Getting started
Basic information
Company account
Employee accounts
Logging into the account
TransID
Overview of modules for Forwarders
Overview of modules for Carriers
Overview of modules for Shippers
Messenger
Messenger functions
Messenger settings
Contact groups on Messenger
Negotiation and acceptance of offers in the messenger - forwarders (TFF) and CargoON
Negotiations and acceptance of offers in the Messenger by the Carrier
Information in the chat window that the caller is on the debt exchange
Conversation archive
Freights
Management of sent freights
The freight archive
Payment term for a freight
Import of freights from a CSV file
Freight templates
Multifreight - handling the function by the client
Multifreight - handling the function by the carrier
Forms of freight settlement
Bulk actions on freights
Loads exchange
Add a freight offer
Delete freight offers
Searching for offers on the Freight exchange
Filter load offers
Editing filters
Search for freight offers on the map
Cost calculation on the Load exchange
Alerts before entering into cooperation
Pop-up menu in the exchange offer table
Offers received from a private exchange
Private freight exchange for forwarders
Humanitarian aid
Direct offers - Forwarder
Direct offers - Carrier
Invitations to Private Exchange with a CSV file
Operations at customs clearance points
Vehicle exchange
Add a vehicle offer
Deleting a vehicle offer
Search for vehicle offers
Calculation of route costs
Adding a contact person in the vehicle offer
Additional functions of the Vehicle Exchange
Orders
Create a new order
Handling orders as a contractor
Handling orders as a carrier
Order template
Archive of orders
Maps
Monitoring
(TFC) Carrier Monitoring
(TFF) Forwarder Monitoring
(CargoON) Shipper Monitoring
Possibility to manually mark the execution of an operation at a route point
Schedules
Warehouse management
Dock management in the warehouse
Time slot management
Booking management
Booking templates
Booking blocks
Handling attachments in bookings and time slots by the shipper
Providing weights during booking
Sharing a time slot with a user from outside the Platform
Employee roles in the Schedules and Bookings modules
Import of Time Slots and Bookings
Bookings
Received bookings and time slots
Booking manual for the Storekeeper
Booking manual for the Security Guard
Contractors
Invite a company to cooperation
Functions of the Contractors module
Adding a company to contractors
Creating groups of contractors
Possibility of suspending cooperation with a contractor
Fixed routes
Functions of the Fixed route modules
Send a fixed route offer to carriers
Edit a fixed route
Fixed route price/rate settings
Price a new fixed route as a carrier
Acceptance of fixed route offer by carrier
Reject a fixed route offer
Fixed routes with shippers
Assign a responsible person to a fixed route
Balancing types
Search, filter and archive fixed routes
Publication of freight offer to a fixed route
Ratings and References
Functions of the Ratings and References module
FAQ about ratings
Issued ratings
List of ratings in the exchange offer line
Payment statuses
Received ratings
References
Invoices
Fleet
History of vehicle routes and monitoring tasks
Adding a fleet and integration with telematics
Access data in telematics systems
Fleet module settings
Publishing a vehicle from the Fleet module
BI Reports
Reports - general information
Performance report
Benchmark report
Freights list report
Type & activity report
Negotiation report
On Time In Full (OTIF) report
Carrier activity report
Directions report
Savings Management report
Freights Overview report
Warehouse utility report - Dock Scheduler
Operation timeline report (Dock Scheduler)
Report - Carrier On Time (Dock Scheduler)
Payments
Automation rules
Adding an automation rule
Publication of freight and searching for carriers using a rule
Automation rule settings
Body
TransRisk
(TFC) Carrier TransRisk - an independent indicator of payment credibility
(TFF) Forwarder TransRisk - an independent indicator of payment credibility
(CargoOn) TransRisk - an independent indicator of payment credibility
Mobile application
Installation and download of the Loads2GO! application
Searching for load offers in Loads2GO!
Search for vehicle offers in Loads2GO!
Filtering freight offers in Loads2GO!
(TFC - Carrier) Negotiation and acceptance of the offer in Loads2Go!
(CargoOn) Negotiation and acceptance of the offer in Loads2Go!
Add a vehicle offer in Loads2GO!
My vehicle offers in Loads2GO!
Messenger in Loads2GO!
Notifications in Loads2Go!
Edit your profile in Loads2GO!
Additional services
Settings
You are here All categories > Freights > Import of freights from a CSV file
Import of freights from a CSV file
Updated 4 weeks ago by Jakub
Who can use this function?
|
Importing freights using files significantly shortens and streamlines work. Thanks to additional functionalities, such as mapping dictionary values, you will be able to quickly and effectively adapt your values in the file to those supported by the Trans.eu Platform. Thanks to this, you will not have to correct them each time during subsequent imports, the values will change automatically.
From this article you will learn:
- how to import freight to the Trans.eu platform using a .csv, .xls or .xlsx file
- how to map a dictionary value
38 STEPS
1. From Add freight, go to Import freight from CSV.
2. Previously, this was the freight import window. The process itself is simple and clear, but it requires the preparation of a file in a specific format and according to a specific template.
3. This often comes down to manual work, and this type of operation is associated with large expenditures of time or personnel, generating unnecessary costs.
4. In order to meet the expectations of our existing and future customers, we offer you a refreshed Smart Freight Importer.
5. Thanks to a flexible approach to the format and syntax of the file, we streamline the process of posting a large number of freight. In addition, we are adding some features that will have a positive impact on the efficiency of operational employees.
6. On the window frame, in the upper right corner, we pull out the link to Help, available at every stage of the process, where by means of an instructional article we will guide you step by step through the new process of importing freight.
7. In addition to the CSV format, our Smart Importer will also support XLS and XLSX formats, adapting to all TMS systems available on the market.
8. Uploading the file, now fully automatically, will take you to the next step – Matching freight data.
9. This is how Smart Freight Importer behaves if the uploaded file matches a previously supported .csv file template or a file mapping you have stored. We will talk about file mapping in a later section.
10. The Smart Importer window will behave in the following way if the uploaded file does not conform to the previously supported .csv file template or has a completely different syntax (e.g. different column names and/or a different column order).
11. In the left-hand panel, there is a checklist of mandatory freight parameters to be adjusted, which are the minimum necessary to post/save imported freight.
12. Clicking on a specific column, for example ‘Date Z’, will allow you to assign the data contained in it to the appropriate parameter on the platform side, in this particular case, the mandatory parameter, i.e. ‘Date of loading’.
13. The mapped column and the corresponding position on the checklist will be highlighted in green.
14. A file mapped as required activates the Save as Template option.
15. In the Save Template window, all you have to do is give the template a unique name and then save it.
16. The saved template will appear in the top left corner on the list of match templates and will be available to all users in the company.
17. Smart Importer always, as a first step after reading the file, if possible, attempts to auto-match with one of the stored templates.
18. The next step is the Import Summary.
19. A significant convenience is the ability to make changes for individual freight parameters directly in the freight import window.
20. This is particularly useful if the imported file contains errors.
21. Filtering the list using the option Show only freights with errors will allow you to quickly correct them.
22. For example, clicking on a specific active field will bring up a window that allows you to make changes in the area of specific freight parameters.
23. In the window that opens, by clicking on the field, you can also make changes to the postal code, city, street and number.
24. In the Import Summary, you also have the option to map your values supported by the Trans.eu Platform.
25. Confirm saving the values with the Save dictionary value button.
26. The mapped value will appear in the Settings in the Freight import module.
27. The exception is the date format, for which the default mapping is applied. It is editable but does not create another dictionary value, instead it overwrites the existing one.
28. In the refreshed version of Importer, there is now a step for posting freights, where you can post all freights in the same way.
29. The default option enabled: Publish all freights in the same mode allows you to publish loads in a specific mode available to the client.
30. Unchecking this option opens up new possibilities. A freight list appears with the option to select multiple items from the list.
31. You can then choose one of the posting modes available to the client.
32. Embedded here is the option to save imported freight as a draft copy, which will invariably be subject to manual posting.
33. Moving on, you will see the corresponding posting modes assigned to each freight in the list.
34. By clicking Import freight, you start both the import process and the posting or draft copy process, which can continue in the background.
35. Until now, the ongoing freight import process prevented all users of a given company from starting another import until the current one was completed, all the while taking up valuable time. The new version of the Importer solves this problem.
36. You will receive a notification when the import is complete. By clicking it, you will be taken to the Summary.
37. The Freight Import Summary appears.
38. Finally, the imported freights are added to the list of Added Freights with appropriate statuses.
Here's an interactive tutorial
** Best experienced in Full Screen (click the icon in the top right corner before you begin) **https://www.iorad.com/player/2306929/importer-fracht-w---EN-2
Freight import and importer data
Expand the arrow next to the Add freight button, then select Import freights from CSV.
- Upload your file and go to the next step.
- In the Freight data matching step, you can easily adjust the values from your file to the values required by the Trans.eu Platform. The built-in dictionary will be helpful in quickly indicating which field on the Platform corresponds to your column in the file.
- Example 1
- All freights will be imported. Click Next to go to Publication parameters.
- Example 2
- Only recognized freights will be imported. In the table you will receive information on which of the freights the error occurred. You can correct wrong values directly in the import window and click Next to go to Publication parameters.
- Complete the Date of payment, Receivers and Contact persons, and then confirm with the Import freight button.
You can publish all imported freights in the same mode, each separately, or select several of them.
You will receive a notification when the import is complete.
You will see the summary as well.
- Example 3
- No freights will be imported. Correct your file and try again.
- Example 4
- Incorrect file format. Please check your file and try again.
- Remember that it is not possible to add the same file multiple times.
- Using the function contrary to the regulations (e.g. duplicating offers) may result in the revocation of the ability to import offers.
Mapping dictionary values
In the Import summary you can use the option to map your column values.
- Click the appropriate field and select a value from the list.
- Confirm saving the value by pressing the Save dictionary value button.
The mapped value will appear in Settings in the Importing freight module.
You can edit, delete or add dictionary values here.