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 ...
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...
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.
>...
PowerBuilder 11.5I have an application that I am creating that accesses a web service
designed by our customer and retrieves inventory/product/order
information. I am getting the error "There was an error generating
the XML document" on one of the calls to the web service.
The process is that I call the function GetPickTickets and with a
string argument that contains the store code. This returns an array
of
any open orders for that particular store. This works fine. After
that I call another function UpdatePickTicket which acknowledges that
we recieved the order information for a specif...
XML import errorHi,
I am using PB9 on Windows 2000 Professional. I am able to import xml
containing Arabic characters from a file using ImportFile. But when I try
to import an xml string containing Arabic characters using ImportString, it
crashes. Please help.
Thanks
Be sure that the XML string is valid XML -- to verify, try to use PBDOM to
create a document from that string, e.g.:
PBDOM_Builder domBuilder
PBDOM_Document doc
TRY
domBuilder = CREATE PBDOM_Builder
doc = domBuilder.BuilderFromString( "<XML with Arabic characters
here>" )
CATCH( PBDOM_Except...
Error importing from XMLHi everybody,
What I'm doing is to export data from a dynamic datastore to a XML file,
until this point there's no problem. But when I try to import this data
from the XML file in another dynamic datastore the error -11 appear to
me. I have the xerces dll in my machine and with other data it works
well, but I'm affraid that XML have some trouble with non-visual
characters, just like new line character.
Anyone can give me a hand in this?
Thanks.
Tiago wrote:
> Hi everybody,
>
> What I'm doing is to export data from a dynamic datastore to a XML f...
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...
superreview requested: [Bug 297814] Report XML parsing errors to the error (JS) console : [Attachment 186991] Report XML parsing errors to the console, rev. 1Benjamin Smedberg [:bs] (formerly bsmedberg@covad.net) <benjamin@smedbergs.us>
has asked Mike Shaver <shaver@mozilla.org> for superreview:
Bug 297814: Report XML parsing errors to the error (JS) console
https://bugzilla.mozilla.org/show_bug.cgi?id=297814
Attachment 186991: Report XML parsing errors to the console, rev. 1
https://bugzilla.mozilla.org/attachment.cgi?id=186991&action=edit
...
superreview granted: [Bug 297814] Report XML parsing errors to the error (JS) console : [Attachment 186991] Report XML parsing errors to the console, rev. 1Mike Shaver <shaver@mozilla.org> has granted Benjamin Smedberg [:bs] (formerly
bsmedberg@covad.net) <benjamin@smedbergs.us>'s request for superreview:
Bug 297814: Report XML parsing errors to the error (JS) console
https://bugzilla.mozilla.org/show_bug.cgi?id=297814
Attachment 186991: Report XML parsing errors to the console, rev. 1
https://bugzilla.mozilla.org/attachment.cgi?id=186991&action=edit
------- Additional Comments from Mike Shaver <shaver@mozilla.org>
I don't _really_ like using nsScriptError for this, because of the JavaScript
references in...
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&...
How to select Xml as Xml?
If I select Xml nodes like this from sql server;
select xmlData.query('//Field[@F = "True"]') as extendedInfo from....
..how to loop through the items in C#?
I can't cast it to a System.Xml.XmlNodeList..?
You can use the XmlDocument class. There's a Load method and a LoadXml method. One of these should get you what you want, after which you can select nodes as you need.C# <---> VB.Net Translator
mm8:
If I select Xml nodes like this from sql server;
select xmlData.query('//Field[@F = "True"]') as extendedInfo from....
...
XML Import Error #2This is a very straightforward xml file. When I import in the dw painter it
tells me import failed no rows. The mappings look OK. No errors in the
trace file. I made all columns string types to avoid any possible format
errors. I've tried all the suggestions from the NGs here and google.
/*---------------------------------------------------*/
/* 4/5/2007 20:39 */
/*---------------------------------------------------*/
CREATING SAX PARSER.
USING XML IMPORT TEMPLATE: shell_ntd
XML NAMES MAPPING TO DATAWINDOW IMPORT COLUMNS:
ELEMENT: /NTD/...
An error while importing an XML fileI made a datawindow for a external source.
I made a xml template , and put this template on the data-import tab.
When I run a preview in the datawindow painter, and import a file, all
works fine.
But in my windowsform application I want to import the xml file in my
datawindow object with the code:
dw_foutlog.ImportFile("E:\foutenlog.xml",
Sybase.DataWindow.FileSaveAsType.Xml)
When I run my application I get the following error:
An unhandled exception of type
'Sybase.DataWindow.MethodFailureException' occurred in datawindow.dll
Additional infor...