>Thank you for the information Dave. Here is some of the background
>information :)
>I am Using Ebase V1.03, without FMP5.5. Data was exported from MS Access
>into Lotus 1-2-3 format, and imported into Ebase using the Admin commands.
>* is added info below.
>
>Labels/Envelopes
>============
>
>2. Mailing label exports don't seem to export the name
>line for some reason.. any ideas? *Mailing labels using
>the [Output] -> [File Export] -> [For Mailing Labels] ->
>[Tab Seperated Text Files] -> MS Word 2000.
> The Name line [FName, LName] are exported as blank,
> but all other information is exported.
The contents of the field Name Line depends on the field Record Type.
If it's Ind (that is, individual) the person's name appears. If it's
anything else (Business, Organization, etc.) the organization
appears. I expect you have records with Record Type Bus or Org, or
blank, and no data in the Business/Organization field. Hence, a blank
in NameLine.
>Importing
>======
>1. updating matching records in current found set - Part of the admin menu
>commands does not seem to import the records. Any ideas? * [Admin] ->
>[Screen2] ->
>[Import a File into NAMES Table] -> [Import Records From a File] ->
>[Update Matching Records in Current Found Set] -> [Match Fields(<=>) to the
>Import Record ID with the Primary key of imported data] -> [Import Data(=>)
>of imported data
>card# to field POSITION] -> [Import] -> [Perform Auto-enter options while
>importing] ->
>[OK]
>
> When returned to the Import Menu Form there is no data to import into
>ebase, nor does the
> update change/modify/or add new information in the current Names file.
>FYI, the POSITION field
> is blank.
The ebase import process uses the de-duping process to manage
updating records. A record in an external file that will be the
source of an update is presumably a duplicate of one already in the
names file (otherwise there wouldn't be anything to update). Proceed
with your import as if you were going to create new records with the
import. When you get past the first step, importing into the file
import1_.103, you get the opportunity to review duplicates. Click the
button to check for duplicates between your import and the names
file. This should include all the records in your import file. You'll
see a screen that shows both records, the imported one, and the one
in your names file. You can review the data record by record, and
mark each one to update with the radio button Update. Or you can hit
the yellow button to Set All to Update.
Go back to the Import menu and move the records into ebase.
BUT BACK UP YOUR EBASE FILE SET FIRST!
>Printing Envelopes
>============
>1. Does anyone know why printing envelopes does not include the ZIP field?*
>From the Home form I
>select the Print Envelope button, In the preview it does not: Show the Name
>Line(FName, LName),
It doesn't show name line for the same reason I mentioned above under
Exporting Mailing Labels. That is, the record type is incorrect.
>or
>the Zip Code.
I just learned something. I never noticed before that the envelopes
don't contain zip4.
>The data has been imported like so:
>[Postal Code:] XXX
>[ZIP:] XXX
>For instance, a postal code of V2L4L4 has been seperated so that Ebase would
>show
>the data. V2L was imported into the Postal Code field, and 4L4 was imported
>into the ZIP4 field.
That's clever. I occasionally get a question about how to deal with
7-character British-style postal codes, and that's a good solution.
>I am expecting:
><<Business/Org>>
><<Fname>> <<Lname>>
><<Delivery Address>>
><<City>> <<Province/State>> <<Postal Code>> <<Zip4>>
>
>What I am getting:
><<Delivery Address>>
><<City>> <<Province/State>> <<Postal Code>>
Business and name are not showing up because of the record type, as I
mentioned above. Zip/Postal Code (the first 5 digits) is all that
appears on the envelope layout. Without FileMaker you can't change
the layout, and you're stuck. You'll have to use labels (which do
contain both parts of the zip code) or export to another application,
like a Word merge document. Has anyone else discovered this problem
and have a workaround?
--
--
Dave Shaw H4 Consulting
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
---------------------------------------------------------------------
