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
//Healthy Home Wellington Leads - Sheet "Leads"
[Tenant/ Owner] as [Tenant/Owner],
[Built Before 2000?],
HNZ? as HNZ, //renamed for consistency
[Comments e.g. reason for not booking],
[Marketing Souce] as [Marketing Source],
[Booking date] as [Booking Date],
[Under 18 or 65+ In Home?],
[Built Before 2000?] as [Built Before 2000? 2],
'Healthy Homes - Wellington' as DocName
(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?