4 Replies Latest reply: May 30, 2011 7:37 AM by Björn Wedbratt RSS

    Load excel Files

      We need to load data from excel.

      We used the LOAD instruction

       

       

       

       

       

       

       

       

      LOAD field1,

           field2

      FROM

      [Prova.xls]

       

      If the file is on the same server where QlikView Server is installed everything works.

      Otherwise if the file is on the network , an error is returned.

      Please note that QLikview has been installed with a local account and the services are running using that local account.

      Is this the reason? Can someone help?

      Thanks

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

        • Load excel Files
          Kaushik Solanki

          Hi,

           

              If you are accessing the file over the network.

              You must specify the address of that computer.

           

              For example

            

          LOAD A,

               B,

               C

          FROM

          [\\VARUN-PC\Unseen Movies\QV\Tableand fields.xlsx]

          (ooxml, no labels, table is Sheet1);

           

              Here Varun-Pc is the comp on which you have the file.

           

             Make sure that you include \\ before the name or address of the computer.

           

             Try this. This will work

           

          Regards,

          Kaushik Solanki

            • Load excel Files

              Hi Kaushik,

              yes, the path is specified.

              i guess that the problem is that QlikView has been installed with a local account. the QLikView services starts with this account. and this account can't reach the folder where the excel is, it has not the permissions to access it.

              Is there a workaround?

              Many thanks

              Martina

                • Load excel Files
                  Daniel Rozental

                  You could map a folder using a network user whose password doesn't expire.

                   

                  I believe there are ways to setup local user access to network resources but it's way more complicated than my basic windows admin skills, you might want to try a windows admin forum.

                  • Load excel Files
                    Björn Wedbratt

                    As Daniel suggested, you can map the folder using an account with permissions to access the folder.

                    Another work-around could be to create a local account on the file-server (where you host the xls-file) with the exact same name and password as the local account running the services on QVS. As you're using local accounts, Windows will use NTLM as the authentication protocol between the resources, and with the exact same name and password, the hash generated will be the same on the two machines. This is a way to share resources in a Workgroup, where no domain controller is present.