>Thanks Dave,
>
>That was exactly the problem and I have it all fixed now.
>
>Now just to clarify; I don't see an export function in the ebase program.
>A function for sending all or part of the names and addresses to someone
>else for use in a mailing.
>
>So although I am not to use the Filemaker IMPORT function on the drop down
>menu, I still need to use the associated EXPORT function to send stuff out,
>right ?
The export function is built in. To get there, click the Output tab
on the Home screen. From the output screen, select the button to
Export a list. You'll get a set of choices, but the only real
difference is the list of fields you're offered to export, and you
can change the list to anything you like. More details in the ebase
manuals.
>
>Thanks,
>Lisa
>
>-----Original Message-----
>From: Dave Shaw [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, February 03, 2001 10:45 AM
>To: TechRocks Support
>Subject: [support] Re: double record numbers
>
>
>Record numbers are auto-entered when a new record is created. The
>next number to be used is set in the field definition and updated if
>you add a new record, BUT when you import records you need to re-set
>this index to a record number higher than the largest in your import
>set. If you use the ebase import routine, this gets done for you.
>Apparently you used the FileMaker menu item to import.
>
>So, delete the records with duplicate numbers. Find the highest
>record number (by sorting the records by record number, for example).
>Go to the field definition for Record Number and check the Auto-Enter
>tab. You'll see that it's checked to auto-enter, increment one. You
>should set the Next Number to one higher than the highest record
>number in your file.
>
>Now when you enter new records, the will be numbered higher than the
>ones already in your file.
>
>>Okay, the doubles start with 6787, and with a couple of singles now and
>>then, go to 6802. One set is organizations I keyed last summer, the other
>>is Congress keyed in today.
>>
>>My highest record number is 7628, which was a new member I put in just
>>before I started my troubles on January 8th. I put that person in, then
>>put my attention on another member that had paid dues for the third time in
>>a year. I thought I'd better send these people a statement with their
>thank
>>you note. Maybe they don't realize they've paid three times.
>>
>>And then my fatal error, after setting up the statement, using the print
>>function from the drop down menu rather than the ebase button.
>>
>>The rest is history. I've been trying to put back together a functioning
>>database ever since.
>>
>>I did use recovery. Quite a few times. On all kinds of folders. When I
>>did get the names to open, sans the source codes and payments, I exported
>>them without the summary data. Just to make sure I had my good names
>safe.
>>Then I went back to working on the program. But I couldn't recover the
>>source code file or the solicit file or the summary file or whatever one
>was
>>messed up. I tried them all. Then I gave up and downloaded 103. But I
>>didn't have an updated Filemaker so had to do it runtime. But couldn't
>get
>>payments and source codes to import and show up there either.
>>
>>Then I just read the other day that you can't import payments properly to
>>103 without an updated Filemaker. Okay, I saw that several of the fields
>>were grayed out every time I tried. Hmm...okay.
>>
>>Back to 102. I'll go to a zipped file and start a new 102 and reimport my
>>names from the back up I made on January 8th, then my payments from where
>>ever I can get them.
>>
>>That done, and it looked good. I didn't mind losing a little payment data.
>>At least things were mostly back to normal.
>>
>>Now this. I thought it wasn't possible for it to double record numbers!
>>
>>Following my highest number, the one I'd put in just before the crash, is a
>>lower number. 5480. A newspaper from the original import, it's been
>there
>>from the get go. About a thousand records follow, mounting up to the
> >fatal doubles.
>>
>>I haven't a clue what to do anymore.
>>
>>
>>------------------
>>Reminder to each recipient: To change your list account preferences, go to
>>http://email.sparklist.com/scripts/lyris.pl?enter=support and enter
>>the email address you used to subscribe to the ebase support list::
>>[EMAIL PROTECTED]
>>
>>To unsubscribe send a blank email to [EMAIL PROTECTED]
>>---------------------------------------------------------------------
>> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>>---------------------------------------------------------------------
>
>--
>Dave Shaw Northwest Classics, Inc
>tel: 206-954-7526 fax: 206-625-1338
>
>------------------
>Reminder to each recipient: To change your list account preferences, go to
>http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the
>email address you used to subscribe to the ebase support list::
>[EMAIL PROTECTED]
>
>To unsubscribe send a blank email to [EMAIL PROTECTED]
>---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>---------------------------------------------------------------------
>
>
>
>------------------
>Reminder to each recipient: To change your list account preferences, go to
>http://email.sparklist.com/scripts/lyris.pl?enter=support and enter
>the email address you used to subscribe to the ebase support list::
>[EMAIL PROTECTED]
>
>To unsubscribe send a blank email to [EMAIL PROTECTED]
>---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>---------------------------------------------------------------------
--
Dave Shaw Northwest Classics, Inc
tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
