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.