Hello,
during the last months I have crated the C-BOARD, a discussion-board / forum with WBS-assigned discussion threads & a WBS-designed overview (and a lot of known and unique functions & features one can expect in such a groupware).
At the current state, the Work Breakdown Structure for the C-BOARD has to be mapped step-by-step (one element after the other) what is okay if we start a new project, but if an existing project with many work-packages shall be imported, it would be nice if there was a module to do this.
For creating such a module, I need to know how a CSV would look like & if the WBS-ID scheme is used mandatory in project-open, so I can rely on the element's position.
It would be nice, if somebody could
A) Post a short how2 for exporting a project's WBS into a CSV file
and
B) place a short example, how such a CSV would look like (and if one can rely on the structure, or if it might happen that a semicolon is not only be used as a separator, but it might happen that one does appear in the description or so...)
Just FYI, the C-BOARD & CCS are available on sourceforge as well: https://sourceforge.net/projects/c-c-s/
(now, the C-BOARD is an integrated part of the CYBR CSCW-SUITE :: CCS as well)
Thanks in advance,
-Florian
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry, for some reason I didn't receive a notification about your posting, and I just saw it yesterday. Did you already start with the development? How should ]po[ and C-Board integrated on the GUI side?
Please use ]po[ V5.0 as a base, there is a beta4 VMware available in the V5.0 download folder.
When going to Project -> Import from CSV, there is an example of a CSV generated by some kind of export. The im_projects table has a "parent_id" column which stores the parent. However, in CSV exports, "Parent Nrs" contains a space separated list of project_nr of the parents to uniquely identify parents.
However, instead of using CSV I'd use a straight SQL query to the PostgreSQL database to extract these data...
Cheers,
Frank
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
during the last months I have crated the C-BOARD, a discussion-board / forum with WBS-assigned discussion threads & a WBS-designed overview (and a lot of known and unique functions & features one can expect in such a groupware).
At the current state, the Work Breakdown Structure for the C-BOARD has to be mapped step-by-step (one element after the other) what is okay if we start a new project, but if an existing project with many work-packages shall be imported, it would be nice if there was a module to do this.
For creating such a module, I need to know how a CSV would look like & if the WBS-ID scheme is used mandatory in project-open, so I can rely on the element's position.
It would be nice, if somebody could
A) Post a short how2 for exporting a project's WBS into a CSV file
and
B) place a short example, how such a CSV would look like (and if one can rely on the structure, or if it might happen that a semicolon is not only be used as a separator, but it might happen that one does appear in the description or so...)
Just FYI, the C-BOARD & CCS are available on sourceforge as well:
https://sourceforge.net/projects/c-c-s/
(now, the C-BOARD is an integrated part of the CYBR CSCW-SUITE :: CCS as well)
Thanks in advance,
-Florian
Hi Florian,
Sorry, for some reason I didn't receive a notification about your posting, and I just saw it yesterday. Did you already start with the development? How should ]po[ and C-Board integrated on the GUI side?
Please use ]po[ V5.0 as a base, there is a beta4 VMware available in the V5.0 download folder.
When going to Project -> Import from CSV, there is an example of a CSV generated by some kind of export. The im_projects table has a "parent_id" column which stores the parent. However, in CSV exports, "Parent Nrs" contains a space separated list of project_nr of the parents to uniquely identify parents.
However, instead of using CSV I'd use a straight SQL query to the PostgreSQL database to extract these data...
Cheers,
Frank