Hi Sokha, A few months ago when I released a new version of the spreadsheet module I was able to import the testdata.xls. I suspect I was running a relatively recent release of OpenMRS during development and testing. Which version of OpenMRS are you running the module on?
If you are still running into trouble please feel free to submit a ticket ( https://tickets.openmrs.org/browse/SIM). Best, Stephen On Tue, Mar 6, 2012 at 5:36 AM, Sokha RUM <[email protected]> wrote: > Is there anyone can successfully import with Spreadsheet Import Module. I > tried with the testdata/testdata.xls, but it did not work. > See the error that i got: > > An Internal Error has Occurred > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException > > Cannot add or update a child row: a foreign key constraint fails > (`openmrs`.`patient_identifier`, CONSTRAINT `defines_identifier_type` > FOREIGN KEY (`identifier_type`) REFERENCES `patient_identifier_type` > (`patient_identifier_type_id`)) > > > Is there something wrong with my config (see attached file) ? > > > > _________________________________________ > > To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to > [email protected] with "SIGNOFF openmrs-devel-l" in the body > (not the subject) of your e-mail. > > [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l] > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
