 Import projects from Excel
Import projects from Excel
Added by О T almost 4 years ago
Hi
I start my local Redmine server v4.2.3.stable:
I have many projects in Excel - more 2000. One row in Excel is one project:
How i can import all of them in Redmine? From Excel, CSV, txt, etc?
Not issues, but all projects?
After that i will import all issues for all projects.
Thx
| nks.jpg (30 KB) nks.jpg | |||
| project_excel.jpg (457 KB) project_excel.jpg | 
Replies (5)
     RE: Import projects from Excel
    -
    Added by C S almost 4 years ago
    RE: Import projects from Excel
    -
    Added by C S almost 4 years ago
  
  As far as I know, it is only possible to import tickets into existing projects, but not to generate a new project via import
     RE: Import projects from Excel
    -
    Added by О T almost 4 years ago
    RE: Import projects from Excel
    -
    Added by О T almost 4 years ago
  
  Is there any way to add multiple projects, even if it is not an easy one?
     RE: Import projects from Excel
    -
    Added by Fletcher Johnston almost 4 years ago
    RE: Import projects from Excel
    -
    Added by Fletcher Johnston almost 4 years ago
  
  You could add multiple projects pretty quickly via the API and a python script. Shouldn't be too bad to parse out the Excel file and create a new project for each row.
     RE: Import projects from Excel
    -
    Added by Chan Li over 3 years ago
    RE: Import projects from Excel
    -
    Added by Chan Li over 3 years ago
  
  Maybe you can try this plugin: https://www.redmine.org/plugins/redmine_excel_connector

more details: https://www.redmine.org/plugins/redmine_excel_connector
| after_loaded.png (94.6 KB) after_loaded.png | 
     RE: Import projects from Excel
    -
    Added by Joan J over 2 years ago
    RE: Import projects from Excel
    -
    Added by Joan J over 2 years ago
  
  Hi @OT did you had any success, I'm on the part of importing the issues on different projects, since projects can't be added to the CSV import it would take a lot of time for environments with many projects.