XMl to XML
Hello,
I retrieved an XML from the dataset which retrieves data from the table in the database. I need to present the data in a different structure. Is XSLT the way or are there any other options.
please let me know.
Thanks!!
Yes
XSLT is a good choice to convert xml file to other forms.
You can take a look at XSLT Tutorial.Sincerely,Young Fang...
XML in, XML outHi All (and a happy holiday to those that will get a break),
I am trying to read in an XML file of addresses. I need to remove all
the address data from the file where code =~ /^000/ (there are none
in the example data below). I need to reproduce that data 'as is', so
I need to honour the tag structure, although the order of the tags
doesn't need to be honoured.
I have been trying to use XML::Simple and I had a go with XML::Smart
but I haven't been able to get the results I want.
My best effort is below (with XML::Simple). There are a couple of
differences ...
datawindow.import(XML!,"file.xml") syntax errorI 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...
XML Import ErrorI 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.
>...
1 Xml -> 2 DataWindows; 2 DataWindows -> 1 XmlHi
Is it possible to import an Xml file like
<data>
<dataX>...</dataX>
<dataV>...</dataV>
<dataV>...</dataV>
<dataV>...</dataV>
...
<dataV>...</dataV>
</data>
to one Datawindow ?
On the other hand is it easily possible to assemble data
from two Datawindows in one XML file ?
thanks
Thomas Kovasits
Thomas Kovasits wrote:
> Hi
> Is it possible to import an Xml file like
> <data>
> <dataX>...</dataX>
> <dataV>...</dataV>
> &l...
xml datawindow importThis 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 ImportI 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 powerbuilderI 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 ImportI 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 DatawindowThis 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 datawindowI'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...
Importing XML into a datawindowSuppose 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
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....
XML::Parser XML::DOM XML::XSLT------_=_NextPart_001_01C6E0D0.3E27D77A
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Hi Craig and fellow VMS Perlers,
You last wrote about this Fri 3/16/2001 11:24 AM, not counting your
very helpful comments on Eisner/Decuserve more recently.
One of my colleagues sent me an email requesting that I make XML::XSLT=20
available on VMS.
perl 5.8.6, VMS 7.3-2, DECC 7.1 latest ACRTL (version 3) on Alpha
XML::XSLT (version 0.48) depends on XML::Parser (version 2.34). This
depends on expat (version 2.0.0).
I built expat a...
Re: Import xml file in xml Element
Here, I got one question, you might be able to help me. Is it possible to import xml file in xml element? For example:
<store> <book> <name>Harry Potter</name> <version>5</version> <publish>2007</publish> <details>c:\actress.xml</details> </book></store>
-- c:\actress.xml <harry>
<actor>Daniel Radcliffe</actor>
<age>18</age>
</harry>
<Hermione&...