Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Datawindow XML Import

  1. How-to
0
Votes
Undo
  1. Prasad Pati
    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)
XMLTest.zip
Dynamic DW, table name prefix to be removed
Datawindow tooltip expression call to function
Responses (3)
Chris Pollach @Appeon
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)
test2.zip
Comment
There are no comments made yet.
Prasad Pati
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
Chris Pollach @Appeon
  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
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.