Categories
View Replies (7)

Resolved Google sheet import specific columns

  1. atrus
    atrus
  2. RO CSVI
  3. Wednesday, 07 April 2021
  4.  Subscribe via email
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
0
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
atrus
atrus
Accepted Answer Pending Moderation
Thanks Tharuna,

But that would be possible i guess? If yes, can you also provide an offer for this one?

Rgrds,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 3
atrus
atrus
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
atrus
atrus
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!