Did it still not work with that format?
No, friend
If not, would you mind sharing your XLSForm and the updated and fixed CSV file again with the community? The community should be able to help you out.
@Victorpaisano25, you are with the same CSV structure:
Change your CSV structure as shown in the image below:
How do I do that
Maybe you will need to do some Excel search for this.
I already converted it and it still doesnât work
I have changed a bit the XLSform and the csv file
PDPesaje.csv (311.6 KB)
Xlform de Pesaje.xlsx (13.2 KB)
works in Kobotoolbox but not in Kobocollect
@Victorpaisano25, you should be able to achieve the desired format by following the instructions as outlined in the steps shared below:
Step 1:
Open the CSV file. You should see your CSV file in the following structure:
Step 2:
Select the column that contains the data.
Step 3:
Select Text to Columns data tool from the Data Tab.
Step 4:
By default, you will see Delimited being selected. Now press Next.
Step 5:
Select Semicolon and press Next.
In some cases, you may also need to select Tab along with the Semicolon if the data has line breaks in it.
Step 6:
Now you will see General being selected. You could simply press Finish.
Step 7:
You should now get a dialogue box as shown in the image below. Simply press OK.
Step 8:
Your CSV is now as shown in the following structure:
Reference CSV File that has been fixed:
PDPesaje.csv (312.5 KB)
Thanks but it still doesnât work
Iâll be waiting for the diagnosis of the situation. Thanks for the support!
Hola @Victorpaisano25 veo que hablas español.
Ya tuve este problema y logre solucionarlo; después de algunos meses.
Este error lo presentan principalmente los usuarios de Excel en español.
Y es muy simple de solucionar, lo Ășnico que tienes que hacer es Abrir tu archivo .CSV usando el bloc de notas y reemplazar y lo Ășnico que debes hacer es reemplazar el punto y coma â;â por simplemente la coma â,â. pulsas reemplazar todo. Luego darle guardar como eliges .CSV y eso es todo.
Esto sucede por como Excel en español interpreta los archivos CSV.
PDPesaje.csv (309.5 KB)
2 Likes
