What is Redmine?

Redmine is a project management web application that facilitates multiple aspects of project oversight and team collaboration. It is designed to be cross-platform and cross-database, ensuring versatility and ease of integration into various work environments. As an open-source tool, it is freely available and is released under the GNU General Public License v2, allowing for community contributions and modifications.

With its foundation in Ruby on Rails, Redmine presents a robust platform supporting multiple projects, each with its own repository, forums, and plugins. Its role-based access control ensures project information security while accommodating diverse team roles and responsibilities. The inclusion of an issue tracking system, Gantt charts, and calendars assists in the meticulous planning and monitoring of project timelines and milestones.

Redmine's comprehensive suite of features extends to news, document, and file management, as well as offering feeds and email notifications to keep the team updated. Its integrated wiki and time tracking capabilities further enhance project documentation and resource management. Custom fields, SCM integration, and the ability to create issues via email provide a tailored user experience and seamless workflow integration. Moreover, Redmine's support for multiple LDAP authentication and self-registration options makes it a versatile choice for varied organizational needs.

Redmine Plugins for Excel

Redmine Excel Connector Overview

The Redmine Excel Connector, created by Chan Li, serves as a bridge between Redmine and Excel. This plugin transforms Redmine into a data hub for Excel, enabling users to perform a variety of operations with Redmine issues directly from Excel.

Loading Issues from Redmine to Excel

Users can leverage the Redmine Excel Connector plugin to import issues from Redmine into Excel. This functionality allows for enhanced data manipulation and arrangement in a familiar Excel format. Moreover, it supports filtering options to tailor which issues are loaded into the spreadsheet.

Updating Excel Rows with Changes from Redmine

The plugin facilitates the updating of Excel rows with new changes from Redmine based on the Redmine ID. This ensures that data in Excel remains in sync with the latest updates in the Redmine system.

Saving Modified Issues from Excel to Redmine

Any modifications made to issues within Excel can be saved back to the Redmine database. This two-way interaction streamlines issue management and ensures that changes are reflected across both platforms.

Issue History Generation

Each time an issue is saved from Excel to Redmine, the plugin generates a history entry for that issue. This feature provides a trackable record of all modifications made outside of the Redmine interface.

Permission-Based Operations

Operations carried out through the Redmine Excel Connector are subject to the permissions of the current Redmine user. This means that users can only perform actions within Excel that they are authorized to do within Redmine, maintaining the integrity of the system's permission structure.

Compatibility and Customization

The Redmine Excel Connector plugin is compatible with a wide range of Redmine versions, from 3.0.x through to 5.1.x, and can be used with various Excel templates. It also provides customization options such as custom row indexing for the header row and column indexing for each column, enhancing its versatility for different project needs.

Common Use Cases

• R

  
  Loading Redmine issues into an Excel spreadsheet for advanced data manipulation
• R

  
  Saving modified issues from Excel back to Redmine, which includes creating a history for each issue
• R

  
  Applying Excel-style arrangements and filters to Redmine issues for customized reporting
• R

  
  Utilizing custom row and column indexing to organize issues within Excel
• R

  
  Ensuring that operations performed in Excel respect the user permissions set in Redmine

Frequently Asked Questions

What is the Redmine Excel Connector and who developed it?

The Redmine Excel Connector is a plugin designed to integrate Redmine with Excel, allowing users to load issues from Redmine into Excel, arrange them, and save them back to Redmine. It was developed by Chan Li.

Where can I find the Redmine Excel Connector and how do I install it?

The plugin's website is conveniencable.com and its code repository is hosted on GitHub. Installation involves cloning the GitHub repository and executing commands in the Redmine installation directory.

What features does the Redmine Excel Connector offer?

The plugin offers features like custom row and column index settings, filters to load and update issues, support for custom field enumeration and multiple dropdown selection, localization of date formats, and it creates a history for each issue when saved.

Is the Redmine Excel Connector compatible with my version of Redmine?

The plugin is compatible with multiple versions of Redmine, ranging from 5.1.x to 3.0.x.

How does the Redmine Excel Connector handle user permissions and updates?

The plugin's operations depend on the user permissions set in Redmine. It has received updates to support new Redmine versions and improve features like date format and custom field enumeration.