Find Jobs
Hire Freelancers

import txt to mysql with php

$30-250 USD

Completed
Posted about 9 years ago

$30-250 USD

Paid on delivery
Hi, this is a very simple work, and very well detailed. I expect to be done and tested in just one day. I need a page in php to import txt values into mysql database. Need to save as unicode characters and accepts characters like ' that can be part of names. Will give you access to a test mysql database. the columns of txt file are as follow : mapped to each [login to view URL] : KIDNAME : KID.KID_NAME PARENTNAME : CUSTOMER.CUSTOMER_NAME EMAIL : [login to view URL] RM : [login to view URL] CLASSROOM : GROUP.GROUP_NAME KIDNAME, PARENTNAME AND EMAIL ARE MANDATORY FIELDS RM AND CLASSROOOM ARE OPTIONAL THERE ARE NO DUPLICATES KIDNAME A PARENTNAME CAN HAVE ONLY ONE EMAIL ( EMAIL IS UNIQUE ) A PARENTNAME CAN HAVE MORE THAN ONE KID RECORDS WITHOUT MANDATORY FIELS SHOULD BE IGNORED AND LISTED AT THE END OF THE IMPORT ROUTINE. SAME TO RECORDS WITH INVALID EMAIL the user will copy all values, without a first row with column names, and field separated by pipe (|) also will have one input box for each of the following fields mycustomer.id_company ( integer type ) [login to view URL] [login to view URL] ( varchar type ) [login to view URL] ( smallinteger type ) below are the tables that need to be filled customer (PK)id_customer ( auto number ) customer_name ( input by user ) password ( default value for all records, input by user ) (UK)email ( input by user, used a unique key ) date_created mycustomer (PK)id_mycustomer ( auto number ) (FK)id_customer ( from table customer ) (FK)id_company ( typed by user ) date_created kid (PK)id_kid ( auto number ) kid_name ( input by user ) RM ( varchar 20 ) itinerary (PK)id_itinerary ( auto number ) itineraryname ( default value for all records, input by user ) (FK)id_company ( default value for all records, input by user ) customer_id ( from table customer.id_customer ) selectKidsonMainPag ( default value : 0 ) auto ( null ) autotime ( null ) itinerary_kid (FK)id_itinerary ( from table itinerary ) (FK)id_kid ( from table kid ) mykid (PK)id_mykid ( autonumber ) (FK)id_company ( default value for all records, input by user ) (FK)id_customer ( from table customer ) (FK)id_kid ( from table kid ) (FK)id_itinerary ( from table itinerary ) group (PK)id_group ( auto number ) (FK)id_company ( default value for all records, input by user ) group_name ( input by user ) year ( input by user ) group_kid (FK)id_group ( from table group ) (FK)id_kid ( from table kid ) Here is a suggested logic to import the values 0 - delete all records of that company : I will send you the sql´s to delete the records. for each row do the following steps : 1 - Create records of table group : Based on year, id_company and group_name check if record exists, if not, create it. Return id_group 2 - Create records of customer ( parent ) : Based on email check if record exists, if not create, if yes, update its name and password ( md5 ). Return id_customer 3 - create itinerary Based on id_customer and id_company check if record exists, if not create. Return id_itinerary 4 - Create mycustomer based on id_customer and id_company check if exists, if not, creates. ( use values returned from previous steps ) 5 - Create kid always insert kids. Return id_kid 6 - create itinerary_kid always insert ( use values returned from previous steps ) 7 - Create mykid : always insert mykid ( use values returned from previous steps ) 8 - Create group_kid always insert group_kid ( use values returned from previous steps ) Attached is a sample file.
Project ID: 7065849

About the project

12 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear sir, I am interested in your project. I have read your project description carefully, also the .txt file. With 7 years experience about PHP, MySql, I can give you solution with perfect accurate. Thank you for your attention, thanhhungqb
$70 USD in 1 day
5.0 (26 reviews)
4.2
4.2
12 freelancers are bidding on average $131 USD for this job
User Avatar
Let me do it quickly .....................................................................................................................
$105 USD in 1 day
4.8 (364 reviews)
7.9
7.9
User Avatar
A proposal has not yet been provided
$210 USD in 3 days
4.9 (291 reviews)
7.6
7.6
User Avatar
Hi, I'm senior web developer and I'm very interested in your project. Hope I will have a chance to work for you on this project. Please contact me. Thanks
$150 USD in 2 days
4.9 (219 reviews)
7.4
7.4
User Avatar
Hi ready to start. Thanks ............................................................................
$100 USD in 3 days
5.0 (411 reviews)
7.4
7.4
User Avatar
Hi How are you? Thanks for Invited me. I know very well php,mysql. Understand very well 8 tasks you listed in Description. Ready to start now.
$210 USD in 3 days
4.6 (147 reviews)
7.0
7.0
User Avatar
hello hope you are doing well I am interested to work on this project. Gladly waiting to serve you sir
$100 USD in 1 day
4.9 (278 reviews)
6.8
6.8
User Avatar
Hi, I make you this PHP page where you can upload txt file and it will parse the file and insert values into correct tables. The page should check for duplicate names and other rules ( based on your requirements). I really hope we can work. thank you
$167 USD in 2 days
4.8 (170 reviews)
7.0
7.0
User Avatar
Még nem kapott javaslatot
$77 USD in 1 day
5.0 (34 reviews)
4.9
4.9
User Avatar
A proposal has not yet been provided
$200 USD in 5 days
4.5 (23 reviews)
5.2
5.2
User Avatar
Hi Dear, I am having 7+ yrs of exp in PHP/MYSQL. I have viewed the txt file you have shared. I can implement the project for you as per your requirement.
$61 USD in 3 days
5.0 (2 reviews)
2.8
2.8

About the client

Flag of BRAZIL
São Paulo, Brazil
5.0
40
Payment method verified
Member since Jan 7, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.