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: 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 this has been done you can apply 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

;

1. In tblValidationEntries setEnter the below information via the backend in tblValidationEntries > sgText1:

1. ClickHome.ClickHomeLive.

ServerUrl: http://jobfilepublictstapi-env.elasticbeanstalk.com/V0ClickHome.ClickHomeLive.

1. ServerUserName: email address used to set up JobFile account

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

ClickHome.

1. JobFile.ExportQueue.Marker

:

1.  see below for how to obtain

this

Step one is to 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

Image Removed

1. these 

1. Query: select * from tblExportQueue order by idExportQueue desc

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

1. . Now enter this number as the marker into tblValidationEntries by running the script below inserting the

desired

1. number in *Insert Export Marker

discovered previously.Finally we need to add the prcGetExportQueueByMarker procedure,

1. *.

   Script: 

   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.

1. 
   

1. If prcGetExportQueueByMarker procedure does not exist use the following script to add this

procedure

1. to your database.

   Script:

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

   AS         

     /* SET NOCOUNT ON */         

     SELECT *         

  FROM  

1.   FROM dbo.tblExportQueue         

  WHERE 

1.   WHERE idExportQueue > @idExportQueueMarker         

  --  WHERE idExportQueue=136973 

1.   ORDER  BY idExportQueue ASC    

  ORDER  BY idExportQueue ASC

1.      

   

1.     

     RETURN

   GO

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

   GO

1.  

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

   Using the windows service create command (SCCreate) create the JobFile Connector Service. 

                             Copy your ClickHome.lic file from your ClickHome win service into the JobFile connector Service.

                              Modify the connection strings config file and ensure it points to your ClickHome SQL Server Instance.

                              Modify the JobfileCH2Connector.exe.config file to ensure all settings point to your ClickHome SQL Server Instance where required. If you're not sure then look at your ClickHome win service config file for these settings.

                             Modify the app settings keys in the file to suit your requirements but you must change the <add key="url" value to: http://jobfilepublictstapi-env.elasticbeanstalk.com/V0. 

                            Depending upon your site consider any proxy or firewall settings that need to be altered to allow the url to be accessed.

                            Once this has been completed you can start the service. Then check the Event Viewer under application to see if there are any error logs.

1. Configure Suppliers
   1. Login to your instance of ClickHome
   2. Go to Admin > Setup > JobFile Admin
      
   3. Click the 'Add' button in the far right hand column for each supplier that you would like to add to JobFile.
   4. Once a supplier is added to JobFile a JobFile id will be returned and from that point forward all tasks that are assigned to them and not completed will be sent to JobFile.
      Note: if you would like to add all suppliers write a script to update the JobFile id field with 'JobFile'. (This is the same as clicking the add button for each individual supplier.)
      Image Added