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. ๐Ÿ‘

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 1 mth 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.

    Like
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 mth 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.

    Like
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 2Replies
  • 39Views
  • 1 Following