Upload Samples
Previous  Next



The Upload Samples page allows us to incorporate data of a set of Samples from an XML file.

graphic

If you try to upload a Sample that already exists in the Study, it will not be possible unless you have ticked the option Overwrite sample if code already exists. In this case all new information for this specific sample will overwrite the old one.

In order to make easier for user to generate the XML files, SNPator provides some Excel files in the Public downloads section. These Excel files incorporate a macro that creates XML files from the spreadsheet.

A possible way to proceed (by no means the only one) would be as follows:

1. Download the Excel files from the Public downloads section:

graphic

2. Extract the Excel files from the *.tar file into your local disc.

3. Open the file samples.xls (remember that this file contains macros, so you must set your Excel options  to allow macros). Once opened the file has to look like this:

graphic


4. The first two rows of the spreadsheet must be kept untouched (unless you have defined new Descriptors). All the information you want to upload into SNPator via XML must be entered into the remaining rows. Only the "code" field is mandatory. The rest of fields may or may not be needed depending on the kind of analysis you plan to perform using SNPator.

If you have defined some Descriptors for this study, you can add their names in the second row, just after the names of the standard fields. It is very important that these names match exactly the name of the descriptor you entered in the Descriptors Administration section.

5. Once you have entered all the data in the spreadsheet, you should execute the macro embedded in it:

graphic



Just give a name to the XML file that is going to be created and click OK:

graphic



You now have a XML file ready to upload to SNPator. After the upload of this file you will get a report in the User Results Section.