Vantage - Can you export BAQ results as CSV in E9?

Yahoo Archive
1
Hi,

It is there, but it looks messier than using a dahsboard and copying results to Excel and saving the Excel doc as a CSV.

Unless you can set up a menu item to export the file with all of the presets set such a swhich BAQ, what file type, what file name etc.

Thanks anyway.




________________________________
From: Dale Dalton <daled@...>
To: vantage@yahoogroups.com
Sent: Fri, 22 January, 2010 15:36:46
Subject: RE: [Vantage] Vantage - Can you export BAQ results as CSV in E9?

Â
Chris - You may already be aware of this; in 803 we have the Business
Activity Query Export Process it's located in the Utilities folder. I hope
it's in 9 if not we won't be going to it anytime soon.

Dale Dalton

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Chris Thompson
Sent: Friday, January 22, 2010 6:34 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Vantage - Can you export BAQ results as CSV in E9?

I have some BAQ results which I would like to export as a CSV and be able to
add this functionailty soe any one can do the same with the BAQ in question.

How can I export a BAQ to a CSV file?

Obviously a long winded way is to Make a dashboard from the BAQ and copy and
paste the results into excel then save the excel file as a CSV, but it's
hardly the streamlined approach.

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

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







[Non-text portions of this message have been removed]
2
I have some BAQ results which I would like to export as a CSV and be able to add this functionailty soe any one can do the same with the BAQ in question.

How can I export a BAQ to a CSV file?

Obviously a long winded way is to Make a dashboard from the BAQ and copy and paste the results into excel then save the excel file as a CSV, but it's hardly the streamlined approach.




[Non-text portions of this message have been removed]
3
Since you have a BAQ, just create a Crystal Report. The Crystal Report
can then be exported to Excel, CSV or several other options.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Friday, January 22, 2010 7:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - Can you export BAQ results as CSV in E9?





I have some BAQ results which I would like to export as a CSV and be
able to add this functionailty soe any one can do the same with the BAQ
in question.

How can I export a BAQ to a CSV file?

Obviously a long winded way is to Make a dashboard from the BAQ and copy
and paste the results into excel then save the excel file as a CSV, but
it's hardly the streamlined approach.

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





[Non-text portions of this message have been removed]
4
Its pretty much six and two threes whether I add the BAQ to a Dashboard then copy the dashboard to excel then save as a CSV or do the way you suggested.




________________________________
From: "Dines, Tim" <tdines@...>
To: vantage@yahoogroups.com
Sent: Fri, 22 January, 2010 12:40:49
Subject: RE: [Vantage] Vantage - Can you export BAQ results as CSV in E9?

Â
Since you have a BAQ, just create a Crystal Report. The Crystal Report
can then be exported to Excel, CSV or several other options.

Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Friday, January 22, 2010 7:34 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Vantage - Can you export BAQ results as CSV in E9?

I have some BAQ results which I would like to export as a CSV and be
able to add this functionailty soe any one can do the same with the BAQ
in question.

How can I export a BAQ to a CSV file?

Obviously a long winded way is to Make a dashboard from the BAQ and copy
and paste the results into excel then save the excel file as a CSV, but
it's hardly the streamlined approach.

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

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







[Non-text portions of this message have been removed]
5
Chris - You may already be aware of this; in 803 we have the Business
Activity Query Export Process it's located in the Utilities folder. I hope
it's in 9 if not we won't be going to it anytime soon.









Dale Dalton





_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Friday, January 22, 2010 6:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - Can you export BAQ results as CSV in E9?





I have some BAQ results which I would like to export as a CSV and be able to
add this functionailty soe any one can do the same with the BAQ in question.

How can I export a BAQ to a CSV file?

Obviously a long winded way is to Make a dashboard from the BAQ and copy and
paste the results into excel then save the excel file as a CSV, but it's
hardly the streamlined approach.

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





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