cindy52 / csvedit Goto Github PK

What steps will reproduce the problem?
1.It is not a bug, it is a usability problem/shortcoming.

What is the expected output? What do you see instead?
N/A

What version of the product are you using? On what operating system?
Windows XP, Eclipse Helios

Please provide any additional information below.
Two issues:
1. (Minor) The asterisk next to the file's name indicating that changes have 
been made to the file appears only after I switch to the CSV Source view.
2. (Important) I wanted to use the CSV Edit in order to provide translations 
for the Magento .csv files. When clicking on a field's value, I can immediately 
edit, which is fine... But when I press ENTER or TAB I cannot move to the next 
cell for editing. Using the mouse to point and click is not efficient for 
changing all (or many in a row) entries. At least something like F2 could be 
used if not ENTER or TAB for the next cell.

I have already OpenOffice installed and I will use it for editing...

Thx !

I think that searching would mean scrolling down to where the search term is 
positioned. This seems to me more like filtering: only rows which contain the 
search phrase remain in the listing and the term is highlighted.

I like it the way it works, it's just a naming thing.

It would be nice if the current black background csv.gif icon could be replaced 
with something lighter colored, as it’s difficult to see many of the icon 
decorations (which tend to be darker colored by default).

I’ve attached an example showing the current CSV and XML icons, with icons 
decorations.

What steps will reproduce the problem?
1. Open a .csv file (in my testing, tab-separated, utf-8). Very simple files 
work, such as the one shown in the screenshot.

What is the expected output? What do you see instead?
The "CSV Table" view sometimes appears empty, while the "CSV Source" displays 
the data. Unfortunately I'm not able to pinpoint more precisely the problem, 
and would be glad to provide more information.
Workaround: change one Preference and revert it (e.g. switch to a comma 
separator and change back to tab). After clicking OK the table view displays 
again.

What version of the product are you using? On what operating system?
- CSVEdit 1.1.1 with options: {use first line as column header, delimiter=TAB, 
text qualifier=empty, comment=empty, filtering not case sensitive}
- Eclipse Juno SR2 with UTF-8 as workspace file encoding
- Windows 7 x64 SP1

What steps will reproduce the problem?
1. Attempt to Open File... error occurs immediately
2. File is large: wc gives 26519 lines, 6,658,195 chars
     13 column. 

What is the expected output? What do you see instead?
org.eclipse.ui.PartInitException: Invalid Input: Must be IFileEditorInput
    at org.fhsolution.eclipse.plugins.csvedit.editors.MultiPageCSVEditor.init(MultiPageCSVEditor.java:782)
    at org.eclipse.ui.internal.EditorManager.createSite(EditorManager.java:798)
    at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:647)
    at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:465)
    at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
    at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:289)
    at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2863)
    at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2768)
    at org.eclipse.ui.internal.WorkbenchPage.access$11(WorkbenchPage.java:2760)
    at org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2711)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
    at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2707)
    at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2691)
    at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2674)
    at org.eclipse.ui.ide.IDE.openEditorOnFileStore(IDE.java:1155)
    at org.eclipse.ui.internal.ide.actions.OpenLocalFileAction.run(OpenLocalFileAction.java:107)
    at org.eclipse.ui.internal.ide.actions.OpenLocalFileAction.run(OpenLocalFileAction.java:76)
    at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:251)
    at org.eclipse.ui.internal.WWinPluginAction.runWithEvent(WWinPluginAction.java:229)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Display.sendEvent(Display.java:3776)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1367)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1390)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1375)
    at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1187)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3622)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3277)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
    at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
    at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1407)


What version of the product are you using? On what operating system?
CSV Edit 1.1.0, Mac OS X 10.6.7, Eclipse 3.6.1


Please provide any additional information below.

Using the file attached (4 columns), every column is showing the contents which 
should be only at the first one.

What steps will reproduce the problem?
1. Open the file
2. Check the table view
3. Contents are as follows

What is the expected output? What do you see instead?
Col1,Col2,Col3,Col4
Col5,Col6,Col7,Col8

Please use labels and text to provide additional information.

I'll love if I can do a multiline edit, not easy way to
add new-lines inside a single field, text is even shown with
strange characters in it (CR/LF) just in one line in editor mode.

On the other hand, multiline text looks
perfectly well in none edit mode.

Perhaps just opening an associated text-editor will
be wonderful, even better.

I have a file like this:

"Id","Name","Vorname","Strae","PLZ","Ort"
1,  "LOOK HERE, Senior",    "Peter",    "str. 23",  "12345","somewhere"

-> with no blank by "LOOK HERE" and a tab character (white space) after the 
comma, which is ignored by csv.

now I edit the table and save it

Id,Name,Vorname,Strae,PLZ,Ort
1," LOOK HERE, Senior", Peter,  tstr. 23,   12345,somewhere

Now I have a tab character in the string and this is not ignored by csv.

I realize this wouldn't be trivial to program however, it would be a nice 
feature to have.

It would be great to be able to define the filter individually for each field 
with options for the operand (contains, does not contain, is, isn't...).

Example:
email "contains"  @
province "is not"          (meaning not empty)

Just something to think about :-)
Thanks Fred
Petr

Another usability feature request.

After finishing editing a column, press tab should move the cursor to the next 
column

What steps will reproduce the problem?
1. Open the preference panel
2. Try to set the tab character (\t)
3. The field is set to have only one character.

What is the expected output? What do you see instead?
Unable to do the action.

What version of the product are you using? On what operating system?
Eclipse 3.4

Please provide any additional information below.

What steps will reproduce the problem?
1. Open a csv file with lots of columns, with various sizes (some very small, 
some very large)

What is the expected output? What do you see instead?
CSVEdit could/should include a function to auto-fit the columns (so that all 
text of each column is shown, not more not less). Currently, auto-fitting is 
only doable one column at a time, by double clicking a separator.
Always auto-fitting might not be a good idea, so a button might be a good option

What version of the product are you using? On what operating system?
CSVEdit 1.1.1, Windows 7 x64

Unable to edit data in Mac OSX, Eclipse Helios, Cocoa

Version 1.0.2

I go to Preferences / CSV Editor Preferences. I click
"Use the first line of the CSV file as the column headers"
and I click OK.

I open the preferences again and it is off again.
Clicking Apply before OK doesn't change anything.

The feature is really switched off. I open a CSV file and it really doesn't 
interpret the first line as column labels.

having a file with these contents:
one,two,three,four
un, deux, trois,quatre
uno, dos, tres, cuatro

The Table editor is showing the file contents like this:
one,one,one,one
un,un,un,un
uno,uno,uno,uno

If clicking on a cell, the contents to be edited are shown correctly. Once the 
cell losts its focus, wrong contents are shown again

Tested on version 1.0.2 using eclipse 3.6

Add a bunch of preferences

can change the character encoding, default UTF-8
can change the end of line character to n rn n
can change the string delimiter char, default "
can handle commented lines

Make sure we take into account the Header Row, if no validation is done against 
the header row, we should not add the missing ,

What steps will reproduce the problem?
1. open a csv file in table mode
2. edit a field
3. switch to source mode

What is the expected output? What do you see instead?
My csv file has comments with commas in them. Upon switching to source mode, 
any text in a comment line after the first comma is deleted. Example:
Before:
#This is a comment, it should be able to have commas
After:
#This is a comment

In addition, the quotes in my text fields disappear. (the quote delimiter is 
set to "") 

Before:
1,2,3,"the first 3 numbers!", 4
After:
1,2,3,the first 3 numbers!, 4

I want the quotes to stay there, because other tools that read the information 
expect them.

What version of the product are you using? On what operating system?
the latest as of 8/23/12 running on eclipse 3.7.2 and Mac 10.7.4

Please provide any additional information below.

CSV Edit could export some packages to allow reusing its source code.

For example, it could be interesting to allow creating custom CSV editors (i.e. 
TSV files) by overriding CSV Edit classes.

What steps will reproduce the problem?
1. Open a CSV file
2. Edit the document so new columns are needed to be shown in the table
3. Check table columns

What is the expected output? What do you see instead?
There is no need to replicate the columns

Please use labels and text to provide additional information.
When editing the document there should not be need of recreating and populating 
the table

Currently the delimiter is set in the preferences. It would be good if one 
could change the delimiter on a per file basis. This would make it possible to 
work with tab- and comma-separated files at the same time.

What steps will reproduce the problem?
1. in Eclipse, choose menu Windows / Preferences
2. click CSV Editor Preferences

What is the expected output? What do you see instead?
I expected some choices (e.g. choosing ";" instead of "," as the field 
separator).

I get a red error message:
"An error has occurred when creating this preference page."

and an error pops-up:
Problem Occurred
Unable to create the selected preference page.
org.fhsolution.eclipse.plugins.csvedit.CSVPreferencePage

What version of the product are you using? On what operating system?
org.fhsolution.eclipse.plugins.csvedit_1.0.0.jar
Windows XP SP3
Version: Helios Release
Build id: 20100617-1415

Czech version of CSV uses semicolons instead of commas. CSV Editor didn't 
auto-detect it so I'm hoping to be able to change the separator in preferences.

Thanks
Petr

I know this is low priority but it'd be great if cursor is focused in the first 
column after clicking Add Row button.

What steps will reproduce the problem?
1. use existin CVS with no text data qualifier (separator= ;)
2. install csv edit and configure it with no text data qualifier
3. edit cvs and add a line

What is the expected output? What do you see instead?
expected : nothing changed except last line
NULL char are inserted as 2 first char on every lines :
(everyline):  <NULL><NULL>;mydata;mydata2

What version of the product are you using? On what operating system?

issue with xp and seven on ecplipe 3.6 & 3.7

Please provide any additional information below.

What steps will reproduce the problem?
1. any
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
1.1.3
rhel5.8 64 bit


Please provide any additional information below.

A. Option to display line numbers in the table view.
B. The table view and source view should be linked.  This is especially true if 
there is not a search function.  If i have 'filtered' and find the table entry 
of interest, I should be able to switch to the source code and find the line 
number without searching again.
C. Search function that isn't a filter in the table view.

If I add a new row in the table modus and switch to the source modus, I don't 
see the new row. If I switch back, the new row is missing.

Use the new menus Insert Column / Delete Column :

on delete : sorting column names are not refreshed after column is deleted

on adding a column : the column is not displayed (even if a 
tableViewer.refreshed is run)

In some situations, there is a header in the csv file. 
It would be nice to have a comment character so csv edit ignores the line.
Thanks!

To enhance the Text editor of a CSV file, could it be possible to highlight  
the different columns?

For example, having a file like this:

one, two, three
one, two, three

It could be a real enhancement to highlight odd column in black, while even 
columns could be shown using a grey font.

Of course, this could be configurable through a preference page ;-)

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?


Please provide any additional information below.

Many business users are using XL to edit csv file.
it will be nice to have the possibility to import the csv file directly in the 
project and saved them as csv given the preferences selected

In CSV editor Preferences, it's not possible to enter "\t" or choose "Tab" as 
delimiter.

Version: CSV Edit 1.1.2
Operating system: Mac OSX 10.9.3
IDE: STS

What steps will reproduce the problem?
1. Open a CSV where TAB is the delimiter

What is the expected output? What do you see instead?
CSV doesn't recognize TABs as separators.
Or maybe it's supported, but I couldn't find how to define tab as the delimiter 
in the Preferences. I tried t, T, ^I, none works


What version of the product are you using? On what operating system?
csvedit 1.1.1, windows 7 x64

To make life simpler for the users of the plugin, create an updated site and 
manage update through the site

Excel-like behaviour would be useful:
- not only add empty row but copy existing one
- copy row/column values to another row or column

Is there a contact link anywhere?

I wanted to say thanks for the plugin, it's looking good.

It would be nice to have pasting from Excel etc. - shouldn't be too hard, as it 
pastes it in tab delimited anyway; maybe tab separated files could be handled 
as well?

Editing column headers would be really useful too.

An update site would be great!

(and you should probably delete this issue once you've seen it!)

What steps will reproduce the problem?
1. Open http://dl.dropbox.com/u/13140569/csvedit-filtering-doesntwork.csv . 
This csv has a header with two columns, but the data has three.
3. Type "11" in the filter box

What is the expected output? What do you see instead?
Only the line starting with "Cell11" should remain. Line starting with"Cell21" 
should disappear
Instead, line "Cell21" remains

What version of the product are you using? On what operating system?
csvedit 1.1.1, windows7 x64

If the CSV file to edit shows a comment in the first line, then the table view 
will show a single column.

Take this "CSV file" as an example

#
# NAME : MyFile
#
one,two,three,four
uno,dos,tres,cuatro

some buttons like 'add column', 'insert column' and 'delete column'

When defining the CSVRow, the system does not read the preferences.
Make sure the toString() method read the preferences.

What steps will reproduce the problem?
1. Open http://dl.dropbox.com/u/13140569/csvedit-utf8-shows-weird-characters.csv
2. Have a look at the first header column

What is the expected output? What do you see instead?
The first Header column should be displayed.
Instead, I see the first column prefixed with "":
http://dl.dropbox.com/u/13140569/csvedit-utf8-shows-weird-characters.png

What version of the product are you using? On what operating system?
csvedit 1.1.1 on Eclipse Indigo SR2, Windows 7 x64 SP1
The UTF-8 file was created using Notepad++ 5.9.8 Unicode

I have a 270 kB file with 82 columns and 860 rows.
Values in each field aren't long, it's names, addresses, e-mails, phone numbers.

My computer has a 1.89 GHz CPU with 2.5 GB of RAM, screen resolution 1200x1600 
(yes, it is portrait).
Scrolling horizontally or vertically takes about 2 seconds, switching from 
another app back to Eclipse takes about 1.5 seconds to refresh the screen and 
start responding. The computer is not swapping, CPU runs at 100%.

When I switch to CSV Source, it is fast, just as I would expect from a simple 
text editor. I'm not surprised, just summing up the facts :-)

I don't want to make the file available for public here but I'll send it to you 
via e-mail if you want.

Thanks for your work Fred, you're doing a great job!

Petr

What steps will reproduce the problem?
1. Open CSV in csvedit
2. Make changes in CSV Table (save button & in file menu remain grayed out, 
Ctrl-S doesn't work)
3. Switch to CSV Source (asterisk appears in tab, grayed out menus now active, 
save is now allowed)
4. Switch back to CSV Table (save is allowed)
5. Save
6. Repeat from 2.

What is the expected output? What do you see instead?

Save should be allowed when changes made in CSV Table. See steps above for 
actual behaviour.

What version of the product are you using? On what operating system?

csvedit 1.1.1, Windows 7, Aptana Studio 3.2.2 (Eclipse Platform 3.7.2)

What steps will reproduce the problem?
1. create csv file as

#
# NAME : MyFile
#
one,two,three,four
uno,dos,tres,cuatro

(This was to reproduce Issue #17)

2. open csv file in the source tab

3. look the console, exception BadLocationException received

org.eclipse.jface.text.BadLocationException
    at org.eclipse.jface.text.AbstractDocument.getChar(AbstractDocument.java:772)
    at org.eclipse.core.internal.filebuffers.SynchronizableDocument.getChar(SynchronizableDocument.java:153)
    at org.fhsolution.eclipse.plugins.csvedit.editors.text.CSVTokenScanner.nextToken(CSVTokenScanner.java:121)
    at org.eclipse.jface.text.rules.DefaultDamagerRepairer.createPresentation(DefaultDamagerRepairer.java:169)

Would it be possible to sort columns using numerical values?

An easy solution might be to allow two more clicks on the column header, the 
first two working unchanged (sorting string representations), and then have the 
next two attempt to sort a column using numerical values?

What steps will reproduce the problem?
1. Open the attached csv file (as far as I know, any file will do, though)
2. Attempt to add a column named "B" (or anything else)

What is the expected output? What do you see instead?
You should see a column called "B".  Its contents should be empty.
Instead, the column will display B until you switch to source view, which will 
reveal that the name of the column has not been saved.  If you switch back to 
table view, the name has disappeared.  In the cell's contents, you will see all 
data from that row displayed.  You can edit the cell to add new data, but it 
will continue to display all data from the row until you close and reopen the 
editor.

What version of the product are you using? On what operating system?
csvedit 1.1.2, Eclipse Kepler.  Windows Server 2008.

Please provide any additional information below.

What steps will reproduce the problem?
1.Set comment char in preferences to #
2.Open a CSV file with lines that start with # for comments
3.Enter data in the table view
4.Switch to source view
5.Comment lines are missing

What is the expected output? What do you see instead?
Expected comments to stay instead comments are removed. Also would be nice if 
you could see the comments in the table view but not show stopper.

What version of the product are you using? On what operating system?
Eclipse 3.5.1, csvedit 1.1.0, windows xp sp3

Please provide any additional information below.
Not able to use the plug-in as my csv data has extensive comments.

What steps will reproduce the problem?
1.Open a csv file
2.Click on heading to sort by column
3.Cannot clear a column sort once applied
4.Switching to source view and then back to table view the column sort 
decoration is no longer displayed but the sort is still in effect. Have to 
close and reopen the editor to clear the sort.

Also had difficulty always reproducing the disappearance of the sort decoration 
so there is likely more to the what is triggering this issue.

What is the expected output? What do you see instead?
Some way to cancel a column sort, the column sort decoration to stay

What version of the product are you using? On what operating system?
Eclipse 3.5.1, csvedit 1.1.0, windows xp sp3

Please provide any additional information below.