Python 3 script to synchronize file revisions between Postgres DB and FTP Folder
$250-750 USD
Betalades vid leverans
I need a python 3 script that does the following:
1) Reads a list of part numbers currently in a Postgres DB
2) Determines if there is a file in the DB for the part number and if so, which revision based on the name of the file. The file naming convention is PARTNAME_REVISION [login to view URL] or .pdf
3) Compares the part list from the DB to a list of files in an FTP folder
4) IF: the part is in Postgres but no file and there is a file in the FTP folder, covert the FTP file to PDF if needed and upload the file to the DB with the proper table links. IF: The file in Postgres is an older revision than the file in the FTP folder, convert the file to PDF if needed, remove the old revision from the Postgres DB and upload the new file with the proper table links. ELSE: The files are the same, do nothing.
Fine details:
- To convert files to PDF and optimize size, you can use this command:
command = "ps2pdf -dPDFSETTINGS=/ebook " + SOURCEFILE + " " + DESTINATIONFILE
[login to view URL](command)
- I will set you up with sandbox access to the db
Projekt-id: #12629936
About the project
Tilldelades:
Seen the details, don't expect having any problems completing. Again you can expect a documented script with reasonable outputs. The only question I have, is why you are storing the files on the DB? Have you conside Mer
14 frilansare har lagt bud på i genomsnitt $345 för det här jobbet
Hello, I'd be glad to develop the synchronization script for you using python 3. Looking forward to chat with you for more details. Best regards,
Hello How are you today? I read your project description and understand it well. I have good experience with python Message me for detail discussion.
Python 3 script to synchronize file revisions between Postgres DB and FTP Folder Linux, PostgreSQL, Python 7 years experience
With pleasure I will get down to business right away. An interesting job, with quite understandable requirements. Sincerely, Damir