Some of data not shown from CSV

[wunj2321]

When i upload file some of the data shown something like this, so i don't sure what happen to it. ( K and M column)

Chem.csv
Micro.csv

[wunj2321]

[Object object] and i have give the csv below

[ConorWebb96]

Hey @wunj2321,

You can still technically access this information. All you need to do is drill into that object.

The fix for this would be making the title different as you have named it E.Coli, if you removed the . and name it E Coli this would fix it and output it correctly.

When testing this was all I changed and everything imported correctly. I'm not 100% sure on what the cause is, it must be related to how Budibase import works. It seems to take whatever is after the . and use that as the key for creating the object.

Heres the output on the frontend before I fixed the title:

And heres what happened after I removed the . in the title after importing.

I hope this makes sense and helps resolve your issue.

[wunj2321]

Thank you @ConorWebb96 , and one more question if i upload 2 file in one DB it shown nothing, I would like to know what it is happen?

Thank you once again

[ConorWebb96]

Hey @wunj2321,

I believe this to be related to your Chem.csv file. It is very poorly structured you have some rows appearing as column headings when they should be apart of the first row. (The below screenshots all appear on the same line.)

You also have stray quotation marks at random places within the CSV file. I would suggest fixing these issues and then re-importing your CSV file.

I'm not 100% sure why it has affected the other table though. I'm currently still investigating this, it likely is a bug I will link it here whenever I've got more information and have written up the bug report.