OOOForum posts and associated databases

From Apache OpenOffice Wiki
Revision as of 06:57, 14 June 2006 by DrewJensen (Talk | contribs)

Jump to: navigation, search

What follows is just a description of items on my machine. The screen shots are of forms that I created as examples for people on the OOOForum. The database files they use are my own creation as are any associated basic libraries.

One good thing about this motly group is this. Almost always when building these examples I used tables created with the Base wizard. I had hoped that this would allow me at some point to re-use much of the work done on the forms (Reports), queries and or macros. In reviewing the files, it appears that this will be the case.

A second thing is that each form, or groups of forms, or basic procedures actually implements most of the functionality for some business function. Keep in mind these where all written as examples, not work for hire, so lots of the bells and whistles are missing. Error handling for one, there isn't much. But even so, there is a lot to be used as a leg up for this project.

As for the basic libraries. I have routines for a tickler function. This has the computer prompt for when to contact customers based on a period, which period is adjustable by the type of customer, or individual customers. It is also a great candidate for using QiQ instead of the view that is currently used.

Data import and merge functions - A set of procedures to import a text file into a schema. The routines use the TEXT table feature of HSQL to import the data. To name two.


Screen Shots

Contact / Customer management. This was a database created to help show how one might manage a many to many table relationship. It used 2 data entry forms and later a dialog as a splash screen. Later still I added a search form.

Prjctcnt 1.png


Prjctcnt 2.png


Prjctcnt 3.png This form is designed to be used by other forms, functions and includes a set of basic macros to be used to update its contents for display and to exchange data with the caller.


Order / invoice generation


Order entry 1.png

Order Head ( New Order Screen ) [ Route sales company ]


Order entry 2.png Order Detail ( Order Line Items ) [ Route sales company ]


Order entry 3.png Order Entry Screen ( Gift Shop – so lots of different shipping vs Billing addresses )


Order entry 4.png Store Layaway Screen [ Thrift Store ]


Order entry 5.png Inventory Adjustment Screen


Order entry 6.png Invoice form as Calc template file.


Misc.

Checkin 1.png

Personal tools