topic Macro export - Encoding in QlikView

Macro export - Encoding

Mon, 28 Apr 2014 07:48:12 GMT

Hi,

We are trying to export straight table to .csv/.tab file with macro use, and I needed the file to be encoded as UTF-8.

My problem is that we export several files that are in ANSI encoding,

Therefore the Encoding type under User Preferences is set to ANSI.

The default export encoding in the document properties is set to UTF-8, it's still export as ANSI.

if anyone can help it's will be great,

Thanks!

luciancotea — Mon, 28 Apr 2014 07:59:31 GMT

I tested in the interface (right-click on table -> Export...) and file is saved correctly (as stated in User Preferences -> Export)

Maybe you can post your macro to replicate the problem.

Mon, 28 Apr 2014 08:09:51 GMT

That's correct, this action is exported as stated in user Preferences,

I need to export the file like it's stated in the document properties...

luciancotea — Mon, 28 Apr 2014 08:28:36 GMT

User Preferences supersedes Document Settings.

But you can specify encoding using macro:

ActiveDocument.GetSheetObject("CH01").Export "D:\pivot.csv", ",", 65001, false

Mon, 28 Apr 2014 09:21:50 GMT

Amazing, thnks