Modify existing data in table when importing from XML

Tiwaz

Hi everyone
I created an XMLPort which imports data from XML to a table in my table.
It only adds new lines in table when importing which is fine until it tries to import an entry from XML which has the same Serial No. (primary key) as an entry in my table when it returns error.
I want to add CONFIRM window and modify existing data.
For example, I have Car Serial No., Model and License Plates fields in my table.
When I import a car with same serial no. but different License plates it returns error since it tries to add new line.
I hope you get what I need
THANKS!

Tiwaz

As I said, It is unique but sometimes, you wish to import data connected with serial no. that already exists in the table but something, ex:. car colour is different so that needs to be updated.
But I figured it out. I set AutoUpdate property of table element to Yes, and it updates fields connected with serial no. that already exists.

Sowkarthika

You can write your code in OnBeforeInsertRecord function in XML port to check if the Serial No. exists already. If the Serial No. exists then you can choose to skip the record by using currXMLport.SKIP or you can write a code to modify the record.

edoderoo

Apparently the serial no. is not unique, and therefor not the right choice for a primary key. Either you need to extend the primary key with the brand of the car, or the license-plate, but this will influence existing code that works with the file!
You can also force the primary key to be unique by adding a consecutive number as primary key, and use the serial no. as secondary key.

Tiwaz

As I said, It is unique but sometimes, you wish to import data connected with serial no. that already exists in the table but something, ex:. car colour is different so that needs to be updated.
But I figured it out. I set AutoUpdate property of table element to Yes, and it updates fields connected with serial no. that already exists.