Python 3 script to synchronize file revisions between Postgres DB and FTP Folder

Slutfört Publicerat 6 år sedan Betalades vid leverans
Slutfört 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

Linux PostgreSQL Python

Projekt-id: #12629936

About the project

14 offerter Distansprojekt Aktivt 6 år sedan

Tilldelades:

ioannislato

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

$311 USD inom 7 dagar
(10 omdömen)
4.0

14 frilansare har lagt bud på i genomsnitt $345 för det här jobbet

lkhelladi

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,

$250 USD inom 2 dagar
(153 omdömen)
7.2
gangabass

I can create Python 3 script that will work exactly like you want: it read list of part numbers from Postgres, check files in database and compares database list with FTP folder. I can complete it in less than two d Mer

$250 USD inom 2 dagar
(240 omdömen)
7.0
ZealousWang

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.

$500 USD inom 10 dagar
(24 omdömen)
6.7
tangramua

Good day! I can write python scripts as you need. In area of web development our main specialization is LAMP stack of technologies (Linux, Apache, MySQL, PHP) but I have experience with Python, javascript, Node.js Mer

$300 USD inom 10 dagar
(59 omdömen)
6.8
awxmem

Hello, I have 8+ years of programming experience in Python along with an extensive coverage of Postgresql db. I am sure that I can write a Python 3.6 script to synchronize the corresponding pdf file revision in Pos Mer

$380 USD inom 3 dagar
(30 omdömen)
6.1
novepi

Hi there, Your requirement is quite clear and straightforward to implement so no questions. All I need is access to db. I can start as soon as you award the project and will be done within 24 hours at most. Thank Mer

$250 USD inom 1 dag
(17 omdömen)
4.8
riyazaec

Hi I am having very good experience with Python and PostgresSQL. I understood your requirement completely. I will provide good solution for your requirement. My budget will be between 70 to 100 USD . Please PM me if yo Mer

$250 USD inom 1 dag
(5 omdömen)
3.6
topithub

Python 3 script to synchronize file revisions between Postgres DB and FTP Folder Linux, PostgreSQL, Python 7 years experience

$500 USD inom 10 dagar
(1 omdöme)
0.8
damirqa

With pleasure I will get down to business right away. An interesting job, with quite understandable requirements. Sincerely, Damir

$355 USD inom 5 dagar
(0 omdömen)
0.0
rajivsingh1986

A proposal has not yet been provided

$277 USD inom 1 dag
(0 omdömen)
1.7