topic Re: BINARY LOAD - why doesn't it work? in QlikView

BINARY LOAD - why doesn't it work?

datanibbler — Thu, 10 Oct 2013 14:22:56 GMT

Hi,

I will have to implement some complex KPI into one of my apps. It already exists - just not quite correct and a bit outdated - in another, so I thought I'd begin by copying that.

It includes a BINARY LOAD. I copy-pasted that into the script in my app as the very first command on the "Main" tab - but it didn't work. So I deleted it and redid it using the wizard - but it still won't work.

The context is this:

- The datamodel is on the same server as the app, just in another directory on the same level

- I am generally using relative paths in my apps
=> The code is >>> Binary ..\02_datamodel\datamodel_syncreon_mgmt.qvw; <<<

When I used the wizard, it put the whole thing into square brackets - but it still didn't work, so I removed them for now.

Can someone help me here?

I guess once I have this working I will have to do a bit of consolidating for I have several other tables already in my app, among them a master_calendar that will probably be redundant - but first I have to get it working.

Thanks a lot!

Best regards,

DataNibbler

Re: BINARY LOAD - why doesn't it work?

rustyfishbones — Thu, 10 Oct 2013 14:29:06 GMT

Hi Friedrich,

Did you check in Document properties to see if Prohibit Binary Load is Clicked

Re: BINARY LOAD - why doesn't it work?

swuehl — Thu, 10 Oct 2013 14:31:33 GMT

'Not working' is not a good error report.

Do you get an error message? If so, what does it say?

Re: BINARY LOAD - why doesn't it work?

datanibbler — Thu, 10 Oct 2013 14:36:23 GMT

Hi,

@ Alan

No, I haven't checked, I will do so now, but why should I have activated that...

@ swuehl

The error message in the script_execution_window is just "Unknown command" which is quite strange after using the wizard to insert it...

Thanks a lot!

Best regards,

DataNibbler

P.S.: I am unsure whether it would actually be so good an idea to use a BINARY LOAD or whether I should instead load just those qvd files I really need - BINARY LOAD is really fast, but still I'll end up with a lot of tables I don't need for this one KPI and which I will just have to delete - I don't know where the balance is.

Re: BINARY LOAD - why doesn't it work?

swuehl — Thu, 10 Oct 2013 14:40:01 GMT

I only get this error message if binary statement is not on the very first line of your script (line 1), before all the set statements, etc. The wizard should insert it at this line, I am sure you don't have copied the binary statement to another place, right?

Re: BINARY LOAD - why doesn't it work?

rustyfishbones — Thu, 10 Oct 2013 14:41:30 GMT

Hi Friedrich,

I assume this must be unticked, otherwise why have the option!

must check if that works too!

Regards

Alan

Re: BINARY LOAD - why doesn't it work?

Anonymous — Thu, 10 Oct 2013 14:43:45 GMT

Maybe there is a hidden script tab before the Main tab (?). In this case the binary is not the first.

Re: BINARY LOAD - why doesn't it work?

datanibbler — Thu, 10 Oct 2013 14:43:54 GMT

Hi,

@ swuehl

No, I have it on the very first line of the "Main" tab already, before everything else.

@ Alan

I guess it must be unticked - but it is so by default, no? It's unticked in my app, anyway.

Re: BINARY LOAD - why doesn't it work?

swuehl — Thu, 10 Oct 2013 14:44:22 GMT

Just a note regarding the prohibit binary load option:

You need to control this option within the application you are trying to binary load, not the one you are inserting the statement.

Re: BINARY LOAD - why doesn't it work?

rustyfishbones — Thu, 10 Oct 2013 14:45:40 GMT

Thanks for clearing that up swuehl!

Re: BINARY LOAD - why doesn't it work?

datanibbler — Thu, 10 Oct 2013 14:48:05 GMT

Dito!

So that's more a data_protection thing, is it? I'll do that in my HR app right away in that case to prohibit anyone from loading that personell data.

Different question: What do you think of the speed_of_loading thing? When I need only, say, 30% of the tables which are in the datamodel, would it still be faster to do the BINARY LOAD instead of loading individual qvd files?

Re: BINARY LOAD - why doesn't it work?

datanibbler — Thu, 10 Oct 2013 14:50:37 GMT

Hi Michael,

Hit!

There is an SQL query from our personell database like in most of my apps and I put that in a hidden script which only I have the key to so noone can glean the logon_data for the database.

So I have to move the BINARY command to the very top of that hidden script?

Re: BINARY LOAD - why doesn't it work?

swuehl — Thu, 10 Oct 2013 14:51:27 GMT

Yes, binary statement need to be the first statement in the (complete) script.

Re: BINARY LOAD - why doesn't it work?

CELAMBARASAN — Thu, 10 Oct 2013 14:52:13 GMT

Does your app has hidden script?

if it has hidden script because it executed at the first. So you have to keep the binary load statement inside the hidden script.

Re: BINARY LOAD - why doesn't it work?

Anonymous — Thu, 10 Oct 2013 14:54:23 GMT

Exactly

Re: BINARY LOAD - why doesn't it work?

Sat, 12 Oct 2013 22:18:54 GMT

But you might not want to do that. What if someone want/need to change the binary statement?

Have the SQL query in a QVD loader and create a personell QVD and set security (file security,hiden script etc...) on the QVW that create the QVD.

Read the QVD after the binary load in a normal fashion. No need for the hidden script in the main QVW,,,

Hans