VACMAN Interface Component

Import Utility

Export Utility

Vacman Interface Component

A VACMAN interface component has been developed which will allow immunization registry systems to interface with VACMAN. This component has been implemented in the Maine and New Hampshire immunization registry system, ImmPact. This component is now available to all other immunization projects.

This component is an Active-X DLL developed using Microsoft Visual Basic 5.0. The component name is VACMAN.DLL.

VACMAN.DLL can be used by any COM-compliant client to create, update, delete and read records in the VACMAN databases. VACMAN.DLL uses ODBC to access the VACMAN databases. The Microsoft ODBC FoxPro Driver (Microsoft Data Access Components version 1.5) is used for connecting to the VACMAN databases, which are maintained in FoxPro 2.6 format.

VACMAN.DLL contains functions to perform the following types of transactions:

• Create/Update Depot Provider Order (vaccine shipped from immunization project depot)

• Create/Update Manufacturer Provider Order (i.e. Varicella vaccine shipped by Merck)

• Read Manufacturer Provider Order (read the shipping information, such as shipment date and lot number shipped)

• Create/Update Provider Inventory Adjustment ("other transactions" - vaccine spoiled, expired or transferred)

• Create/Update Provider Profile

• Update Provider Profile Shipping Data (update only the shipping-related fields in the provider profile)

• Create/Update Doses Administered Data

• Read Vaccine Reference Table

• Read Inventory on Hand Table

Top

Top

VACMAN can import data from an external file (on disk, hard drive, or network drive) into the corresponding database. This process is performed using the Import Data Into VACMAN screen under the Utilities Main Menu.

The types of data that can be imported into VACMAN are:

• Distribution of vaccines from the Project/depot to providers

• Doses of vaccine reported administered by providers

• Individual physicians associated with providers

• Other transactions associated with distribution of vaccines from the Project/depot to providers (vaccines transferred between providers, vaccines returned to the Project/depot by providers, vaccines lost/spoiled during distribution, and vaccines wasted by providers)

• Provider

• Vaccines that were distributed by the Project/depot and reported by providers as still being in inventory

• Varicella vaccine ordered for providers and shipped directly from the manufacturer

• VFC enrollment

The formats that VACMAN can read for files being imported are:

• DBF (database file)

• SDF (ASCII text file with a fixed length for each field)

• TXT (ASCII text file with commas as delimiters between fields)

• WK1 (Lotus 1-2-3 file)

• XLS (Microsoft Excel file)

The layout of the file being imported must match the layout of the corresponding VACMAN database.  The file being imported can be in one of the following layouts:

• condensed file - contains only fields that are in the corresponding VACMAN database and contain information.  Only files with distribution of vaccine, other distribution transactions, and Varicella vaccine data can be in this layout.

• full file - contains all the fields that are in the corresponding VACMAN database, whether the field contains information or not

For more information about importing data, refer to the VACMAN for Windows User’s Guide.

Top

VACMAN can export data from certain VACMAN databases to an external file (on disk, hard drive, or network drive). This process is performed using the Export Data screen under the Utilities Main Menu.

The databases that can be exported from VACMAN are:

• Distribution (DISTRIB) - records of vaccines distributed from the Project/depot to providers and records of other transactions associated with distribution of vaccines from the Project/depot to providers (vaccines transferred between providers, vaccines returned to the Project/depot by providers, vaccines lost/spoiled during distribution, and vaccines wasted by providers)

• Doses Administered (DOSESADM) - records of doses of vaccine reported administered by providers

• Enrollment (ENROLL) - records of provider VFC enrollment information

• Physician (PHYSICN) - records of individual physicians associated with a provider

• Provider (PROVIDER) - records of individual providers

• Provider Inventory (PROVHAS) - records of amount of vaccines that were distributed by the Project/depot and reported by providers as still being in inventory

• Stock (STOCK) - records of Varicella vaccine shipped from the manufacturer to providers

The data being exported is written in one of the following file formats by VACMAN:

• DBF (database file)

• SDF (ASCII text file with a fixed length for each field)

• TXT (ASCII text file with commas as delimiters between fields)

• WK1 (Lotus 1-2-3 file)

• XLS (Microsoft Excel file)

The options to export data from a VACMAN database are:

• copy - write the data from the VACMAN database, but do not delete the data from the database

• move - write the data from the VACMAN database and then delete the data from the database

For more information about exporting data, refer to the VACMAN for Windows User’s Guide.