Versions Compared

Old Version 14

changes.mady.by.user Kendall Walker

Saved on

compared with

New Version Current

changes.mady.by.user Kendall Walker

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview:

JobFile provides a way for suppliers & contractors to update their status of a task (accept, reject, started, completed etc.).

ClickHome merely links to JobFile in order to push the information through and receive it back.

For the purpose of this document a supplier/contractor will be referred to as a ‘resource’.

Workflow:

  • On scheduling a task from ClickHome (if JobFile is chosen as a way for the assigned resource to confirm the task) an email is created which includes a URL link to JobFile. The resource can click on this link and accept, reject or propose an alternate date for the task.

  • Replies from the resources are then automatically downloaded from JobFile (standard is every 30 minutes) when it runs and sent back to ClickHome.

 

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;

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

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

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

  2. ClickHome.ClickHomeLive.Enabled: TRUE

    3. ClickHome.ClickHomeLive.TimeOut: 60

    2. JobFile.ExportQueue.Marker see below for how to obtain these 

    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.

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

    Image Removed

      1. Grab the number in the idExportQueue of the first row

    to have a bProcessed value of 0Now add the prcGetExportQueueByMarker procedure,

      1. . 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.


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

    procedure  ORDER  BY idExportQueue ASC

      1. to your database.

        Script:

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

        AS         

          /* SET NOCOUNT ON */         

          SELECT *         

          FROM dbo.tblExportQueue         

          WHERE idExportQueue > @idExportQueueMarker         

      --  WHERE idExportQueue=136973  

      1.   ORDER  BY idExportQueue ASC          

       

      1.     

          RETURN

        GO

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

        GO

         

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

    Unzip & 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

      1. 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

the Companies

your ClickHome 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. 
In the config file ensure the following url value is inserted

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’s

there are any error logs.

 

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

  1. Log into ClickHome as a Supervisor

  2. Open a contract and then a construction task

  3. In the Call Sheet, assign a task to a Resource (preferably one that you can contact to confirm the link is working)

  4. Click ‘Save’

On receiving the email, the resource will click on the link and then be redirected to the below page where they can accept, reject or propose an alternate date for the task depending on the settings applied by the builder. Then the resource will be able to register for free which will allow them to log in to JobFile, manage their tasks and access a variety of features or they can simply continue to receive the call up emails one at a time without registering. (For more information about resource access to JobFile please see the JobFile Registered Supplier Guide)

Image Removed

4. Setup JobFile options for resources:

JobFile allows the 'Job Owners' (builders) to predetermine some of the options that their resources have when accepting tasks.

a. Acceptance Permissions

Log into JobFile and go to:

Admin > Options > Relationships

This page is separated into 3 types of user accounts;

  1. Anonymous = resources with no registered account in JobFile 
  2. Login = resources registered in JobFile 
  3. Own = Job Owners that are assigning themselves work (non ClickHome Users)

Under the first 2 user types (anonymous and login) check the settings on the right hand side (Yes/No) for each of the following (these settings will be applied to all tasks that are scheduled to a resource from ClickHome. This means, in JobFile the resource will or will not be able to do the following depending on the settings applied):

  • The Resource can reject a task
  • The Resource can propose an alternate date for a task
  • The Resource can select a booked in date

When you are finished click 'Save'.

Image Removed 

b. Reasons

Recording a Job Not Ready, Proposing an Alternate Date & Rejecting a task are all actions that the resource will take when working on a task.

As the Job Owner you can determine the reasons for the resource to choose from.

To do this;

1. Log into JobFile and go to; Admin > Options > Lists

There are 3 lists:

    1. Job Not Ready Reasons

    2. Propose Alternate Date Reasons

    3. Reject Reasons

Image Removed

There may be default reasons inserted however you can edit or remove these and add your own or you can leave them as they are.

Click on 'Edit' then enter a new entry and click 'Save.

You must create at least one (1) entry for each list otherwise that function will not work for the resource.

Image Removed

5. Upload Logo for JobFile call ups:

In the JobFile account details page you can upload your company logo to your account to ensure that it appears on the resources tasks (in top left hand corner as per above example).

1. Go to;  Admin > Account > Details

2. Click on the attach button (paperclip icon)

3. In the popup window click Attach

4. Using the windows browser navigate to your logo and then click Open.

5. Your logo will be added as per below

Image Removed
  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