I unable to upload CSV file

[Root Info Solutions]

Hello David,

I am using ubuntu. I am using PII Viewer for Google Analytics but when I'm trying to upload CSV file it's not uploading didn't show any error or message.

Please see the screenshots.

Regards Saroj

[David Simpson]

Are there any errors in the web console?

Try opening the web console and look for errors:

To open the dedicated Console panel, either:

• Press Ctrl+Shift+J (Windows / Linux) or Cmd+Opt+J (Mac).
• If DevTools is already open, press the Console button.
• When you open the Console panel, the Console drawer collapses automatically.

-- https://developers.google.com/web/tools/chrome-devtools/console/

[Root Info Solutions]

Hello David,

No error found. I am following this video: https://www.youtube.com/watch?v=Y_OiIyLC4cI

I want to see individual analytics username and email. Have I needed to create a CSV file manually? Currently, I have downloaded it from Analytic report.

[divesh jain]

hello,

‌ i have same problem and also email you but didn't get any reply. as you said i have seen to the dev tool and saw problem but i was unable to understand it please help me here what it shows

options.js:257 Uncaught TypeError: Cannot read property 'forEach' of undefined
at FileReader.reader.onload (options.js:257)
reader.onload @ options.js:257
load (async)
(anonymous) @ options.js:238
dispatch @ jquery.min.js:5
y.handle @ jquery.min.js:5

please help me with this

thank you

[David Simpson]

@divesh jain This seems to be an error reading the CSV file. I see 2 errors in uploading a valid file mime-type from India today - I use Google Analytics to record errors.

If this is you, then it looks like you are uploading something with a mime type of application/vnd.ms-excel - probably an xls or xlsx file rather than a csv file.

[divesh jain]

hello David,

‌ Thank you so much for your assistance. i got it correct now sorry for trouble but one last thing i need help in from you.

Is there any way that one can get detail like name and email address from google analytics user explorer client id number as i don't have any information of them ?

i want this information as my business is not online business like purchasing products online. it is just website from which i can contact them who just viewed it from email address data. As in pii viewer you need data that i don't have.

thank you

[David Simpson]

@divesh jain

Take a look at the following:

• https://davidsimpson.me/2014/04/20/tutorial-send-user-ids-google-analytics/
• https://davidsimpson.me/pii-viewer-for-google-analytics/
• https://davidsimpson.me/2014/04/22/tutorial-using-pii-viewer-google-analytics-chrome-extension/

‌

[divesh jain]

hello David

‌ I have seen this video before but I have question that in pii viewer which csv file should i upload from analytics user explorer?

But thing is as in your video your csv file had data of name, email , country ,etc of user id that how we see the data in pii veiwer but i done have that data so how do i get it ?

Thank you

[David Simpson]

Hmm. The starting point of this is that you have your own collection of users who can be saved into a CSV file.

If you do not have that, then you’ll need to find out who your users are first.

[divesh jain]

hi David

‌ As i don’t have the data and don’t know how to get it. I thought pii viewer helps to know about the site visitors from start i thougt that only. i doing these for more than 2 months following you and other sources to get this done.

I don’t know what to say but i just want to know about people who visit my website and their email address is there any way i can get it will help me a lot?

Thank you

‌

[David Simpson]

OK, so imagine that your website has a member's area.

When a member logs into the member’s area, they will have a username such as [e-mail] (which is not allowed to be sent to Google Analytics becuase of section 7 of the terms of service) and a user id, which might be an integer such as667, or a guid such as 26b0b310-1db8-4f8a-a692-731d91639ae0.

Here’s the important bit:

1. Because your website knows the user id, it can send it to Google Analytics as a custom dimension.
2. Because it’s your website, you will likely have some way to extract a list of users from the website’s database, say as a CSV.

If you have 1 and 2 sorted out, you can use PII Viewer for Google Analytics.

If you don’t have these 2 bits of data, you’ll need to get them before you can do anything with the PII Viewer Chrome extension.

[Ahkeem Lang]

Hey David, I’m experiencing the same issue. I have a csv file that I want to upload but when I do I receive the error from the screenshot I’m sharing.

‌