|
Home > Archive > Commerce Server General > September 2005 > Catalog Export/Import
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]
| Author |
Catalog Export/Import
|
|
| Tomas Vera 2005-09-09, 5:52 pm |
| Hello All,
I'm working on a CS project for a client.
We build the original catalog from a XLS file that contained their
product IDs, descriptions, prices, etc.
But now they need to do a bulk update/modification.
I know that I can do an XML export from the BisDesk for them to review
the catalog info.
Assuming that they're able to make the mods that they need.
Can I re-import this catalog to update the existing items?
Or, will the imported items be treated as "new" items in the catalog?
Is there a better strategy for doing the export/update/import of the
existing catalog?
Any help is appreciated!
-tomas
| |
| Vinayak Tadas[MSFT] 2005-09-09, 5:52 pm |
| You can do an incremental update
The CatalogManager object has a method named ImportXml which contains a
parameter fUpdateOnly.
Setting this to true will update exieting items in the catalog
http://msdn.microsoft.com/library/d...-us/comsrv2k/ht
m/cs_rp_catalogmanager_zbhs_b.asp
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only
--------------------
From: Tomas Vera <taveraNOSPAM@sbcglobalREMOVE.net>
Newsgroups: microsoft.public.commerceserver.general
Subject: Catalog Export/Import
Message-ID: <47g3i15q9n3jlrc4r5qrastnue11rsib4o@4ax.com>
X-Newsreader: Forte Free Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 25
NNTP-Posting-Host: 12.44.161.140
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr21.news.prodigy.com 1126285810 ST000 12.44.161.140 (Fri, 09
Sep 2005 13:10:10 EDT)
NNTP-Posting-Date: Fri, 09 Sep 2005 13:10:10 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1:
SCSYQN_@FS@[SVP[KROFOFXBWR\HPCTL@XT^OBPLAH[\RWICYFWUQBKZQLYJX\_ITFD_KFVLUN[D
OM_A_NSYNWPFWNS[XV\I]PZ@BQ& #91;@CDQDPCL^FKCBIPC@KLGEZEFNMDYMKHRL_YY
YGDSSODXYN@[\
BK& #91;LVTWI@AXGQCOA_SAH@TPD^\AL\RLGRFWEARB
M
Date: Fri, 09 Sep 2005 17:10:10 GMT
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
wsfeed1.ip.tiscali.net!news.glorb.com!newscon02.news.prodigy.com!prodigy.net
!newsmst01b.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr
21.news.prodigy.com.POSTED!2080ae30!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3400
X-Tomcat-NG: microsoft.public.commerceserver.general
Hello All,
I'm working on a CS project for a client.
We build the original catalog from a XLS file that contained their
product IDs, descriptions, prices, etc.
But now they need to do a bulk update/modification.
I know that I can do an XML export from the BisDesk for them to review
the catalog info.
Assuming that they're able to make the mods that they need.
Can I re-import this catalog to update the existing items?
Or, will the imported items be treated as "new" items in the catalog?
Is there a better strategy for doing the export/update/import of the
existing catalog?
Any help is appreciated!
-tomas
| |
| Tomas Vera 2005-09-12, 6:07 pm |
| Vinayak,
Thanks for the information.
I've used the CatalogManager to export my catalog to an XML file.
But this file is not readable by Excel (probably since it is not in
the XML Spreadsheet format (?)).
I also tried linking to the file using MS Access, but it seems that I
can only import th file into MS Access. But the data is not imported
properly by MS Access. Most of the information is blank/null.
Can you recommed an application that will allow for editing/saving of
changes to the XML file generated by the catalog manager?
I only have a couple of hours in the budget for getting this done and
creating a quick and dirty editor will probably put me over my time
budet for this export/edit/import cycle.
Thanks.
-tomas
On Fri, 09 Sep 2005 18:45:46 GMT, vtadas@online.microsoft.com
("Vinayak Tadas[MSFT]") wrote:
>You can do an incremental update
>The CatalogManager object has a method named ImportXml which contains a
>parameter fUpdateOnly.
>Setting this to true will update exieting items in the catalog
>http://msdn.microsoft.com/library/d...-us/comsrv2k/ht
>m/cs_rp_catalogmanager_zbhs_b.asp
>
> Thanks
> Vinayak Tadas
> Microsoft
> http://blogs.msdn.com/vinayakt
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use. © 2002 Microsoft Corporation. All rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> Get Secure! For more info visit http://www.microsoft.com/security. Please
> reply to the newsgroups only
>
>
>--------------------
>From: Tomas Vera <taveraNOSPAM@sbcglobalREMOVE.net>
>Newsgroups: microsoft.public.commerceserver.general
>Subject: Catalog Export/Import
>Message-ID: <47g3i15q9n3jlrc4r5qrastnue11rsib4o@4ax.com>
>X-Newsreader: Forte Free Agent 2.0/32.652
>MIME-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>Lines: 25
>NNTP-Posting-Host: 12.44.161.140
>X-Complaints-To: abuse@prodigy.net
>X-Trace: newssvr21.news.prodigy.com 1126285810 ST000 12.44.161.140 (Fri, 09
>Sep 2005 13:10:10 EDT)
>NNTP-Posting-Date: Fri, 09 Sep 2005 13:10:10 EDT
>Organization: SBC http://yahoo.sbc.com
>X-UserInfo1:
>SCSYQN_@FS@[SVP[KROFOFXBWR\HPCTL@XT^OBPLAH[\RWICYFWUQBKZQLYJX\_ITFD_KFVLUN[D
>OM_A_NSYNWPFWNS[XV\I]PZ@BQ& #91;@CDQDPCL^FKCBIPC@KLGEZEFNMDYMKHRL_YY
YGDSSODXYN@[\
>BK& #91;LVTWI@AXGQCOA_SAH@TPD^\AL\RLGRFWEARB
M
>Date: Fri, 09 Sep 2005 17:10:10 GMT
>Path:
>TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
>wsfeed1.ip.tiscali.net!news.glorb.com!newscon02.news.prodigy.com!prodigy.net
>!newsmst01b.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr
>21.news.prodigy.com.POSTED!2080ae30!not-for-mail
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3400
>X-Tomcat-NG: microsoft.public.commerceserver.general
>
>Hello All,
>I'm working on a CS project for a client.
>
>We build the original catalog from a XLS file that contained their
>product IDs, descriptions, prices, etc.
>
>But now they need to do a bulk update/modification.
>
>I know that I can do an XML export from the BisDesk for them to review
>the catalog info.
>
>Assuming that they're able to make the mods that they need.
>
>Can I re-import this catalog to update the existing items?
>
>Or, will the imported items be treated as "new" items in the catalog?
>
>Is there a better strategy for doing the export/update/import of the
>existing catalog?
>
>Any help is appreciated!
>
>-tomas
>
/*-------------------------------
* Tomas Vera
* tomas (at) sbcglobal (dot) net
*-------------------------------
*/
| |
| Vinayak Tadas[MSFT] 2005-09-12, 8:49 pm |
| I am not sure if this can be developed in a couple of hours.
Instead of exporting the file cant you do this
1. Perform a search on the catalog to get the records you want to edit
2. Bind the recordset to a datagrid
3. Use the catalog APIs to save the changes made by the user back to the
catalog database.
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only
--------------------
From: Tomas Vera <tavera@NO_SPAM_sbcglobal.net>
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: Catalog Export/Import
Message-ID: <co2ai196av4bi6qkslbbsuebl6p7ojlj3v@4ax.com>
References: <47g3i15q9n3jlrc4r5qrastnue11rsib4o@4ax.com>
<Jff#16WtFHA.464@TK2MSFTNGXA01.phx.gbl>
X-Newsreader: Forte Free Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Lines: 104
NNTP-Posting-Host: 216.52.212.170
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr12.news.prodigy.com 1126501478 ST000 216.52.212.170 (Mon,
12 Sep 2005 01:04:38 EDT)
NNTP-Posting-Date: Mon, 12 Sep 2005 01:04:38 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1:
TSU[@SVGTRSYB_LYN& #91;O@_WH@YR_B@EXLLBWLOOAFEQR@ETUCCNSKQF
CY@TXDX_WHSVB]ZEJLSNY\
^J[CUVSA_QLFC^RQHUPH[P& #91;NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^
NXA\EVHSP[D_C^B_^
JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM
Date: Mon, 12 Sep 2005 05:04:38 GMT
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!newscon06.news.prodigy.com!prodigy.net!newsmst01b.news.prodigy.com!p
rodigy.com!postmaster.news.prodigy.com!newssvr12.news.prodigy.com.POSTED!208
0ae30!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3404
X-Tomcat-NG: microsoft.public.commerceserver.general
Vinayak,
Thanks for the information.
I've used the CatalogManager to export my catalog to an XML file.
But this file is not readable by Excel (probably since it is not in
the XML Spreadsheet format (?)).
I also tried linking to the file using MS Access, but it seems that I
can only import th file into MS Access. But the data is not imported
properly by MS Access. Most of the information is blank/null.
Can you recommed an application that will allow for editing/saving of
changes to the XML file generated by the catalog manager?
I only have a couple of hours in the budget for getting this done and
creating a quick and dirty editor will probably put me over my time
budet for this export/edit/import cycle.
Thanks.
-tomas
On Fri, 09 Sep 2005 18:45:46 GMT, vtadas@online.microsoft.com
("Vinayak Tadas[MSFT]") wrote:
>You can do an incremental update
>The CatalogManager object has a method named ImportXml which contains a
>parameter fUpdateOnly.
>Setting this to true will update exieting items in the catalog
>http://msdn.microsoft.com/library/d...n-us/comsrv2k/h
t
>m/cs_rp_catalogmanager_zbhs_b.asp
>
> Thanks
> Vinayak Tadas
> Microsoft
> http://blogs.msdn.com/vinayakt
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use. © 2002 Microsoft Corporation. All
rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> Get Secure! For more info visit http://www.microsoft.com/security.
Please
> reply to the newsgroups only
>
>
>--------------------
>From: Tomas Vera <taveraNOSPAM@sbcglobalREMOVE.net>
>Newsgroups: microsoft.public.commerceserver.general
>Subject: Catalog Export/Import
>Message-ID: <47g3i15q9n3jlrc4r5qrastnue11rsib4o@4ax.com>
>X-Newsreader: Forte Free Agent 2.0/32.652
>MIME-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>Lines: 25
>NNTP-Posting-Host: 12.44.161.140
>X-Complaints-To: abuse@prodigy.net
>X-Trace: newssvr21.news.prodigy.com 1126285810 ST000 12.44.161.140 (Fri,
09
>Sep 2005 13:10:10 EDT)
>NNTP-Posting-Date: Fri, 09 Sep 2005 13:10:10 EDT
>Organization: SBC http://yahoo.sbc.com
>X-UserInfo1:
>SCSYQN_@FS@[SVP[KROFOFXBWR\HPCTL@XT^OBPLAH[\RWICYFWUQBKZQLYJX\_ITFD_KFVLUN[
D
>OM_A_NSYNWPFWNS[XV\I]PZ@BQ& #91;@CDQDPCL^FKCBIPC@KLGEZEFNMDYMKHRL_YY
YGDSSODXYN@[
\
>BK& #91;LVTWI@AXGQCOA_SAH@TPD^\AL\RLGRFWEARB
M
>Date: Fri, 09 Sep 2005 17:10:10 GMT
>Path:
>TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!n
e
>wsfeed1.ip.tiscali.net!news.glorb.com!newscon02.news.prodigy.com!prodigy.ne
t
>!newsmst01b.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssv
r
>21.news.prodigy.com.POSTED!2080ae30!not-for-mail
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3400
>X-Tomcat-NG: microsoft.public.commerceserver.general
>
>Hello All,
>I'm working on a CS project for a client.
>
>We build the original catalog from a XLS file that contained their
>product IDs, descriptions, prices, etc.
>
>But now they need to do a bulk update/modification.
>
>I know that I can do an XML export from the BisDesk for them to review
>the catalog info.
>
>Assuming that they're able to make the mods that they need.
>
>Can I re-import this catalog to update the existing items?
>
>Or, will the imported items be treated as "new" items in the catalog?
>
>Is there a better strategy for doing the export/update/import of the
>existing catalog?
>
>Any help is appreciated!
>
>-tomas
>
/*-------------------------------
* Tomas Vera
* tomas (at) sbcglobal (dot) net
*-------------------------------
*/
| |
| Jeff Lynch 2005-09-12, 8:49 pm |
| There are some very good tools for CS2002 at
http://www.gotdotnet.com/Workspaces...a0-b7f284a8c113
that may help you with this. In the past I've used a simple BizTalk map to
transform from an Excel XML schema into the CS2002 catalog schema also.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
""Vinayak Tadas[MSFT]"" <vtadas@online.microsoft.com> wrote in message
news:X2IiMK$tFHA.768@TK2MSFTNGXA01.phx.gbl...
>I am not sure if this can be developed in a couple of hours.
> Instead of exporting the file cant you do this
> 1. Perform a search on the catalog to get the records you want to edit
> 2. Bind the recordset to a datagrid
> 3. Use the catalog APIs to save the changes made by the user back to the
> catalog database.
>
>
>
> Thanks
> Vinayak Tadas
> Microsoft
> http://blogs.msdn.com/vinayakt
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> You assume all risk for your use. © 2002 Microsoft Corporation. All
> rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> Get Secure! For more info visit http://www.microsoft.com/security.
> Please
> reply to the newsgroups only
>
>
> --------------------
> From: Tomas Vera <tavera@NO_SPAM_sbcglobal.net>
> Newsgroups: microsoft.public.commerceserver.general
> Subject: Re: Catalog Export/Import
> Message-ID: <co2ai196av4bi6qkslbbsuebl6p7ojlj3v@4ax.com>
> References: <47g3i15q9n3jlrc4r5qrastnue11rsib4o@4ax.com>
> <Jff#16WtFHA.464@TK2MSFTNGXA01.phx.gbl>
> X-Newsreader: Forte Free Agent 2.0/32.652
> MIME-Version: 1.0
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 8bit
> Lines: 104
> NNTP-Posting-Host: 216.52.212.170
> X-Complaints-To: abuse@prodigy.net
> X-Trace: newssvr12.news.prodigy.com 1126501478 ST000 216.52.212.170 (Mon,
> 12 Sep 2005 01:04:38 EDT)
> NNTP-Posting-Date: Mon, 12 Sep 2005 01:04:38 EDT
> Organization: SBC http://yahoo.sbc.com
> X-UserInfo1:
> TSU[@SVGTRSYB_LYN& #91;O@_WH@YR_B@EXLLBWLOOAFEQR@ETUCCNSKQF
CY@TXDX_WHSVB]ZEJLSNY\
> ^J[CUVSA_QLFC^RQHUPH[P& #91;NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^
NXA\EVHSP[D_C^B_^
> JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM
> Date: Mon, 12 Sep 2005 05:04:38 GMT
> Path:
> TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
> ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
> ews.com!newscon06.news.prodigy.com!prodigy.net!newsmst01b.news.prodigy.com!p
> rodigy.com!postmaster.news.prodigy.com!newssvr12.news.prodigy.com.POSTED!208
> 0ae30!not-for-mail
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3404
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Vinayak,
> Thanks for the information.
> I've used the CatalogManager to export my catalog to an XML file.
> But this file is not readable by Excel (probably since it is not in
> the XML Spreadsheet format (?)).
>
> I also tried linking to the file using MS Access, but it seems that I
> can only import th file into MS Access. But the data is not imported
> properly by MS Access. Most of the information is blank/null.
>
> Can you recommed an application that will allow for editing/saving of
> changes to the XML file generated by the catalog manager?
>
> I only have a couple of hours in the budget for getting this done and
> creating a quick and dirty editor will probably put me over my time
> budet for this export/edit/import cycle.
>
> Thanks.
> -tomas
>
>
> On Fri, 09 Sep 2005 18:45:46 GMT, vtadas@online.microsoft.com
> ("Vinayak Tadas[MSFT]") wrote:
>
> t
> rights.
> rights
> Please
> 09
> D
> \
> e
> t
> r
>
> /*-------------------------------
> * Tomas Vera
> * tomas (at) sbcglobal (dot) net
> *-------------------------------
> */
>
|
|
|
|
|