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

完了済み 投稿 6年前 着払い

$250-750 USD

着払い

完了済み 着払い

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

プロジェクトID: #12629936

プロジェクトについて

13個の提案 リモートプロジェクト アクティブ 6年前

お金を稼ぎたいと思っていますか？

Freelancerで入札する利点

予算と期限を設定してください
仕事の報酬を受け取りましょう
提案のアウトラインを作成してください
登録して仕事に入札するのは無料です

アワード：

ioannislatoのプロフィール写真
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 もっと

$311 USD 7日以内
(10レビュー)
4.0

13人のフリーランサーが、平均$344 で、この仕事に入札しています。

gangabassのプロフィール写真
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 もっと

$250 USD 2日以内
(451件のレビュー)
7.9
lkhelladiのプロフィール写真
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 2日以内
(197件のレビュー)
8.0
ZealousWangのプロフィール写真
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 10日以内
(24件のレビュー)
6.7
tangramuaのプロフィール写真
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 もっと

$300 USD 10日以内
(120件のレビュー)
7.7
awxmemのプロフィール写真
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 もっと

$380 USD 3日以内
(32件のレビュー)
6.1
novepiのプロフィール写真
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 もっと

$250 USD 1日以内
(20件のレビュー)
5.0
riyazaecのプロフィール写真
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 もっと

$250 USD 1日以内
(6件のレビュー)
3.7
topithubのプロフィール写真
topithub

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

$500 USD 10日以内
(レビュー1件)
2.3
rajivsingh1986のプロフィール写真
rajivsingh1986

A proposal has not yet been provided

$277 USD 1日以内
(0件のレビュー)
1.7
このようなプロジェクトを投稿する