trouble with import

Hubertus

I should update a BO with data coming from a M$SQL using a csv file.
The updates seem to work fine, but no records are added. I emptied the table in MySQL and tried again but every non existing ID produces

Business object with ID 4not found in row 1 and column 1. Ignoring data for the object

The Import happens from a rule with

IMPORT Kunde FROM SystemSettings.ImportDateiKunden IN BATCHES OF 10

The csv file contains about 2000 records starting with

"Kunde.ID","Kunde.MatchCode","Kunde.Firma","Kunde.FirmaZusatz","Kunde.Anschrift","Kunde.PLZ","Kunde.Ort","Kunde.Land","Kunde.Bemerkung"

4,"Wollinger LA","Wollinger Graz",,,"8010","Graz","AT","LP100 1:1 !!!!"

I'm using build 882

Any idea on what's going wrong here ?

Thanks a lot
Hubertus

Hubertus

ok I found in another thread that I can't use the ID for updating .
So I added a field KHKID in my BO and changed the header to start with

"Kunde.KHKID"

which worked fine.

But using

"*Kunde.KHKID"

correctly updates the records but doesn't add new ones.
Is this a bug or a feature ?
In case this is a feature could you please tell me how I can update AND create records ?

Hubertus

another question:
would there be any side effects if I update the database directly ?

aware_support

You cannot create and update records from the same CSV file. You need to split it in two files - one for creating records and one for updating records.

The "*" notation is used to identify a primary key of the record to be updated in situations when the native Aware IM primary key attribute (ID) is not known. Therefore this notation should only be used to update records.

Yes, you can update the database directly if you know what you are doing and if you do not want to execute rules - therefore, since you are bypassing rules, you have to make sure that the data you modify stays consistent.