On 08/08/2007 06:29 PM, Paul wrote: >> >> On 8/8/07, Paul <[EMAIL PROTECTED]> wrote: >> > >> > >> > To be honest, I would suggest something like an open source CRM >> > application instead of building / using something within OOo. That however >> > will also depend on current size of customer base and expected growth. >> > >> > Typically open source CRM's are downloadable for free and can be >> > installed and managed by yourself. Have a look at sugarCRM open source >> > version ( http://www.sugarforge.org/content/open-source/) >> > <http://www.sugarforge.org/content/open-source/%29>.. There are other >> > options for sugarCRM for which you can pay for support etc... >> > >> > www.sourceforge.org can also be searched for other CRM type >> > applications. >> >> >> >> Paul: >> >> Thank you for the suggestion of using the CRM software. I've tried using >> things like Quickbooks on my Windows system in the past, and have found >> these to be overkill and would like to try build something tailored to my >> business. This way I know "what's under the hood" and can grow it with the >> business over-time. >> >> I'll be dedicating more time to the database application and see what >> transpires. There is a template included with Microsoft Access that does >> virtually everything I'll need to do with OpenOffice Base. However, I'm >> choosing to stay with OpenOffice and a Linux-Based system. >> >> If you have any resources you can share, that would be greatly >> appreciated. >> > > In that case, you could possibly ask someone nicely to send you the .mdb > (for the table structure), then simply add the forms that you need over the > top. BASE can open and work with MDB's just fine. > > /paul >
Unfortunately Base won't open the Acess forms, reports, etc., only the tables. Further, there are no Microsoft Access import filters in 2.2.1 Base (linux) or 2.3dev (linux). You need to connect using JDBC or MySQL. Ubuntu linux OOo *do* have a Base converter/filter for MS Access, so it's entirely possible to include one in the standard OOo 2.2.1/2.3 versions. http://wiki.services.openoffice.org/wiki/MSA-Base_Faq However... there is a template within OOo Base that can do basically everything Troy is asking for; simply open up a new Base, Tables|Use Wizard to Create Table| and thre are sample tables for Buiness and Personal. Example: Assets, Categories, Contacts, Customers, Deliveries, Employees, Employees Tasks, Expenses, Invoice Details, Invoices, Mailing list, etc., etc. I'd recommend that Troy look at installing 2.3dev (latest is M223) as the 2.3 development version has some nice features & bug fixes regarding Base. Further, you can install the new Report Wizard extension. Obviously, 2.3dev is still in development, but it can be run side-by-side with 2.2.1. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
