Subject Re: [IBO] IB_Export into XML
Author Gerhard Schober
Post date 2014-01-14T17:03:46Z
Thanks Jason,

it's working.

But how can I change the format the XML ?
I'll need it lik:

OBJNR and SPESENSUMME are my fields in the table.
---
<?xml version="1.0" encoding="ISO-8859-1" ?>
<XML_EUROPA_3000_DEBITOREN>
<DEBIREG Form="kunde">
<OBJNR>1</OBJNR>
<SPESENSUMME>2015.00</SPESENSUMME>
</DEBIREG>
<DEBIREG Form="kunde">
<OBJNR>101</OBJNR>
<SPESENSUMME>450.00</SPESENSUMME>
</DEBIREG>
---

Thanks
Gerhard


On Tue, Jan 14, 2014 at 5:14 PM, IBO Support List <supportlist@...> wrote:
 

You can simply do a string and then save it to a file.
 
MyStringList.Text := MyQuery.AsXML;
MyStringList.SaveToFile( MyFileName );
 
As for Win/Dos and Unix, it creates the same type of file as the platform you are running from. I don't have a property where you can explicitly specify which you want regardless of what platform you are running on. You could make a feature request at http://tracker.ibobjects.com.
 
Thanks,
Jason

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Gerhard Schober
Sent: Tuesday, January 14, 2014 6:42 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] IB_Export into XML

Hi Jason,
I have no idea what you mean. What I want is to export a table into a XML formatted ASCII file.
Was playing around with your export component but noticed that the output file format "efText_Delimited" is UNIX.
It should be DOS/Windows.

Can I have this setting ?

Thanks
Gerhard



On Fri, Jan 10, 2014 at 6:28 PM, IBO Support List <supportlist@...> wrote:
 

There isn't an XML option for TIB_Export.
 
You may want to look at the TIB_Query's AsXML property.
 
Jason

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Gerhard Schober
Sent: Friday, January 10, 2014 7:27 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] IB_Export into XML

Hi all,

need a little help exporting records into a XML file.
How is the IB_Export.ExportFormat property working ?
What is [efUser] ?

I have to export a table into a formatted XML file.

Thanks
Gerhard

--
Gerhard Schober
DevCon Engineering
9490 Vaduz
Liechtenstein




--
Gerhard Schober
Business Risk Manager
DevCon Engineering
9490 Vaduz
Liechtenstein




--
Gerhard Schober
Business Risk Manager
DevCon Engineering
9490 Vaduz
Liechtenstein
Phone +41 44 5863470
Mobile +41 78 8881571