Lukket

Population of csv files into mysql, running mysql scripts

We need a python script to upload csv files into a mysql database, move the processed csv files into a processed folder, and using mysql scripts to clean up the data.

We receive multiple email files daily with 3 csv file attachments per email.

1. *counters*.csv, Devices counters file

2. *cartridges*.csv, Cartridge counters file

3. *alarms*.csv, Alarms reports file.

These attachments are saved to our linux server folder during the day.

We need to:

1.

Some of the csv file names have spaces. They must be removed and replaced with a underscore “_”

2.

On all csv files the name of the csv filename must be added to LAST Column of the csv file with the header of FILE_ID

3.

Upload the csv files into a 3 mysql tables with the same column names as the csv header row.

4.

Processed csv files must be moved into a processed folder with the suffix “[url removed, login to view]”

5.

We need to create a list of printers with their serial number as the primary key (Table “PRINTER_DETAILS”). Table structure as below. The field ID, from table counters, must have the date, defaults and the counters parts removed. This is the field SITE_ID. The last column “TYPE” has to values “N” (default) and “L”. There can only be one entry for a printer.

6.

Based on the table “PRINTER_DETAILS” the counters and the date scanned must be populated into table PRINTER_COUNTERS. There is no primary key as there could duplicate entries.

The purpose of this is too step by step make sure that each printer has a

1. Site_id

2. Their counters recorded. The csv files have a lot of duplicated entries. We need one sett of counter per device.

This python script will be run as a cron job at midnight. NB this is a linux (centos) environment.

I have included a selection of files. I have included the database script to create Databases.

This is part of a larger system that will be part of our billing and reporting system. We need clean data first.

All files can be downloaded from this link.

[url removed, login to view]

Færdigheder: Linux, MySQL, Python

Se mere: script population mysql, using python freelancer, type data structure, reports freelancer, reporting freelancer, python script freelancer, python freelancer job, purpose freelancer, need data structure, mysql job freelancer, linux centos freelancer, key selection, key data structure, job values, freelancer zip file, freelancer spaces, freelancer reporting, freelancer python job, freelancer folder, freelancer files, freelancer dropbox, freelancer databases, freelancer attachments, dl freelancer, default freelancer

Om arbejdsgiveren:
( 0 bedømmelser ) Johannesburg, South Africa

Projekt-ID: #947516

18 freelancere byder i gennemsnit $150 for dette job

dtqsoftware

Freelancer from Costa Rica with MySQL and Linux programming experience. I'll be glad to do this job. See PM for details.

$125 USD in 4 dage
(21 bedømmelser)
5.6
smartgest

I can do that in the best professional mode. Please check PM.

$100 USD på 1 dag
(12 bedømmelser)
5.0
deadhunt

Please check PMB

$200 USD in 6 dage
(14 bedømmelser)
4.6
YashpalSingh123

php/mysql experienced

$250 USD in 3 dage
(5 bedømmelser)
4.3
MuseiKaze

I will be able to complete this for you within 2-3 days.

$150 USD in 2 dage
(6 bedømmelser)
4.1
srikantasr

Hi, Please check your PM.

$150 USD in 3 dage
(2 bedømmelser)
2.6
raus81

Hi, I'm a python programmer in Italy.

$50 USD in 2 dage
(0 bedømmelser)
0.0
mroodles

I will build your python script in a few hours. I will also leave one day for testing/modifications/implementation.

$250 USD in 2 dage
(0 bedømmelser)
0.0
e44x77

Hello I can do it for you.

$300 USD in 10 dage
(0 bedømmelser)
0.0
lordwud

I looked through your files, and I should be able to finish it in a few hours. However I bid 5 days for testing, or modifications.

$200 USD in 5 dage
(0 bedømmelser)
0.0
fabianopires

Please check PM.

$150 USD in 5 dage
(0 bedømmelser)
0.0
selvaman

I can complete the task successfully

$50 USD in 5 dage
(1 bedømmelse)
0.0
vinayaktelecom

I am Python developer and contributor.Please check PM too.

$139 USD in 2 dage
(0 bedømmelser)
0.0
koden

I love python, and this project interest me very, please see my PM.

$30 USD in 0 dage
(0 bedømmelser)
0.0
SeyZ

Hello, I already do this kind of job on getacoder ( http://www.getacoder.com/projects/view_Python_To_MySQL_Data_Transfer_138208.html ). In addition, I am a Python Developer for a company in Belgium. I will be ha Mere

$45 USD in 7 dage
(0 bedømmelser)
0.0
AntonyK

Hello, sir! The algorithm is absolutely clear and work will becomes just a pleasure. All you'll been need is be online, because some subtleties are clarified directly during the development process. Truly yours, Mere

$189 USD in 3 dage
(0 bedømmelser)
0.0
astmas

Hello! My skill can help you,

$160 USD in 5 dage
(0 bedømmelser)
0.0
shrugged11

I can help you with this.

$199 USD in 3 dage
(0 bedømmelser)
0.0
san0774

I gone thru ur zip file and interested to work with it as i have experience in backend scripts, i can complete the work in couple of days but to be on safe i told 5 days.

$170 USD in 5 dage
(0 bedømmelser)
0.0