Parsley Extension

[Pallavi]

Hi Team,

I want to read .xlsx file for that I am trying to import Parsley extension in thingworx.

I have downloaded the Parsley from Github. 

But While importing I am getting .jar file conflict error. So I tried to below steps to resolve this issue.

1) Stopped Tomcat.

2) Deleted the existing .jar file from Thingworx/extension folder.

3) There are multiple extension are using the same .jar file , so i have deleted the .jar file from the particular       extension folder also.

4) After I tried to Start the Tomcat , Tomcat is not getting started.

5) Once I revert back my changes it is started.

Can you please help me with this issue.

Thanks,

[VladimirRosu]

I will start my reply by stating that the Parsley extension is not a PTC supported product - it was developed by a former PTC employee.

Regardless, the easiest way to try and solve this situations is by removing the respective jar files from the Extension zip file itself (not from other folders) and from the metadata.xml, where those jars are referenced.

Once that's done, and if the existing JAR libraries are compatible with the extension functionality, you can retry the extension import and it should work fine.

[Pallavi]

Hi @VladimirRosu ,

I have tried that solution , deleted .jar file from Parsley extension from lib folder and updated the metadata.xml also. 

The extension is validated and imported successfully but the service ParseXLSX is not woking.

Error : Unable to Invoke Service ParseXLSX on Parsley : org/apache/poi/util/StaxHelper 

Thanks

[VladimirRosu]

Hi @Pallavi ,

I will say this is an unfortunate situation because you're exactly in the situation I wrote in bold above. Specifically, the "org.apache.poi.util.StaxHelper" class was introduced in Apache POI version 3.17.

Your option is to rework the code to use the XMLHelper, which is available before 3.17 - you need to download the source code and rebuild the extension in this situation.

[Pallavi]

Hi @VladimirRosu ,

I dont have any knowledge to rebuild the extension .

Is there any other solution to read .xlsx file in thingworx?

Thanks,

[VladimirRosu]

You can always try to convert the XLSX files in a CSV format, that's easily readable without any library.

On the other hand rebuilding the extension requires lightweight Java programming knowledge and most information is available here. Everything's done in Eclipse. I suggest reaching out to a colleague who has knowledge around this, and, since Extensions are a very important part of the platform, investing some time into how to build Java extensions in ThingWorx. I'm recommending this because while 99% of the time you don't need to create an Extension, there are situations like this when such knowledge is worth its weight in gold

[Rocko]

To my knowledge, TWX does not come with POI libraries. So if you have a conflict, that means some other extension you installed uses POI in another version. So you could also try to find out which extension it is and a) remove it or b) remove the POI libs from that extension instead of the parsley extension.

[PEHOWE]

Hello @Pallavi , 
I will start my reply by stating that the Parsley extension is not a PTC supported product - it was developed by a former PTC employee.

The library which makes the extension possible is an Open Source Library by the Apache Software Foundation Project POI. 

Depending on the version of ThingWorx you are using and the Version of Java The library included in the extension may be incompatible. I would recommend finding the proper version of the Apache POI libraries and inserting them into the extension.

This could just work. The other would be to configure the Eclipse Development Environment and rebuild the extension including the proper libraries.

 I have done a couple of different projects with the POI library so am willing to try to provide suggestions.

HTH,

Pehowe