Importing XML into a datawindow

Suppose you have an xml file and you want to import that into a datawindow. 
Is there a way to create the template automatically?  I mean, is there a 
mechanism that can create the template for you, or do you have to manually 
do this?

thanks!

joe 


0
JG
4/28/2005 9:09:01 PM
sybase.powerbuilder.general 62418 articles. 19 followers. Follow

4 Replies
726 Views

Similar Articles

[PageSpeed] 21

As far as I know, manually is the only way though many have suggested this
as an improvement (the ability to create the datawindow from a dtd).  Anyone
else have thoughts on the subject?

Doug Porter
DailyAccess Corporation

"JG" <joseph.grantNOSPAM@assetpoint.com> wrote in message
news:427150e9$1@forums-2-dub...
> Suppose you have an xml file and you want to import that into a
datawindow.
> Is there a way to create the template automatically?  I mean, is there a
> mechanism that can create the template for you, or do you have to manually
> do this?
>
> thanks!
>
> joe
>
>


0
Doug
4/28/2005 9:42:36 PM
Very well then.  I thought I was just dense and missing the whole point.  It 
sure bould be nice to create what you are talking about.

if anyone else has thoughts on this, I would appreciate them.  Basically 
what I am trying to do is import an XML document into a datawindow.  The 
problem is that the data is NOT originating from the datawindow, instead it 
is originating from a webservice.

Does anyone do anything remotely like this?

Thanks!



"Doug Porter" <doug_porterATdailyaccessDOTnospamDOTcom> wrote in message 
news:427158c8$1@forums-2-dub...
> As far as I know, manually is the only way though many have suggested this
> as an improvement (the ability to create the datawindow from a dtd). 
> Anyone
> else have thoughts on the subject?
>
> Doug Porter
> DailyAccess Corporation
>


0
JG
4/28/2005 9:58:43 PM
"JG" <joseph.grantNOSPAM@assetpoint.com> wrote in message news:42715c8f$1@forums-2-dub...
> Very well then.  I thought I was just dense and missing the whole point.  It sure bould be nice to create what you are 
> talking about.
>
> if anyone else has thoughts on this, I would appreciate them.  Basically what I am trying to do is import an XML 
> document into a datawindow.  The problem is that the data is NOT originating from the datawindow, instead it is 
> originating from a webservice.
>
> Does anyone do anything remotely like this?
>
> Thanks!


It depends on how complex the XML is...   I've done it with simple row/column (flat) XML structures, and it's really 
simple.
But I developed the template, and told the senders to "send me XML that conforms to this schema/DTD".  I didn't have to 
start with an XML document and "reverse-engineer" that into a dw template...

-- 
Paul Horan[TeamSybase]


0
Paul
4/29/2005 1:37:41 PM
http://powerbuilder.codexchange.sybase.com/files/documents/67/1164/xml2dw.zip

"JG" <joseph.grantNOSPAM@assetpoint.com> wrote in message 
news:427150e9$1@forums-2-dub...
> Suppose you have an xml file and you want to import that into a 
> datawindow. Is there a way to create the template automatically?  I mean, 
> is there a mechanism that can create the template for you, or do you have 
> to manually do this?
>
> thanks!
>
> joe
> 


0
Yosi
5/1/2005 10:30:14 AM
Reply:

Similar Artilces:

superreview denied: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 217751] (Av2) <general.xml>
neil@parkwaycc.co.uk <neil@httl.net> has denied Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 217751: (Av2) <general.xml> https://bugzilla.mozilla.org/attachment.cgi?id=217751&action=edit ------- Additional Comments from neil@parkwaycc.co.uk <neil@httl.net> >+ <binding id="statusbarpanel-menu-iconic" display="xul:menu" extends="chrome://global/content/bindings/general.xml#statusbarpa...

superreview requested: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 217751] (Av2) <general.xml>
Serge GAUTHERIE <gautheri@noos.fr> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 217751: (Av2) <general.xml> https://bugzilla.mozilla.org/attachment.cgi?id=217751&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> (In reply to comment #2) > Hmm, if the diff is current (by date I would imagine so) then I do not > personally see a problem syncing this and grabbing toolkits version fr...

datawindow.import(XML!,"file.xml") syntax error
I am using Pocket PowerBuilder 1.5 build 360 from the help file I saw [ImportFile method (DataWindows)] long dwcontrol.ImportFile ( {saveastype importtype}, string filename {, long startrow {, long endrow {, long startcolumn {, long endcolumn {, long dwstartcolumn } } } } } ) This statement inserts all the data in the file D:\TMP\EMPLOYEE.CSV into dw_employee starting at the first column: dw_employee.ImportFile("D:\TMP\EMPLOYEE.CSV") This statement inserts all the data in the file D:\TMP\EMPLOYEE.XML into dw_employee starting at the first column: dw_em...

superreview granted: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 219626] (Av3-XPFE) <general.xml>++
neil@parkwaycc.co.uk <neil@httl.net> has granted Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 219626: (Av3-XPFE) <general.xml>++ https://bugzilla.mozilla.org/attachment.cgi?id=219626&action=edit ...

superreview requested: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 219626] (Av3-XPFE) <general.xml>++
Serge GAUTHERIE <gautheri@noos.fr> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 219626: (Av3-XPFE) <general.xml>++ https://bugzilla.mozilla.org/attachment.cgi?id=219626&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> Av3-XPFE-Bw, with full diff. Keeping [[ (Av3-XPFE-Bw) <general.xml>++ patch 2006-04-23 16:17 PDT 2.38 KB neil: review+ ]] ...

xml datawindow import
This is a multi-part message in MIME format. ---=_forums-1-dub4cab0dcf Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit using powerbuilder 11.5 hi, i have a external datawindow and xml template and try to import a xml file into the datawindow, but i got two records, instaead of one record. i want to see only one record, but with different address lines as addr1, addr2 etc The problem what i noticed is i have a addresline in the xml document, which is rpeating for more then one line with the same attribute. how to solve this porblem...

Datawindow XML Import
I have a datawindow and use it's importfile method to import an xml file. Unless I put the DTD in the same directory as the data file, I get a "could not open DTD" error. How can I control whether or not it uses the DTD or at least the path where it looks for DTD's? Chris B wrote: > I have a datawindow and use it's importfile method to import an xml file. > Unless I put the DTD in the same directory as the data file, I get a "could > not open DTD" error. How can I control whether or not it uses the DTD or at > least the path where it l...

XML import in powerbuilder
I am running into a weird problem. I am trying to call a webservice method that returns an XML string. Then I import it into a datawindow using importstring method. This is a customer query. When I query for a single record, it sends me valid XML that I can import, but when queried on multiple records, the xml generated is not being imported. Then I tried to craete a template for import process. When I do that, import returns me -1. I have compared the datatypes and order of fields with the XML elements, they all match. When I run the XML string through XMLParsestring() method, it retu...

Datawindow XML Import
I have a datawindow and use it's importfile method to import an xml file. Unless I put the DTD in the same directory as the data file, I get a "could not open DTD" error. How can I control whether or not it uses the DTD or at least the path where it looks for DTD's? ...

Import XML to Datawindow
This is a multi-part message in MIME format. ---=_forums-1-dub4b059314 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit When I tried the import using the XML attached Import keeps failing. Please help as creating template is not successful either. Thanks ---=_forums-1-dub4b059314 Content-Type: text/xml; name="file4.xml" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="file4.xml" PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjxzOkVu dmVsb3BlIHhtbG5zOnM9Imh0dHA6Ly9zY2hlbWFzLnhtbH...

Importing XML to datawindow
I've asked this question before without getting any answer (see "values not repeating when importing xml"). I'm trying to import a XML-file into a datawindow. The structure of the XML-file is; group 1 information (e.g customer) group 2 information (e.g order) one or many details (e.g order items) I want this information imported into columns in my datawindow detail, where I have a column for each tag in the XML-file. When I import it, I get one row for each order item, but the group level information (customer and order) is set only at the rows where t...

Import XML into a DataWindow
Hi all, having never used DataWindow XML Import I wonder about the limitations of this technique. I have to import a XML file containing order headers and order items. So I thought I can achieve that using a grouped DataWindow but that seems to be wrong. Here is a shortened sample of the data I like to import: <?xml version="1.0" encoding="utf-8"?> <ORDER xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.healy-hudson.com/XMLSchema/Schlecker/1.1" xsi:sch...

XML Import Error
I created a simple dw and in the designer retrieved and saved rows as xml. When I try to import the rows, I get this error. XML Import Error - No matching datawindow column reference within XML template. Ay ideas? -- PB9.01.7151 Thank you, R.Chauvin Did you turn on the xml import tracing option? It should give you more information about what it doesn't like. On 2 Jul 2004 06:08:17 -0700, "Bob Chauvin \( Paix dehors \)" <nocanspambob_chauvin@yahoo> wrote: >I created a simple dw and in the designer retrieved and saved rows as xml. >...

Problem importing XML into a DataWindow
PB: 10.2 This is my first try at using XML. Our mainframe group has created a 'WebService' whereby we can get the quantity in stock by passing stock code via GetURL. The result passed back is an XML string: <?xml version="1.0" encoding="UTF-8"?> <QyOnHand>15</QyOnHand> I created an external DataWindow with a single column QyOnHand and made it numeric. The following line of code returns -1 ll_rc = dw_1.ImportString(ls_xml, XML!) What am I missing? Thanks, Roland You might want to try posting in the .webservices or...

Web resources about - Importing XML into a datawindow - sybase.powerbuilder.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Intelligent Versus Surrogate Keys
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...

chevy volt
ProEXR File Description =Attributes= channels (chlist) compression (compression): Zip dataWindow (box2i): [0, 0, 5119, 2475] displayWindow (box2i): ...

Enable - A comprehensive solution for the localization of PowerBuilder applications Untitled Document ...
Enable is localization/ translation tool used by PowerBuilder developers to make their applications multilingual.Enable is a powerful tool that ...

comp.lang.clipper.visual-objects - Google Groups
comp.lang.clipper.visual-objects 1-20 von 33006 Themen werden angezeigt Integrity of a file marcosm...@gmail.com 09:35 Combobox value Lu 08:12 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
Developers can choose Win32 or newer style .Net development

PowerToTheBuilder - PowerBuilder UI Controls
HOME - COMPONENTS - PB UI DESIGNER - DOWNLOAD\PURCHASE - SUPPORT - FAQ - ABOUT Take Control of your UI with PB Ultimate Suite PowerToTheBuilder.com ...

Beautiful iPad Mini 3 Concept Reimagines Appleā€™s Tablet With iPhone 6 Design, Gold Color [Images]
The iPhone 6 may be grabbing all of the recent headlines due to its impending announcement, but spare a thought for those who prefer to stay ...

Java Networking - Real's HowTo
Real's HowTo Custom Search Java Language String and Number Applet AWT Swing Environment IO Javascript interaction JDBC Thread Networking JSP ...

Business Intelligence Products - Database Management, Data Warehousing & Mobility Software - Sybase Inc ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...

Resources last updated: 12/6/2015 1:12:33 PM