bardsoftware / ganttproject

Official GanttProject repository.
http://ganttproject.biz
GNU General Public License v3.0
892 stars 310 forks source link

MPX export special caracter issues (comma, quote) #491

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.Create a list of tasks
2.Add in some of the task name commas or quotes
3.Export to Project MPX format
4.Import in MS Project 2010
5.All tasks will be imported but taks with comma or quotes will have and empty 
description field.

What is the expected output? What do you see instead?
The task description should be present

What version of the product are you using? On what operating system?
GanttProject 2.5 Praha (build 1024) on x84 (64bit)

Please provide any additional information below.
If fix requires too much effort, preventing export by saying no comma, quotes 
are supported in task name would at least advise the user.

Original issue reported on code.google.com by fran6.ja...@gmail.com on 20 Apr 2012 at 7:14

GoogleCodeExporter commented 9 years ago
I think that fix requires efforts from Microsoft :/

In MPX file which is produced by GanttProject task names with commas and quotas 
are properly escaped (at least as my knowledge of MPX file spec allows to 
judge), and GP itself imports such files back fine. 

If you need it to be able to exchange files with MS Project, try using MS XML 
format, it should work better.

Original comment by dbarashev on 22 Apr 2012 at 8:27

GoogleCodeExporter commented 9 years ago
It may be a bug from MSP2010, I will do some trial to find some sort of 
patterns that may help to solve this issue.

The XML format has a worst problem, it doesn't seem to export the duration of 
the tasks.  All task are at 1 day and the only thing holding on the schedule is 
that the start dates are set according the GP schedule.  This file is unusable 
since once refreshed the 140days project end up taking 40days (my boss would 
like that!)

Original comment by fran6.ja...@gmail.com on 23 Apr 2012 at 1:03

GoogleCodeExporter commented 9 years ago
Huh? Any example of a project where duration is set to 1 day after export to 
XML? It works fine with HouseBuildingSample

Original comment by dbarashev on 24 Apr 2012 at 12:05

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Here is an example file that was ported to MSP2010 in XML format.  You can see 
that all duration are set to "0" which is more like a milestone.

See attached .GAN used and MSP sreenshot.

Original comment by fran6.ja...@gmail.com on 3 May 2012 at 8:46

Attachments:

GoogleCodeExporter commented 9 years ago
For the comma and quote issue, whereas the reason of this post, here are the 
test files used and MSP2010 results.

Original comment by fran6.ja...@gmail.com on 3 May 2012 at 8:52

Attachments:

GoogleCodeExporter commented 9 years ago
It appears that the problem with .xml format is actual for tasks with no 
assigned resources. Thanks for reporting it. I submitted a separate issue #503

Is my understanding correct that you have not found yet a way to escape commas 
in MPX format?

Original comment by dbarashev on 3 May 2012 at 10:17