Evaluation

smart Data Pump - Generic Output for Progress ADM2 Smart Data Objects · Index · Part 1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · 10 · Expand · Web Feed

Demo Software

Installation
· Create a copy of the sample database 'sports' and a (new) working directory.
· Download the sportsDemo.zip and unzip it into the working directory.
· Start a progress session with current directory = working directory and connect to the sports database (-ldb sports).
· Open tools/datapump/p-install-DataPump.p with the ProcedureEditor and press [F2] to initialize the smartDataPump (see 'Installation' for more information on the install process).
· Compile tools/* and salesOrders/*.

Run the demo
Open salesOrders/w-SalesOrders.w with the ApplicationBuilder, then choose 'Run'.

The three SDOs run locally, so you should see populated browsers for Customers, SalesOrders and OrderLines. Don't forget to change the SDO instance properties when you install an AppServer later on to run the demo in client-server mode.

Choose the 'Call...' buttons to evaluate the smartDataPump.

Sample Reports

Customers: All records ordered by customer#
US-Customers: Only records with 'USA' or nothing in the country field
Orders: All sales orders of one selected customer
OrderLines: Kinda draft order printout, calculating totals on the quantity field

All reports were created with european settings (Day.Month.Year, comma as decimal point and dot as thousands separator). I didn't apply fancy formatting or filtering, the samples were created to demonstate the basic functionality.

Static HTML
· Customers.htm
· Customers-printedHTML.pdf shows the repeated headings on every page (printed with IE6.0)
· CustomersUSonly.htm
· Orders.htm
· OrderLines.htm

CSV
· Customers.csv (delimiter=';')
· Orders.csv (delimiter='|')
· OrderLines.csv (delimiter=',')

Excel
· Customers.xls
· Orders.xls
· OrderLines.xls

View screen shots of the smartDataPump's user interface.