Regarding your filePro Survivor Series order...

[John Esak]

Hi Pauline,

Absolutely no problem.

Yes, there is a 100% guarantee (from me) that the Tutorials will teach you
filePro beyond anything you could imagine. Just do me (an yourself) the
favor of taking the tutorials starting from Chapter 1, and go lesson by
lesson from there. IMPORTANT. Even if you think you already know the topic
being coverd... DON'T skip it. Don't skip anything. It takes a lot of hours
(I think about 35 total), but all through the beginning chapters and lessons
is when I'm laying the solid groundwork you will need to learn the good
stuff. Even though I tell you somewhere in the chapters that you must take
the Runtime Tutorial first before starting the programming tutorials, IGNORE
THIS. Since you already know how to run filePro that is not necessary for
you.

So, take a few lessons, starting from 1, or even one at at time, and then
practice what you have just learned on your own test files. There is simply
no way you can fail. Soon, you will be able to patch and change your own
programs to work more like you want them to work and not the way they want
you to work.

There are a few (lots actually) README FIRST files before Chapter 1 of the
Beginning Tutorial. These take almost 30 minutes total just by themselves...
they are useful though. Rmember, Beginning doesn't mean beginning it's only
a name to have somewhere to start. During the very first few chapters I show
many things that only advanced filePro programmers know. Trust me and do the
whole tutorial, and then let me know if I was right or not.

Good luck,

John

By the way... since you like Excel. Let me write something quick for you
here. It's something that was in The Guru about 15 years ago now, but it
works as well today as it did then. :-)

If you already program at all in filePro... try this in one of your files.
If you don't, after a few chapters in the tutorials you will understand it
thoroughly.

This is the fastest, simplest way I know to export data into an Excel file.

Define a "Processing Only" output format, and fill it with the code I put
below. Let's say you call this processing table "fred" than you would run it
by picking the right filePro file, selecting the output format "fred", and
then selecting the records you want exported to the excel fiel. Once it runs
you can immediately open myexport.xls with Excel just by clicking on the
filename.

Change the fields you export and the headings you put for them to fields
that make sense for the file you've selected to export records from. (Sorry
for the dangling preposition. :-)

Good luck. If you don't understand any of this, don't worry, in a very few
hours of taking the tutorials you will. -John

File: your chosen file, processing-only output format "fred"

top     if: @os eq "UNIX"
      then: ff="/tmp/myexport.xls"
        if: @os eq "DOS"
      then: ff="C:\myexport.xls"
         if:
       then: export dif fil=(ff)
         if: a eq ""
       then: gosub heading;  goto top
         if:
       then: fil(1)=3;  fil(2)=14;  fil(3)=9  '... do all the fields you
need
         if:
       then: end
heading  if:
       then: fil(1)="Date";  fil(2)="Cust Code";  fil(3)="Amount"  'fill in
in the column headings
         if:
       then: a(1,*,g)="Y";  return



> -----Original Message-----
> From: Pauline Browning [mailto:Pauline at browningbbs.com]
> Sent: Tuesday, April 24, 2007 2:11 PM
> To: john at valar.com
> Subject: Re: Regarding your filePro Survivor Series order...
>
>
> Thank you for the offer.  Actually, I have been using FilePro since the
> early 80's, when it was the Small Computer Company.  I have several data
> bases going and they are inter-related and the processing tables
> have become
> quite patch-worked - I need to fix that.  My accounting system is
> QuickBooks
> (I hate account numbers!).  So, I think I will pass on the accounting
> package.
>
> There is so much MORE I would like to know about programming with FilePro
> and I am thinking your program will provide me with the skills I
> need to do
> so.  I would like to learn to export and import using Excel, however I do
> not know how to program in Excel as yet.  My next project.
>
> Thank you,
>
> Pauline
>
>
> ----- Original Message -----
> From: "John Esak" <john at valar.com>
> To: <pauline at browningBBS.com>
> Sent: Tuesday, April 24, 2007 11:47 AM
> Subject: Regarding your filePro Survivor Series order...
>
>
>
> Hello Pauline,
>
> First, let me thank you for ordering the Survivor Series Tutorials, I know
> you will enjoy these CD''s and I'm sure you will get a great deal out of
> them.
>
> It's just that I'm in a bit of an ethical quandary for the next
> few days at
> least. I removed the special "2 for 1" sale price off the web page back on
> March 15th, and so your order for the  Tutorials will get you them at $399
> as you selected. They will go out today by priority mail.
> However, sometime
> next week, I am sending out a large mailing to all the old Guru Magazine
> subscribers and many other filePro users and developers in which I am
> reinstating the 2 for 1 sale for another month, ending on May 30th.
>
> In this sale, as with the one you just missed, you can get the Tutorials
> free by buying the new Survivor Series Accounting package at its price of
> $599, thus saving $399 over all. I have no way of knowing if you
> are in need
> of complete filePro based Accounting, either to use as is or copy
> parts for
> your own programs, but if you are, just let me know and I will make that
> offer available to you since you are buying this product only a few days
> before the mail-out announcement.
>
> Please don't take this email as me trying to "sell" you something
> else... I
> am very happy you bought the Tutorials and as I said, I am absolutely
> certain you will find them to be worth far more than their price. I don't
> need to make any more money off you. I just don't want you to
> feel offended
> or cheated when I put the new sale price back up on the site
> tomorrow or the
> next day.
>
> Simply let me know if you want the Accounting package, I will bill your
> credit card another $200 and it will go out immediately. If you aren't
> interested, just remember that the offer is good for you if ever
> you want to
> avail yourself of it. If you bought it now, my only gain would be  the
> savings of putting them both into the same priority mail pack. :-)
>
> take care, and thanks again for your order.
>
> John Esak
> (570) 384-2444
>
>
>
>