Script / Macro to read Windows tags on files

mall1m — Sat, 16 Nov 2024 20:46:53 GMT

Dear everybody,

I'm trying to find a way to extract "windows file tag" from thousands of file

these tags are the one you can see when you right qlik on file properties in "detail" tab and they can be applied on various field format (image, office document etc)

I tried with attributes() function but it doesn't fit my needs (it extracts EXIF properties but not the windows tags)
this post here may provide a solution combining a module with objFile.attributes but i'd like to avoid using module
another solution should be to execute a powershell script to extract tags into a readable file then read this file with qlik (in my case powershell is more acceptable than qlik macro module)

Does anybody can imagine another solution ?

Thanks in advance

Re: Script / Macro to read Windows tags on files

Brett_Bleess — Mon, 01 Jul 2019 19:50:54 GMT

Your best option here would be to look on Microsoft Communities for a Power Shell script that could pull this and dump it to a csv file etc. and then pull that into QlikView. I would not recommend trying to do this via the QlikView Edit Module either, not likely to function nearly as well as a separate PowerShell script dumping things to the csv file(s) and you reading those in via a load script. My two cents on this one.

Regards,
Brett

topic Re: Script / Macro to read Windows tags on files in QlikView

Script / Macro to read Windows tags on files

Re: Script / Macro to read Windows tags on files