[POSSIBLE SPAM] RE: Creating DBFs Out Of Progress --

You're welcome.

There is a problem though. I haven't been able to connect to the DBF
in Crystal. I keep getting a 'corrupt header' error. ??????

This is an interesting/challenging project so I'll probably bang on
it some more ....

--- In vantage@yahoogroups.com, Adam Ellis <aellis@s...> wrote:
> > Anyway, I tried...
> >
> > DEF VAR TheTableHandle AS HANDLE NO-UNDO.
> > TheTableHandle = BUFFER Empbasic:HANDLE.
> > RUN c:\Pro2DBF.p (TheTableHandle,"C:\EmpBasic.dbf",2).
> >
> > ... and had some luck. But the called procedure seemed to lock
and I
> > had to end-program
>
> Lonnie,
>
> Thank you for this snippet - I think this is what I needed to get
going
> in the right direction. I've now got DBFs being generated. I'll
update
> the group once I have this packaged better.
>
> Thanks again!
> Adam
I have been looking around at how I can generate a DBF file out of a
Progress procedure and I getting closer, perhaps somebody with more
Progress knowledge than myself can fill in the blanks. Anyway, I have
used Results to generate all of the query code that I need. Then I ran
across this project on Sourceforge that gives a way to turn a buffer or
query into a dbf file:

http://sourceforge.net/projects/ganimede/

(see pro2dbf). My thoughts were that I would be able to yank out the
"OUTPUT TO" statement that Results generated and substitute in something
like this:

RUN X:\Vantage\VBP\pro2dbf.p ("EmpBasic", "test.dbf", 0)

but that first parameter is getting me. It is expecting a buffer or a
query. Any thoughts on what I am doing wrong? My original code (before
I yanked out the OUTPUT TO) is here:

http://sourceforge.net/forum/forum.php?thread_id=990404&forum_id=162706

Many thanks,
AE
Hello Adam,

I am not certain I totally understand what your doing. If your need is for
something on an onetime basis I have used the export utility in Vantage to
dump a table out to a dbf file. Would you be more specific about what you
are trying to accomplish.

Thanks

Dan Shallbetter
States Electric

-----Original Message-----
From: Adam Ellis [mailto:aellis@...]
Sent: Tuesday, December 16, 2003 1:59 PM
To: Vantage Group
Subject: [Vantage] Creating DBFs Out Of Progress -- Almost There


I have been looking around at how I can generate a DBF file out of a
Progress procedure and I getting closer, perhaps somebody with more
Progress knowledge than myself can fill in the blanks. Anyway, I have
used Results to generate all of the query code that I need. Then I ran
across this project on Sourceforge that gives a way to turn a buffer or
query into a dbf file:

http://sourceforge.net/projects/ganimede/
<http://sourceforge.net/projects/ganimede/>

(see pro2dbf). My thoughts were that I would be able to yank out the
"OUTPUT TO" statement that Results generated and substitute in something
like this:

RUN X:\Vantage\VBP\pro2dbf.p ("EmpBasic", "test.dbf", 0)

but that first parameter is getting me. It is expecting a buffer or a
query. Any thoughts on what I am doing wrong? My original code (before
I yanked out the OUTPUT TO) is here:

http://sourceforge.net/forum/forum.php?thread_id=990404
<http://sourceforge.net/forum/forum.php?thread_id=990404&forum_id=162706>
&forum_id=162706

Many thanks,
AE


_____




[Non-text portions of this message have been removed]
> I am not certain I totally understand what your doing. If your need is
> for
> something on an onetime basis I have used the export utility in
> Vantage to
> dump a table out to a dbf file. Would you be more specific about what
> you
> are trying to accomplish.

Dan,

I'll back up a bit. We purchased a program off Caesar Development
Services called the Payroll Report Engine that allowed us to automate
the procedure of dumping out payroll information into an MS Access
database file for reporting purposes. We've come to rely on that
utility and, now that CDS has apparently fallen off the face of the
planet, we need a replacement. The export utility works well for us for
many tasks and, if I cannot make this work, we'll probably resort to
that. Ideally, I was hoping to roll this entire thing up into one nice
package that I can bundle with Visual Basic / Crystal Reports to also
speed up some of our painfully slow ODBC reports.

Thanks in advance,
AE
Adam,

I've never tried to create a DBF, but thanks for pointing out the
Pro2DBF.p - it may be useful in the future.

Anyway, I tried...

DEF VAR TheTableHandle AS HANDLE NO-UNDO.
TheTableHandle = BUFFER Empbasic:HANDLE.
RUN c:\Pro2DBF.p (TheTableHandle,"C:\EmpBasic.dbf",2).

... and had some luck. But the called procedure seemed to lock and I
had to end-program.

Good luck,
Lonnie



--- In vantage@yahoogroups.com, Adam Ellis <aellis@s...> wrote:
> > I am not certain I totally understand what your doing. If your
need is
> > for
> > something on an onetime basis I have used the export utility in
> > Vantage to
> > dump a table out to a dbf file. Would you be more specific about
what
> > you
> > are trying to accomplish.
>
> Dan,
>
> I'll back up a bit. We purchased a program off Caesar Development
> Services called the Payroll Report Engine that allowed us to
automate
> the procedure of dumping out payroll information into an MS Access
> database file for reporting purposes. We've come to rely on that
> utility and, now that CDS has apparently fallen off the face of the
> planet, we need a replacement. The export utility works well for
us for
> many tasks and, if I cannot make this work, we'll probably resort to
> that. Ideally, I was hoping to roll this entire thing up into one
nice
> package that I can bundle with Visual Basic / Crystal Reports to
also
> speed up some of our painfully slow ODBC reports.
>
> Thanks in advance,
> AE
Have you checked this out yet, Adam?

http://www.v9stuff.com/dbwrite9.p <http://www.v9stuff.com/dbwrite9.p>

Hope this helps you out,

Ted Kitch
tedkitch@...

-----Original Message-----
From: Adam Ellis [mailto:aellis@...]
Sent: Tuesday, December 16, 2003 1:59 PM
To: Vantage Group
Subject: [Vantage] Creating DBFs Out Of Progress -- Almost There

I have been looking around at how I can generate a DBF file out of a
Progress procedure and I getting closer, perhaps somebody with more
Progress knowledge than myself can fill in the blanks. Anyway, I have
used Results to generate all of the query code that I need. Then I ran
across this project on Sourceforge that gives a way to turn a buffer or
query into a dbf file:

http://sourceforge.net/projects/ganimede/
<http://sourceforge.net/projects/ganimede/>

(see pro2dbf). My thoughts were that I would be able to yank out the
"OUTPUT TO" statement that Results generated and substitute in something
like this:

RUN X:\Vantage\VBP\pro2dbf.p ("EmpBasic", "test.dbf", 0)

but that first parameter is getting me. It is expecting a buffer or a
query. Any thoughts on what I am doing wrong? My original code (before
I yanked out the OUTPUT TO) is here:

http://sourceforge.net/forum/forum.php?thread_id=990404
<http://sourceforge.net/forum/forum.php?thread_id=990404&forum_id=162706>
&forum_id=162706

Many thanks,
AE


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>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cd5gc82/M=267637.4116730.5333196.1261774/D=egroup
web/S=1705007183:HM/EXP=1071691280/A=1853619/R=0/*http:/www.netflix.com/Defa
ult?mqso=60178356&partid=4116730> click here


<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmai
l/S=:HM/A=1853619/rand=219397481>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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


[Non-text portions of this message have been removed]
On Tue, 2003-12-16 at 16:31, Ted Kitch wrote:
> Have you checked this out yet, Adam?
>
> http://www.v9stuff.com/dbwrite9.p <http://www.v9stuff.com/dbwrite9.p>
>
> Hope this helps you out,
>
> Ted Kitch
> tedkitch@...

Ted,

Actually this SourceForge project is an updated version of that very
script. The author even mentions Peter van Dam in the comments
section. It was helpful, though, to look at a simpler version to make
sense of.

Thanks for the link,
AE
> Anyway, I tried...
>
> DEF VAR TheTableHandle AS HANDLE NO-UNDO.
> TheTableHandle = BUFFER Empbasic:HANDLE.
> RUN c:\Pro2DBF.p (TheTableHandle,"C:\EmpBasic.dbf",2).
>
> ... and had some luck. But the called procedure seemed to lock and I
> had to end-program

Lonnie,

Thank you for this snippet - I think this is what I needed to get going
in the right direction. I've now got DBFs being generated. I'll update
the group once I have this packaged better.

Thanks again!
Adam