Problems with importing .csv and .txt files
Up one level
Problems with importing .csv and .txt files
Hi there-
The instructions on how to do this are very clear, but for some reason, Elan 3.5.0 will not import some .csv files that I have.
This is what I get when I try to do the import:
Java Web Start 1.5.0_13
Using JRE version 1.5.0_13 Java HotSpot(TM) 64-Bit Server VM
User home directory = /Users/cjkarr
----------------------------------------------------
c: clear console window
f: finalize objects on finalization queue
g: garbage collect
h: display this help message
m: print memory usage
o: trigger logging
p: reload proxy configuration
q: hide console
r: reload policy configuration
s: dump system and deployment properties
t: dump thread list
v: dump thread stack
0-5: set trace level to <n>
----------------------------------------------------
Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 11 >= 11
at java.util.Vector.setElementAt(Vector.java:489)
at javax.swing.table.DefaultTableModel.setValueAt(DefaultTableModel.java:638)
at mpi.eudico.client.annotator.gui.ImportCSVDialog.initTables(ImportCSVDialog.java:123)
at mpi.eudico.client.annotator.gui.ImportCSVDialog.<init>(ImportCSVDialog.java:104)
at mpi.eudico.client.annotator.commands.global.ImportDelimitedTextMA.actionPerformed(ImportDelimitedTextMA.java:96)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:334)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
at java.awt.Component.processMouseEvent(Component.java:5602)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5367)
at java.awt.Container.processEvent(Container.java:2010)
at java.awt.Component.dispatchEventImpl(Component.java:4068)
at java.awt.Container.dispatchEventImpl(Container.java:2068)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866)
at java.awt.Container.dispatchEventImpl(Container.java:2054)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
I'm not a java person - help anyone?
Thanks!
Re: Problems with importing .csv and .txt files
Hi K ;)<br><br>One thing would be to check how many columns are there in your CSV file. The Java message, seems to me, that is related with one row having more than 11 fields.<br>If you are importing from Excel and have, say, 3 columns, make sure that there aren't any comments, notes or numbers on any additional columns.<br><br>hope this helps.<br><br>Francisco.<br><br>
Re: Problems with importing .csv and .txt files
In principle the importer should handle differences in number of columns in different rows correctly, but maybe my testing was not extensive enough.
You could send one of your .csv/.txt files to me (with a description of the column specifications you used in the importer dialog) so that I can try to reproduce the problem.
(han.sloetjes AT mpi.nl)
-Han