Skip to main content
16-Pearl
September 18, 2012
Question

CSV Import Tool

  • September 18, 2012
  • 2 replies
  • 8041 views

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.

    2 replies

    1-Visitor
    March 31, 2016

    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!

    KaelLizak16-PearlAuthor
    16-Pearl
    April 11, 2016

    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

    1-Visitor
    December 20, 2017