1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

Import from CSV - Overwriting

Discussion in 'Community' started by jo-ka, Oct 8, 2019.

  1. jo-ka

    jo-ka Member

    Level: Community
    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.
     

    Attached Files:

  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    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.
     
  3. Nagtegaal

    Nagtegaal New Member

    Level: Community
    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
     
  4. pastvne

    pastvne Bruce Decker

    Level: Community
    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.
     

Share This Page