Check to see if there is a pattern to the zips that are dropping digits. I
suspect that these would be zip codes that begin with a zero. During the
data importing process there is a step where you can indicate the formatting
for each "column" or field. At this stage, make sure to highlight the zip
field and choose to format it as "text" rather than "general" or "number."
A number formatted field will drop the leading zero in a number as being
superfluous. It is also a good idea to check any other fields containing
numbers to see if this is happening to those fields as well (i.e. serial
numbers, id numbers, etc.). Once the import has been successful the fields
will operate correctly and your numbers will be the proper length.
> From: "office" <[EMAIL PROTECTED]>
> Reply-To: "TechRocks Support" <[EMAIL PROTECTED]>
> Date: Mon, 2 Jul 2001 11:48:49 -0400
> To: "TechRocks Support" <[EMAIL PROTECTED]>
> Subject: [support] Re: Importing data
>
> I am trying to import names into ebase and everything is working fine except
> the zip code. It is importing as four digits instead of five. I have
> imported before and not had a problem so I'm not sure what I'm doing wrong.
> And, other than the zip, the import is working great. I am importing from
> an excel file which shows the correct five numeral zip code. Any
> suggestions? They'd be very much appreciated.
------------------
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
---------------------------------------------------------------------
