Leonard Mada wrote:
Hello Stefan,
Stefan Weigel wrote:
Hi Leonard,
Leonard Mada schrieb:
it should work with:
http://loinc.org/downloads
See the link with title: LOINC Table File - ASCII Text Format (2.9
MB).
I got it. I can´t see any problem.
Did you set the data type of the columns in the import options to
"text"?
When opening a 54,000+ rows csv-file the user does NOT usually browse
through the table to see if there will be problems and does NOT
usually chang row-formattings [please also notice that there is a
clearly text-header at the beginning of the file]. The user just
expects that everything works fine.
That was my expectation, too.
After importing the document, I made specific changes (it is unlikely
that any lab/health system will use all the LOINC-defined codes), and
customized the data even further and used that data subsequently. Only
after experiencing strange behaviour did I start to investigate what
went wrong and only after a lot of debugging did I notice the culprit.
How many hidden errors arise because of such automatic formatting?
I presume no one knows for surely, but it is probably much higher than
permissible.
Sincerely,
Leonard Mada
[By the way, I have installed OOo in the en-locale on Win2k SP4
en-locale.]
Stefan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.6/1891 - Release Date: 1/13/2009 8:17 AM
Leonard:
I finally had time to try opening the file in Excel 2003. It also does
the date conversion on the same 12 entries in that column as Calc. So
Calc is not unique in this repect.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
