topic Re: CSV Import Tool in Systems/Software Engineering

CSV Import Tool

KaelLizak — Tue, 18 Sep 2012 21:12:15 GMT

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

Re: CSV Import Tool

sdeshpande — Thu, 31 Mar 2016 00:46:53 GMT

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.

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

blePreview.java:264)

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

ew.java:251)

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

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

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

main.java:75)

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

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

main.java:75)

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

        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre

ad.java:201)

        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.

java:116)

        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre

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!

Re: CSV Import Tool

KaelLizak — Mon, 11 Apr 2016 15:00:55 GMT

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

Re: CSV Import Tool

jfitz — Wed, 20 Dec 2017 08:11:22 GMT

Re: CSV Import Tool

VolkerEckardt — Sun, 18 Mar 2018 10:46:36 GMT

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

Re: CSV Import Tool

apost — Wed, 21 Oct 2020 22:56:47 GMT

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

Re: CSV Import Tool

MrKis — Fri, 19 Aug 2022 07:46:51 GMT

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

Re: CSV Import Tool

VladimirN — Fri, 19 Aug 2022 07:48:38 GMT

@apost

Re: CSV Import Tool

apost — Tue, 23 Aug 2022 22:04:06 GMT

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

Re: CSV Import Tool

MrKis — Tue, 27 Sep 2022 12:36:48 GMT

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.

Re: CSV Import Tool

MrKis — Tue, 27 Sep 2022 14:29:51 GMT

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.

Re: CSV Import Tool

Chittaranjan_11 — Tue, 06 Jun 2023 07:09:15 GMT

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)

Re: CSV Import Tool

Chittaranjan_11 — Thu, 08 Jun 2023 10:52:04 GMT

Dear Volker,

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

Regard,

Chittaranjan

Re: CSV Import Tool

VladimirN — Thu, 08 Jun 2023 14:28:39 GMT

@VolkerEckardt