Welcome CFBHN IT/IS all Hand Meeting August 3, 2012. Agenda Data due date – 7 th of the Month Prevention data still submitted to KIT Solution Performance Outcomes June 2012 – not final New Performance Outcomes for FY 12-13 FTPS Site – Where/How to submit SAMHIS data to CFBHN
CFBHN IT/IS all Hand Meeting
August 3, 2012
Changes and what has stayed the same
Refer to the Exhibit A
Instructions on how to submit data to CFBHN via FTPS
Using Central Florida Behavioral Health Network’s
Central Florida Behavioral Health Network (CFBHN) has built a means for agencies that have been using DDE(direct data entry) screens in SAMHIS to create SAMH data files that can be uploaded.
The Data Entry Spreadsheets are available to your agency on the CFBHN Share Point portalhttp://cfbhn.org/agency-resources.aspResources / Agency Shared Documents/ Manual Input Templates (ZIP file)
There are 11 sheets: one for each primary data set for SAMH data
You may download the templates to any location on your PC that you choose. Just be sure that the location is one that you will remember and can get to easily.
CFBHN recommends using Windows Explorer to help you manage the template files and the data files you will create with them.
If you need help to use it, you can do a Google search for “Windows Explorer how to use”. There are many websites covering the topic including instruction videos on YouTube
To use Windows Explorer, Right click the START button in the lower left corner of your screen and select “Open Windows Explorer”.
You will want to keep these ‘clean copies’ without any data in them, to make your regular working files.
SO, After downloading the files, you will want to make another copy of each file, again, use a computer path location you remember and get to easily.
The Templates will be available on the SharePoint site if you ever need to download again.
And to have the programs in the template files work correctly, you must create a new folder on your computer’s “C” drive.
The name of this folder is
Now you are ready to use the spreadsheet template files
If the ‘Security Warning: Macros have been disabled’ message appears on your screen click the Enable Content button to enable the macros.
However, you cannot produce the file to upload to CFBHN unless you enable macros.
So, click the Enable Content button.
There are at least 300 formatted rows available in each file where you can enter data. (The SERVinputPacker.xlsm – our example, has 600 data entry rows)
Drop down lists for selecting a value to enter are not available currently. Use the Pamphlet 155-2 for reference during your data entry as frequently as you wish.
You may open and use and save a copy of each of the spreadsheets you use as often as you need to while you are preparing your data.
When you have completed your data entry (for the week, or the month) and you are ready to send it to CFBHN, you will run the macro built into the spreadsheet.
BUILDING YOUR OUTPUT FILE FOR CFBHN
The first action the Macro performs is to save your spreadsheet.
SO…You will not lose any of your data from running the Macro.
Ctrl + Shift + Q
Click button “Run Macro”
Simultaneously depress the Control Key, the Shift Key and the letter Q or click button “Run Macro”
Short, sweet and simple.
You will have noticed while the Macro runs, your screen changes many times
C:\SAMHfiles\DEMOinput.txt would be the filename instead if you had prepared demographics data….etc!