Data Studio
1.7K members online now
1.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

UTF-8 upload error message

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi

I am trying to upload my UTF-8 file (converted to UTF-8 with Microsoft Editor, but it keeps telling me "There are only 3 columns out of the 1 expected"...

even if I upload a file with only 1 column....! 

anyone can help?

thanks

William

UTF-8 upload error message

[ Edited ]
Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Sounds like you have already uploaded a file. The new file must have exactly the same number of columns and titles. If not it will prompt you the change and ask if you want to add the columns. The problem is it may break any existing fields you have customized (e.g. - calculated field, renamed, etc. ) hence breaking the charts associated. I did this to an entire report.

 

For UTF-8: I upload my CSV (MS Excel) files into Google Drive, which converts to a Google Sheet. Then I download it and save at a xxx.csv file again. This removes non UTF-8 characters. Then I drop and drag it along side the existing data set.

 

Hope that helps...Gregg

UTF-8 upload error message

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Sounds like you have already uploaded a file. The new file must have exactly the same number of columns and titles. If not it will prompt you the change and ask if you want to add the columns. The problem is it may break any existing fields you have customized (e.g. - calculated field, renamed, etc. ) hence breaking the charts associated. I did this to an entire report.

 

For UTF-8: I upload my CSV (MS Excel) files into Google Drive, which converts to a Google Sheet. Then I download it and save at a xxx.csv file again. This removes non UTF-8 characters. Then I drop and drag it along side the existing data set.

 

Hope that helps...Gregg

Re: UTF-8 upload error message

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Hi Gregg
yeah i'll try that... not sure if that was the case though, because i
really created a file with only 1 column, and 20 amounts thereunder...
I have tried a workaround though which is to link directly the google
sheets files to the report and associate them without downloading them and
uploading them... seems to work...

i am new at this since... today! if you have any tip on this, if you think
associating directly to google sheet is not a good idea, I am taking up all
advices before I build too many reports and dashboards and having to undo
them later! Smiley Happy

cheers
William

Re: UTF-8 upload error message

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭
Hi Gregg
yeah i'll try that... not sure if that was the case though, because i
really created a file with only 1 column, and 20 amounts thereunder...
I have tried a workaround though which is to link directly the google
sheets files to the report and associate them without downloading them and
uploading them... seems to work...

i am new at this since... today! if you have any tip on this, if you think
associating directly to google sheet is not a good idea, I am taking up all
advices before I build too many reports and dashboards and having to undo
them later! Smiley Happy

cheers
William

UTF-8 upload error message

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

So, it definitely sounds as if you altered your columns since the initial upload. If you have not invested too much time in this report I would start over. It also sounds like you are uploading your own data. So try these steps:

1) determine the column (data) you know you need.

2) create a CSV file

3) upload CSV file to create a new Data Source

4) at the end of the upload you will be offered to create a new report...do that.

5) Rename Data Source and Report so you can easily find them

6) build your report out with graphs and charts

 

Gregg

UTF-8 upload error message

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

William,

 

While you are learning I recommend using small amounts of data until you master a component. Once you build you confidence up...use one report for building on and another for testing. You can share the data source between the two reports. But be careful of changing the data source files. You can break the charts, therefore for learning purposes I would have totally separate reports and sources for testing.


Gregg