New Google Spreadsheet format in WP-Property Importer

Since Google has updated spreadsheet docs to new format you will get this warning - 

_**Invalid Google Spreadsheet URL. Remember to copy and paste directly from your address bar when viewing a Google Spreadsheet.

**_At the moment we no longer support this format. The easiest way around is to convert googlespreadsheet to csv file. So the steps are:

  1. Open the old URL in browser, and it'll redirect you to an updated URL, with a new "key".
  2. Make sure the Spreadsheet is set to be accessible to "Anyone with Link", if not done so already.
  3. Take the new "key" and insert it into the following URL:  https://docs.google.com/spreadsheets/d/---REPLACE-THIS-WITH-KEY---/export?format=csv
  4. Paste our new URL into the XML Importer's URL field, click "preview".
  5. If all works well you'll see some data, after that, just make all the "XPath Rule" fields lowercase.

That's it.

Learn more - https://support.google.com/docs/answer/6082736?p=revision_history_migrate

WP-Property: Importer

  1. Images are not Importing in WP-Property Importer
  2. XML and RETS Setup Services for WP-Property Importer
  3. Properties not published or Pending Images Download for WP-Property Importer
  4. WP-Property: Importer - Home
  5. Error No listings are found when running the WP-Property Importer Check your Query
  6. Could not connect to RETS server HTTP in WP-Property Importer
  7. Could not load XML Object from raw data in WP-Property Importer
  8. RETS DMQL basics for WP-Property Importer
  9. Issues Connecting to RETS Server for WP-Property Importer
  10. New Google Spreadsheet format in WP-Property Importer
  11. Google Spreadsheet errors in WP-Property Importer
  12. WP-Property: Importer - Useful XPath Rules To Use In Schedules
  13. WP-Property: Importer - There Was An Issue Doing The RETS Search In WP-Property Importer
  14. WP-Property: Importer - Translating
  15. Installing WP-Property: Importer
  16. WP-Property: Importer - Running The Import For WP-Property Importer
  17. WP-Property: Importer - Recommended Values For Server Configuration Options For WP-Property Importer
  18. WP-Property: Importer - MySQL Server Has Gone Away
  19. WP-Property-Importer-Introduction To RETS
  20. WP-Property: Importer - Integration Of WP Importer With Agents Add On
  21. WP-Property: Importer - Importing CSV
  22. WP-Property: Importer - Google Spreadsheet Format Error. Authentication With Google Failed. Reason Is Bad Authentication In WP-Property Importer
  23. WP-Property: Importer - DMQL Queries
  24. WP-Property: Importer - Could Not Load XML Object From Raw Data. Looks Like The Data Has Errors And Can Not Be Converted To XML Object In WP-Property Importer
  25. WP-Property: Importer - Could Not Connect To RETS Server, PHRETS 1 Cookie File \"\" Cannot Be Written To. Must Be An Absolute Path And Must Be Writable Within WP-Property Importer
  26. WP-Property: Importer - Basic XML Import Step By Step For WP-Property Importer
  27. WP-Property: Importer - Basic RETS Import Step By Step For WP-Property Importer
  28. WP-Property: Importer - Available XPath Functions For WP Importer Schedules
  29. WP-Property: Importer - Attribute Matches In Schedule Settings For WP-Property Importer
  30. WP-Property: Importer - Advanced Schedule Options For WP-Property Importer

Feedback and Knowledge Base