Export data to XML - generate xml files?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
ACDC
Posts: 1148
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Export data to XML - generate xml files?

Post by ACDC »

Sorry, I have just remembered you cannot do a Text Document with a subreport. Maybe a standard report could work. I will have to check
CalD
Posts: 146
Joined: Sun May 08, 2016 10:20 pm

Re: Export data to XML - generate xml files?

Post by CalD »

A standard report is not purely text?
customaware
Posts: 2413
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Export data to XML - generate xml files?

Post by customaware »

Standard Report is PDF Cal
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
CalD
Posts: 146
Joined: Sun May 08, 2016 10:20 pm

Re: Export data to XML - generate xml files?

Post by CalD »

Right you are, so back to the original question about exporting an invoice as xml, there is no point using a standard report - unless you are prepared to use a plugin of some sort to convert the pdf to xml.

I still don't see a better way than just building the text string into a large attribute or attributes as per my earlier suggestion, one enhancement on what I said earlier is you could possibly use REPLACE_PATTERN to tidy it up and make it easier to read.
intra
Posts: 279
Joined: Thu Oct 11, 2012 1:30 pm
Location: Australia

Re: Export data to XML - generate xml files?

Post by intra »

I think a plugin would be the way to generate this.

I'm going to attempt to write you one, i hope you're not in a rush for it as i'm doing it for my own curiosity. (in between writing a preso for the conference) :D

I'll PM you over the weekend George.
Avid Linux user....
ACDC
Posts: 1148
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Export data to XML - generate xml files?

Post by ACDC »

Right you are, so back to the original question about exporting an invoice as xml, there is no point using a standard report - unless you are prepared to use a plugin of some sort to convert the pdf to xml.
If you design a report and make sure it contains only text, and then EXPORT the report to Invoice1234.xml you should end up with a file containing the text

A report only becomes a pdf document when you PRINT or Export a *.pdf , but in this case you are exporting the document with a *.xml

I could be totally wrong of course, the exported file may contain other characters which totally debunks my theory. If I had time I would test it out, maybe you should give it a try (My experience using the report writer for this purpose has been for a simple text layout, no grid items and using Text document type)
intra
Posts: 279
Joined: Thu Oct 11, 2012 1:30 pm
Location: Australia

Re: Export data to XML - generate xml files?

Post by intra »

Got an email address i can send you a file attachment George?
Avid Linux user....
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Export data to XML - generate xml files?

Post by weblike »

intra wrote:Got an email address i can send you a file attachment George?
I've sent you a PM.

Thank you
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
CalD
Posts: 146
Joined: Sun May 08, 2016 10:20 pm

Re: Export data to XML - generate xml files?

Post by CalD »

Curious as to if you got this sorted, and how you ended up doing it?
aware_support
Posts: 7526
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Export data to XML - generate xml files?

Post by aware_support »

If you want custom XML export (as is the case here), then it's really easy to do it with a plugin - we have created dozens of such plugins.

You can try doing it with reports as some suggest or using some other technique, but if your XML is reasonably complex you will end up with lots of sub-reports and performance will not be great. Still it can be a workable solution.

But plugins are by far the best method for this.
Aware IM Support Team
Jaymer
Posts: 2475
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Export data to XML - generate xml files?

Post by Jaymer »

could someone post one of these JAVA projects (or even just the "wrapper") so others of us could learn and get started with plugins?
thx
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
aware_support
Posts: 7526
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Export data to XML - generate xml files?

Post by aware_support »

There is a video tutorial on Java plugins - please watch it
Aware IM Support Team
CalD
Posts: 146
Joined: Sun May 08, 2016 10:20 pm

Re: Export data to XML - generate xml files?

Post by CalD »

This frustrates me to to be honest, I don't particularly want to learn how to write java plugins. Just like when I use other tools I don't want to learn .net to extend functionality. However I do appreciate in some cases for obscure reasons there may be no choice.
aware_support
Posts: 7526
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Export data to XML - generate xml files?

Post by aware_support »

If you can work around it with document templates and other techniques, feel free to do so. But like you say, in some cases, there is simply no other choice.
Aware IM Support Team
Post Reply