Uploading data is a simple process in Tercen.

This article will get you familiar with how to do it and what settings there are for the more advanced options.


Prerequisites:

Some things you need to check before you start.

Data is uploaded to a Tercen Project. Make sure you have one created before you start following this guide.

It is always a good idea to review your data file in a text viewer or MS Excel to make sure you don't have any missing values or any important numbers that are input as text.


No time to read?

Watch a video of how it's done:

tip: Open the video in another browser tab beside Tercen. That way, you can pause it and follow along with the instructions.


Upload a data file

On the project screen, there is a button called New Data Set.

This opens the screen to choose the type of file you are uploading.

Standard files are Microsoft Excel files or Delimited Text files such as (.csv or .tsv)

There are also options for some of the proprietary file types that specific analysis machines output.

Choose the file type you want to upload.

Then browse to the file location and select it.

You can give the data an alternative name to the filename.

Now press the Upload button.

If it is an Excel file or a Machine file, you are done.

Congratulations!

You can move on to analysing your data by making a workflow.

For a Delimited Text file you will see one more screen...

Working with Delimited Text Files

They are the oldest type of data file, and they live by their own rules.

Here you can adjust the Header names for your data.

Tercen detects if you have numbers or characters in your column of data. It is worth knowing that if Tercen detects a character (a letter or a symbol) in even one field of your data, it will treat that whole column as text.

You can stop the import, correct the field, and re-start the process. Or you can tell Tercen to treat the column the way you want it (number or text), and it will replace any empty fields or numbers with text as "NaN" which means "not a number."

By default, NaN gets excluded from any calculations.

Press Upload and you are done.

Congratulations!

The world of data analysis awaits when you create a workflow.

Still feeling adventurous?

Advanced Settings

Journey through the weird and wonderful world of Delimited Text files.

Delimited Text files have some import parameters depending on how the file was put together during creation. The Tercen importer detects these and looks to process the file in the best way it can. If you have some advanced knowledge of how Delimited Text files work, or you hit an error message from Tercen, you can change the detected settings by hand.

Click Settings on the choose file page to open up the panel.

Some files do not have a header row, so by selecting false Tercen will automatically generate headers for your file.

Text files are encoded with character sets that dictate the types of symbols displayed properly on a computer. Normal a-z and 0-9 is never a problem, but you may have scientific notation or pictographic characters (such as Kanji) in your data. You may have to change setting here to get these tom import.

The Delimited part of a Delimited File usually means a comma or a Tab to separate the data. But your file may have a different character like a semicolon. It might even have more than one separator if it was amalgamated from different files. You can select them here.

String Delimiter is the quote marks you are using to identify long passages of text. There might be commas in that text breaking up a normal sentence, and you don't want Tercen to see that as a Delimiter.

Lastly, many researchers put comments into their data files. If you have marked out a line with a character, like a Hash #, then select it here and Tercen will ignore it when the import happens.

Did this answer your question?