filepro to sql

[Bill Campbell]

On Wed, Apr 22, 2009, Richard Hane wrote:

>OK it's time for wierd question of the day.

>Has anyone populated a SQL (either Microsoft or mysql) database directly
>from filepro?  If not have about MS-Access?

>I am pretty sure this could be done with Excel either dif or csv but I am
>trying to do this seemlessly.

We do regular imports into a Zope/Plone site from FilePro, which is
probably a bit more complex than importing into an SQL database.
The basic procedure we use is to create TSV files for each table
to be imported, then run an external python script that handles
the import via xmlrpc calls to the Plone site.

A very simple shell script could be used to import TSV files into
either postgresql (my choice) or mysql, one line per table in the
appropriate order to insure foreign key constraints are not
broken.  I do not Do Windows(tm) so can't say how one would do
this with M$-SQL or Access, but I assume that a simple batch file
could control the import.

As for importing into Excel or OpenOffice-calc, I have had
problems with field types doing tab-separated or comma-separated
files, so do it the other way around.  When I export data from my
Unify based accounting software that need in OpenOffice-calc, I
export the data to a MySQL database, then use the OO-calc data
sources to import from MySQL.  My accounting software is running
on SCO OpenServer 5.0.6a in a VMware virtual machine on CentOS 5
updating a MySQL database on another server running SuSE Linux
Enterprise 10, and importing into NeoOffice (Mac native
OpenOffice.org) on a Mac Mini running OS X 10.4 Tiger.  Who says
we can't have diversity :-).

Bill
-- 
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792

Democracy is two wolves and a sheep voting on what to have for dinner.
Liberty is a well armed sheep. -- Ben Franklin