Difference between revisions of "Custom F&R Codes"

From Kiosk Documentations
Jump to: navigation, search
(How to Copy your Finding & Recommendation Codes from the WinTos Server to TermiteKiosk (Microsoft Access))
(Blanked the page)
 
(24 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[File:Frcodes.jpg|800px]]<br>
 
Users can customize and input their own F&R codes to use in the termite reports.<br>
 
<br>
 
__TOC__
 
<br>
 
== How to Create Custom F&R Codes ==
 
#Hover over Codebook in the Navigation Panel and click on '''Findings and Recommendations Codes'''
 
#Click on the '''F&R''' tab
 
#Click on [[File:Newentry.JPG]] on the bottom left, then input your information in the corresponding text boxes.
 
*By default, the Findings are combined with the Recommendations. If you wish to separate them into categories, click on the drop down menu at the top and select '''Modular F&R'''.
 
*Alternatively you can change the default in '''Options''' in the General section.<br><br>[[File:Fr.JPG|500px]][[File:Fr2.JPG|500px]]<br><br>
 
#To edit a code, click on the [[File:Edit.png]] icon.
 
#When you are finished, remember to click [[File:Save.JPG]]
 
  
== Importing F&R Codes ==
 
#Click '''Import List''' on the F&R Codes list<br><br>[[File:Importfr.JPG|400px]]<br><br>
 
#If you have already downloaded the Findings template, you may skip this step. If you haven't, click DOWNLOAD TEMPLATE. You '''MUST''' format the spreadsheet correctly for the import to work.<br>
 
  ''If you do not have the program Microsoft Excel, you can download the free spreadsheet program from Open Office <u>'''[https://www.openoffice.org/download/index.html here]'''</u>.''
 
:3. The template will begin downloading. Click the file on the bottom bar of your browser to continue.
 
:4. Fill out the spreadsheet following the outlined categories. When you have finished, make sure to save.<br>
 
'''Note:''' ''Type'' column in the template can be disregarded.<br><br>[[File:Templatefr.JPG|500px]]<br><br>
 
:5. Go back to TermiteKiosk. Now, at the Import Findings screen, click SELECT A FILE and locate the saved document in your computer, and open.
 
:6. Click IMPORT
 
 
== How to Copy your Finding & Recommendation Codes from the WinTos Server to TermiteKiosk (Microsoft Access) ==
 
For customers who already own the Microsoft Office suite, you should be able to open the database file through Microsoft Access.<br>
 
#First open the database with Microsoft Access, then scroll down the tables and double-click '''PredefinedComments'''.<br><br>[[File:Access1.JPG|600px]]<br><br>
 
#Open up the Finding & Recommendations import excel template. If you haven't downloaded it already, go to the top navigation panel > Codebook > Finding & Recommendations Codes > Import List > '''Download Template'''.
 
#On the Access table, click on the top row ("CommentNum" and "Comment" respectively). When you select "CommentNum," the whole column will be selected. Press Ctrl + C to copy the selection, then switch to the excel template. Click on the box right under "'''Code'''" in Column A (A2) and Paste (Ctrl + V). Do the same with "Comment" and paste it under "Description" (B2). <br><br>[[File:Access3.JPG|576px]][[File:Access4.JPG|600px]]<br><br>
 
 
== How to Copy your Finding & Recommendation Codes from the WinTos Server to TermiteKiosk (OpenOffice) ==
 
Those who do not own Microsoft Access, there is a free alternative you can use to view the database files and extract them to fit in the F&R Codes template.<br>
 
#First, download '''Open Office'''
 
#When you open the installer, make sure you have at least '''Base''' selected (Open Office Base - database management program)
 
#After installation has finished, open the OpenOffice application. Select '''Database'''.<br><br>[[File:Database1.JPG|600px]]<br><br>
 
#A screen will open, click the option: '''Connect to existing database;''' select from the drop down menu: '''Microsoft Access.''' Click '''Next''' when finished.<br><br>[[File:Database2.JPG|600px]]<br><br>
 
#Click '''Browse''' to select the database file in the WinTos. <br><br>[[File:Database3.JPG|600px]]<br><br>
 
#Finally, select ''No, do not register the database'' (as you are using it just once to copy and paste information), then check the box "Open the database for editing."<br><br>[[File:Database4.JPG|600px]]<br><br>
 
#A "Save As" window will pop up- select a location on your computer to save the database.
 
#Scroll down to the database to "Predefined Comments". This is where your custom Finding & Recommendation codes are located. Right click on it and select '''copy'''.<br><br>[[File:Database6.JPG|600px]]<br>[[File:Database7.jpg|400px]]<br><br>
 
#Make sure you have already downloaded the import template from TermiteKiosk. If you haven't, go to Codebook > Custom F&R Codes > Import List, and download the spreadsheet. <br><br>[[File:Importfr.JPG]]<br><br>
 
#Copy and paste the columns of the original codes into the corresponding category in the template file.
 
#Once you have successfully transferred all the columns into the new template, save, then import the new file into TermiteKiosk.
 
 
== Exporting F&R Codes ==
 
#Click [[File:Exportlist.jpg]].
 
#You can choose to Export all the codes or just a selected few.<br><br>[[File:Exportcontractparagraph.JPG|300px]]<br><br>
 
#Saving your F&R Codes as an HTML will open a new tab with your text. Saving it as an XLS will save it as an Excel file and will begin downloading on your computer.
 

Latest revision as of 22:36, 8 July 2016