The Import Attributes functionality allows you to update attributes for multiple containers in a single action using a CSV file. This is especially useful when handling large-scale updates efficiently.
The process is based on uploading a CSV (comma-separated values) file containing:
- A list of container numbers
- The attribute changes you want to apply
Let's explain the different possibilities
- Add an attribute: Goal is to add an attribute with a certain value, even if this attribute is already linked to the container. This makes it possible to add multiple values of the same attribute to a container.
- Replace an attribute: Goal is to replace the value of an existing attribute. The attribute will be added if the attribute is not found in the list of attributes for this container.
- Remove a value from an attribute. Goal is to remove the attribute with that value, if an attribute with that key and that value is found on the MMT. You have to pass the value that has to be removed.
- Clear an attribute. Goal is to remove the attribute and its value from that container
The tricky part is that you have to inform Streamliner which action you want to take.
To tell Streamliner which action to perform, use specific column headers in your CSV file:
| Action | Column Header Format | Example |
|---|---|---|
| Add | attributes.add.<attribute_key> | attributes.add.seal |
| Replace | attributes.replace.<attribute_key> | attributes.replace.seal |
| Remove | attributes.remove.<attribute_key> | attributes.remove.seal |
| Clear | attributes.clear.<attribute_key> | attributes.clear.seal |
You can combine multiple actions in one file or execute them separately.
Important Notes
- Only non-archived containers are processed
- Column order does not matter
- Only the following columns are required:
container_number- Action columns
- All other columns are ignored
Step-by-Step Instructions
Step 1: Navigate to Multimodal Transport
Go to the Multimodal Transport tab in the plugin Streamliner.
Step 2: Prepare Your CSV File
Include a container number .
container_number- Add additional columns for each action you want to perform.
Example:
container_number,attributes.add.seal
CONT1234567,ABC123
CONT7654321,XYZ789Result:
The attribute Seal will be added to each listed container with the specified value.
Container CONT1234567 will have:
- seal = ABC123
Container CONT7654321 will have:
- seal = DEF456
đź’ˇ Tip:
Export a small selection from the MMT list and use it as a template.
Step 3: Select “Import Attributes”
Open the Import Attributes function in the application.
Step 4: Preview or Import
You have two options:
Preview (When you want to test a new action)
- Validates the CSV structure
- Generates a result file showing what changes would be applied
- No actual changes are made
- A preview result file is downloaded on your PC.
Use this to verify your file before importing.
Import
- Applies the changes immediately
- The system confirms:
- Number of containers affected
- Any errors encountered
Step 5: Verify Results
After importing, review the updated containers to confirm that the attribute changes were applied correctly.
Best Practices
- Start with simple files before combining multiple actions
- Use Preview for you first files
- Ensure attribute names (keys) are consistent and correctly spelled
- Double-check values when using the remove action
Comments
0 comments
Please sign in to leave a comment.