{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BD87toWE19","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"BD87toWE19","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Q01 [Quality Assurance]","IDOC"]
["IDoc 0000000136751916 was saved but cannot or should not be processed","136751436"]
["IDoc 0000000136751917 was saved but cannot or should not be processed","136751437"]
["IDoc 0000000136751918 was saved but cannot or should not be processed","136751438"]
["IDoc 0000000136751919 was saved but cannot or should not be processed","136751439"]
["IDoc 0000000136751925 was saved but cannot or should not be processed","136751440"]
["IDoc 0000000136751950 was saved but cannot or should not be processed","136751441"]
["IDoc 0000000136751960 was saved but cannot or should not be processed","136751442"]
["IDoc 0000000136751964 was saved but cannot or should not be processed","136751443"]
["IDoc 0000000136751965 was saved but cannot or should not be processed","136751444"]
["IDoc 0000000136751968 was saved but cannot or should not be processed","136751445"]
["IDoc 0000000136751969 was saved but cannot or should not be processed","136751446"]
["IDoc 0000000136751970 was saved but cannot or should not be processed","136751447"]

{"sheet":"Instructions","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Put the description of the SAP server in Cell A1 of the BD87toWE19 tab.  This is how the tool knows to which SAP server to connect. \n\nThis tool is provided with no warranty, expressed or implied.  Always test this tool thoroughly in a sandbox before using it in a production system to ensure that it works as desired. "]
["This tool is designed to find failed IDOCs in BD87 for which the error message is \"The interval 01 was not found\" and then automatically recreate those same IDOCs in WE19 without EAN11 or NUMTP (EAN and EAN Type) values. This recurring failure was caused by EAN ranges in the production system missing in sandbox systems. \n\nThis code can be recycled to solve any recurring problem with inbound IDOCs including deleting invalid lines.  Just ensure that the user has access to the transactions BD87 and WE19.  "]
["Speed up the process of finding the failed IDOCs by putting the IDOC Message Type in the code of the GetIDOCS() function.  On a busy system, this can save several seconds."]
["This code is also a great example of how to access and manipulate the TreeView and GridView objects.  The interface of the WE19 transaction is very confusing, but code to handle it is documented in the VBA to make it easily recyclable."]