On Sunday 08 March 2009 08:18:54 pm KAM.covad wrote: > It would help me (and maybe others) if you could post that code, or at > least some key information. That is what I am planning to do. I need to > create a custom upgrade program that would copy all the data including > memos from an existing VFP9/dbf into a Python/PostgreSQL application.
Actually, there is not much to using the program. In my case I used dbf.py (but there are several versions running around). dbf.py takes a list of the file names (somefile.dbf) and creates a list of dict for the records. Then you take the records and insert them into postgres. The issues are mostly understanding the fox data and their structure and how it relates to Postgres. I expanded mine to including creating the Dabo bizobj's and creating the SQL statements for creating the Postgres database. Watch out for Postgres reserved words that are common in the Fox world - like "name". I'd try out Ed's version first because mine is not ready for prime time and was designed with a specific set of requirements not likely to match what you are doing. Just post any questions you have and I'm sure we can help. For example I never did figure out how to determine the primary key. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
