Files with .txt suffix won't open as spreadsheet in Symphony or Open Office
Kevin Ramer (4.5k●9●186●201)
| asked Aug 07 '12, 3:14 p.m.
closed Aug 07 '12, 4:10 p.m. by Jared Burns (4.5k●2●9)
Ok, Granted this isn't a fault of either JazzMon or either of the mentioned products. But my experience is that
.txt files are opened as "write" documents. However, one can avoid that by creating a work sheet from a file. Create > Sheets... Choose From File in the lower part of the dialog. Both Symphony and Open Office provide this. A bit more work for us, but easier than renaming all those .txt files.... Just a tip. Maybe the JazzMon will provide means of creating the files with .csv which import directly. |
Accepted answer
JazzMon 1.3.0 was just released and now generates comma separated CSV files that are more easily imported into both Symphony and Excel.
The release also includes standard formulas on each line that can be used to sort and filter data; these compute totals, max values, averages and the ratio of the average to the baseline. Since there is some difference in formulas between Symphony and Excel, a new property is provided that identifies the target spreadsheet program to address this difference so the new features will work in both spreadsheet applications. Daniel Toczala selected this answer as the correct answer
Comments
Kevin Ramer
commented Oct 04 '12, 10:07 a.m.
Nice. I'll have to check it out.
|
One other answer
Unforunately Excel only interprets .csv files as comma separated and will misread tab-separated data like what JazzMon produces. It will ask what the separator is when reading in .txt files.
Symphony on the other hand will ask what separator to use when reading .csv files but not .txt files. We'll review how we could improve the situation for Symphony users in the future. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.