CUSTODIAN-L Archives

Archiver > CUSTODIAN > 2008-01 > 1199645610


From: <>
Subject: Re: [CUST] Importing
Date: Sun, 6 Jan 2008 18:53:30 -0000
References: <002901c84f77$ac66cd20$d8e987d9@harold3w14pq5x><001d01c84ffa$4f88c1c0$0200a8c0@wjh><000301c8503f$4b562e40$bd4286d9@harold3w14pq5x>


Harold

Since Custodian 3 uses Access databases check whether or not your
firewall/antivirus package is denying you write facilities to the files
........

regards

Bill


----- Original Message -----
From: "Harold Badham" <>
To: <>
Sent: Sunday, January 06, 2008 8:09 AM
Subject: Re: [CUST] Importing


> Bill
>
> Many thanks for comment but I am trying to import separate surnames &
> forenames
>
> Harold
>
> ----- Original Message -----
> From: <>
> To: <>
> Sent: Sunday, January 06, 2008 12:23 AM
> Subject: Re: [CUST] Importing
>
>
>> Hi Harold
>>
>> Are you trying to import FULL Names rather than Surname / Forename ? if
> so
>> you need to split the FULL NAME field into two using excel's "Text to
>> Columns" before you import and match fields with custodian - once done
>> you
>> can save the match of fields for future imports ............
>>
>> regards
>>
>> Bill
>>
>> ----- Original Message -----
>> From: "Harold Badham" <>
>> To: <>
>> Sent: Saturday, January 05, 2008 8:10 AM
>> Subject: [CUST] Importing
>>
>>
>> > Using version 3.5.6 have been attempting to import 1901 Census
> information
>> > from an Excel spreadsheet, but it is only possible to import a few
>> > lines
>> > before getting an error message
>> > This error message varies & have had the following
>> >
>> > 1) Error no --2147417848
>> > Description Automation error
>> > The object invoked has disconnected from its client
>> > Object - Custodian 3
>> > Routine - Import _Excel
>> >
>> > 2) Error no - - 2147217887
>> > Description - Field Name Index - NOTE_ST_Source cannot be a zero length
>> > stream.
>> >
>> > 3) Error no - 9
>> > Description - Subscript out of range
>> > Object - Custodian 3
>> > Routine - Place source_update
>> >
>> >
>> > Omitting different fields I find that it is the forename that is the
>> > problem as it is possible to import all other fields.
>> > It is also possible to import the forename into a user field.
>> >
>> > I have checked importing into civil registration certicates & Probates
>> > &
>> > have the same problem.
>> >
>> > Has anyone else had this problem?
>> >
>> > Harold Badham
>> >
>> > -------------------------------
>> > To unsubscribe from the list, please send an email to
>> > with the word 'unsubscribe' without the
>> > quotes in the subject and the body of the message
>>
>>
>>
>> -------------------------------
>> To unsubscribe from the list, please send an email to
> with the word 'unsubscribe' without the
> quotes in the subject and the body of the message
>>
>>
>
>
>
>
> -------------------------------
> To unsubscribe from the list, please send an email to
> with the word 'unsubscribe' without the
> quotes in the subject and the body of the message


This thread: