Help uploading Excel file
You can add or update gemstones in the GemeShare using a Excel file.
The First row of the file must contain the headers for each corresponding field and must looks like:
GEMSTONE_ID;CATEGORY_ID;SUBCATEGORY_ID;GEMSTONE_TYPE;SHAPE;CARATS;LENGTH;WIDTH;DEPTH;PRICE;QUANTITY;URL_GEMESTONE;URL_PICTURE;GW_COLOR;GW_TONE;GW_SATURATION;GRADE;ENHANCEMENT;CERTIFICATE;URL_CERTIFICATE;COMMENTS
Begining with the second row must be created a row for each gemstone that looks like:
998;1;0;23;3;5.01; ;5;6;851.8;1;http://www.yoursite.com/products.php?id=26614;http://www.yourwebsite.com/apps/images/gemstones/thumb/26614.jpg ;25;3;4;2;5;1; http://www.yourwebsite.com/apps/images/gemstones/thumb/cert_1.jpg; a great gemstone
The file must not contain any error to be correctly uploaded. The following validationds are done:
GEMSTONE_ID: must be different to blank
CATEGORY_ID: must contain one of the following values:
1 Single Gemstone
2 Parcel
3 Jewerly
SUBCATEGORY_ID: must contain one of the following values:
1 Bracelets
2 Earrings
3 Necklaces
4 Pendants
5 Rings
* Sub Categories only for Jewerly Category
GEMSTONE_TYPE: must contain one of the following values:
1 Alexandrite
2 Amethyst
3 Aquamarine
6 Citrine
7 Emerald
8 Garnet
10 Garnet, Rhodolite
11 Garnet, Champagne
12 Garnet, Tsavorite
13 Iolite
14 Peridot
15 Ruby
16 Sapphire, Blue
17 Sapphire, Natural Fancy
19 Montana Sapphire
21 Tanzanite
22 Topaz, Precious (Golden)
23 Tourmaline
24 Garnet, Mozambique
37 Garnet, Color change
38 Garnet, Spessartite
42 Opal
49 Peridot, Arizona
50 Quartz, Smoky
51 Sapphire, Yellow
52 Sapphire, White
54 Topaz, London Blue
55 Topaz, Sky Blue
56 Topaz, Swiss Blue
58 Tourmaline, Green
62 Zircon, Blue
63 Topaz, Blue
64 Sapphire
74 Cubic Zirconia
134 Sapphire, Natural Fancy-Brown
135 Fancy Sapphire, Color Change
136 Sapphire, Natural Fancy -Green/Blue
137 Sapphire, Natural Fancy-Orange
138 Sapphire, Natural Fancy-Purple
139 Sapphire, Natural Fancy-Red
140 Sapphire, Natural Fancy-Lilac
142 Sapphire, Synthetic
157 Tourmaline, Blue
161 Sapphire, Pink
162 Sapphire, Natural Fancy Yellow
165 Garnet Andradite
166 Garnet Chrome Pyrope
167 Sapphire, Burma / Kashmir
168 Beryl, Red
169 Andalusite
170 Apatite
171 Benitoite
172 Diopside
173 Kunzite
174 Sapphire, Color Change
175 Sapphire, Padparadcha
176 Spinel
177 Spinel, Red
178 Spinel, Blue
180 Garnet, Malaia
181 Garnet, Grossularite
182 Morganite
183 Beryl, Golden
185 Beryl, Green
186 Topaz, Pink
187 Tourmaline, Chrome
188 Zircon, Brown
189 Topaz
190 Topaz, Imperial
191 Spinel, Lavender
192 Tourmaline, Bi-color
193 Tourmaline, Blue-Green
194 Tourmaline, Red
195 Tourmaline, Paraiba
196 Sapphire, Green
197 Ruby, Burma
198 Quartz, Ametrine
199 Garnet, Almandite
200 Garnet, Demantoid
203 Tourmaline, Red /Pink
213 Zircon
214 Jade
215 Garnet, Mandarin
216 Amber
217 Amblygonite
218 Ametrine
219 Andesine-Labradorite
221 Aragonite
222 Azurmalachite
224 Bixbite
225 Cats-Eye Quartz
226 Cerussite
227 Chalcedony
228 Chrysoberyl
229 Chrysocolla
230 Chrysoprase
231 Copal
232 Crystal Quartz
233 Cuprian Tourmaline
234 Danburite
id value
235 Diamond
236 Diaspore
237 Drusy Quartz
238 Epidote
239 Euclase
240 Fire Agate
241 Fluorite
242 Fossils
243 Glass
244 Hauyne
245 Helenite
246 Heliodor
247 Hiddenite
248 Imperial Hessonite
249 Indicolite
250 Jasper
251 Kyanite
252 Labradorite
253 Lapis Lazuli
254 Leopard Quartz
255 Lepidocrocite Quartz
256 Madeira Citrine
257 Magnesite
258 Mandarin Ice
259 Medusa Quartz
260 Moldavite
261 Moonstone
262 Mother-Of-Pearl
263 Multi-Gemstone
264 Mystic Topaz
265 Obsidian
266 Opal Recon Matrix
267 Orthoclase
268 Pearl
269 Petalite
270 Phenakite
271 Prasiolite
272 Prehnite
273 Quartz
274 Rhodochrosite
275 Rhodonite
276 Scapolite
277 Scheelite
278 Semiblack Opal
279 Shanseres (tm)
280 Sillimanite
281 Sinhalite
282 Sphalerite
283 Sphene
284 Spodumene
285 Strawberry Quartz
286 Strontium Titanate
287 Sunstone
288 Teradora (tm)
289 Trapiche Emerald
290 Turquoise
291 Ulexite
292 Yag
293 Zandrite
294 Zoisite
295 Tourmaline, Mozambique
296 Rubellite
297 Fire Opal
298 Hessonite Garnet
SHAPE: must contain one of the following values:
2 Oval
3 Emerald
4 Round
5 Trillion
6 Square
7 Pear
8 Heart
9 Princess
10 Radiant/Modified Square
12 Marquise
14 Baguette
16 Cab. Oval
17 Cab. Round
18 Cab. Pear
19 Cab. Marquise
20 Cushion/Antique
21 Square Cushion/Antique
58 Round Diamond Cut
CARATS: Must be greater than 0
LENGTH: Blank or numeric value
WIDTH: Blank or numeric value
DEPTH: Blank or numeric value
PRICE: Must be greater than 0
QUANTITY: Must be greater than 0
ENHANCEMENT: must contain one of the following values:
1 N None - no enhancement -
2 H Heating
3 O Oiling/Resin Infusion
4 R Irradiation
5 B Bleaching
6 C Coating
7 D Dyeing
8 F Filling
9 HP Heating and Pressure
10 I Impregnation
11 L Lasering
12 U Diffusion
13 W Waxing/Oiling
14 E Enhanced
CERTIFICATE: must contain one of the following values:
1 AGTA
2 GIA
3 GUBELIN
4 SSEF
5 EGL
6 AGL
7 IGI
8 AGS
9 SI
10 NONE
11 EGC
12 GIT
13 GRS
URL_GEMESTONE: Must be the internet address in case your gemstone is in a website in the internet.
URL_PICTURE: Must be the internet address where the picture of your gemstone is located.
URL_CERTIFICATE: Must be the internet address where the picture of your gemstone certificate is located (not required field).
GW_COLOR: Gemewizard color of your gemstone, optional (done automatically by the gemeshare).
1 Red
2 orangy Red
3 red-orange
4 reddish Orange
5 Orange
6 yellowish Orange
7 orangy Yellow
8 Yellow
9 greenish Yellow
10 Yellow-Green
11 strongly yellowish Green
12 yellowish Green
13 slightly yellowish Green
14 Green
15 very slightly bluish Green
16 bluish Green
17 very strongly bluish Green
18 Green-Blue
19 very strongly greenish Blue
20 greenish Blue
21 very slightly greenish Blue
22 Blue
23 violetish Blue
24 bluish Violet
25 Violet
26 violetish Purple
27 Purple
28 reddish Purple
29 Red-Purple or Purple-Red
30 strongly purplish Red
31 slightly purplish Red
GW_TONE: Gemewizard tone of your gemstone, optional (done automatically by the gemeshare).
2 Very light
3 Light
4 Medium light
5 Medium
6 Medium dark
7 Dark
8 Very dark
GW_SATURATION: Gemewizard saturation of your gemstone, optional (done automatically by the gemeshare).
1 Grayish/Brownish
2 Slight Grayish/Brown
3 Very Slightly Grayish / Brownish
4 Moderately Strong
5 Strong
6 Vivid
GRADE: Grade of your gemstone, optional (done automatically by the gemeshare).
1 GEM
2 AAA
3 AA
5 A
6 B
7 C
COMMENTS: Comments about your gemstone.