{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PALETTIZE","barcode","TestBarcode"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PALETTIZE","index":0,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Group NO","Group","Sub-Task","Item No","Device","Function","Expected result","Actual result","Status","Date","Tester","Approve Check","Approval","Remark"]
[1,"MainModule",null,null,"Handy","Start program","Able to start program normally",null,"Passed","2025-01-03","Nack"]
[null,null,null,null,"Handy","Close program","Able to close program normally",null,"Passed","2025-01-03","Nack"]
[null,null,null,null,"Handy","Initial state TITLE","Define TITLE state at startup",null,"Passed","2025-01-03","Nack"]
[null,null,null,null,"Handy","Settings INI config file","Able to read the settings",null,"Passed","2025-01-03","Nack"]
[null,null,"BTClientLib",null,"Handy","Connect to BTServerDB","Able to connect","Able to connect","Passed","2025-01-03","Nack"]
[null,null,null,null,"Handy","Setup to next step -> frm1000(TITLE)","Able to set the next state","Able to set the next state","Passed","2025-01-03","Nack"]
[2,"frm1000",null,null,"Handy","fGetCountry()","Send the right SQL command to server","Able to do as expected","Passed","2025-01-03","Nack",null,null,"SELECT * FROM HTCTRL WHERE HTNumber = 'TRKD0024'"]
[null,null,null,null,"Handy","fGetTitle()","Send the right SQL command to server","Able to do as expected","Passed","2025-01-03","Nack",null,null,"SELECT * FROM HTTITLE WHERE Country = '066' AND PrgID = 'KDPL1000'\nUPDATE HTCTRL SET ExeName='KDPL1000' WHERE HTNumber = 'TRKD0024'"]
[null,null,null,null,"Handy","fGetEmplName(gstrctKDHT.strUserNo)","Send the right SQL command to server","Able to do as expected","Passed","2025-01-03","Nack",null,null,"SELECT * FROM PICSUSER WHERE EmplCode = '693003'"]
[null,null,null,null,"Handy","Setup to next step -> frm1005(NAME)","Able to set the next state","Able to set the next state","Passed","2025-01-03","Nack"]
[3,"frm1005",null,null,"Handy","Scan barcode USER","Able to scan barcode","Result as expected","Passed","2025-01-03","Nack",null,null,"UPDATE HTCTRL SET EmplCode='693003' WHERE HTNumber='TRKD0024'"]
[null,null,null,null,"Handy","Scan barcode OCMENUBACK","Exit program normally","Exit with error but fixed","Passed","2025-01-03","Nack",null,null,"UPDATE VANPJ SET ExeName='        ' , SearchKey='                              ' WHERE HTNumber = 'TRKD0024'","ERROR|Pervasive.Data.SqlClient.Lna.v: [LNA][Zen][SQL Engine]Invalid column name:'ExeName'."]
[null,null,null,null,"Handy","Setup to next step -> frm1010(SECTION)","Able to set the next state","Able to set the next state","Passed","2025-01-03","Nack"]
[]
[4,"frm1010 (SECTION)","-",null,"Handy","Scan SECTION barcode","Able to scan barcode","Able to do as expected","Passed","2025-01-04","Nack",null,null,"SELECT * FROM SECTION WHERE CenterCode = 'TR1' and SectionID = 'A' and Section = 'TRT1N001'"]
[null,null,null,null,"Handy","Setup to next step -> frm1013(NOTADDRS)","Able to transition to IPADDR form","Able to do as expected","Passed","2025-01-04","Nack"]
[null,null,null,null,"Handy","Setup to next step -> frm1015(PALETTESCN)","Able to set the state to PALETTESCN while the IP Address has already been set",null,"Passed","2025-01-04","Nack"]
[null,null,null,null,"Handy","Update section_id to HTCTRL after scan section","Able to update data","Able to do as expected","Passed","2025-01-04","Nack",null,null,"* Move the SQL statement to do before scan IP Address\nUPDATE HTCTRL SET SectionID='A' , Section='TRT1N001' WHERE HTNumber='TRKD0024'"]
[]
[5,"frm1013 (IPADDRS)",null,null,"Handy","Scan barcode","Able to scan barcode","Able to do as expected","Passed","2025-01-04","Nack"]
[null,null,null,null,"Handy","Update IP to SECTION after scan","Able to update data","Able to do as expected","Passed","2025-01-04","Nack",null,null," UPDATE SECTION SET Hinmei='192.168.1.176' WHERE CenterCode = 'TR1' and SectionID = 'A' and Section = 'TRT1N001'"]
[null,null,null,null,"Handy","Setup to next step -> frm1015(PALETTESCN)","Able to transition to next form","Able to do as expected","Passed","2025-01-04","Nack"]
[]
[6,"frm1015 (PALETTESCN)",null,null,"Handy","Scan barcode","Able to scan barcode","Able to do as expected","Passed","2025-01-04","Nack"]
[null,null,null,null,"Handy","Set state to MENUBACK","Transition to SECTION screen"]
[null,null,null,null,"Handy","Set state to DONE","Transition to ENTKEY screen"]
[null,null,null,null,"Handy","Set state to PCSCAN","Transition to PCSCAN screen"]
[null,null,null,null,"Handy","Set state to CHKBGN","Transition to CHKBGN screen"]
[null,null,null,null,"Handy","Set state to RDYPRT","Transition to RDYPRINT screen"]
[null,null,null,null,"Handy","Set state to SHUTDOWN","Transition to QUIT"]
[null,null,null,null,"Handy","Scan palette\nStart \"A\" | \"L\" & LEN=31","Able to update data","Able to do as expected","Passed","2025-01-04","Nack"]
[null,null,null,null,"Handy","Get PLAN information after scan base label","Able to get data","Able to do as expected","Passed","2025-01-04","Nack",null,null,"SELECT * FROM PLAN WHERE PicsType = 'KD' and CstmId = 'C' and CstmCode = 'AAT' and Kukuri = '20170200' and Line = 'T1' and Msc = 'DV02MH1' and Pnt = 'A4D' and Trm = 'DW6' and Lot = '324' and Gr = 'TA' and Seq = '01'"]
[null,null,null,null,"Handy","Get SECTION information after scan base label","Able to get data","Able to do as expected","Passed","2025-01-04","Nack",null,null,"SELECT * FROM SECTION WHERE CenterCode = 'TR1' and SectionID = 'A' and Section = 'TRT1N001'"]
[null,null,null,null,"Handy","Update Seq to SECTION after scan","Able to update data","Able to do as expected","Passed","2025-01-04","Nack",null,null,"UPDATE SECTION SET Seq='000002' WHERE CenterCode = 'TR1' and SectionID = 'A' and Section = 'TRT1N001'"]
[null,null,null,null,"Handy","Update details to PLAN after scan","Able to update data","Able to do as expected","Passed","2025-01-04","Nack",null,null,"UPDATE PLAN SET Flag='1' , DateStartJ='20250104' , TimeStartJ='150555' WHERE PicsType = 'KD' and CstmId = 'C' and CstmCode = 'AAT' and Kukuri = '20170200' and Line = 'T1' and Msc = 'DV02MH1' and Pnt = 'A4D' and Trm = 'DW6' and Lot = '324' and Gr = 'TA' and Seq = '01'"]
[null,null,null,null,"Handy","Get SPM information after scan base label","Able to get data","Data not found","Failed","2025-01-04","Nack",null,null,"SELECT * FROM SPM WHERE YYYYMMDD = '20170200' and PicsType = 'KD' and CstmId = 'C' and CstmCode = 'AAT' and Msc = 'DV02MH1' and Pnt = 'A4D' and Trm = 'DW6' and Gr = 'TA' and CartonFrom = '     ' and CartonTo = '     ' and PartNo = '          ' and PartID = '  ' and PartCL = '  ' and PartZnc = ' '"]

{"sheet":"barcode","index":1,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["admin",{"$f":"Code128(A1)","v":""}]
[]
["OCMENUBACK",{"$f":"Code128(A3)","v":""},null,null,null,null,null,{"$f":"Code39Mod43(SUBSTITUTE(A3,\"*\",\"\"))","v":"!OCMENUBACK6!"}]
[]
["J693003",{"$f":"Code128(A5)","v":""}]

{"sheet":"TestBarcode","index":2,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,2,0,12],[25,2,28,12],[13,2,16,12],[17,2,20,12],[21,2,24,12]]}
["Type","Content","Barcode"]
["User","J693003x",{"$f":"Code39Mod43(LEFT(SUBSTITUTE(B2,\"*\",\"\"), LEN(SUBSTITUTE(B2,\"*\",\"\"))-1))","v":"!J693003/!"}]
[]
["Base Label","*ADV02MH1A4DDW6324TA0120170200T17*",{"$f":"Code39Mod43(LEFT(SUBSTITUTE(B4,\"*\",\"\"), LEN(SUBSTITUTE(B4,\"*\",\"\"))-1))","v":"!ADV02MH1A4DDW6324TA0120170200T17!"}]
[]
["Section","*GTR1  ATRT1N001B*",{"$f":"Code39Mod43(LEFT(SUBSTITUTE(B6,\"*\",\"\"), LEN(SUBSTITUTE(B6,\"*\",\"\"))-1))","v":"!GTR1==ATRT1N001B!"}]
[]
["IPADDRS","*OP192168001176x*",{"$f":"Code39Mod43(LEFT(SUBSTITUTE(B8,\"*\",\"\"), LEN(SUBSTITUTE(B8,\"*\",\"\"))-1))","v":"!OP1921680011765!"}]
[]
["Location","*PDB2M508V1    00020000446S*",{"$f":"Code39Mod43(LEFT(SUBSTITUTE(B10,\"*\",\"\"), LEN(SUBSTITUTE(B10,\"*\",\"\"))-1))","v":"!PDB2M508V1====00020000446S!"}]
["N060S"]
["Part No."]
[]
["Location","*PDB2M508V2    00020000447U*"]
["N061S"]
["Part No."]
[]
["Location","*PDB2M508W1    00020000457V*"]
["N062S"]
["Part No."]
[]
["Location","*PDB2M508W2    00020000449X*"]
["N063S"]
["Part No."]
[]
["Location","*PDB2M50M50B   00020000543T*"]
["N075S"]
["Part No."]
[]
["Carton Label","*CDV02MH1A4DDW6324TA0109975/*",{"$f":"Code39Mod43(LEFT(SUBSTITUTE(B30,\"*\",\"\"), LEN(SUBSTITUTE(B30,\"*\",\"\"))-1))","v":"!CDV02MH1A4DDW6324TA0109975/!"}]
[]
[]
["Set state to MENUBACK","*OCMENUBACKx*",{"$f":"Code39Mod43(LEFT(SUBSTITUTE(B33,\"*\",\"\"), LEN(SUBSTITUTE(B33,\"*\",\"\"))-1))","v":"!OCMENUBACK6!"}]
[]
["Set state to SHUTDOWN","*OCSHUTDOWNx*",{"$f":"Code39Mod43(LEFT(SUBSTITUTE(B35,\"*\",\"\"), LEN(SUBSTITUTE(B35,\"*\",\"\"))-1))","v":"!OCSHUTDOWNH!"}]
[]
["Set state to CHGBGN"]
["Set state to RDYPRT"]
["Set state to SHUTDOWN"]