To GoodData homepage

Replies posted by Darina

4 Replies

D
DarinaNew Participant
asked in Data sources

Why did GoodData rearrange the columns in my .csv file?

Hi Iva,Problem solved! It turns out that there were some NULL values among the dates in the updated file. They were probably interpreted as text and considered out of bounds. When I removed them, the upload was successful.Thank you so much for your support and your patience! 🙏The error message I kept getting said “Make sure that the data corresponds with the structure in the header, and try again.” So I thought that there was something wrong with the header or the structure of the data. Perhaps it would be useful - in case the load of a file fails - to include an indication of the reason why the load failed to point the user in the right direction. An error message suggesting that there is something wrong with some of the values might be more informative as to what needs to be fixed in a case like this.

7
Iva Gasparekova
GoodData Employee
9 months ago
D
DarinaNew Participant
asked in Data sources

Why did GoodData rearrange the columns in my .csv file?

Hi Iva,Many thanks! I’ve tried again, in Firefox as well as Chrome, and I still get the error. In the DevTools Network Monitor, I don’t see an error per se - these are the requests/responses that appear:I think that you might be interested in the POST request. I don’t see any RequestID field anywhere, but perhaps the X-GDC-REQUEST field from the Response Header could be helpful: X-GDC-REQUEST: data_load_UsJEmIEFsz_YUQudGgzHh:dn8lcYDJPZeUcoEB.Or is there another part of the DevTools that I should be looking at instead?

7
Iva Gasparekova
GoodData Employee
9 months ago
D
DarinaNew Participant
asked in Data sources

Why did GoodData rearrange the columns in my .csv file?

Hi Iva,Thank you! I’ve looked into it a bit more and these are my findings: The simple fact that the columns are in a different order in the template .csv file does not seem to be a problem for the other .csv file in my workspace. The file which I want to upload to update one of the data sets, has the same structure as the previous one, but some of the values have been updated.Let’s say that in the original file, the value in the “colour” column for id 2 was “blue”, but in the new file for id 2 the value is “red”. That is the only difference I am aware of. Might that be the problem? And if so, how do I go about changing/correcting values in the data sets?

7
Iva Gasparekova
GoodData Employee
9 months ago
D
DarinaNew Participant
asked in Data sources

Permanently deleting the whole dataset

Many thanks for your reply, Julius!

2
D
10 months ago
Welcome to the GoodData Community!Cookie settings