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:

Code: Select all

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