Database / Mapping / Strong References Required / Specific to description

In Progress

Description

Sno Module Title Description

1 CSV export(Distrubution master)

Read CSV file 1. Upload form the file

2. Validations for the form

3. Check for CSV file(which will not allow all other files apart from CSV)

4. Read the file and get the contents of all fields along with header

Mapping 1. Get the database field names

2. Get the CSV header names

3. Screen to map the database fields and CSV haders

4. Null validation for mapping(which will not miss the match fileds)

5. If CSV headers and database fields are same then no need to ask for mapping

Save the format After mapping save the template with headers and the file with headers will be downloaded as csv file

Insert the data 1. After mapping generate sql query

2. check for the options in the upload form

3. If empty, delete all the records in the table and insert new records in the tabel

4. If append, insert the records read from CSV by adding new rows after the existing data

Skills: MySQL, PHP, Software Architecture, Software Testing, Website Testing

See more: file validation, data mapping, map csv fields, sql query format, mysql append data, mysql append, title description, mysql export table sql, format references, php save form data table, php module need match, mysql empty database, mysql database query form, data validation export database, existing form fields data database, export mysql table csv, mysql export database, save screen sql table, form query data export, mysql export table, csv validation mysql, mapping field, sql query field, mysql match append, csv mysql map fields

Project ID: #5077626

3 freelancers are bidding on average $129 for this job

aboobakr

Hi, I have done many projects like to read the csv and comparing and validate the filename etc. Please see the below link to verify. http://nahas.imarasoft.info/Naaz/READ_CSV Upload any CSV file. You can see th More

$166 USD in 4 days
(5 Reviews)
3.3
krgourav007

Can you please confirm whether you want window base application or web based I have ~5years of experience in .NET/DB/PHP and with multiple versions. I can create the same for you with in one day regards\ Kumar G More

$100 USD in 0 days
(0 Reviews)
0.0
happytohelpyou89

hi, I worked for third party(worlds one of the top 10 ranked IT company),but very new int his freelancer,i am able to understand your project needs.but i have some queries,regarding file,these are follows. 1. If th More

$122 USD in 3 days
(0 Reviews)
0.0