topic Re: Store command qvd not working qliksesne in App Development

Store command qvd not working qliksesne

Aspiring_Developer — Wed, 12 Aug 2020 09:56:37 GMT

Hello ,

I am facing very strange issue while storing txt file in qliksense:

I have below connection:-

Now i writing the store syntax like this:-

Store Users into [lib://Site HR (ad_admin.kkishor)/HR Divisions Scorecard/Security/Users_New.txt](txt);

I have entered my connection name as well but still the txt file is not created at the location. I am not able to understand what i am missing . Can any one please help ?

@Anil_Babu_Samineni @sunny_talwar @Gysbert_Wassenaar @p_verkooijen

Thanks in advance

Re: Store command qvd not working qliksesne

tresB — Wed, 12 Aug 2020 10:04:06 GMT

Try like:

STORE Users INTO 'lib://YourConnectionName/Users_Name.txt' (txt);

Re: Store command qvd not working qliksesne

Aspiring_Developer — Wed, 12 Aug 2020 10:38:47 GMT

@tresB

I tried , it didn't worked

Re: Store command qvd not working qliksesne

Anil_Babu_Samineni — Wed, 12 Aug 2020 10:42:17 GMT

If you have further folders you need to define there. As an example, From your string. It should be like

Store Users into 'lib://Site HR (ad_admin.kkishor)/HR Divisions Scorecard/Security/Users_New.txt' (txt);

Re: Store command qvd not working qliksesne

Aspiring_Developer — Wed, 12 Aug 2020 11:57:52 GMT

@Anil_Babu_Samineni

Tried , didn't worked. It is nit creating any text file at the location.

STORE Users INTO 'lib://Site HR (ad_admin.kkishor)/HR Divisions Scorecard/Security/Users_New.txt' (txt);

Re: Store command qvd not working qliksesne

tresB — Wed, 12 Aug 2020 12:31:31 GMT

Are you getting any error message? Is there (by chance) any exit script before this line? Can you share your script snippet and the data load progress window screen shot? Also make sure that you are looking at the right folder for the stored file.

Re: Store command qvd not working qliksesne

Anil_Babu_Samineni — Wed, 12 Aug 2020 13:26:40 GMT

Can you go this folder which you created connection "Site HR (ad_admin.kkishor)" and then place one file which Qlik can read. Then go to script then go to connection and you can go to till where you want to and check If the string what you loaded and where you stored is correct? // I meant, with Slashes {i.e. Forward or Backward) as well

Re: Store command qvd not working qliksesne

stevedark — Thu, 13 Aug 2020 08:10:34 GMT

The statement you are running looks correct. You definitely need the format specifier at the end ((txt)) or it will save a QVD with a .txt extension, which will confuse things.

The most likely issue is permissions to that location.

First up, I would manually create the Security folder, as whilst it should be created by Sense it is a potential blocker.

Next copy and paste the path into a File Explorer window, and check it opens. From your screengrabs it looks like it will, but always worth checking.

The most likely issue is security on that location. Remember that when you are reading or writing in Sense it is not your own user account that is being used, rather that of the Sense server service account (you can check what this is in Services). Ensure that this user has full write permissions in that location.

If your service account has RDP access to the server, you could RDP to the server as that user account and try creating a file that way - as this will prove or disprove that security settings are the issue.

If you have a file at that location already, and that is open in Excel, that will stop the creation of a new file.

Also (to state the obvious) the table Users must have previously been created.

If you can post the error message (either copy and paste or screengrab) here that will help diagnose.

Good luck!

Re: Store command qvd not working qliksesne

Aspiring_Developer — Thu, 13 Aug 2020 12:53:00 GMT

@stevedark

Hello Steve,

Many Thank for sharing you insights.

Unfortunately, i am not getting any error.

I tried to create the txt file using qlikview and it worked. Below is the script:-

User_Final:
Load
upper(NTNAME) as NTNAME,
All_SITE.REFERENCE as SITE.REFERENCE,
upper(All_SITE.REFERENCE) as UPPERSITE,
upper(GROUPE.REFERENCE) as GROUPE.REFERENCE,
upper(ACCESS) as ACCESS,
upper(COMPAGNIE.REFERENCE) as COMPAGNIE.REFERENCE,
upper(DIVISION.REFERENCE) as DIVISION.REFERENCE,
upper(BU.REFERENCE) as BU.REFERENCE,
upper(REGROUPEMENT.REFERENCE) as REGROUPEMENT.REFERENCE,
upper(PERIMETER) as PERIMETER
resident Users;
//drop table Users;

rename Table User_Final to Users;

Store Users into [Y:\POG_Sources_Documents\HR Divisions Scorecard\Security\Users_QVTEST.txt](txt);

The above qlikview script created the txt file at location.

I created a new connection , changed the format to store to csv , still didn't worked.

Store command:- Store Users into [lib://DeleteVB (ad_admin.kkishor)/Users_New.csv](txt);

I am able to store qvd's in the location but not text files. If it is the case of permission, how can i check it from my end.

Thanks in advance

Re: Store command qvd not working qliksesne

stevedark — Thu, 13 Aug 2020 13:41:17 GMT

That is very strange that you are getting no error, but the file is not there. Also strange that the format makes a difference to whether it works.

Just to confirm, if you change both the csv and txt to be qvd the file creates correctly as you would expect?

The screenshot looks a little odd, as usually when you hit return after entering a path Sense puts each part of the path in a little box. Does this happen for you?

It's important not to put csv in the brackets at the end, as this is not a valid format specifier, it needs to be qvd or txt.

I'm wondering if Users might be a reserved word, what if you don't do the rename and store [User_Final] instead?

When the QVD is written does it have any rows? (QViewer is a quick way to check this).

Cheers,

Steve

Re: Store command qvd not working qliksesne

canerkan — Thu, 13 Aug 2020 14:16:52 GMT

Hi,

ist it possible that you just forgot to undo the commentary. I quoted your script part and marked the part i meant in red. You werde loading with Residet Users but did not drop it before you renamed your Table "User_Final". I'm not sure but this might be a reason for an error as you already have a Table called Users. So it does not get to the line where it stores your Table.

User_Final:
Load
upper(NTNAME) as NTNAME,
All_SITE.REFERENCE as SITE.REFERENCE,
upper(All_SITE.REFERENCE) as UPPERSITE,
upper(GROUPE.REFERENCE) as GROUPE.REFERENCE,
upper(ACCESS) as ACCESS,
upper(COMPAGNIE.REFERENCE) as COMPAGNIE.REFERENCE,
upper(DIVISION.REFERENCE) as DIVISION.REFERENCE,
upper(BU.REFERENCE) as BU.REFERENCE,
upper(REGROUPEMENT.REFERENCE) as REGROUPEMENT.REFERENCE,
upper(PERIMETER) as PERIMETER
resident Users;
//drop table Users;
rename Table User_Final to Users;

Store Users into [Y:\POG_Sources_Documents\HR Divisions Scorecard\Security\Users_QVTEST.txt](txt);

Re: Store command qvd not working qliksesne

Ksrinivasan — Thu, 13 Aug 2020 17:02:00 GMT

Hi,

Your Table Name is User_Final, but you have used to store as Users,

In store Code you have not mention Table name : User_Final, wrongly entered Table Name :Users, So file wont create

Store Users into [lib://DeleteVB (ad_admin.kkishor)/Users_New.csv](txt);

Re: Store command qvd not working qliksesne

Aspiring_Developer — Fri, 14 Aug 2020 07:12:39 GMT

Hello @Ksrinivasan

I have renamed the renamed the table User_Final to Users , post that storing it into txt file.

Re: Store command qvd not working qliksesne

Ksrinivasan — Sat, 15 Aug 2020 06:19:56 GMT

hi,

Just do it,

1. Create one txt file name like Test_01.txt in path
[Y:\POG_Sources_Documents\HR Divisions Scorecard\Security\

2. Create new app

3. Load Test_01 text file (now it give you proper path)

4. copy the loading file path and write store code with copy the loading file path and paste it.

5. now run and check your folder, your will be there.