Export to Excel

Yahoo Archive
1
Is there a way to export Vantage default reports to an excel file?
Specifically I am trying to export the stocked status report.

-Dave Schnorr


[Non-text portions of this message have been removed]
2
When you preview your report, look in your x:\vantage working directory for a report.txt. You can open the text file in excel.

-----Original Message-----
From: Dave Schnorr [mailto:daves@...]
Sent: Wednesday, April 02, 2003 1:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Export to Excel


Is there a way to export Vantage default reports to an excel file?
Specifically I am trying to export the stocked status report.

-Dave Schnorr


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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=1705007183:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>
<http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.1728375/D=egroupmail/S=:HM/A=1457554/rand=994608706>

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
3
Print preview the report. Go to the vntgwork (or what ever you named it)
directory and open the .txt file for the previewed report. The Excel import
wizard should guide you from there.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Dave Schnorr [mailto:daves@...]
Sent: Wednesday, April 02, 2003 1:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Export to Excel


Is there a way to export Vantage default reports to an excel file?
Specifically I am trying to export the stocked status report.

-Dave Schnorr


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



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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
We set up a Generic / Text only printer in Windows and print Vantage
reports. Excel will lead you through placing dividers on the data as you
import to Excel. Titles and page headings will generally be "garbaged up"
but you data should be aligned correctly.

-----Original Message-----
From: Dave Schnorr [mailto:daves@...]
Sent: Wednesday, April 02, 2003 1:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Export to Excel


Is there a way to export Vantage default reports to an excel file?
Specifically I am trying to export the stocked status report.

-Dave Schnorr


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



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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
I'm not sure off hand how complicated the Stock Status report is or amenable to grabbing the report.txt from the Vantage Work folder but one alternative for turning many stnadard reports into spredsheets or exporting to another database is Monarch from Datawatch. Not real cheap, but very powerful ripping and parsing from reports. Once you setup a template for a report it is a couple click process to extract data from the report file. Setting up the templates involves a bit of learning curve so the investment in software and time depends a lot on how often you want to export default reports to Excel. If an exported report involves a lot of massaging of the spreadsheet to remove heading lines, etc..., every time you run it, it might pay in the long run to automate all of this. Just a thought.
-Todd C.

-----Original Message-----
From: Dave Schnorr [mailto:daves@...]
Sent: Wednesday, April 02, 2003 12:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Export to Excel


Is there a way to export Vantage default reports to an excel file?
Specifically I am trying to export the stocked status report.

-Dave Schnorr


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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=1705007183:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>
<http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.1728375/D=egroupmail/S=:HM/A=1457554/rand=994608706>

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
6
At 01:32 PM 4/2/2003 -0500, you wrote:
>Print preview the report. Go to the vntgwork (or what ever you named it)
>directory and open the .txt file for the previewed report. The Excel
>import wizard should guide you from there.

Just thought of something that would be a slick add-on...

In Vantage.INI you can specify the program used for print
previews. Someone could write a little program to pop up and prompt the
user for alternate options, like Print Preview, Save As, Open in Excel,
Email, etc. That would avoid having to poke around in VntgWork.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338



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

I'll second that notion.

Sounds like a good candidate for one of the consulting companies /
programmers to crank out for a nominal fee.

Todd Anderson

-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Wednesday, April 02, 2003 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Export to Excel


At 01:32 PM 4/2/2003 -0500, you wrote:
>Print preview the report. Go to the vntgwork (or what ever you named it)
>directory and open the .txt file for the previewed report. The Excel
>import wizard should guide you from there.

Just thought of something that would be a slick add-on...

In Vantage.INI you can specify the program used for print
previews. Someone could write a little program to pop up and prompt the
user for alternate options, like Print Preview, Save As, Open in Excel,
Email, etc. That would avoid having to poke around in VntgWork.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338



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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=246920.2960106.4328965.1728375/D=egroupweb/S=17050071
83:HM/A=1513704/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_02F/g22lp?T
arget=mm/g22lp.tmpl>

<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.1728375/D=egroupmai
l/S=:HM/A=1513704/rand=745077286>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
8
At 01:28 PM 4/2/2003 -0600, you wrote:
>I'll second that notion.
>Sounds like a good candidate for one of the consulting companies /
>programmers to crank out for a nominal fee.
>

I'm not current on any windoze programming, or I'd bang it out. Maybe Thad
or Mike P would like to?

-WC


[Non-text portions of this message have been removed]
9
Dave,
Creating a Crystal version of the Stock Status is quite possible for a
'current' date. We have a Crystal version that we use regularly, which is
exportable to Excel. If you are running the Stock Status for a past period
in time in Crystal you would have a mess.

Troy Funte
Liberty Electronics

-----Original Message-----
From: Dave Schnorr [mailto:daves@...]
Sent: Wednesday, April 02, 2003 1:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Export to Excel


Is there a way to export Vantage default reports to an excel file?
Specifically I am trying to export the stocked status report.

-Dave Schnorr


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


Yahoo! Groups Sponsor
ADVERTISEMENT




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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
10
We went live recently on Vantage 6.1. Under our previous version (4.00.904)
when I would preview a report I could look in the target working directory
for report.txt and open the file in excel. In 6.1 when I print preview a
report, there is no report.txt file generated. Is there something I am
missing or a different way to export to Excel?
11
I still do that in 6.1 so maybe you just need to keep looking for the file.

-----Original Message-----
From: James Smith [mailto:jsmith@...]
Sent: Tuesday, February 08, 2005 10:36 AM
To: Vantage (E-mail)
Subject: [Vantage] Export to Excel



We went live recently on Vantage 6.1. Under our previous version (4.00.904)
when I would preview a report I could look in the target working directory
for report.txt and open the file in excel. In 6.1 when I print preview a
report, there is no report.txt file generated. Is there something I am
missing or a different way to export to Excel?




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/links
Yahoo! Groups Links
12
The stock status report created a report.txt file when I tried that, the AR
aging report did not. The AR aging report default was the crystal report,
when I changed the default to progress, the report.txt file was created and
I was able to export. Must just be an issue with crystal reports??

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Tuesday, February 08, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Export to Excel



I still do that in 6.1 so maybe you just need to keep looking for the file.

-----Original Message-----
From: James Smith [mailto:jsmith@...]
Sent: Tuesday, February 08, 2005 10:36 AM
To: Vantage (E-mail)
Subject: [Vantage] Export to Excel



We went live recently on Vantage 6.1. Under our previous version (4.00.904)
when I would preview a report I could look in the target working directory
for report.txt and open the file in excel. In 6.1 when I print preview a
report, there is no report.txt file generated. Is there something I am
missing or a different way to export to Excel?




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/links
Yahoo! Groups Links









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/links
Yahoo! Groups Links








[Non-text portions of this message have been removed]
13
The issue is this.
When Vantage creates a Progress report, it uses the txt file as a temp file
to work from. When Vantage creates a Crystal report, it creates DBF files
to work from.
Either can be used to get the information you are looking for with a little
effort, but as stated, it depends on the format of the report.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: James Smith [mailto:jsmith@...]
Sent: Tuesday, February 08, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Export to Excel



The stock status report created a report.txt file when I tried that, the AR
aging report did not. The AR aging report default was the crystal report,
when I changed the default to progress, the report.txt file was created and
I was able to export. Must just be an issue with crystal reports??

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Tuesday, February 08, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Export to Excel



I still do that in 6.1 so maybe you just need to keep looking for the file.

-----Original Message-----
From: James Smith [mailto:jsmith@...]
Sent: Tuesday, February 08, 2005 10:36 AM
To: Vantage (E-mail)
Subject: [Vantage] Export to Excel



We went live recently on Vantage 6.1. Under our previous version (4.00.904)
when I would preview a report I could look in the target working directory
for report.txt and open the file in excel. In 6.1 when I print preview a
report, there is no report.txt file generated. Is there something I am
missing or a different way to export to Excel?




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/links
Yahoo! Groups Links









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/links
Yahoo! Groups Links








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



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/links
Yahoo! Groups Links