Import From File Window

This functionality can be used to import information from a file into fields for existing animals. For example, if you had ultrasound or carcass data that was sent to you as a file, you could import it into Fusion using this window.

Choosing a File

When you first choose this option in the Animal List window, you will be asked to choose a file. Fusion can deal with tab-delimited and CSV. It can also handle the specialized "B5" carcass data file from Cargill. Make sure you are choosing one of the supported file types.

Showing File Contents

After you have chosen a file, Fusion will read the file in and attempt to split each row into columns. It will then display these rows and columns in a grid type format. The first step is to look at the information in this grid and make sure it looks like Fusion split the rows and columns up the way you were expecting. If it did not, the structure of the file may not be supported by Fusion.

Choosing What To Import

You can choose which columns and rows from the file you will import and what fields each column will be imported into. You also need to tell Fusion how to figure out which row should be associated with which animal so it saves the new data to the correct animal.

The left most column is labeled Import. When the import takes place, Fusion will only import rows where this column is checked. For example, some files will have header information in the first row which you would not want to import. Make sure you uncheck rows that shouldn't be imported. You can Alt-Click (Option-Click on Mac) a checkbox to change all the rows at the same time.

For the other columns, you need to Right-Click a column header and choose an option to tell Fusion how to handle this column.

When you are done, the column headers will describe which field (if any) the column will be imported into. Purple columns are "match" columns and green columns are "import" columns. White columns will be ignored.

Importing

To start the import, click the Import… button. You will be given two options:

About Errors

When errors are being shown, you can scroll through the list looking for each row that has an error. If you have a lot of rows and few errors, it may be hard to find each error. When errors shown, there is a Show Next Error button that can be used repeatedly to have Fusion show you the next error in the list.

Presets

If you need to import the same type of file many times, you won't want to have to set up each column association over and over. Instead, you can save the setup as a preset and apply that preset each time you pick a similar file.

Saving a Preset

Once you have associated columns and fields and are sure the import will work correctly, click the Presets… button and choose Manage Presets. You want to add the current setup as a new preset, so click the + button in the window that appear. You can then give the preset a name so you can use it in the future.

If you make more changes and want to save the changes, click the Presets… button again and choose Save Changes To Current Preset.

Using a Preset

You can use a preset by clicking the Presets… button and choosing Manage Presets. In the window that appears, select the desired preset and click the Use Selected Preset button. While you are in this window, you can Double-Click the name of a preset to change the name. You can also select a preset and click the - button to delete it.

After you have chosen a preset, Fusion will apply it to the columns and show the name of the preset being used next to the Presets… button.

What's In a Preset

A preset saves each column/field association. It also saves whether the first row should be imported or not. It does not save whether other rows should be imported or not, so if you have a file where the first several rows should never be imported, you will need to manually uncheck the other rows each time.

After the Import

When the import has completed successfully, Fusion will put a special filter on the Animal List window so that only animals that were involved in the import are shown. This gives you a chance to see that things happened correctly. Click the Clear button in the Animal List window to remove this filter.

warning icon You cannot undo an import! If you are trying an import for the first time, consider trying with only one or two rows and checking that it works the way you expect first.

Getting Here

You can open this window by choosing Modify → Import From File… from the Animal List window.

Related Topics