Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Export rows in Access Point

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!

13 Replies
Highlighted
Not applicable

Hello, did you try with this?

Regards,

Santiago.

Highlighted
Specialist
Specialist

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

Highlighted
Not applicable

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:

GroupDirectory
QVDC: \QLIKVIEW\QVD
LOADSC: \QLIKVIEW\LOAD
LOGSC:\QLIKVIEW\LOGS
APLICATIONC:\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.

Highlighted
Specialist
Specialist

Ok! Now If I do Reload QlikView Thrown a lot of errors. Can you help me to manage the code?

Thanks!

Highlighted
Specialist
Specialist

My Scenario is:

C:/Windows/Desktop/QlikView

Under this folder I have all my QlikView Documents.

Highlighted
Not applicable

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.

Highlighted
Specialist
Specialist

Hi, Qlikview gives trouble with the table DocumentSummary.

I Attached a picture with the error. and the log.

Thanks.

Highlighted
Not applicable

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 (XmlSimple, Table is [DocumentSummary/LineageInfo])

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.

Highlighted
Specialist
Specialist

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