How to Match Data in CSV Columns to Reference/Dynamic/Static Fields in Collections

Question
#1

Greetings @vishsahu
I am importing CSV files with all columns/ fields completed. Now when they are in the collection, the data in reference or dynamic fields do not appear. e.g. if the field requires an option be selected like a dropdown, it will not show in the final record of the collection. The CSV looks like this

image
image1169×189 7.7 KB

and the final collection looks like this
image
image1267×533 37 KB

and the Collection configuration is like this
image
image1268×560 27.8 KB

If I have to change the collection fields to text, which i thought could solve the problem, then when it comes to the fields defining the parent/child relationship they will no longer be valid as i would like to implement the cascading dropdown option using these collections. I have thousands of lines of data (some beyond 32000 lines) to be able to manually select all the reference options updating each record… What options do i have.

Thank you

#2

Hie @vishsahu . I have also tried importing using JSON and the same reference fields are not populating but the text fields are populating

image
image1238×550 41.6 KB

and the JSON file
image
image1364×723 64 KB

#3

Hi @WillieMak,

Sorry for the late reply.

If you are still seeing the issue, then can you please send us the JSON file in email?

Thanks.

#4

Greetings @vishsahu

Thank you for the response. Yes I did find a way round it using UUID because the builder couldn’t match the data on basis of text alone. Took me days to map uuid to each line in all related collection. Will explain what I did. It needs a bit of time.
However I am still facing the challenge that even then, some data from the same CSV is not connecting directly to the parent or child dropdown. Am currently trying something else to see if it will work. Will be in touch

Thanks

#5

Sure. Thanks. @WillieMak