RO CSVI

Setting up Google sheets export using RO CSVI

A step by step instruction on setting up Google Sheets export using RO CSVI with an import template is explained in this document.

Step by step setting up Google Sheets export using RO CSVI

    1. Check that you have setup the Google token as explained in the Google API settings for import and export document.
    2. Create a VirtueMart Product export template
    3. On Source tab select Destination as Export to Google Sheets

      Setting up Google sheets export using RO CSVI

    4. Now enter the Spreadsheet details. Consider an example spreadsheet like https://docs.google.com/spreadsheets/d/1g9isWCeljHGSpbLbDsdarF89OVvmy8AI4nUWHUZxXis/edit#gid=0
    5. Spreadsheet id is 1g9isWCeljHGSpbLbDsdarF89OVvmy8AI4nUWHUZxXis
    6. Sheet name is Sheet 1
    7. From cell is A
    8. To cell is G
    9. Enter these details and save the template. We are all set for export. 

      Spreadsheet details Google

    10. Go to RO CSVI Export page and do the export as usual, RO CSVI will read the data from database and write it to the Google sheet.

    11. Once the export is done, log details page shows the result of the export.

      Export result from exporting data into Google Sheets

    12. You can now check your Google sheet for the exported data

Front-end export

Since version 8.22.0, you can also export to Google sheets from the front-end by creating a menu item. For more information see the related article Setting up a front-end export template. This runs exactly the same as if you were to run it from the back-end, the only difference is that the front-end will show a result message based on a language string. The default language string used to show the result message is COM_CSVI_DATA_TO_GOOGLE_SHEET_FRONTEND_COMPLETE. In case you have multiple exports you may want to modify the language string to reflect the nature of the template. This can be done by appending the template ID to the language string. For example, if your template ID is 33 the language string will become COM_CSVI_DATA_TO_GOOGLE_SHEET_FRONTEND_COMPLETE_33 and you can give it your customized message in the Joomla Language Overrides.

Related Articles