Open Design Engine - Google Spreadsheet to Redmine Table Conversion - Open Design Engine

Google Spreadsheet to Redmine Table Conversion

Added by Jeremy Wright almost 12 years ago

I roughed out the attached Python script to convert a Google Spreadsheet that was downloaded in CSV format to a Redmine table. You pass the script the CSV's file name and the Redmine format is dumped to standard output. I developed the script on Linux and didn't account for MS Windows end-of-lines, so Windows users may have issues.

You may still have to do some tweaking of the output if you have any stray commas throughout your table. At the time of this post the following is an example of the output, but is subject to change.

https://opendesignengine.net/projects/far-horizons-project/wiki/BOM_v1_0

I did have to account for a few extra commas, but it beats trying to convert it by hand.

It might be nice to have a feature like this built into ODE some day.

googleSheetConvert.py (1.3 kB)

Replies (1)

RE: Google Spreadsheet to Redmine Table Conversion - Added by Jeremy Wright almost 12 years ago

Well, this script has become kind of a moot point for now. The table that the script produces looks good, but Redmine doesn't handle the table very well, especially if you have a navigation bar on the side. Depending on the size of your browser window the table can end up overlapping your nav bar.

(1-1/1)