is there a way to Export a query as Excel by scriptblock to a Folder in COMOS PQM

Couldn't find anything on this but i know it can be done

@Moderator, please help me delete this (intermediate) post.

AutoGen_3796202

Similar was discussed. Does the thread provide any help to you

https://support.industry.siemens.com/tf/ww/en/posts/export-query-as-excel-by-script/214042/?page=0&pageSize=10

This is not the same, that query saves to a c: drive or a computers locally, where as the one i am trying to build must store the file in Comos PQM

@Moderator, please help me delete this (intermediate) post.

AutoGen_3796202

Currently, I do not have access to test it using DVM.

But may be you can try,

a.Documents.CreateNewWithName("Test1")

Set a.Documents.item("Test1").Cobject = C

a.Documents.item("Test1").DocumentType = b.DocumentType

[where b is xls file in COMOS]

Replace the excel file with new export excel file [a.Documents.item("Test1").FullFileName] using:

a.workset.CopyFile (p1, p2, p3)

This is just a twisted way, but other friends can offer you cleaner script.

Shami Gupta

 Thanks will play around with it, its more debugger based, what i need is query based Scriptblock action to export the query to excel but into the PQM

RuAvAnD

 

AutoGen_3796202

Currently, I do not have access to test it using DVM.

But may be you can try,

a.Documents.CreateNewWithName("Test1")

Set a.Documents.item("Test1").Cobject = C

a.Documents.item("Test1").DocumentType = b.DocumentType

[where b is xls file in COMOS]

Replace the excel file with new export excel file [a.Documents.item("Test1").FullFileName] using:

a.workset.CopyFile (p1, p2, p3)

This is just a twisted way, but other friends can offer you cleaner script.

Shami Gupta

 Thanks will play around with it, its more debugger based, what i need is query based Scriptblock action to export the query to excel but into the PQM

 I am not getting this to work :-(