Re: Searching a DBF
Re: Searching a DBF
- Subject: Re: Searching a DBF
- From: Mike Schienle <email@hidden>
- Date: Fri, 19 Sep 2014 13:11:08 -0500
On Sep 19, 2014, at 10:48 AM, email@hidden wrote:
>
> Once a month, we have to download a database of "excluded persons from here: and run our employee list against it to see if any are on the "excluded" list.
>
> The first problem: The database is in ".DBF" format and normal Excel and Numbers will not open it. (The no-longer-supoprted AppleWorks will but...).
>
> Ideally**, I would drop the zipped DBF file into a watched folder and it would unzip the file and compare the existing employee list to the database. reporting any found or a negative in the event none are found.
>
> I have found that NeoOffice will open the DBF file and it can be searched. Any suggestions on how to automate this process?
Hi Marconi -
I think you'll need a scripting language to deal with the DBF file. With something like Perl (built into MacOS, but will need additional modules and coding), you could call a Perl program to pull the contents from the DBF file and do whatever processing you need, then have Automator wrap around the Perl program to take care of whatever inputs and outputs you need to massage.
Mike Schienle
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Automator-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden