Importing historical project titles into Redmine
Added by Ted Hyde over 10 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.