Hello,
I'm loading some data from Google Docs, which loads data fine when running from QV 11 installed on my local machine and also loads fine when reloading manually from QV 11 installed on our QlikView server.
Below is the script (I've removed part of the key).
//Loading data from Google Docs
PROSPECTS:
//Healthy Home Wellington Leads - Sheet "Leads"
LOAD
Surname,
[First Name],
Address,
Suburb,
City,
Postcode,
Phone,
Mobile,
[Work Number],
Email,
[Tenant/ Owner] as [Tenant/Owner],
[Landlord Name],
[Landlord Number],
[Landlord Address],
[Landlord Email],
[Built Before 2000?],
CSC,
HNZ? as HNZ, //renamed for consistency
Outcome,
[Date Called],
[Comments e.g. reason for not booking],
[Marketing Souce] as [Marketing Source],
[Booking date] as [Booking Date],
Assessor,
[CRM Number],
[Date Entered],
[Ethnic Group],
[Health Problems?],
[Under 18 or 65+ In Home?],
[Built Before 2000?] as [Built Before 2000? 2],
'Healthy Homes - Wellington' as DocName
FROM
[https://docs.google.com/a/righthouse.co.nz/spreadsheet/pub?key=0AgZcvpXbJuyUdEUV0RUZobEE&single=true...]
(txt, utf8, embedded labels, delimiter is ',', msq);
The problem I have is when trying to publish to the Access Point, reloading through publisher. It fails every time with the below script lines immediately after trying to load the above sheet...
30/06/2014 00:02:59: Error: Field not found - <Surname>
30/06/2014 00:02:59: General Script Error
30/06/2014 00:02:59: Execution Failed
30/06/2014 00:02:59: Execution finished.
When I reload the doc manually on this server in QV 11 it runs fine, but when attempted through publisher it fails.
Anybody got any advice/tips on why this might be?
Thanks,
Adam
