This is intended for an audience who's willing to roll up their sleeves and who are somewhat technically inclined.

CSV Downloads are a great tool!  They allow you to download all your data pretty quickly so you can do whatever you need with it.  However they are a little finicky and often times break because there's weird characters in the data being downloaded.

We can and will fix this for you, but if you're impatient and want to become a hacker for a day, here's instructions on how to to fix this yourself.

  1. Open the Inspector in your browser.  
  2. Click the offending "Download" link.
  3. Find the console output of your data.
  4. Copy and Paste it into the JSON Validator at jsonlint.com
  5. Find the errors in the data (one by one) and fix them in the validator.
  6. Retest using the validator. If it skips the error you just fixed, change the data in PushPress.
  7. Repeat steps 2 - 6 until the validator has no further issues.

1. Open Inspector

Usually this can be done by right clicking anywhere on the web page and clicking on "Inspector" or "Open Inspector".

This will open up a console window that you can use to inspect things on the webpage. It should look like this.

2. Click the offending Download link.

Where ever you are trying to download this data from, go ahead now and click on the download link.

3. Find the console output of your data.

Click on "console" in the debug options.  Then look for a crazy long block of text with some names you recognize.

It should start with a note similar to "CSV DATA". and end with a note similar to "END CSV DATA".  Do not copy the lines saying "CSV DATA" and "END CSV DATA" however!  Just the stuff in between, starting with a { and ending with a }.

4. Open a new browser tab.  Go to jsonlint.com and paste this data into the JSON Validator.

5. Find the errors in the data (one by one) and fix them in the validator.

It will generally just break at the first error it encounters and highlight it in red.  
Generally speaking, the CSV breaks when there's weird characters.  So if you see anything weird there, remove it or replace it with a standard character.

If you want to be very sure, simply remove any non-alphanumeric character you see. This would include quotes, single quotes, brackets, ampersands, etc.

6. Retest using the validator. Fix the data in PushPress.

Click on test again. If the validator moves on from the last error it found, then you fixed it.  Go back to PushPress, find the person you just changed data for and make that change in PushPress as well.

AGAIN.  Make sure you change and save the data in PushPress as you fix them on the validator.

7.  Repeat steps 2 - 6 until the validator has no further issues.

Keep cleaning the data until the validator shows up green as VALID.  Once it does and you've made and saved all these changes on the corresponding records in PushPress, your data should be ready to download.

Did this answer your question?