Dan,
Yes, I have developed a lot of (rather complex) XML output files.
Generally speaking a quite simple solution is:
Create table with all (empty) lines of the xml file in a table
it looks like this for instance:
(It is a XML-structure in the Dutch language)
What you see is the result of a concatenation of three columns.
1 first column is the openings tag
2 second column contains the content of the tag
3 third column is the closing tag
4 concatenation of 1 + 2 + 3 (in this example shown as XML_Resultaat_regel)
When you have created this table, you can fill the second column with
the content and print the above column with the report-writer using the
TXT option
it looks like this:
PRINT XML_message +
ORDER BY XML_ID +
OPTION TXT +
|FILENAME .V_BESTAND +
|SHOW_CANCEL_DIALOG OFF +
|OPEN OFF
-- The column XML_ID is used for ordering the lines
Hope this helps, if you need further assistance, please mail me privately
kind regards
Tony
Op 20-08-2024 om 16:11 schreef 'Dan Goldberg' via RBASE-L:
I have been requested to export data using adf/xml format. It is a
universal format that the automotive industry uses.
It looks like this.
<?xml version="1.0" encoding="UTF-8"?>
<ADF>
<Leads>
<Lead>
<LeadID>12345</LeadID>
<FirstName>John</FirstName>
<LastName>Doe</LastName>
<Email>[email protected]</Email>
<Phone>555-1234</Phone>
<Company>Example Corp</Company>
<Title>Sales Manager</Title>
<Address>
<Street>123 Elm St</Street>
<City>Springfield</City>
<State>IL</State>
<ZipCode>62701</ZipCode>
<Country>USA</Country>
</Address>
<LeadSource>Website</LeadSource>
<Status>New</Status>
<DateCreated>2024-08-16</DateCreated>
</Lead>
<!-- Repeat <Lead> block for additional leads -->
</Leads>
</ADF>
Has anyone been able to export this in Rbase?
Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB502735ADC00F6C056A3AE65ED48D2%40BY3PR19MB5027.namprd19.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/BY3PR19MB502735ADC00F6C056A3AE65ED48D2%40BY3PR19MB5027.namprd19.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/fe01b44b-4585-499f-8fc0-da21313142c8%40cio-bv.nl.
