Thank you Ben and Misha! I will try using these answers to move forward. I haven't made any progress since my first email. I will let you know if I have more questions and if I can get it to work, then I will add more instruction to the current documentation.
However, just to make sure I understood what Misha was saying; So the speadsheet import module can only create new patients and add in data. It can not add data to an existing patient. Is that correct? Thanks Evelyn On Thursday, September 22, 2011, Ben Wolfe wrote: > I've bolded Misha's responses to your questions below. Does that help you? > Were you ever able to do the import successfully? > > Ben > > > ---------- Forwarded message ---------- >> > From: "Evelyn Castle" <[email protected] <javascript:_e({}, >> 'cvml', '[email protected]');>> >> > Date: 2011 9 12 18:48 >> > Subject: Spreadsheet Import Module >> > To: <[email protected] <javascript:_e({}, 'cvml', >> '[email protected]');>> >> > >> > Hi All, >> > I am trying to use the spreadsheet import module and unfortunately, I am >> not >> > getting very far with it. I have the module installed and its running >> fine >> > on my system (version 1.8.2 of OMRS and 0.3 of spreadsheet import >> module). >> > Where I am getting stuck is designing the form. For example, I have a >> form >> > that has 3 columns, "Name of Woman", "Weight", "Parity" that I want to >> > import. >> > For the "Data" column, I need to "Select the location in the OpenMRS >> > database where the data from this column in the spreadsheet should be >> > placed." >> > For name of woman, I have it as "Person Name: Family Name". Questions: >> Is >> > this the right data option? >> *If this field corresponds to the person's last name, then yes.* >> >> > Will this create a new patient if the name is >> > not already in the database? >> *Yes* >> >> > Will it add to a patient record if their name >> > is already in the database? >> *No, it should, to the best of my memory, avoid processing that line of >> the spreadsheets. Modification of existing entries was not >> implemented.* >> >> > For weight and parity, should these be added as "Obs: Value Numeric"? >> *Yes* >> >> > For the "dataset index": Should "Name of woman" = "Unique Import into >> > Table", "Weight" = 1 and "Parity = 2? >> *The important thing here is that Weight = 1 and Parity = 2.* >> >> > After I click next, the screen appears that looks like the attached >> screen >> > shot. Is this how it is supposed to look? In the description for the >> module >> > on the wiki, it seems that this page is getting mixed up somehow. If it >> is >> > correct, can someone explain how to fill it out correctly? >> > *The trick is that you will also need a field from the Person table so >> that this table is created - for example Person: Birthdate. I believe >> you also will need to have a field (in your spreadsheet) from the >> Patient table, such as Patient Identifier: Identifier. If that is the >> case, then you will only have two concept dropboxes, the first of >> which will need to be Weight, and the second Parity.* >> >> I hope that helps. >> >> Misha >> >> > Thanks a lot for all of your help. If I can get this to work, it will >> save >> > me days (possibly a week) of entering back data so I REALLY want to get >> it >> > working :) >> > Evelyn >> > >> > >> > -- >> > Evelyn Castle >> > Co-Director, eHealth Nigeria >> > +1 415 545 8289 (US) >> > website: http://www.eHealthNigeria.org >> > blog: http://www.evelyncastle.com >> > skype: evelynlcastle >> > ________________________________ >> > Click here to unsubscribe from OpenMRS Implementers' mailing list >> > > > > ------------------------------ > Click here to unsubscribe <javascript:_e({}, 'cvml', > '[email protected]?body\x3dSIGNOFF%20openmrs-implement-l');>from > OpenMRS Implementers' mailing list -- Evelyn Castle Co-Director, eHealth Nigeria +1 415 545 8289 (US) website: http://www.eHealthNigeria.org blog: http://www.evelyncastle.com skype: evelynlcastle _________________________________________ 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]
