Programming Examples

 

*      Data Export to Excel

*      Data Export to Word

*      Mass Data Export

*      Automated Backup

*      Report Viewer

*      Job Streaming

*        mvBase Administration

 

 

 

 

 

Data Export to Excel

 

 

Data Export to

Excel

 

We have developed a capability to pull information from the database and format it into excel spreadsheets.  This allows you to view your data in an environment with all the calculation and sorting features of Excel available to you.

 

We have created utilities that allow data to be either exported from the database for manipulation within a spreadsheet, or imported from a spreadsheet into the financial database.

 

Applications for this utility in the past have included exporting current year financial data for manipulation to create budgets for the following year, and importing of manipulated data back into budget fields.

 

The utility can be interfaced with data basic programs to place data from complex reports directly into spreadsheets.

 

 
Text Box: GL.MSTR....... DESCRIPTION............. CYA.YTD.12

1.0.0.000      FUND BALANCE             406,844.33
1.0.2.001      REGULAR CHECKING         923,263.82
1.0.2.003      PENSION CLEARING               0.00
1.0.2.004      CASH CLEARING                  0.00
1.0.2.005      CAFETERIA CHECKING             0.00
1.0.2.011      COMPUTER UPGRADE CHECKING      0.00
1.0.2.012      GRANT CHECKING                 0.00
1.0.3.006      REFUND CHECKING           -4,317.70

GL.MSTR

DESCRIPTION

CYA.YTD.12

1.0.0.000

FUND BALANCE

406,844.33

1.0.2.001

REGULAR CHECKING

923,263.82

1.0.2.003

PENSION CLEARING

0.00

1.0.2.004

CASH CLEARING

0.00

1.0.2.005

CAFETERIA CHECKING

0.00

1.0.2.011

COMPUTER UPGRADE CHECKING

0.00

1.0.2.012

GRANT CHECKING

0.00

1.0.3.006

REFUND CHECKING

-4,317.70

 

 
                                                                             

Go to Top

 

Go to Top

 

 

 

 

 

 

 

 

 

 

Data Export to Word

 

 

Export to Word

 

Within mvBase we have

developed a tool that

will take system reports

and format them into

Word Documents.

 

This utility can be set up

to run any report in the

database directly to

Word, or format and

export it to Word from

our “Report Viewer” on-

screen viewing utility.

 

 

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Go to Top

 

 

 

 

 Mass Data Export

 

 

 

 

Go to Top

 

 

 

 

 

 

 

 

Automated mvBase Backup

 

 

Go to Top

 

 

 

Report Viewer

On-screen Report Viewing

 

  Report Viewer

 

  Any report in the system

  can be run to a hold  

  queue and brought up

  for viewing using the

  report viewer.

 

 

  You can search the

  report for specified text,

  page through the report,

  or go directly to the top

  or bottom of the report.

 

  When printing the report

  you have the option of

  printing a single page, a

  page range or all pages.

 

  You can export the

  report in a DOS format

  and then choose to

  open it in either Word or

  Excel.

 
Text Box:                      ***  REPORT VIEWER  ***                              
U/D=page up/down              Left/Right or L/R = shift left/right     
  Home/End = begin/end of report  <Esc>  =  exit Report Viewer        
S = search;   C = left margin;  P = print;  X = Export file to DOS     
------------------------------------------------------------------  
NAME................ CITY........... LST GIFT.. LST DATE                        
                                                                                
Smith,Diane          Belton              $10.00 01/15/06                        
Smith,Gordon L       Ft Lauderdale       $35.00 08/07/05                        
Smith,Anne H         Charlotte           $50.00 02/27/05                        
Smith,Annette        Conover             $25.00 05/12/04                        
Smith,Lorena         Pensacola            $5.00 03/06/06                        
Smith,Sara B         Birmingham         $500.00 07/25/05                        
Smith,Andrew E       Erie                $25.00 12/31/05                        
Smith,Alvin G        Greeley            $200.00 04/09/06
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Go to Top

 

 

 

Job Stream Reporting

 

 

We have developed Job Stream Reporting as a way to run several reports with a

minimum of user input.  Month End duties often require the printing several

reports.  Our Job Stream can combine the running of multiple into a single

operation, where multiple reports can be set up to run in a single process with just

a few keystrokes.

 

This process has also been applied to create formerly printed reports as electronic

files in a spreadsheet format, with all of the benefits of spreadsheet calculation. 

The output is that shown in the Data Export to Excel section.  Users can log in to a

page set up specifically for them on the network and view all their reports on one

screen.  In addition to saving paper, this process puts archived reports at the

user’s fingertips.

 

Our Job Stream Reporting concept is a huge time-saver and can take the laborious

task of running and collating multiple paper reports a thing of the past.

 

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Go to Top

 

 

 

mvBase Administration Support

In addition to creating software solutions we are capable of assisting you with your

mvBase administration and maintenance needs.

 

Some of the things we can assist you with are:

 

Increasing mvBase Disk Space

Setting up new Printers on the mvBase Workstation

Configuring Telnet Servers

Creating remote ViaDuct connections for on or off-site access to database

Archiving and Restoring accounts and data from Backup files

Spooler set up and maintenance

 

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Go to Top