1. atrus
  2. RO CSVI
  3. Wednesday, 31 March 2021
  4.  Subscribe via email
Good day!

Could it be possible to import from a google sheet only the rows that are visible and exclude the ones that are hidden with a filter?. That would be very useful (at least for us) as we do a lot of custom/partial imports of products.

Rergards,
Chris
Accepted Answer Pending Moderation
Just a reminder to see if we could work smth on this, thanks!
  1. one week ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Chris,
I remember the content of this post was removed and set to resolved when checked last time. We don't get email on post which is edited so this got missed.

Could it be possible to import from a google sheet only the rows that are visible and exclude the ones that are hidden with a filter?. That would be very useful (at least for us) as we do a lot of custom/partial imports of products.

Importing only the visible rows is not possible with current RO CSVI google sheet imports. I see that Google API has an option of setting filters but we are not sure on how that works. You are the first user asking for this feature. If we get more request on this feature we will consider in adding this with future version of RO CSVI.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Thanks Tharuna,

I'd be interested to receive a quote for this task if you have the chance to see whether this could be indeed possible.

Rgrds,
Chris
  1. one week ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Chris,
We will look into this and get back with an update.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Tharuna,

Just following up, you can send me the quotation in my email also.

Rgrds,
Chris
  1. one week ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Chris,
We have developed this feature and attached files with the patch file. You have to

1. Load the attached patch file with RO CSVI Maintenance page.
2. In your import template settings on Source tab set Import hidden rows field to No (By default it is set to Yes). Save the template.
3. In import preview page you should see hidden rows are not loaded.
4. Run the import.

This feature skips hidden rows either set to hidden by user manually or set hidden by filter in google sheet. Please test the feature and let me know on how it goes.
Attachments (3)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Many thanks Tharuna!

I uploaded the patch, it gives 500 Internal Server error in all google sheet imports (before previewing). I will try to look into the server to get more details.

Rgards,
Chris
  1. one week ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Chris,
There is a new setting Import hidden rows added to import template on Source tab with the patch. Did you save the setting in your import template? Can you try saving with one import template and see if the error is gone?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hi Tharuna,

Yes, i changed the 'Import hidden rows' to false and saved. It gets saved ok. But the error is there.

Rgrds,
Chris
  1. one week ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Chris,
Please check your server error logs and see if you can find any details on the error. You can post it here so i can check.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hi Tharuna,

So far i see this in server error log:

[fcgid:warn] mod_fcgid: read data timeout in 31 seconds, referer: https://www.quality-tuning.eu/administrator/index.php?option=com_csvi&view=templates
[core:error] End of script output before headers: index.php, referer: https://www.quality-tuning.eu/administrator/index.php?option=com_csvi&view=templates

I changed the PHP max script run time to 60secs but i still get a timeout.

Rgrds,
Chris
  1. one week ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Chris,
Two suggestions

1. In your import template settings on Limit tab set Lines per import to 100 or 50, save the template and run the import again.
2. Check what happens if you set 'Import hidden rows' to Yes on Source tab. See if import goes with out any error.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hi Tharuna,

1. Set it to 50 but still get the error. Please note that the import is not starting at all as it hangs before the preview screen.
2. No change even if i set it to Yes

Rgrds,
Chris
  1. one week ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Chris,
2. No change even if i set it to Yes

Ok with Import hidden rows set to Yes the new code sent with the patch file is not processed. So 500 error is not because of patch file. Is the 500 error only with Google imports or with all imports? Which Joomla, VirtueMart and PHP version you are using?

Also check 500 internal server error document and see if any of the solution in the document helps you with the error.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Tharuna,

Please see below:

Joomla 3.9.25
PHP 7.4.16
Virtuemart 3.8.9 10473

The problem only happens with google sheet import, other imports work ok.

I reinstalled CSVI 7.20.0 and the google sheet import worked ok. Afterwards i reinstalled the patch and the 500 error came up again, so something goes wrong due to the patch it seems. See attached from patch installation.

Rgrds,
Chris
Attachments (1)
  1. one week ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello Chris,
Your Joomla, VirtueMart and PHP versions looks good and screenshot shows patch is installed correct. I think it must be something with code. Can you send me your site login and (S)FTP details to check? You can post the details in Site details tab under your reply.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Alright thanks, filled the info.
  1. one week ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello Chris,
Thank you for sending requested details. I have been testing on your site with 500 error and could see the call made for google sheets with new code is causing this problem. I am not sure if there is something different with your google sheet and that is causing the error. To test more on this, please send me the link of your google sheet and provide access to my email tharuna.b@gmail.com. I will set this sheet in my local server for further testing.

You can set Import hidden rows field to Yes and run the import. The error with this condition is solved.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Thanks Tharuna,

I've shared the google sheet.

Rgrds
  1. one week ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Hello Chris,
Thank you for sharing the google sheet. I am able to reproduce the error with your google sheet. I am looking into it and will keep you updated on the findings.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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