|
Home > Archive > Commerce Server General > December 2004 > Catalog XML files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| ryanr@nni.com 2004-11-16, 5:48 pm |
| This question is primarily directed at the MS people.
I'm working on a tool to build all permutation of products, as opposed
to creating a script for each catalog. I'm curious if there is any
documentation detailing how how Commerce Server 2002 builds each part
of the XML file.
For example, the "Price" fields of both the Product and Product
Variant (in Business Desk) become an attribute "listprice" of the
"Product" and "ProductVariant" nodes in the Catalog XML files.
Are there any links, documentation, etc. or am I going to spend a week
playing with Business Desk, slotting in various options and seeing
what comes out?
Many Thanks,
Ryan Ross
| |
| Robert Bogue [MVP] 2004-11-16, 8:47 pm |
| When we were investigating bulk import we saw that doing XML exports was the
easiest way to determine the file format.
However, ultimately we decided against the bulk import and opted for a web
service to update products individually -- which has it's own issues, but is
workable.
Rob
<ryanr@nni.com> wrote in message
news:8u4lp01eptr4vqj3ut4bj1vsprf7djcjjl@
4ax.com...
> This question is primarily directed at the MS people.
>
> I'm working on a tool to build all permutation of products, as opposed
> to creating a script for each catalog. I'm curious if there is any
> documentation detailing how how Commerce Server 2002 builds each part
> of the XML file.
>
> For example, the "Price" fields of both the Product and Product
> Variant (in Business Desk) become an attribute "listprice" of the
> "Product" and "ProductVariant" nodes in the Catalog XML files.
>
> Are there any links, documentation, etc. or am I going to spend a week
> playing with Business Desk, slotting in various options and seeing
> what comes out?
>
> Many Thanks,
> Ryan Ross
| |
| ryanr@nni.com 2004-11-17, 2:46 am |
| Fair enough, but I'd like to give my approach a try.
As it stands, I've completed about half of it (so I want to finish
it), just need to whack in multi-language support. I went with the
tree approach (every choice is a node).
Do any MS employees have the one-to-one Business Desk to Catalog XML
specs available? I'll be irked if I have to play with Business Desk
this weekend.
Actually, does anyone have a relatively modest catalog (less than
1,000 items) with multi-language items they can send me?
Regards,
Ryan Ross
On Tue, 16 Nov 2004 21:40:53 -0500, "Robert Bogue [MVP]"
<robert[dot]bogue[at]crowechizek[nospam]com> wrote:
>When we were investigating bulk import we saw that doing XML exports was the
>easiest way to determine the file format.
>
>However, ultimately we decided against the bulk import and opted for a web
>service to update products individually -- which has it's own issues, but is
>workable.
>
>Rob
>
><ryanr@nni.com> wrote in message
> news:8u4lp01eptr4vqj3ut4bj1vsprf7djcjjl@
4ax.com...
>
| |
| Ravi Shankar 2004-11-17, 7:47 am |
| If you have an existing catalog file, you should export it using the BizDesk
or the Catalog Manager (if you're using FP1). Load this into a XML Document
Editor like that came with BizTalk 2002 and you'd have your schema.
Basically, there is a MSCommerceServerCatalog.. something node with a
version attribute, 2.0 if you're using commerce server 2002 sp2 or 2.5 if
you're using FP1.
Then there are two child nodes, one being CatalogSchema and the other being
Catalog.
Then under catalog you have DisplayName with language as the attribute
(multi lingual) and categories, products each with displayname, name, parent
category as nodes and everyting else as attributes.
"ryanr@nni.com" wrote:
> Fair enough, but I'd like to give my approach a try.
>
> As it stands, I've completed about half of it (so I want to finish
> it), just need to whack in multi-language support. I went with the
> tree approach (every choice is a node).
>
> Do any MS employees have the one-to-one Business Desk to Catalog XML
> specs available? I'll be irked if I have to play with Business Desk
> this weekend.
>
> Actually, does anyone have a relatively modest catalog (less than
> 1,000 items) with multi-language items they can send me?
>
> Regards,
> Ryan Ross
>
>
> On Tue, 16 Nov 2004 21:40:53 -0500, "Robert Bogue [MVP]"
> <robert[dot]bogue[at]crowechizek[nospam]com> wrote:
>
>
>
| |
| ryanr@nni.com 2004-11-20, 2:47 am |
| Ok, final question(s):
Where can I find info on the languages supported by Commerce Server?
I'm looking at a table right now (Retail2002) called
CatalogLanguageMap, which holds a couple of languages, but the number
in Bizdesk is more. Where can I find a table of these two (i.e.
English-US = "en-us")?
How about a table of currencies, and their codes?
Units of measurement?
Thanks,
Ryan
On Wed, 17 Nov 2004 02:30:02 -0800, Ravi Shankar
<shankycheil@newsgroup.nospam> wrote:
[vbcol=seagreen]
>If you have an existing catalog file, you should export it using the BizDesk
>or the Catalog Manager (if you're using FP1). Load this into a XML Document
>Editor like that came with BizTalk 2002 and you'd have your schema.
>
>Basically, there is a MSCommerceServerCatalog.. something node with a
>version attribute, 2.0 if you're using commerce server 2002 sp2 or 2.5 if
>you're using FP1.
>Then there are two child nodes, one being CatalogSchema and the other being
>Catalog.
>
>Then under catalog you have DisplayName with language as the attribute
>(multi lingual) and categories, products each with displayname, name, parent
>category as nodes and everyting else as attributes.
>
>
>
>"ryanr@nni.com" wrote:
>
| |
| David Messner [MSFT] 2004-12-28, 2:49 am |
| The catalog system doesn't force you into any particular scheme for
language identifiers.
That said, I would recommend using the standard RFC1766 language
identifiers (.NET Framework uses these for CultureInfo).
http://rfc.net/rfc1766.html
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.
--------------------
NNTP-Posting-Date: Sat, 20 Nov 2004 01:22:00 -0600
From: ryanr@nni.com
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: Catalog XML files
Date: Sat, 20 Nov 2004 02:21:57 -0500
Message-ID: <9krtp0h2rn9vgloehn15ocumjgmqt2e12p@4ax.com>
References: <8u4lp01eptr4vqj3ut4bj1vsprf7djcjjl@4ax.com>
<e35vc7EzEHA.336@TK2MSFTNGP10.phx.gbl>
<aemlp0dib1n4n2ehqcbm9pviin49e7odj0@4ax.com>
<FD521D96-9C9B-4BA4-81C9-59E2376E7891@microsoft.com>
X-Newsreader: Forte Free Agent 2.0/32.646
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 90
NNTP-Posting-Host: 69.141.10.159
X-Trace:
sv3- 235w0+VZBb8rXhrlfpSplLL9x8nmuwQZ9Kuwto94
HFLq4Y+BFvuHzBoIkwiEaakLVM7+jReS
Kvk4tFL!ramKs4Lf2dBI8AwtVVAFvtzcL00/Pf5/OU2lM/MXPN/m2TAB+iw3LrcTIhTUW25UPnL/
K1CCkr8N!ypRphojTxnkVkQ==
X-Complaints-To: abuse@nni.com
X-DMCA-Complaints-To: abuse@nni.com
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
X-Postfilter: 1.3.20
Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!new
sfeed1.ip.tiscali.net!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giga
news.com!local1.nntp.dca.giganews.com!nntp.nni.com!news.nni.com.POSTED!not-f
or-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15126
X-Tomcat-NG: microsoft.public.commerceserver.general
Ok, final question(s):
Where can I find info on the languages supported by Commerce Server?
I'm looking at a table right now (Retail2002) called
CatalogLanguageMap, which holds a couple of languages, but the number
in Bizdesk is more. Where can I find a table of these two (i.e.
English-US = "en-us")?
How about a table of currencies, and their codes?
Units of measurement?
Thanks,
Ryan
On Wed, 17 Nov 2004 02:30:02 -0800, Ravi Shankar
<shankycheil@newsgroup.nospam> wrote:
>If you have an existing catalog file, you should export it using the
BizDesk
>or the Catalog Manager (if you're using FP1). Load this into a XML
Document
>Editor like that came with BizTalk 2002 and you'd have your schema.
>
>Basically, there is a MSCommerceServerCatalog.. something node with a
>version attribute, 2.0 if you're using commerce server 2002 sp2 or 2.5 if
>you're using FP1.
>Then there are two child nodes, one being CatalogSchema and the other
being
>Catalog.
>
>Then under catalog you have DisplayName with language as the attribute
>(multi lingual) and categories, products each with displayname, name,
parent[vbcol=seagreen]
>category as nodes and everyting else as attributes.
>
>
>
>"ryanr@nni.com" wrote:
>
was the[vbcol=seagreen]
web[vbcol=seagreen]
but is[vbcol=seagreen]
|
|
|
|
|