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

Resolved Import(ImportString) XML into DW PB2019

  1. How-to
0
Votes
Undo
  1. Marina Grafit
    Marina Grafit
  2. PowerBuilder
  3. Wednesday, 3 February 2021 16:41 PM UTC

Hello,

We want to upgrade from PB12.5 to PB2019.

We are facing a problem with PB2019 + XML import(ImportString) in to DW object. Is there some different way(PB12.5 --> PB2019) to use this option?

The script works fine in PB12.5, but in PB2019 we get ImportString returns -11 .

 

Thanks in advance

 

 

 

.net dll importer, Object instance does not exist...
connect to database from Powerclient from outside
Responses (9)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 3 February 2021 17:35 PM UTC
  2. PowerBuilder
  3. # 1

Greetings, Marina -

The -11 return code can be caused by XML that is not well formed or by XML parser libraries not found.

As a test, are you able to use ImportString in PB 2019 to import any XML content into any DataWindow, even a very simple one? If not, that would indicate the problem may be caused by missing XML parser libraries.

You may wish to zip a sample of the XML you are trying to import along with the exported source of the DataWindow Object (.srd) and post the zip file in a new reply in this thread to see if anyone else can successfully import the XML information.

Regards, John

Comment
Marina Grafit
  1. Marina Grafit
  2. Monday, 15 February 2021 13:13 PM UTC
I changed the DS to DW and now I get an error message "Error initializing XML Service. Please check whether XML parser libraries can be located in the path."

What are the XML parser libraries?
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 3 February 2021 17:52 PM UTC
  2. PowerBuilder
  3. # 2

Hi Marina;

  We would need to see your DW Object source and an example .XML file you use to import into that DWO, in order to see if we could spot something "out of kilter".  ;-)

Regards .. Chris

Comment
Marina Grafit
  1. Marina Grafit
  2. Monday, 15 February 2021 13:29 PM UTC
I changed the DS to DW and now I get an error message "Error initializing XML Service. Please check whether XML parser libraries can be located in the path."

What are the XML parser libraries?
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 4 February 2021 04:24 AM UTC
  2. PowerBuilder
  3. # 3

Maybe you can get some information by activating the "trace"?

dw1.Modify("DataWindow.Import.XML.Trace = 'yes' ")
dw1.Modify("DataWindow.Import.XML.TraceFile = 'C:\temp\xmltrace.log' ")

Also: 
Does this happen when running the executable?
In that case it could be a missing runtime library?
Comment
There are no comments made yet.
Marina Grafit
Marina Grafit Accepted Answer Pending Moderation
  1. Wednesday, 10 February 2021 04:53 AM UTC
  2. PowerBuilder
  3. # 4

Hi All,

srd datastore lds_temp:

 

 

luo_data.is_data : 

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

<TI ID="1">
<TeudatIkuv>7777777</TeudatIkuv>
<HAWB>1Z1111111111111111</HAWB>
<ChWeight>85.50</ChWeight>
<StorageDays> 4</StorageDays>
<EntryDate>20210206</EntryDate>
<ExitDate>00000000</ExitDate>
<Charges>
<Line LineNo="1" TI_ID="1">
<ChargeCode>1</ChargeCode>
<ChargeName>ניטול</ChargeName>
<Currency>ILS</Currency>
<Amount>184.04</Amount>
</Line>
<Line LineNo="2" TI_ID="1">
<ChargeCode>2</ChargeCode>
<ChargeName>אחסנה</ChargeName>
<Currency>ILS</Currency>
<Amount>20.00</Amount>
</Line>
</Charges>
</TI>

</TerminalCharges>

 

 

ll_ret = lds_temp.Importstring( XML!, luo_data.is_data )

In PB 12.5 - ll_ret = 2(2 rows in the xml string)

in PB 2019 - ll_ret = -11 

 

Please Help

Regards,

Marina

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 10 February 2021 23:49 PM UTC
  2. PowerBuilder
  3. # 5

Hi Marina,

I've never really used XML with datawindows / datastores, so forgive me if I'm totally wrong here, but ...

The exported datawindow source code that you pasted, does not have a correct xml section
(I'm not to sure about your XML-data either):

export.xml(usetemplate="terminalcharges" headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 template=(comment="" encoding="UTF-16LE" name="terminalcharges" xml="teudatikuvhawbchweightstoragedaysentrydateexitdatechargecodechargenamecurrencyamount"))

So for some reason it has been corrupted? Migration process? (check in the pb 12.5 version of it's already like that).

You might be able to fix it by editing the xml section left below on your datawindow and doing an 'Edit'. For example set 'Standalone' to 'yes', save and set it back to 'yes' and save. You'll get something like this, all the way at the end of the source code of the ds / dw.
(I first imported your exported ds into a library. If you then open the imported dw, you already get an error.)

....
...
export.xml(usetemplate="terminalcharges" headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0  template=(comment="" encoding="UTF-16LE" name="terminalcharges"
xml="<?xml version=~"1.0~" encoding=~"UTF-16LE~" standalone=~"no~"?><d_terminal_charges_http><d_terminal_charges_http_row __pbband=~"detail~"><teudatikuv>teudatikuv</teudatikuv><hawb>hawb</hawb><chweight>chweight</chweight><storagedays>storagedays</storagedays><entrydate>entrydate</entrydate><exitdate>exitdate</exitdate><chargecode>chargecode</chargecode><chargename>chargename</chargename><currency>currency</currency><amount>amount</amount><id>id</id></d_terminal_charges_http_row></d_terminal_charges_http>"))
import.xml(usetemplate="terminalcharges" )

 

Here's the result of doing what I just described:

release 19;
datawindow(units=0 timer_interval=0 color=1073741824 brushmode=0 transparency=0 gradient.angle=0 gradient.color=8421504 gradient.focus=0 gradient.repetition.count=0 gradient.repetition.length=100 gradient.repetition.mode=0 gradient.scale=100 gradient.spread=100 gradient.transparency=0 picture.blur=0 picture.clip.bottom=0 picture.clip.left=0 picture.clip.right=0 picture.clip.top=0 picture.mode=0 picture.scale.x=100 picture.scale.y=100 picture.transparency=0 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes print.background=no print.preview.background=no print.preview.outline=yes hidegrayline=no showbackcoloronxp=no picture.file="" grid.lines=0 )
header(height=80 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
summary(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
footer(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
detail(height=92 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
table(column=(type=number updatewhereclause=yes name=teudatikuv dbname="TeudatIkuv" )
 column=(type=char(25) updatewhereclause=yes name=hawb dbname="HAWB" )
 column=(type=number updatewhereclause=yes name=chweight dbname="ChWeight" )
 column=(type=number updatewhereclause=yes name=storagedays dbname="StorageDays" )
 column=(type=char(8) updatewhereclause=yes name=entrydate dbname="EntryDate" )
 column=(type=char(8) updatewhereclause=yes name=exitdate dbname="ExitDate" )
 column=(type=number updatewhereclause=yes name=chargecode dbname="ChargeCode" )
 column=(type=char(30) updatewhereclause=yes name=chargename dbname="ChargeName" )
 column=(type=char(3) updatewhereclause=yes name=currency dbname="Currency" )
 column=(type=number updatewhereclause=yes name=amount dbname="Amount" )
 column=(type=number updatewhereclause=yes name=id dbname="ID" )
 )
text(band=header alignment="2" text="Teudatikuv" border="0" color="33554432" x="9" y="8" height="64" width="279" html.valueishtml="0"  name=teudatikuv_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Hawb" border="0" color="33554432" x="297" y="8" height="64" width="686" html.valueishtml="0"  name=hawb_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Chweight" border="0" color="33554432" x="992" y="8" height="64" width="261" html.valueishtml="0"  name=chweight_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Storagedays" border="0" color="33554432" x="1262" y="8" height="64" width="343" html.valueishtml="0"  name=storagedays_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Entrydate" border="0" color="33554432" x="1614" y="8" height="64" width="571" html.valueishtml="0"  name=entrydate_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Exitdate" border="0" color="33554432" x="2194" y="8" height="64" width="448" html.valueishtml="0"  name=exitdate_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Chargecode" border="0" color="33554432" x="2651" y="8" height="64" width="325" html.valueishtml="0"  name=chargecode_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Chargename" border="0" color="33554432" x="2985" y="8" height="64" width="823" html.valueishtml="0"  name=chargename_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Currency" border="0" color="33554432" x="3817" y="8" height="64" width="238" html.valueishtml="0"  name=currency_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Amount" border="0" color="33554432" x="4064" y="8" height="64" width="219" html.valueishtml="0"  name=amount_t visible="1"  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Id" enabled="0" border="0" color="0" x="4293" y="4" height="64" width="206" html.valueishtml="0"  name=id_t visible="1"  font.face="Tahoma" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
column(band=detail id=1 alignment="1" tabsequence=10 border="0" color="33554432" x="9" y="8" height="76" width="279" format="[general]" html.valueishtml="0"  name=teudatikuv visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=2 alignment="0" tabsequence=20 border="0" color="33554432" x="297" y="8" height="76" width="686" format="[general]" html.valueishtml="0"  name=hawb visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=3 alignment="1" tabsequence=30 border="0" color="33554432" x="992" y="8" height="76" width="261" format="[general]" html.valueishtml="0"  name=chweight visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=4 alignment="1" tabsequence=40 border="0" color="33554432" x="1262" y="8" height="76" width="343" format="[general]" html.valueishtml="0"  name=storagedays visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=5 alignment="0" tabsequence=50 border="0" color="33554432" x="1614" y="8" height="76" width="571" format="[general]" html.valueishtml="0"  name=entrydate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=6 alignment="0" tabsequence=60 border="0" color="33554432" x="2194" y="8" height="76" width="448" format="[general]" html.valueishtml="0"  name=exitdate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=7 alignment="1" tabsequence=70 border="0" color="33554432" x="2651" y="8" height="76" width="325" format="[general]" html.valueishtml="0"  name=chargecode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=8 alignment="0" tabsequence=80 border="0" color="33554432" x="2985" y="8" height="76" width="823" format="[general]" html.valueishtml="0"  name=chargename visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=9 alignment="0" tabsequence=90 border="0" color="33554432" x="3817" y="8" height="76" width="238" format="[general]" html.valueishtml="0"  name=currency visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=10 alignment="1" tabsequence=100 border="0" color="33554432" x="4064" y="8" height="76" width="219" format="[general]" html.valueishtml="0"  name=amount visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial (Hebrew)" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="177" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=11 alignment="0" tabsequence=110 border="0" color="0" x="4293" y="12" height="64" width="206" format="[general]" html.valueishtml="0"  name=id visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Tahoma" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" pagingmethod=0 generatedddwframes="1" )
xhtmlgen() cssgen(sessionspecific="0" )
xmlgen(inline="0" )
xsltgen()
jsgen()
export.xml(usetemplate="terminalcharges" headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0  template=(comment="" encoding="UTF-16LE" name="terminalcharges" xml="<?xml version=~"1.0~" encoding=~"UTF-16LE~" standalone=~"no~"?><d_terminal_charges_http><d_terminal_charges_http_row __pbband=~"detail~"><teudatikuv>teudatikuv</teudatikuv><hawb>hawb</hawb><chweight>chweight</chweight><storagedays>storagedays</storagedays><entrydate>entrydate</entrydate><exitdate>exitdate</exitdate><chargecode>chargecode</chargecode><chargename>chargename</chargename><currency>currency</currency><amount>amount</amount><id>id</id></d_terminal_charges_http_row></d_terminal_charges_http>"))
import.xml(usetemplate="terminalcharges" )
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" nativepdf.customsize=0 nativepdf.customorientation=0 nativepdf.pdfstandard=0 nativepdf.useprintspec=no )
export.xhtml()

 

regards

Comment
There are no comments made yet.
Marina Grafit
Marina Grafit Accepted Answer Pending Moderation
  1. Sunday, 14 February 2021 10:32 AM UTC
  2. PowerBuilder
  3. # 6

Thank you for your response.

 

I replaced the DS with a new one that I created in PB2019:

 

 

 

I wrote a simple code :

datastore lds_temp
lds_temp = CREATE datastore
lds_temp.dataobject = "d_terminal_charges_http"

ls_temp = "<?xml version=" + '"'+"1.0" +'"'+ " encoding=" + '"' + "UTF-8" + '"' + " standalone= " + '"' + "no" + '"' + " ?>" +&
"<TerminalCharges>" +&
"<TI ID= " + '"' + "1" + '"' + ">" +&
"<TeudatIkuv>7777777</TeudatIkuv>" +&
"<HAWB>1Z1111111111111111</HAWB>" +&
"<ChWeight>2.30</ChWeight>" +&
"<StorageDays> 14</StorageDays>" +&
"<EntryDate>20201222</EntryDate>" +&
"<ExitDate>20210104</ExitDate>" +&
"<Charges>" +&
"<Line LineNo=" + '"' + "1" + '"' + " TI_ID=" + '"' + "1" + '"' + ">" +&
"<ChargeCode>1</ChargeCode>" +&
"<ChargeName>ניטול</ChargeName>" +&
"<Currency>ILS</Currency>" +&
"<Amount>6.42</Amount>" +&
"</Line>" +&
"<Line LineNo=" + '"' + "2" + '"' + " TI_ID="+'"' + "1"+'"' + ">" +&
"<ChargeCode>2</ChargeCode>" +&
"<ChargeName>אחסנה</ChargeName>" +&
"<Currency>ILS</Currency>" +&
"<Amount>88.00</Amount>" +&
"</Line>" +&
"</Charges>" +&
"</TI>" +&
"</TerminalCharges>"

sle_1.text = ls_temp

ll_ret = lds_temp.Importstring( XML!, ls_temp )
messagebox("ll_ret1 - ls_temp",string(ll_ret))

ll_ret = lds_temp.Importstring( XML!, sle_1.text )
messagebox("ll_ret2 - sle_1.text",string(ll_ret))


DESTROY lds_temp

 

The good news that it works when I ran from PB --> ll_ret = 2

The bad news that after I deploy a project and run the exe, ll_ret = -11 still  :(

Please HELP

Regards Marina

Comment
Load more comments
Marina Grafit
  1. Marina Grafit
  2. Monday, 15 February 2021 13:29 PM UTC
I changed the DS to DW and now I get an error message "Error initializing XML Service. Please check whether XML parser libraries can be located in the path."

What are the XML parser libraries?
  1. Helpful
Andreas Mykonios
  1. Andreas Mykonios
  2. Monday, 15 February 2021 18:36 PM UTC
I guess it's the following:

PBXerces190.dll (or PBXerces.dll for pb 2019 r3), xerces-c_2_8.dll, xerces-depdom_2_8.dll ->XML Web DataWindow support and XML support for DataWindows and DataStores.

Can you find them in your machine? PB 12.5 had a different version of those libraries: PBXerces125.dll, xerces-c_2_6.dll, xerces–depdom_2_6.dll.

  1. Helpful
Marina Grafit
  1. Marina Grafit
  2. Tuesday, 16 February 2021 05:37 AM UTC
I have them all,



I also copied ones more ALL DLL files from 12.5 run time library to 2019 run time library, still the same error :(
  1. Helpful
There are no comments made yet.
Marina Grafit
Marina Grafit Accepted Answer Pending Moderation
  1. Monday, 15 February 2021 05:05 AM UTC
  2. PowerBuilder
  3. # 7

What do you mean? 

First I deploy the hole project and checked my problem with exe, but then I started to change little by little my code so,

I build 2 specific PBDs and copied them to the run time library.

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 15 February 2021 17:19 PM UTC
  2. PowerBuilder
  3. # 8

Hi Marina,

The "xml parser libraries" are probably part of some runtime DLLs. So my guess is that you first have to make sure you have the correct powerbuilder runtime installed (correctly). I recommend using the 'powerbuilder runtime packager' and then install the runtime on the pc where you are getting the error.

Also check if there's not some older runtime in the PATH environment variable of windows.

regards.

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 16 February 2021 08:03 AM UTC
Copying 12.5 dlls into the runtime folder of 2019 won't help if your executable has been made with 2019. My advice is to cleanup that folder and uninstall any installed runtimes. Then re-install the correct runtime using the pb runtime packager. Also make sure that you use 32 or 64 bit installer package, depending on how your exectuble has been made: 32 or 64 bit.

regards
  1. Helpful
Marina Grafit
  1. Marina Grafit
  2. Tuesday, 16 February 2021 09:51 AM UTC
We did this again:

Select Programs>Sybase>PowerBuilder 19>PowerBuilder Runtime Packager from the Windows Start menu or launch the pbpack190 executable file in your Shared\PowerBuilder directory.

And copied the Dlls in the run time library



NOW IT WORKS FINE



Thank you all for your help
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 16 February 2021 10:20 AM UTC
yw,

Glad it works!
  1. Helpful
There are no comments made yet.
Marina Grafit
Marina Grafit Accepted Answer Pending Moderation
  1. Tuesday, 16 February 2021 09:52 AM UTC
  2. PowerBuilder
  3. # 9

We did this again:
Select Programs>Sybase>PowerBuilder 19>PowerBuilder Runtime Packager from the Windows Start menu or launch the pbpack190 executable file in your Shared\PowerBuilder directory.
And copied the Dlls in the run time library

NOW IT WORKS FINE

Thank you all for your help

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.