I have a collection (states) with three fields: state, is_available, lgas (List<String>)
I want to upload a CSV file in the Firestore manager interface to populate the collection (states) because doing it one by one would take a long time and I also do not want to use a custom function
I need help with representing the nested list of lgas in CSV without errors in FF
What I have tried:
I have tried formating my CSV in the following ways but they all returned errors..
Note: my CSV has headers: state,is_available,lgas
Kaduna,true,"[Chikun, Jere]"
Kaduna,true,"Chikun;Jere"
Kaduna,true,"[""Chikun"", ""Jere""]"
Kaduna,true,"[Chikun\, Jere]"
Kaduna,true,(Chikun, Jere)
Kaduna,true,[Chikun, Jere]For most of them I get a grey area after uploading the CSV
And for others I get this:
What my CSV looks like
