Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
A simple Question,
I have a thousands of documents running into my access point. So my list is huge. is there a way to export all rows (Names of documents) to Excel?
Thanks!
Hello, did you try with this?
Regards,
Santiago.
Hi,
Thanks for you reply.
where goes the path? In the variable?
For example if I call a folder C:/Windows/Desktop/QlikView where is found it all QlikView documents
In the variable I have to put C:/Windows/Desktop/QlikView?
I need to extract to excel - number of tables, fields, registers, variables etc
Thanks
Hi, as in the example i got a path C:\Qlikview, so in second tab called 'Configuration', i put C:\Qlikview on directory and 'production' on Group.
Under C:\Qlikview i got 4 folders called QVD,APPS,LOGS and LOAD then when i made a load script all my qvd´s, and qvw´s files appear on the next corresponding tabs under production group. Then if i want to make a group of these, i should have to put in the second tab something like:
Group | Directory |
QVD | C: \QLIKVIEW\QVD |
LOADS | C: \QLIKVIEW\LOAD |
LOGS | C:\QLIKVIEW\LOGS |
APLICATION | C:\QLIKVIEW\APLICATION |
Then I could export any chart of those tabs to excel.
I hope this works for you.
Sorry about my english, isn't my native language.
Regards,
Santiago.
Ok! Now If I do Reload QlikView Thrown a lot of errors. Can you help me to manage the code?
Thanks!
My Scenario is:
C:/Windows/Desktop/QlikView
Under this folder I have all my QlikView Documents.
What kind of errors?
You just have to place C:/Windows/Desktop/QlikView instead C:\QLIKVIEW. Could be a permission trouble, can you post a screen?
I test this qvw on my download folder and in my desktop like in this picture, and still working fine.
Another thing, when i tested on another machine at first time i wrote D:\QLIKVIEW and made a reload then i had a lot of errors, then i saw that directory was black, i mean the words on chart, so i press enter and those changed to green, i did a reload and run with any problem.
Check this, if still not working let see us a screenshot.
Regards,
Santiago.
Hi, Qlikview gives trouble with the table DocumentSummary.
I Attached a picture with the error. and the log.
Thanks.
Parece ser un error en la dirección o estructura de directorio.
Aquí ya marca el primer incoveniente. Intenta cambiando / por \ o el inverso de acuerdo al simbolo que hayas usado en la primera prueba.
..."///d:/integraciones/documentos/ARPU.qvw."
...
FROM
07/08/13 10:11:08: Error: An invalid character was found in text content.
07/08/13 10:11:08: On line number: 1. On column number: 2. System ID:
file:///d:/integraciones/documentos/Volumetria.qvw.
...
y marca el mismo para cada documento que encuentra. Por es creo que podría ser asunto del simbolo '/' y '\' prueba tomando unos dos documentos, los más livianos al C:\Qlikview o D:\Qlikview o al escritorio incluso, solo con motivo de hacer una prueba fácil.
Saludos,
Santiago.
Hola,
Hice la prueba y me arroja los mismos errores. Lo que hice fue generar un nuevo QVW guardado en una carpeta llamada pp. Luego puse la dirección ..//pp.qvw. Con un Inline. (Prueba Simple). Te adjunto el QlikView.
pd: Intenté con los dos símbolos y nada / \
Gracias,
Saludos