I gang

python import from excel (CSV) to mysql

before you read :

this project looks like a piece of cake. BUT if you are not an experienced programmer don't apply as code will have to be pep 8 and in good quality

i need a python function that gets a CSV file and a configuration file

the program will add or change data in DB

the configuration file will have the following sections

1) target_db

2) type: insert only / check and update

3) fields -source, target (list of fields-not all)

4) key fields in CSV (that are in DB) so we know if a record exists or update

4) if update any field put the old record in the "updated" file

5) if inserted: put any record in the "inserted" file

6) if an error is put in the "errors" file

============================================================

notes:

field names are not english may have ",", "'" and "," use encode (try encoding='windows-1255')

target fields name are English

make sure you have all the fields in CSV columns so we know if it is the right CSV

attache are 1 configuration 1 DB structure and 1 excel demo, upon success, you will be given a more complicated CSV

Evner: Python, Excel, Databehandling, MySQL

Se mere: import remote csv mysql, import excel file mysql using vbnet, import biggest csv mysql, import freeware csv mysql, import excel file mysql database php, import excel files mysql php, import number csv mysql, import excel file mysql export using php, import excel file mysql using java, asp net import excel csv, import excel file mysql php, php import excel file mysql smarty, php tutorial import excel file mysql, import excel csv jsp, import crm csv mysql, classic asp import excel csv, import excel csv file macro access, import excel csv file to mysql database using php

Om arbejdsgiveren:
( 73 bedømmelser ) HAIFA, Israel

Projekt ID: #31892067

Tildelt til:

borutflis

Hello, I know how to do your job, I actually once wrote an article about such a task: [login to view URL] What DB engine are you using? Don't hes Flere

$150 USD in 7 dage
(26 bedømmelser)
5.5

45 freelancere byder i gennemsnit $167 timen for dette job

(533 bedømmelser)
8.5
(266 bedømmelser)
7.3
saubhagyamweb

+++++++++++++++++++++++++++++++++++ Hello Jony, Hope you are doing well I have checked about your requirements and my skills are a match. I have relevant 5+ years of expertise in Python, Data Analysis, object detec Flere

$200 USD in 7 dage
(38 bedømmelser)
6.7
purplemaestro

Hi. Hope you are doing well. I have high level expertise in Python. I have read the project requirements carefully and can create a Python script with all those 6 points covered. Will provide you top quality work for s Flere

$180 USD in 2 dage
(90 bedømmelser)
6.2
(54 bedømmelser)
6.1
(85 bedømmelser)
5.8
vladilavsuhovoy1

Hey! I am skilled Python developer. I am familiar with Python and I have a lot of work experiences in Python, Data Processing, MySQL and Excel. I can start right away. I want to discuss for this project in detail. Pl Flere

$250 USD in 5 dage
(11 bedømmelser)
5.4
(73 bedømmelser)
5.5
harunnizam

Hi. How are you? As a senior web developer, I can make python script for updating csv data into mysql DB. I can start right now. I hope we can discuss more details via chat. Thanks.

$90 USD in 2 dage
(11 bedømmelser)
5.5
vovakovalkov80

Hi I have worked on several similar projects and can deliver quality work on tight deadlines. I'm interested to hear more about the project. If you award me the project I'd be very happy to discuss this further and get Flere

$200 USD in 7 dage
(7 bedømmelser)
4.8
hayteekeys

Hello, i can create python function that gets a CSV file and a configuration file perfectly I have rich exp in ACM/ICPC and deep understandings of algorithms for Classifications, NLP, Neural Networks,e.t.c I attended Flere

$50 USD på 1 dag
(29 bedømmelser)
5.4
(17 bedømmelser)
4.7
hsh564cf84accd96

We will do your python work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in pr Flere

$200 USD in 7 dage
(21 bedømmelser)
4.6
gdbus628

Hello, How are you? Thanks for your job posting. I will provide the high quality code based on PEP8. Let's discuss in more detail about the job. Regards.

$200 USD in 7 dage
(2 bedømmelser)
4.0
eng400

Hi,i'm a data scientist with a BS degree in computer science i will do your task as fast as i can and i will achieve it exactly as you want,don't worry about any thing contact me for discussion

$100 USD in 7 dage
(16 bedømmelser)
3.9
freelancerIrvan

Hi there, I am a talented python dev, and I suppose I can handle this task successfully. Please let me know more details, and Please give me your chance. I look forward to hearing from you. Flere

$139 USD in 7 dage
(3 bedømmelser)
3.9
(4 bedømmelser)
3.7
nenadudovicic111

Hello? I have read your description. I can provide the great result that you are asking for as I have rich experience in python with excel and mysql. Could you please open your chat box for me? Let's get a great re Flere

$155 USD in 3 dage
(5 bedømmelser)
3.2
IvanLomakin

Hello. I am a python expert. I have read your requirements. This project is PIECE OF CAKE for me. I have already developed similar project but used sqlite for database. I will build interface for your project. I want t Flere

$150 USD in 7 dage
(5 bedømmelser)
3.2
kirillvaginfree

Hello I have gone through your job description. I am a skilled and experienced in web and mobile development for over 8 years. Also very familiar with the database structure and queries. I am proficient with python sc Flere

$200 USD in 7 dage
(4 bedømmelser)
3.1