topic Re: Export to semicolumn csv in accesspoint in QlikView

Export to semicolumn csv in accesspoint

kris_vliegen — Tue, 10 Apr 2018 09:43:23 GMT

Hi all,

I would like to export a straight table to a semicolumn separated csv-file in accesspoint.

If possible I would like to do this via a button.

If I use the right mouse button and export I get a comma separated csv.

Who can help me?

regards,

Kris

Re: Export to semicolumn csv in accesspoint

olivierrobin — Tue, 10 Apr 2018 10:03:57 GMT

hello

if you right click to export, you can choose between file formats an delimiters

.csv

.txt

and commas, semi-colons, tabulations ....

Re: Export to semicolumn csv in accesspoint

olivierrobin — Tue, 10 Apr 2018 10:05:35 GMT

and in the same manner, if you choose export action in a button, you can configure several options when choosing file as destination of the export

Re: Export to semicolumn csv in accesspoint

kris_vliegen — Tue, 10 Apr 2018 11:22:45 GMT

Do you mean in the access point?

If I right click on the straight table and choose Export

I have to click "Press here"

And than Qlikview downloads a csv-file.

But this file is comma separated. not Semicolon separated.

Re: Export to semicolumn csv in accesspoint

olivierrobin — Tue, 10 Apr 2018 11:59:53 GMT

oups

i tried in desktop not in browser

Re: Export to semicolumn csv in accesspoint

kris_vliegen — Tue, 10 Apr 2018 12:06:20 GMT

If I choose the export action in a button.

It opens a new tab with the data.

And I've selecte the SKV-filetype but it creates a comma-separated table.

In the browser I can't find a save-button and I can't find the saved file.

Re: Export to semicolumn csv in accesspoint

marcus_sommer — Tue, 10 Apr 2018 12:28:15 GMT

AFAIK the used delimiter is related to the regional settings from the OS. Therefore a change might be work but be carefully because this are global settings and it could have various side-effects (by us with german settings the delimiter is the semi-colon).

Another possibility might be that this could be overwritten within the settings.ini but I don't know which setting must be added or changed. You could try a search for it and/or playing with various settings from the easter egg (within the desktop client) and then looking in the local settings.ini - but it's an ugly trial & error game ...

Therefore it might be easier to change your afterwards processing to accept commas and/or to detect the delimiter and to branch in the appropriate data-extracting.

- Marcus

Re: Export to semicolumn csv in accesspoint

kris_vliegen — Thu, 17 May 2018 08:18:40 GMT

Hi All,

I've created one string where I insert all the values seperated with a ";".

This is all working fine but if there is one value with a comma in he put a double quotes in the beginning and the end of the record.

Is there a way I can disable this?

Regards,

Kris

Re: Export to semicolumn csv in accesspoint

marcus_sommer — Thu, 17 May 2018 08:55:42 GMT

You could try it with no quotes within the file-format like: (txt, delimiter is ';', no quotes)

- Marcus

Re: Export to semicolumn csv in accesspoint

kris_vliegen — Thu, 17 May 2018 08:59:58 GMT

Hi Marcus,

this you can do when you do a store statement in the script.

The problem I have is that the user is creating a csv in the access-point.

regards,

Kris

Re: Export to semicolumn csv in accesspoint

marcus_sommer — Thu, 17 May 2018 09:08:26 GMT

Yes, I should have read the post from the beginning. How many records are usually exported? If this are not too many it might be an option to print this table respectively the already concatenated single column-table. This opened the table within another browser-tab and could with Ctrl A | C | V be copied in text-file.

- Marcus

Re: Export to semicolumn csv in accesspoint

kris_vliegen — Thu, 17 May 2018 09:41:28 GMT

We have a SAAS-environment, so we rent out our keys.

It is a customer that askes for it.

It would be better if it could go in 1 flow.

I've also tried with a button and under actions -axternal - Export.

If I choose as filetype a csv qlikview is creating a csv-file in "my downloads"

If I choose a SKV he is opening the file in another tab in my browser.

But also as comma-seperated-file.

I've no idea why the skv is opening in a brower and why it is also comma-seperated.

regards,

Kris

Re: Export to semicolumn csv in accesspoint

marcus_sommer — Fri, 18 May 2018 07:54:41 GMT

I think I would go by extending the process-logic of checking the output-format (reading the header and counting commas and semi-colon would be enough to identify the used delimiter) and then branching into the appropriate routine (it might be just one routine and the preceeding checking is adjusting a variable).

Also possible would be to use an extra routine between export and the further processing maybe with a batch-file which just replaced commas, semi-colon, quotes like needed.

- Marcus

Re: Export to semicolumn csv in accesspoint

kris_vliegen — Tue, 22 May 2018 07:33:03 GMT

Hi Marcus,

what do you mean with extending the process-logic?

regards,

Kris

Re: Export to semicolumn csv in accesspoint

marcus_sommer — Tue, 22 May 2018 08:00:27 GMT

I assume that the csv-output is used in any other tool and that this tool expect a certain format. If the output-format from Qlik couldn't be sufficient adjusted there is in general the possibility to change the expect input-format from this tool and/or extending it with some logic that it is (nearly) meaningless which format the csv had because this tool checked the format and applied to correct loading/extracting-routine.

What happens with these csv-data - where and how are they loaded?

- Marcus

Re: Export to semicolumn csv in accesspoint

kris_vliegen — Fri, 25 May 2018 07:58:50 GMT

At the moment I have 2 different cases with the same Csv-format.

The first one I don't know where they use it for.

The second one is for importing the data in a CRM-tool.

So it would be best if we get the data in the correct format out of Qlikview.

A semicolon-seperated CSV with no double quotes around the records with a comma in.

Regards,

Kris

Re: Export to semicolumn csv in accesspoint

marcus_sommer — Fri, 25 May 2018 11:24:48 GMT

Maybe it's an alternatively to write these data instead of exporting them and you coud adjust everything like you want. Here an example what is meant: Re: Export to CSV with quotation marks.

- Marcus

Re: Export to semicolumn csv in accesspoint

kris_vliegen — Fri, 25 May 2018 12:48:12 GMT

And is this working in the access-point?

Re: Export to semicolumn csv in accesspoint

marcus_sommer — Fri, 25 May 2018 13:00:39 GMT

With the IE plugin yes - with the AJAX client I doubt. Here might be an extension possible like SQL Writeback from QlikView extension object. But I think the above mentioned possibilities to adjust the afterwards processes would be easier than an extension.

- Marcus