Resolved Google sheets - No column headers have been found in the file

Many thanks Roland, it works nicely now

Will keep on with the testing and will let you know if i notice anything else.

Hello Chris,
I was able to reproduce this error with your template. The filter stock_published does it include the first row in google sheet? The possibility of seeing this error 'No column headers have been found in the file' is when the data from google sheets does not include the headers in the sheet which also means the filter is not including the first row from google sheets.

Hello Chris,
The start and end column seems to be not set in stock_published filter. The problem is only with this filter. If i set filter view to tempProduct filter, import loads fine. May i know on what basis the filter stock_published is set and in what range of columns?

Hi Tharuna,

The filter is made basis col H ('published'); more specifically only the Y values are selected, the N values are excluded. (so that only published products will be updated on import)

Thanks,
Chris

Hello Chris,
Please load the attached patch file and check the import. Let me know if the patch file solves the filter issue.

Thanks Tharuna,

Yes the first row it's included (you can see the relevant sheet/filter in the shared google worksheet)

Regards,
Chris

Hi Tharuna,

Many thanks! The filter shows ok now.

The only pending problem is that it runs forever; i'm checking the time-out instructions you sent me before but i'm not sure that i'm actually having a timeout. When there is a timeout the process stops. I can see the rows imported to be increasing and the import to be running (or at least it seems it does), it just never stops; so the server seems to allow the process to run fine, it simply never ends So not sure if it is a server side issue, or a csvi issue atm.

See attached the relevant log (and template). The rows to be imported where abt 3300, but i had to stop it at abt 16000 rows, it kept going forever.

Rgrds,
Chris

Hello Chris,

Many thanks! The filter shows ok now.

Glad to know that filter works as expected.

The only pending problem is that it runs forever; i'm checking the time-out instructions you sent me before but i'm not sure that i'm actually having a timeout. When there is a timeout the process stops. I can see the rows imported to be increasing and the import to be running (or at least it seems it does), it just never stops; so the server seems to allow the process to run fine, it simply never ends So not sure if it is a server side issue, or a csvi issue atm.
See attached the relevant log (and template). The rows to be imported where abt 3300, but i had to stop it at abt 16000 rows, it kept going forever.

Debug log has default of first 20 entries. Looking into debug log i don't see anything wrong with those first 20 entries. How many rows entries you have in Google sheet? Are there empty lines after 3300 rows? Please set the Number of lines in log file field to 5000 in RO CSVI config page and run the import. Post the debug log to check. That will tell us what is going on after 3300 rows.

Hi Tharuna,

Please see attached the latest log file. I don't see any empty lines in the google sheet. Note that we are using a filter for the import also (total final row count is 3328)

Also i see in the log some queries like:

UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='23',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`product_weight`='0.7000',`product_weight_uom`='kg',`product_length`=NULL,`product_width`=NULL,`product_height`=NULL,`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`product_stockhandle`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='24h.gif',`product_special`='0',`product_discontinued`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`product_canon_category_id`=NULL,`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`has_categories`='1',`has_manufacturers`='1',`has_medias`='1',`has_prices`='1',`has_shoppergroups`='0',`created_on`='2015-04-20 08:37:20',`created_by`='937',`modified_on`='2022-05-24 13:13:43',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku` = '151510-SET'

So much updating here, while the template only has 2 fields to update: product_in_stock and product_ordered. Not sure why it pulls all these data from the excel sheet.

Rgrds,
Chris

Hello Chris,

The only pending problem is that it runs forever; i'm checking the time-out instructions you sent me before but i'm not sure that i'm actually having a timeout. When there is a timeout the process stops. I can see the rows imported to be increasing and the import to be running (or at least it seems it does), it just never stops; so the server seems to allow the process to run fine, it simply never ends So not sure if it is a server side issue, or a csvi issue atm.

I am able to reproduce this issue and looking into it. Will send you an update on our findings.

So much updating here, while the template only has 2 fields to update: product_in_stock and product_ordered. Not sure why it pulls all these data from the excel sheet.

It does not pull the data from excel sheet. The field values product_in_stock and product_ordered are pulled from import file but the rest of the fields are default field values which are updated on import.

Hi Tharuna,

Thank you for the clarifications; looking forward to the findings on the running-4ever issue then.

Rgrds,
Chris

Hello Chris,

The issue with forever running was that whenever the process would start the next round it started from the beginning, that way you never reach the end

Can you please apply the attached patch and let me know if it works for you?

Looking forward to your findings.

Hey Roland, hope you are well!

Many thanks, uploaded the patch but something looks off, see attached img. The filter is not taken into account and also i cannot see a preview of the rows to be imported.

Rgrds,
Chris