Using your HTML I tried with a table in one of our HTML Pages and found you could alias your header names in the load script e.g
@!1 AS "Aangemaakt",
@!2 AS "Recruiter"
and use your exclude rowno 1 to get a clean table. How to get at paginated data in a table now that would be interesting.
Hope this helps
Like you say its a one time issue on setup of your script.
I think the issue they will have is HTML Table headers can contain a lot stuff not needed for the import.
Mine for example cam through as
[',25,document.getElementById('joblistgriduserhiddenfields').value,''); " class="tableheader"> CRM No] AS "CRM#",
So tricky to automate for each site will be coded different.
Please mark any replies that have been helpful/correct for other users of the community to follow.
Hi henkewillemsen! I came across the same situation and extended your initial solution a bit, combining it with a suggestion from The specified item was not found.. This way you don't have to create the aliases manually.
My approach looks like this:
//load the table from the web page, except the unwanted first row
(html, utf8, no labels , table is @1)
//iterate over values in the first loaded row (=the source table second row that contains
//the field names I want) to build a mapping table
for f = 1 to NoOfFields('tmpTable')
let vDisplay = FieldValue('@'&$(f),1);
mapping load * inline [
//rename the nameless fields using the mapping table
Rename Fields using mapNames;
//prune the no longer needed first row from the table
NoConcatenate // needed to avoid this load to collapse into the already loaded table
load * resident tmpTable where RecNo()>1; //prune first row, now used as field names
Drop Table tmpTable;