cancel
Showing results for 
Search instead for 
Did you mean: 

XML file conversion issue

former_member253394
Participant
0 Kudos

Hi All,

I am facing one issue while converting XSD file into XML in Excel.

Below is the screen shot while i am dragging the structure of my BO into excel:

the structure of my Bo is :

BO{

alternative key element A;

element B;

node BO1

{

element C;

element D;

}

node BO2

{

element E;

element F;

}

}

Can you please let me know if i am missing anything?

Thanks,

Malkit Singh

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member253394
Participant
0 Kudos

Hi

Can you please Let me know if i am missing anything.

Thanks,

Malkit Singh

HorstSchaude
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Malkit,

As you have subnodes Excel would not be my first choice.

Did you tried it with MS VisualStudio as described in ?

Bye,

    Horst

Former Member
0 Kudos

Hello Malkit,

1. You have not enabled "mass List processing" option while creating your XML input service.

2. As Horst said, it is not very straight forward to upload records with Subnodes, you would need a helper/intermidiate BO to process such cases and it involves a bi of more coding.

Regards,
Saurabh

HorstSchaude
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Saurabh,

That's not correct.

I doubt that MS Excel is not the best tool to build up the list.

The XML upload works very well with a deep-structured XML assumed the XML is well defined.

Bye,

  Horst

chandansb
Active Contributor
0 Kudos

Hello Malkit,

Hope you are dragging into cell A2.

Regards,

Chandan

former_member253394
Participant
0 Kudos

Hello Chandan,

Yes I am dragging the structure into A2 only.

Thanks,

Malkit Singh