Find Jobs
Hire Freelancers

Create a Python program to download a 60 mb csv file and insert it into a Postgres database

$30-250 USD

已完成
已发布将近 11 年前

$30-250 USD

货到付款
I need someone to create a cron job, which downloads the csv file (.gz file actually) found here [login to view URL] and inserts it into a postgresql database. After that an email needs to be sent from our linux server, with a report of how many rows were inserted and how many rows failed. 0 rows should fail. Please utilize the appropriate column types (not all varchar). Please do not include the following columns: AddressOfficialAddressLineText AddressPostalValidFromDate AddressPostalMunicipalityCode AddressPostalStreetCode AddressPostalStreetBuildingIdentifier AddressPostalStreetName AddressPostalFloorIdentifier AddressPostalSuiteIdentifier AddressPostalDistrictSubdivisionIdentifier AddressPostalPostOfficeBoxIdentifier AddressPostalPostCodeIdentifier AddressPostalDistrictName AddressPostalStreetBuildingIdentifierTo AddressPostalRegionCode AddressPostalAddressLineText And any columns, which names ends with "ValidFromDate". Please create a free test database at [login to view URL] with a 10000 row limit for this project. Your solution should "just work". The cron job should run and the db should get deleted and re-created. Please use a temporary secondary table which will replace the "live" table once it has been confirmed that all all rows were successfully inserted, so we do not risk that a failure will leave us with no data.
项目 ID: 4623637

关于此项目

9提案
远程项目
活跃11 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi. I have experience with Python and Postgres. Let start the work
$63 USD 在1天之内
4.9 (79条评论)
7.0
7.0
9威客以平均价$155 USD来参与此工作竞价
用户头像
Hello sir, I have all the necessary skills to make this script for you.
$166 USD 在5天之内
4.9 (9条评论)
4.8
4.8
用户头像
Hi. Please check my pm.
$157 USD 在2天之内
5.0 (9条评论)
4.6
4.6
用户头像
cron, python, csv, un-gzip, mail, postgresql, heroku.. you certainly don't ask for many skills! Luckily, I can do all that. I just need to chat with you and clarify the final bits and we can get started. Please see PM for my references.
$250 USD 在4天之内
5.0 (5条评论)
3.5
3.5
用户头像
yes I can do this
$113 USD 在3天之内
5.0 (2条评论)
3.1
3.1
用户头像
Hej hulagutten2, I'm the author of an script to "magically" determine the type of columns in a CSV file and to automatically generate the corresponding PostgreSQL CREATE statement. So I know a bit about CSV, PostgreSQL and the like :) Can you please provide a direct link to download the CSV file (highlight the link and right-click, then "Copy Link Address" or similar depending on your browser) so that I can check the file itself? Thanks, MacFR
$200 USD 在10天之内
5.0 (1条评论)
1.5
1.5
用户头像
hi i can do this job..
$222 USD 在4天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I can work on this. I have projects in the past that are similar on this. Thanks
$55 USD 在3天之内
0.0 (1条评论)
0.0
0.0
用户头像
I have experience with both python and postgresql. I can do it for you with no problems. Check your PMB.
$170 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

DENMARK的国旗
Copenhagen, Denmark
5.0
165
付款方式已验证
会员自1月 11, 2010起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。