Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

Okay
  Public Ticket #1155375
Issue with Google Sheets Integration: "Moved Temporarily"
Closed

Comments

  • partyparty started the conversation
    May 2, 2017 at 4:33am

    Hello. We are getting an issue with our Google Sheets integration. The sheets are both public, but unfortunately they are not showing on the website via WPdataTables. If you go to the website homepage, please just scroll down to the bottom of the page and notice the WPdataTables area where the spreadsheets are missing.

    We are hoping you can assist us with figuring out what is going on. Thank you.

  •   partyparty replied privately
  • [deleted] replied
    May 3, 2017 at 10:17am

    Hi partyparty,
    Thank you for the purchase.

    The issue is probably related with your Google Spreadsheet. You have narrow some columns (B, D, F...) but it is not possible to have empty columns. You should not create Google Spreadsheet like that. Each column should have at least column Header name. Also I suggest you also not to skip rows in the spreadsheet (but this will not cause errors in wpDataTables). Please take a look at the example how Google Spreadsheet file should look at this link.

  • partyparty replied
    May 4, 2017 at 7:04pm

    Milos,

    Thanks that helped! I have one more question. The table is now showing up, but there are several empty rows showing up at the top of the table when viewing on the website: http://cy-fair.setmy.site/


  • [deleted] replied
    May 5, 2017 at 9:31am

    Hi partyparty,

    This is probably happening because you have empty rows in the Google Spreadsheet. Can you please send me the new Spreadsheet or check if you have any empty rows in it?

  • partyparty replied
    May 5, 2017 at 5:15pm

    Hi Milos,

    Here is the spreadsheet: https://docs.google.com/spreadsheets/d/1w-6aw1zlU10Pf8paA4rUs6ZM2nyXCTwbw3LcY--8KRY/edit?usp=sharing

    I made the spreadsheet publically editable so you may edit it if you need to. It is a test. 

  •  1,894
    Miloš replied
    May 8, 2017 at 4:35pm

    Hi partyparty

    Milos is currently on a vacation so I will help you out.
    Can you please try now I edited the spreadsheet and this is the result . ( attachment) 

    The issue was that you have a new line between sentences in column UNIT DETAILS
    You entered them like this :

    Equivalent to small hall closet.
    Drive up access.

    and it should be entered like this:

    Equivalent to small hall closet. Drive up access.

    Because of that Google spreadsheets recognize them as a new row or break and that is why you had that issue.

    Best regards.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • sgwifi replied
    June 9, 2017 at 2:22pm

    After some searching, I found out in another ticket that we can use <br> to resolve the issue.

    Thanks for this wonderful plugin!