As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #901964
2-dimensional array error
Closed

Comments

  •  2
    Kris Small started the conversation

    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

    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

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

    Thanks

  • [deleted] replied

    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

    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%