• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to export master-detail datawindow data to UBL-Invoice-2.0 template's XML file?

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

Resolved How to export master-detail datawindow data to UBL-Invoice-2.0 template's XML file?

  1. How-to
0
Votes
Undo
  1. Ong Chin Keat
    Ong Chin Keat
  2. PowerBuilder
  3. Friday, 16 February 2024 06:43 AM UTC

hi GURUs,

Would like to get your advise how PB datawindow XML template can be build according to UBL-Invoice-2.0.XSD  and ultimately the datawindow can export to XML format accordingly (see example output xml file einvoice.xml as attached). Please find attached both UBL-Invoice-2.0.XSD (template) and sample output of einvoice.xml file.

Appreciate anyone help.

regards,

Dev 

Attachments (1)
UBL2 e-Invoice.zip
References
  1. https://docs.oasis-open.org/ubl/UBL-2.1.html
  1. DataWindow
  2. XML
SaveAs XLSX DLL
PowerBuilder 2017 R3 Build 1915 end of support dat...
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 16 February 2024 18:06 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Dev;

  The DW's XML processing is restricted to a 2D model (row + column) as per it's Primary Buffer. Your XSD model is more complex. So you will need to use PB's PBDOM feature (see the PB help) for this more complex XML task. That would then involve retrieving the DWO's items one-by-one (via a GetItemXxxx command) and then populating the XML structure using PBDOM's object classes & methods that it provides.   HTH

Regards .. Chris

Comment
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.