CSV upload and ID mapping, there is a lookup field...
# generaln
Nbtwist
07/27/2022, 6:58 PMCSV upload and ID mapping, there is a lookup field that I am matching the internal ID to, but the CSV upload is failing. Any suggestions?
n
Nick
07/27/2022, 7:16 PMWhat does the error say?
n
Nbtwist
07/27/2022, 7:48 PM"Invalid custrecord_inv_item reference key ""10962"
n
Nick
07/27/2022, 8:01 PMRisking asking the basic question here, but do you have a record of the type you are trying to import to with the internal id = 10962? This error would suggest no record exists w/ that internal ID.
t
Tristan Day
07/27/2022, 8:03 PMhave you changed the reference type of the key to be the internal ID?
Tristan Day
07/27/2022, 8:03 PMnormally it defaults to "name"
Tristan Day
07/27/2022, 8:03 PM(click the pencil on the left of the import mapping row)
n
Nbtwist
07/27/2022, 8:19 PM@Tristan Day that may be it! And Nick yes these were all exported from the environment
Nbtwist
07/27/2022, 8:28 PM@Tristan Day yup that solved it! 883 records imported successfully
👍 1