Home >> Sum of the Parts >> Importing Data from Excel

Importing Data from Excel

Sometimes you need to populate your database with data from a 3rd party source. As an example, large e-commerce stores that have hundreds or thousands of items need a way for store administrators to add and update large volumes of product data.

Through proper planning and a synchronized process we can build your Website so you can make additions and changes to multiple records in your Website's database by uploading EXCEL or CSV files in the administrative section of your Website.

How It Works
1. We work with you to build a standard EXCEL or CSV file with the required fields.

2. We add a feature to the administrative section of your Website where you can upload these files.

3. You build the Excel file with all the records you need to add or change.

4. You then go to your administrative section of your Website and upload the file. The programming will analyze each row in the file using a unique identifier, such as a Product ID, to check for matches in the database. If the Product ID is already found to exist in the database then the item is updated. If it is not found then the item is added.

Things to Keep in Mind
The EXCEL or CSV files used must have standard column headers and they cannot be changed. Once the master file is created it is the prototype for all of the uploads you will do.

Care must be taken when adding data to these files. If data is put in to the wrong columns or fields are left blank then the entire upload will need to be erased. We tag all of your uploads so the data goes in to the database in sets. That way if an upload needs to be removed we know exactly what records were added as part of that upload.

Pertaining to the above, we can also automate the process of removing an upload by providing a feature that will let you review your uploads and remove any or all records.

Home     About Us     Experience     Technologies     Sum of the Parts     Beyond the Code     Clients     Contact Us     Sitemap

© 1997 - 2020 TConsult Web Dev Inc.