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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

CSV Import Tool

KaelLizak
14-Alexandrite

CSV Import Tool

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.


Kind Regards,
Kael Lizak

Senior Technical Support Engineer
PTC Integrity Lifecycle Manager
13 REPLIES 13

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
14-Alexandrite
(To:sdeshpande)

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


Kind Regards,
Kael Lizak

Senior Technical Support Engineer
PTC Integrity Lifecycle Manager

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

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
8-Gravel
(To:apost)

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
24-Ruby II
(To:MrKis)

@apost 

apost
7-Bedrock
(To:MrKis)

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

MrKis
8-Gravel
(To:apost)

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
8-Gravel
(To: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.

Dear Volker,

 

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

 

Regard,

Chittaranjan

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)

jfitz
4-Participant
(To:KaelLizak)

 

 

Top Tags