MX CSV Import-Export Forum :: append to table rather than empty then insert

This thread was displayed: 94 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
James Davidson
01-24-2007 18:45:35 GMT +2

ive created a csv upload page which imports the data from a csv into a table. however with each upload it removes all previous records and inserts as new. is it possible to modify the behavour so with each upload it adds ( appends ) the data to the bottom of the table ?

Back | Reply | Quote | Top
Ionut MOICIANU
01-26-2007 17:17:05 GMT +2

Hello,

You have to make sure you don't have any unique columns included in your csv file (like the primary key, which should be set as auto-increment in db table). Then, just set the "Unique key column" option from the last tab in "CSV Import Wizard" interface to 'None'.

Regards,
Ionut

Reply | Quote | Top
MX CSV Import-Export 1.8.6
© Adobe Systems Romania. All rights reserved.