All Web Applications In One Streamlined Environment 
Customer Service  |  Site Map
Home
Products
Download
Store
Support
Partners

Browse Topics In
Knowledge Base


General Issue

Photo Gallery

Newsletter

FAQ Support

Customer Helpdesk

Link Manager

Geo Traffic

CSV Data Tool

eCommerce

Web Blogger

Events Calendar

Vote Caster

News & Announcement

Guestbook

Contact Form


Search for Answers
Intelligent FAQ Search. Type in your keywords to search for the answers you need.


Customer Helpdesk
Can't find the answers you need? Go to our Technical Support Helpdesk





Back CSV Data Tool > Tutorials Showing 5 of 5 Prev


How do I update records of a table using the CSV Import?
Modified on 2004-12-21


To update the records of a table in your database, it is required that the table has a primary key column (the column containing unique id that identifies each record in the table).

  1. Prepare all the records you would like to update in a CSV file.

    Note: Please make sure the data for primary key column in your CSV file matches those unique ids in the original table.

  2. Login to your One Admin console, click on the CSV Import link, and complete the step 1 (Load CSV) and step 2 (Connect Database).

  3. When you're in the third step 'Match Column', scroll down to the bottom of the page, and check 'Update records using Primary Key' option.

  4. Select the primary key field of your existing table from the first drop down list. Then choose which column in your CSV file that matches the primary key field, from the drop down menu next to 'with Column'.

  5. Click 'Next' to complete the data import.



Is this FAQ helpful? Ratings :
Printer Friendly Version
Tell A Friend


Related FAQs In This Category
Export a MySQL database to CSV file.
How do I translate the language file for my CSV Data Tool?




Quick Links
Support Helpdesk
Knowledge Base
Product Activation
Installation Support


More Information
Purchase & Delivery
Pricing Information
Payment Methods
Refund Policy
License Agreement
Privacy Policy

Copyright © 2004 by Comdev Software Sdn Bhd. All Rights Reserved. License Agreement Privacy Policy