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 (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 to forward you the email.

6. Once you have verified the email address contact JobFile support and request them to manually upgrade your builders account to a paid account. 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 > sgText1:

   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.ClickHomeLive.Enabled: TRUE

   5. ClickHome.ClickHomeLive.TimeOut: 60

   6. JobFile.ExportQueue.Marker and JobFile.DownloadExportQueue.Marker: see below for how to obtain these 

      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 column bProcessed is no longer 1 and becomes zero. This is the point in which the export queue has been processed.
         Query: 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 enter this number as the marker into tblValidationEntries by running the script below inserting the number in *Insert Export Marker*.

         Script: 

         insert into tblValidationEntries (cdValidCode,sgDisplay,sgvalue,inOrder,fkidOther,bStdActive,inStdCustomOrder)
         values ('SETTINGS','JobFile.ExportQueue.Marker','AUTO',100,/*Insert Export Marker*/,1,100)

      3. Next, search the database for the the following stored procedure: prcUpdValidationEntries. Then check that the validation entry we added earlier is actually appearing in the required view.  

         Query: select * from ViewValidationEntries where sgDisplay like 'jobfile%' 

         This should find the record we entered, if this doesn’t then there’s an issue with the row we entered earlier.

      4. Now add the prcGetExportQueueByMarker procedure, use the following script to add this procedure.

         Script:

         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

      5. The next step is to download and install the JobFile Connector via: https://drive.google.com/file/d/0BzFoAfjAJGPObHNsZ2E3TkJIWUU/view?usp=sharing

         Download both the exe and msi files to a folder on the application server and run the setup.exe. This will install the JobFile service on the Application server and from here you will need to configure JobfileCH2Connector.exe.config file to point to the Companies SQL Server.There are two spots in this config file you need to change. The location of the server needs to be inserted after the first instance of the word (Data Source) and the database name needs to be inserted after the first instance of the word (Initial Catalog). You can use the ctrl + f function in notepad to find these locations. Once this has been completed you can start the service. Then check the Event Viewer under application to see if there’s any error logs.

      6. This Step was at the bottom of the FogBugz document, what does it relate to? (http://apps.imagemation.com/FogBugz/default.asp?W512) 

         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

         
         

NOTES:

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

• If you want to upload any existing jobs to JobFile that were created prior to JobFile being turned on you will need to run a 1502 in tblBackEndJobs using that fkidContract.

3. Test call up email - JobFile URL link for a resource: