RO CSVI
Setting up Google Sheets import using RO CSVI
| RO CSVI
A step by step instruction on setting up Google Sheets import using RO CSVI with an import template is explained in this document.
Google API settings for import and export
| RO CSVI
RO CSVI Supports import from Google sheets starting with 7.17.0 version. In this document we explain step by step the procedure for setting up the Google account API.
Replace line breaks with an HTML br tag on import
| RO CSVI
This document explains on how to make RO CSVI replace line breaks with an HTML br tag on import using the Multi-Replace rule.
Dependent custom fields for all
| RO CSVI
RO CSVI has extended its support to Dependent custom fields for all in its RO CSVI Customfieldsforall extension. The procedure to run this import is same as Customfieldsforall except the part that there is a new available field custom_parent_value which is used for inserting parent_id.
Using Developer Tools to analyze problems
| RO CSVI
Sometimes a process generates an error notification or it simply seems to run forever. In this case the error happens in the background and you can't see what is happening. To make it possible to see what is happening, you can use the developer tools from your browser.
Installation
The developer tools are generally available by pressing F12 or CTRL-SHIFT-I. Another option is to right click on the page and select Inspect from the popup dropdown.
Analyze the problem
With the developer tools open we can analyze what happens. Follow these steps:
- Prepare your template if you are doing an import or export, otherwise you can skip this step.
- Activate the developer tools.
- Click on the Network tab. The network tab will tell us what is going on. Your screen should look like this:
- Click on the Preserve log button to make sure that the import information is not lost.
- Start the import/export/maintenance task
- During the execution you can get a screen like this:
- What to look for is the URL shown in the red box that ends with index.php?option=com_csvi Click on this URL to see the contents.
- Click on the Response tab
- Here you will either see the error that is causing the problem or some code you may not understand. That is not a problem.
- Either look to fix the error or post the full output on the forum and we will have a look
- You can now close the developer tools.