Converting files from DBF into Filepro
Cutting Edge Laser Inc.
celaser at pathcom.com
Thu Jan 6 10:52:57 PST 2005
This is a common thing for us as well. It is a real pain in the butt.
What I usually do is open the DBF file and then create a text file.
Then I use the IMPORT process and import the file into the required
lengths.
Using dd can be a real pain due to the fact that the header is often a
different length for each file.
Scott Doern
Cutting Edge Laser Inc.
Laura Brody wrote:
> On Thu, 06 Jan 2005 07:51:13 -0500, Tom Pancero
> <postmaster at cobbinc.com> wrote:
>
>> Greetings all.
>>
>> Red Hat 8 -- Filepro 4.8
>>
>> I regularly receive data files from customers that are used in the
>> preparation of commercial bulk mail.
>>
>> I am interested in a better approach to converting them to Filepro
>> than the current one;
>>
>> Use 'dd' to strip off the header and create a temporary file for the
>> remaining data which is in a fixed field length format.
>>
>> Next I use a Filepro file configured as a 'Non Filepro' key that reads
>> the data elements and uses an automatic processing table to create a
>> 'Maillist' record that we ultimatly mail from.
>>
>> There is no provision for dealing with any changes in the makeup
>> of the DBF file so each time I get one of these I really need to take
>> a closer than normal look at the data.
>>
>> Anyone have a better approach?
>
>
> Is there a problem with using the foxcopy utility?
> I use dbcopy on Windows to pull DBF files into filePro. I
> have it create a temporary filePro file and then run a
> report to add the records into a final filePro file.
>
> What kind of changes to the file? If it is just the
> length of fields, my method wouldn't care. If they change
> the order of the fields, my copy from the temp file to
> the final file wouldn't like it very much. You would have
> to deal with this no matter what.
>
>
More information about the Filepro-list
mailing list