[opencms-dev] Automatc import of artikels in 6.2

[shishank.mathur at wipro.com]

Hi,

Here is one of the approach that you can use:

1) Export the data from legacy database in form of delilited text file.
2) Write a program that parse this text file and create an xml file for
each record based on the XML structured content XSD. If your current
application, running on top of DB is capable of it, that is the best
idea.
3) Using upload utility, load all the xml files in OpenCMS. These will
be uploaded as "plain" type.
4) Using DB export utility, export out the XML files uploaded to a zip
file (location will be in WEB-INF/packages folder).
5) Open zip file and extract out manifest file.
6) Replace all the "type=plain"  to "type=<your defined structured
type>"
7) Add the manifest file back to zip and do database import of the zip.
It will convert all the files to required Structured content.

Hope this helps.

Thanks

BR,
Shishank
http://www.pcmspace.com


-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of
Guggenberger,Wilhelm
Sent: Thursday, March 02, 2006 1:21 PM
To: opencms-dev at opencms.org
Subject: [opencms-dev] Automatc import of artikels in 6.2


Hi !

Is it possible to import struct content, e.g. articels ... from a
external database ?

I have a product catalog with prices in a external database.
I will import this data in opencms, extend this with pictures and
additional text.
Is this possible ? Can I import it and use it as new content type ? (xsd
definition)

Thanks for help
Willi

_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change
your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev


The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com