Expression Dataset Will Not Open

Symptom: An attempt to open an Expression Dataset gives an "Open somewhere else" error even though it cannot be open anywhere else.

Solution: An Expression Dataset opened for editing (in the Expression Dataset Manager) works with a temporary file in the program folder (typically C:\Program Files\GenMAPP 2) that has the same name as the Expression Dataset and the extension .$gx. If the program or the computer crashes while editing an Expression Dataset, that file will be left in place. GenMAPP uses the existence of that file to determine whether an Expression Dataset may be edited. Be sure that the Expression Dataset is not being edited by GenMAPP and then delete the .$gx file. If GenMAPP is not open, it is safe to delete all .$gx files.

Converting an Excel Spreadsheet to CSV

1. With the Excel spreadsheet open to the desired sheet, click on File > Save As.
2. In the "Save as type" drop-down list, choose CSV (Comma delimited) (*.csv).
3. Click Save.
4. If the spreadsheet has more than one sheet, Excel produces a warning concerning multiple sheets. Ensure that the desired sheet is open in Excel and click OK.
5. Then Excel warns about features that are not compatible with the CSV file. These are formatting features, not data, so click Yes. Close the file. Excel will ask if you want to save the changes to the file, even if you have not made any changes. it is OK to clock No if you have not made any changes.
6. Launch GenMAPP.

Converting an Excel Spreadsheet to Tab-Delimited Text

1. With the Excel spreadsheet open to the desired sheet, click on File > Save As.
2. In the "Save as type" drop-down list, choose Text (Tab delimited) (*.txt). Do not choose Unicode Text.
3. Click Save.
4. If the spreadsheet has more than one sheet, Excel produces a warning concerning multiple sheets. Ensure that the desired sheet is open in Excel and click OK.
5. Then Excel warns about features that are not compatible with the Tab-delimited file. These are formatting features, not data, so click Yes. Close the file. Excel will ask if you want to save the changes to the file, even if you have not made any changes. it is OK to clock No if you have not made any changes.
6. Launch GenMAPP.