[connection name] [oledb connection provider string]
[connection name] [SQL statement] [1st ? substitution]*
… … … …
Legend
keyword indicating a template option
[text] value of keyword
* optional item
… many items allowed
[2nd ? substitution]* … … … … … … …
… … … … … … … …
[10th ? substitution]*
…
1998001.00
Vision Provider=SQLOLEDB;Data Source=hebron;Initial Catalog=VisionDemo50;Integrated Security=SS
Vision 1998001.00
SELECT PR.Name FROM PR WHERE PR.WBS1=? AND PR.WBS2=''
Vision 1998001.00
SELECT EM.Firstname+' '+Em.lastname FROM EM, PR WHERE PR.Pr
Vision 1998001.00
SELECT CFGProjectType.Description FROM PR, CFGProjectType WHE
Vision 1998001.00
SELECT PRDescriptions.Description FROM PRDescriptions WHERE PR
Vision 1998001.00
SELECT ISNULL(PR.Address1,'')+ISNULL(PR.Address2,'')+ISNULL(PR.A
Vision 1998001.00
SELECT CL.Name FROM CL, PR WHERE PR.ClientID = CL.ClientID A
Vision 1998001.00
SELECT CASE WHEN PR.Status = 'A' THEN 'Active' WHEN PR.Status =
Vision 1998001.00
SELECT CASE WHEN PR.Status = 'A' THEN 'Active' WHEN PR.Status =
Vision 1998001.00
SELECT DISTINCT EM.EMail, 'TRUE' FROM EM, EMProjectAssoc WHE
Vision 1998001.00
SELECT PR.[Name], PR.StartDate, '', PR.EstCompletionDate, '', 'false', '',
Vision 1998001.00
SELECT RPTask.[Name], RPTask.StartDate, '', RPTask.EndDate, '', 'fals
mo50;Integrated Security=SSPI
NOTE: import from project WBS
NOTE: import from project planning module
project WBS
project planning module
Vision Provider=SQLOLEDB;Data Source=hebron;Initial Catalog=VisionDemo50;Integrated Security=SSP
Vision SELECT DISTINCT EM.EMail, EM.FirstName, EM.LastName, 'COMPANY'
mo50;Integrated Security=SSPI
e, EM.LastName, 'COMPANY', Organization.Name, EM.Title, '', EM.WorkPhone+ISNULL('x'+EM.WorkPhoneExt,''), EM.MobilePho
honeExt,''), EM.MobilePhone, EM.HomePhone, EM.Fax, 'ADDRESS', CAST(EM.Memo AS CHAR), 'True', 'Deltek' FROM EM INNER JOIN O
FROM EM INNER JOIN Organization ON EM.Org = Organization.Org WHERE EM.Employee = ? AND EM.Status='A' AND EM.EMail Is Not
A' AND EM.EMail Is Not Null And EM.EMail''
0001
Vision Provider=SQLOLEDB;Data Source=hebron;Initial Catalog=VisionDemo50;Integrated Security=SSP
Vision 0001
SELECT DISTINCT EM.EMail, EM.FirstName, EM.LastName, 'COMPANY', Organizati
mo50;Integrated Security=SSPI
Active Directory Provider=ADSDSOObject
Active Directory SELECT info, info, street, facsimileTelephoneNumber, homePhone, mobile
NOTE: Active Directory return values appear in reverse order of their column specifications
NOTE: the Active Directory comment attribute, "info" is used to insert blank columns into the SQL
eNumber, homePhone, mobile, telephoneNumber, info, title, department, company, sn, givenName, mail FROM 'LDAP://newforma' WHERE
DAP://newforma' WHERE objectClass = 'user' AND mail = '*'