Unable to export to Excel / CSV files are empty

Web Scraper version: 1.29.66
Chrome version: Versione 116.0.5845.188 (64 bit)
OS: Windows 10

Sitemap:
{"_id":"scheda-cliente","startUrl":["https://privatewebsite/"],"selectors":[{"id":"Cliente Codice","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='1332:0']","type":"SelectorText"},{"id":"Provincia","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='34:554;a']","type":"SelectorText"},{"id":"Telefono","multiple":false,"parentSelectors":["_root"],"regex":"","selector":".slds-truncate span.forceOutputPhone","type":"SelectorText"},{"id":"Cellulare","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='63:554;a']","type":"SelectorText"},{"id":"Finanziabile","multiple":false,"parentSelectors":["_root"],"regex":"","selector":".slds-form-element__static span.lvm-grid-no-fade-out","type":"SelectorText"},{"id":"Note","multiple":false,"parentSelectors":["_root"],"regex":"","selector":".slds-form-element_edit span.uiOutputTextArea","type":"SelectorText"},{"id":"Cognome","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='293:246;a']","type":"SelectorText"},{"id":"CF/PIVA","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='398:246;a']","type":"SelectorText"},{"id":"Ultimo Ordine","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='377:246;a']","type":"SelectorText"},{"id":"Ultima Rata","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='415:246;a']","type":"SelectorText"},{"id":"Email","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='522:246;a']","type":"SelectorText"},{"columns":[{"extract":true,"header":"Codice Opera","name":"Codice Opera"},{"extract":true,"header":"Nome Prodotto","name":"Nome Prodotto"},{"extract":true,"header":"Data Firma","name":"Data Firma"},{"extract":true,"header":"Qtà","name":"Qtà"},{"extract":true,"header":"N.Rate","name":"NRate"},{"extract":true,"header":"Codice Cliente","name":"Codice Cliente"},{"extract":true,"header":"Cliente","name":"Cliente"},{"extract":true,"header":"Numero Ordine","name":"Numero Ordine"}],"id":"Lista Opere","multiple":true,"parentSelectors":["_root"],"selector":".cT_ListaOpereAccount table","tableDataRowSelector":".slds-table--bordered tr","tableHeaderRowSelector":"tr.slds-text-title--caps","type":"SelectorTable"},{"id":"Via","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"div[data-aura-rendered-by='675:246;a']","type":"SelectorText"},{"id":"Cap / Città","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"div[data-aura-rendered-by='677:246;a']","type":"SelectorText"},{"id":"Ultima Telefonata","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='852:246;a']","type":"SelectorText"},{"id":"Data Ultima Telefonata","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='847:251;a']","type":"SelectorText"},{"id":"Ultimo Appuntamento","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='869:246;a']","type":"SelectorText"},{"id":"Data Ultimo Appuntamento","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='856:251;a']","type":"SelectorText"},{"id":"Esito","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='911:246;a']","type":"SelectorText"},{"id":"Funzionario","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"span[data-aura-rendered-by='948:246;a']","type":"SelectorText"},{"id":"Operatore","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"div[data-aura-rendered-by='1450:246;a']","type":"SelectorText"},{"id":"Ultima Modifica","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"div[data-aura-rendered-by='1502:246;a']","type":"SelectorText"}]}
Error Message:

Exported Excel / CSV are empty

i can see data on preview mode clicking the "data preview" button but unable to export them!
also how i can add exported data to an existing file? instead of saving a single file for every exported page? ...it's possible to add this option? like "append to existing file" or having a button to click for faster export that can grab data on the page i'm viewing and appen to an existing file?
Thanks

Yes because is a private site Salesforce and you need to be logged So I've removed the uri
The problem is that the excel file (or csv file) are created but only with header columns but without data... but on screen i see that they are scraped sucesfully so i can cut&paste on excel for example but is tedious task to do it manually...

I hope the "append to file" feauture will be created so i can export faster without creating a file for every page that's absurd... aving 500.000 pages to extract

I've try with chrome and firefox same issue... seems data don't pass some kind of block but I'm logged as admin user on that pc...

On another pc it work fine ... but I need to use it on that pc so I can debug this bug if someone can guide me on how to do...

Hard to diagnose without site access but I'm guessing your selectors are specific to one page only 'cos they seem to contain a lot of random numbers, e.g.

span[data-aura-rendered-by='852:246;a']
span[data-aura-rendered-by='847:251;a']

These numbers would probably change with every new page, so your scraper won't work.

1 Like

Exactly Ieemeng I suppose this is a security measure of Salesforce CRM (https://www.salesforce.com)

...so basically I'm unable to grab data since selectors change every time...
(I've asked on another post if there is another way to select data...)