[Calendula-devel] data migration
Darryl Caldwell
darrylc@fudosys.com
Fri, 12 Mar 2004 09:08:44 -0800 (PST)
Bill, Bill, Bill, where were you when I needed your expertise last year? ;-)
Thanks for that great code snippet. I can see putting that to use REAL
SOON. The problem to be solved is to start planning for migration of data
in FM and Access databases over to Calendula. Thomas and others have
suggested that many small nonprofits use FM and Access to store their
donor data. Some type of migration tools should be present early on and I
want to make sure the path is mapped out.
-D
>
> Hello, all:
>
> I haven't been following this thread, and I haven't posted to this list
> before, which
> explains why I'm copying to some individuals: I'm not sure I have the
> right address
> for the list.
>
> I've worked with both FM and Access. Both support ODBC, and Python offers
> convenient access to ODBC. IIRC, FM's ODBC is wobbly, and as a consequence
> I
> have retrieved data from FM tables as HTML files, then parsed them.
> Access's
> ODBC has never given me trouble, and I've used it heavily, on and off, for
> some
> years.
>
== Code sample snipped ==
>
> Would someone mind restating the problem to be solved?
>
--
Darryl Caldwell
darrylc@fudosys.com
www.fudosys.com