Data File Format - VPConnect - English - Foundation 22.1 - OnBase - external - OnBase/VPConnect/English/Foundation-22.1/VPConnect/Configuration/Vendor-Account-Bulk-Insert-Tool/Data-File-Format - 2022-12-15

VPConnect

Platform
OnBase
Product
VPConnect
Release
Foundation 22.1
License

The data file to be imported must match this format provided here, and the data values in each row should be comma delimited, commonly known as a CSV file.

Field Name

Field Description

Field Length / Format

User Name

User account login name

256 / Alphanumeric

First Name

First name

256 / Alphanumeric

Last Name

Last name

256 / Alphanumeric

Password

Initial password

Minimum of 8 alphanumeric characters and 1 special character

Email

User's email address

256 / Alphanumeric

Vendor ID | Customer Number

Vendor ID you want this user account to be associated with + "|" + the Customer Number this record should be associated with in your IAConnect database (as defined in the customer configuration table). The Customer Number is typically the same for every record in the file.

VEND ID: 25 / Alphanumeric

Customer Number: 10 / Alphanumeric

Role

The VPConnect role to assign to the vendor

256 / Alphanumeric

Data File Example:

xx1234,Abraham,Lincoln,alXX123$,alincoln@spfld.org,53000|10001,Vendor Admin

xx2345,John,Adams,jaXX123$,jadams@quincy.org,53000|10001,Vendor Admin