Manman to Microsoft Toolbox
Contents
1. to Microsoft T oolbox User M anual Summit Systems Inc 308 Orchard Ave St Louis Mo 63119 2526 Phone 314 963 9021 Fax 314 968 4122 Email SummitSys aol com Web www sumsystems com Version 1 0 May 2007 Manman is a registered trademark of Infor Global Solutions to Microsoft T oolbox Contents Features of Manman to Microsoft 01 2 Installation Instructi nsS ca ea ee eee eee eed ee ga raa 3 Extract Processes 5 Manman to Microsoft Toolbox 6 Manman to Microsoft Toolbox Omar and 10 Extract File casas ceri cobrar vex 13 Extract File Format i pu u E wa ow 48 Xo P er d a Pe a ee ah 16 Transaction Log EXER aC ts AUR XR Cae x eed Aura x 17 Moving the Files to 5 21 importing Fres to Excel esie dra x acea e Acid dead 24 Extract and Capacity cae sea ind Sid Cr eed Kad dace a 25 Access Import Appl eati 0nS cese etre eee ae vete vede aes 27 2 Features of Manman to Microsoft Toolbox Features to Microsoft T oolbox Features The Manman to Microsoft Toolbox is designed to help your company with your data extraction data conversion and archiving requirements It pro2. Financials Extract to Microsoft T oolbox Omar Shipping History and Financials The EXTRACTF programis used to create flat ASCII files fromthe Manman OMAR Accounts Payable and General Ledger modules Before executing the EXTRACTF program it is recommended that you log on to a Group on the HP3000 that is empty For example CHGROUP OMFILES RUN EXTRACTF SUMMI T MMV110 The EXTRACTF program will allow you to select al OMAR records or a subset of your OMAR records that you work with a subset of your OMAR data ini have your extract file transfer and Windows I mp working effectively of your t is recommended tially until you ort processes A subset of the OMAR FINDB records can be extracted based on the Product Master records Product Type The data fromthe Shipping History database may also be extracted for a selected Product Type The Accounts Payable and General Ledger extracts do not have the capability to select a subset of the information All of the Accounts Payable database and General Ledger database is extracted by these two processes Prompts The following are the prompts in the EXTRACTF process WHICH EXTRACT WOULD YOU LIKE TO EXECUTE 1 OMAR FI NDB TABDB 2 SHIPPING HI STORY HI SDB 3 ACCOUNTS PAYABLE PAYDB VNDDB 4 GENERAL LEDGER GLDB OPTI ON 1 The EXTRACTF program allows you to do 4 different extracts If you select extract option 1 OMAR the followin
3. ANY NEWGROUP HSFILES ACCESS R W A L X S ANY NEWGROUP APFILES ACCESS R A L X S ANY NEWGROUP GLFILES ACCESS R W A L X S ANY Extract Process Overview Running the E xtract Processes The purpose of this section is to give you a general overview of the Manman extract processes on the HP3000 Here are some things to know before you run the extract programs 1 The Extract programs are designed to be run from the colon prompt There are 2 extract programs RUN EXTRACTM SUMMI T MMV110 Manufacturing RUN EXTRACTF SUMMI T MMV110 Omar and Financials 2 Each Extract program creates a series of flat ASCII files on the HP3000 The flat files created are named the same as the dataset they are derived from For example here are the files created by the Manufacturing database extract CHGROUP MGFI LES LISTF FI LENAME ACCTXREF ASSEMB CCFIL DEPTREC DFACFIL ECOCMT ECOMAS ECOREC EXTDFIL FAMLNK INTFI L INVFI L NVLMAS LDFIL MPSPLAN MRPPLAN NCFIL ODF OWOF PSF TCFIL TRFIL WCFIL WOS HT WOTR 3 Each extract file will contain every field in the dataset This will allow you to continue to use your Manman database guide as a reference for where the field resides and what its definition is 4 The extract files created will reside in your local Group on the HP3000 Therefore it is recommended that you log on in a Group that is empty and specific to where you want the files to
4. Manman to Microsoft Toolbox Omar and Financials 4 OMAR mdb 5 ShippingHistory mdb 6 mdb 7 GL mdb 26 Extract and Capacity Limits Extract and Capacity Limits A Microsoft Access database mdb file has a 2GB maximum size We have reviewed the size of Manman databases on many customers HP3000 and have yet to find a customer whose databases exceed this limit If Microsft Access is not your target platform Microsoft provides an SQL Server migration assistant SSMA for Access utility A multitude of other MS Access to Database X 3rd party migration utilities are also available on the market You can find move information on SQL and Microsoft Access in the documentation included on your CD Access Import Applications Microsoft Access Import Applications At this point we presume you have moved the extract files from the HP3000 they reside on your PC Windows server in a directory all by themselves and that the extract files have a TXT suffix The purpose of this section is to provide you with an overview of the Microsoft Access Import Applications we provided you on you CD The CD will contain up to 4 Microsoft Access Migration programs The Manman to Microsoft Toolbox Manufacturing Product includes these 2 programs Mi grateMFG Creates Manufacturing mdb and Purchasing mdb Mi grateTL Creates Translog mdb The Manman to Microsoft Toolbox for Omar and Financials includes the programs Mi grat eOMAR Creates OMAR
5. Pages printed Records selected Pages printed EXTRACTING IM Records selected Pages printed Records selected Pages printed EXTRACTING OWOF Records selected Pages printed Records selected Pages printed Records selected Pages printed EXTRACTING INVLMAS 6510 1 1422 1 EXTRACTING CCFIL 0 EXTRACTING DFACFIL 1724 1 24758 1 715 EXTRACTING WCFIL 219 EXTRACTING ECOMAS 15 EXTRACTING DEPTREC Records selected Pages printed Records selected Pages printed Records selected Pages printed Records selected Pages printed Records selected Pages printed Records selected Pages printed Records selected Pages printed EXTRACTING NCFIL Records selected Pages printed EXTRACTING ODF Records selected Pages printed EXTRACTING PSF Records selected Pages printed EXTRACTING TCFIL Records selected Pages printed EXTRACTING TRFIL Records selected Pages printed EXTRACTING WOSHT Records selected Pages printed EXTRACTING WOTR Records selected Pages printed Records selected Pages printed Records selected Pages printed Records selected Pages printed LISTF ACCTXREF ECOMAS ECOREC NVFIL NVLMAS ODF OWOF WOS HT WOTR ASSEMB PRINT I NVFIL END 1 EXTRACTING EXTDFIL EXTRACT PROCESS COMPLETED 55 1 818 1 EXTRACTING INTFIL 18248 1 EXTRACTING INVFIL 2
6. Reflection file transfer Applying the TXT suffix 23 Moving the Files to Windows you use the FTP MPUT or MGET commands or do a Reflection e transfer the file names on the Windows Server PC will not the required TXT suffix However applying the TXT fix can be accomplished with one simple MS DOS command CD mgfiles RENAME TXT To reach the MS DOS command prompt on your PC click on START RUN enter CMD 24 Importing Files to Excel Importing Files to Excel Using the to Microsoft T oolbox with Excel Although the Manman to Microsoft Toolbox product includes Microsoft Access Import programs often an Excel spreadsheeet will satisfy your requirements This section describes how to import a single extract file on the HP3000 to an Excel spreadsheet on your PC A visual example is found on the proceding page 1 Click on File then File Transfer using Reflection or Minisoft You must be at the HP3000 colon prompt to do a file transfer 2 Select a host file name to download In our example we used the MRPPLAN file 3 Select a file transfer type of ASCII 4 Select a local file name and directory or desktop for the file Apply a XLS suffix to the local file name For example MRPPLAN XLS 5 Launch Excel DO NOT DOUBLE CLICK ON MRPPLAN XLS Double clicking on the file bypasses the text import wizard in Excel Instead launch Excel and do a FILE amp OPEN Choose the file MPRPLAN XL
7. reside This will help you with your file transfer to the Windows platform For example CHGROUP MGFILES 0r HELLO MANAGER ACCOUNT MGFILES PURGE RUN EXTRACTM SUMMI T MMV110 6 EXTRACTM Manufacturing Extractanufacturing Extract to Microsoft T oolbox M anufacturing The EXTRACTM programis used to create flat ASCII files fromthe Manman Manufacturing module Before executing the EXTRACTM program it is recommended that you log on to a Group on the HP3000 that is empty example CHGROUP PUFILES RUN EXTRACTM SUMMI T MMV110 The EXTRACTM program will allow you to select all of your Manufacturing records or a subset of your Manufacturing records It is recommended that you work with a subset of your Manufacturing data initially until you have your extract file transfer and Windows Import processes working effectively A subset of the Manufacturing MANDB records can be extracted based on an Item Master Class Code This can be either class code group 1 2 3 or 4 Upon selecting the Item Master records associated with the class code additional item master records may also be included that have the following attributes 1 Have a bill of material relationship with the original item master records selected 2 Are associated with work order records that the origi nal item master records selected also are A subset of the Purchasing PURDB records can be extracted based on purchase order date e
8. view by clicking on the tables object For additional information on how to use Microsoft Access we recommend the visual instruction book Access 2003 Quick Steps from McGraw Hill Osborne publishing ISBN 0 07 223229 3 Example of the Microsoft Access Import Program MigrateMFG Data Migration Tool Application Interface 2 File Edit View Insert Format Records Tools Window Help Run Program Errors Administration Exceptions Click to Select Database Folder L n Location C AccessPURFiles Manufacturing mdb lv e Purchasing md gt 7 gt 195 ID Click the button above to select the folder where you want the two Access databases created By default a subfolder DFACFIL txt IMAMAN willbe created ECOCMT txt ECOMAS txt ECOREC txt EXTDFIL txt Type the names of the two Access Databases to create 4 Click to import data INTFIL txt PRLFIL txt PRXFIL txt RCHSFIL txt REASMAS txt RECNMAS txt SHPFIL txt SNFIL txt SNPOFIL Ext TERMMAS txt V1099FIL txt VNCRFIL txt VNDMAS txt VNDSFIL txt 9 Click the buttons to the right to select the Folders the text files For the Access databases reside Form View 1 Click on the large button in the top left Click to Select Database Folder This will allow you to browse and select what directory to store the Microsoft Access Database that gets created By defaul
9. you selected extract option 2 Purchasing the following prompt will appear PURCHASE ORDER DATE OPTI ON 1 EXTRACT ALL PURCHASING DATA RECORDS 2 EXTRACT PURCHASE ORDERS ADDED DURING A RANGE OF DATES OPTI ON 2 Select option 1 to extract the entire Manman Purchasing database If you choose option 2 the following prompts will appear ENTER BEGI NNI NG PURCHASE ORDER ADD DATE IN YYYYMMDD FORMAT ENTER ENDI NG PURCHASE ORDER ADD DATE IN YYYYMMDD FORMAT Enter a range of dates in YYYYMMDD selection is made on the POADD date field in the POMAS dataset 8 EXTRACTM Manufacturing Extractanufacturing Extract If you selected extract option 3 Transaction Logs the following prompts will appear CALCULATE MONTHLY PART USAGE AFTER EXTRACTI NG THE TRANSACTI ON LOGS N One of the benefits to the Transaction Log extract function is that an additional extract file can be created which will store mo nt hl y record January to December for 4 years on what a part s usage is responding Y to the prompt above an additional process to build this file will be launched at the oe of extracting and reformatting the transaction log records SELECT TRANSACTION LOGS 1 BY DATE RANGE 2 CURRENT TRANSACTION LOG 3 BY NAME ENTER TO LIST OPTI ON 1 If you enter a question mark all of the transaction log files that appear in your manufacturing data base will be listed on the screen The transaction log
10. 23 will result in the following dataset _ J IM Table esc INLOC XL NC010 F2A EA CONAMER 06283 XL 252 F12 EA CONAMER 78 LLAE E671C 78 XL NCO1O FIA EA CONAMER FldOp optional if the comparison is made for two values at the same time this field is used to state Op first operator for the selected field gt lt Default value is Value2 second comparison value Saving a filter for later use After setting the search criteria go to the text box in the lower left enter the name you want for the filter and click Save Filter As The filter will be retrievable from the Select Filter Name drop down list The saved filters depend on the table name and workstation name In this way various users can build different filters with the same names for the same table query without interfering Retrieving a saved filter Select the data set then expand the Select Filter Name drop down list and choose the desired filter Button description Save Filter As allows you to change an ad hoc filter into a saved filter Enter the name of the filter and click the Save Filter As button or press Alt S Delete Filter allows you to delete the filter defined on the screen Click or press Alt D Show All Records will open the table displayed in the Select Form To Filter drop down list Click or press Alt W This oper
11. 94 EXTRACTING LDFIL 2723 1 EXTRACTING MPSPLAN 2 EXTRACTING MRPPLAN 10368 1 265484 1 713 1 6882 1 713 EXTRACTING ECOCMT EXTRACTING ECOREC EXTRACTING FAMLNK 0 1 3 31 PM CCFIL DEPTREC DFACFIL EXTDFIL FAMLNK LDFIL MPSPLAN MRPPLAN PSF TCFIL TRFIL ECOCMT I NTFIL NCFIL WCFIL 18 601243 0000000 600 20060426 CONAMER 0000005 374 00000 1234 0000 00000000 000 00000000 63040 008 20060426 100255 K K KKK K KK k K K K K k Kk K k k k k k k k k k k k k k k k kk k k k kkk kk kkk kkk kk kkk kkk kkk kkk Example of running the EXTRACTM program to export Y Transaction Log Records and create a file of monthly usage for each part number K kK KK K KK k K K K K k K K K k K k k k k k k k k k k k k k kk kk k k kk kk kkk kk kkk kkk kkk kkk kkk RUN EXTRACTM SUMMI T MMV110 Manman Manufacturing Extract Utility v1 WHI CH EXTRACT WOULD YOU LIKE TO EXECUTE 1 MANUFACTURING MANDB RESDB 2 PURCHASING PURDB VNDDB B TRANSACTION LOGS DPTION 1 3 MANUFACTURING DATA BASE NUMBER 0 CALCULATE MONTHLY PART USAGE AFTER EXTRACTI NG THE TRANSACTION LOGS N Y BEGINNING EXTRACT PROCESS 8 34 AM SELECT TRANSACTION LOGS 1 BY DATE RANGE 2 CURRENT TRANSACTION LOG TR001264 8 BY NAME enter to list OPTION 1 1 STARTING DATE 4 1 Records selected 58255 Creating extract file BEGINNING REFORMAT P
12. L OPTCHG PYTMAS SHDFIL SOEFIL SERFIL CKFIL MAS VNDMAS CIAFIL CIDFIL CUSFIL CUSTMAS GLMAS HLDMAS OPTFIL PRDPCFIL REMAS RMT MAS SHIPFIL SHPHI 5 STFIL TAXMAS SHDFIL SHI PFIL DEFACMAS NRCTFIL TERMMAS VATFIL ALTFIL AMTFI L BUDFIL BUDMAS JETFIL JVFIL RPTMAS TCMFIL 16 Extract File Format Extract File Format The Format of the Extract Files Created This section describes the how the data elements Fields from the Manman system are formatted in the Extract files The Delimiter Each data element is delimited separated by the Bar character This is often refered to as the pipe character An example of how the Bar is used to separate each field is shown below This is the OMAR payment terms file PYTMAS of TABDB PRINT 5 OMFILES 00001 30 DAYS 00035 00000 00000000 000 00002 NET 60 DAYS 00065 00000 00000000 000 00003 90 00095 00000 00000000 000 00004 170 10 NET 30 00037 00016 000000000 10 00005 1 10 NET 60 00065 00016 000000000 10 00006 1 10 NET 90 00095 00016 000000000 10 000071 2 10 NET 30 00035 00016 000000000 20 00009 2 10 NET 90 00095 00016 000000000 20 00010 2 45 NET 60 00065 00045 000000000 20 Dates All of the dates in the Manman system have been identified The extract programs convert the date from proprietary Manman format to the standard YYYYMMDD format in the extract files created Numeric Fields There are 4 different types of numer
13. MAR DATA BASE NUMBER 0 0 BEGINNING EXTRACT PROCESS 1 20 PM PRODUCT TYPE 100 Records selected 1440 FINDING SALES ORDERS ASSOCIATED WITH THE PRODUCTS SELECTED Records selected 1155 FINDING INVOICES ASSOCIATED WITH THE PRODUCTS SELECTED Records selected 1456 EXTRACTING BILMAS Records selected 2847 Pages printed 1 EXTRACTING GLMAS Records selected 4841 Pages printed 1 EXTRACTING PROMAS Records selected 1440 Pages printed 1 EXTRACTING IM Records selected 52562 Pages printed 1 EXTRACTING PTMAS Records selected 706 Pages printed 1 EXTRACTING SALMAS Records selected 125 Pages printed 1 Records selected 42 Pages printed 1 Records selected 85 Pages printed 1 Records selected 99 Pages printed 1 Records selected 102 Pages printed 1 Records selected 24 Records selected 48 Pages printed 1 Records selected 566 Pages printed 1 Records selected 171 Pages printed 1 Records selected 15 Pages printed 1 Records selected 1701 Pages printed 1 EXTRACTING AIFIL Records selected 9513 Pages printed 1 EXTRACTING ARFIL Records selected 972 Pages printed 1 EXTRACTING CHAFIL Records selected 1774 Pages printed 1 EXTRACTING CIAFIL Records selected 1741 Pages printed 1 EXTRACTING CIDFIL Records selected 4005 Pages printed 1 EXTRACTING CMFIL Records selected 972 Pages printed 1 EXTRACTING COMFIL Recor
14. ROCESS 8 36 AM FORMATTING TRANSACTION LOG EXTRACT FILE Records selected 58255 Pages printed 1 EXTRACTING IM Records selected 52562 Pages printed 1 BUILDING ORDER KEYS FROM TLOG EXTRACT FILE 1 Records selected 56958 BUILDING ORDER KEYS FROM TLOG EXTRACT FILE 2 Records selected 1801 BUILDING ORDER KEYS FROM TLOG EXTRACT FILE 3 Records selected 3574 BUILDING ORDER KEYS FROM TLOG EXTRACT FILE 4 Records selected 3764 Pages printed 1 CALCULATING PART USAGE PROCESS 8 39 AM CALCULATING PARTS USAGE FILE ENTER THE YEAR OF THE MOST RECENT DATA EXTRACTED YYYY 2007 Records selected 47857 Records selected 2505 Pages printed 1 EXTRACT PROCESS COMPLETED 8 39 AM KK KKK K KK K K K K K K KK K k K k k k k k k k k kK k k k k kk kk k k kk kk kk kkk kkk kk kkk kk kkk kkk Example of running the EXTRACTF program and extracting OMAR data for a selected product type KKK KK K KK KKK K K k K K K K K K k k k K kK K K K k k k k k kK KK k k k k k kkk kk k k kk kkk kk kkk kkk kk k CHGROUP OMFILES RUN EXTRACTF SUMMI T MMV110 Omar Shipping and Financials Extract Utility v1 WHI CH EXTRACT WOULD YOU LIKE TO EXECUTE 1 OMAR FI NDB TABDB 2 SHIPPING HI STORY HI SDB 3 ACCOUNTS PAYABLE PAYDB VNDDB 4 GENERAL LEDGER GLDB OPTION 1 1 PRODUCT TYPE OPTION 1 EXTRACT ALL PRODUCT TYPES 2 EXTRACT A SELECTED PRODUCT TYPE OPTION 1 2 Pages printed O
15. S from your list of Excel files Upon doing so the Text Import Wizard will be launched 6 Select the delimited file type not fixed width Click Next 7 Click on other for the delimiter and insert a Bar in the box next to the other checkbox The Bar is a shift backslash on your keyboard Click Next 8 By default each column in Excel defines the variable as general You have the option of clicking on specific columns and redefining them as dates or text 9 Your spreadsheet should now be imported Click on Format Column Auto Fit selection to display the full contents of each column Click on File Save As and save as Excel Workbook format instead of delimited format Excel Limitations There is a maxi mum of 65 534 rows records that you can impo into Excel Therefore if you download a file from the HP3000 contains more than 65 534 records only the first 65 534 will i mported rt that be Microsoft Excel 2007 no longer has the 65 534 limit The new limit is 1 000 000 records Example of using the Manman to Microsoft Toolbox with Excel File Transfer Local Host Local file names I Host file names m 44 bh MRPPLAN XLS MRPPLAN MGFILES 62 957 Ed 967 is America Online Transfer Protocol WRQ R ellection v BOM_Sample Transfer type 24 bomout ASCII HP 3000 Host If file exists 3 Show Host Files Command View lt Ask User Local directo
16. USAGE Part Usage Table This file creates one record per part number Year 1 represents the year of the most recent transaction log exported For example if you exported transaction logs from 2001 to 2003 Year 1 would represent the usage of the part for each month of 2003 Year 2 would represent the usage of the part for each month of 2002 Year 3 would represent the usage of the part for each year in 2001 Year 4 would be zero TUPARTNO Part Number A18 key TUYEAR A4 year YYYY representing year 1 TUY1M 12 Usage Year 1 January TUY1M2 12 Usage Year 1 February TUY1M3 12 Usage Year 1 March TUY1M 12 Usage Year 1 Apri TUY1M5 12 Usage Year 1 TUY1M6 12 Usage Year 1 June TUYIM7 12 Usage Year 1 July TUY1M8 12 Usage Year 1 August TUY1M9 12 Usage Year 1 September TUY1M10 12 Usage Year 1 October TUY1M11 12 Usage Year 1 November TUY1M12 12 Usage Year 1 December TUY2M 12 Usage Year 2 January TUY2M2 12 Usage Year 2 February TUY2M3 12 Usage Year 2 March TUY2M4 12 Usage Year 2 Apri TUY2M5 12 Usage Year 2 May TUY2M6 12 Usage Year 2 June TUY2M7 12 Usage Year 2 July TUY2M8 12 Usage Year 2 August TUY2M9 12 Usage Year 2 September TUY2M10 12 Usage Year 2 October TUY2M11 12 Usage Year 2 November TUY2M12 12 Usage Year 2 December TUY3M 12 Usage Year 3 January TUY3M2 12 Usage Year 3 February TUY3M3 12 Usage Year 3 March TUY3M4 12 Usage Year 3 Apri TUY3M5 12 Usage Year 3 May TUY3M6 12 Usage Year 3 June TUY3M7 12 Usage Year 3 July TU
17. Y3M8 12 Usage Year 3 August TUY3M9 12 Usage Year 3 September TUY3M10 12 Usage Year 3 October TUY3M11 12 Usage Year 3 November TUY3M12 12 Usage Year 3 December TUYAM 12 Usage Year 4 January TUY4M2 12 Usage Year 4 February TUY4M3 12 Usage Year 4 March TUY4M4 12 Usage Year 4 Apri TUY4M5 12 Usage Year 4 May 20 TUY4M6 12 TUY4M7 12 TUY4M8 12 TUY4M9 12 TUY4M10 12 TUY4M11 12 TUY4M12 12 Usage Usage Usage Usage Usage Usage Usage Year Year Year Year Year Year Year 4 4 Transaction Log E xtracts Transaction Log Extracts June July August September October November December 21 Moving the Files to Windows Moving the Files to your Windows Server or PC ou intend on using Excel instead of Microsoft Access refer he next section of this manual Importing files to Excel intend to use the Microsoft Access Import programs that we there 2 rules that need to be adhered to when moving es to your PC or Windows Server 1 The files should be moved to a folder directory that will contain only the files to be imported In other words an empty folder 2 The files must be suffixed with the txt suffix For example the IM file would be named IM TXT on your PC There are 2 primary methods of moving your extract files from the HP3000 to your PC Windows Server FTP File Transfer Protocol or an ASCII File Transfer using your Terminal Emulator Reflec t lection or so
18. ation will remove the filter form from the screen before the table is displayed The filter form will show up again when the table is closed Apply Filter will apply the filter on the form displayed in the Select Table To Filter drop down list Click or press Alt A K K KKK K KK K K k K K k K K K k K k k k k k k k k k k k k k kk kk k kkk kk kk kkk kkk kkk kkk kkk kkk Example of running the EXTRACTM program and extracting manufacturing data for a selected class code KKK KKK KKK KKK RR KKK k X 523 OCC EO k k OG XX KKK RK X G X X GG X X CHGROUP MGFILES RUN SUMMI T MMV110 Manman Manufacturing Extract Utility v1 WHICH EXTRACT WOULD YOU LIKE TO EXECUTE 1 MANUFACTURING MANDB RESDB 2 PURCHASING PURDB VNDDB 3 TRANSACTION LOGS OPTION 1 1 MANUFACTURING DATA BASE NUMBER 0 0 CLASS CODE OPTION 1 EXTRACT ALL CLASS CODES 2 EXTRACT A SELECTED CLASS CODE OPTION 2 2 BEGINNING EXTRACT PROCESS 3 27 PM SELECT PARTS BASED ON WHICH CLASS CODE GROUP 1 2 3 4 2 CLASS CODE 100 Records selected 1469 Records selected 10368 Records selected 178 Records selected 1469 Records selected 715 Records selected 374 Records selected 1089 Records selected 715 Records selected 12730 EXTRACTING ACCTXREF Records selected Pages printed EXTRACTING 55 Records selected Pages printed Records selected
19. available to you However extracting and reformatting hundreds of thousands of records does require a lot of processing time The extract processes may be run during the day along with your normal Manman users If you will be extracting entire databases it is recommended that you try to do so off hours selected product type or selected class code extracts execute in the normal HP3000 Batch Queue DS The entire database extract processes execute in the low priority HP3000 Batch Queue ES The extract files created will be approximately the same size as the database they were extracted from There is no reason for any HP3000 to have less than 30 free space Disk space is at all time record low prices 9GB disk drives are available for less than 200 Buy one or two disks and take advantage of them have had a number of positive experiences with HP3000 hardware broker Genisys Corporation www Microsoft Access Table Limits u will be using the Microsoft Access Import processes that ncluded on your CD then be aware that a Microsoft Access a i If yo are i database does have a theoretical limit to the amount of data that t can hold Manman to Microsoft Toolbox Access component will create ifferent Access databases in a directory MANMAN on your dows server PC to Microsoft Toolbox Manufacturing 1 Manufacturing mbd 2 Purchasing mdb 3 Transl og mdb
20. crap transactions 11 Percent of Labor Last Operation scrap transactions 11 Reference Number 10 Receiver or Material Requisition Inventory Location from which Parts are Moved 10 Inventory Lot from Which Parts are Moved 18 Balance of Parts at the Inventory Location Lot From Which Parts are Moved R2 Inventory Location to which Parts are Moved 10 Inventory lot to which Parts are Moved 18 Balance of Parts at the Inventory Location Lot to which Parts are Moved 2 Quantity of the Part Issued Received or Scrapped R2 Nettable Quantity On Hand After Update R2 Debit Account Number A24 Credit Account Number A24 The Date the Transaction is Logged A8 The Time the Transaction is Logged A8 The User Entered Date A8 Log on Name A8 Command Number A6 Unit Value R4 Extended Unit Cost R4 Material Cost R4 Material Overhead Cost R2 Assembly Labor Cost R4 in Assembly Fixed Overhead Cost R2 Assembly Variable Overhead Cost R2 Assembly Third Overhead Cost R2 Assembly Outside Processing Cost R2 Assembly Outside Processing Overhead Cost R2 Component Labor Cost R4 in Component Fixed Overhead Cost R2 Component Variable Overhead Cost R2 Component Third Overhead Cost R2 Component Material Overhead Cost R2 Component Outside Processing Cost R2 Component Outside Processing Overhead Cost R2 Scrap Reason Code 2 Project Activity A16 Revision 2 19 Transaction Log E xtracts TL
21. ds selected 676 Pages printed 1 EXTRACTING ACCTXREF Records selected 1042 Pages printed 1 Records selected 0 Pages printed 1 EXTRACTING CUSFIL Records selected 7035 Pages printed 1 EXTRACTING GLDFIL Records selected 4406 Pages printed 1 EXTRACTING INFIL Records selected 2153 Pages printed 1 EXTRACTING OOE FILES Records selected 0 Pages printed 1 Records selected 756 Pages printed 1 Records selected 8 Pages printed 1 Records selected 20025 Pages printed 1 EXTRACTING SIFIL Records selected 13374 Pages printed 1 Records selected 815 Pages printed 1 EXTRACTING SODFIL Records selected 2871 Pages printed 1 EXTRACTING SOEFIL Records selected 676 Pages printed 1 EXTRACTING TOPFIL Records selected 0 Pages printed 1 EXTRACT PROCESS COMPLETED 1 23 PM LISTF FILENAME AL FIL ARFIL BI LMAS CHAFIL CI AFIL CIDFIL CMFIL COMFIL CRFIL CURPRFIL CUSFIL CUSTMAS FCMAS FRTMAS GLDFIL GLMAS HLDMAS NFIL OPTCHG OPTFIL PRDPCFIL PRIFIL PROMAS PTMAS PYTMAS REMAS RMT MAS SALMAS SCTMAS SIFIL SMFIL SODFIL SOEFIL STFIL TAXMAS TOPFIL PRINT SOEFIL ENDz1 10103 4899 001 4899 ALLIED SUPPLY INC 10828 SHADY TRAIL DAL LAS TX 75220 19321001 19321001 0704 00000 00000 00000 0000 1 IND 2 BESTWAY 30943 00005 00000 00000 00000 00001 00000000 000 00000 18991231 00000 00001 00084458 000844581 C USTX RELO8 02 SJ ACKSON
22. e files can all be referenced in the Manman database guides included on your CD Manman to Microsoft Toolbox Manufacturing MANUFACTURING MANDB RESDB CHGROUP MGFILES i LISTE FI LENAME ACCTXREF ASSEMB CCFIL DEPTREC DFACFIL ECOCMT ECOMAS ECOREC EXTDFIL FAMLNK INTFI L INVFI L INVLMAS LDFIL MPSPLAN MRPPLAN NCFIL ODF OWOF PSF TCFIL TRFIL WCFIL WOSHT WOTR B PURCHASING PURDB VNDDB CHGROUP PUFILES i LISTE FI LENAME CONTFIL RCHFIL PODSFIL POFIL POMAS POMMFIL PRAFIL PRAHFIL PRDSFIL PRHFIL PRLFIL PRXFIL RCHSFIL REASMAS RECNMAS SHPFIL SNFIL SNPOFIL TERMMAS V1099FIL VNCRFIL VNDMAS VNDSFIL C TRANSACTION LOGS CHGROUP TLFILES i LISTE FI LENAME ORDERFIL TLOGFIL TLUSAGE A Manman to Microsoft Toolbox Omar and Financials OMAR CHGROUP OMFILES FI NDB TABDB C D Extract File Names i LISTE FI LENAME AI FIL ARFIL BI LMAS CMFIL COMFIL CRFIL FCMAS FRTMAS FTN08 NFIL OPSFIL PRIFIL PROHI S PTMAS SALMAS SCTMAS SERFIL SIFIL SMFIL SODFIL TOPFIL SHIPPING HI STORY HISDB CHGROUP HSFILES i LISTE FI LENAME OPSFIL PROHI S SHPHI S ACCOUNTS PAYABLE PAYDB VNDDB CHGROUP APFILES i LISTE FI LENAME BATCHMAS BNKMAS CKCFIL PADFIL PDVCHFIL PGLMAS VATMAS VCHFIL FIL GENERAL LEDGER GLDB CHGROUP GLFILES i LISTE FI LENAME ACMFIL ADUFIL ALFFIL ATVMAS BASFIL BATMAS CLRMAS COMMAS GLPFIL J VMAS TMS RATFIL TRAMAS VPRFIL CHAFIL CURPRFIL GLDFI
23. e the table query to search In the filter form select the dataset to filter from the drop down list Select Table to Search The list contains all user tables native or linked from other sources and saved queries in the database except those used specifically designed for filtering Expand the list by clicking the arrow on the right side of the list or press Alt T ne 3 Filter Form neg Select Table to Search v Select Filter Name Details LineOp talue1 Fldop 2 v uvas Se C eu met Delete Fiter Show all records Fiter 3 Building an ad hoc filter After selecting the data set go to the detail section to define all filter elements Line Op operator for the entire line Leaving it blank will use a default of And It is used to concatenate the defined lines and create an advanced filter Field Name the name of the field to filter the drop down list contains all fields from the source 23 Filter Form 5 oles Select Table to Search Details LineOp FieldName Fldop Op2 Value2 Save Filter As gt _ gt Delete Filter Show all records Apply Filter ee 1 first operator for the selected field gt lt Between and so on Selecting Between will restrict the next criteria for that line Default value is Valuel the value used for the filter Example DOLCC 200408
24. f Using FTP on the HP3000 The fastest method to transfer data off of the HP3000 is using FTP You can initiate FTP and push the files from your HP3000 to your Windows server in the following manner RUN ARPA SYS OPEN 123 50 43 21 ip address of your Windows Server PC Enter the remote user name and password when prompted The open command Opens a connection to the remote server The PUT command will move push a single file from the HP3000 to your Windows server For example PUT M MGFILES MGFILES IM TXT Will move the IM item master extract file from the MGFILES group on the HP3000 to a directory called MGFILES on your server and apply a TXT flat ascii file suffix The MPUT command will push a group of files fromthe HP3000 to your Windows server is an example of pushing all of the files from a manufactuing extract to your Windows server 22 Moving the Files to Windows oving the Files to Windows CHGROUP MGFILES lt lt lt group where files reside RUN FTP SYS File Transfer Protocol 0012 08 Hewlett Packard Co 2002 ftp OPEN 147 82 21 237 lt lt lt ip address of windows server 220 USCTNOO3 Microsoft FTP Service Version 5 0 Connected to 147 82 21 237 INFO 40 Name manager anonymous lt lt lt user name of windows server 331 Anonymous access allowed send identity e mail name as password Password test lt lt lt password ofte
25. file names the date of the first transaction last transaction and whether the transaction log has been posted to the general ledger MG UT 555 will be displayed If you choose option number 1 the following two prompts appear BEGI NNI NG DATE ENDI NG DATE Upon entering a date range the first and last record of the transaction log files in your manufacturing data base group are retrieved and the program determines the number of transaction log files to read If you choose option number 2 then only the current transaction log file is read If you choose option number 3 then all of the transaction file names are listed the screen You will be allowed to enter the beginning and ending range of the numbers assigned to the transaction log file names This is the same criteria used by UT 801 and the other transaction log inquiry programs in Manman If you choose to create the monthly part usage file the following prompt will appear ENTER THE YEAR OF THE MOST RECENT DATA EXTRACTED YYYY This prompt is used to align the usage numbers properly in the usage record Enter the year of the most recent transaction log record that was included in your extract EXTRACTM Manufacturing Extract At this point the extract programs will run and display progress messages for the major datasets being extracted The Transaction Log extract will display progress after every 2500 records read 10 EXTRACTF Omar and Financials
26. g prompt will appear PRODUCT TYPE OPTION 1 EXTRACT ALL PRODUCT TYPES 2 EXTRACT A SELECTED PRODUCT TYPE OPTI ON 1 Select option 1 to extract the entire OMAR database Be advised that the all product type option will have a tangible run ti me 11 EXTRACTF Omar and Financials Extract Both option 1 and 2 will prompt for the database number to extract the records from OMAR DATA BASE NUMBER 0 Answer with a value between zero and 99 If you choose option 2 to select a subset of records based on Product Master Product Type the following prompts will appear PRODUCT TYPE Enter a valid Product Master Product Type Only sales order and accounts receivable activity associated with this product type will be extracted If you select extract option 2 Shipping History the following prompt will appear PRODUCT TYPE OPTION 1 EXTRACT ALL PRODUCT TYPES 2 EXTRACT A SELECTED PRODUCT TYPE OPTI ON 1 Select option 1 to extract the entire Shipping History database Be advised that the all product type option will have a tangible run ti me Both option 1 and 2 will prompt for the database number to extract the records from OMAR DATA BASE NUMBER 0 Answer with a value between zero and 99 If you choose option 2 to select a subset of records based on Product Master Product Type the following prompts will appear PRODUCT TYPE Enter a valid Product Master Product Type Only shipments associated wit
27. h this product type will be extracted If you select extract option 3 Accounts Payable the following prompt will appear ACCOUNTS PAYABLE DATA BASE NUMBER 0 Enter a value between 0 and 99 entire Accounts Payable database will then be extracted 12 EXTRACTF Omar and Financials Extractd Financials Extract If you select extract option 4 General Ledger the following prompt will appear General Ledger DATA BASE NUMBER 0 tween 0 and 99 The entire General Ledger Enter a value be then be extracted database wil At this point the extract programs will run and display progress messages for the major datasets being extracted Extract File Names Names of the Extract Files Created As mentioned earlier the goal of the extract processes was to incorporate the same file names and field names so that the data elements are easily identified by using the Manman database guides A PDF copy of the Manman release 11 database guides are included on your CD The extracts will also consolidate two Manman databases into one extract process when there are dependencies and it is sensible to do 50 For example 1 The Manufacturing extract exports data from both the MANDB and RESDB databases RESDB dataset contains ECO information associated with bills of material 2 The Purchasing extract exports data from both the purchasing database PURDB and the Vendor database VNDDB 3 The Transaction Log extract export
28. ic fields in the Manman system 1 Integers numbers ranging from 0 to 32767 Integers are formatted as 5 digit numbers in the extract files The exception to this rule are integers for dates which are converted to YYYYMMDD format 2 Double Integers these represent whole numbers with values exceding 32767 Double integers are formated as 8 digit numbers in the extract files 3 Real Numbers and Double Real Numbers these are floating numbers numbers containing decimal values The real numbers are in the extract file with a length of 12 bytes contain a period and have 2 or 3 decimal positions For example 12345678 123 17 Transaction Log E xtracts The Format of the Transaction L og Extracts The Transaction Log Extracts differ slightly from Transaction Log file format in the Manufacturing database guide This was done to facilite better inquiry capabilities by order purchase order work order sales order number There are 4 extract files The primary file containing the transaction log record itself is named TLOGFIL If you will be using the Monthly Part Usage capability of the product that file holds 48 months of Usage information Therefore it is recommended that you extract Transaction Log information in 4 year or less increments 1 year 2 year or 3 year blocks of Transaction Log data work well also IM Item Master Table A subset of the MANDB Item Master table to facilitate reporting TNO A18 Part N
29. mdb and Shi ppi story mdb Mi grateAPGL Creates mdb and GL mdb These programs were developed in Microsoft Access 2003 but should run on any version of Microsoft Access Import programs were developed by calling a series of Visual Basic Macros It is possible not probable that if you are running a version of Access prior to Access 2003 the import you may have to obtain a dil from the Microsoft website Because the Import programs run macros you may receive the Microsoft security warnings that macros are about to be run and have to continue or change the macro security setting Double click on these Import programs to launch them directions on how to Import on on the following page After the Import program has run Access databases in Manman format will be built in a subdirectory called MANMAN Access databases have the following names Manman to Microsoft Toolbox Manufacturing 1 Manufacturing mbd 2 Purchasing mdb 3 Translog mdb Manman to Microsoft Toolbox Omar and Financials 4 OMAR mdb 5 ShippingHistory mdb 6 mdb 7 GL mdb 28 Access Import Applications Access Import Applications Double click on the Access databases to view your Manman data Upon opening the database a macro which runs a custom Filter Inquiry process will execute You do not have to use our custom Filter Inquiry process Simply close the Filter Window and you can 5 what Manman table to
30. n not required 230 Anonymous user logged in Remote system type is Windows NT ftp cd mgfiles lt lt lt directory where files will placet ftp mput Q ftp quit If you will be using the MPUT the required TXT suffix will not be applied Refer to applying the TXT suffix section below You may also pull the extract files from the HP3000 to your Windows server by initiating FTP on the Windows server and using the GET or MGET commands Additional information can be found in the HP3000 ARPA File Transfer Protocol User Guide http docs hp com en 36957 90158 i ndex ht ml Terminal Emulator File Transfer When using your terminal emulator you are offered a choice between a binary file transfer type or an ascii file transfer type Choose ASCII The Reflection terminal emulator allows you to put in an Q for the host file name to transfer all files in a group This allows you to do a file transfer on a series of files instead of specifying them individually When using the and a Reflection file transfer i n i f a p For example CHGROUP MGFILES fi logon to the group the files reside Also using an Q file transfer in reflection does not appl y the required TXT suffix to the local PC le names Refer to the Ts t applying the TX uffix section The Minisoft terminal emulators file transfer capability is for individual file names It should also be noted that the Minisoft file transfer is slower than the
31. not have to it is recommended you create a seperate group on the HP3000 for the different sets files are created Manman to Microsoft Toolbox consists of 7 distinct extracts Manman to Microsoft Toolbox Manufacturing 1 MANUFACTURING MANDB RESDB 2 PURCHASING PURDB VNDDB 3 TRANSACTION LOGS anman to Microsoft Toolbox Omar and Financials OMAR FI NDB TABDB SHIPPING HI STORY HI 508 ACCOUNTS PAYABLE PAYDB VNDDB M 4 5 6 7 GENERAL LEDGER GLDB 4 Installation Instructions Installation Instructions The Group names d irectories on the HP3000 that we recommend that you create and wil be using through this manual are as follows 1 MGFILES manufacturing 2 PUFILES purchasing 3 TLFILES transaction logs 4 OMFILES omar 5 HSFILES shipping history 6 APFILES accounts payable 7 GLFILES general ledger To create these Groups Logon to the Account your Manman databases reside in For example HELLO USERNAME MANMAN Then issue the following command to build your Groups XEQ BLDGROUP SUMMI T MMV110 The BLDGROUP command file executes the 7 statements below If you want your extract files created in different Groups or on specific HP3000 volume sets do the NEWGROUP SEEN e ANY NEWGROUP MGFILES ACCESS R X S NEWGROUP PUFILES ACCESS R A L X S ANY NEWGROUP LES ACCESS R W A L X 5 ANY NEWGROUP OMFILES ACCESS R W A L X S
32. nsecutive delimiters as one Semicolon Space Other m Text qualifier 54 Data preview 8 209242 0000000 630 0030712 20030712 8 2112010 0000000 600 0040610 20040610 8 3011414 0000000 510 0051109 20051109 8 305159 0000000 550 0030718 20030718 8 308114 0000000 460 20031223 20031223 lt Back Finish You have the option of defining specific columns as dates text Click Finish Text Import Wizard Step 3 of 3 This screen lets you select each column and set Column data format the Data Format General General converts numeric values to numbers date C Text values to dates and all remaining values to text 6 Date MU C Do not import column skip Advanced Data preview 20040610 8 3011414 20051109 8 305159 20030718 8 308114 20031223 Your spreadsheet should now be imported Click on Format Column Auto Fit selection to display the full contents of each column Click on File Save As and save as Excel Workbook format instead of delimited format Extract and Capacity Limits Extract and Capacity Limits HP3000 Extract Program Limits Each of the extract programs has a limit of 3 000 000 records per dataset If you have Manman datasets that exceed this value please contact us and we will adjust the limit up accordingly for you The HP3000 extract programs are written with the most expedient coding and reformatting processes
33. ntered You will be allowed to enter a start and end date for purchase orders added A subset of the Transaction Log records can be extracted based on the standard Manman Transaction Log selection of date or Transaction Log file name number Prompts The following are the prompts in the EXTRACTM process WHI CH EXTRACT WOULD YOU LIKE TO EXECUTE 1 MANUFACTURING RESDB 2 PURCHASING PURDB VNDDB 3 TRANSACTION LOGS OPTI ON 1 After answering the prompt above you will be asked where the Manufacturing database resides This prompt will not appear if you have previously logged on to Manman during your session as you will have JCW set and it will know what Manman EXTRACTM Manufacturing Extract database you are using MANUFACTURING DATA BASE NUMBER 0 Answer with a value between zero and 99 If you selected extract option 1 Manufacturing the following prompt will appear CLASS CODE OPTION 1 EXTRACT ALL CLASS CODES 2 EXTRACT A SELECTED CLASS CODE OPTI ON 2 Select option 1 to extract the entire Manman Manufacturing database Be advised that the all class codes option wil have a tangible run time If you choose option 2 to select a subset of records based on Item Master Class Code the following prompts will appear SELECT PARTS BASED ON WHICH CLASS CODE GROUP 1 2 3 4 Answer with a value between 1 and 4 CLASS CODE Enter a valid item master class code If
34. ries CS Desktop 2 Desktop My Computer Sem 1 Shared Documents ViewLog gt Local Disk C Vewlog 22 12404a04e19625ab92 Help AccessAPFiles E Close C Documents and Settings DByms Desktop Do not double click on the MRPPLAN XLS file Launch Excel and do a FILE amp OPEN Choose MRPPLAN XLS as you browse The Import Wizard appears Choose the delimited file type Text Import Wizard Step 1 of 3 The Text Wizard has determined that your data is Fixed Width If this is correct choose Next or choose the data type that best describes your data Original data type Choose the file type that best describes your data Characters such as commas or tabs separate each field Fixe width Fields are aligned in columns with spaces between each Field Start import at row 1 File origin 437 OEM United States Preview of File C Documents and Settings DByrns Desktop MRPPLAN TXT 10000000 120030712 2003071215 0 10000000 20040610 20040610 8 10000000 20051109 12005110918 10000000 20030718 12003071815 10000000 20031223 2003122315 Cancel Finish Click on the Other checkbox and put a bar in the adjacent box bar is a shift backslash on the keyboard Text Import Wizard Step 2 of 3 This screen lets you set the delimiters your data contains You can see how your text is affected in the preview below Delimiters E Treat co
35. s a subset of Item Master information from MANDB so that the user can create inquires containing part descriptions and other Item Master elements while viewing Transaction Log records or Usage information The Transaction Log extract also creates a file that contains 48 individual months of Usage for each part number The Transaction Log Extract files and fields are documented in the Transaction Log extract section of this manual 4 The OMAR Extract exports data from both the FINDB and TABDB Tables databases 5 The Shipping History Extract exports data from HISDB but also exports a A subset of information on Ship to customers from CUSFIL of FINDB so that customer names and cities can be associated with Shipping History Inquires This extract file is SHPHIS b A subset of information on Product Masters records from PROMAS of FINDB so that product descriptions and units of measure can be incorporated This extract file is CUSHIS c A subset of information on Item Masters records from IM of MANDB to include Part descriptions 6 The Accounts Payable extract exports data from both the database PAYDB and the Vendor Master VNDMAS from the Vendor database 14 Extract File Names Extract File Names The HP3000 extract processes EXTRACTM and EXTRACTF create one flat ASCII file for each dataset in the database being extracted The Extract File Names created by each of the 7 extract processes are listed below Thes
36. t the program uses the folder where the application is installed and creates a new subfolder MANMAN Access databases built will reside in the MANMAN subfolder 2 Click on the large button in the top middle of the screen Click to select folder for Manufacturing text files This is the folder you downloaded the MGFILES from the HP3000 3 Click on the large button in the top right of the screen Click to select folder for Purchasing text files This is the folder you downloaded the PUFILES from the HP3000 4 Click on GO Note if you only want to build 1 Access database instead of 2 Access databases use the check box next to the Database 1 and Database 2 to choose which Access database you will be creating When the import process is finished there will almost always be import errors This is NORMAL Any import errors can be reviewed under the error tab in the tblImportErrors table Someties a Bar character appearing in the data being imported will cause an import error Custom Filter Process that is launched upon opening the Microsoft Access Database 1 The filter form should open automatically If you do not wish to use this filter function just close this window Filter Form em CES Select Table to Search Select Filter Name Details FieldName Fldop Op2 Value2 ERN is 77 2607 a a lj Save Filter As Sa Delete Filter Show all records Apply Filter 2 Indicat
37. tically converted into a complete MS Access Database or another data format You can create your own extracts filter view do custom reporting etc Archive and Inquire upon your M anufacturing Transaction Logs Transaction Log records are not easily read reformatted and archived The Manman to Microsoft Toolbox accomplishes this and calculates and stores monthly Usage information for each part Don t purge your transaction log records move them to a Windows platform Installation Instructions Installation Instructions 1 Restore the files fromthe tape on to your HP3000 system Log on as MANAGER SYS and enter the file equation FILE DEV TAPE Restore the tape by entering the command RESTORE SUMMI T MMV110 SHOW CREATE This presumes you are running Manman release 11 If you are running a different Manman release substitute MMV110 for the account your code resides in ie 090 for the remainder of the installation instructions 2 Grant the MMV110 Account the capabilities it needs for the extract programs to run ALTACCT MMV110 CAP PM 3 Grant the SUMMIT group the capabilities it needs for the extract programs to run ALTGROUP SUMMIT MMV110 CAPzIA BA MR DS PH PM ACCESS R A L X S ANY 4 Understanding where the Extract Files will be Created When you run the extract processes on the HP3000 the files are created in your home or local group Although you do
38. umber key CCODE I1 Group 1 Class Code REV A2 Revision Level DESC A30 Part Description UOM A2 Stocking Unit Of Measure NLOC A10 Prime Inventory Location SCODE 2 Source Code BCODE A2 Buyer or Planner Code FLTI ME I1 Fixed Lead Ti me GLACCT 24 Pri mary General Ledger VCODE A10 Prime Vendor Code PRUOM A2 Purchasing Unit Of Measure PLANCODE A2 Planner CONVFACT R2 Conversion Factor CLCOD2 I1 Group 2 Class Code CLCOD3 I1 Group 3 Class Code CLCOD4 I1 Group 4 Class Code ORDERFIL Order Table This table facilitates keyed reads into the transaction log data by work order number sales order number purchase order number or material requisition number ORDERNO A10 links to TLWOPO of TLOGFIL key ORDDOCTYP A2 document type WO SO PO or MR ORDVCNO A10 Ship to Customer Number or Vendor Number ORDVCNAME A30 Customer Name or Vendor Name ORDADDDAT A8 date order added 18 Transaction Log E xtracts Transaction Log Extracts TLOGFIL Transaction Log File TLPARTNO TLWOPO TLDOCTYP TLWOPN TLSCRWC TLTLOC TLTLOT TLTQTY TLQNTY TLQOH TLDR TLCR TLDAT TLTI ME TLUSRDAT TLSCPREA TLPROJ TLREV Part Number 18 Order Number A10 Document Type A2 WO sales order key key TLWOPO represents a work order number number SO purchase order number or material requisition number MR Work Order Part Number A18 Work Center scrap transactions A6 Operation Sequence s
39. vides you with two easy to use functions 1 A high speed M anman to flat delimited file extract process 2 An automatic Microsoft Access or Excel import routine Here is how it works You run a utility on the HP3000 and all or a selected portion of your Manman data is converted to flat ASCII delimited text files The files are easily downloaded from your HP3000 to your Windows platform We provide you with a Windows program that you launch on your PC which automatically reads the files and builds a replica of the databases in Microsoft Access All with a few clicks of your mouse The file names field names date reformatting and data integrity is built in The Access databases as close to the same format as the native Image databases in Manman Just one way of trying to keep things consistent A user can pick up the Manman database guide and still have a reference as to where the data is and what it means The delimited files you create can also be imported into E xcel SQL or other Windows databases and tools Benefits of the Manman to M icrosoft T oolbox Easy Extract Capability A typical data migration calls for moving information from the H P3000 to a new server This product will save time in formatting the hundreds of fields dates and files in the Image databases into an ASCII delimited format Easy Import Capability The delimited files are automa
Download Pdf Manuals
Related Search