That is awesome, Joaquin! -------------------- Andrew S. Kanter, MD MPH
- Director of Health Information Systems/Medical Informatics Millennium Villages Project, Earth Institute, Columbia University - Asst. Prof. of Clinical Biomedical Informatics and Clinical Epidemiology Columbia University Email: [email protected] Mobile: +1 (646) 469-2421 Office: +1 (212) 305-4842 Skype: akanter-ippnw Yahoo: andy_kanter >________________________________ > From: Joaquín Blaya <[email protected]> >To: [email protected] >Sent: Friday, March 30, 2012 4:35 PM >Subject: Re: [OPENMRS-IMPLEMENTERS] Spreadsheet Import Module > > >We will fix the module to work with OpenMRS 1.9 RC2. I hope that this should >be done a month or so depending on our other work load. > >Joaquín >___________________________________________________________________ >Gerente de Desarrollo, eHealth Systems >Research Fellow, Escuela de Medicina de Harvard >Moderador, GHDOnline.org > > > >On Mon, Mar 26, 2012 at 4:00 PM, Ben Wolfe <[email protected]> wrote: > >Tobin >> >>I don't think the original developer is around anymore. (Any takers?) >> >>My guess from this error is that the drug.concept value is not something that >>is in your concept.concept_id column. Is that something you can set or is >>that done by the module? >> >>Ben >> >> >> >>On Wed, Mar 14, 2012 at 7:10 PM, Tobin Greensweig <[email protected]> >>wrote: >> >>Hello, >>> >>> >>>Does I am wondering if anybody has experience using the Spreadsheet Import >>>Module with v 1.8.3? Is it supported? >>> >>> >>>I am attempting to import Concept Drugs from a CSV. In the administration >>>area I setup the import template but the module never asks >>>about Pre-specified values (which would be needed in this case). When I go >>>to finalize the import I get an error that a foreign key hasn't been >>>defined... >>> >>> >>>Thank you, >>> >>> >>>Tobin >>> >>> >>> >>> >>> >>> >>>An Internal Error has >>>Occurredcom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException >>>Cannot add or update a child row: a foreign key constraint fails >>>(`openmrs183`.`drug`, CONSTRAINT `primary_drug_concept` FOREIGN KEY >>>(`concept_id`) REFERENCES `concept` (`concept_id`)) >>> >>>Consult the help document. >>>Contact your friendly neighborhood administrator if it cannot be resolved. >>> >>>Hide stack trace >>> >>>sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>>sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >>>java.lang.reflect.Constructor.newInstance(Constructor.java:513) >>>com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >>>com.mysql.jdbc.Util.getInstance(Util.java:381) >>>com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) >>>com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >>>com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) >>>com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) >>>com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) >>>com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) >>>com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) >>>com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1634) >>>com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1715) >>>org.openmrs.module.spreadsheetimport.DatabaseBackend.importData(DatabaseBackend.java:442) >>>org.openmrs.module.spreadsheetimport.SpreadsheetImportUtil.importTemplate(SpreadsheetImportUtil.java:285) >>>org.openmrs.module.spreadsheetimport.web.controller.SpreadsheetImportImportFormController.processSubmit(SpreadsheetImportImportFormController.java:101) >>>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>java.lang.reflect.Method.invoke(Method.java:597) >>>org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) >>>org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426) >>>org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) >>>org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) >>>org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) >>>org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) >>>org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) >>>javax.servlet.http.HttpServlet.service(HttpServlet.java:637) >>>javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:65) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:76) >>>org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:58) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:112) >>>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) >>>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:83) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:83) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:83) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) >>>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >>>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >>>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >>>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >>>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >>>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) >>>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) >>>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) >>>org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >>>java.lang.Thread.run(Thread.java:680) >>> >>> >>>OpenMRS Version: 1.8.3 Build 24510 >>> >>>The following data will be submitted with the report to enable the team to >>>resolve the problem. >>> * The error message and stack trace >>> * OpenMRS version >>> * Application server name and version >>> * Username of the user currently logged in >>> * The implementation id of this installation (if defined) >>> * Names and versions of all installed modules >>> >>> >>> >>> >>>________________________________ >>> Click here to unsubscribe from OpenMRS Implementers' mailing list >>>>________________________________ >> Click here to unsubscribe from OpenMRS Implementers' mailing list >>________________________________ > Click here to unsubscribe from OpenMRS Implementers' mailing list > > _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
