Hi all,
We'd like to be able to import specific columns (consecutive or not) with google sheets, e.g.
A, B:E, I
Would it be possible? we have large google sheets with a lot of data, so this will enable us to make custom imports only for the data needed at a time.
Rgrds,
Chris
CSVI 7.16.1, Virtuemart 3.8.2, Joomla 3.9.18, PHP 7.2.31
Hello Chris,
Specific column import with Google sheets is not possible with RO CSVI. As of now we only support single consecutive range of cell import with Google sheets.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks Tharuna,
But that would be possible i guess? If yes, can you also provide an offer for this one?
Rgrds,
Chris
CSVI 7.16.1, Virtuemart 3.8.2, Joomla 3.9.18, PHP 7.2.31
Hello Chris,
In RO CSVI import template, you can set ranges from say A:I in the template settings and for the columns you don't want to import, you can set it to skip field in template fields. In your case set C,D,F,G and H to skip template field. That should help you do import of specific columns. Let me know on how that goes.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks Tharuna,
that's a good tip, thanks! Seems to work.
Btw, how csvi detects the google sheet end of records? I'm importing a sheet with abt 3000 records but CSVI keeps going and i need to stop it manually.
Rgrds,
Chris
CSVI 7.16.1, Virtuemart 3.8.2, Joomla 3.9.18, PHP 7.2.31
Hello Chris,
that's a good tip, thanks! Seems to work.
Glad to know it works.
Btw, how csvi detects the google sheet end of records? I'm importing a sheet with abt 3000 records but CSVI keeps going and i need to stop it manually.
What happens after 3000 records? Can you post a screenshot on what you see?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Tharuna
Before posting a pic to let u know:
The import continues 4000,5000 etc (I have set 1000 entries per step)
Rgrds,
Chris
CSVI 7.16.1, Virtuemart 3.8.2, Joomla 3.9.18, PHP 7.2.31
Hello Chris,
The import continues 4000,5000 etc (I have set 1000 entries per step)
Does your import finish and goes to log details page? We would like to see a screenshot on what you see with your import. That will help us to know the issue.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.