| Author |
Message |
Guest
|
 Posted:
Wed Nov 17, 2004 6:05 am Post subject:
Catalog XML files |
|
|
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 |
|
| Back to top |
|
 |
Robert Bogue [MVP]
Guest
|
| Posted:
Wed Nov 17, 2004 8:40 am Post subject:
Re: Catalog XML files |
|
|
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...
| Quote: | 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 |
|
|
| Back to top |
|
|
Guest
|
| Posted:
Wed Nov 17, 2004 11:05 am Post subject:
Re: Catalog XML files |
|
|
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:
| Quote: | 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
|
|
|
| Back to top |
|
|
Ravi Shankar
Guest
|
| Posted:
Wed Nov 17, 2004 4:30 pm Post subject:
Re: Catalog XML files |
|
|
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:
| Quote: | 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...
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
|
|
|
| Back to top |
|
|
Guest
|
| Posted:
Sat Nov 20, 2004 1:21 pm Post subject:
Re: Catalog XML files |
|
|
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:
| Quote: | 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:
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
|
|
|
| Back to top |
|
|
David Messner [MSFT]
Guest
|
| Posted:
Tue Dec 28, 2004 2:36 pm Post subject:
Re: Catalog XML files |
|
|
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+VZBb8rXhrlfpSplLL9x8nmuwQZ9Kuwto94HFLq4Y+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:
| Quote: | 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:
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
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in