yougenmap Wiki

Your place to load, share, and compare genome maps

Brought to you by: batesokr, liangc_mu

Uploading Data

Uploading data to YouGenMap is done by placing the genetic marker data in a spreadsheet. When received on the back-end, the PHPExcel library is utilized for the reading spreadsheets. The allowed file formats are based on what file formats the library can read.

Excel5

This is the general Microsoft Excel format. The encompassing file formats are the Microsoft Excel Workbook (.xlsx) and the Microsoft Excel 97-2003 Worksheet (.xls). More information about either file format can be found here.

Excel2003XML

This is the Microsoft XML Spreadsheet file format. We require this format to have the extension '.xml' so that is can be recognized upon upload. More information about this file can be found here.

Open Office

This is the Open Document Format (ODF) or OASIS XML file format that OpenOffice uses. We require this format to have the extension '.ods' so that it can be recognized upon upload. More information about this file format can be found here.

File Formats NOT Supported

CSV

This is the Comma Separated Value (CVS) file format. While it is the case the library PHPExcel supports CSV files, CSV files only support one sheet. This limitation makes CSV files unusable for YouGenMap as the spreadsheets uploaded contain multiple sheets. More information about the CSV file format can be found here.

Gnumeric

This is the Gnumeric file format used for the Gnome Gnumeric Spreadsheet software. While it is the case the library PHPExcel mentions support for the Gnumeric file format, the library crashes when it reads a spreadsheet with such a file format. Our recommendation is to convert to the Open Document Format (.ods) which most Gnumeric software is capable of. More information about the Gnumeric file format can be found here.

SYLK

This is the Microsoft Multispan Symbolic Link Interchange (SYLK) file format. While it is the case the library PHPExcel supports SYLK files, SYLK files only support one sheet. This limitation makes SYLK files unusable for YouGenMap as the spreadsheets uploaded contain multiple sheets. More information about the SYLK file format can be found here.