CompletedUnits.csv - inconsistant formats

[GoogleCodeExporter]

What steps will reproduce the problem?
1. AFAIK no special action is needed.
2. My CompletedUnits.csv contains several faulty rows
3. look into attachment below

What is the expected output? What do you see instead?
Nice and clean formatted CSV, but most often I get some odd one-digit number 
showing up in the column between 'PPD' and 'Download date'

What version of the product are you using? On what operating system?
HFM.ORG 0.5.1 rev 198, running Windows XP Pro SP3.

Please provide any additional information below.

Original issue reported on code.google.com by alexfr...@gmail.com on 6 Jul 2010 at 6:31

Attachments:

• CompletedUnitsError.JPG

[GoogleCodeExporter]

I've just found out, that the error is caused by PPD, being reported by HFM 
using 'decimal comma' (if decimal places >=1). That causes the problem, since 
HFM is reporting in CSVs (comma-seperated-values). When the file is imported 
into Excel the decimal point (comma) is interpreted by Excel as a seperator 
instead. Solution would be to use DECIMAL POINT instead of DECIMAL COMMA or 
using another ASCII character
a seperatr!

Original comment by alexfr...@gmail.com on 6 Jul 2010 at 7:30

[GoogleCodeExporter]

Semicolon as seperator would be better, since comma is/has been used in 'Work 
Unit Name' i.e. "p6701_VSD in POPC and water, neutralized"

Original comment by alexfr...@gmail.com on 6 Jul 2010 at 8:21

[GoogleCodeExporter]

Hey... thanks for the report.  This is a documented, but yet fully functional 
feature.  In fact, my plans for this cataloging of WUs is something I plan to 
address in the next couple releases - probably with a SQL engine behind the 
scenes.  I will be providing an mechanism to import the current CSV data and 
cases where extraneous commas in the protein name or comma separation in the 
numbers, in lieu of periods, will be addressed as best possible.

There is a reason why I still label the software as Beta. ;-)

Original comment by harlam357 on 10 Jul 2010 at 4:25

[GoogleCodeExporter]

Thx for feedback - gratefully awaiting implementation ;-)

Original comment by alexfr...@gmail.com on 10 Jul 2010 at 5:09

[GoogleCodeExporter]

Original comment by harlam357 on 9 Oct 2010 at 3:16

• Changed state: Started
• Added labels: Component-Logic, Component-Persistence, Milestone-Release0.6, OpSys-Linux, OpSys-Windows, Priority-High
• Removed labels: Priority-Low

[GoogleCodeExporter]

Marked Fixed for Revision 237.

This there isn't necessarily a 'Fix' for this.  The CompletedUnits.csv file has 
just been superseded by the WU History Database feature.

Original comment by harlam357 on 9 Oct 2010 at 8:09

• Changed state: Fixed