Getting XML out to Excel?

I'm not sure about generating the XML from a report, but I generate them directly from the BAQ all the time. Once the BAQ is created, you set it up in a schedule using the "Business Activity Query Export Process" found in the System Management Utilities. You have the option of XML or CSV as an output format.




________________________________
From: powersro <bpowers@...>
To: vantage@yahoogroups.com
Sent: Tuesday, August 18, 2009 2:35:22 PM
Subject: [Vantage] Getting XML out to Excel?

Â
Hi,

Newbie here looking for the easiest way to generate XML from a BAQ and get it out to Excel on a recurring basis (scheduled).. Thought the easiest thing do do was create and run a report, then grab the XML from the reports directory. I've got the BAQ written and working and I created a report with the BAQ report designer. I thought I could add this report to a process set and schedule the process set but I can find a "Save to Process Set" button for this. Am I on the right track or am I missing something? Is there an easier way?

Thanks in advance for any help.

Bob







[Non-text portions of this message have been removed]
Hi,

Newbie here looking for the easiest way to generate XML from a BAQ and get it out to Excel on a recurring basis (scheduled). Thought the easiest thing do do was create and run a report, then grab the XML from the reports directory. I've got the BAQ written and working and I created a report with the BAQ report designer. I thought I could add this report to a process set and schedule the process set but I can find a "Save to Process Set" button for this. Am I on the right track or am I missing something? Is there an easier way?

Thanks in advance for any help.

Bob
Bob,



You can set up a schedule in System Mgmt, Utilities, System Agent...New
Schedule - set for a daily hour or hourly etc...



Then, go to BAQ Export process and fill in all the data and instead of
NOW for the schedule, click on the drop down and find your newly created
schedule...Click on recurring if you want it to continue...



For the BAQ Export, you can choose CSV as the output - which can also
open in Excel if you want, use comma as the text delimeter...



You can view the active and scheduled tasks in the system monitor - and
you will see a task now added to your newly created schedule.



Karen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of powersro
Sent: Tuesday, August 18, 2009 1:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Getting XML out to Excel?





Hi,

Newbie here looking for the easiest way to generate XML from a BAQ and
get it out to Excel on a recurring basis (scheduled). Thought the
easiest thing do do was create and run a report, then grab the XML from
the reports directory. I've got the BAQ written and working and I
created a report with the BAQ report designer. I thought I could add
this report to a process set and schedule the process set but I can find
a "Save to Process Set" button for this. Am I on the right track or am I
missing something? Is there an easier way?

Thanks in advance for any help.

Bob





[Non-text portions of this message have been removed]
Check out your BAQ Export Process under System Management // Utilities

You can choose any BAQ and dump it to your \MFGSYSDATA\REPORTS\ folder
as an XML or CSV (better for Excel). You can schedule it to run every
10 minutes, or daily or wherever in between.



Vic


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of powersro
Sent: Tuesday, August 18, 2009 2:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Getting XML out to Excel?

Hi,

Newbie here looking for the easiest way to generate XML from a BAQ and
get it out to Excel on a recurring basis (scheduled). Thought the
easiest thing do do was create and run a report, then grab the XML from
the reports directory. I've got the BAQ written and working and I
created a report with the BAQ report designer. I thought I could add
this report to a process set and schedule the process set but I can find
a "Save to Process Set" button for this. Am I on the right track or am I
missing something? Is there an easier way?

Thanks in advance for any help.

Bob



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links