Project

General

Profile

Importing historical project titles into Redmine

Added by Ted Hyde over 9 years ago

Greets - I'm running a new install of Redmine :2.5.3.stable/Ruby:1.9.3-p484 (2013-11-22)[x86_64-linux]/Rails:3.2.19/MySql
after a need to expand capabilities from my antiquated Web2Project system. I had tuned up that older system quite well and had a lot of historical data in it.

I'm not interested in bringing everything over - just for consistency I'd like to be able to mass-import the following fields from a csv (or similar flat file):
-projectName -> Name,
-projectDescription -> Description,
-fileNumber -> custom field: File Number,
-projectCreationDate -> {Project Creation Date},
-estimatedStartDate -> custom field: Estimated Start Date

I don't need any modules or trackers enabled, and no issues / tasks imported or populated.

I'm just looking to have the list available, of which could potentially be manually edited for future purposes. Project status can be left as 'open' and I can tidy up and close them on a case-by-case basis.

I realize I could probably perform a sql hack to do this, but I'd prefer it go in in a proper transaction format.

Any thoughts?

Thanks,
Ted.