GemEx Reports - Online Help

GemEx Systems, Inc.
6040A W. Executive Dr.
Mequon, WI 53092
262-242-1111
Email GemEx Tech Support: notification@gemex.com

Contents

New features

How to use the pages:

Find Exact Scan
Find Similar Scans
Scan Results
Report Tracking
Receiving
Upload Orders

How to:

Change the text size to make the page 'easier to read' or 'fit on a print-out'
Use muti-select boxes
Use range selection option lists
Print reports
Download reports

Explanations of rejected scans:

Appears Dirty
Bad Separation
Below Performance Standard
Duplicate
Invalid Stone ID
Missing Color/Clarity
Missing Weight
Not Centered
Other Problem
Previously Approved
Questionable Calibration
Stone Moved
Wrong Shape

Go Back to top





New features:
Go Back to top

Added Saturday, 10/2/2004:
Added Thursday, 10/14/2004:
Added Saturday, 10/16/2004:
Added Monday, 6/20/2005:
Go Back to top







How to use the Find Exact Scan page
Go Back to top

Overview: The 'Find Exact Scan' page allows you to find scan result matches for exact stone IDs.  Only exact stone ID matches will return matching rows.
  • Approved: The rows displayed in green are approved scans with 'Y' in the Make Report field, which indicates that a report can be made for the scan.
  • No Report: The rows displayed in blue are approved scans with 'N' in the Make Report field, which indicates that there is nothing wrong with the scan, but a report cannot be made because the scales are preliminary for that shape.  'Preliminary Scales' refers to arbitrarily set scales that are not permanent, because a scientific analysis for the shape has not been finalized to accurately determine light performance ratings.
  • Rejected: The rows displayed in red are rejected scans.   Most rejection reasons require the stone to be rescanned and resubmitted for approval before a report can be made, while others do not.   Regardless if the stone needs to be rescanned or not, a report cannot be made for a scan rejected for any reason.   Please refer to the explanations of rejected scans for details.

Please refer to the circled areas on the diagram below that correspond to the following letters:
Go to diagram for Find Exact Scan
A. Welcome Message: This displays your company name.
B. Last Updated Timestamp: Date and time when the information for this page was last updated.  This does not indicate the timestamp for the entire web site.  For example, there are separate processes for updating scan result information and report tracking information, so these two sets of information will have different timestamps.
C. Page Links: This is the current page.  The link for the currently selected page will be bold and green.
D. Stone ID Field: Enter the stone ID here.  On this page, only exact stone ID matches will return results.
E. New Search Button: Click here to search for the stone ID entered in the Stone ID Field, or press the Enter key.

Find Exact Scan page example:
Go to explanation

Go Back to top







How to use the Find Similar Scans page
Go Back to top

Overview: The 'Find Similar Scans' page allows you to find and sort scan result matches for similarly matching stone IDs.  All stone IDs that contain the text entered into the Stone ID Field anywhere within the stone ID will return matching rows.  For example, an entered stone ID of 123 will return matches such as st0123, 9012363-e, 123123, and 123.  Matching rows with stone IDs such as 1223 for this example or any stone IDs that do not contain the characters in consecutive order will not be returned.
  • Approved: The rows displayed in green are approved scans with 'Y' in the Make Report field, which indicates that a report can be made for the scan.
  • No Report: The rows displayed in blue are approved scans with 'N' in the Make Report field, which indicates that there is nothing wrong with the scan, but a report cannot be made because the scales are preliminary for that shape.  'Preliminary Scales' refers to arbitrarily set scales that are not permanent, because a scientific analysis for the shape has not been finalized to accurately determine light performance ratings.
  • Rejected: The rows displayed in red are rejected scans.   Most rejection reasons require the stone to be rescanned and resubmitted for approval before a report can be made, while others do not.   Regardless if the stone needs to be rescanned or not, a report cannot be made for a scan rejected for any reason.   Please refer to the explanations of rejected scans for details.

Please refer to the circled areas on the diagram below that correspond to the following letters:
Go to diagram for Find Similar Scans
A. Welcome Message: This displays your company name.
B. Last Updated Timestamp: Date and time when the information for this page was last updated.  This does not indicate the timestamp for the entire web site.  For example, there are separate processes for updating scan result information and report tracking information, so these two sets of information will have different timestamps.
C. Page Links: This is the current page.  The link for the currently selected page will be bold and green.
D. Reset Filters Button: This button will restore all of the fields to their original values.
E. Stone ID Field: Enter the stone ID here.  On this page, any stone IDs that include the entered text string anywhere within the stone ID will return results.
F. Display Rows Field: Enter the number of rows per page to be displayed here.  Only the currently displayed page can be downloaded or printed, so in certain circumstances it may be desirable to increase this value.  If there are more total rows returned than this number, the pages can be navigated with Previous and Next buttons.  This 'display rows' limit is set so results return very quickly even when there are several thousand total matching rows.  Another reason for this limit is because of web server memory constraints.  If the number of returned rows on a single page exceeds the server memory limitations allocated for the web site, the display may fail.This field works in conjunction with letters G and H below.
G. Starting Record Field: Enter the number of the starting row to be displayed here.  For a large number of matching rows, it may be faster to start in the middle of the list rather than click the Next button several times.  This field works in conjunction with letter F above and letter H below.
H. Repeat Headers Field: Enter the number of rows to display before redisplaying the header row.  The header row gives a decription for every column in the matching rows display.  The header rows appear on the screen display and printer output, but will not appear when downloaded.  This field works in conjunction with letter F and G above.
I. New Search/Sort Button: Click here to search or resort the matching rows for the stone ID entered in the Stone ID Field, or press the Enter key.
J. Sort By Option List: These three Sort By option lists work together to allow the matching records to be sorted in a custom order.
K. Descending Checkbox: Selecting this checkbox for any of the three Sort By option lists (see letter J above) will sort the corresponding list selection in descending order.  If a descending checkbox is not selected, the sort order is ascending by default.

Find Similar Scans page example:
Go to explanation

Go Back to top







How to use the Scan Results page
Go Back to top

Overview: The 'Scan Results' page allows you to create very specific reports for scans.   The report content and sort order is controlled by entering filter information.   Multiple filters may be selected at the same time.   For example, a report can be filtered by date range and stone id range and status, sorted by status then sorted by stone ID within each status.   An unfiltered report will return all scans in the database.   An unsorted report will return all matching rows in the order they were entered into the database, typically by the date reviewed.
Range option lists:
There are fields that allow filtering with a start/lowest and end/highest range by entering information in fields or by choosing from option lists.   The range fields include date (date reviewed), stone id, weight (carat weight entered at time of scan), white light scale, color light scale, and scintillation scale.   The start/lowest range must be lower or the same as the end/highest range or an error message will be displayed.   For all of these ranges there are three options:
  1. Enter only the start/lowest range to return all matching rows starting from that point.
  2. Enter only the end/highest range to return all matching rows up to and including that point.
  3. Enter both start/lowest and end/highest ranges to return all matching rows within that range.
Multi-select boxes:
There are also multi-select boxes so one or more filters in each box can be selected at the same time.   The multi-select boxes are status, shape, and bscope (BrillianceScope name).   There are three ways to use a multi-select box:
  1. To select a single choice scroll to a choice and click on it, and to change the selected choice click on a different choice which will deselect all other selected choices.
  2. To select or deselect multiple non-consecutrive choices hold down the control key while clicking.
  3. To select a group of consecutive choices click on the first choice, then hold down the shift key and click on the last choice to also select all choices between the first and last choice.
All selected filters and sorting options will be displayed on the screen so you can be certain that the report was filtered and sorted as desired, and also on print-outs so multiple reports can be printed out with details as to what each report contains.   Downloaded reports do not include header rows or filtering/sorting information so they can be easily imported into a database without containing unusable rows, and the file can be saved with a file name that describes the report as desired.   The column order for downloaded files is the same as the order displayed on the screen or a print-out.
  • Approved: The rows displayed in green are approved scans with 'Y' in the Make Report field, which indicates that a report can be made for the scan.
  • No Report: The rows displayed in blue are approved scans with 'N' in the Make Report field, which indicates that there is nothing wrong with the scan, but a report cannot be made because the scales are preliminary for that shape.  'Preliminary Scales' refers to arbitrarily set scales that are not permanent, because a scientific analysis for the shape has not been finalized to accurately determine light performance ratings.
  • Rejected: The rows displayed in red are rejected scans.   Most rejection reasons require the stone to be rescanned and resubmitted for approval before a report can be made, while others do not.   Regardless if the stone needs to be rescanned or not, a report cannot be made for a scan rejected for any reason.   Please refer to the explanations of rejected scans for details.

Please refer to the circled areas on the diagram below that correspond to the following letters:
Go to diagram for Scan Results
A. Welcome message: This displays your company name.
B. Last Updated timestamp display: Date and time when the information for this page was last updated.  This does not indicate the timestamp for the entire web site.  For example, there are separate processes for updating scan result information and report tracking information, so these two sets of information will have different timestamps.
C. Page links: This is the current page.  The link for the currently selected page will be bold and green.
D. Status muti-select box: This mutli-select box allows selecting one or more choices at the same time.  'Special' status choices include 'Unresolved Rejected' and 'All Rejected' which must be selected by themselves with no other status selections or an error message will be displayed.
Unresolved Rejected returns all rows for rejected scans that have not been followed up with an approved scan. This is a great way to get a list of all stones that need to be rescanned, but it can become cluttered with rejections for Invalid Stone ID.  The reason for including Invalid Stone ID is so a slightly misnamed stone ID can be identified, renamed, and resent for approval.  These rejections for Invalid Stone ID can be eventually filtered out by using the Date Range filter in conjunction with Unresolved Rejected filter.
All Rejected will return all rejected scans, regardless if they are followed up with an approval or not.  This is available for identifying rejection trends that may be associated with certain cuts, certain BrillianceScopes, certain BrillianceScope operators, etc.
E. Date range option lists (date reviewed): These range option lists allow selecting only the start date, only the end date, or both the start and end dates.  For either the start date or end date, the month, day, and year must all be selected or an error message will be displayed.
F. Scale range option lists: These range selection option lists allow selecting only the lowest scale, only the highest scale, or both the lowest and highest scales for white light, color light, and/or scintillation.
G. Stone ID range option lists: These range selection option lists allow selecting only the lowest stone id, only the highest stone id, or both the lowest and highest stone ids.  It is best to enter the stone ids exactly as they were approved or rejected, but there is an easy way to get around this: For example, to return a list of all stone ids starting with LC, the lowest stone id may be entered as LC and the highest as LD.  Even if there are stone ids that start with LD, these will not be returned if there are any additional characters in the stone IDs after the letter D.  This method can be used with more characters for further filtering.
H. Shape muti-select box: This mutli-select box allows selecting one or more choices at the same time.
I. Reset Filters button: This button will restore all of the fields to their original values.
J. Weight range option lists: (carat weight entered at time of scan) These range selection option lists allow selecting only the lowest carat weight, only the highest carat weight, or both the lowest and highest carat weights.
K. Bscope muti-select box: (BrillianceScope name) This mutli-select box allows selecting one or more choices at the same time.
L. Display Rows field: Enter the number of rows per page to be displayed here.  Only the currently displayed page can be downloaded or printed, so in certain circumstances it may be desirable to increase this value.  If there are more total rows returned than this number, the pages can be navigated with Previous and Next buttons.  This 'display rows' limit is set so results return very quickly even when there are several thousand total matching rows.  Another reason for this limit is because of web server memory constraints.  If the number of returned rows on a single page exceeds the server memory limitations allocated for the web site, the display may fail.This field works in conjunction with letters M and N below.
M. Starting Record field: Enter the number of the starting row to be displayed here.  For a large number of matching rows, it may be faster to start in the middle of the list rather than click the Next button several times.  This field works in conjunction with letter L above and letter N below.
N. Repeat Headers field: Enter the number of rows to display before redisplaying the header row.  The header row gives a decription for every column in the matching rows display.  The header rows appear on the screen display and printer output, but will not appear when downloaded.  This field works in conjunction with letter L and M above.
O. New Search/Sort button: Click here to search or resort the matching rows for the stone ID entered in the Stone ID Field, or press the Enter key.
P. Stored Filters display: This indicates how many filters have been selected, excluding sort options. This can help when unseen filters are selected within multi-select boxes.
Q. Sort By Option List: These three Sort By option lists work together to allow the matching records to be sorted in a custom order.
R. Descending Checkbox: Selecting this checkbox for any of the three Sort By option lists (see letter Q above) will sort the corresponding list selection in descending order.  If a descending checkbox is not selected, the sort order is ascending by default.

Scan Results page example:
Go to explanation

Go Back to top







How to use the Report Tracking page
Go Back to top

Overview: The 'Report Tracking' page allows you to create very specific reports for GemEx Light Performance Analysis reports that have been produced.   The report content and sort order is controlled by entering filter information.  Multiple filters may be selected at the same time.   For example, a report can be filtered by date range and stone id range and status, sorted by stone id then by status descending.   An unfiltered report will return all GemEx reports in the database.   An unsorted report will return all matching rows in the order they were entered into the database, typically by the date the report was made.
Range selection option lists:
There are fields that allow filtering with a start/lowest and end/highest range by entering information in fields or by choosing from option lists.   The range fields include date (date made or date shipped)and stone id.   The start/lowest range must be lower or the same as the end/highest range or an error message will be displayed.   For all of these ranges there are three options:
  1. Enter only the start/lowest range to return all matching rows starting from that point.
  2. Enter only the end/highest range to return all matching rows up to and including that point.
  3. Enter both start/lowest and end/highest ranges to return all matching rows within that range.
Directly below the date range option lists is a group of radio buttons that allow searching by either the date the report was made or the date the report was shipped from the printing company.   The 'Report Made' radio button is selected by default.
Option boxes:
There are also option boxes to select the status or retailer..   All selected filters and sorting options will be displayed on the screen so you can be certain that the report was filtered and sorted as desired, and also on print-outs so multiple reports can be printed out with details as to what each report contains.   Downloaded reports do not include header rows or filtering/sorting information so they can be easily imported into a database without containing unusable rows, and the file can be saved with a file name that describes the report as desired.   The column order for downloaded files is the same as the order displayed on the screen or a print-out.
Report Statuses:
  • New and Processed: This indicates that the report has been made but has not yet been received by the printing company.   These rows are displayed in purple.
  • Added: This indicates that the report has been received by the printing company.   These rows are displayed in purple.
  • Redo: This indicates that the report file was rejected by the printing company and must be remade by GemEx.   These rows are displayed in purple.
  • Bad-Redone: This indicates that a report rejected by the printing company (a 'Redo') has been remade.   These records will remain in the database with this status, and a new record of the redone report will also exist.   These rows are displayed in purple.
  • 'Shipped', 'Customer_Rcvd', and 'We do not print': These rows are displayed in green which indicates that the report has been shipped to the customer.
  • All other statuses: This indicates that records were manually updated at GemEx, and while we strive for consistency there are times when we will enter in a status appropriate for the circumstances at that time.   These rows are displayed in purple.

Please refer to the circled areas on the diagram below that correspond to the following letters:
Go to diagram for Report Tracking
A. Welcome message: This displays your company name.
B. Last Updated timestamp display: Date and time when the information for this page was last updated.  This does not indicate the timestamp for the entire web site.  For example, there are separate processes for updating scan result information and report tracking information, so these two sets of information will have different timestamps.
C. Page links: This is the current page.  The link for the currently selected page will be bold and green.
D. Date range option lists (date made or date shipped): These range selection option lists allows selecting only the start date, only the end date, or both the start and end dates.  Directly below the date range option lists is a group of radio buttons that allow searching by either the date of 'Report Made' or 'Date Shipped' (see letter F below).  For either the start date or end date, the month, day, and year must all be selected or an error message will be displayed.
E. Status option box: This option box allows selecting one status choice at a time.  Click here to see the different types of report statuses.
F. Date Range radio buttons: These radio buttons allow searching by either the date the report was made or the date the report was shipped from the printing company (see letter D above).  The 'Report Made' radio button is selected by default.
G. Retailer option box: This option box allows selecting one retailer choice at a time.
H. Reset Filters button: This button will restore all of the fields to their original values.
I. Stone ID range option lists: These range selection option lists allows selecting only the lowest stone id, only the highest stone id, or both the lowest and highest stone ids.  It is best to enter the stone ids exactly as they were approved or rejected, but there is an easy way to get around this: For example, to return a list of all stone ids starting with LC, the lowest stone id may be entered as LC and the highest as LD.  Even if there are stone ids that start with LD, these will not be returned if there are any additional characters in the stone IDs after the letter D.  This method can be used with more characters for further filtering.
J. Display Rows field: Enter the number of rows per page to be displayed here.  Only the currently displayed page can be downloaded or printed, so in certain circumstances it may be desirable to increase this value.  If there are more total rows returned than this number, the pages can be navigated with Previous and Next buttons.  This 'display rows' limit is set so results return very quickly even when there are several thousand total matching rows.  Another reason for this limit is because of web server memory constraints.  If the number of returned rows on a single page exceeds the server memory limitations allocated for the web site, the display may fail.This field works in conjunction with letters K and L below.
K. Starting Record field: Enter the number of the starting row to be displayed here.  For a large number of matching rows, it may be faster to start in the middle of the list rather than click the Next button several times.  This field works in conjunction with letter J above and letter L below.
L. Repeat Headers field: Enter the number of rows to display before redisplaying the header row.  The header row gives a decription for every column in the matching rows display.  The header rows appear on the screen display and printer output, but will not appear when downloaded.  This field works in conjunction with letter J and K above.
M. New Search/Sort button: Click here to search or resort the matching rows for the stone ID entered in the Stone ID Field, or press the Enter key.
N. Stored Filters display: This indicates how many filters have been selected, excluding sort options.
O. Sort By Option List: These three Sort By option lists work together to allow the matching records to be sorted in a custom order.
P. Descending Checkbox: Selecting this checkbox for any of the three Sort By option lists (see letter O above) will sort the corresponding list selection in descending order.  If a descending checkbox is not selected, the sort order is ascending by default.

Report Tracking page example:
Go to explanation

Go Back to top







How to use the Receiving page
Go Back to top

Overview: The 'Receiving' page allows you to change the report staus of a GemEx LPA report to CUSTOMER_RCVD.  Using this receiving page for every report will easily help identify all of the reports that have not been received when performing a search on the 'Report Tracking' page.  There are two ways of entering in report identification information:
  1. The first is by scanning the barcode printed on the LPA report.
  2. The second is by entering the stone id (or product id).
Only exact barcode or stone id (or product id) matches will return matching rows.  When a matching row is found, it is automatically updated to a report status of CUSTOMER_RCVD.

Please refer to the circled areas on the diagram below that correspond to the following letters:
Go to diagram for Receiving
A. Welcome Message: This displays your company name.
B. Last Updated Timestamp: Date and time when the information for this page was last updated.  This does not indicate the timestamp for the entire web site.  For example, there are separate processes for updating scan result information and report tracking information, so these two sets of information will have different timestamps.
C. Page Links: This is the current page.  The link for the currently selected page will be bold and green.
D. Entry Type Radio Buttons: Select the button for the type of entry, whether the entry is from scanning a barcode from an LPA report or a manually entered stone id (or product id).  The barcode has different information than the stone id (or product id), so selecting the wrong button will prevent any matching rows.
E. Entry Field: Enter the barcode scan or stone ID (or product id) here.  On this page, only exact matches will return results.
F. New Search Button: Click here to search for the entry in the Entry Field, or press the Enter key.
G. 'Receiving' Warning Display: The blue box framing the text at the top of the page and the warning display indicate that this is not a 'read-only' page.  When a matching row is found, it is automatically updated to a report status of CUSTOMER_RCVD.

Receiving page example:
Go to explanation

Go Back to top







How to use the Upload Orders page
Go Back to top

Overview:

The 'Upload Orders' page allows orders to be directly submitted to GemEx in a user-friendly manner.   The orders can be sent in a 'tab delimited' or 'comma separated' text file format, with or without quotes surrounding the individual field values.   To overcome the several different text file column orders we receive, this page is designed to assign the text file columns to GemEx Field Names.   For example, if the first column is the Stone ID entered at the time of scanning, the GemEx field Name 'Stone Scan ID' should be assigned to the first column.   If the first row of the file contains header information instead of actual data that goes onto an LPA report, the profile should be saved with 'First Row Contains Header Information Only' checked.   The column assignments determine how information is displayed on an LPA report.

Once these columns are assigned to GemEx Filed Names, the column assignment order can be saved in a Column Assignment Profile for future uploads.   As long as future uploads are in the same column order, and the file's header row is consistent with the saved profile, the profile does not need to be edited.   There can be many saved profiles for different text file formats, but only one is the default profile.   When the first Column Assignment Profile is saved, it automatically becomes the default profile.   Once a default profile exists, all future text file uploads will be automatically set to the column assignments from the default profile.

If the default profile is not correct for the uploaded text file, a different saved profile can be selected or the column assignments can be modified by clicking on the 'Edit Column Assignments' button.   When any changes are made to the column assignments, options will be available to save a new profile, overwrite the selected profile, or skip saving the changes.

Some profiles may be locked by GemEx Systems, Inc. so they cannot be edited.   This is done for orders that are specifically set up to be submitted through automated processes.
Definitions of GemEx Field Names (in alphabetical order):

Please note that it is not necessary to use all of these GemEx field names when submitting an order.   The minimum requirement for a report is 'Stone Scan ID'.   In many cases, a multi-stone report will require a 'Product ID / Stone Group ID' along with the individual 'Stone Scan IDs' in the set.   To avoid delays in processing an order, it is important that the 'Stone Scan ID' in the order text file matches the 'Stone Scan ID' exactly the way it was approved.
  • Bill To (line 1) Company: First line of the 'bill to' address as it should appear on a mailing address label.
  • Bill To (line 2a) Contact Name: Second line (first part) of the 'bill to' address as it should appear on a mailing address label.
  • Bill To (line 2b) Contact Phone: Second line (second part) of the 'bill to' address as it should appear on a mailing address label.
  • Bill To (line 3) Address: Third line of the 'bill to' address as it should appear on a mailing address label.
  • Bill To (line 4) Address: Fourth line of the 'bill to' address as it should appear on a mailing address label.
  • Bill To (line 5) Address: Fifth line of the 'bill to' address as it should appear on a mailing address label.
  • Bill To (line 6) Address: Sixth line of the 'bill to' address as it should appear on a mailing address label.
  • Carat Weight - Individual: Used when different than the 'Total Carat Weight' in a multi-stone set.
  • Carat Weight - Total: Total carat weight of a single-stone or multi-stone set.
  • Clarity: Lab measurement.
  • Clarity 2: Lab measurement - used for multi-stone sets when each report is on a sigle line of the order text file.
  • Clarity 3: Lab measurement - used for multi-stone sets when each report is on a sigle line of the order text file.
  • Color: Lab measurement.
  • Color 2: Lab measurement - used for multi-stone sets when each report is on a sigle line of the order text file.
  • Color 3: Lab measurement - used for multi-stone sets when each report is on a sigle line of the order text file.
  • Crown Angle: Lab measurement.
  • Crown Depth (mm): Lab measurement.
  • Crown Percent: Lab measurement.
  • Culet Details: Lab details.
  • Culet Percent: Lab measurement.
  • Cut: Lab measurement.
  • Depth Size (mm): Lab measurement.
  • Depth Percent: Lab measurement.
  • Fluorescence: Lab measurement.
  • Girdle Details: Lab details.
  • Girdle Percent: Lab measurement.
  • Graining: Lab measurement.
  • Image 1 File Name: File name for an image to be used on an LPA report.
  • Image 2 File Name: File name for an image to be used on an LPA report.
  • Lab Bag ID: Lab bag identification.
  • Lab Data is Missing (Y/N): For programs that have been specifically set up to use lab information, a 'Y' or 'YES' indicates that the lab data is intentionally missing.
  • Lab Name: Name of the lab that graded the stone or stone set.
  • Lab Report Date: Date the stone or stone set was graded at the lab.
  • Lab Report ID: Lab report identification.
  • Lab Stone ID: Stone identification used at the lab.
  • Lot Number: Lot identification for the stone or stone set.
  • Memo ID: Memo identification for the stone or stone set.
  • Number of Center Stones: GemEx adds the 'Number of Center Stones' and the 'Number of Side Stones' together to get the total number of stones in a report.
  • Number Of Side Stones: GemEx adds the 'Number of Center Stones' and the 'Number of Side Stones' together to get the total number of stones in a report.
  • Pavillian Angle: Lab measurement.
  • Pavillian Percent: Lab measurement.
  • Pavillion Size (mm): Lab measurement.
  • Polish: Lab measurement.
  • Product ID / Stone Group ID: For muli-stone sets, this identifies the entire GemEx LPA report.
  • Product SKU Number: Product class identification.
  • Reprint: If this report has already been produced in the past, GemEx will produce the report without delay if there is anything in this column for the given row.
  • Retailer: Name or code of the retailer or seller.
  • Shape: Lab measurement.
  • Ship To (line 1) Company: First line of the 'ship to' address.
  • Ship To (line 2a) Contact Name: Second line (first part) of the 'ship to' address as it should appear on a mailing address label.
  • Ship To (line 2b) Contact Phone: Second line (second part) of the 'ship to' address as it should appear on a mailing address label.
  • Ship To (line 3) Address: Third line of the 'ship to' address as it should appear on a mailing address label.
  • Ship To (line 4) Address: Fourth line of the 'ship to' address as it should appear on a mailing address label.
  • Ship To (line 5) Address: Fifth line of the 'ship to' address as it should appear on a mailing address label.
  • Ship To (line 6) Address: Sixth line of the 'ship to' address as it should appear on a mailing address label.
  • Stone Scan ID: The identification entered at the time the stone was scanned.  This needs to match the stone id exactly as how it was approved.
  • Stone Scan ID 2: Used for multi-stone sets when each report is on a sigle line of the order text file (see 'Stone Scan ID' for details).
  • Stone Scan ID 3: Used for multi-stone sets when each report is on a sigle line of the order text file (see 'Stone Scan ID' for details).
  • Stone Size 1 (mm): Lab measurement, typically the maximum diameter.
  • Stone Size 2 (mm): Lab measurement, typically the minimum diameter.
  • Symmetry: Lab measurement.
  • Table Size (mm): Lab measurement.
  • Table Percent: Lab measurement.
  • Text File Line ID: Line number in order text file (for customer use).
Go Back to top







How to change the text size to make the page 'easier to read' or 'fit on a print-out'
Go Back to top

The default text size (also known as font size) depends on the type and version of the Internet browser being used.   These instructions are intended to assist in making our web site more readable and therefore more user friendly.   Please note that the page layout will be altered as the text size is changed.   Please refer to the 'Help' item at the top of your browser window for more details.

Go Back to top







How to use Multi-select Boxes
Go Back to top

Multi-select boxes are used to select one or more options at the same time.   There are three ways to use a multi-select box:

  1. To select a single choice scroll to a choice and click on it, and to change the selected choice click on a different choice which will deselect all other selected choices.
  2. To select or deselect multiple non-consecutrive choices (choices that are not directly above or below each other) hold down the control key while clicking.
  3. To select a group of consecutive choices click on the first choice, then hold down the shift key and click on the last choice to also select all choices between the first and last choice.

Go Back to top







How to use Range Selection option lists
Go Back to top

There are fields that allow filtering with a start/lowest and end/highest range by entering information in fields or by choosing from option lists.   The start/lowest range must be lower or the same as the end/highest range or an error message will be displayed.   For all of these ranges there are three options:

  1. Enter only the start/lowest range to return all matching rows starting from that point.
  2. Enter only the end/highest range to return all matching rows up to and including that point.
  3. Enter both start/lowest and end/highest ranges to return all matching rows within that range.

Go Back to top







How to print reports
Go Back to top

On the 'Find Similar Stone IDs' page, the 'Scan Results' page, and the 'Report Tracking' page, the reports can be printed by clicking the 'Print' button at the top of the displayed report.   Only the current page will be printed.   If the found set is larger than the number of displayed rows, the report will be broken up into multiple pages.   To increase the number of rows per page, enter a larger number in the Display Rows field, then click the New Search/Sort button.   If the report text does not fit on the page, try printing in a landscape layout instead of a portrait layout (in most cases the print layout can be changed by clicking the Properties button on the print dialog window) and/or decrease the text size.   All selected filters and sorting options will be displayed on the printed report so you can be certain that the report was filtered and sorted as desired, and also so multiple reports can be printed out with details as to what each report contains.

Go Back to top







How to download reports
Go Back to top

On the 'Find Similar Stone IDs' page, the 'Scan Results' page, and the 'Report Tracking' page, the reports can be downloaded by clicking the 'Download as CSV' button at the top of the displayed report.   Only the current page will be downloaded.   If the found set is larger than the number of displayed rows, the report will be broken up into multiple pages.   To increase the number of rows per page, enter a larger number in the Display Rows field, then click the New Search/Sort button.   Downloaded reports do not include header rows or filtering/sorting information so they can be easily imported into a database without containing unusable rows, and the file can be saved with a file name that describes the report as desired.   The column order for downloaded files is the same as the order displayed on the screen or a print-out.   The file must be saved before it can be opened.

Go Back to top







Explanations of rejected scans:

Rejected Reason: Appears Dirty
Go Back to top

If a stone is dirty, the light scales will not be accurate or repeatable.   A stone can be rejected for 'Appears Dirty' for the following three resons:

  1. Oil: A stone with oil on the surface or oil on the BrillianceScope Analyzer glass where the diamond is placed for scanning can cause an effect we call 'rainbowing'.   An analogy of rainbowing can be seen at a gasoline station after it rains, and the water is mixed with the oil on the ground which causes rainbow colors to appear.   A common way that oil gets on a stone surface or on the glass is by touching it with fingers.   Rainbowing is not as critical in round shapes unless it is excessive. Rainbowing in all other shapes severely affects the light scales.   Rainbowing can sometimes be seen in up to all six light views, but is highly visible in light view 6.   Please refer to the following document by clicking on the link: Examples of Appears Dirty
  2. Dirt on the stone: A stone with dirt on the surface of the diamond can cause an excessive return of white light.  This can be seen in any or all of light views 1 through 5.   Please refer to the following document by clicking on the link: Examples of Appears Dirty
  3. Dirt on the glass: Dirt on the top or botom of the glass where the diamond is placed for scanning on the BrilliancesScope Analyzer will cause extra blobs to appear that falsely alter the results of the light performance scales.   Typically a group of scans will be rejected for 'Appears Dirty' when the dirt on the glass is not noticed by the BrillianceScope Analyzer operator.   This will be seen in all six light views.   Do not clean the glass with alcohol, because it leaves a film that causes rainbowing.   The glass can be cleaned with a standard glass cleaner and dried well with a paper towel.  
  4. Dirt on the camera lens: Dirt on the camera lens inside the BrilliancesScope Analyzer will cause extra blobs to appear that falsely alter the results of the light performance scales.   Typically a group of scans will be rejected for 'Appears Dirty' when the dirt on the camera lens is not noticed by the BrillianceScope Analyzer operator.   This will be seen in all six light views.   The first thing to try to get dirt off of the camera lens is to blow on it to remove dust.   If the camera lens needs further cleaning, the lens should only be cleaned with lens cleaner and a lens cleaning towel.   Using anything else may scratch the camera lens.   Please refer to the following document by clicking on the link: Examples of Appears Dirty
  5. Static Electricity: Another reason for a stone to appear dirty is caused by static.   This is more of a problem during dry months.   Static is an electrical charge that can cause objects to either attract or repel each other.   In the case where the static charge causes the glass on the BrillianceScope Analyzer and the stone to repel each other, the stone actually slightly levitates above the glass.   This small gap causes a phenomenon called 'Newton's rings' which is the same principle behind why rainbows appear.   The gap between the glass actually makes a rainbow that looks ths same as the rainbowing from oil on the stone.   The solution is to discharge static from the stone by touching it to a grounded metal source.   If the tweezers are metal the tweezers should be touched to ground after the stone is picked up.   Any unpainted surface on the BrillianceScope Analyzer such as a screw is a good ground, because the chassis is grounded.   There are four screw ends on the top of the BrillianceScope Analyzer surrounding the glass where the diamond gets placed.   There are also six screws used to hold the door onto the left side.   Immediately after touching the tweezers or diamond to the exposed metal and before touching anything else, place the diamond on the glass, then close the door and begin the scan.   Please refer to the following document by clicking on the link: Examples of Appears Dirty



Rejected Reason: Bad Separation
Go Back to top

This occurs when the default separation is incorrectly set, or when the separation needs to be temporarily adjusted for the diamter of the stone currently being scanned. When the sparation is not set correctly, the outline of the stone is incorrectly detected.   Incorrectly adjusted separation may also cause a scan to be rejected for Wrong Shape.   Please refer to the following document for example images of Bad Separation and instructions to change the separation value by clicking on the link: Adjusting the Separation Value



Rejected Reason: Below Performance Standard
Go Back to top

This applies for companies that require the light scales to meet a certain requirement. Examples currently in use are:

  1. All three scales must be high or better to pass.
  2. Two of the scales must be at least medium while the third must be high or better to pass, but if any of the scales are very high the other two scales can be anywhere to pass.
If these performance requirements are a regular standard, we can program our Quality Check system to automatically reject scans that do not meet these requirements.  Stones rejected for 'Below Perofmrance Standard' usually requires the stone to be recut for better performance, depending upon the company's policy.



Rejected Reason: Duplicate
Go Back to top

Scans rejected for 'Duplicate' can be one of two reasons:

  1. Two or more different scans with the same stone ID were submitted for approval at the same time, so we are unable to determine which scan to make a report for.
  2. Two or more scans with different stone IDs are actually the same stone rescanned.   We beilieve this typically happens when the BrillianceScope Analyzer operator forgets to put the next stone in before scanning, so the same stone is rescanned.



Rejected Reason: Invalid Stone ID
Go Back to top

This applies for companies that have set up one or more programs with specific prefixes and/or suffixes for their stone IDs.   This typically requires a certain number of characters within the stone ID for each prefix/suffix, and in most cases we will not take the liberty of renaming the stone IDs ourselves.



Rejected Reason: Missing Color/Clarity
Go Back to top

This applies for companies that require that the color and clarity gets entered into the BrillianceScope Analyzer program at the time of the scan, and this information is included in the GemEx LPA report.   In this case the scan is rejected if either the color or clarity is missing.



Rejected Reason: Missing Weight
Go Back to top

This applies for companies that require that the carat weight gets entered into the BrillianceScope Analyzer program at the time of the scan, and this information is included in the GemEx LPA report.   In this case the scan is rejected if the carat weight is missing.



Rejected Reason: Not Centered
Go Back to top

When a stone is not centered on the screen in the BrillianceScope Analyzer program, or if the BrillianceScope Analyzer itself is not centered properly during a factory calibration, a scan may be rejected for 'Not Centered'.   If a stone is not centered, the light scales will not be accurate or repeatable.   There is a range of tolerance for this, and depends mostly on the size of the stone being scanned.   Larger stones are more obvious when they are not centered than smaller stones.   Please refer to the following document by clicking on the link: Examples of Not Centered



Rejected Reason: Other Problem
Go Back to top

This is typically due to an error that occurred with the BrillianceScope Analyzer program that causes a scan to look unacceptable.   This rejection reason is not very common, and we are continously improving the BrillianceScope Analyzer program so this is becoming more rare.



Rejected Reason: Previously Approved
Go Back to top

Scans are rejected for 'Previously Approved' when a stone ID that has already been approved is submitted for approval again.   Scans rejected for this reason should not be rescanned or resubmitted for approval.   Unless arrangements are made ahead of time, we cannot determine if the original scan should be replaced or if this is an error on the customer's part where two or more stones were labeled with the same stone ID.   In most cases an LPA report has already been made for the first scan, and having two different LPA reports with the same stone ID but different stones is against our general policy.   If a reprint request came in for a stone ID with two different stones, we could not be certain which is the correct scan.   If a reprint of an LPA report is required the stone should not be rescanned, but instead a request can be made to have the LPA report reprinted.



Rejected Reason: Questionable Calibration
Go Back to top

Scans will be usually be rejected for this reason in groups of stones scanned on the same BrillianceScope Analyzer.   In most cases the light views have green or red hues that are not normal in one or more light views.   This usually indicates that the BrillianceScope Analyzer should first be calibrated with an xCalibration, and then followed up with a factory calibration if the problem does dissappear.   On occasion it is determined that there is a faulty component on the BrillianceScope Analyzer, which requires one or more parts to be shipped to the customer's location for replacement.   Before a determination can be made for replacement of a faulty component, both an xCalibration and a factory calibration must be performed as well as scanning and submitting a few stones afterward for our review.   Please refer to the following document by clicking on the link: Examples of Questionable Calibration



Rejected Reason: Stone Moved
Go Back to top

If a stone moves during the middle of the scanning process, the light scales will not be accurate or repeatable.   This can be caused by bumping the BrillianceScope Analyzer during the scanning process, or loose parts inside the BrillianceScope Analyzer that causes excess vibration.   When a scan is analyzed by the BrillianceScope Analyzer program, the outline is determined from sampling the stone in all six light views.   When the stone moves, the outline is skewed which causes what we call 'noise'.   Noise can severely alter the scales incorrectly.   Please refer to the following document by clicking on the link: Examples of Stone Moved



Rejected Reason: Wrong Shape
Go Back to top

This can happen for three reasons:

  1. The default separation is incorrectly set or the separation must be temporarily adjusted for the stone diameter currently being scanned.   In this case the BrillianceScope Analyzer program cannot automatically determine the correct shape, because the outline of the stone is altered.
  2. For a company with a program using prefixes and/or suffixes in the stone IDs, the wrong prefix or suffix may have been entered during the scan process which causes a mismatch of stone ID to shape.
  3. The shape of the stone has not yet been programmed into the BrillianceScope Analyzer program, and it was incorrectly detected as a different shape than it really is.

Go Back to top