cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Integrity LM: Server Gateway and Reports

Re: Integrity LM: Server Gateway and Reports

Hello,

 

I'm interested in Custom Gateway, notably in the Excel Export.

I've downloaded the latest CustomGateway on gitHub, and installed it.

But i've no idea on how to configure the "export-config" in gateway-tool-configuration.xml so that it can export an Excel file instead of a Word one (the exporter Id). Can anybody help me please ?

 

This is what I tried, with some other exporter id values such as "MSEXCEL", "EXCEL", "XLSX"

 

  <export-config info-name="Test Custom Gateway Excel">
   <name>Excel Custom Gateway</name>
   <description>Excel Custom Gateway</description>
   <exporter id="excel">
    <property name="template">C:\Integrity\gateway\export\Microsoft Excel\Excel Custom Gateway.xlsx</property>
   </exporter>
   <extension>xlsx</extension>
   <gateway-configuration-name>EXTERNAL_EXPORT-DEFAULT-DEFAULT</gateway-configuration-name>
  </export-config>

 

Thanks by advance,

 

Thomas WIATR

Highlighted

Re: Integrity LM: Server Gateway and Reports

Hi Thomas,

 

such a Gateway XML entry would look like this:

 

      <export-config>
         <name>Export Documents (Excel)</name>
         <description>Excel Export Test Suite with Macro</description>
         <exporter class="com.ptc.services.gateway.exporter.excel.ExcelExport">
            <property name="template">http://localhost:7001/gateway/export/Microsoft Excel/Template_Excel_Import_Test_Suite.xlsx</property>
            <property name="type">something</property>
         </exporter>
         <extension>xlsx</extension>
         <display-fields>
            <display-field>DOCUMENT_TITLE</display-field>
         </display-fields>
         <gateway-configuration-name>Excel Export Test Document</gateway-configuration-name>
      </export-config>

This "something" has to be set to the Excel Export Type that you want to have as an output. Valid types are coded in the com.ptc.services.gateway.exporter.excel.ExcelExport, which is a Java Class in IntegrityCustomExport.jar.  IntegrityCustomExport.jar has to be registered in the gateway.lax.

 

So, the IntegrityCustomGateway as such is not enough to get Excel.

 

Does this clarify?

Volker

 

 

Re: Integrity LM: Server Gateway and Reports

Hi,

 

Thanks a lot for your quick answer.

It 's clear to me (at least it seems to be ... I hope I didn't misunderstand !).

I'll test that this week.

 

Thanks again

 

Thomas

 

 

Re: Integrity LM: Server Gateway and Reports

Hi Volker,

 

I am interested in knowing how we can transfer Integrity data to Power BI.

 

Regards,

Chirag Agarwal

Re: Integrity LM: Server Gateway and Reports

That is functionality we would like to explore as well.  We were also interested in looking into the use of Amazon Quicksight.  https://aws.amazon.com/quicksight/ since we utilize AWS for some of our environments.  Curious to see if there is a way to do that as well.  Not an IT person, but as a business owner of the platform, want to get churn data, time versus change information.