Okay
  Public Ticket #901964
2-dimensional array error
Closed

Comments

  •  2
    Kris Small started the conversation
    September 26, 2016 at 4:03am

    I am attempting to get this Google Sheet to display on my page (https://docs.google.com/spreadsheets/d/1K41o2-UGqlP8GfzPeQhHqnUp50SFsQkcDWMFp8pBRvs/pubhtml)

    I've read the other users' issues with the following error: 

    wpDataTables backend error: Please provide a valid 2-dimensional array.

    I'm not sure what format I am missing that will help the data to display.

    Any suggestions?

  • [deleted] replied
    September 26, 2016 at 11:05am

    Hi Kris Small,
    Thank you for your purchase.

    Please send me approve me permission so I can edit your file. I will not change any data I just want to see what is causing an issue.

  •  2
    Kris Small replied
    September 28, 2016 at 11:41pm

    I've done as requested. Please let me know if you are unable to access.

    Thanks

  • [deleted] replied
    September 29, 2016 at 4:12pm

    Hi Kris Small,

    Sorry for delayed replay I didn't see that you have approved me a permission so I can edit your Google Spreadsheet file.

    Problem is because you have added breaks with ENTER in column B. For example B2:

    2014 Data (Released September 2015)
    Clark County: 9.33% (1st lowest in Washington)
    WA: 13.55%

    If you want to add breaks you should do in this way:

    2014 Data (Released September 2015)<br>Clark County: 9.33% (1st lowest in Washington)<br>
    WA: 13.55%

    Our plugin is converting Google Spreadsheet file to CSV and when you add breaks with ENTER button it convert to CSV file that is corrupted.

  • [deleted] replied
    October 3, 2016 at 1:09pm

    Hi Kris Small,

    In this document you still have breaks and in cells where you have added <br> tag.

    Cells in column B should look like this:

    Right:

    2014 Data (Released September 2015)<br>Clark County: 9.33% (1st lowest in Washington)<br>WA: 13.55%

    Wrong:

    2014 Data (Released September 2015)<br>
    Clark County: 9.33% (1st lowest in Washington)<br>
    WA: 13.55%

    Wrong:

    2014 Data (Released September 2015)
    Clark County: 9.33% (1st lowest in Washington)
    WA: 13.55%