Importing XSD

[Former Member]

Hi,

I am developing an IDOC to File scenario. I have been provided with the following XML file format for the target. How do I proceed ? Should I import XML or XSD ? If XSD, then how can I generate one, which is acceptable.

XML File format:

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

<nsDataExport><columns>

<column name="Purchase Order No" id="col0" type="System.String" />

<column name="Purchase Unit Price (Base Charge)" id="col1" type="System.Decimal" />

<column name="Purchase Delivery Date" id="col2" type="System.DateTime" />

<column name="Purchase Company Code No" id="col3" type="System.String" />

<column name="Purchase Cost Center Code" id="col4" type="System.String" />

<column name="Purchase Capital Acct No" id="col5" type="System.String" />

<column name="Purchase Vendor Company Supplier Code" id="col6" type="System.String" />

<column name="Location Code" id="col7" type="System.String" />

<column name="Room/Cubicle" id="col8" type="System.String" />

<column name="Floor" id="col9" type="System.String" />

<column name="Depreciation Begin Date" id="col10" type="System.DateTime" />

<column name="Depreciation End Date" id="col11" type="System.DateTime" />

<column name="Depreciation Useful Life (Duration)" id="col12" type="System.String" />

<column name="Depreciation Freq" id="col13" type="System.String" />

<column name="Depreciation Fixed Asset Master Record No" id="col14" type="System.String" />

<column name="Asset record Source (Imported From)" id="col15" type="System.String" />

<column name="Asset Record Source No" id="col16" type="System.String" />

<column name="Asset Type" id="col17" type="System.String" />

<column name="Model Version" id="col18" type="System.String" />

<column name="Fixed Asset No. " id="col19" type="System.String" />

<column name="Asset Description" id="col20" type="System.String" />

<column name="User Name (First)" id="col21" type="System.String" />

<column name="User Name (Last)" id="col22" type="System.String" />

<column name="Email" id="col23" type="System.String" />

<column name="Control Station Code Details" id="col24" type="System.String" />

<column name="Lessor Vendor Details" id="col25" type="System.String" />

<column name="Maint Depot Loc Code Details" id="col26" type="System.String" />

<column name="User details (People Soft ID)" id="col27" type="System.String" />

<column name="AirTime Vendor Details" id="col28" type="System.String" />

<column name="Supplying Vendor Details" id="col29" type="System.String" />

<column name="Maintenance Vendor Details" id="col30" type="System.String" />

<column name="Prior Location Code Details" id="col31" type="System.String" />

<column name="Installed Loc Code Details" id="col32" type="System.String" />

<column name="Chgbk Assigned Loc Code Details" id="col33" type="System.String" />

<column name="Warranty Vendor Details" id="col34" type="System.String" />

<column name="For-Use-At Loc Code Details" id="col35" type="System.String" />

<column name="Disposal Vendor Details" id="col36" type="System.String" />

<column name="Manufacturing Vendor Details" id="col37" type="System.String" />

</columns>

<exportExecution date="9/7/2007 7:16:19 PM" resultsSetId="d1deee3b-1010-4455-b8f1-53d9edb5a383">

<dataSource name="SAP_testing" guid="90fe1afa-54fe-4c1e-90c5-0cc57f6a5eb0" />

<rows>

<row rowNumber="0">

<column ref="col0">UNKNOWN</column>

<column ref="col7">HOU</column>

<column ref="col15">NotificationServersSS20060222</column>

<column ref="col16">2006022201674</column>

<column ref="col17">DESKTOP</column>

<column ref="col18">UNKNOWN</column>

<column ref="col19">38375435</column>

<column ref="col20">UNKNOWN</column>

<column ref="col22">Unknown</column>

<column ref="col23">Woody</column>

</row>

<row rowNumber="1">

<column ref="col1">0</column>

<column ref="col4">297</column>

<column ref="col5">1674</column>

<column ref="col6">XEROX</column>

<column ref="col7">ATW</column>

<column ref="col12">60</column>

<column ref="col13">MO</column>

<column ref="col14">PENDING</column>

<column ref="col15">InfoMan</column>

<column ref="col16">4940414</column>

<column ref="col17">PRINTER</column>

<column ref="col18">DC440</column>

<column ref="col20">XEROX DOCUMENT CENTRE MULTI FUNCTION DEVICE</column>

</row>

<row rowNumber="2">

<column ref="col7">UNKN</column>

<column ref="col8">Unknown</column>

<column ref="col9">Unk</column>

<column ref="col15">DavidCenter Sheet US Computer Assets</column>

<column ref="col16">38658SS10170</column>

<column ref="col17">MONITOR</column>

<column ref="col18">1702</column>

<column ref="col19">36590319</column>

<column ref="col21">Unknown</column>

<column ref="col22">Unknown</column>

</row>

<row rowNumber="3">

<column ref="col0">PB74251</column>

<column ref="col1">2357.1700</column>

<column ref="col4">297</column>

<column ref="col5">1685</column>

<column ref="col6">ENPOINTE</column>

<column ref="col7">HVS</column>

<column ref="col8">DMD01</column>

<column ref="col12">36</column>

<column ref="col13">MO</column>

<column ref="col14">PENDING</column>

<column ref="col15">InfoMan</column>

<column ref="col16">3825727</column>

<column ref="col17">PC</column>

<column ref="col18">6563/85U</column>

<column ref="col19">36579033</column>

<column ref="col20">IBM P3/600 64MB 10.1GB CD-ROM</column>

<column ref="col23">HVS</column>

</row>

<row rowNumber="4">

<column ref="col0">unknown</column>

<column ref="col3">US10</column>

<column ref="col6">HP</column>

<column ref="col7">ILN</column>

<column ref="col12">48</column>

<column ref="col15">FOUNDSS</column>

<column ref="col16">2.00612E+12</column>

<column ref="col17">PRINTER</column>

<column ref="col18">HPLSR1320@</column>

<column ref="col20">HP 1320 LASER PRINTER</column>

<column ref="col21">CustPersonName</column>

<column ref="col22">CustPersonName</column>

</row>

<row rowNumber="5">

<column ref="col7">ILN</column>

<column ref="col15">CDRSS20060808</column>

<column ref="col16">200608080214</column>

<column ref="col17">PC</column>

<column ref="col18">Unknown</column>

<column ref="col19">1040882</column>

</row>

</rows>

</exportExecution>

</nsDataExport>

Thanks,

Sachin.

[former_member214364 · Accepted solution]

Hi Sachin,

You have to import XSD as External definition .The file format is neither XML nor XSD, but you can create XSD from this.

Thanks,

Jag

[Former Member]

Hi,

I need to import the file into Altiris Asset Management system. It only accepts the file in the specified format i.e., the column definitions should be present in the top of the file, else the export fails. Regarding the spaces in the tags, that I can take care of, and remove them.

Thanks,

Sachin.

[Former Member]

Hi Sachin,

Check out this thread..

Michals suggestion sounds good...

Nilesh

[Former Member]

hey

as pointed out by Raj,there are some tags in your structure has tags which are not acceptable in XI.if u really want to owkr with xsd you need to trim off the XSD off these unacceptable tags and then use it or else you can simply create a Data type.

i would prefer creating my own Data type and not importing the XSD(since its not completely valid)

Thanx

Aamir

[justin_santhanam]

Sachin,

You can save it as .xsd and import as External Defintion in XI. While saving the external definition make sure that choose the type as .xsd .

One more thing I seen ur .xsd I think u can't import the xsd which u pasted here into XI. bcoz the file contains the column name with spaces in it also / like Room<b>/</b>Cubicle

User Name <b>(</b>Last<b>)</b> etc...these names are not valid in XI.

Any how just give a try....

raj.