How to import resources from Excel

1

Can i import resources from Excel? If yes do i need row headers? I assume that each resource occupies each row. do my columns have to match the information as per the new resource ? I set up a small list and tried to import it. 1st time saved it as an excel file no luck then saved it as a csv file again nothing. Am I missing something? apologies if it is blindingly obvious but idiot proof step by step appreciated

2

You can import CSV which can be produced from Excel. Yes, you need row headers. You can export project from GanttProject to CSV to see the expected structure of CSV file.

3

Hi,
could you give an example how to create resource CSV file for import to the project?

4

As written above, you can export our sample project to CSV to create an example.

5

I have did and get a parser error Failed to parse value=Phone
please find csv file and suggest what to repair.

HouseBuildingSample.csv (6.51 KB)

6

This file seems to be produced by Excel or something like that. You need to replace rows with empty cells (those which consist of commas) with just empty rows (as text) and remove empty cells at the end of resource column headers. The result is attached.HouseBuildingSample.csv (6.2 KB)

7

I filed a new issue to ignore empty cell lines and trailing empty cells: https://github.com/bardsoftware/ganttproject/issues/1634

8

Apropos to the general question, I want to import a few new tasks.

  1. I exported to Excel.
  2. Added my new tasks. Saved XLS.
  3. Imported.
  4. I end up with my original tasks duplicated, and the new task.

If I want to import new tasks, do I need to import only the tasks I wish to add?

9

Yes, import adds data to the current project.

10

Hi,

First, I would like to thank whoever made GanttProject and keeps it working! This is great piece of software.

Well, I downloaded the HouseBuildingSample.csv and just tried an import into a blank new project to understand how import works.

Unfortunately, despite no error shows up, nothing happened. I have no single resource available neither from the resource tab nor when I try to create a new task and assign it to a resource.

I tend to believe this import process described above does not work straight.

I am a French user, does it means the headers for such import are expected different and localized?

Well, it seems yes, I have set GanttProject language to English then tryed import again and tada! Works! However, “Default role” appears as “undefined” for each resource. Also, could be useful to get a message showing how many records have been imported. It would help to understand whether import worked and how well.

Could it be that “Roles” have to exist in the “Roles” section before an import can succeed?

Here in the current example resources are all “Architect” but it is true that in a blank project this role does not exist…

I checked the “Resource role” field from the project properties and “Architect” is there n times as many as resources imported meaning GanttProject does not handle duplicates during resources import. Could it be an issue to be raised both because “Default role” appears empty and exact same roles are duplicated in Project properties?

I am using GanttProject 3.3.3300 on Windows 11.

Best regards,

11

Yes, the interface language is expected to match the language of the column headers in CSV.

I will look at the issues with roles, thanks for reporting!