JobFile Setup Instructions - Public Test Environment (CH2)

Settings

1. Create a JobFile account (these account details will be used to setup the link between ClickHome and JobFile, JobFile is not the system for builders to use, ClickHome is).

1. Go to: http://jobfilepublictestap-env.elasticbeanstalk.com/Registration;

2. Enter the following;

1. Company Name;

2. Company Type "Builder"

3. Contact Name;

4. Email Address;

5. Password

6. Confirm Password 

   NOTE: the password cannot be ‘password’ and must be at least 6 characters;

3. Click next

4. Accept the terms in the license agreement, then click confirm;

5. An email will be sent to the registered email address, you will need to verify the email address using the link in the email;
   NOTE: No email will be sent to you in the test environment as emails are setup to go to JobFile Support. Please wait for a JobFile Team member forward you the email .

6. Once this has been done contact JobFile support to manually upgrade your builders account to a paid account and then you can apply the correct settings in ClickHome as per the next step.                                              

2. Configure Settings in ClickHome - JobFile for all resources;

1. Enter the below information via the backend in tblValidationEntries:

   1. ClickHome.ClickHomeLive.ServerUrl: http://jobfilepublictstapi-env.elasticbeanstalk.com/V0

   2. ClickHome.ClickHomeLive.ServerUserName:email address used to set up JobFile account

   3. ClickHome.ClickHomeLive.ServerPassword:password used to set up JobFile account

   4. ClickHome.JobFile.ExportQueue.Marker:see below for how to obtain this

      1. Find the export marker. The Export marker is used by Jobfile to determine which item in the Export Queue needs to be exported next. To find out where Jobfile needs to start this export you’ll need to run the SQL query found below. Begin scrolling through the table until you find the point in which the bProcessed is no longer 1 and becomes zero. This is the point in which the export queue has been processed.
         select * from tblExportQueue order by idExportQueue

         

      2. Grab the number in the idExportQueue of the first row to have a bProcessed value of 0.

         Now we must enter the marker into the tblvalidationentries table. Run the script below inserting the desired Export Marker discovered previously.

         insert into tblValidationEntries (cdValidCode,sgDisplay,sgvalue,inOrder,fkidOther,bStdActive,inStdCustomOrder)

         values ('SETTINGS','JobFile.ExportQueue.Marker','AUTO',100,/*Insert Export Marker*/,1,100)

         Search the database for the the following stored procedure, prcUpdValidationEntries.

         The next on the SQL server is to check that the validation entry we added earlier is actually appearing in the required view.  (select * from ViewValidationEntries where sgDisplay like'jobfile%') Should find the record we entered, if this doesn’t then there’s an issue with the row we entered earlier.

         Add the prcGetExportQueueByMarker procedure, use the following script to add this procedure.

         CREATE PROCEDURE [dbo].[prcGetExportQueueByMarker] (@idExportQueueMarker INT)         

         AS         

           /* SET NOCOUNT ON */         

           SELECT *         

           FROM   dbo.tblExportQueue         

           WHERE  idExportQueue > @idExportQueueMarker         

           --  WHERE idExportQueue=136973     

           ORDER  BY idExportQueue ASC               

           RETURN

         GO

         GRANT EXECUTE ON [dbo].[prcGetExportQueueByMarker] TO [SiteManager]

         GO

      3. Finally, take the value and insert into the following statement;

         insert into tblValidationEntries (cdValidCode,sgDisplay,sgvalue,inOrder,sgText1 ,bStdActive,inStdCustomOrder)

         values ('SETTINGS','ClickHome.ClickHomeLive.Enabled','-',100,'TRUE',1,100)

         insert into tblValidationEntries (cdValidCode,sgDisplay,sgvalue,inOrder,sgText1 ,bStdActive,inStdCustomOrder)

         values ('SETTINGS','ClickHome.ClickHomeLive.ServerPassword','-',100,'password',1,100)

         insert into tblValidationEntries (cdValidCode,sgDisplay,sgvalue,inOrder,sgText1 ,bStdActive,inStdCustomOrder)

         values ('SETTINGS','ClickHome.ClickHomeLive.ServerUserName','-',100,'Client Name',1,100)

         insert into tblValidationEntries (cdValidCode,sgDisplay,sgvalue,inOrder,sgText1 ,bStdActive,inStdCustomOrder)

         values ('SETTINGS','ClickHome.ClickHomeLive.TimeOut','-',100,'60',1,100)

         insert into tblValidationEntries (cdValidCode,sgDisplay,sgvalue,inOrder,bStdActive,inStdCustomOrder)

         values ('SUPSETTING','Clickhome Live ID','CHLIVEID',100,1,100)

         GO

         Grabbing exportqueue for jobs started last month:

         declare @idcontract nvarchar (100)

         select top 1  @idcontract=idcontract from tblcontracts where dtdatestartschedule > '2013-01-24' order by idcontract

         set @idcontract = '%<idcontract>'+@idcontract +'%'

         print @idcontract

         select top 1 *,idexportqueue from tblexportqueue where sgdata like @idcontract

   5. NOTES:

      1. If you have copied databases then you will need to run clean up scripts - see James to obtain these.

      2. To allow access to purchase orders please ensure the distribute rule is checked.

      3. If the builder wants to upload any existing jobs to JobFile that were created prior to JobFile being turned on you will need to run a 1504 in tblBackEndJobs using that fkidContract.