CSV import question

[kenneth a. goldbergParticipant]

I love the effortless csv-file drag-and-drop importing feature. It works great, but there’s one issue that could be improved. Suppose I drag in a CSV file, with fields, A, B, C. I set up nice plots, etc. Later, I re-generate the CSV file with new data, and the same fields A, B, C. What is the best way to import and seamlessly overwrite the original A, B, C, so the graphs simply update?

Currently when I drag the new (replacement) CSV file into DataGraph, new A, B, C fields will be created right alongside the old ones. I end up temporarily naming the old fields A_old, B_old, C_old, importing the new file, and then manually switching the graph dependencies to the new A, B, C before deleting the _old data. Thank you.

[dgteamModerator]

Try dragging and dropping the updated file directly on the existing group object.  If the column names are the same, DataGraph should do just what you are asking for!

This was introduced a couple of versions ago, so if you are on an older version you may need to update.

Let us know if that works for you.

 

[kenneth a. goldbergParticipant]

Wonderful! Works like a charm. Thank you!

[jordanParticipant]

If you end up with giant DG files like I do with lots of columns of data, sometimes you can miss drop the csv, so what I do is select the columns in the data table and drop the csv on to the data table and it works well with a big drop area.

[mikizParticipant]

Hi there,

I was looking for something similar for .xlsx files. Is there anything or the solution is to export xlsx to csv and follow the nice procedure?

thanks

[dgteamModerator]

You can do the same for .xlsx files directly, no need to covert to csv.  I just ran a test to double check that it was working properly and had no problems.

When you drag and drop an excel file icon onto the column definitions list, DataGraph creates an overall group that is named based on the file name.  If the file contains multiple sheets they will be  subgroups.

For example, here I imported an excel file called “Populationtest”.  It had two tabs in the file, “Continents” and “Test”.  I had no problem modifying the data and reimporting by dropping on the “Populationtest” group object.  The data was updated properly.

 

[mikizParticipant]

thank you so much.

It is exactly what I need.

michele

[Author]

Posts