Company Info

Sage 100 Contractor 3-5 Job Contacts


Import Job Contacts directly into Sage 100 Contractor. Simply download your job contacts into Excel, review and apply job contact information and import directly into Sage 100 Contractor 3-5 Job Contacts.

Are you tired of manually keying in Job Contacts one by one into Sage 100 Contractor? Would you rather download your job contacts, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 3-5 Job Contacts data entry form.

Key Features:

Import Template Download:

Import File Layout:

HeaderReferenceData TypeTabExampleDescription
recnumRequiredNumericContacts2019021Job No
cntnmeRequiredString (50)ContactsJohn DoeContact Name
jobttlString (50)ContactsPresidentJob Title
phnnumString (14)ContactsPhone No
phnextString (6)ContactsPhone Ext
e_mailString (75)Contactsjdoe@gmail.comEmail
cllphnString (14)ContactsCell Phone
faxnumString (14)ContactsFax No
othphnString (14)ContactsOther Phone
othdscString (50)ContactsOther Description

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor

File Example:
ARJOBCONT,2017504,"Steve Harold","President"
ARJOBCONT,2017504,"Mark Rice","Manager"


System Requirements:

Requires the Sage 100 Contractor Data Integration Suite