1. Prasad Pati
  2. PowerBuilder
  3. Tuesday, 11 December 2018 18:33 PM UTC

I am trying to import XML data into a datawindow. XML has header which i don't want to import. I want to import 3 rows of data in the Item tag. I am getting does not pass the validation test. If i use Data Import template i am getting Import file failed. please let me know what i am doing wrong. I appreciate your help.

 PB version 2017R3

 

Attachments (1)
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 11 December 2018 19:16 PM UTC
  2. PowerBuilder
  3. # 1

Hi Prasad;

   Yes, you need to loose the "Header" part of the XML for the DWO to import properly (see attached).

HTH

Regards ... Chris

Attachments (1)
Comment
There are no comments made yet.
Prasad Pati Accepted Answer Pending Moderation
  1. Tuesday, 11 December 2018 19:28 PM UTC
  2. PowerBuilder
  3. # 2

Yes Chris if I remove the Header part from the XML it works, but i don't have control removing the Header part, I get the data with the Header part. I am looking if there is a way to import data even it has Header part. I think XML template should work, but i am getting Import file failed.

Thanks for quick reply.

Comment
  1. Chris Pollach @Appeon
  2. Tuesday, 11 December 2018 19:35 PM UTC
FWIW: What I would do is read & parse the Header section out of the XML file via a little PowerScript and then output a "cleaned up" no header XML file. Then import that into the DWO.
  1. Helpful
There are no comments made yet.
Prasad Pati Accepted Answer Pending Moderation
  1. Tuesday, 11 December 2018 22:56 PM UTC
  2. PowerBuilder
  3. # 3

I got it working with the Header part, will post details soon

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.