Importing csv file


#1

I have used the Export function to determine the file format for the tasks and the resources. The tasks seem to import okay but none of my attempts, and I’ve tried it probably 4 dozen times, have I been successful in importing resources.

Each time I try the import I make slight changes thinking that maybe there’s something wrong with the data’s format but I can’t even import data that I entered manually into GanttProject and exported to import back into a new blank project file.

Is there some trick or steps that I need to take first? Do all the roles need to be defined first? Doa ll the columns need to have data?

I’m running 2.8.8


(Dmitry Barashev) #2

Can you share the CSV file?


#3

FOREP.csv (2.5 KB)
Attached…


#4

Any thoughts as to why this won’t import?


(Dmitry Barashev) #5

Oh, thanks for reminding.
GanttProject expects both tasks and resources sections to be in the file, separated by two empty lines. Even if CSV has no tasks, there must be task headers line. Inserting these three lines (headers + two empty) in the head of your CSV fixes the issue:

-- Begin here --
ID,Name,Begin date,End date


-- End here ---

#6

Ok, that really helped… I also found that when Excel saves to a csv file, it adds additional commas to the resource heading when the tasks section has more column headings than the resource section. This then causes errors when importing. I’ve since used Notepad++ to clean up my Excel csv files.


(Dmitry Barashev) #7

Hopefully this will be fixed with new export/import directly to XLS files


(Scott Baker) #8

Hi

I am issue upload my csv please help.

Gantt - 12 Oct - Sheet1.csv (691 Bytes)


(Dmitry Barashev) #9

Can you please explain what do you expect from us? This CSV is not in the format which is understood by GanttProject. You can see the expected format by exporting any project (e.g. our standard HouseBuildingSample) to CSV.