What is the origin of the ODM file? I would rather use a PQSQL backup file from the original OC database to restore the database.
I do not think so, but on the other hand I'm not a technical expert, just a Clinical Pharmacologist , but I would assume to import the ODM file it must have some place to put the data. I know that by using WEB services you can create visits and ad patients but as far as I know not create a whole study. Maybe Gerben or Christian can give you further guidance how to solve you problem!
I've done similar imports: from OC3042 with Oracle into OC33 with Postgresql. If you, or anyone else, are interested, I can upload the MsAccess-utility I used, but it is a tool that you must modify for each new project, I'm afraid. Then you still must manually
- create the Study
- create the Events
- upload the CRFs
From there on you can automate, provided you have web-services running.
I have a
rather unusual questions for you, I'm using your excellent MS ACCESS tool for
data management and it works like a charm with OpenClinica, Now I got request
to either import data directly into your tool or via the unneeded detour to
first import data into OpenClinica and then into your tool via the standard export
utilities. This seems very much overdoing it as I do not need any of the OC
extensions for this job,. The data is stored in a regular ODM 1.3 file but no
OC extensions. Is it possible to get the data into your tool without to many
modifications in the too. The ultimate goal is to have the data in a “long and
skinny” table, similar to your TblClinicalData from which I create all listings
is there a simple way to do this – importing a regular ODM 1,3 file into your
MS ACCESS system?