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 > > _________________________________________ 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]
