|
|
|
The file you upload must be a CSV (comma delimited file) with each field delimited
by a comma. A Microsoft Excel file should be saved as a CSV file before uploading.
The first row should contain the field headers. The upload instructions are in place
for all ways you can upload manual or programmatically.
For uploading help, please email tech@diamonds.net.
The following are valid RapNet fields. See below for complete list of RapNet field
names and accepted values:
|
Main diamond details
|
Stock #, Shape, Size,Color , Clarity, Polish,
Symmetry,Cut Grade ,
Fluorescence Intensity, Fluorescence Color,
Measurements, Lab,
Certificate #, Treatment |
|
Prices
|
RapNet Price, RapNet Discount
%, Cash Price, Cash Price
Discount % |
|
Additional diamond details
|
Fancy Color, Fancy Color
Intensity, Fancy Color Overtone,
Depth %, Table %, Girdle Thin,
Girdle Thick, Girdle %,Girdle
Condition, Culet Size, Culet
Condition, Crown Height, Crown
Angle, Pavilion Depth, Pavilion
Angle, Laser Inscription, Comment
|
|
Location and status
|
Country, State, City,
Availability
|
|
Permissions and other
|
Is Matched Pair Separable,
Pair Stock #, Allow RapLink Feed,
Parcel Stones, Certificate Filename,
Diamond Image, 3D File,
Trade Show
|
RapNet field names and accepted values:
|
Field name
|
Acceptable alternate field names
|
Acceptable field values
|
Comments
|
|
3D File
|
3DFile, Sarin, SarinFile, Srn, SrnFile, ThreeDFile, ThreeDImage
|
|
The filename of the 3d image.
This can be a .srn, .gem, or .ogi.
|
|
Top |
|
|
Allow RapLink Feed
|
AllowRapLinkFeed, RapLink
|
Y = Yes
N = No
|
Allows this diamond to appear
in Raplink Diamond Feed Service (virtual inventory).
|
|
Top |
|
|
Availability
|
Avail, Availability, Available,
Status AllowRapLinkFeed, RapLink
|
G = Guaranteed Availability, GA, Guaranteed, GuaranteedAvailable
GAC = Gauranteed Availability Cash Only, GC, Guaranteed Cash
M = Out on Memo, Memo, OnMemo, On Memo
STPS = Subject to Prior Sale
NA = Not Available, N, Unavailable"
|
|
If "NA" is entered, the stone will not appear in search results. Guaranteed
available means the seller has immediate access to the diamond.
|
|
Top |
|
|
Cash Price
|
Index Price, Index Asking Price
|
|
|
The price at which the seller is prepared to sell for cash on delivery/order. Per
Carat, no dollar sign, no commas, no cents.
|
|
Top |
|
|
Cash Discount %
|
IndexDiscountPercent
|
Examples: Entering: -0.30 will give 30% below Rap.
|
|
Enter a negative decimal (eg - 0.25) for a discount or positive decimal (eg 0.05)
for a premium the Rapaport list.
|
|
Top |
|
|
Certificate #
|
Cert Num, CertID, CertificateID, CertificateNum, CertificateNumber, CertNo, CertNum,
CmPub
|
|
|
Enter the number on the certificate from the grading lab.
|
|
Top |
|
|
Certificate Filename
|
CertFile, CertFilename, CertificateFile, CertificateFilename, CertificateImage,
CertImage, File
|
Only .JPG and . PDF files are accepted. Maximum size of the scan should not exceed
100kb for easy viewing
|
|
Scanned image of the certificate in JPG or PDF form only.
|
|
Top |
|
|
City
|
City, CityLocation
|
|
|
Specify the city location of the stone.
|
|
Top |
|
|
Clarity
|
Clar, Clarity, Clearity, Purity
|
FL, IF, Loupe Clean, LC, VVS1, VVS2, VS1, VS2, SI1, SI2, SI3, I1, P1, I2, P2, I3,
P3.
|
|
For fancy colored stones that have no clarity, enter "N" for none.
|
|
Top |
|
|
Color
|
Color, Colr, Colour
|
D, E, F, G, H, I, J, K, L, M, N, O,P, Q, R, S, T, U, V, W, X, Y, Z
|
|
For fancy colors use the fancy color column.
|
|
Top |
|
|
Comment
|
Comments, Remarks
|
|
|
No more than 255 characters.
|
|
Top |
|
|
Country
|
Country, CountryLocation, LotCountry
|
|
|
Specify the country location of the stone.
|
|
Top |
|
|
Crown Angle
|
|
|
|
Give a value to the nearest 0.5 degree.
|
|
Top |
|
|
Crown Height
|
Crown, Crown Percent, CrownHeight, CrownPct
|
|
|
Give percentage with only one number after the decimal. Do not include % sign.
|
|
Top |
|
|
Culet Condition
|
|
P = Pointed
A = Abraded
C = Chipped
|
|
|
Culet Size
|
Culet, CuletSize, Culet_size, CuletGrade,Cullet, CulletGrade
|
VL = Very Large
L = Large
M = Medium
S = Small
VS = Very Small
N = None
|
|
|
Cut Grade
|
Cut, CutGrade
|
I= Ideal, ID
EX = Excellent, EXC
VG = Very Good
G = Good
F = Fair
P = Poor
|
|
|
Depth %
|
Depth, Depth Percent, DepthPct, DepthPercent, Dpth, TotalDepth
|
Example: 62.4
|
|
Give percentage with only one number after the decimal. Do not include % sign.
|
|
Top |
|
|
Diamond Image
|
DiamondImage, Image, ImageFile, Photo
|
Only .JPG and . PDF files are accepted. Maximum size of the scan should not exceed
100kb for easy viewing
|
|
Scanned image of the certificate in JPG or PDF form only.
|
|
Top |
|
|
Fancy Color
|
FancyColor, FancyColorMainBody,
FC-Main Body, FCMainBody
|
BK = Black
B = Blue
BN = Brown
CM = Champagne
CG = Cognac
GY = Gray, Grey
G = Green
O = Orange
P = Pink
PL = Purple
R = Red
V = Violet
Y = Yellow
W = White, WH
X =Other, OT
|
|
To enter two colors, separate with a hyphen or a space. Example: Blue-Green, Blue
Green, B-G, B G
|
|
Top |
|
|
Fancy Color Intensity
|
FancyColorIntensity, FCIntensity, FC-Intensity
|
F = Faint
VL = Very Light
L = Light
FCL = Fancy Light
FC = Fancy, FC
FCD = Fancy Dark
I = Fancy Intense
FV = Fancy Vivid
D = Fancy Deep, DP, Deep
|
|
|
Fancy Color Overtone
|
FancyColorOvertone, FancyColorOvertones, FCOvertone
|
Example: Brownish-Yellowish
|
|
List any overtones in the color.
|
|
Top |
|
|
Fluorescence Color
|
FlrColor, Fluo Color, Fluor Color, FluorColor, FluorescenceColor
|
B = Blue, BL
W = White, WH
Y = Yellow, YL
O = Orange, OR
R = Red
G = Green, BG
N = None, NIL, NON
|
|
Default is "N" if left blank.
|
|
Top |
|
|
Fluorescence Intensity
|
Flr, FlrIntensity, Fluo Intensity, Fluor, Fluor Intensity, Fluorescence, Fluorescence
Intensity, FluorescenceIntensity, FluorIntensity
|
VS = Very Strong, VST, FL4
S = Strong, STG, ST, FL3
M = Medium, MED, FL2,
F = Faint,FNT, Negligible, FA, FL1
SL = SL, Slight, SLI
VSL = Very Slight, VSLG, VSLT
N = None, NON,No, NIL, FL0
|
|
|
Girdle %
|
Girdle Percent, GirdlePct, GirdleThicknessInPct
|
|
|
Must be a positive number. Do not include % sign.
|
|
Top |
|
|
Girdle Condition
|
Girdle Condition
|
P = Polished
F = Faceted
B = Bruted
|
|
|
Girdle Thick
|
GirdleMax, GirdleThick
|
Extremely Thick = XTK, EXTHICK, EXTHK, XTHK, XTHICK, XTHIK, ETK, EK, XK
Very Thick= VTK, VTHCK, VTHK, VTHICK
Thick = TK, THK, THIK, THIC
Slightly Thick = STK, SLTK, SLTHK
Medium = M, MED, MD
Thin = TN, THN
Slightly Thin = STN, SLTN, SLTHN
Very Thin= VTN, VTHN, VTHIN, VN
Extremely Thin = XTN, XTHN, EXTN, ETN, EN, XN
|
|
|
Girdle Thin
|
Girdle, GirdleMin, GirdleThin
|
Extremely Thick = XTK, EXTHICK, EXTHK, XTHK, XTHICK, XTHIK, ETK, EK, XK
Very Thick= VTK, VTHCK, VTHK, VTHICK
Thick = TK, THK, THIK, THIC
Slightly Thick = STK, SLTK,SLTHK
Medium = M, MED, MD
Thin = TN, THN
Slightly Thin = STN, SLTN, SLTHN
Very Thin= VTN, VTHN, VTHIN, VN
Extremely Thin = XTN, XTHN, EXTN, ETN, EN, XN
|
|
You may enter both Girdle Thin and Girdle Thick in this field, separate with a hyphen.
Example: thn-thk
|
|
Top |
|
|
Is Matched Pair Separable
|
IsMatchedPairSeparable, IsPairSeparable, PairSep, PairSeparable, Separable, Separatable
|
Y = Yes
N = No
|
|
If this value is set to "Y" the individual diamonds will show up in single
stone searches as well as pair searches. If stones are a pair and they are marked
NOT separable they will NOT show up in single stone searches.
|
|
Top |
|
|
Lab
|
Cert, Certificate, Laboratory
|
GIA = G.I.A, G
AGS = AGS, AGSL, AGS0, A
HRD = HRD, H
IGI = IGI, I
EGL USA = EGU, EGL USA, EGLUSA, EGLNY, EGL U.S.A, EGL US, EGL Canada
EGL Belgium = EGB, EGL Belgium
EGL International
EGL Israel = EGI, EGL Israel
EGL Pre-Cert
EGL South Africa = EGL South Africa, EGL S. Africa
GCAL
GSL = Gemscan
VGR
DCLA
PGS
Other = Other, Own
None = None, N, X, NO, NON,NC, NonCert
|
|
|
Laser Inscription
|
|
|
|
Enter no more than 50 characters.
|
|
Top |
|
|
Measurements
|
Dimensions, Meas, Measurement, Measurements
|
Example: 8.93 x 6.44 x 3.82
|
|
|
MeasWidth
|
Measurements Width, Width, MeasurementsWidth
|
|
|
Use as alternative to "measurements"
|
|
Top |
|
|
MeasDepth
|
Measurements Depth, Height, MeasurementsDepth, MeasHeight
|
|
|
Use as alternative to "measurements"
|
|
Top |
|
|
MeasLength
|
Measurements Length, Length, MeasurementsLength
|
|
|
Use as alternative to "measurements"
|
|
Top |
|
|
Pair Stock #
|
MatchedPairStockNo, MatchedPairStockNum, MatchedPairStockNumber, Matching Stock
Num, MatchingPair, MatchingStockNo, MatchingStockNum, MatchingVenderStockNumber,
Pair, PairStock, PairStockNum, PairStockNumber
|
|
|
Enter the stock number of the other diamond in the pair.
|
|
Top |
|
|
Parcel Stones
|
ParcelStoneCount, ParcelStones, StoneCount, Stones
|
|
|
Enter the number of stones in the parcel. This field should be left blank for single
stones.
|
|
Top |
|
|
Pavilion Angle
|
|
Example: 62.3
|
|
Give a value to one decimal place.
|
|
Top |
|
|
Pavilion Depth
|
Pavil, Pavilion, Pavilion Percent, PavilionDepth, PavilionPct
|
Example: 62.3
|
|
Give a value to one decimal place.
|
|
Top |
|
|
Polish
|
Finish, Pol
|
I = I, ID
EX = Excellent, X
VG-EX = Very Good to Excellent, VGEX
VG = Very Good,V, V. Good, V.G
G-VG = Good to Very Good
G = Good
F-G = Fair to Good
F = Fair
P= Poor
|
|
|
RapNet Discount %
|
PctRapNetDiscount, Rap netDisc, RapnetDiscount, RapnetDiscountPct, RapnetDiscountPercent,
RapnetDiscPct, RapnetDpx, RapnetRapPct, RDisc, RDiscount, RDiscountPct, RDiscountPercent,
RDiscPct, RDpx, RRapPct
|
Example: -0.34
|
|
To enter a discount below the Rap price, enter a negative decimal value, such as
-.25
|
|
Top |
|
|
RapNet Price
|
AskingPrice, PerCarat, PerCt, Prc, Price, PriceCarat, PriceCt, PricePerCarat, PricePerCt,
Px
|
|
|
The price at which the seller is prepared to sell the diamond, often a memo or credit
price. Per carat, no dollar sign, no commas, no cents.
|
|
Top |
|
|
Shape
|
Shp
|
Round = B, BR, RB, RD, RBC, Round Brilliant, RND
Pear = P, PS, PSH
Emerald = E, EM,EC
Square Emerald = SQE, SQEM
Princess = PRN, PR, PRIN, PN, PC, MDSQB, SMB
Marquise = MQB, M, MQ
Asscher = A, CSS, AC
Baguette = BAG, BG
Briolette = Briolette, BRIO, BRIOLET, BT
Bullets = BU
Cushion = C, CUX,CU, CB, CUSH, CUS
Cushion Modified = CMB, RCRMB, CRC, CSC, CX, RCSB, SCMB, SCX
EuropeanCut = EU
Flanders = FL, FC
Half Moon = HM, HMB
Heart = H, HS, HT
Hexagonal = HEX
Kite = K, KT
Lozenge = LOZ
Octagonal = Octagonal, OC
Old Miner = OM
Oval = O, OV
Pentagonal = PEN
Radiant= R, RAD, RA, RC, RDN
Rose = RS
Shield = SH
Square = SQ
Star = S, ST
Trapezoid = TP, TRAP, TRAPB, TZ
Triangle = Triangular, TRI
Trilliant = T, TR, TRIL, TRILL, TRIB,TRL, MTRI
|
|
|
Size
|
Carat, CaratSize, CaratWeight, Ct, CtSize, CtWeight, Weight, Sz, Weight
|
Enter .01-99.
|
|
For parcels enter total carat weight up to two decimal points.
|
|
Top |
|
|
State
|
StateLocation
|
|
|
Specify the state location of the stone.
|
|
Top |
|
|
Stock #
|
ReferenceNum, ReferenceNumber, Stock, Stock Num, Stock_no, StockNo, StockNum, StockNumber,
VenderStockNumber
|
|
|
Enter your inventory stock number.
|
|
Top |
|
|
Symmetry
|
Sym, Symetry, Sym-metry
|
I = I, ID
EX = Excellent, X
VG-EX = Very Good to Excellent, VGEX
VG = Very Good,V, V. Good, V.G
G-VG = Good to Very Good
G = Good
F-G = Fair to Good
F = Fair
P= Poor
|
|
|
Table %
|
Table, Table Percent, TablePct, TablePercent, Tbl
|
Example: 60
|
|
Give percentage in two digit form. Do not include % sign.
|
|
Top |
|
|
Trade Show
|
TradeShow
|
For use during major trade shows.
|
|
See Rap.Net for instructions.
|
|
Top |
|
|
Treatment
|
Enhance, Enhancement, Enhancements, Enhance-ments, Treatments
|
LD = Laser Drilled
IRR = Irradiated
CE= Clarity Enhanced, Fracture Filled
COL = Color Enhanced
HPHT = High pressure high temperature
OT = Other (enter any other type of treatment)
N = For none, if the stone is untreated.
|
|
To enter multiple values, separate with a semicolon (;). ALL treatments MUST
be listed.
|
|
Top |
|
Related links:
|