Completed

Script or procedure for data import from csv to MySQL

Current status:

Two tables available in MySQL:

- FA_Kopf

- FA_Vorgang

Every day, two csv files are uploaded to the file server:

- [login to view URL] (contains approx. 8.000 rows, 25 fields in each row)

- [login to view URL] (contains approx. 200.000 records, 51 fields in each row)

Topic:

Prepare a MySQL stored procedure (or executable program) which perform the following steps:

1. Extracts all rows from file [login to view URL] for which the column Disponent. value is not ULK or ULB or ULG.

2. Update FA_Kopf table based on [login to view URL]:

a. if record is available (index field: Auftrag): check all data matching:

i. if not match, update data from [login to view URL]

ii. if match, leave as it is

b. if record is not available: create new record from [login to view URL] to FA_Kopf table

3. Extracts all rows from file [login to view URL] for which:

a. the column Rückmeldenr. value is not 0 or not empty

b. column Auftrag value is available in FA_Kopf table

4. Update FA_Vorgang table based on [login to view URL]:

a. if record is available (index field: Auftrag+Vorgang): check all data matching:

i. if not match, update data from [login to view URL]

ii. if match, leave as it is

b. if record is not available: create new record from [login to view URL] to FA_Vorgang table

Others:

1. The procedure/program should have the following inputs:

a. [login to view URL] file name

b. [login to view URL] path

c. [login to view URL] fila name

d. [login to view URL] path

2. If data is not valid (eg. data type in csv doesn’t mathc with data type in MySQL), skip the row and don’t stop the procedure/program with error message.

Skills: MySQL, Javascript, C++ Programming

See more: file import csv mysql php, import csv mysql web interface, script import csv mysql, perl script import csv mysql linux, import csv mysql script perl, import csv mysql db script perl php, php script import csv mysql field mapping, script import csv mysql import csv script, import csv mysql php script prestashop, python script import csv mysql

About the Employer:
( 11 reviews ) Budapest, Hungary

Project ID: #21037742

Awarded to:

swiftinitdotcom

I have done similar projects like this before. I am the best candidate to do this project. I have fully ready cloud based secure platform for your needs. Recently built a web portal for a European client. It went live More

$200 USD in 7 days
(0 Reviews)
0.0

31 freelancers are bidding on average $145 for this job

lkhelladi

Hello, I'd be glad to develop a scrit using python that will run automatically to import data from CSV files into MySQL tables, following your specified algorithm. Looking forward to hearing from you soon. Best rega More

$140 USD in 2 days
(82 Reviews)
6.9
fattahaabdul

I can import data from csv to sql. I have 8+ years of experience in JavaScript and mysql. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.

$250 USD in 7 days
(61 Reviews)
7.5
shihan033010

Hi I am interested in your project requirements. I can compete the functionality that you need. Please accept the bid and create the milestone.

$100 USD in 3 days
(270 Reviews)
6.7
crtvecode

Hello, I can write a PHP script for this and update the data in [login to view URL] and [login to view URL] as per the logic explained on the requirement. I am an experienced Web developer, Please check my client's recent comment a More

$139 USD in 3 days
(59 Reviews)
6.4
nisharapath

Hello. I read your project fully and it is possible for me. As you can see my profile, I have rich experiences in MySQL and web. If you hire me, I will do my best and you will see successfully result. Please contact me More

$100 USD in 3 days
(32 Reviews)
5.9
dungforever

Hello mate I am very glad to place a bid to your project and i can finish your project in 12 hours Data import from csv to MySQL is very interesting job for me and i am confident. I have read your description carefully More

$70 USD in 1 day
(63 Reviews)
5.6
dimkazakos

Hi! I have done a lot of projects like yours. Check my profile. I need one day to complete the project and one day to fix buges if any. You will receive a php file that does the whole work after uploading your files to More

$250 USD in 2 days
(31 Reviews)
4.7
SmithZhang

Hello I am a senior website developer and I have plenty of experience in web development. I have plenty of Knowledge about PHP , HTML, CSS , Javascript, Python, Nodejs, React.js. I have experience developed the app to More

$140 USD in 7 days
(16 Reviews)
4.4
reedsystems

Hi, how are you today? I read your project description and I can provide you with a script (php or asp.net) that can be run manually or scheduled to run automatically and perform the data import.

$200 USD in 7 days
(7 Reviews)
4.5
fivestar10

Hi! I am very happy to see your project detail. I think it is just my project. :) As you can see in my profile, (my review: https://www.freelancer.com/u/fivestar10?w=f) I have much experience with your job. please cont More

$140 USD in 7 days
(10 Reviews)
4.5
Proolancer

I m a database administrator with 8 years of experience in this industry. I read your project details and attached files and I understood your needs ,I can do what you want in the deadline just contact me and we can di More

$200 USD in 7 days
(10 Reviews)
4.5
freelancerdanie9

:)Best Effort for You I have 10 years experience for web & app development. I 'm very interest of your task because of i'm expert app developer and have good skill and enough experience to carry out your task very well More

$140 USD in 7 days
(8 Reviews)
4.1
greenguru2018

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is More

$140 USD in 7 days
(12 Reviews)
4.0
baxianupam

Michael Leboeuf said, “A satisfied customer is the best business strategy of all”. We very well follow it. Our main goal is to provide you 100% service and extra 50% one. Our specialist is focus on web design & front More

$90 USD in 3 days
(3 Reviews)
3.9
naishodayo

Hi,dear. I am a senior software developer. I have just checked your project description, I am able to complete this project. I am looking forward to your response. Thanks.

$150 USD in 3 days
(4 Reviews)
3.8
$50 USD in 3 days
(8 Reviews)
3.5
Panda393

Hello I am senior developer with rich experience. I read your project description carefully. If you choose me, I'll provide satisfied result you want in a day. Thank you

$80 USD in 7 days
(4 Reviews)
3.2
AsadAli987

Hi, I am currently working as Machine Learning Engineer at VisionX. I have more than 3 years of experience in Python Scripting. I have already done similar project, where I had to match and update the SQL tables using More

$88 USD in 3 days
(5 Reviews)
2.8
uzairnaseer920

JUST DO YOUR WORK IN CHEAP RATE. WILL DO LESS THAN BID I hold a degree in Computer Engineering. I minored in Programming with a focus in following skills: Java programming with GUI (JAVA, JAVAFX) Python Programming ( P More

$140 USD in 7 days
(5 Reviews)
3.0
hungrygks

Hi there!!, About Me : Quick solution provider with 8 year experience in web design and development. Task : Script for data import from csv to MySQL database Note : I can start to work right now and Just Private mes More

$120 USD in 7 days
(3 Reviews)
2.1