Export and Import

jacklcs

Good day eveyone..

I managed to Export the Customer Database.

EXPORT Customer TO 'C:/export/CustomerForUpdate.csv' FOR UPDATE
IMPORT Customer FROM 'C:/export/CustomerForUpdate.csv'
Those information I changed the CustomerForUpdate.CSV File is update the Customer List. That cool..

I found this on the User Guide:

4. CREATE IF NOT FOUND
If this keyword is specified the import file can be used both to update existing records and create new ones. If a record referred to in the file is not found Aware IM will create a new record.

Assume I added 2 New Customers Row inside the CusotmerForUpdate.CSV which do not have the CusotmerID

Then I wrote a process: IMPORT Customer FROM 'C:/export/CustomerForUpdate.csv' CREATE IF NOT FOUND

But it only update the existing record change and without import the 2 New Record at all.

Please help..

jacklcs

Hi.. anyone done this before?

Timo

I have used the following succesfully:

If FILE_EXISTS('c:\import\CUSTOMER.csv')='Yes' Then 
IMPORT customer FROM 'c:\import\CUSTOMER.csv' CREATE IF NOT FOUND

Gabbitas

Hi jacklcs,

Did you ever manage to resolve this one?

I'm having the same issue: It updates all records fine but does not create any new records I may have added to the CSV.

Thanks