Subject RE: [IBO] IB_Export into XML
Author IBO Support List
Post date 2014-01-14T17:23:40Z
You are welcome to trace into the IBO code and make alterations to suit your needs.
 
Just make sure you rebuild your packages after you have made modifications.
 
Jason

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

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