Import linked records with Excel CSV

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • harrytruman
    Member
    • Jun 2023
    • 98

    Import linked records with Excel CSV

    Hi Everyone,

    I'm trying to upload a CSV of linked records. The first column has unique identifiers to update by. The second column is a list of record ID numbers that correspond to records in the first column. See attached screen shot.

    When I upload a file like this, it only updates the linked records field with one value. The correct way to do this in Espo is to have column 1 with one ID number and the next row cell has a list of record ID numbers like 82400, 84500, etc.

    Is there another way to upload a CSV like this without having to CONCATENATE​ the contents of a row into one cell. Any ideas. Thanks!
  • esforim
    Active Community Member
    • Jan 2020
    • 2204

    #2
    You mean not need to EXCEL/CSV CONCATENATE​​ right?

    If so I would: create 3 field? And third field in EspoCRM use a CONCATENATE​​ formula?

    Comment

    Working...