Last week I asked you to help me with the challenge I face exporting data. I'm still having trouble exporting the data: I've tried all the earlier mentioned solutions (see below) but it still doesn't work properly and I have not managed to figure out myself what the cause is.
For now I send you the CRFs, it might be that there are any mistakes/incompatibilities that cause the error?
I hope we can fix this, it would be a pity if I cannot use this database, after the hours of work spend to it.....
Thank you so much in advance!
Robin Wijsman, PhD student Radboudumc, Nijmegen, The Netherlands.
From: Tina D Purnat
this might be a stupid question -- but how do you enter decimals? If you are on a US (default) language, then the decimals must be with period -- like 2.65
OC does not accept well any commas for thousands in the number...
If you know which fields might be the issue -- see how you defined them in Excel and compare with how they get exported. It might be that OC database is expecting something different from what you are typing in -- and the web application is accepting it when you enter the data even if it should not...
2013/12/4 Tina D Purnat
Probably a field ypu included on the extract has some character that the OC export engine doesn't like. The export works as a transformer of one data format into the spss, excel, etc. If the data format comong into the export contaons something the transform script can't handle, it will stall.
Your error doesn't like a decimal number value... Bit you would need to find out in which field.
One way of trying to quick test is, try first to create a new dataset and tey to export it. If it doesn't work, then make a small fataset and keep trying if export works. Then add more fields and keep yesting if export works. This way you will eventually be able to deduce what field is causing the issue. Next step is to review the eCRFs and the data in this foeld, and try to figure out what is improper.
This is long wonded, bit it is the only way to figure out what is the problem and how you can avoid it on future...
On Dec 4, 2013 6:04 PM, Robin Wijsman wrote:
I have a question concerning the export of my 'dummy' OC database into SPSS. It is possible to create a dataset, however when I try to export the dataset to SPSS a message shows-up: "the extract data job failed with the message: for input string "3.9". More information may be available in the log files."
The funny thing is that the numbers change every time I try to extract the database. See attached Word file for a few sequential attempts. I was even more surprised when, after doing so a few times, a file was created (only once, there after the same errors occured) that could be opened in SPSS. All this seems quite strange to me.The same goes for Excel files. Extracting the CDISC files seems to work properly.
I'm using OC 3.1.4 and I'm just a simple MD without hardly any (untill recently....) background in computer science. Please help me out! :-) In the attachment the logfiles.
Thank you very much in advance.
CRF_Patienttest_1.xls 93.5 KB
CRF_Tumortest.xls 80.0 KB