Tools - Importing Split
DH SYSTEMS
HELP
At times you may want to import GIA details directly into DH Systems through data you receive via spreadsheet from
GIA. This will save time as you will not have to manually enter these details.
Below are the conditions to make it work.
The fields must be in following order, but the actual field names must not be included in the file.
Report No Report Dt Client Ref Shape Length Width Depth Weight Color Color
Descriptions Clarity Clarity Status Final Cut Polish Symmetry Fluorescence Intensity
Fluorescence Color Girdle Girdle Condition Culet Size Depth % Table % Crn Ag Crn
Ht Pav Ag Pav Dp Str Ln Lr Half Painting Proportion Paint Comm Key to Symbols
Report Comments Inscription Synthetic Indicator Girdle %
Report Dt field may not be left blank
The file must be saved with as a comma delimited file with a CSV or TXT extension. The content must be pure text.
This is an example as viewed through Notepad:
2117816076,01/13/2011,154667,RBC,4.37,4.34,2.7,0.31,E,,VS1,,EX,EX,EX,NON,,MED to
STK,Faceted,NON,62,56,34.5°,15.00%,41.0°,43.50%,55%,80%,EX,EX,,Needle Crystal Pinpoint,,GIA 2117816076 ,,3.50%
2117816024,01/13/2011,154825,RBC,4.34,4.31,2.69,0.3,F,,VS1,,EX,EX,EX,NON,,MED,Faceted,NON,62.2,57,35.0°,15.00%,41.2°,43.50%,55%,75%,EX,EX,,Crystal,,GIA
2117816024 ,,3.50%
2117816065,01/13/2011,154829,RBC,4.39,4.35,2.67,0.31,F,,VVS2,,EX,EX,EX,NON,,MED to
STK,Faceted,NON,61.1,58,34.5°,14.50%,41.0°,43.50%,55%,75%,EX,EX,,Cloud,,GIA 2117816065 ,,3.50%
GIA. This will save time as you will not have to manually enter these details.
Below are the conditions to make it work.
The fields must be in following order, but the actual field names must not be included in the file.
Report No Report Dt Client Ref Shape Length Width Depth Weight Color Color
Descriptions Clarity Clarity Status Final Cut Polish Symmetry Fluorescence Intensity
Fluorescence Color Girdle Girdle Condition Culet Size Depth % Table % Crn Ag Crn
Ht Pav Ag Pav Dp Str Ln Lr Half Painting Proportion Paint Comm Key to Symbols
Report Comments Inscription Synthetic Indicator Girdle %
Report Dt field may not be left blank
The file must be saved with as a comma delimited file with a CSV or TXT extension. The content must be pure text.
This is an example as viewed through Notepad:
2117816076,01/13/2011,154667,RBC,4.37,4.34,2.7,0.31,E,,VS1,,EX,EX,EX,NON,,MED to
STK,Faceted,NON,62,56,34.5°,15.00%,41.0°,43.50%,55%,80%,EX,EX,,Needle Crystal Pinpoint,,GIA 2117816076 ,,3.50%
2117816024,01/13/2011,154825,RBC,4.34,4.31,2.69,0.3,F,,VS1,,EX,EX,EX,NON,,MED,Faceted,NON,62.2,57,35.0°,15.00%,41.2°,43.50%,55%,75%,EX,EX,,Crystal,,GIA
2117816024 ,,3.50%
2117816065,01/13/2011,154829,RBC,4.39,4.35,2.67,0.31,F,,VVS2,,EX,EX,EX,NON,,MED to
STK,Faceted,NON,61.1,58,34.5°,14.50%,41.0°,43.50%,55%,75%,EX,EX,,Cloud,,GIA 2117816065 ,,3.50%
 | |  | |  | |  |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |