Fieldcode Manual

Tip: You can use filters for better results

If you want to import tickets from another system you can use the ticket import.
The tool gives you the option to import excel sheets with Ticket data into the Fieldcode Work Place with the right standards.

Go to sidebar -> Ticket import button

The import is clustered into five steps:
1. Upload -> 2. Configuration -> 3. Test -> 4. Import -> 5. Done

You don’t want to prepare your .xls file for yourself?   
No problem, just use our template and replace it with your ticket data!

  1. Select the Project Name you want to assign your Excel File to via the dropdown.
  2. Select the Configuration you want to use with your Excel File to via the dropdown.
  3. Click Add File and select the Excel File you want to import with File explorer OR drag it directly from your desktop to the Drag & Drop window.
    Please wait until the file is added.
  4. Click NEXT to proceed to the next step.
Prepating the excel file

The excel file must begin on sheet 1 and header A1.
Please also ensure that you stick to the format specifications in order to make the ticket import as smooth as possible:

  • The LSDT date must be formatted in this scheme: YYYY/MM/DD
  • The system uses the GMT timezone, therefore please make sure to convert the LSDT date and time fields accordingly in your template first 
  • The preferred appointment time must be formatted in this scheme: YYYY/MM/DD
  • YYYY/DD/MM formatting will cause failed validation
  • Only .xlsx and .xls files are accepted by the ticket importer
Upload step

You have the following options in this menu:

Switch your Excel FieldsAdjust to Fieldcode Ticket FieldsEdit ValuesAllow Duplicates and / or advanced options.

  1. Switch Excel fields: Mandatory fields are necessary for system to process. By clicking the drop down in one of these fields you can chose another field that should be mapped to Fieldcode Ticket Fields.
  2. Adjust to Fieldcode ticket fields: The system tries to also adjust additional fields to Fieldcode Mapping and suggests appropriate fields. However, they can also be further mapped manually by clicking the drop-down.
  3. Edit Values: By clicking the button inside a field you can change the assigned value (subcategory, category, or boolean) of your field.
  4. Allow duplicates: This toggle decides if the remaining fields that contain the same data are further allowed to be kept in the import process or should be kicked out. The default setting is Duplicates allowed.
  5. Advanced options: When the context menu is chosen, you can see three dots beside every row which enable further functionality. In the context menu, you have the options to Add fixed valuesAdd Prefix, and Add Suffix to the selected Ticket field. Click Save after you are making changes here, otherwise, changes won’t be saved.

You can click on the preview to check if you are satisfied with your mapping. 
After that click on Test configuration to proceed to the next step.

The importer now runs through automatically and validates your field mappings. The validation can either fail or succeed.

Test failed

In case the test failed you will be prompted with the errors and the affected tickets and can go back to configuration or Skip & Start import (not recommended!).

Test succeeded

In case of success, you can click on Start import to start the next step.

The Import will now run through automatically while showing the number of tickets that are being processed.

The import can either run through successfully as above or with skipped tickets as below.

Successfully importing tickets
Partial-successfully importing with skipped tickets

Regardless of how the Import ends you have two options now.
Either click DONE to finish the process or press click here (as shown in the screenshot above) to save the configuration for later purposes.

If you click on click here you have to do the following to save your configuration:

Saving the import configuration for later usage
  1. Insert a name for your configuration.
  2. Insert a description for your configuration.
  3. Click on Save.
Was this topic helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we further improve this topic?
Please submit the reason for your vote so that we can improve this topic.