0

Import csv files with related tables.

How's it going.  I need a procedure to import csv files with related tables.  There is something hidden somewhere. 馃憤

3 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    From my quick review, there is no way of setting reference field links during the import process. I don't even see the fields as being available.

    Which means you will have to

    1) import the data into a temp table or an import table then use scripts to copy the data into the appropriate tables. Which means you have to have data in your import data that can use to find the appropriate records to link to.

    or

    2) have fields in your tables that can store the data that will be used to link the new records, so when you push a button you can link all the new records.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    Fred

    Hi, I made severasl test and for now it work, I can import .csv file to my table Documentos with all Plan Dates, Hours,  etc, and the Disciplines related with documents today I Will try with the Activities I suppose Works too.

      • kent
      • 1 yr ago
      • Reported - view

      Rafael How did you proceed to do this? Did you follow Fred's advice above or something else?

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 3Replies
  • 168Views
  • 2 Following