Loading from Website Script

BN — Sat, 31 Jul 2021 17:59:42 GMT

Hello Everyone , newby here

I am trying to Load Data from https://www.baaa-acro.com/crash-archives but i keep getting an unkown error. With this code i got only 260 lines fetched

for i=1 to 1375

let vPage= 'https://www.baaa-acro.com/crash-archives' & if($(i)>1,$(i),'') & '.htm';

LOAD
//Image,
"Date",
Operator,
"A/C Type",
Location,
Fatalities,
Registration
//F8
FROM [lib://Aviation-Crashes]
(html, utf8, embedded labels, table is @1; //filters(

I then tried this code and only got to 1305 lines.

FOR vsCounter = 1 TO 1375

LET vsPage = If($(vsCounter) = 1, 20, 27488 + $(vsCounter) - 1);

LET vsURL = 'https://www.baaa-acro.com/crash-archives' & '$(vsPage)' & '.htm';

SET ErrorMode = 0;

LOAD

@2 AS [Date],

@3 AS [Operator],

@4 AS ["A/C Type"],

@5 AS [Location],

@6 AS [Fatalities],

@7 AS Registration

FROM [lib://Aviation-Crashes]
(html, utf8, no labels, table is @1);

// WHERE Recno() > 4;

SET ErrorMode = 1;

I am not sure what the error is, if someone, anyone can help me please.

topic Loading from Website Script in Search the Community

Loading from Website Script