{"id":2036,"date":"2014-11-19T19:44:07","date_gmt":"2014-11-19T19:44:07","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=2036"},"modified":"2014-11-19T19:44:07","modified_gmt":"2014-11-19T19:44:07","slug":"importing-reports-to-excel","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/importing-reports-to-excel\/","title":{"rendered":"Importing Reports to Excel"},"content":{"rendered":"

Some users want to import reports to Excel. The problem is that the first position of the spool file is a carriage control character. This does not import well into Excel. This script will prompt you for a spool file name, and the path and location where it isto be placed on the PC.\u00a0 Read the file into the HP editor, strip the carriage control character from the file, save it, and download the edited file to the PC. Prompt for the spool file on the HP. Only the name of the spool file is needed; the group and account will be appended.<\/span><\/p>\n

\n
\n
\n
\n
\n
LET HEADER = “Spool File”
\nLET PROMPT = “Please Enter the Spool file name ‘onnnn’ :”
\nACCEPT SPOOL
\nPrompt for the path and file name where the file is to be placed on the PC.
\nLET HEADER = “PC Path and File Name”
\nLET PROMPT = “Please enter the PC file name including the full Path”
\nACCEPT PCFILE
\nAppend the group and account to the spool file name.
\nLET SPOOLFIL = SPOOL & “.OUT.HPSPOOL^M”
\nLET EDFILE = “T ” & SPOOLFIL
\nRun HP’s editor and text in the spool file.
\nKBSTRING editor
\nKBSPEC HP_RETRNKEY
\nWAITS “\/^Q”
\nTRANSMIT EDFILE
\nKBSPEC HP_RETRNKEY
\nWAITS “\/^Q”
\nRemove the first position from the spool file–this is the carriage control character.
\nKBSTRING cq 1\/1 to “” in all
\nKBSPEC HP_RETRNKEY
\nWAITS “\/^Q”
\nKeep the file to a name that can be used for the download.
\nKBSTRING k WS92xxx,unn
\nKBSPEC HP_RETRNKEY
\nWAITS “^Q”
\nKBSTRING y
\nKBSPEC HP_RETRNKEY
\nWAITS “^Q”
\nKBSTRING E
\nKBSPEC HP_RETRNKEY
\nWAIT 00:00:02
\nTransfer the edited file to the PC.
\nHOSTF WS92XXX
\nLOCF\u00a0 PCFILE
\nRECSIZE 256
\nASCII
\nDOWNLOAD
\nEND<\/span><\/dd>\n<\/dl>\n<\/dd>\n<\/dl>\n<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Some users want to import reports to Excel. The problem is that the first position of the spool file is a carriage control character. This does not import well into Excel. This script will prompt you for a spool file name, and the path and location where it isto be placed on the PC.\u00a0 Read […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,62],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2036"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=2036"}],"version-history":[{"count":1,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2036\/revisions"}],"predecessor-version":[{"id":2037,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2036\/revisions\/2037"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=2036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=2036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=2036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}