# Import Format

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FCcSXtrSU8Xyi0xgSCOAn%2Fimage.png?alt=media&#x26;token=facc654c-9134-4d8e-8d51-1199e28f6fb3" alt=""><figcaption></figcaption></figure>

***

## Page Overview

Columns

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FOC9wvfWjjbI1XCePKrEJ%2Fimage.png?alt=media&#x26;token=818ca680-c3ce-47d0-b4ff-1015a32b56da" alt="" width="563"><figcaption></figcaption></figure>

The table on the main screen shows the following:

* *Name:* The title of the import.
* *Type:* The file type of the import, either CSV or Fixed.
* *Time Zone:* The time zone the **tickets** were created.
* *Header:* If the imported file contains a Header.

***

## Adding a New Format

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FhGqmvJHYwd9cXW7MGCI4%2Fimage.png?alt=media&#x26;token=23bf70e1-6227-441c-89c8-6c7de8597cf1" alt=""><figcaption></figcaption></figure>

Clicking on the +New Format button will provide a new window to manually assign the column values for the expected imported file. Matching with the main menu, the information requested in this field is:

* *Format Name:* The name of the file import.
* *Format Type:* The format file type, either CSV or Fixed.
* *Time Zone:* The time zone the tickets were created.
* *Header Row:* If the file being imported contains a header row.
* *Column:* The matching columns of the import to Fast-Weigh.

The *Column* entry will take the most work to import the file. The ticket file being imported must match the columns expected with the entry field. The information that is **required** is noted with a ZERO in the entry field. This information **must** be included from the following fields:

* *Ticket*
* *Date*
* *Order*
* *Product*
* *Truck*
* *Net*

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2F3WtMhlEl79tn99zZo8uL%2Fimage.png?alt=media&#x26;token=a840cf39-c6c7-4bff-9f57-c8d2e92d3406" alt=""><figcaption><p>Click the image to expand.</p></figcaption></figure>

In the above example, we have information present in columns 1-12, then again in column 15. Although the information is available, only the following information is **required:**

* *Ticket -* Column 1
* *Date -* Column 2
* *Order -* Column 4
* *Product -* Column 5
* *Truck -* Column 6
* *Net -* Column 10

The created format will now allow you to [Import Tickets](https://help.tacinsight.com/fast-weigh-knowledge-base/references/web-portal/tickets/ticket-bulk-edit) into Fast-Weigh from an external system.

***

## Editing an Existing Format

\
If you need to import tickets after a format is created, and the information is mostly the same, you can edit an existing format instead of creating a brand new one and adjust the expected column location.

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2F1guDA8Fq9x2CKoQWSHE9%2Fimage.png?alt=media&#x26;token=6077ef59-0502-4369-a8b8-07285ab1a6ac" alt="" width="134"><figcaption></figcaption></figure>
