|
Creating a
New Record in to the cBiz |
Create a New Consultant:
To create a new consultant in the cBiz we need to follow the below steps.
-
The table name to store Candidates is 'Consultants'
-
You need to
set the field "ConsIntID" = NewCounter (ex:
'CS00000036')
-
You need to
set the field "DisplayName" = FirstName + "
" + LastName (ex: 'Kris Reddy')
-
You need to
set the field "ConsultantID" = FirstName + "
" + LastInitial (This need to be unique, if
not unique append a number, till it is
unique)
-
You need to
set the field "CreateDate" = CurrentDateTime
-
You need to set the field "ModifiedDate" = CurrentDateTime
-
You need to set the field "UserIDs" = ",Admin," (Note the leading and lagging commas. Instead of 'Admin', you can put any other valid cBizOne user. But make sure you put the leading and lagging commas)
-
All of the above fields are compulsory, and you need to follow the rules mentioned above.
Issues Regarding Resumes:
-
"ResumeDir"
-
"ResumeDir"
= "Database\" (Fixed word - Note the ending
slash) - IF Resumes are stored in the
database
-
"ResumeDir"
= The folder where the resume is, and is
should end with "\" - IF Resumes are stored
in your file system.
-
"ResumeFile" = Resume file name (no path)
-
"uuResumeText"
= Text content of the resume.
If the resumes are stored in the database (the following can be ignored, if the Resumes are stored in your file system)
Table Name to store resumes: Documents
You need to set the following fields in the Documents table.
-
"ItemIntID" = NewCounter (ex: 'CS00000036') (This ID is same as the ConsIntID of the given candidate)
-
"DocType" = "Resume" (Fixed word)
-
"DocName" =
ResumeFileName (with or without path)
-
"DocContent"
= Zipped (compressed) resume content
-
"CreateDate"
= CurrentDateTime
-
"ModifiedDate" = CurrentDateTime
SQL
Query:
Please find the following link to download the T-SQL
Query to create a simple Candidate in to the cBiz.
Link1: Generating ConsultantID
Link2: New CONSULTANT
Create a New Company:
Please find the following link to download the T-SQL
Query to create a simple Company in to the cBiz.
Link1: New COMPANY
Create a New Contact:
Please find the following link to download the T-SQL
Query to create a simple Contact in to the cBiz.
Link1: New CONTACT
Create a New Requirement:
Please find the following link to download the T-SQL
Query to create a simple Requirement in to the cBiz.
Link1: New Generate ReqID
Link1: New REQUIREMENT