0 Replies Latest reply: Jun 29, 2014 7:42 PM by Adam Major RSS

    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&gid=0&output=csv]

      (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