Import from CSV - Overwriting

[jo-ka]

Hello. I'm having an issue when importing from CSV.

I import for example, 10 lines of a CSV file. It works OK.

I then import it again, and change some descriptions on some lines.

I would expect that, when I import the file for the second time, that those changed fields were updated.

I even tried with the Overwrite option set to yes, with no avail.

Am I doing something wrong, or am I expecting something that it's not programmed?

If so, is there a way to overcome this?

Thanks in advance.

 

[troester]

I didn't test if there are issues.
But at least you need a record id, an (Fabrik internal id) element which is set as PK in list settings.

 

[Nagtegaal]

For me the overwrite works fine. It does a merge in the database and yes you need a PK. I just wonder if the overwrite can be set to yes by default

 

[pastvne]

The listCSV plug-in gives you some nice programmatic hooks to the import process. You might be able to use it to code some kind of algorithm to check the import line against the database to determined automatically if the csv row being imported as a match in the database. If so, you might be able to code your own update to the database record and override the importer's logic.

I just used it myself on my own project and was able to gain the control I wanted over the import.