Hmm interesting. Thanks that gives me some ideas. Dan Goldberg Lance Camper ________________________________ From: 'Tony IJntema' via RBASE-L <[email protected]> Sent: Tuesday, August 20, 2024 1:04:22 PM To: [email protected] <[email protected]> Subject: [EXTERNAL] Re: [RBASE-L] - adf/xml format
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: [cid:[email protected]] (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]<mailto:[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]<mailto:[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]<mailto:[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<https://groups.google.com/d/msgid/rbase-l/fe01b44b-4585-499f-8fc0-da21313142c8%40cio-bv.nl?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/BY3PR19MB5027EF96D6A3836FEA40975DD48E2%40BY3PR19MB5027.namprd19.prod.outlook.com.
