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

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.

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