State of Ohio Department of Public Safety Upload Authorization Tool
In order to meet the State of Ohio regulations for the proper reporting of certain types of recyclable materials the agency offers a web based service that can be accessed on line via a mass update tool, directly pulling the required information from tickets in SMSTurbo V10. This document is met as a customer facing instructional on the specific information the state needs in order to process these tickets, and how to get it entered.
CIS/IT setup side
Associates at Creative Information Systems need to perform some setup on one of the SMSTurbo clients in the customer’s production/live environment. The tech must create ticket UDF’s and extended UDF’s that allow the customer to enter specific information for those tickets to be uploaded. Additionally, the Upload tool provided by CIS has to be present and run from the SMSTurbo folder. It can then be launched from the desktop via a shortcut.
This section specifically addresses how to setup those UDFs to meet the State of Ohio scrap metal transaction submissions. It also is a useful primer on setting up UDFs and some low level programming for those UDFs. For upload customers in Ohio these fields must be present on ticket forms and to classify certain transactions. The following document outlines the steps for doing that.
In SMSTurbo V10 navigate to utilities, User defined fields, ticket UDFs
There are three required Ticket UDFs that need to be created as shown below:
PlateNum: License Plate of Vehicle
PlateState: 2 Character State Abbreviation
OHDPSUPLOAD: When checked, this indicates to the upload tool that this ticket should be uploaded.
If the fields already exist but named something different, edit the UDF and change its name to the correct name.
i.e Plate# needs to be PlateNum
There should be several xUDFs in the Customer, Material and TKDetail tables as shown below:
Select "Utilities", "User defined fields", "Other UDF's". Click on "customer" on the left.
If the Extended UDFs shown above are not present than run ComWedge to create them.
In SMSTurbo V10 simply navigate to Utilities, Configuration, SMSTurbo, ComWedge and click on the button "Add
Extended License Fields to the database"
These xUDFs are all added by SMSComWedge however only four are required for the upload
xID_Image: Picture of License (if this field is not present after running ComWedge then manually create it
by selecting "Add new UDF". On the next screen enter the UDF name and type "binary". Select the
"Launch Editor" button. Type "image" here and save.
After you have determined that all 4 required fields are present click on "Material" on the left.
On the "Maintain Material", "Misc" tab you will create 3 UDFs shown above.
1. xOH_ExportType: This can have one of the following values:
METAL NOT RECYCLABLE
RECYCLABLE NOT SPECIAL
Click on "Add new UDF". Enter the name "OH_ExportType" Set it to type "alpha", length 25.
Hit the "Launch Editor" button. Enter this line "list (METAL NOT RECYCLABLE|RECYCLABLE NOT SPECIAL|RECYCLABLE SPECIAL)
Save your changes on both screens.
Create the following two UDFs by selecting "Add new UDF". enter the name, select type "numeric",
and set the length to 2 or greater.
These three values have other required fields that go along with them.
METAL NOT RECYCLABLE requires that you fill in the notes field on the Ticket Detail entry screen with a description.
RECYCLABLE SPECIAL requires a picture of the item on ticket detail screen, photobox1
All Three requires a picture of the seller on the main ticket screen photobox1.
All Three require a picture of the seller's id stored on the vendor, misc tab at bottom under ID_Image
Customer Use Of The Tool and Making Up loadable Ticket Transactions
New fields may appear on your tickets if you did not already have those fields., ticket detail screen, maintain vendor records Misc tab, maintain material Misc records.
These fields are as follows in the order of their use:
Maintain Material, Misc tab
*xOH_ExportType This field has three choices: METAL NOT RECYCLABLE
RECYCLABLE NOT SPECIAL
*A code found in the Ohio documentation is entered in
One of 2 boxes. “NONSPECIALCODE” OR “SPECIALCODE” If the classification created for that material in Step1, defines it as one of these 2 types. The default is 0 and 0 is not read as a code. Only one box at a time will ever have a code entered, if either.
All materials that will qualify as materials eligible for reporting will need to have these attributes defined. Which materials are what types are defined in the SOH tables below. Simply select your choice from the dropdown menu. Complete this tab for all materials.
Each vendor must have certain information stored for them. These are on the main
vendor maintenance screen, Vendor tab.
*Address1 -an address must be entered here and/or Address2.
*Address2 -an address must be entered here and/or Address1.
*City -enter vendor’s city
*State -enter vendors state
*Zip/postal code -enter vendors zip or postal code.
On the Vendor Misc tab
*XID_FirstName first name of vendor/customer
*XID_MiddleName middle name of vendor/customer
*XID_LastName last name of vendor/customer
*XID_Image id card image (not shown in Screenshot at bottom of page, clcik on this filed to run a scanner to create an image of their ID.)
How to create a ticket using materials requiring reporting to the State of Ohio
In addition to creating tickets in the way they are normally done certain information
Must be entered on the ticket, and ticket detail screens.
Main ticket screen
*Ticket Date -filled automatically
*Ticket Number -filled automatically
*PlateNum -license plate number of vehicle involved in the transaction.
*PlateState -2 letter state abbreviation
*OHDPSUPLOAD -checked or unchecked. Use this to mark the ticket as a ticket to be uploaded.
Basic programming can set it to be Y or N by default.
*Photo1 -should contain a picture of the person selling the material
Ticket Detail Screen
Once a material is added double click on that material detail line.
*Notes: -information must be entered here if material is METAL NOT RECYCLABLE in the notes box.
Enter a brief description of the material on the notes field.
*If the material is classified as RECYCLABLE SPECIAL a picture of the material sold must
be present on picture box one (Dphoto1) on the detail screen.
Technical Specifications for Scrap Metal Daily Transactions Submissions
Running the Upload Tool
User Name: This is assigned by OHDPS
Password: This is assigned by OHDPS
Facility #: This is assigned by OHDPS
To install this with SMSv10 simply locate the OHIOSMDTS.exe in the SMSTurbo folder. Double click on it to run.
A shortcut may be placed onto the desktop but the tool must be located in the \smsturbo folder.
After entering the credentials information for log on, and running the tool,those values will be saved when the tool is launched again.
Choose the dates you wish to upload transactions for and click upload. Each ticket is uploaded one at a time. So if a ticket fails the other successful tickets will still be uploaded. A message at the end will inform you of how many tickets uploaded, failed, and the total tickets considered for upload. If any tickets failed you will be prompted to see a list of those tickets so that they can be corrected if needed.
In the case of a ticket failing the tool will provide an error message explaining why.
Note that tickets can not be uploaded more than once to OHDPS.
The customer may use the same credentials to logon to the State of Ohio web site to view uploaded tickets or
to delete them if necessary.