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]

Reply via email to