Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load from Google Docs - Load Fail

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

Tags (1)
Community Browser