Upload SNPs Info

Previous Next

The Upload SNPs Info page allows you to incorporate data about SNPs present in SNPator from a XML file.

To make it easier for user to generate 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:

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

3. Open the file snps.xls (remember that this file contains macros, so you must set your Excel options to allow macros). The file must look like this (depending on your Microsoft Office version):

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.

The "code" field must coincide with the SNP code already present in SNPator. Otherwise the SNP will be discarded and no information for it will be uploaded.

To make data entering easier, the "chromosome" and "position" fields can be automatically filled-up by SNPator once the every SNP dbSNP IDs has been uploaded. To do so, remember to fill-up now the "dbsnp" field in order to identify the SNP in the dbSNP public database.

If you have defined some Descriptors for this study, you can add their names into 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:

Now just give a name to the XML file that is going to be created and press OK:

You now have a XML file ready to upload to SNPator.