Dave and Rainie:
I have tried both your suggestions. I have added all the area codes in the
US to the Set up Wizard, I have filemaker 5.0 and am using Ebase 103. Each
time I import records the phone # comes out together and the prefix is not
in the correct box. When I initially imported my legacy dbase I didn't have
this problem, I don't know idea why it is doing this. I need to transfter
and go over 6000 new names by Friday and I work during the day. Please
help!
Sarah
>Each time I try to import text delimited info. The phone # does not come in
>correctly. I have removed all spaces, periods, and dashes from the phone
>numbers before I import them but it still does not put the prefix in the
>correct space. All the numbers go into the second field.
Are you using the ebase import procedure? The FileMaker import
process will happily put the unmodified phone number wherever you
tell it. The ebase procedure includes a step which checks the phone
number to see if it has parentheses or hyphens, picks the appropriate
pieces and puts them into the area code and phone number slots.
----------
From: "Rainie Jueschke, CFRE" <[EMAIL PROTECTED]>
Reply-To: "TechRocks Support" <[EMAIL PROTECTED]>
Date: Sun, 25 Mar 2001 22:33:29 -0500
To: "TechRocks Support" <[EMAIL PROTECTED]>
Subject: [support] Re: Importing phone numbers.
Sarah,
This might be worth checking out. If you don't have full administrative
access, you'll have to ask the person in your organization who does to do
this. Go to
the Administration tab. Click on "set up", this may not be the exact
wording, but it is something like that, I think it's on screen 2, I'm not
sure (I'm at home
and don't have ebase at this computer). Click through the wizard until you
get to a screen that tells you to enter area codes. You should see a frame
with a
list of area codes if they have been entered already. If they haven't, add
all the area codes that show up in your data base and try your import again.
If the
area codes have been entered previously, then the problem must be something
else.
Sarah Rayer wrote:
> Sorry, but I'm not really sure what you mean. I get our contacts strait
> from our web master, and I go through all of them and make sure there are no
> spaces, periods, etc. So I don't understand why it is doing this.
>
> Sarah
>
> > From: "Rainie Jueschke, CFRE" <[EMAIL PROTECTED]>
> > Reply-To: "TechRocks Support" <[EMAIL PROTECTED]>
> > Date: Sun, 25 Mar 2001 18:09:39 -0500
> > To: "TechRocks Support" <[EMAIL PROTECTED]>
> > Subject: [support] Re: Importing phone numbers.
> >
> > Sarah,
> >
> > I don't know if this will help, but, when you (or whoever was responsible)
> > first set up ebase, were the area codes identified in the setup wizard
(under
> > administration). If nothing was entered, ebase might not be able to
determine
> > what numbers comprise the area codes.
> >
> > Rainie Jueschke, CFRE
> > Development Director
> > South Carolina Fair Share
> >
> > Sarah Rayer wrote:
> >
> >> Each time I try to import text delimited info. The phone # does not come
in
> >> correctly. I have removed all spaces, periods, and dashes from the phone
> >> numbers before I import them but it still does not put the prefix in the
> >> correct space. All the numbers go into the second field.
> >>
> >> Sarah Rayer
> >>
> >> ------------------
> >> 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
> > ---------------------------------------------------------------------
> >
>
> ------------------
> 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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
