Export Data to Text File
To export data, choose Export from the Data Sets menu of OptiPath (or choose Export from the Results menu). Data will be written in tab delimited text format (fields are separated by tabs). Spreadsheet programs, database programs and word processors should be able to import the file with no difficulty. The information for the artifacts, assemblages, features, seriation and data set for the active seriation will be included in the exported file. If you want to export all of the seriations for a data set, you must do so one at a time. To export an OptiPath to Excel is a two step procedure. First, export the OptiPath data to a text file, and then import the text file into Excel.
Note that if you export a data set to a tab delimited file and then import that file into Excel and save it as an Excel file, that Excel file must be modified before trying to import it into OptiPath. All but the last set of rows (those defining artifacts and assemblages) must be deleted. The deleted rows are those describing the data set, the seriation and the features. You may also want to delete the rows with Names EARLIER and LATER, and columns named Exclude, Distance and Rate. If you do not delete these two rows and three columns you will get a warning message for each one saying it is being ignored.
Warning! Tabs in the data will be converted to spaces. This is unlikely to occur as it is difficult to get tabs into the data.
Warning! If the string _)!(%*
appears in your data, it will be replaced by a tab in the text file (the string is used as a temporary
place holder for tabs and then converted to a tab).
A standard Windows Save File dialog will appear (titled Select Output File in OptiPath).
You do not need to locate an existing file. OptiPath will create a new file if the named file does not exist. If the named file does exist, OptiPath will overwrite it with the data from the data set being exported.
If the data set is exported successfully, you will be reminded of the file and folder location.
