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>
<property name="template">C:\Integrity\gateway\export\Microsoft Excel\Excel Custom Gateway.xlsx</property>
Thanks by advance,
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?
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.
I am interested in knowing how we can transfer Integrity data to Power BI.
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.