Käynnissä

python soecial excel to mysql insert /upodate

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

attached test_files

the solution is a well documented program and configuration files, as i may want to use another file for test.

please note: there may be errors while reading, or unreadable fields

this is not a 3 lines job !

use pymysql

Taidot: Python, Tietojärjestelmäarkkitehtuuri, MySQL, Tietojenkäsittely, Excel

Näytä lisää: php insert excel mysql, reading excel file insert mysql, read data excel file insert mysql using aspnet, excel mysql insert, excel macros insert data mysql database, insert excel mysql using jsp, excel mysql python, i have 12 scanned images and each one has 30 rows and 15 column i need you will type the data from images to excel, i have 36 statements that i need entered into excel the maximum number of entries per statement is 86 rows and two columns one c, i have an existing php/mysql script that i need customized with additional functions, i need someone to do some data entry, I have a Excel with different rows. I need the information to be put in column (City, Name, Phone ect, i need a major life change, i need a serious life change, what size electric fireplace insert do i need, do i need an electrician to change a light fixture, excel vba insert picture from directory on cell value change, i need a hacker to change my grades

Tietoa työnantajasta:
( 68 arvostelua ) HAIFA, Israel

Projektin tunnus: #31824526

Myönnetty käyttäjälle:

jaberlama

Hello , i will not say that i'm the best pogrammer ever (Like other proposals ) but rather that i'm a honest and hardwoking person , you will have your job done quickly and in a cleaner way ( with full transparency and Lisää

$60 USD 7 päivässä
(2 Arvostelua)
2.5

8 freelanceria on tarjonnut keskimäärin $124 tähän työhön

ginushaji3

I am python expert having over 4 years of experience. Contact me for further deliberations........................... Regards Ginu

$200 USD 7 päivässä
(20 arvostelua)
4.3
MaksimUshkalov

Dear Client I have 5+ years experiences in web development with Python and Django. I've created beautiful applications for various projects. I've been working with small and big teams, with different management approac Lisää

$30 USD 7 päivässä
(18 arvostelua)
4.4
novikovyaroslavd

Hi there Python King here If you hire me you can save your time and money I've done many python jobs before kindly ping me I'm quite sure about this project Thanks

$50 USD 7 päivässä
(10 arvostelua)
3.6
artocenter

Hi. I am a skilled engineer with 8+ years experience in Software Architecture, MySQL, Data Processing, Excel and Python. A skilled programmer, able to learn and adapt quickly to new technologies. I've read the job desc Lisää

$100 USD 2 päivässä
(4 arvostelua)
4.0
rubnawazquraishi

Hi, I have read your functional requirements. I can get done in 1 day. I am python most experienced in this platform

$100 USD 1 päivässä
(9 arvostelua)
2.6
serviceguptacon9

Hello, Hope you doing well, I am interested in your project, I can complete this project on time and give you 100% result. Let's take it further and start your project as soon as possible connect me in chat anytime, Lo Lisää

$250 USD 7 päivässä
(1 arvostelu)
0.0
dejanmilutinovi1

⭐⭐⭐⭐⭐ Hello Client! I hope you are doing well and safe from COVID-19. I am a self-motivated Front-End developer with both theoretical knowledge and hands-on experience in web development. I can work as not only an inde Lisää

$200 USD 7 päivässä
(0 arvostelua)
0.0