I'm not sure, I think you'll have to play around with it. Try with a small import to see if it appends records or just skips that line of the import.
Ben On Thu, Sep 22, 2011 at 7:06 PM, Evelyn Castle <[email protected]>wrote: > 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]> >>> > Date: 2011 9 12 18:48 >>> > Subject: Spreadsheet Import Module >>> > To: <[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 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 > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>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]
