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
Hi Tharuna,

Thanks for the update!

Rgrds,
Chris
  1. one week ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Chris,
I fixed the cause for 500 error and also to skip the hidden values from Google sheet filter views. Uploaded changes to your site. Import preview looks fine to me with VM Stock Google Sheet Import template. I did not run the import on your site so can you please check and let me know if it works as expected?
Kind regards,

Tharuna

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

Many thanks for this, confirm that the 500 error is gone now. My preview doesn't look as expected though, see attached the google sheet with filtering applied (on product_sku column) and the corresponding preview. I know the preview doesn't show the data that will be finally imported necessarily, so I also tried to import but instead of 3 entries only the import reached 100 lines and then i stopped it manually.

Feel free to run import on this template for further tests if you like. Maybe the problem is because of the non-ending import? (google sheet import goes forever, see my other post here: https://rolandd.com/support/ro-csvi/google-sheet-import-specific-columns)

Regards,
Chris
Attachments (2)
  1. 6 days ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Chris,
Google sheets api gets hidden values from Filter views created in the sheet and those are removed from import. May i know how you have hidden the values? Filters shows the below list as hidden SKU values and so values other than that shows up in import preview page.


235156,06-3455-57,06-7720S-SET,08-1003-09,08-1407-12,08B,08T,150188-SET,151007-03C,151007-03C-SET,151510-SET,151574-SET,151869-SET,151883-SET,152046-7-SET,152084-95,152181-01-SET,152211-SET,152245-SET,152477-8-SET,152513-01-SET,152513-03-SET,152517-8-SET,152590-SET,152894-06,170030P,170056-SET,250003M,250450,25872-B-SET,25872-SET,25872-Y-SET,3-1-Connector,300401,75-7663,75-7676,A074-SET,A3007-SET,AGBOVFG,aluminium-bends,aluminium-straight-tubes,aluminized-bends,BC,BL-101,BL-107,BL-114,BL-15,BL12-13,BL154-SET,BL161-SET,BL161VB-SET,BL162-SET,BL167-SET,BL171-SET,BL186-SET,BL187ST-70,BL188-SET,BL189-SET,BL192-SET,BL194-95,BL202-89-SET,BL202VB-89-SET,BL204-SET,BL205-SET,BL206-SET,BL208-SET,BL214-SET,BL215-SET,BL217-SET,BL219-SET,BL22-23,BL220-SET,BL221-SET,BL222-SET,BL226-SET,BL227,BL33-34,casting-bends,CAT104R1,CAT104R2T,CAT125R1,CAT125R2-3,CH102,Clamps,cone-filters-blue-130,cone-filters-blue-65,couplers,CP-1BK,CUT,CZT-Pipe-SET,F101250,FL22,FL7,FL80-90-101,flat-wiper-blades,flexible-hoses,FLT,front-wiper-blades,FVW100150,gaskets,green-replacement-filters,hangers,Header-Wraps-500,heavy-duty-clamps,HH102,hose-clips,HR-002,HR-008,ILP,kart-filters,KAU01,KAU101P,KITR32,KITYR32,KMN,KVB,Lambda-Sensor,LF133,LF133S,LF165-SET,LF166-SET,M039-SET,M044-SET,monster-line,MSH8,perforated-pipes-aluminized,perforated-pipes-ssteel,pipe-connectors,powerflow-filters,rear-wiper-blades,reducers,Rubber-Rings,S8150,SC47-57,Short-Bends,shs,silencers-38,silencers-50,SL102135,SL10245,SL10276,SL1027645,SL1027690,SL10290,small-filters,Sound-Controller,Spiral-Air-Hoses,SSAR,ssteel-cnc-bends,straight-hangers,Titanium-Wraps,TR1003-64,TR1010,TR1012,TR1019-50,TR1020-22,TR1025,TR510-55,TR520,TR540,TR550,TR680,TR700,TR720,TR790,TR800,TR870,TR880,TR890,TR960,TR970,TR980,TR990,TRM1,TRM2,TRM3,trucks-front-wiper-blades,u-clamps,v-bands,vacuum-valves,VC,VSC,VVCL,VVOP,walker,WS-002,WS-107,WSP,Y1-Y2,Y3-Y4,YC,06-3455,RM,RMLS,SRM,SRMLS"
Kind regards,

Tharuna

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

Yes, should be more hidden values than these, it's weird. See attached how I create the filter.

Regards,
Chris
Attachments (2)
  1. 3 days ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Chris,
I am still seeing the same values as hidden content. Let me look into this more and get back to you with an update.
Kind regards,

Tharuna

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

Let me know if i can help further in anyway.

Rgrds,
Chris
  1. 2 days ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1
  • 2


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