'[i][size=1]initialize hash tables at the "form" level[/size][/i]
Public Export_Log_Fields As New Hashtable()
Public Export_Log_Mode As New Hashtable()
Public OUT_FIELD_TYPE As New Hashtable()
Public OUT_FIELD_LOC As New Hashtable()
Public OUT_TYPE_LOC_FIELD As New Hashtable()
Public Sub INIT_HASHTABLE()
Export_Log_Fields.Add("total impressions printed", "total_impressions_printed")
Export_Log_Fields.Add("total sheets printed", "total_sheets_printed")
Export_Log_Fields.Add("total black only pages printed", "total_BW_imp_printed")
Export_Log_Fields.Add("total color pages printed", "total_Color_imp_printed")
'[i][size=1]yadayadayada[/size][/i]
Export_Log_Mode.Add("job status", "1")
Export_Log_Mode.Add("record status", "2")
Export_Log_Mode.Add("container id", "1")
Export_Log_Mode.Add("job id", "2")
OUT_FIELD_TYPE.Add("total_BW_imp_printed", "int")
OUT_FIELD_TYPE.Add("total_Color_imp_printed", "int")
OUT_FIELD_TYPE.Add("total_sheets_printed", "int")
'[i][size=1]yadayadayada[/size][/i]
OUT_FIELD_TYPE.Add("page_range", "str")
OUT_FIELD_TYPE.Add("job_data_number", "str")
OUT_FIELD_TYPE.Add("job_queue", "str")
OUT_FIELD_TYPE.Add("sent_by", "str")
'[i][size=1]yadayadayada[/size][/i]
OUT_FIELD_TYPE.Add("rip_started", "date")
OUT_FIELD_TYPE.Add("print_started", "date")
OUT_FIELD_TYPE.Add("date_submitted", "date")
'[i][size=1]yadayadayada[/size][/i]
'[i][size=1]now the array index locations, 3 arrays of 3 types, int, string, date[/size][/i]
OUT_FIELD_LOC.Add("pages_ripped", "0")
OUT_FIELD_LOC.Add("rip_time", "1")
OUT_FIELD_LOC.Add("copies_requested", "2")
OUT_FIELD_LOC.Add("copies_printed", "3")
OUT_FIELD_LOC.Add("total_sheets_printed", "4")
'[i][size=1]yadayadayada[/size][/i]
OUT_FIELD_LOC.Add("job_name", "0")
OUT_FIELD_LOC.Add("job_queue", "1")
OUT_FIELD_LOC.Add("sent_by", "2")
'[i][size=1]yadayadayada[/size][/i]
OUT_FIELD_LOC.Add("date_submitted", "0")
OUT_FIELD_LOC.Add("rip_started", "1")
OUT_FIELD_LOC.Add("print_started", "2")
OUT_FIELD_LOC.Add("print_completed", "3")
'[i][size=1]yadayadayada[/size][/i]
'[i][size=1]now, indicate the output field name when looping thru the 3 arrays of varying type[/size][/i]
OUT_TYPE_LOC_FIELD.Add("str_0", "job_name")
OUT_TYPE_LOC_FIELD.Add("str_1", "job_queue")
OUT_TYPE_LOC_FIELD.Add("str_2", "sent_by")
'[i][size=1]yadayadayada[/size][/i]
OUT_TYPE_LOC_FIELD.Add("int_0", "pages_ripped")
OUT_TYPE_LOC_FIELD.Add("int_1", "rip_time")
OUT_TYPE_LOC_FIELD.Add("int_2", "copies_requested")
'[i][size=1]yadayadayada[/size][/i]
OUT_TYPE_LOC_FIELD.Add("date_0", "date_submitted")
OUT_TYPE_LOC_FIELD.Add("date_1", "rip_started")
OUT_TYPE_LOC_FIELD.Add("date_2", "print_started")
OUT_TYPE_LOC_FIELD.Add("date_3", "print_completed")
End Sub