Creating Data type from excel

[former_member474221]

Hi

I have a excel file which has a column with 200 fields

I just have to create a Datatype with this 200 fields....When i tried using "insert rows" option it inserts 200 blank rows but when i copy the entire column from excel it gets copied in the single field in data type only

Do I need to manually create each field or is there a way to copy the fieldnames from excel column into data type

Hema

[ravi_reddy1]

HI hema,

i think no option to pick all the data types at a time in Pi

U can COPY  the data type from excel and paste in data type editor

Thanks & Regards,

E.Ravi chandra reddy

[sunilchandra007]

Please check .

This tool might me be helpful in your case.

Regards,

Sunil Chandra

[Former Member]

Very useful tool. It may help you Hema.

[former_member192343]

You can try this method:

create 2 columns in excel.

First columt befor your 200 fields fill with <xs:element name="

Second. after your 200 fields - "type="xs:string" />

then copy your table and paste in text editor

add before :

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

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">

    <xs:element name="root">

        <xs:complexType>

            <xs:sequence>

and add after:

               </xs:sequence>

        </xs:complexType>

    </xs:element>

</xs:schema>

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

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">

    <xs:element name="root">

        <xs:complexType>

            <xs:sequence>

                <xs:element name="qqq" type="xs:string" />

                <xs:element name="www" type="xs:string" />

                <xs:element name="eee" type="xs:string" />

                <xs:element name="aaa" type="xs:string" />

                <xs:element name="sss" type="xs:string" />

                <xs:element name="ddd" type="xs:string" />

                <xs:element name="zzz" type="xs:string" />

                <xs:element name="ttt" type="xs:string" />

                <xs:element name="yyy" type="xs:string" />

                <xs:element name="uuu" type="xs:string" />

                <xs:element name="hhh" type="xs:string" />

                <xs:element name="nnn" type="xs:string" />

                </xs:sequence>

        </xs:complexType>

    </xs:element>

</xs:schema>

Regards,

Mikhail

[Former Member]

Hi Mikhail

When we copy the data from excel to text editor , the data will contain two additional tab in between the field names.

If we import it with tabs, then we will not able to see the structure. However if we replace the tab with blank then it will work.

Also there needs to be a space between element name and type. For example

<xs:element name="qqq" type="xs:string" />

So we have to use " type="xs:string" /> in another column. There has to be a space at before type.

[former_member192343]

Hi Indrajit

Yes, of course, tabs should be deleted. Spaces at screenshot exist, in description I missed it.

Thanks

Regards, Mikhail

[former_member192343]

HI, try to import to excel any xsd file, then you will see how Excel document should look like to be exported to XSD file and use it for import to Integration Builder.

Regards Mikhail