Input in the form of an xml

[Former Member]

Hi,

I am getting input in the form of an XML file mentioned below.How can I define a DTD/ do i need to make any change for the xml fiel to make it available for XI.

I need to map the input message to a target message.

<b>Points will be rewarded for the use full answer</b>

<b>XML File:</b>

<?xml version="1.0" encoding="UTF-8" ?>

<?pdx_version "1.0"?>

<?generated_by Solutions/Solutions/ver 1.0/1?>

<!DOCTYPE ProductDataeXchangePackage (View Source for full doctype...)>

- <ProductDataeXchangePackage thisDocumentIdentifier="_2749275"

thisDocumentGenerationDateTime="2007-06-22T16:20:05-08:00"

thisDocumentModificationDateTime="2007-06-22T16:20:05-08:00"

originatedByContactName="ERP Exchange Production"

packageType="Solutions ProductDataeXchangePackage"

dataSource="Solutions" thisDocumentCopyright="Solutions">

- <Items>

- <Item itemIdentifier="105-0033-1003" itemUniqueIdentifier="IVI96393567"

globalLifeCyclePhaseCode="Production" globalProductTypeCode="Part"

revisionIdentifier="1" proprietaryProductFamily=""

category="Part" globalProductUnitOfMeasureCode="each"

revisionReleasedDate="2007-06-21T18:15:52-08:00" ownerName="Larry Reeves"

isTopLevel="Yes" description="Resistor, MF, 0603, 100K 1%, 1/10 W">

- <AdditionalAttributes groupLabel="Version Information">

<AdditionalAttribute name="Version Notes"

value="Rework Supermicro X6DBE motherboard to resolve overheating of MOSFET

DRIVER IC which causes unexpeceted reboot (no cores or logs) in the field.

Reference Bugs 11116, 12916, 12435.Cut in the rework on all incoming returns,

chassis and full systems. All new builds and any refurb WIP that has not gone

through BI should be processed for the rework, especially 460s and 560s."

dataType="String" />

<AdditionalAttribute name="Change Number" value="ECO-000331" dataType="String" />

<AdditionalAttribute name="Version Shared" value="No" dataType="String" />

<AdditionalAttribute name="Effective Version Shared" value="No" dataType="String" />

<AdditionalAttribute name="Material Effectivity Date" value="2007-06-21T18:15:52-08:00" dataType="String" />

</AdditionalAttributes>

- <AdditionalAttributes groupLabel="Category Information">

<AdditionalAttribute name="Category Name" value="Part" dataType="String" />

<AdditionalAttribute name="Category Path" value="Part" dataType="String" />

</AdditionalAttributes>

- <AdditionalAttributes groupLabel="Arena Solutions Custom Attributes">

<AdditionalAttribute name="Standard Cost" value="" dimension="$" dataType="Decimal" />

<AdditionalAttribute name="Target Cost" value="" dimension="$" dataType="Decimal" />

<AdditionalAttribute name="Target Price" value="" dimension="$" dataType="Decimal" />

<AdditionalAttribute name="Active Cost #1" value="" dimension="$" dataType="Decimal" description="quoted" />

<AdditionalAttribute name="Active Cost #2" value="" dimension="$" dataType="Decimal" description="quoted" />

<AdditionalAttribute name="Active Cost Line #1" value="" dataType="String" />

<AdditionalAttribute name="Active Cost Line #2" value="" dataType="String" />

<AdditionalAttribute name="Arena Solutions Description" value="Resistor, Metal Film, SMT0603, 100K 1%, 1/10 W"

dataType="String" />

<AdditionalAttribute name="Expandable Part Type" value="" dataType="String" />

</AdditionalAttributes>

- <ApprovedManufacturerList>

- <ApprovedManufacturerListItem manufacturerPartIdentifier="541-100KHCT-ND"

manufacturerPartUniqueIdentifier="IMI96393567-7304938" manufacturerContactUniqueIdentifier="ECI142354" globalManufacturerPartStatusCode="Approved" description="Vishay/Dale CRCW0603100KFKEA" manufacturedBy="Digikey">

- <AdditionalAttributes groupLabel="Supplier Item Type">

<AdditionalAttribute name="Manufacturer Item" value="No" dataType="Boolean" />

<AdditionalAttribute name="Vendor Item" value="Yes" dataType="Boolean" />

</AdditionalAttributes>

</ApprovedManufacturerListItem>

- <ApprovedManufacturerListItem manufacturerPartIdentifier="RC0603FR-07100KL"

manufacturerPartUniqueIdentifier="IMI96393567-7304939" manufacturerContactUniqueIdentifier="ECI142384" globalManufacturerPartStatusCode="Approved" description="" manufacturedBy="Yaego America">

- <AdditionalAttributes groupLabel="Supplier Item Type">

<AdditionalAttribute name="Manufacturer Item" value="Yes" dataType="Boolean" />

<AdditionalAttribute name="Vendor Item" value="No" dataType="Boolean" />

</AdditionalAttributes>

</ApprovedManufacturerListItem>

</ApprovedManufacturerList>

</Item>

</Items>

- <ManufacturerParts>

- <ManufacturerPart manufacturerPartIdentifier="541-100KHCT-ND"

manufacturerPartUniqueIdentifier="IMI96393567-7304938"

manufacturerName="Digikey" manufacturerContactUniqueIdentifier="ECI142354"

referenceNotes="RES 100K OHM 1/10W 1% 0603 SMDVishay/Dale"

manufacturerPartType="Part" description="Vishay/Dale CRCW0603100KFKEA" isTopLevel="No">

- <ApprovedSupplierList>

<ApprovedSupplierListItem supplierPartIdentifier="541-100KHCT-ND" supplierPartUniqueIdentifier="ISI7304938" supplierPartContactUniqueIdentifier="ECI142354" globalSupplierPartStatusCode="Approved"

comments="Or Equivalent" suppliedBy="Digikey" />

</ApprovedSupplierList>

</ManufacturerPart>

- <ManufacturerPart manufacturerPartIdentifier="RC0603FR-07100KL"

manufacturerPartUniqueIdentifier="IMI96393567-7304939"

manufacturerName="Yaego America" manufacturerContactUniqueIdentifier="ECI142384"

referenceNotes="RES 100K OHM 1/10W 1% 0603 SMD Metal Film"

manufacturerPartType="Part" description="" isTopLevel="No">

- <ApprovedSupplierList>

<ApprovedSupplierListItem supplierPartIdentifier="311-100KHRCT-ND"

supplierPartUniqueIdentifier="ISI7304937" supplierPartContactUniqueIdentifier="ECI142354"

globalSupplierPartStatusCode="Approved" comments="Or Equivalent" suppliedBy="Digikey" />

</ApprovedSupplierList>

</ManufacturerPart>

</ManufacturerParts>

- <SupplierParts>

<SupplierPart supplierPartIdentifier="541-100KHCT-ND"

supplierPartUniqueIdentifier="ISI7304938" supplierName="Digikey"

supplierContactUniqueIdentifier="ECI142354"

referenceNotes="RES 100K OHM 1/10W 1% 0603 SMDVishay/Dale" supplierPartType="Part"

description="Vishay/Dale CRCW0603100KFKEA" isTopLevel="No" />

<SupplierPart supplierPartIdentifier="311-100KHRCT-ND"

supplierPartUniqueIdentifier="ISI7304937" supplierName="Digikey"

supplierContactUniqueIdentifier="ECI142354"

referenceNotes="RES 100K OHM 1/10W 1% 0603 SMD" supplierPartType="Part"

description="RES 100K OHM 1/10W 1% 0603 SMD" isTopLevel="No" />

</SupplierParts>

- <Contacts>

<Contact contactIdentifier="DIGI001" contactUniqueIdentifier="ECI142354"

contactName="Digikey" addressLine1="" addressLine2="" cityName="" regionName="" globalCountryCode=""

nationalPostalCode="" telephoneNumber="" facsimileNumber="" department="" businessName="Digikey"

emailAddress="" universalResourceIdentifier="" contactStatus="Unrated" isTopLevel="No" />

<Contact contactIdentifier="" contactUniqueIdentifier="ECI142384" contactName="Yaego America"

addressLine1="" addressLine2="" cityName="" regionName="" globalCountryCode=""

nationalPostalCode="" telephoneNumber="" facsimileNumber="" department="" businessName="Yaego America"

emailAddress="" universalResourceIdentifier="" contactStatus="Unrated" isTopLevel="No" />

</Contacts>

</ProductDataeXchangePackage>

Thanks & Regards,

kiran kumar

[manish_bhalla2 · Accepted solution]

The easiest way is ...

1. Use a tool like XMLSpy or StylusStudio to generate an xsd from the xml.

2. Upload the xsd into XI as an External Definition

Cheers

Manish

Message was edited by:

Manish Bhalla

[Former Member · Accepted solution]

>> 2. Upload the xsd into XI as an imported archive

shoudnt it be External definition?

[manish_bhalla2 · Accepted solution]

yeah, you're right. Sorry, mind is wandering a bit today !

Cheers

M

[manish_bhalla2]

Also, if you are using the PDX standard, there are probably pre-defined XSD (or DTD) already available.

Refer:

http://www.pdxstandard.org/

http://xml.coverpages.org/pdx.html

http://webstds.ipc.org/2571/2571pub.pdf

http://xml.coverpages.org/IPC-2571-DTD-200111.txt

http://www.inemi.org/cms/

Cheers

Manish

[Former Member]

Hi ,

Open this message in Altova XML SPY and then go to option DTD/Schema and the select Generate DTD/Schema . It will generate required XSD file for you and you can import that file in your IR .

I guess it might give you error at line 4

<!DOCTYPE ProductDataeXchangePackage (View Source for full doctype...)>

so change it to

<!DOCTYPE ProductDataeXchangePackage>

and it will work .

Thanks ,

Suvarna