# How to Import Tickets

***

## Setting up your Import <a href="#setting_up_your_import" id="setting_up_your_import"></a>

{% hint style="warning" %}
You must be logged into an **Admin** account the access the Import Format page
{% endhint %}

{% stepper %}
{% step %}

### Navigate to \[ Settings > Import Format ]

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FNP1d88ALcvUJ400Wbb0E%2Fimage.png?alt=media&#x26;token=e6569ad4-be4e-46de-8c9f-6ca97f72a501" alt=""><figcaption></figcaption></figure>

{% endstep %}

{% step %}

### Click on \[ + New Format ]

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FKN5PZM02jeHhrbYB91UQ%2Fimage.png?alt=media&#x26;token=5c4c3b08-4a6e-44c1-a1cd-4e1b1ae78590" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Fill the Required Fields

The minimum required fields are the **\[** **Format Name ]** and all fields with a **\[ 0 ]**

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FtWc0ku2snopMXrUtKBMR%2Fimage_2025-07-09_124605145.png?alt=media&#x26;token=d16cb9b5-2696-4340-9fe9-fc277dc9461c" alt=""><figcaption><p>If you are importing Orderless Tickets, fields with a * are also required</p></figcaption></figure>

Match your fields to the corresponding number of the column in your export with the column containing that information on your CSV

{% hint style="info" %}
Numbers will replace the letter of the column in your export:\
**A** = **1**, **B** = **2**, **C** = **3**, **D** = **4**, etc.
{% endhint %}

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FpCliw4lUvKU6qlcMcne6%2Fimage.png?alt=media&#x26;token=acc37752-7c95-466c-ae07-b6f766d942e3" alt=""><figcaption></figcaption></figure>

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FwGhPyT8T6sLszrgvu9Qr%2Fimage_2025-07-09_125543044.png?alt=media&#x26;token=8d298570-34d0-4e9b-a292-0230198429ef" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
"**Header Row**" is checked because the CSV in the above example does have a header row, this can be left unchecked if your columns do not have headers.
{% endhint %}
{% endstep %}

{% step %}

### Click \[ **✓** Update ]

The Import Format should now be created! Follow the **Importing Ticket Data** steps below to see how to use it.
{% endstep %}
{% endstepper %}

***

## Importing Ticket Data

{% stepper %}
{% step %}

### Navigate to \[ Tickets > Ticket Import ]

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2Fo1cjIhyR5UMCtXja2ySt%2Fimage.png?alt=media&#x26;token=6cfbc6b1-931f-4596-8d4c-9771a75be951" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Fill the required fields

Select the ticket import **Format**, **Import File** (CSV), **Region**, **Location** and **Yard**

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FSg49Ws4XOauS4yLLVPSd%2Fimage.png?alt=media&#x26;token=7db810a5-98ad-4681-9e20-18039aa5da16" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*Overwrite Date*: Will overwrite all dates on tickets being imported\
\&#xNAN;*Overwrite Hauler*: Will overwrite all haulers on tickets being imported\
\&#xNAN;*Add New Trucks*: Will add trucks on tickets being imported, if they are not in Fast-Weigh
{% endhint %}

{% endstep %}

{% step %}

### Click \[ Upload ]

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FJrU9jqFScOIELp6CJcpd%2Fimage_2025-07-09_132739862.png?alt=media&#x26;token=9eca2d94-1498-4722-aecb-2c78ae1893d3" alt=""><figcaption></figcaption></figure>

• Go over the import and the CSV to correct any errors if present

{% hint style="info" %}
Errors are shown in the right most column. This error is stating that the order being applied is not valid
{% endhint %}

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2Fit7QDNWjOO13qyuodyLQ%2Fimage.png?alt=media&#x26;token=888d3e36-bd8c-4427-b6ac-03869c469871" alt=""><figcaption></figcaption></figure>

• Once all errors are cleared, the tickets will have green check marks next to them

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FTTHs7b5xJVl59V3i8J07%2Fimage.png?alt=media&#x26;token=84e6e81b-d8d1-430f-87df-e8dab12d0fcd" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Click the \[ Save ] Button

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2F7Vrw9YPG1eALqTyQG2qS%2Fimage.png?alt=media&#x26;token=40631cff-682d-4023-9fec-6db0900b59a5" alt=""><figcaption></figcaption></figure>

The tickets should now be imported and viewable from the **Ticket Query**

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FHi0PvyWQH9lHxWITFgCZ%2Fimage.png?alt=media&#x26;token=635b0c08-13e7-40de-a7bc-61fdeb1beb45" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

***

## References

{% content-ref url="../../references/web-portal/tickets/ticket-import" %}
[ticket-import](https://help.tacinsight.com/fast-weigh-knowledge-base/references/web-portal/tickets/ticket-import)
{% endcontent-ref %}