On Wednesday 26 December 2007 02:42:42 pm kam wrote: > This is a nice presentation of an application using Dabo with PostgreSQL. > > I would like to do something like this. > > Problem, my company is in California and I have many users in New England > with a vfp9 application. The users are not computer literate. How easy is > it (Is it possible?) to send an update that would automatically install > PostgreSQL, copy all the VFP9 data (more than 100 DBF's in 3 separate > folders with a DBC in each folder) into the SQL? Most users have a small > network with a dedicated server and 3-8 workstations. They want to use > Linux for their server and continue to use their Win2k workstations. The > application must be downloaded in one file and everything must be very easy > with defaults so they can simply keep pressing enter to install. > > I would appreciate any comments and suggestions, links, etc
I would install for them - via NX, VNC, ssh, gotoAssist or whatever you use for a remote connection. Most linux distro's today have Postgres available as an install. So if you install a Linux server I don't see Postgres being an issue. With windows the install is also very straight forward only requires Administrator rights to setup the services. Setting up the Postgres users I think would require hand coding. However, creating the database and tables can all be done with DDL statements from postgres in a single script. Converting VFP data can be done in several ways. I have used a product from EMS and also just copied to a cvs/text file. The EMS product imports the data in a single process. And using cvs/text files requires DDL type statements (use COPY) for the Postgres side and of course on the VFP side I just opened each table and used the "copy to" command. Deploying Python and Dabo is not hard but I think it requires two processes to occur. To be honest I haven't had any reason to automate the install. I just did it. All my clients have internet access making it easy. BTW I hope Larry is reading because he was working on a way to convert VFP forms to Dabo (forms) cdxml files. I doubt he got very far because it was just before the holiday. Even if Larry got nothing done it is not hard to hand code the UI to copy a VFP form. Bottom line I know if had to I could get it done. -- 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/dabo-users/[EMAIL PROTECTED]
