CSV Import Tool

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!