1. atrus
  2. RO CSVI
  3. Wednesday, 18 May 2022
  4.  Subscribe via email
Hello all,

I'm using a google sheet for importing prices and i need to do a regex replacement at run time to add new lines for the additional shopper groups prices. (I have shared the relevant sheet recently to Tharuna, the tab name is price_import)

I have created the following rule (a regex replacement of \\n to \n). However, i'm not sure how the additional custom fields (column name = DELETE as you will see) should be taken into account during import.

Would appreciate your advice.

Thanks!
Chris
Accepted Answer Pending Moderation
Hi Tharuna,

Thanks, i will need to check another way then.

Rgrds,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Chris,
I'm using a google sheet for importing prices and i need to do a regex replacement at run time to add new lines for the additional shopper groups prices.

I don't understand the need of adding new lines for shopper groups prices. Can you share a screenshot on what you are trying to do with shopper groups prices?

I have created the following rule (a regex replacement of \\n to \n). However, i'm not sure how the additional custom fields (column name = DELETE as you will see) should be taken into account during import.

Your google sheet has multiple DELETE columns. You want to combine all these columns into one column on import? Please explain with an example.
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
Accepted Answer Pending Moderation
Thanks Tharuna,

I need to import multiple prices / per product for each shopper group (total 3). So far (before using sheets) i was doing a regex replacement to go from as shown in the shopper-groups.jpg attached to the example-import.txt as attached also. (The DELETE column name is just a reminder to delete these before importing). I am checking to see if there a possibility to automate this process using sheets.

In the sheet we use 1 row per product because it's more convenient for our calcs; but in csvi i think it's only possible to import multiple prices per product in separate lines, that's why i'm using the regex replacement.

Hope it's more clear now. Perhaps there is a better way i'm missing.

Regards,
Chris
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Chris,
I need to import multiple prices / per product for each shopper group (total 3). So far (before using sheets) i was doing a regex replacement to go from as shown in the shopper-groups.jpg attached to the example-import.txt as attached also. (The DELETE column name is just a reminder to delete these before importing). I am checking to see if there a possibility to automate this process using sheets.

With txt files \n represents new line and so it worked to generate separate lines for a product in example-import.txt file. As much as i know, adding \n will not work with Excel or Google sheets. I do not see a way to create a new line automatically with RO CSVI rules.

In the sheet we use 1 row per product because it's more convenient for our calcs; but in csvi i think it's only possible to import multiple prices per product in separate lines, that's why i'm using the regex replacement.

That is correct. RO CSVI expects each product price as individual line.
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. # 4
Accepted Answer Pending Moderation
Many thanks Tharuna, yes, i am implementing this way for now.

Noted though: i have created a filter (called published_products) based on column K, but when i try to import, it seems that it's not taken into consideration; all lines are imported. See attached the template file.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Noted though: i have created a filter (called published_products) based on column K, but when i try to import, it seems that it's not taken into consideration; all lines are imported. See attached the template file.

The filter is set based on Column K but your template shows range is set from A to J. Modify range as A to K in template and check the import.
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. # 6
Accepted Answer Pending Moderation
Many thanks Tharuna, it works now; didn't know that you had to also include the 'filter' column when it's not supposed to be included in the import data.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
Without including the Filter column, CSVI will not be able to filter data from the complete Google Sheet data on import.

Glad to know that it is working now.
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. # 8
Accepted Answer Pending Moderation
Hello,
One way to handle this with RO CSVI is by creating 3 import templates and by using Skip template field to import needed columns. So first import will import Column A for product_sku, Columns C to J and other columns can be set to Skip. Second import template will import Columns K to Q including Column A for product_sku and the rest of columns to be set to Skip template fields. The same goes for third import template. Check if this option works for you.
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. # 9
  • Page :
  • 1


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