CSV Import Tool

[KaelLizak]

In my opening blog post, I asked for feedback on what content MKS Customer Community users would like to see migrated to to Planet PTC. Matt Giltaji had asked for a posting of the CSV Import tool. After some digging, I believe I've found the files Matt had referred to. I have attached them to this post.

[sdeshpande]

Hi Kael,

Does this still work?

I've been trying to get a working import for excel data and the Excel Integration doesn't work for us because we're on Office 2016.

I tried the CSV import tool according to the instructions in that document.

However, after selecting the file and previewing the data, when I select "Configure Field Mappings" the Data Preview window closes and nothing else seems to happen.

The command prompt shows the following, but I get no connection request for the server so I cannot move forward and map the fields and therefore import the data.

C:\Program Files (x86)\Integrity\IntegrityClient10\lib>set IC_HOME=C:\Program Fi

les (x86)\Integrity\IntegrityClient10

C:\Program Files (x86)\Integrity\IntegrityClient10\lib>cd /d "C:\Program Files (

x86)\Integrity\IntegrityClient10\lib"

C:\Program Files (x86)\Integrity\IntegrityClient10\lib>"C:\Program Files (x86)\I

ntegrity\IntegrityClient10\jre\bin\java.exe" -Xms256m -Xmx512m -cp importCSV.jar

;opencsv-2.2.jar;mksapi.jar com.mks.services.utilities.csv.CSVImporter

Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: com.mks.api.

1. IntegrationPointFactory.getAPIVersion()Ljava/lang/String;

        at com.mks.services.utilities.csv.APISession.<clinit>(APISession.java:23

)

        at com.mks.services.utilities.csv.CSVTablePreview.mapButtonClicked(CSVTa

1. blePreview.java:264)

        at com.mks.services.utilities.csv.CSVTablePreview.access$5(CSVTablePrevi

1. ew.java:251)

        at com.mks.services.utilities.csv.CSVTablePreview$6.actionPerformed(CSVT

1. ablePreview.java:156)

        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:20

22)

        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav

a:2346)

        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel

.java:402)

        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259

)

        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL

1. istener.java:252)

        at java.awt.Component.processMouseEvent(Component.java:6525)

        at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)

        at java.awt.Component.processEvent(Component.java:6290)

        at java.awt.Container.processEvent(Container.java:2234)

        at java.awt.Component.dispatchEventImpl(Component.java:4881)

        at java.awt.Container.dispatchEventImpl(Container.java:2292)

        at java.awt.Component.dispatchEvent(Component.java:4703)

        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898

)

        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)

        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)

        at java.awt.Container.dispatchEventImpl(Container.java:2278)

        at java.awt.Window.dispatchEventImpl(Window.java:2739)

        at java.awt.Component.dispatchEvent(Component.java:4703)

        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:746)

        at java.awt.EventQueue.access$400(EventQueue.java:97)

        at java.awt.EventQueue$3.run(EventQueue.java:697)

        at java.awt.EventQueue$3.run(EventQueue.java:691)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo

1. main.java:75)

        at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo

1. main.java:86)

        at java.awt.EventQueue$4.run(EventQueue.java:719)

        at java.awt.EventQueue$4.run(EventQueue.java:717)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo

1. main.java:75)

        at java.awt.EventQueue.dispatchEvent(EventQueue.java:716)

        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre

1. ad.java:201)

        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.

java:116)

        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre

1. ad.java:105)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

        at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

Is this a known issue? Is there any solution?

Thanks in advance!

[KaelLizak]

Hello Sourabh Deshpande‌

Have you tried storing credentials in the client of the workstation being used to run the script?  I suspect this script won't prompt for connection details.

Regards,
Kael

[VolkerEckardt]

Hello,

the java error might be caused by a missing mksapi.jar, or a different mksapi.jar (Integrity) version.

Were you able to solve the reported issue already?

Volker

[apost]

We recently upgraded to 12.3.0.0 and I haven't been able to reconfigure the csv loader to work again. I was hoping the excel integration could be used instead but it cannot be used to import structure which is very useful and the csv loader was very good at. I've tried to adapt the importcsv.bat file but I am currently stuck with the error message: Error: Could not find or load main class com.mks.services.utilities.csv.CSVImporter is this another file I am missing? @KaelLizak 

[MrKis]

Did you manage to get it to work? tried it with 12.5 but also get the same error.
Error: Could not find or load main class com.mks.services.utilities.csv.CSVImporter
is there a working version in the meantime? Thanks

[VladimirN]

@apost 

[apost]

I never did get it to work unfortunately and I am still looking for a solution.

[MrKis]

Hello @apost 
I got it to start.
copied mksapi.jar to the program directory. importCSV.bat adjusted the paths to Integrity, commented out "cd".

Only now I get an API error on ConfigureFieldsMapping: .NoSuchMethodError: getAPIVersion()

There were changes in the "new" api. If I have time I'll try to debug it or has someone already done it.

[MrKis]

I can not edit a post?

with mksapi.jar version 4.11.3238 it works with integrity 12.2, only made a short import test so far.

[Chittaranjan_11]

Dear Volker,

Do we have any update on this issue? Your help is appreciated.

Regard,

Chittaranjan

[VladimirN]

@VolkerEckardt 

[Chittaranjan_11]

Dear All,

Do we have any update on this issue ? 

I am using Integrity 11.2 client but the CSV Import script is not working and facing an error as below. I copied the unzip folder files in installable bin folder, while clicking on "Configure Field Mapping" option getting an error. Kindly support on fixing this error.

C:\Programme\PTC\IntegrityClient11\lib>"C:\Programme\PTC\IntegrityClient11\jre\bin\java.exe" -Xms256m -Xmx512m -cp importCSV.jar;opencsv-2.2.jar;mksapi.jar com.mks.services.utilities.csv.CSVImporter
Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: com.mks.api.IntegrationPointFactory.getAPIVersion()Ljava/lang/String;
at com.mks.services.utilities.csv.APISession.<clinit>(APISession.java:23)
at com.mks.services.utilities.csv.CSVTablePreview.mapButtonClicked(CSVTablePreview.java:264)
at com.mks.services.utilities.csv.CSVTablePreview.access$5(CSVTablePreview.java:251)
at com.mks.services.utilities.csv.CSVTablePreview$6.actionPerformed(CSVTablePreview.java:156)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)