I'm pretty new to using Qlikview and I don't know the proper terminology for everything, so please correct me if I'm talking nonsense. Also please excuse me if I'm just not making sense in general. It's finals week and I'm running on two hours of sleep and half of a red bull.
So I'm the intern here at work and I was told that we need to start keeping metrics on an automated process. I can't change existing code to add logging, but I can harvest data from the files in the output folders for these processes. I know I can generate a .csv easily with a perl script, but I'd like to keep everything from data generation to display in one place.
So I've got three main questions:
1. Can a load script read file metadata such as creation date and time? Basically, can it generate fields like "File name" "Date" etc.
2. Can a load script run through each file in a folder and pull information based on xml tags? I would also need fields based on "Author" "Department" etc.
3. Can I set a button to re-run the load script?
3a. Does Actions -> External -> Reload do what I think it does?
If all that is possible, how slow would it be? I'm needing this to be relatively quick. Though if I can't do the above, or if it's too slow, then I suppose I could have the sheet open a URL to a perl script, or launch an external application to generate a file, which I could then load. I'm just not sure what would be the more efficient.
