4. Integration
Read this section to learn more about the preparation of diamond data to upload to Tracr and how to monitor an integration session.
Overview
Tracr provides two ways of integrating diamond data:
Integration Tool available on the Tracr Management Portal. Use the Integration Tool to manually upload your diamond data files.
Tracr Loader available for Windows-based operating systems. Use Tracr Loader to automate the file upload process. You can download the Tracr Loader application and user guide from the Integration toolkit.
Key concepts
Before you integrate your diamond data, it is important that you understand the following key concepts:
A participant must claim the provenance of a diamond. Therefore, to register a diamond on Tracr, you must provide information about each diamond from a box so that Tracr can match the box information. If a diamond scan or video is provided, Tracr will also try to identify that single diamond individually.
To register a rough diamond 'family' (all splits and polished), Tracr must be aware of all the diamonds and how they are linked. Tracr therefore requires each diamond to have a unique participant_id. Each split part of the diamond must have a unique ID. Each polished diamond must also have a unique ID so that Tracr knows which diamond is being polished and the new name of its polished version.
Tracr keeps information about each step from rough to polished. To link diamonds, you must always register the parent diamond first. To register a split diamond, Tracr must know the rough diamond (or the split, if it is a 'split of a split'). To register a polished diamond, Tracr must know which diamond is being polished.
Prepare your diamond data for an integration
To register diamonds on Tracr, you must upload the required data through the Tracr Management Portal or the Tracr Loader whenever the diamond changes form and/or is passed from one process to another. This includes windowing and when unexpected incidents happen during the manufacturing process. You can also upload optional files like images and videos to enhance the Diamond Experience.
Provided you have all the required data, you can upload multiple diamonds at once provided all diamonds in the upload are at the same stage. You cannot upload rough, all split, and polished diamonds in the same CSV file as Tracr requires different templates for different manufacturing steps.
Prepare a rough diamond dataset
To integrate rough diamonds, you will need to provide basic information about the diamonds, including the carat, and some information about the sight box, including the year, sight number, and sight box ID. Tracr uses this information to check:
If the box exists and has been assigned to you.
That you are uploading the correct number of carats (total) in the box.
Please note:
Tracr does not require the scan and the plan to be provided for rough diamonds.
Providing the images and videos is optional, however, this will greatly improve the Diamond Experience.
Use the Data Dictionary
It is recommended that you download and use the Data Dictionary (Integration Tool > Integration toolkit > Data dictionary) to help you to populate the CSV file. Filter the Data Dictionary by "Stone State = Rough". Ensure that you populate fields with the column "Required = true".
Additional data fields to upload a scan file
Tracr requires two additional data fields when uploading a scan file:
scan_device_manufacturer
scan_device_model
Supported technologies
Lexus Helium
The Cutwise platform offers a service to convert 3D Scans to STL files. https://pricing.cutwise.com/conversion/ox2z-stl Please contact Lexus India for more details.
Values for the additional fields are: scan_device_manufacturer : "Lexus SoftMac" scan_device_model : "Model name of your device"
Diabot
InnovSeed Diabot generates an open STL file which can be uploaded into Tracr.
Values for the additional fields are: scan_device_manufacturer : "InnovSeed" scan_device_model : "Diabot" or "Diabot NX"
Sarine
If you require to use a Sarine device to upload a 3D scan to Tracr, please contact our Support Team for more details.
Prepare a split diamond dataset
This procedure applies to every modification to the diamond after the rough session and before the diamond is polished. If the rough diamond is split during the manufacturing process, every part that was split has to be declared using a new participant ID and linked to the parent diamond.
Please note:
Tracr does not require the scan and the plan to be provided for the split diamonds.
Ensure that the parent diamond is always registered before submitting the split diamond - the parent needs to be declared first.
Providing the images and videos is optional, however, this will greatly improve the Diamond Experience.
Every time you split a rough diamond, each split will receive a new unique Tracr ID.
Use the Data Dictionary
It is recommended that you download and use the Data Dictionary (Integration Tool > Integration toolkit > Data dictionary) to help you to populate the CSV file. Filter the Data Dictionary by "Stone State = Split". Ensure that you populate fields with the column "Required = true".
Prepare a polished diamond dataset
Sarine Instructor
If you are using Sarine Instructor to provide a scan for polished diamonds, you need to generate an XML report and an STL export. Use the template provided by Tracr to export the report for each diamond.
To extract data for polished diamonds using Sarine Instructor, refer to Sarine Instructor: Extracting data for polished diamonds
In the CSV file, Tracr needs the STL file in the column scan, and the XML report in the column scan_report.
Helium software
If you are using Helium software to provide a scan for polished diamonds, you need to generate an HTM report and an STL export. Use the template provided by Tracr to export the report for each diamond. There are two types of Helium template:
Specific shape, only for a handful of shapes with additional information.
Generic, less information but you can use this template for all shapes.
In the CSV file, Tracr needs the STL file in the column scan, and the HTM report in the column scan_report.
For more information about exporting using a Helium Polish Scanner, please refer to the Helium Polish Scanner - Settings for Export (PDF).
Please note:
Before uploading polished diamond data, please make sure that you register the parent diamond on Tracr.
To verify the polished diamond, a 3D scan and the report of the scan of the diamond are crucial.
Providing the images and videos is optional, however, this will greatly improve the Diamond Experience.
Add the grading document to complete the polished digital asset.
Use the Data Dictionary
It is recommended that you download and use the Data Dictionary (Integration Tool > Integration toolkit > Data dictionary) to help you to populate the CSV file. Filter the Data Dictionary by "Stone State = Polished". Ensure that you populate fields with the column "Required = true".
Sarine Instructor: Extracting data for polished diamonds
Extracting the required traceability data for polished diamonds using Sarine Instructor software is compatible with the following hardware:
DiaMension
DiaMension HD
DiaMark HD
DiaMark™ HD
Once a polished diamond is scanned and the file loaded onto the Instructor software, you can extract the following data points:
Diamond Measurements (using a provided template)
Diamond 3D Model
The following instructions describe how to extract the required data.
Required fields for diamond integration
The following are the required fields for diamond integration. Refer to the Data Dictionary for more information, including the allowed values.
Rough
participant_id – Your unique identifier for the diamond. This can be your ERP ID or any other ID which will help you to identify the diamond in your system.
participant_timestamp – A date and time of your choosing. For example, this may be when you added the diamond into to your system or when it was processed.
box_id – The parcel identification number. This is the ID of the parcel you receive from the producer.
sight_year – The sight year.
sight_no – The sight number.
carats – The weight of the rough diamond. Tracr requires a precision of three digits.
Note Producers are no longer required to provide a colour for diamonds registered via DIT at rough. Colour can be omitted by leaving the colour cell for that diamond in the upload CSV blank.
Split
participant_id – Your unique identifier for the diamond. This can be your ERP ID or any other ID which will help you to identify the diamond in your system.
participant_parent_id – Your identifier for the parent rough diamond.
participant_timestamp – A date and time of your choosing. For example, this may be when you added the diamond into to your system or when it was processed.
carats – The weight of the split diamond. Tracr requires a precision of three digits.
Polished
participant_id – Your unique identifier for the diamond. This can be your ERP ID or any other ID which will help you to identify the diamond in your system.
participant_parent_id – Your identifier for the parent split or rough diamond (if the rough was polished without splitting).
participant_timestamp – A date and time of your choosing. For example, this may be when you added the diamond into to your system or when it was processed.
carats – The weight of the polished diamond. Tracr requires a precision of three digits.
cut_grade – The grade of cut.
shape – The shape of the polished diamond.
clarity – The relative absence of inclusions and blemishes.
symmetry – The symmetry of the polished diamond.
polish_quality – The quality of the polished diamond.
scan – The scan of the polished diamond (for example, Sarine scan).
scan_report – The extracted report of the scan.
Note We require mutual exclusivity of colour and fancy_colour fields. You may only provide fancy_colour (fancy_colour, fancy_colour_intensity and optionally fancy_colour_overtone) or colour values for any given diamond being registered or updated via the integration tool.
Transfer
participant_id – Your unique identifier for the diamond. This can be your ERP ID or any other ID which will help you to identify the diamond in your system.
transfer_type – The type of transfer: in or out.
transfer_timestamp – The date when the diamond was transferred.
box_id – The parcel identification number.
platform – The name of the participant that purchased or sold the diamond.
Video quality requirements
If you are providing a video of your diamond, please note the following:
Format – .mp4, .avi, .mkv, .mov
Rotation – At least one full 360° rotation horizontally (clockwise or anticlockwise)
Number of frames: At least 30
Resolution – At least 400 x 400 pixels
Good contrast between the stone and the background
Unobscured background, clean without clamps
(Optional) Additional video in fluorescence
Examples
Tracr data control
After uploading diamond data, Tracr runs following control processes:
Rough diamonds
For a given sight box, that the total carat weight submitted does not exceed the total carat weight invoiced by De Beers.
For a given sight box, that the number of diamonds submitted does not exceed the number of diamonds invoiced by De Beers (where applicable).
Child rough (split) diamonds
That the sum of all the children's carats does not exceed the carat weight of the parent diamond.
Polished diamonds
That the carat weight of the polished diamond does not exceed the carat weight of the parent diamond.
View integration session history
Tracr maintains a list of all the sessions that you create, save or abandon.
To view your session history:
From the Tracr menu, select Integration > Integration Tool. The Session history page displays a list of your integration sessions.
Each session has a status, which shows whether the session was submitted, is in progress, or was abandoned.
Submitted – Data has been uploaded and Tracr is processing the diamonds.
In progress – The session was not submitted, either because the user did not click Submit or chose to save and quit the session, possibly because not all the required files were available. To complete the session, in the Action column, select Continue session.
Abandoned – The session was abandoned. Note that you can only abandon a session if the CSV file has passed validation.
Session information
For each session, Tracr gives the following information:
Session ID – The ID allocated to the session by Tracr.
Session start – The date and time the session started. You can filter on the start date if you only want to display sessions started on a particular date.
Session submitted – The date and time the session was submitted to Tracr. If this is blank, check the Status column to see if the session is ‘In progress’ or was ‘Abandoned’.
Integration type – The integration type selected when the CSV was uploaded to Tracr. You can filter on integration type if you only want to display sessions of a certain type.
Diamonds submitted – The number of diamonds submitted to Tracr.
Diamonds excluded – The number of diamonds excluded when the dataset was uploaded to Tracr.
Status – The status of the session. You can filter on status if you only want to display sessions at a certain status.
Details – Provides more information about the status of the session.
Action – The available options depend on the status of the session.
For a ‘Submitted’ session, select the ellipsis to access the following options: Monitoring – Display the Integration monitoring page for the selected session. .xlsx file – Download a simple or detailed report for the selected session.
For an ‘In progress’ session, select Continue session to complete and submit the session.
Filter your session history
You can filter the list of sessions by event date, integration type, or status.
To filter by event date:
Select Start date, choose the date from the calendar, and select Apply. Tracr only displays sessions for the selected date.
To filter by integration type:
Select Integration type, select the type(s) that you want to display, and select Apply. Tracr only displays sessions for the selected integration type(s).
To filter by status:
Select Status, select the status(es) that you want to display, and select Apply. Tracr only displays sessions for the selected status(es).
Continue a session
If a session has been saved (status = ‘In progress’), you can select Continue session in the Action column on the Session history page to complete and submit the session.
If you want to quit a session without submitting it and then continue the session later, select the Quit button at any time during file upload and then select Save and quit. Tracr saves your session which appears on the Session history page with a status of ‘In progress’.
Export a session report
You can export details of a selected session currently displaying on the Session history page as a report (xlsx file).
2. Choose report type
In the Action column, select the ellipsis and do one of the following:
To download a simple report for the selected session, under Download a session report as, select .xlsx file. View example report
To download a detailed report for the session, under Download full session report, select .xlsx file. View example report
Last updated