Home

OSAS Web (OW) - White Ware, Inc

1. echo The database server is too busy Sorry about that echo Please try again later echo echo By the way we have recorded this problem and will add echo capacity if it happens frequently fi OSAS Web B2B User s Manual Files for Remote Access Remote access provides you greater security than the standard OSAS Web B2B setup By physically separating your company s web server from the data storage your Internet customers are allowed access to only the information you specify To do this you must copy specific files from the main computer where the OSAS information is stored to the remote terminal where the web server resides The information stored on the web server is separated into two groups The first group is the data files the second group is the public programs Copy Data File to Web Server To copy the data files needed by OSAS Web B2B use the Copy Data Files to Web Server function to copy these files to the remote server ARCDx ARCTx ARCUx ARINx INAIx INCAx INCLx INGLx INHSx INLDx INLOx INLPx INLTx INPPx INPSx INQLx INQTx INSNx INTB INTXx INUMx INUPx INVEx OSAPPL OSCN OSCOMP OSINFO OSTPL OWCC OWCGx OWICx OWIIx OWGCx OWTB RMGCx RMTDx RMTHx SODEx SOTB SOTDx SOTHx OSAS Web B2B Manual E 1 Files for Remote Access You also have the option to copy the ARHIx file which stores the customer s detailed transaction history During the initial installation you m
2. E Local intranet a The page lists up to 10 groups for this customer If there are more groups after the ones listed the Next and Previous buttons appear Click these buttons to scroll through the list of groups Click on the item group for which you want to list items or if there are more than 10 groups available to you enter a group to search for and click the Search for Group button You can also search for a specific item from all available groups by entering the item ID and clicking the Search for Item button If there are items in your shopping cart the View Shopping Cart command appears in the side menu Click View Shopping Cart to list its contents OSAS Web B2B User s Manual The Web Interface Order Entry Order Entry Items HTML Screen 3 Sales Order Entry Microsoft Internet Explorer File Edit View Favorites Tools Help fa a Search Favorites A media O mV SYSTEMS INC Information Inventory Orders Order Inquiry ACEO Order Entry CEET ACE BUILDERS Inventory Group Codes CCUM CELL 505 555 1646 Login Page pa Choose the item ID you want to order Item ID Subgroup Code Item Description Additional Description Ree Price Millwork Package PKG 1 275 1920 Cabinets SET 1 055 0925 Doors Windows Top of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems I
3. I set up item pictures and they don t show up Why not While setting up your item pictures you must set up the virtual paths linking the data to the display function screens Check these two items 1 You must set up a virtual path on the web server The virtual path should be image with the actual path going to the directory where the images are stored See your web server manual for more information 2 You need to copy the image files into the directory on the web server to which the virtual path is mapped Can use WIN CGI scripting calls with OSAS Web B2B No Currently OSAS Web B2B only supports standard CGI scripting calls I run OSAS Web B2B at my Internet Solution Provider ISP How do update my files Follow these steps 1 Find out what directories the ISP is using for your OSAS Web B2B files The directories you need to check are e The actual path to which the osasweb virtual directory is mapped e The actual path to which the image virtual directory is mapped e The actual path of the document directory in which OPENHOME HTM is located e The directory where the data and OSAS programs are stored if you do not store them in the osasweb virtual directory B 2 OSAS Web B2B User s Manual Common Questions 2 Create a mirror web site A mirror web site is a copy of your web site including file placement that you may create on a separate computer at your location Because it matches your ISP web sit
4. sesage sesid sesrec sessioncookie sesipl stdfoot stdhead tempdir title url urltpl If session tracking is on with the sestpl global string this value determines the age in hours a session cookie lasts The default is 24 Setting it to 0 results in the session expiring when the browser is closed An internally maintained value if session tracking is turned on Stores the current session record whose structure is defined with sestpl An internally used value for cookie management Stores the string template definition for session state management If defined before utcgi wbb is CALLed the Basic Web Utility manages a session record using this as the record definition Used in standard structure options Points to a file to be appended to the end of all output Used by utexit wbb Used in standard structure options Points to a file to be placed just after the body tag is printed by the first call to utsend wbb Points to a directory to be used for temporary files If it is not defined the Basic Web Utility looks for the environment variable TEMP Then use the tmp directory on UNIX or the current cgi directory on Windows Used by uttempfl wbb Triggers the standard structure options and is placed in the document header inside title amp ldots title tags An internally maintained value used in Win CGI An internally maintained value used in Win CGI OSAS Web B
5. Building Login Header Building Login Body Building Login Trailer Company H 11 05 2002 Terminal T000 OVR Enter a title for your login page then enter the directory path name to the location on the web server from which web pages are launched To save your entries and create the login page use the Proceed OK command After the page is created the Set Up Web Components screen appears OSAS Web B2B User s Manual 4 3 Install Web Server Components Use the Install Web Server Components function to copy the components required for OSAS Web B2B to the web server This function copies the various OSAS Web B2B web pages and web drivers The information copied to the web server is divided into three categories e Web server programs including the OSAS Web B2B programs scripts style sheets and batch files e Data files including the OSAS Web B2B Accounts Receivable Sales Order and Inventory files copied by the Copy Data Files to Web Server function page 6 7 e Resource Manager programs including the applications programs used in calculating prices aging customers and so on copied by the Copy Programs to Web Server function page 6 7 In this function you tell OSAS Web B2B where this information is stored You need to describe how to reach the web server from the OSAS system and how to access the information from the web server If you use local processing the programs and data files reside on the s
6. Forms that have been specified as method post enctype multipart form data are handled by utcgi wbb Any field types of file are stored in a temporary file and the file name is stored in the cgi field For example if a form contains a file field named datafile a text field named name and the user filled in c files customers dat for the datafile field then cgi might look like this cgi name xyz cgi datafile tmp bw123999 dat The extension of the uploaded file name is retained but the name is changed to guarantee its uniqueness The original file name is stored in a global string STBL filename fieldname so the above example would set stbl filename datafile to c files customers dat See the uttempfl wbb information for a description of where temporary files are stored F 70 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utcgiwin wbb Win CGl support This program is used internally by the Basic Web Utility when the Win CGI environment is detected and should never be CALLed directly utcnum wbb Convert formatted numeric text string to a number Syntax CALL utcnum wbb text value This low level routine converts a text string to a number ignoring currency symbols and other nonnumeric characters In PRO 5 it is also sensitive to the OPTS byte 6 position for the decimal character The characters and are both interpreted to indicate that the number is negat
7. The CGI specification requires that certain characters be specially coded to avoid ambiguous usage This low level routine may be used to both encode and decode text based on the CGI requirements decode is set to 0 to encode text returning the result in result decode is set to 1 to decode a previously encoded text returning the result in result OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utentity wbb Convert HTML markup entities to browser displayable format Syntax CALL utentity wbb text When sending text to a client browser it may be necessary to include characters that the browser would normally interpret as HTML markup characters but should be displayed as they are stored Examples include lt gt and amp This routine converts occurrences of these characters to the proper entity markup For example the lt characters are converted to amp lt This routine is called automatically for all data elements by the high level Basic Web Utility programs unless the user defined template attribute passthruzy is specified utenv wbb Get environment variable Syntax CALL utenv wbb name value This low level routine can be used to access an operating system environment variable It can be used whether or not utcgi wbb has been called name is a case insensitive environment variable name value returns the value of the environment variable OSAS Web B2B User
8. 10 0000 EA 10 0000 EA This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved zn Unit of Measure 2 464 41 492 882 00 246 441 00 49 288 20 24 644 10 276 013 92 138 006 96 1 143 73 1 606 41 1 464 09 OSAS Web B2B User s Manual Y Local intranet El 7 8 9 History Inquiry The Web Interface 8 10 The page lists 10 history entries for this customer If there are more entries after the ones listed the Next button appears If there are more entries before the ones listed the Previous button appears Click these buttons to scroll through the entries Click Top of Page to return to the top of the web page To find a specific invoice enter the invoice number in the box and then click Search For Invoice You can also click on an item ID to create a line item for that item in your order entry shopping cart if you are permitted to do so based on your customer ID and password When you finish reviewing history close the browser to end your session or choose a different menu selection from the side or top menus OSAS Web B2B User s Manual Invoice Inquiry The Invoice Inquiry web page on the Information menu shows the invoices and credit memos in history for this customer Click an invoice number to view more information about that invoice on the Invoice
9. formats are better quality show much more detail and in addition to working better on browsers load faster than a bitmap file OSAS Web B2B User s Manual B 3 List of Files Copied When you install the web server components the following files are copied from the OSAS progOW path to the destination you entered Some files are stored with different extensions to avoid duplication These files are renamed to the correct extension when they are copied BBX Programs These programs use input from users to look up data and create web pages OWPASSWD BBX OWMENU BBX OWARMENU BBX OWINMENU BBX OWSOMENU BBX OWMNUBLD PUB OWLOOKUP BBX OWCUST BBX OWAGE BBX OWINV BBX OWINVPR1 BBX OWORDR BBX OWORD2 BBX OSAS Web B2B User s Manual Verifies passwords Initialization program for the session Creates the Information menu Creates the Inventory menu Creates the Orders menu Builds the side and top navigation menus Calls a BBx program based on your choice from the main menu Information Account Information Information Aged Trial Balance Information Invoice Inquiry Information Invoice Inquiry Detail Order Inquiry Information Order Inquiry Detail Information C 1 List of Files Copied C 2 OWORD6 BBX OWHIST BBX OWINVL BBX OWITEMS BBX OWPRCALC BBX OWPBRK BBX OWADDL BBX OWORDER BBX OWORDER2 BBX OWORDER3 BBX OWORDER4 BBX OWORDER5 BBX OWORDER6 BBX OWORDER7 BBX OWPATH BBX OWSESS PUB OWFILE PUB
10. or call utses wbb 0 session errmsg Use the utses wbb program to store any manipulated session data as follows session custid 1234 call utses wbb 1 session errmsg Session expiration and deletion is handled automatically based on a 24 hour session lifespan however this can be controled with the global string sesage which stores a numeric value of hours This does two things e Records stored on the server are automatically purged when the numeric value is reached This purge takes place each time utcgi wbb is called with session management triggered If the value of sesage is 0 or less it defaults to 24 OSAS Web B2B User s Manual F 43 Automatic Session Tracking Basic Web Utility Guide e The cookie used for the session which is stored on the client browser machine is given an expiration time in hours If it is set to O or less the browser has no expiration time and expires by default when the user exits the browser A session can be manually deleted from the server using the utses wbb program call utses wbb 2 errmsg For session tracking to work the user account CGI tasks run under must have write rights to the utses dat file In addition if the file is not present the first time session tracking is used the Basic Web Utility creates the file in the Basic Web Utility directory and therefore must have permission to create the file F 44 OSAS Web B2B User s Manual File Uploading Support
11. 1 49 scroll region command 1 42 1 51 Ins function key 1 52 Insert Line command function key 1 42 1 51 pull down menu command 1 42 Insert line item 1 42 1 51 Insert mode function key 1 52 Install OPEN Web Server Components function 3 21 Install Web Server Components function 4 5 screen 4 6 interfaces with Accounts Receivable 1 11 Internet Access Codes List function 7 13 sample 7 13 Internet Companies List function 7 9 sample 7 9 Internet Inventory Item Groups List function 7 11 sample 7 11 Inventory Additional Description HTML screen 8 17 Inventory Information Lookup Group Codes HTML screen 8 14 Ttems HTML screen 8 15 Price Breaks HTML screen 8 18 Inventory Item Pictures function 3 5 screen 3 6 Inventory Item Pictures List function 7 7 sample 7 7 OSAS Web B2B User s Manual Inventory Lookup commands 1 43 1 50 Inventory Lookup commands 1 43 Alias Lookup 1 43 1 50 Customer Vendor Lookup 1 43 1 50 Description Lookup 1 43 1 50 Detail Lookup 1 43 1 50 Lot Lookup 1 43 1 50 Serial Lookup 1 43 1 50 Shift F3 1 43 Shift F4 1 43 Shift F5 1 43 Shift F6 1 43 Shift F7 1 43 Shift F8 1 43 Inventory lookup commands alias lookup 1 50 Inventory Price Break Lookup HTML screen 8 18 inventory search commands 1 50 Invoice Detail Lookup HTML screen 8 12 Invoice Inquiry Lookup HTML screen 8 11 invoice detail 8 12 web function 8 11 Item Group Codes function 3 3 Item Group Cod
12. Builders Supply This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved OPEN SYSTEMS is a registered trademark of Open Systems Holdings Corp 3 Local intranet Enter the customer ID password or access code and then select the company if you gave that customer access to more than one company Click Submit to continue OSAS Web B2B User s Manual 8 3 OSAS Web Login Page The Web Interface When you click Submit OSAS Web B2B checks the customer ID and password and opens the Account Information web page This page contains top and side menus based on the functions and information to which you have granted that customer access If the customer ID is not set up or the password is incorrect an error message appears OSAS Web B2B Menus 8 4 There are three top level menu groups Information Inventory and Orders These top level menus contain one or more side menu functions as follows e Information e Account Information e Aged Trial Balance e History Inquiry e Invoice Inquiry e Inventory e tem Inquiry e Orders e Order Inquiry e Order Entry OSAS Web B2B User s Manual Account Information The Account Information web page on the Information menu displays data for the customer s account from the OSAS files The information includes general information and can optional
13. Ctrl Z 1 39 Del 1 51 Down Arrow 1 38 End 1 52 F1 1 41 F10 1 39 1 52 F2 1 38 1 45 F3 1 38 F5 1 38 F6 1 38 F7 1 39 F9 1 52 Home 1 52 Ins 1 52 Left 1 51 PgDn 1 38 PgUp 1 38 Right 1 51 Shift F3 1 50 Shift F4 1 50 Shift F5 1 50 Shift F6 1 50 Shift F7 1 50 Shift F8 1 50 Shift Fl 1 41 Shift F10 1 52 Shift F3 1 43 Shift F4 1 43 Shift F5 1 43 Shift F6 1 43 Shift F7 1 43 Shift F8 1 43 Shift F9 1 39 1 52 Up Arrow 1 38 G Global Inquiry defined 1 3 graphical menu exiting from 1 22 features of 1 21 right click menu 1 28 1 45 sample screen 1 22 GUI Text Using OSAS with Contractors Job Cost 1 21 H Help 1 29 function key 1 41 pull down menu command 1 41 tool button 1 27 1 44 help commands F3 1 47 F6 1 47 F7 1 47 History command 1 58 History Inquiry web function 8 9 Home inquiry command 1 49 report command 1 66 scroll region command 1 42 1 51 Home function key 1 52 HOMEPATH table 3 21 HTML 1 7 I IMGPATH table 3 21 Information command 1 55 Information menu 1 55 Comments command 1 56 Documents command 1 59 History command 1 58 Information command 1 55 Inquiry function key 1 38 1 45 graphical 1 45 partial key 1 48 pull down menu command 1 38 inquiry commands Down Arrow 1 49 End 1 49 Enter 1 49 Esc 1 49 F7 1 49 Home 1 49 Ins 1 49 PgDn 1 49 PgUp 1 49 Up Arrow 1 49 Ins inquiry command
14. If you need more information consult a customer support representative OSAS Overview Resource Manager The Resource Manager application is the foundation or shell of OSAS It provides the operating environment that holds the other applications Resource Manager also includes three powerful business features Global Inquiry Executive Information Summary EIS and Print Manager With Global Inquiry you can drill through your accounting data to find selected information throughout your system With EIS you can access company information quickly and view summaries of all aspects of a company or a group of companies With Print Manager when you print reports to file your reports can be stored sorted printed and searched for specific text Base Applications Base applications are designed and produced with the largest possible number of industries in mind They are most effective when you interface them with each other Base applications are usually named after common accounting operations Examples are General Ledger Accounts Payable Purchase Order Accounts Receivable Sales Order Payroll and Inventory OSAS Web B2B User s Manual 1 3 Welcome to OSAS Introduction Running OSAS 1 4 OSAS runs on an operating system supported by 150 megabytes of permanent storage and 4MB of RAM You may need additional space or memory depending on the size of your data files and the operating system you use Consult your reseller for m
15. Inventory Lookups Menu Commands Edit Modes Other Inventory Lookups Information Help 2xre se mE Alias Lookup lt Shift F3 gt Customer Vendor Lookup lt Shift F4 gt Detail Lookup lt Shift F5 gt Lot Lookup lt Shift F6 gt Serial Lookup lt Shift F7 gt Description Lookup lt Shift F8 gt If you use the Inventory application and the cursor is in an Item ID field you can use any of the Inventory Lookups commands to search for information about items and select an item for entry in the field you are in Command Alias Lookup Customer Vendor Lookup Detail Lookup Lot Lookup Serial Lookup DescriptionLookup OSAS Web B2B User s Manual Description Searches for items with a specified alias listed as an alternate item When you enter the alias you can use the and wildcard characters to restrict or widen the search Searches for an item based on customer ID or vendor ID When you enter the customer or vendor ID you can use the and wildcard characters to restrict or widen the search Searches for detailed information about an item You can enter search information in any of the fields that appear using any of the following wildcard characters to restrict or widen the search lt gt Searches for an item based on lot number When you enter the lot number you can use the and wildcard characters to restrict or widen the search Searches for an item based on serial number Wh
16. Line Item HTML screen 8 24 Order Entry Items HTML screen 8 23 order numbers 5 4 Select Shipping Address 8 27 Shipping Address Information 8 28 Shopping Cart HTML screen 8 25 web function 8 21 Order Entry for Line Item HTML screen 8 24 Order Inquiry HTML screen 8 19 Order Detail 8 20 web function 8 19 Order Number HTML screen 8 30 order numbers 5 4 OSAS running 1 4 system requirements 1 4 OSAS Web Login Page web function 8 3 output device printer 1 63 P parameters access code 1 4 command to start OSAS 1 4 company ID 1 4 general expression 1 4 terminal ID 1 4 partial key inquiry 1 48 Paste function key 1 39 1 52 pull down menu command 1 39 tool button 1 44 PgDn inquiry command 1 49 report command 1 66 scroll region command 1 42 1 51 PgDn function key 1 38 PgUp function key 1 44 inquiry command 1 49 report command 1 66 scroll region command 1 42 1 51 PgUp function key 1 38 Pop Up Calendar tool button 1 44 Previous Line command function key 1 42 1 51 pull down menu command 1 42 Previous Page command function key 1 42 1 51 pull down menu command 1 42 Print Manager defined 1 3 PRO 5 Command tool button 1 28 Proceed OK function key 1 38 pull down menu command 1 38 verification button 1 45 Proceed command 1 17 pull down menu functions commands 1 38 Edit 1 39 Help 1 40 OSAS Web B2B User s Manual Information 1 41 Information menu 1 55 Inventory L
17. Newer browsers such as Netscape 3 support a new form posting protocol that allows data files to be uploaded to a web server For the browser to send the form using a protocol that supports file uploads the lt form gt tag must have the option enctype multipart form data added When the form is submitted it is formatted differently In Basic Web Utility 1 1 utcgi wbb detects this type of form post and loads the cgi template accordingly The only difference is that file fields are loaded with a file name indicating the location of the uploaded file on the server The name used is a unique generated name that retains the original extension uploaded by the user The original file name is stored in the stbl filename x where x is the name of the field on the HTML form The files are stored in the system temp directory or in a directory named in the stbl tempdir See the utcgi wbb reference section for more details OSAS Web B2B User s Manual F 45 Global String Reference Global String STBL Usage arraysep bbweb version bodyopt cgi cgitpl commdir cookies cr env OSAS Web B2B User s Manual Delimits field names from array element numbers If arraysep is __ then a cgi name of amount__5 would be interpreted as cgi amount 5 The default separator is a hyphen but because this conflicts with Javascript code it may be necessary to use another value valid in Javascript variable names but one th
18. company ID will be completely removed Use the Delete F3 command to remove all access codes for the customer and the company or press Enter to abort this operation Internet access code faccess code will be removed Use the Delete F3 command to remove the access code for the customer or press Enter to abort this operation Inventory must be installed to run the Print Inventory Item Groups list The OSAS Inventory application must be installed to use this function Inventory must be installed to run the Print Inventory Pictures list The OSAS Inventory application must be installed to use this function Item fitem ID is already set up The item ID you entered already has Internet access Either enter a new item or edit the existing item entry Line Item error amp or these are reserved for internet use The code or ID you entered contains an invalid character Reenter the code or ID without these reserved characters A 2 OSAS Web B2B User s Manual System Messages Master access code faccess code for company xxx does not exist The access code you entered is not set up for the company that you entered Check the code to verify that it is set up correctly for the company from which you are trying to copy The file name cannot contain spaces The file name you entered for a graphic cannot have a space in it Check the name of the picture file and reenter it Thru value must be greater than from valu
19. date n 8 date jul slsp c 3 fill c 2 formt ype hidden amount i 4 scale 2 mask t 40 00 0330 DIM SLSP slsp_id c 3 name c 20 In the CUST data template a list of keys and descriptions are referred to by the global string values SLSPID and SLSPNM These lists are loaded here and when other routines generate selection lists or lists of salesperson values the IDs and names are used 0400 REM 1100 load the STBL s for SLSPID and SLSPNM 0410 REM The CUSTS template references keys and vals for the slsp field 0420 REM This facilitates the default use of a select list object for 0430 REM entry forms and also will cause HTML merges to use the name 0440 REM rather than the id for display purposes Note that placing 0450 REM these references in the template merely serves to provide 0460 REM default formatting and that can be overridden in any given 0470 REM situation 0480 LET SLSPCHAN UNT OPEN SLSPCHAN GENSMPL2 0490 LET IDS NAMES 0500 READ RECORD SLSPCHAN END 0520 SLSP OSAS Web B2B User s Manual Basic Web Utility Sample Program Reference 0510 LET IDS IDS SLSP SLSP_ID NAMES NAMES SLSP NAME GOTO 0500 0520 LET X STBL SLSPID IDS X STBL SLSPNM NAMESS IDS NA MES 0530 CLOSE SLSPCHAN Now that the setup is complete the program branches to the program specified in the CGI input value pgm If no pgm value is specified or an invalid pgm is specified
20. democlst txt contains a place marker between the lt ul gt and lt ul gt unordered list tags The structure includes a lt li gt list element tag so that each record becomes another bullet item in the document The name field is treated as a link and the link is specified in the variable LINKEXPR which is constructed to run a program with the CGI value cust_id set to the customer number of any given record The program defaults to the sample invoice list demoilst bbx but can be specified in the CGI value linkto The Customer Maintenance application uses the linkto value to load and edit a customer record 0200 REM 100 Initialize other values 0210 LET KNUM 1 MAXRECS 10 0220 LET STRUCTURE lt li gt name Elink cust id city state zip phone 0300 REM 100 Construct a link expression used to link each customer 0310 REM to a specified program for further display edit 0320 LET LINKEXPR ENV SCRIPT_NAME cust_id cust_id encode 0330 LET LINKTO demoilst bbx LLINKTO FIELD CGI linkto ERR 0340 0340 LET LINKEXPR LINKEXPR amp pgm LINKTO 0400 REM 1100 Open Customer Data File 0410 LET CUSTCHAN UNT OPEN CUSTCHAN GENSMPL1 After opening the customer master file the uthtmfil wbb program generates a list of records in the CUSTLIST variable and lists up to MAXRECS records The list starts with the value in STARTWITHS and continues until the end of the file If the variable CURKEY is retur
21. tempfile tempchan F 61 Toolkit Program Functional Listing Basic Web Utility Guide rsread wbb Read a record by way of an RS 232 serial connection Syntax CALL rsread wbb filename mode ky knum rec errmsg This program communicates with a running rswatch wbb task on another system It scans the file for an available port to issue a request on Each serial port has a corresponding rswatch task running on the target system A library of available serial ports is maintained in the text file rsttys txt By using a dedicated serial connection between a live Business Basic system and a Web server system connected to the Internet potential security issues of having a TCP IP connection to the live system can be avoided While a dedicated serial connection is slower and doesn t support concurrency it is secure filename is the name of the file on the target system to access It can be a full pathname or any name accessible to the task running rswatch wbb on the target system e mode is the read mode used to access the desired record nretrieves the key after that specified in ky ky need not exist e pretrieves the key before that specified in ky ky need not exist e any other value looks for ky specifically ky is the key to access or a positioning value for the n and p modes This returns the actual key of the record returned knum is the key chain number to use in a multi keyed file If the keys are
22. 59 opening 1 60 viewing 1 60 double click defined 1 13 Down Arrow inquiry command 1 49 report command 1 66 scroll region command 1 42 1 51 E edit line item 1 51 editing comments 1 58 Editing Files D 1 modifying batch and script files D 2 OSAS Web B2B User s Manual modifying the config bbx D 1 EIS defined 1 3 EMAIL table 3 21 screen 3 22 End inquiry command 1 49 report command 1 66 scroll region command 1 42 1 51 End function key 1 52 Enter inquiry command 1 49 scroll region command 1 51 error messages C 1 D 1 Esc inquiry command 1 49 Executive Information Summary defined 1 3 exit from inquiry window 1 49 from report to menu 1 66 from screen or window 1 39 function key 1 39 pull down menu command 1 39 F F1 function key 1 41 F10 function key 1 52 F2 function key 1 38 F3 scroll region command 1 42 1 51 F3 function key 1 38 1 44 F5 function key 1 38 F6 function key 1 38 1 44 F7 inquiry command 1 49 report command 1 66 F7 function key 1 39 F9 function key 1 52 Favorites Menu 1 53 adding items to 1 29 changing to from 1 29 removing items from 1 29 Field Down function key 1 38 OSAS Web B2B User s Manual pull down menu command 1 38 Field Up function key 1 38 pull down menu command 1 38 File Maintenance menu structure 1 10 First Line command function key 1 42 1 51 pull down menu command 1 42 Function help 1 29 function keys Ctrl J 1 39
23. Accounts Receivable GL Account function in General Ledger and Price and Availability and Item Inquiry functions in Inventory you can set up a Favorites menu rather than moving between each application The Favorites menu for the graphical main menu is illustrated below AR Edit Cash Receipts GL Accounts IN Price and Availability IN Item Locations To set up the Favorites menu do the following 1 Select the function you want to add to the menu and press F10 or use the right click menu in graphical mode 2 Press F2 to confirm that your selection was added To remove a function from the menu follow these steps 1 Select the function on the Favorites menu that you want to remove 2 Press F10 or use the right click menu in graphical mode OSAS Web B2B User s Manual 1 53 Information Menu The Information menu appears on some function screens in certain applications and gives you access to additional information about a customer vendor item job bill of material or employee The commands available on the Information menu are determined by the applications you have installed and can include e General Information Comments History Documents Not all of the commands above appear on every Information menu instead commands are available only as they are relevant to the task you are performing For example if you are entering a transaction in Accounts Receivable you can access comments or
24. Detail web page page 8 12 Invoice Inquiry HTML Screen 4 OSAS Customer History Invoice Lookup Microsoft Internet Explorer 0 xj File Edit View Favorites Tools Help ae Q ra X r x a PA JD search 5 2 Favorites QQ Media E 2 en gt Links gt DROP v er ren 7 24 Em SYSTEMS INC Information Account Information Inventory Orders CustomeriD ACE001 Aged Trial Balance COTE ACE BUILDERS SCHEITERTE 605 555 1646 History Inquiry Type Invoice Number Date ieoiceunqure Invoice 12670074 Invoice 24889030 Invoice 12670064 Invoice 12670054 Invoice 12670046 Invoice 24889022 Invoice 12670041 Invoice 12670038 Invoice 12670035 Invoice 12670032 Invoice 12670030 Invoice 12670027 Invoice 12670025 Invoice 12670021 Invoice 24889014 Invoice 12670018 Invoice 12670016 Invoice 12670015 Invoice 12670013 Invoice 12670010 Invoice 12670001 Invoice 24889003 Login Page 12 21 2000 12 09 2000 11 24 2000 10 17 2000 09 05 2000 09 03 2000 08 09 2000 07 18 2000 06 21 2000 05 03 2000 04 03 2000 03 02 2000 02 05 2000 01 26 2000 12 17 1999 09 02 1999 08 17 1999 07 14 1999 07 11 1999 Click an invoice number in the list to view detail for that invoice The Invoice Detail web page appears Click Top of Page to return to the top of the web page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and O
25. Exit from the File menu Save the Report as a File To save the report as a text file select File or enter F The data path set up for the workstation in the Defaults function on the Resource Manager Workstation Configuration menu appears If necessary enter a new data path or click the Browse button to navigate to the correct directory then enter the file name followed by the txt extension The file name plus extension that you enter must be less than 35 characters Press Enter to save the report in that directory View the Report on Screen Text Screens Only If you are using text screens you can view selected reports directly in the OSAS screen Keep in mind that this option displays the report one page at a time storing previously viewed pages in the workstation s memory Use the Defaults function on the Resource Manager Workstation Configuration menu to limit the number of screen pages you can view to conserve memory resources Follow these steps to view the report on screen 1 Enter S to select S creen 2 Whenavailable enter S if you want to view the report in standard width or C if you want to view it in compressed width 3 When the report appears press Enter to view the next page or Page Up to view previous pages 1 64 OSAS Web B2B User s Manual Introduction Reports E mail the Report Before you can e mail reports you must enter details about your e mail system using the E Mail Setup function on the Resource
26. History Inquiry The History Inquiry web page on the Information menu shows the invoice credit memo and payment history for this customer History Inquiry HTML Screen ZA OSAS Customer History Lookup Microsoft Internet Explorer File Edit View Favorites Tools Help a ar a 3 Links gt wf SYSTEMS Account Information Aged Trial Balance History Inquiry Invoice Inquiry Login Page Q rex r x 2 O search p Favorites QU Media Ir NC INC Information Inventory Orders customer AC 001 GETTY Ace BULDERS CEET 505 555 1646 PENR nvoice tem Dosen A yP Number Job ID 24889030 12 09 2001 Heating Cooling yn Package PAYMENT RECEIVED Heating Cooling Package MNEOO1 PAYMENT RECEIVED Heating Cooling MNODO1 Package PAYMENT RECEIVED Heating Cooling Package MEO Standard Window 24 X MNODD1 40 Slide by Window 30 X MNOOO1 40 Slide by Window 24 x 40 A for Invoice Invoice Payment 24889022 10 27 2002 Invoice 24889022 09 03 2002 Payment 24889014 01 27 2002 Invoice 24889014 12 17 2001 Payment 24889003 08 27 1999 Invoice 24889003 07 11 1999 Invoice 12670074 12 21 2000 600 Invoice 12670074 12 21 2000 460 Invoice 12670074 12 21 2000 450 MNODO1 Top of Page Problems or Questions E mail Webmaster builders supply com ocation ID 1 0000 PKG 0000 100 0000 PKG 0000 10 0000 PKG 0000 56 0000 PKG 10 0000 EA
27. Internet Access Codes List shows the access codes you set up for your customers for the companies customers or access codes you select Internet Access Codes List 11 06 2002 Builders Supply 11 55 AM Internet Access Codes List Company ID Cust ID Access Code Location HTML Page Type ACEO01 Testl Information Account Information Orders Order Inquiry Orders Order Inquiry Detail Information Information History Inquiry Inventory Item Inquiry Inventory Item Inquiry Show On Hand Quantity Inventory Item Inquiry Show Price Qty Breakdown Information Account Information Show Balances Information Account Information Show Credit Limit Orders Order Entry Inventory Item Inquiry Additional Description Information Aged Trial balance Information Invoice Inquiry Inventory Item Inquiry Link to Order Entry Information History Inquiry Link to Order Entry Orders Order Inquiry Link to Order Entry Inventory Item Inquiry Show On Hand Quantity as vailable End of report OSAS Web B2B User s Manual 7 13 Customer Groups List The Customer Groups List shows the item groups that you have set up for each customer for the customer IDs or group codes you select You can also choose to organize the list by customer or by group code Customer Groups List 11 06 2002 11 55 AM Cust ID Group ID ACEO01 APPLIANCE ACEO01 DOORS ACEOO01 HEAT AIR ACEO01 INTERIOR ACEO01 MATERIALS ACEO01 MILLWORK
28. Inventory application and the cursor is in an Item ID field on a function screen you can use any of the Inventory Lookup commands to search for information about items and select an item for entry in the field In graphical mode these commands are available on the Inquiry Lookup menu In text mode the IN Search flag appears at the bottom of the screen to alert you that these commands are available Command Alias Lookup Customer Vendor Lookup Detail Lookup Lot Lookup Serial Lookup Description Lookup Hot Key Shift F3 Shift F4 Shift F5 Shift F6 Shift F7 Shift F8 Operation Searches for items with a specified alias listed as an alternate item When you enter the alias you can use the and wildcard characters to restrict or widen the search Searches for an item based on customer or vendor ID When you enter the ID you can use the and wildcard characters to restrict or widen the search Searches for detailed information about an item Enter information in any of the fields that appear using these wildcards to restrict or widen the search 2 lt gt Searches for an item based on lot number When you enter the lot number you can use the and wildcard characters to restrict or widen the search Searches for an item based on serial number When you enter the serial number you can use the and wildcard characters to restrict or widen the search Searches for an item based
29. Item Additional This screen lists the additional description lines for an Descriptions item and a graphic image of the item if you set one up Item Price Breaks This screen shows the price breaks for an item you select if you have access to this information OSAS Web B2B User s Manual 8 13 Item Inquiry The Web Interface Item Inquiry HTML Screen Group Codes E OSAS Inventory Information Lookup Microsoft Internet Explorer File Edit View Favorites Tools Help Q ea M O x x E A 3 Search se Favorites A Media amp a I SYSTEMS INC Information Inventory Orders Search for tem Item Inquiry Login Page Choose the Group that you want to see items for APPLIANCE Appliances DOORS Doors HEAT AIR Heating and Air Conditioning Equipment INTERIOR Interior Materials Paint Wallpaper Supplies MATERIALS Materials MILLWORK Millwork Trim and Doors PARTS Cabinet Replacement Parts WINDOWS Windows Top of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved Fes ess S Local intranet This screen lists 10 groups for this customer If there are more groups after the ones listed the Next button appears If there are more groups before the ones listed the Previous button appears Click these buttons
30. Manager System File Maintenance menu You can e mail only selected reports In general any report or form that makes up part of your audit trail cannot be e mailed Follow these steps to e mail a report 1 Select E mail or enter M 2 When available select Standard or enter S if you want to e mail a standard width report or select Compressed or enter C if you want to e mail it in compressed width The E Mail Information screen appears 2 E Mail Information Commands Edit Modes Other Help 2xe ae aman g OK Abander E Mail To amyd osas com CL Subject Tax Groups List Attachment IV 3 If you e mailed this report previously the last e mail address to which you sent the report appears Press Enter to use this address change it if necessary or enter a new e mail address 4 Enter another address to send the e mail to as a carbon copy if necessary 5 OSAS automatically enters the name of the report in the Subject field Change this subject line if necessary 6 Selectthe Attachment check box or enter Y in text mode to send the report as a text file attachment to the e mail message If you clear this box or enter N in text mode the report is sent in the body of the e mail 7 Click OK or press Enter to e mail the report OSAS Web B2B User s Manual 1 65 Reports Introduction Report Commands 1 66 Use the following commands when a report appears on the screen Key PgUp PgDn H
31. OSAS Web B2B User s Manual Operation Deletes the help screen content To recover a deleted screen copy the xxHELP file from the distribution media to the PROGxx subdirectory xx is the application ID The copying process overwrites changes you made to other help screens In graphical mode you must first press F6 to enter the edit screen for the help content before you can press F3 Edits a help screen Exits the help screen and closes the window 1 47 Menu and Function Commands Introduction Inquiry Commands When the Inquiry button 4 appears next to a field or the Inquiry flag appears in the lower right corner of the screen the Inquiry command is available Click the button or press F2 to open the Inquiry screen to look up and select an appropriate entry The Inquiry screen operates in two modes Search and Sort You can toggle between these modes within an Inquiry window by pressing the Ins Insert key You can also choose the default mode for Inquiry windows by using the Defaults function on the Workstation Configuration menu within Resource Manager e In Search mode you can move through the keys listed by typing progressively larger portions of the key you want to find For example when you press C the window displays keys beginning with the letter C When you next press A the window displays keys beginning with CA and so on e n Sort mode you can change the order of certain Inquiry windows by pressing
32. OSAS program files to the web server for the inquiry and sales order entry functions You need run this function only during the installation process Once the programs are copied to the web server you do not need to copy them again unless you change your web server or update the OSAS Web B2B software Copy OSAS Programs to Web Server Screen 1513 Commands Edit Modes Other Help xtmmmu e OK Abandon Web Server Resource Manager Path c httpd progRM Company H 11 06 2000 Terminal TODO INS The web server Resource Manager path you entered in the Install Web Server Components function page 4 5 appears Press Enter to use this path or enter the full path from the OSAS system to the Resource Manager path on the web server Use the Proceed OK command to begin the copy process When copying finishes the Remote Access menu appears OSAS Web B2B User s Manual 6 7 Master File Lists Printing a Master File List 7 3 Item Group Codes List 7 5 Inventory Item Pictures List 7 7 Internet Companies List 7 9 Internet Inventory Item Groups List 7 11 Internet Access Codes List 7 13 Customer Groups List 7 15 Tables List 7 17 OSAS Web B2B User s Manual 7 1 Printing a Master File List The functions on the Master File Lists menu let you print lists of the information you entered using the File Maintenance menu These lists do not contain any calculations or transaction amounts but rather list only the basic fil
33. OVR OSAS Web B2B User s Manual 1 59 Information Menu Introduction Enter the ID for which you want to view attached documents The Inquiry F2 command is available Use these commands to view document information open an attached document or switch between or select a new ID e Press H to return to the header section to select a new ID e Press F to view documents attached to the first ID on record e Press Lto view documents attached to the last ID on record e Press N to view documents attached to the next ID on record e Press P to view documents attached to the previous ID on record e Press V to view document information The View Documents screen appears and lists the file name directory path and description of the attached document Press any key to return to the Documents screen e Press O to open the attached document in the appropriate software application You may need to edit the Resource Manager File Types function in order to associate files with your preferred applications If you have problems opening a document return to the function in which the document was attached and edit the attachment to change the direction of the slashes used in the directory path If the directory path contains backward slashes Y change them to forward slashes and vice versa e Press Gto go to a specific document line This command is available only when there is more than one screen of line item
34. Proceed Start Over Field Up Field Down Abandon Delete Jump Exit The right click menu gives you quick access to commonly used commands such as those used to access help move around the function screen work with information on EIS dashboards and so on The commands that are available on the right click menu depend on the function and the field you are currently using Function Field Inquiry sj When the Inquiry button appears next to a field on a function screen you can either click the S button or press the F2 Inquiry key to open the inquiry screen and search for information Verification Buttons OK Abandon When you ve completed data entry on a function screen you can either click OK or press PgDn to proceed to the next screen or to save your entries Click Abandon or press F5 to abandon entries OSAS Web B2B User s Manual 1 45 Menu and Function Commands OSAS lets you navigate around the main menu and function screens in a variety of ways This section describes the commands that are available when you access a specific command For example accessing the Help command makes the Maintenance and Exit commands available while you are in that function This section also describes how to navigate within scroll regions and fields while you work with OSAS functions Help Commands When you use the Help F1 command you can use these commands Key F3 Delete F6 Maintenance F7 Exit
35. Programs to Web Server function 6 7 screen 6 7 COPYPATH table 3 21 Create Login Page function 4 3 screen 4 3 Ctrl J function key 1 39 Ctrl Z function key 1 39 cursor moving down or forward one field 1 38 moving up or back one field 1 38 selecting item 1 49 Cursor end function key 1 52 Cursor home function key 1 52 Cursor left function key 1 51 Cursor right function key 1 51 Customer Groups customer screen 3 18 function 3 17 item group screen 3 17 Customer Groups List function 7 15 sample 7 15 Customer History Lookup HTML screen 8 9 web function 8 9 Customer Internet Access Codes function 3 13 screen 3 9 3 14 Customer Invoice Inquiry Lookup web function 8 11 Customer Lookup HTMLscreen 8 5 web function 8 5 Customer Order Detail Lookup HTML screen 8 20 Customer Order Lookup 1 2 HTML screen 8 19 web function 8 19 Customer Vendor Inventory Lookup function key 1 43 1 50 pull down menu command 1 43 D Del function key 1 51 Delete function key 1 38 information on a screen 1 38 line item 1 42 1 51 pull down menu command 1 38 tool button 1 44 Delete character function key 1 51 Delete Line command function key 1 42 1 51 pull down menu command 1 42 Delete to End of Line function key 1 52 Description Inventory Lookup function key 1 43 1 50 pull down menu command 1 43 deselect defined 1 14 Detail Inventory Lookup function key 1 43 Documents 1 59 File Types 1
36. Q O x A Asa Servos rein IE Links gt SYSTEMS INC Information Inventory Orders Order Inquiry ACEDO Order Entry CATA ACE BUILDERS Item Lookup CUCM CLs 505 555 1646 Login age Item ID item Description Quantity Unit Price Extended Price 550 Millwork Package 3 0000 PKG y 1 275 1920 3 825 58 Add to Shopping Cart Recalculate Cancel Order Top of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved l e Local intranet Enter the quantity of the item you want to order and select the appropriate unit from the Unit list box Enter 0 zero if you do not want to order this item After you specify the quantity you want click Recalculate OSAS Web B2B calculates the extended price for the quantity you ordered 8 24 OSAS Web B2B User s Manual The Web Interface Order Entry When you are satisfied with the quantity and price click Add to Shopping Cart to add the item to your cart The Order Entry Items screen appears To abandon your entire order and empty your shopping cart click Cancel Order The Order Entry Group Codes page appears Tf there are items in your shopping cart the View Shopping Cart command appears in the side menu Click View Shopping Cart to list its contents so that
37. REM Permission to derive programs from this is hereby granted provided 0040 REM said programs utilize licensed copies of the Basic Web Utility As with the scrolling customer listing a startwith value can be supplied to begin the invoice listing at a particular point A more records link containing the startwith value is specified in this program where there are more than 10 invoices to display 0100 REM 1100 If continuing the invoice list the CGI field 0110 REM startwith is used to indicate what invoice 0120 LET STARTWITH STARTWITH FIELD CGI startwith ERR 0130 The invoices are presented in a HTML table structure so each line from the invoices file is formatted with table row tags In addition the table and column heading tags are required above and below the invoice list and are stored in TABLETOP and TABLEBOTS 0200 REM 100 Initialize other values 0210 LET KNUM 0 MAXRECS 10 0215 LET TABLETOP lt table border gt lt tr gt lt th gt Invoice lt th gt lt th gt Date lt th gt lt th gt Amount lt th gt lt tr gt 0220 LET STRUCTURE lt tr gt lt td gt invoice lt td gt lt td gt date lt td gt lt td align right gt amount lt br gt lt td gt lt tr gt 0225 LET TABLEBOT lt table gt 0400 REM 1100 Open Data Files 0410 LET CUSTCHAN UNT OPEN CUSTCHAN GENSMPL1 0420 LET INVCHAN UNT OPEN INVCHAN GENSMPL3 OSAS Web B2B User s Manual F 29 Sample Program Reference Basic Web Utilit
38. Substitutions Create More Records Information Either As a URL or As Hidden Form Tags Manage Session Record Substitute Occurrences of Text with Replacement Text Create HTML Table from an Array Append Text with Specified HTML Markup Tags to a HTML String Template Tools Program Uttplbas wbb Uttplcp wbb Description Load Data Template from Basis Data Dictionary Copy Matching Values from Source to Destination Templates OSAS Web B2B User s Manual Syntax call utencode wbb decode text result call utentity wbb text call utmeta wbb tpl text call utmore wbb cgi flds moreurl morehidden call utses wbb mode sesrec errmsg call utsub wbb text from to call uttable wbb caption options dat all work call uttags wbb tags text html Syntax call uttplbas wbb dict fl control tpl errmsg call uttplcp wbb source dest F 59 Toolkit Program Functional Listing Basic Web Utility Guide Conversion Tools Program Utcdate wbb Utcdtf wbb Utcnum wbb Utcprop wbb Utcstr wbb Description Convert Text Date to Internal Julian Integer or Date Time Number Convert Typical and OEM Text Date Formats to from Julian Date Convert Formatted Numeric Text String to a Number Convert a Text String to Proper Case Unmask a String Based on a Mask and Return an Internal Value Memo Field Tools Program Description
39. Support Telephone 800 582 5000 Support Fax 952 403 5870 Internet Address www osas com Contents Introduction Welcome to osas The OSAS Web B2B System Conventions OSAS Text Menu OSAS Graphical Menu OSAS Text Functions OSAS Graphical Functions Menu and Function Commands Favorites Menu Information Menu Reports Installation and Setup Installing the Web Server Installing OSAS Web B2B File Maintenance Item Group Codes Inventory Item Pictures Internet Inventory Item Groups Customer Internet Access Codes Customer Groups Tables Set Up Web Components Create Login Page Install Web Server Components OSAS Web B2B User s Manual 1 7 1 13 1 17 1 21 1 31 1 37 1 47 1 53 1 55 1 61 2 3 2 5 3 5 3 9 3 13 3 17 3 21 4 3 4 5 iii Contents Sales Order Processing Sales Order Processing on the Web Transaction Journal Build Sales Orders from Remote Files Purge Log File Remote Access Remote Access Copy Data Files to Web Server Copy OSAS Programs to Web Server Master File Lists Printing a Master File List Item Group Codes List Inventory Item Pictures List Internet Companies List Internet Inventory Item Groups List Internet Access Codes List Customer Groups List Tables List The Web Interface OSAS Web Login Page Account Information Aged Trial Balance History Inquiry Invoice Inquiry Item Inquiry Order Inquiry Order Entry References System Messages Commo
40. amount of memory to start the application with The default is 512 MAXTRIES The number of times the script attempts to start PRO 5 in the event of an error such as maximum users exceeded ERRORLOG The file to store messages when MAXTRIES is exceeded CONFIG The config bbx file used by the application BBEXEC The path to the PRO 5 executable Windows 95 and Windows NT The Basic Web Utility for Windows 95 and Windows NT is more complicated to set up and configure than for UNIX As an overview a windows executable is run from the web server s scripting directory This program reads in a configuration file and executes Visual PRO 5 Visual PRO 5 runs a program that creates the desired web page and writes the resultant HTML source to a temporary file The windows executable then passes the contents of this file back to the browser and the web page appears OSAS Web B2B User s Manual F 5 The Basic Web Utility and CGI Basic Web Utility Guide Because the Windows operating system does not handle stdin and stdout in the same manner as the UNIX operating system Visual PRO 5 must be run in I O mode and must utilize temporary files to send information back to the browser These temporary files are created in the web server s scripting directory so Visual PRO 5 must have WRITE permissions to that directory Additionally the web server s home drive must not be DSKSYN d so that Visual PRO 5 can manipulate these files Two separate ex
41. changes to list the items in that group If you click on an item ID you add that item to your order entry shopping cart if you are permitted to do so based on your customer ID and password If you click on a highlighted description you see additional description information and a graphical image of the item if available If you click on the price of any item you see a breakdown of quantity break pricing for this customer The page lists 10 items and subgroups for this customer If there are more than 10 items on file the Next and Previous buttons appear Click these buttons to scroll through the list of items OSAS Web B2B User s Manual 8 15 Item Inquiry The Web Interface To search for a specific item within any available group enter the item ID and then click Search for Item Click Top of Page to return to the top of the web page When you finish reviewing the information close the browser to end your session or choose a different menu selection from the side or top menus 8 16 OSAS Web B2B User s Manual The Web Interface Item Inquiry Item Additional Descriptions Screen entory Additional Descriptio oso erne plore 5 xj File Edit View Favorites Tools Help a Links gt Q rex v r x 2 2 O Search 5 7 Favorites N Media l r ca J 3 RER po Zu Em SYSTEMS INC Information Inventory Orders Item Inquiry Item Lookup ltemiD 900 EDEN Refrigerator Black Login
42. communication parameters needed to match the parameters on the Web server serial ports as specified in the rsttys txt file in the Basic Web Utility directory The raw device mode for the stty command must be included The default setting if no s option is specified is 9600 raw cs8 ixon ixoff ixany The v option if specified causes logging to take place for each transaction and error processed This can be redirected to a log file running in background Note The rswatch sh script requires editing to correctly start BBx Modify the values of lines beginning with bbexec bbenf and bbwebz accordingly F 64 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utaddr wbb ADDR low level Basic Web Utility routines Syntax CALL utaddr wbb Many Basic Web Utility programs make repeated use of several low level routines By making those routines resident in memory ADDR d processing performance is improved CALL this routine once at the beginning of any session that uses Basic Web Utility programs OSAS Web B2B User s Manual F 65 Toolkit Program Functional Listing Basic Web Utility Guide utcdate wbb Convert text date to internal julian integer or date time number Syntax CALL utcdate wbb strdate juldate This low level routine is used to convert a text string to a julian date value The current Business Basic default date format is used to determine whether the format is month day
43. documents about items or customers but not about employees or vendors Information The Information command gives you general information about the subject For customers the Information command lists sale amounts and important dates while for inventory items the same command lists quantities types and base prices When the Information screen appears enter the ID for which you want to view information Use the commands available at the bottom of the screen to scroll between or select a new ID then use the Exit F7 command to return to the function screen from which you accessed the Information command OSAS Web B2B User s Manual 1 55 Information Menu Introduction Comments Use the Comments command when it appears to view comments added through File Maintenance functions or to add comments about a customer item vendor employee or job The Comments screen appears after you access the Comments command The Customer Comments screen is shown below as an example Customer Comments P Commands Edit Modes Other Scroll Commands Help 2xe re mal g Dr Customer ID 5 ACE BUILDERS Ref ID End Date FIR Date Ref Comment 06 15 2002 003 SPOKE WITH JON RE EMAIL CONF AND ORDER TRACKING zj PLEASE NOTIFY JANE OF ANY SHORT SHIPMENTS a TRACER PUT ON LAST SHIPMENT aj ACE AGREED TO PAY 3000 ON 2 1 PLEASE NOTIFY JANE AT ACE WHEN ITEM IS MAILED CALLED CUSTOMER AB
44. in or in The in and in operators perform position checks on text fields and values If datafield is numeric in the template value must be a simple number If datafield is defined with a user attribute of date format value should be a text date such as 11 30 95 tif end tags may be nested An example follows if ytd sales gt 0 lt td gt Sales ytd_sales lt td gt end If datafield is not found in the data template and is not a global string variable the meta instruction is retained in the text Note that datafield should not be enclosed in brackets and there must be at least one space between datafield and opr and opr and value OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utmmoin wbb Convert memo field textarea tag CGI input to blocked text Syntax CALL utmmoin wbb cgitext blocked block Business Basic applications typically store variable length text fields in multiple records blocked to a certain size Often the maintenance of these blocks is performed one line at a time within the Business Basic application itself This routine simplifies the conversion of free form text entry in an HTML form into a format suitable for storage using blocking techniques The string variable cgitext contains data from a lt textarea gt input tag in a HTML form This information is sent to the server with CR LF characters wherever the user pressed the Enter key while ed
45. is replaced html returns its original value plus the formatted value of text OSAS Web B2B User s Manual F 109 Toolkit Program Functional Listing Basic Web Utility Guide uttplbas wbb Load data template from Basis data dictionary Syntax CALL uttplbas wbb dict fl control tpl errmsg This low level routine is designed to quickly return a template for a file defined in the BASIS data dictionary which is a directory that contains the BASIS data files LOCAT 1 FIELD 1 and TYPDEF 1 This program works directly with the dictionary files There is no need to initialize the extended utility or data dictionary environments dict contains the name of the directory where the dictionary files are stored If empty the files must be accessible through normal PREFIX based directory searching fl contains the name of the file of the dictionary to be loaded control is used internally to track open file channels used by this program It should be null when this routine is first called and passed unchanged to additional calls of this program To close the channels manually the channel values are stored in control in the 2 byte binary increments dec control 1 2 dec control 3 2 and dec control 5 2 tpl returns the data template for the specified file errmsg contains an error message if the template generation failed for any reason F 110 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Funct
46. low level routine is designed to convert various formats to and from julian values The legal values for format match those for date fields in data templates See the Data Templates section for more information tojul is set to 0 to convert from juldate to text or to 1 to convert from text to juldate format can be set to any of the following mdy MMDDYY mdyy MMDDYY YY ymd YYMMDD yymd YYY YMMDD dmy DDMMYY dmyy DDMMYYYY aon ADD ON date format soa State of the Art MAS90 date format text stores the stored text version of the date and juldate stores the julian integer version of the date OSAS Web B2B User s Manual F 67 Toolkit Program Functional Listing Basic Web Utility Guide utcgi wbb Set template variables based on the operating system environment and CGI input stream Syntax CALL utcgi wbb env cgi errmsg With the exception of utaddr wbb this is the first Business Basic CGI application program called Once executed the env and cgi string templates can be used to determine environment and CGI values The template env holds the system environment variables many of which are used in CGI applications For example env script name contains the logical name of the executable script that started the BBx session and env remote addr contains the IP address of the client browser that sent the request to the host server In addition to creating env values for each environment variable a global st
47. network systems By requiring any user to enter a password a firewall acts as a buffer from unwanted access into your system While they do not protect against viruses firewalls are recommended to protect sensitive data If you have questions and concerns your value added reseller can supply you with answers and suggestions If you are using a Windows Web Server that accesses data through a UNIX Data Server see on page 4 7 OSAS Web B2B User s Manual Installing OSAS Web B2B When you set up OSAS Web B2B you can elect to allow access to your OSAS data files directly from the Internet or to allow access to copies of your files stored on the web server even if the web server is installed on the same machine The process of using copies of your files is known as remote processing If you elect to use remote processing you must complete a few additional steps after you complete the installation and setup checklist below OSAS Web B2B Requirements and Applications You must have the Accounts Receivable application installed and set up on your system to use OSAS Web B2B OSAS Web B2B uses your Customer file as a basis for the access codes that allow your customers to access the OSAS Web B2B functions on the Internet You have control of which OSAS Web B2B functions can be run and by which customers However some of the functions require other OSAS applications in order to work With Accounts Receivable installed your cus
48. not unique the use of ky for repeated requests may return the same record It may be necessary to use the rsreadm wbb program to get a range of duplicate secondary keys rec returns the data record with trailing 00 hex 00 values removed errmsg returns an error message if an error occurs An Error 2 detects an end Wo of file condition when using modes n and p OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing rsreadm wbb Read a record range by way of an RS 232 serial connection Syntax CALL rsreadm wbb filename key1 key2 knum ky al rec all count errmsg This program communicates with a running rswatch wbb task on another system and scans the file for an available port to issue a request on Each serial port has a corresponding rswatch task running on the target system A library of available serial ports is maintained in the text file rsttys txt By using a dedicated serial connection between a live Business Basic system and a Web server system connected to the Internet it is possible to avoid potential security issues of having a TCT IP connection to the live system While a dedicated serial connection is slower and doesn t support concurrency it is secure filename is the name of the file on the target system to access It can be a full pathname or any name accessible to the task running rswatch wbb on the target system key1 and key2 specify the key range
49. on item description When you enter the description you can use the and wildcard characters to restrict or widen the search OSAS Web B2B User s Manual Introduction Menu and Function Commands Scroll Region Commands When the prompt gt is in a line item scroll region you can use the following commands The buttons are available only in graphical mode Hot Key Button Home Page Up Up Down Page Down End F3 Insert Enter I4 la le b bo Iu Operation Moves to the first line item in the entire list Moves to the previous screen or to the first line if you are on the first screen Moves up one line item Moves down one line item Moves to the next screen or to the last line if you are on the last screen Moves to the last line item in the entire list Deletes the line item in the selected line Inserts a line item at the selected line Edits or views the line item in the selected line In Field Editing Commands When the cursor is in a field that contains information you can use the following commands Hot Key Right Left Delete OSAS Web B2B User s Manual Description Moves the cursor to the right Moves the cursor to the left Deletes the character the cursor is on 1 51 Menu and Function Commands Hot Key Insert Home End F9 Undo F10 Delete to End of Line Shift F9 Copy Field Contents Shift F10 Paste Field Contents 1 52 Intro
50. options that control the order in which information is printed for example print the list by item code or by group code select the option you want to use to organize the information You can select only one print option If the screen contains check boxes or Yes No fields that control additional printing instructions select the check box or enter Y in text mode to use that option when printing the list Clear the check box or enter N in text mode if you do not want to use that option Select the output device to begin printing the list See Output the Report on page 1 64 for more information After you produce the list the Master File Lists menu appears OSAS Web B2B User s Manual Item Group Codes List The Item Group Codes List shows the item group codes that you set up using the Item Group Codes function on the File Maintenance menu Item Group Codes List 11 06 2002 l2 32 PM Group Description APPLIANCE Appliances DISHWASHER Dishwashers DOORS Doors Builders Supply Item Group Codes List HEAT AIR Heating and Air Conditioning Equipment INTERIOR Interior Materials MATERIALS Materials MILLWORK Millwork Trim and Doors PAINT Paints PARTS Cabinet Replacement Parts REFRIG Refrigerators STOVE Stoves and Ranges SUPPLIES Paint Supplies WINDOWS Windows End of report OSAS Web B2B User s Manual Paint Wallpaper Supplies Inventory Item Pictures List The Inventory Item Pic
51. order selected If there are more line items for the order the Next and Previous buttons appear Click these buttons to scroll through the line items for the order Click Top of Page to return to the top of the web page When you finish viewing line item detail use your browser s Back button to return to the Order Inquiry web page When you finish viewing order information close the browser to end your session or choose a different menu selection from the side or top menus OSAS Web B2B User s Manual Order Entry The Order Entry web pages allow your customer to enter a sales order through the Internet The customer chooses the items he wants from the item groups to which you grant him access Next the customer enters the quantity of the item that he wants to purchase and adds it to his shopping cart The OSAS Web B2B system then calculates the price and tax for the items the customers ordered and lists the order total When the customer submits the order and verifies the shipping information OSAS Web B2B creates the order as a quote using the batch ID you specified in the Resource Manager Company Information function in OSAS Screen Use Screen Order Entry Group Codes Order Entry Items Order Entry Line Item View Shopping Cart Shipping Information Order Number OSAS Web B2B User s Manual Description Use this screen to select the item group that contains the items you want to order Use this screen to
52. s Manual F 73 Toolkit Program Functional Listing Basic Web Utility Guide uterr wbb Generic error display routine Syntax CALL uterr wbb errnum linenum progname Handling unexpected errors in CGI applications is different from terminal based applications because there is no direct channel to the end user This routine provides an simple method of notifying the user of a problem Typically after CALLing this routine the program exits Business Basic To call this in PRO 5 use CALL uterr wbb err tcb 5 pgm 2 The routine generates a simple HTML page displaying a heading and error specifics The heading displayed for specific error codes can be controlled by creating global string values called errdesc n For example in PRO 5 the following creates a valid message for a missing file error dummy stbl errdesc 12 A missing file error occurred In addition to displaying an HTML page uterr wbb also attempts to mail an administrator user a message about the error To do this the global string value mailerror should be set to the email address of the administrator With a host running UNIX this feature opens a pipe to the UNIX mail command and sends a message detailing the error F 74 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utexit wbb Clean up Basic Web Utility work files in the Win CGI environment Syntax CALL utexit wbb cgi When the Basic Web Utility ope
53. scrolling applications it may be necessary to provide a link or button to a subsequent set of records through a more records link Often this type of link only requires one or two fields to be passed to the subsequent task This information can be easily created manually in Business Basic code However if many fields of information passed to the current task must be passed on to subsequent tasks this routine can simplify the task of creating the HTML text required The string template cgi is generated by utcgi wbb flds is an optional comma separated list of field names If specified only the field names specified are used to generate moreurl and morehidden from cgi If flds begins with then all fields in the template except those listed after the first comma are included in the generated document moreurl is returned as a text string that contains URL encoded field value pairs from the values stored in cgi For example if cgi state CA and cgi slsp z 100 then moreurl would contain state CAg sIsp 100 This can then be appended to the end of a cgi link URL such as cgi bin listrecs state CA amp slsp 100 morehidden is returned as a set of hidden field input tags for inclusion in a HTML form The above example would produce the following text lt input type hidden name state value CA gt lt input type hidden name slsp value 100 gt This can then be embedded in an HTML form along with a Submit bu
54. select the item you want to order from the group you selected Use this screen to enter the quantity of the item you want to calculate the price and to add the item to your shopping cart Use this screen to review your order to change the quantities on any item and to submit your order Use this screen to verify the shipping address for this order and to enter special notes about it This page displays the number that identifies your order 8 21 Order Entry The Web Interface Order Entry Group Codes HTML Screen 8 22 Sales Order Entry Microsoft Internet Explorer E E 10 xl File Edit View Favorites Tools Help au Om O 3 A 6 vorn qd O Br Se Ren p a Emm SYSTEMS INC Information Inventory Orders Order Inquiry ACEOO Order Entry CATE ACE BUILDERS T TUE Mir TEE 505 555 1646 Login Page Search for Item Choose the group that you want to order items from APPLIANCE Appliances DOORS Doors HEAT AIR Heating and Air Conditioning Equipment INTERIOR Interior Materials Paint Wallpaper Supplies MATERIALS Materials MILLWORK Millwork Trim and Doors PARTS Cabinet Replacement Parts WINDOWS Windows Top of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved za e
55. set up correctly with the customer and company from which you are trying to copy Company is not set up for Internet Transactions You cannot use the Build Sales Orders from Internet function for a company listed as Inactive Use the Company Information function on the Resource Manager Company Setup menu to change the OSAS Web status to Active Could not find ffile name You may have problems running OSAS Web without this file A required file is missing Without this file some functions within OSAS Web B2B will not work properly Make sure the required file is in the data path and try again Could not find file name You may have problems running OSAS Web without this program A required program is missing Without this program some functions within OSAS Web B2B will not work properly Make sure the required program is in the Resource Manager path and try again Could not find application information for Resource Manager The file OSAPPL is missing or corrupted Make certain that OSAPPL is in your Resource Manager path and try the function again OSAS Web B2B User s Manual A 1 System Messages Customer customer ID already has internet access The customer is already set up within this group Destination directory cannot be the same as source directory The destination directory entered is the same as the source directory Check for the correct destination directory and reenter it Internet access for customer ID in company
56. sh provides the interface mechanism for UNIX CGI requests OSAS Web B2B User s Manual F 113 A Abandon function key 1 38 pull down menu command 1 38 verification button 1 45 About OSAS pull down menu command 1 40 access code entering in graphical menus 1 24 parameter 1 4 tool button 1 24 Account Information web function 8 5 adding comments 1 58 Aged Trial Balance HTMLscreen 8 7 web function 8 7 Alias Inventory Lookup function key 1 43 1 50 pull down menu command 1 43 Application Information tool button 1 27 Application Setup right click menu 1 29 B base applications defined 1 3 Bell mode pull down menu command 1 40 Build Sales Orders from Remote Files function 5 7 screen 5 8 Build Sales Orders Log OSAS Web B2B User s Manual Index sample 5 9 C Calculator tool button 1 25 1 44 CGI defined 1 7 change to from Favorites tool button 1 25 1 29 changing companies graphical menus 1 29 click defined 1 13 Command Help pull down menu command 1 40 commands in field editing 1 51 report 1 66 scroll region 1 51 comments adding 1 58 editing 1 58 viewing 1 56 Common Questions B 1 companies changing 1 29 company parameter 1 4 conventions report 1 61 user s manual 1 13 Copied Files C 1 BBX Programs C 1 Copy function key 1 39 1 52 pull down menu command 1 39 tool button 1 44 Copy Data Files to Web Server function 6 5 screen 6 6 Copy OSAS
57. submit formhtml rem add form tags to form append to html script to perform update is cgi bin custupdt CALL uttags wbb form cgi bin custupdt formhtml html rem send out form in html to browser CALL utsend wbb html CALL utexit wbb cgi OSAS Web B2B User s Manual F 79 Toolkit Program Functional Listing Basic Web Utility Guide utfrmgn2 wbb Generate a complete HTML form from a template Syntax CALL utfrmgn2 wbb tpl flds captions flags captags actionval submitval resetval placement work This program uses utfrmgen wbb to create a form and adds the Submit and Reset buttons and form action tags to create a complete HTML input form For the tpl flds captions flags captags and work variables refer to the utfrmgen wbb documentation actionval contains the name of the script to execute when the Submit button is pressed All forms contain a tag similar to form methodz post action actionname gt The text in actionval is used for actionname submitval contains the caption used on the submit button s If this is null the browser places its own caption on the button resetval contains the caption used on the reset button s If this is null no reset button is created on the form placement is used to determine where to place the submit and reset buttons The following values are valid 1 Below form 2 Above form 3 Both above and below form Add 100 to these
58. the authoring tool These codes become redundant and appear in the body of the document F 40 OSAS Web B2B User s Manual HTTP Cookies Netscape Corporation introduced the concept of a cookie into their Navigator browser prompting the specification to be incorporated into other browsers Cookies provide a mechanism for the server to instruct the browser to retain certain data elements and to pass those data elements back to the server on demand Detailed information about cookies can be found on Netscape Corporation s web site http home netscape com Cookies are implemented in the Basic Web Utility via global strings If on the first call to utsend wbb a global string named cookies is defined it is assumed to be a comma separated list of cookie names Cookie names refer to other global strings with names and values passed to the browser through Set Cookie headers For example if the global string cookies is set to fe fi fo fum the Basic Web Utility looks for four global strings and instructs the browser to store their values In the Netscape cookie specification there are additional elements other than data values such as expiration dates and valid domain and path names These can be added to the value of the global string if desired and the Basic Web Utility issues the header Set Cookie name global string The cookie values are returned automatically by the browser in the CGI input stream and utcgi wbb looks for
59. the input fields top Captions are placed above the input fields In addition 1f the pre or table is specified the data is arranged in columns and array values in the template are scrolled within the column OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing The text string captags contains any tag used to format the captions before placing them in the HTML form This string is used in a CALL to uttags wbb Refer to that program page for more information linkexpr may contain one or more link definitions to use if any data field contains the link lead in option If multiple link expressions are contained in linkexpr they must be separated by an ASCII character 1 01 An example of a link expression links a record in a list to a full page display of that particular record Typically the full page display is based on the record s key field Here is an example assuming there is a script that will be given the records key through the ID field linkexpr cgi bin showpage ID ID encode Note that uthtmout wbb is CALLed recursively to format the actual URL used in the link so the same formatting information applies to text and linkexpr work is a text string that returns the HTML document with captions and data fields OSAS Web B2B User s Manual F 89 Toolkit Program Functional Listing Basic Web Utility Guide uthimkey wbb Generate HTML list from a file given a list of keys S
60. these and sets the global string values appropriately An example of cookie use would be as a session tracking mechanism If after calling utcgi wbb there is no global string ses id a unique code can be generated and placed into a global string ses id and that name can be placed in the global string cookies From that point whenever that page is loaded until the browser is closed on the user s system the ses id string will be maintained Using the expires domain and path data in the cookie specification it would be possible for the session ID to be tracked across an entire application for any length of time OSAS Web B2B User s Manual F 41 Automatic Session Tracking The Basic Web Utility 1 1 automatically manages session information using a single HTTP cookie called sesid The format of the session information is defined by creating a global string STBL named sestpl that contains the string template definition for the session This string must be defined before the application CALLs utcgi wbb and triggers the internal session management x stbl sestpl name c 30 custid c 10 items 100 c 20 call utcgi wbb env cgi errmsg In the above example the session tracks name custid and items array fields Any input from a form or URL that appears in cgi is automatically updated in the session values To retreive the session record do one of the following dim session stbl sestpl session stbl sesrec
61. to scroll through the groups Click on the description of the item group you want to view The screen changes to list the items and subgroups in that group If there are more than 10 item groups on file enter the group code and click Search for Group to search for a specific item group To search for a specific item within any available group enter the item ID and then click Search for Item 8 14 OSAS Web B2B User s Manual The Web Interface Item Inquiry Item Inquiry HTML Screen Items A OSAS Inventory Information Lookup Microsoft Internet Explorer 5 10 xj File Edit View Favorites Tools Help Item Inquiry E77 Login Page Information Inventory Orders Search for tem Item ID Subgroup Description Additional Unit of Unit Price Price Code Description Measure Breaks 900 Refrigerator Black EA 429 9100 5 0000 901 Refrigerator White EA 429 9100 20 0000 902 Refrigerator Almond EA 429 9100 20 0000 APPLIANCE Appliances Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 18998 2001 Open Systems Holdings Corp All rights reserved a al ODDO B Local intranet E The items and subgroups that belong to the group you select appear Units of measure unit prices and quantities appear for items in the group If you click a subgroup ID the screen
62. values for a horizontal rule and to separate the buttons from the form body If utfrmgn2 wbb recognizes any field types of type file the lt form gt tag is created with the enctype multipart form data option to support file uploading utcgi wbb is compatible with this attribute but only modern browsers support it i e Netscape Navigator 3 0 or above Microsoft Internet Explorer 3 0 or above OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utfrmin wbb Copy CGI input to a data template Syntax CALL utfrmin wbb cgi tp1 This is a high level program to copy data from the CGI input template to a data template It is sensitive to the user defined format attributes for defining date number and string formats This is typically used to copy data into a data template for storage in a file from either a form being updated or from a URL that contains CGI input fields cgi is the string template generated by utcgi wbb tpl is a data template that can incorporate user defined format attributes For more information see the Data Templates section OSAS Web B2B User s Manual F 81 Toolkit Program Functional Listing Basic Web Utility Guide utfrmout wbb Merge template data into HTML form output Syntax CALL utfrmout wbb tpl text work This high level program merges BBx data with HTML text and produces a result in work The intent is to produce an HTML form with the default hand
63. you need a declaration in your CGI setup to handle BBx programs and graphical images You must specify these virtual directories for e CGI scripts osasweb with the path to the OSAS Web B2B programs e graphical images image with the path to the graphical images style sheets style with the path to the OSAS Web B2B programs and style sheets If you have questions about setting up virtual directories consult your web server user s manual The web server must have access to a BBx interpreter in order for OSAS Web B2B to function If your web server can access your OSAS Resource Manager directory at all times you can use the interpreter installed there for OSAS Web B2B If not you must install a BBx interpreter on the web server itself before you install OSAS Web B2B Once you have your web server installed and operational you can proceed with OSAS Web B2B installation OSAS Web B2B User s Manual 2 3 Installing the Web Server Installation and Setup Security Procedures and Devices for OSAS Web B2B 2 4 Data security is a priority for many companies OSAS Web B2B is designed to secure your files customer lists and account information through use of integral password checks which you setup during your OSAS Web B2B installation To enhance OSAS Web B2B s built in security codes you may install a firewall for your web server A firewall is a generic name for a program or system that enforces access control between two
64. 0 Stores the user entered file name when a file upload field is posted from a HTML form When stored on the web server file system the Basic Web Utility retains the file extension but renames the file uploaded to a run time defined name The original name is stored in this global string Provides a path to the physical location of image files Any data field with a user attribute of image y is interpreted by the Basic Web Utility to be an image file In creating the HTML lt img src gt tag the Basic Web Utility attempts to open the file If the file cannot be located by a PREFIX search define imagelib as the physical path to open the file The Basic Web Utility can then determine the width and height of both gif and jpg images and create a img tag that is rendered faster by most browsers This is added to the beginning of any lt img src gt tags generated by the Basic Web Utility If imageurl is home images and a data field with a user attribute of image y is 1001 gif the Basic Web Utility defines the tag as lt img src home images 1001 gif gt Note the imagelib can also help in determining the width and height for the tag An internally maintained value used by utwatch wbb and utcgi wbb OSAS Web B2B User s Manual Basic Web Utility Global String Reference Global String STBL Usage Slist mailerror memospacer memotable moreurl otherhead outchan outfile OSAS Web B2B U
65. 11 06 2000 Terminal TODO OVR 1 The location of the OSAS Web B2B directory on the web server appears Press Enter to accept the path shown or enter a different path 2 Select the output device to produce the journal See Output the Report on page 1 62 for more information on output devices OSAS Web B2B User s Manual 5 5 Transaction Journal Sales Order Processing Transaction Journal Report 5 6 11 01 2002 4 51 PM 00000142 00000144 00000145 00000146 00000149 End of rep 11 01 2002 11 01 2002 11 01 2002 11 01 2002 11 01 2002 ort Builders Supply Transaction Journal New Order No Additional Comments Please process promptly Note Shipping Address Change May substitute standard window OSAS Web B2B User s Manual Build Sales Orders from Remote Files You can elect to allow access to your OSAS data files directly from the Internet or to copies of your files which have been placed on the web server The process of using copies of your files is known as remote processing See chapter 2 for more information about remote processing Use the Build Sales Orders from Remote Files function to copy orders entered through the web to quotes in your OSAS Sales Order data files Do not use this function if you are not using remote processing with OSAS Web B2B When you elect not to use remote processing the orders are entered as quotes directly into your OSAS files Because remote proces
66. 2B User s Manual Basic Web Utility Global String Reference Global String STBL Usage usechan waitsec OSAS Web B2B User s Manual Used to force the Basic Web Utility to search for available channels above this value If the Basic Web Utility conflicts with other programs used in an application set this value to a high number to prevent the Basic Web Utility from using the UNT value to open files Used by utwatch wbb to pause a specified number of seconds between directory scans The default is one second F 51 Toolkit Program Reference Overview The Basic Web Utility toolkit consists of a number of Business Basic programs and operating system executables Some of the programs are considered high level programs and they CALL lower level programs to perform a task Some routines may CALL other high level programs to provide a more complete encapsulation of a task Toolkit Program Alphabetical Listing Program rsread wbb rsreadm wbb rswatch sh utaddr wbb Utcdate wbb Utcdtf wbb Utcgi wbb Description Read a record by way of an RS 232 serial connection UNIX only Read a record range by way of an RS 232 serial connection UNIX only Watch a RS 232 serial port on a target system UNIX only ADDR low level Basic Web Utility Routines Convert Text Date to Internal Julian Integer or Date Time Number Convert Typical and OEM Text Date Formats to from Julian Date Set Template Va
67. 9 In UNIX you can enter the parameters in any order and you can use any combination You must leave a space between the parameter mark t c or a and the parameter itself In Windows you can set up OSAS such that it always opens using a certain access code Open the OSAS program shortcut s properties and enter the access code and your company ID in the Target box For example using apple as your access code and H as your company ID enter the following C osas progRM osastm exe m4096 tT00 nTOO aapple cH If you want the system to prompt for an access code after opening enter a in the Target field followed by a space followed by c and the company ID In the Windows icon properties the parameter marks m t or n can be entered in any combination but must be before the separation dash The access code and company ID commands a and c must be entered after the separation dash See the Resource Manager Installation Manual for more information on these parameters OSAS Web B2B User s Manual 1 5 The OSAS Web B2B System B2B is a software industry term that describes web based systems that facilitate business to business transactions OSAS Web B2B is just such a system You can use the OSAS Web B2B application to allow your customers access to selected information from your OSAS data files with any web browser Your customers can also use the OSAS Web B2B system to enter sales orders into your system throu
68. ACEO01 PARTS ACEO01 WINDOWS CASHCA INTERIOR CASHMD INTERIOR CASHMN INTERIOR CASHPS INTERIOR CASHTX INTERIOR DALOO1 HEAT AIR DALOO1 INTERIOR GREOO1 HEAT AIR GREOO1 INTERIOR KANOOlL HEAT AIR KANOOlL INTERIOR LOSO01 HEAT AIR LOSOO01 INTERIOR SUNOO1 HEAT AIR SUNOO1 INTERIOR TENOO1 HEAT AIR TENOO1 INTERIOR VISOO1 INTERIOR End of report Builders Supply Customer Groups List Group Description Appliances Doors Heating and Air Conditioning Equipment Interior Materials Paint Wallpaper Supplies Materials Millwork Trim and Doors Cabinet Replacement Parts Windows Interior Materials Paint Wallpaper Supplies Interior Materials Paint Wallpaper Supplies Interior Materials Paint Wallpaper Supplies Interior Materials Paint Wallpaper Supplies Interior Materials Paint Wallpaper Supplies Heating and Air Conditioning Equipment Interior Materials Paint Wallpaper Supplies Heating and Air Conditioning Equipment Interior Materials Paint Wallpaper Supplies Heating and Air Conditioning Equipment Interior Materials Paint Wallpaper Supplies Heating and Air Conditioning Equipment Interior Materials Paint Wallpaper Supplies Heating and Air Conditioning Equipment Interior Materials Paint Wallpaper Supplies Heating and Air Conditioning Equipment Interior Materials Paint Wallpaper Supplies Interior Materials Paint Wallpaper Supplies OSAS Web B2B User s Manual 7 15 Tables List The Table
69. Clears data from all fields and moves the cursor to the first field on the screen Deletes information on the screen Since this command deleted an entire record use it with caution OSAS Web B2B User s Manual Introduction OSAS Graphical Functions Command Description Jump Moves the cursor to the next block of data on the screen or to the next field that requires an entry Exit Exits from a screen or a window without saving data Edit Menu Commands Edit Modes Other Information Help E xt Copy Shft F9 Paste lt Shft F10 gt e Undo Ctrl 2 Command Description Copy Copies the contents of the current field Paste Pastes the value you copied from a previous field into the current field Undo Restores the contents of the current field from before you made changes to it Modes Menu Select the options you want to use Commands Edit Modes Other Information Help 3 xE p y Verify Exit NS v Bell Quick v Verify PgDown Command Description Verify Exit When verification is on you must press a key twice to verify that you want to exit or abandon functions OSAS Web B2B User s Manual 1 39 OSAS Graphical Functions Introduction 1 40 Command Bell Quick Verify PgDown Description When the bell is turned on it sounds at an error or when you must verify a command When this option is off the cursor stops at every field possible To make the cursor skip the fields that do not
70. E TXT Used by OWAGE BBX OWINV TXT Template text file for OWINV BBX OWINVPR TXT Template text file for OWINVPR BBX OWORDR TXT Used by OWLOOKUP OWORD2 TXT Template text file for OWORD2 BBX OWORD6 TXT Template text file for OWORD6 BBX OWHIST TXT Used by OWLOOKUP OWINVL TXT Used by OWLOOKUP OWPBRK TXT Template text file for OWPBRK BBX OWSESS TXT Invalid Session message OWORDASK TXT Continue New Order message OWORDER TXT Template text file for OWORDER BBX OWORDER2 TXT Template text file for OWORDER2 BBX OWORDER3 TXT Template text file for OWORDER3 BBX OWORDER5 TXT Template text file for OWORDERS BBX OWORDER6 TXT Template text file for OWORDER6 BBX OWORDER7 TXT Template text file for OWORDER7 BBX OWBADQTY TXT Invalid Quantity message OSAS Web B2B User s Manual C 3 List of Files Copied C 4 OWADDL TXT OWITEMS TXT OWBUSY TXT OWNOVIEW TXT Template text file for OWPASSWD BBX Used by OWLOOKUP Process Interrupted message No Items to View message Standard CGI Executables These programs accept user input start the BBx interpreter and run the necessary OSAS Web B2B program When the BBx program is finished these programs load the resulting web pages OWMENU EXE OWARMENU EXE OWINMENU EXE OWSOMENU EXE OWLOOKUP EXE OWINVPR EXE OWORD2 EXE OWORDER3 EXE OWORD6 EXE OWORDER4 EXE OWPBRK EXE OWORDERS EXE OWADDL EXE OWORDER6 EXE OWORDER EXE OWORDER7 EXE OWORDER2 EXE Files Copied and Function in OSAS Web B2B When you copy fi
71. GI EXE OSAS Web B2B User s Manual C 7 Editing Files You may need to edit certain files to set up remote processing or correct errors This appendix demonstrates how to edit your CONFIG BBX file DOS batch files and UNIX shell scripts Modifying CONFIG BBX If you are using multiple drives and Remote Processing you may need to modify CONFIG BBX to use the dsksyn command If your data lies outside the current directory you must add the prefix command CONFIG BBX stblen 3072 fcbs 70 handles 70 cibs 70 USE_LIM aliases 20 dsksyn a dsksyn b prefix httpd httpd bbx e progrm There are two important settings to know about when you set up the CONFIG BBX file prefix and dsksyn If you have the data files in a different path than the BBx directory you should specify this in the prefix by entering the full path name of the location where the data files reside Make sure that you use forward slashes and end the path with a forward slash If the interpreter is on a different path than the BBx directory you will need to add that path to the prefix also Separate multiple prefix entries with a single space OSAS Web B2B User s Manual D 1 Editing Files If a prefix refers to a different drive than the root drive you must use the dsksyn command This command lets BBx know it can skip looking in a particular drive For example imagine you use drives A B C D and E and you keep your data files on driv
72. M 11000 generic error trap 2010 CALL uterr wbb ERR TCB 5 PGM 2 2020 GOTO DONE Customer Maintenance democent bbx This program generates a customer maintenance form By default the form contains no customer data and can be used to create a new customer record However if the CGI field cust id is filled in with a valid customer number that customer record can be edited and updated Unlike the prior examples an HTML document template is not used Instead the HTML text is created in the program 0001 SETERR ERRTRAP 0010 REM democent bbx Basic Web Utility demo customer entry form 0020 REM Copyright 1996 by Allen Miglore All rights reserved 0030 REM Permission to derive programs from this is hereby granted provided OSAS Web B2B User s Manual F 31 Sample Program Reference Basic Web Utility Guide F 32 0040 REM said programs utilize licensed copies of the Basic Web Utility 0100 REM 100 Get customer record If the CGI field cust id contains a valid customer number the customer record is loaded into the data template CUST Otherwise the template is initialized from the startup program 0110 LET CUSTCHAN UNT OPEN CUSTCHAN GENSMPL1 0120 READ RECORD CUSTCHAN KEY FIELD CGI cust_id ERR 0200 ERR 0200 CUST An entry form is generated from the CUST data template The cust id field is hidden and cannot be edited though it is passed to the democupd bbx program Fields indicated with a show option are
73. OPEN SYSTEMS Accounting Software OSAS Web B2B User s Manual 2210 0W65 O 2003 Open Systems Holdings Corp All rights reserved Document Number 2210 0W65 No part of this manual may be reproduced by any means without the written permission of Open Systems Inc OPEN SYSTEMS and OSAS are registered trademarks and Resource Manager Resource Manager for Windows and Report Writer are trademarks of Open Systems Holdings Corp BB is a trademark and PRO 5 and Visual PRO S are registered trademarks of BASIS International Ltd Novell and NetWare are registered trademarks of Novell Inc Microsoft Windows Windows 95 Windows 98 Windows NT Windows 2000 and MS DOS are either trademarks or registered trademarks of Microsoft Corporation Adobe and Acrobat are registered trademarks of Adobe Systems Inc TrueType is a registered trademark of Apple Computer Inc Printed in U S A This manual is recyclable April 2003 Release 6 5 This document has been prepared to conform to the current release version of OPEN SYSTEMS Accounting Software Because of our extensive development efforts and our desire to further improve and enhance the software inconsistencies may exist between the software and the documentation in some instances Call your customer support representative if you encounter an inconsistency Open Systems Inc 1157 Valley Park Drive Suite 105 Shakopee Minnesota 55379 General Telephone 952 403 5700 General Fax 952 496 2495
74. OUT PAST DUE BALANCE Y ij zj Ref ID end Date new ID Append Enter edit First Next Prev Last Goto Company H 10 08 2002 Terminal T000 OVR 1 Enter the ID for which you want to view or enter comments in the ID field at the top of the screen The Inquiry F2 command is available 2 The ID of the terminal you are working at appears in the Ref ID field To work with comments for only the default reference ID press Enter To work with comments for a different reference ID enter that ID To work with all comments clear this field and press Enter 3 Enter the date of the most recent comment you want to work with in the End Date field or press Enter to work with all comments 1 56 OSAS Web B2B User s Manual Introduction Information Menu The date reference and text that appear for each comment depend on the reference ID and end date you enter The comments are arranged by date the most recent date first then by reference ID 4 Use these commands to work with the comments on the screen e Press R to return to the Ref ID field to enter a new reference ID e Press D to return to the End Date field and enter a new end date by which to sort comments Press I to return to the ID field and enter a new ID for which to view or enter comments e Press A to add a new comment The Append Comment screen appears e Press E to edit a selected comment The Edit Comment screen appears e Press F to v
75. OWPURGE PUB OWPC BBX UTHTMCON UTHTMFIL BBX Order Entry Select Shipping Address Information Detail History Inquiry Item Inquiry Group Code Breakdown Item Inquiry Items for the group code you selected Item price calculator Item Inquiry Price Break Information Additional Description Picture Order Entry Group Code Screen Order Entry Items for the group code you selected Order Entry Line Item Entry Order Entry Recalculate Prices and Submit Line Order Entry View Submit Order Order Entry Recalculate Prices and or Show Shipping Information for submitting an order Order Entry Move an order into Sales Order Get the path of the BBx directory on the web server Verify the SESSION ID Set the template for the SESSION string Remove all entries from the SESSION file that are more than 24 hours old Get period information from RMTB Builds conditional hypertext links based on input provided from the calling program Builds odd even row coloration based on the stylesheet OSAS Web B2B User s Manual List of Files Copied HTML Base Pages These files contain the framework for the HTML pages displayed to Internet users The data requested by the users is merged into the framework by the programs listed above OWPASSWD TXT Template text file for OWPASSWD BBX OWMENU TXT Template text file for OWMENU BBX OWBASE TXT Template text file for elements common to all screens OWCUST TXT Used by OWLOOKUP OWAG
76. PEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved OSAS Web B2B User s Manual Y Local intranet 8 11 Invoice Inquiry The Web Interface Invoice Detail HTML Screen When you click an invoice number on the Invoice Inquiry web page OSAS Web B2B re creates that invoice form from the entries in the AR and IN history files and displays the invoice s detail on this web page F OSAS Customer History Invoice Microsoft Internet Explorer E E 10 xl Fie Edit View Favorites Tools Help ay Links gt Qm O 8 Dave eme 9 eC Lm 3 mnm i z e 4 SYSTEMS INC Information Inventory Orders Informati ELLE TRE ATTN ACCOUNTS PAYABLE BERNER ACE BUILDERS ACE BUILDERS 1588 SE 318T STREET 1588 SE 31ST STREET PADUCAH KY 28655 7865 PADUCAH KY 28655 7865 Aged Trial Balance History Inquiry Invoice Inquiry So 12 21 2000 GPD 47591774 C O D 12670074 Login Page METETE Quantities units Price Amount 100 Electrical Package Shipped 47 0000 PKG 324 6549 15258 78 300 Interior Door Shipped 5 0000 EA 20 8000 104 00 350 Entry Door Shipped 10 0000 EA 214 5060 2145 06 450 Slide by Window 24 x 40 Shipped 10 0000 EA 146 4090 1464 09 460 Slide by Window 30 X 40 Shipped 10 0000 EA 160 6410 1606 41 600 Standard Window 24 X 40 Shipped 10 0000 EA 114 3730 1143 73 Location Tax Breakd
77. Page 25 5 cuft Frostfree side by side Water and ice dispenser Top of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved 5 Local intranet Click Top of Page to return to the top of the web page When you finish viewing additional descriptions use your browser s Back button to return to the Item Inquiry web page When you finish reviewing items close the browser to end your session or choose a different menu selection from the side or top menus OSAS Web B2B User s Manual 8 17 Item Inquiry The Web Interface Item Price Breaks HTML Screen 8 18 File Edit View Favorites Tools Help w Q rex X x 2 0 9 Search Sp Favorites pa a AL J 3 Links gt p SEN Information Inventory Orders Item Inquiry Item Lookup En 900 Refrigerator Black Login Page 429 9100 Quantity Price Break 5 0000 419 9100 10 0000 409 9100 Top of Page Problems or Questions Email Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved Local intranet Click Top of Page to return to the top of the web page When y
78. SAS Web B2B User s Manual Basic Web Utility The Basic Web Utility and CGI Two associated bat files stdcgi bat and wincgi bat are text files designed to contain configuration parameters used by the executables to specify how Visual PRO 5 should be run The bat file extension is used for historical reasons and these files are never actually executed as a typical batch file The appropriate bat file should be copied to the same directory as the exe file mentioned above Both the exe file and bat file may be renamed to something more descriptive such as custquery exe and custquery bat However they must retain their original extension and the root of the file name must be the same for both files This allows you to define multiple queries for use with the web server The next step is to edit the bat file to modify the BBPROG BBEXEC BBCONFIG MEM BBTERM and USERID parameters These parameters are used to tell the cgi executable how to find Visual PRO 5 and what startup options to pass to it Note that when specifying paths for Visual PRO 5 the configuration file and the program file all directories with spaces in their names should be changed to reference the short name For example if Visual PRO 5 exists as c program files basis vpro5 vpro5 exe the BBEXEC parameter should be set to c progra 1 basis vpro5 vpro5 exe Parameter Description BBPROG Specifies the program that Visual PRO 5 will run This program will be responsibl
79. Setup OSAS Web B2B Components Use the functions on the Setup OSAS Web Components menu to create your Web Login Page based on the criteria you set up through the File Maintenance functions and to install the OSAS Web components on your web server Master File Lists Use the functions on the Master File Lists menu to produce listings of the information you entered using the File Maintenance functions Use the lists to verify your entries or for future reference 1 10 OSAS Web B2B User s Manual Introduction The OSAS Web B2B System Application Interaction OSAS Web B2B is an application that translates your OSAS data into fields accessible through the Internet The information available for access comes from the Inventory Accounts Receivable and Sales Order applications Resource Manager Inventory gt OSAS Web B2B Accounts Receivable Sales Order The Internet OSAS Web B2B s application interaction means that the information you enter in one application can be transferred to and used in other applications This process reduces data entry time and the number of errors that might creep in along the way OSAS Web B2B uses data from Inventory Accounts Receivable and Sales Order displaying this data to users on the Internet requesting the information from your web server In return sales orders entered through OSAS Web B2B update your Sales Order files Yo
80. T statement andor specifies whether the AND or OR boolean is used between fields in where If this is not set to or then and is assumed Any field in cgi and tpl that isn t null in cgi is evaluated The field name for the where clause expression fragment is taken from cgi If a cgi field called opr name is found the where clause operator is taken from that field Otherwise the text of the cgi field itself is analyzed for an operator Operators can be lt gt lt gt lt gt in like and between If there is no operator but the data in cgi contains or characters and the tpl definition for the field is character rather than numeric the like operator wildcard is used Otherwise text fields must start with the characters entered and numeric fields must be equal to the number entered OSAS Web B2B User s Manual F 103 Toolkit Program Functional Listing Basic Web Utility Guide If the operator is between there must be exactly two occurrences of the same field name and the where clause will be formed as field gt first value and field lt second value If the same field occurs multiple times in cgi as can happen with checkboxes multiple selection lists or intentionally created duplicate named tags multiple where clause expressions are created with OR boolean logic other than the between operator case noted above distinct from the AND or OR booleans used between unique field nam
81. The external number 10 01 becomes 1001 when stored mask format Use format for output All numerics not interpreted as dates are processed with utcnum wbb on input Caption phrase See Text Fields above OSAS Web B2B User s Manual F 19 Data Templates Basic Web Utility Guide Date Fields date format Dates default to Julian integer format If format is anything other than a known format Julian storage 1s assumed Custom formats include mdy MMDDYY e mdyy MMDDYYY Y ymd YYMMDD yymd YYYYMMDD dmy DDMMYY dmyy DDMMYYYY e jul julian integer dtm julian date with time precision Caption phrase See Text Fields above F 20 OSAS Web B2B User s Manual Sample Program Reference Sample Program Reference Overview The sample programs provided with the Basic Web Utility can be used as learning guides as well as the basis for practical CGI programs A UNIX shell script to start a specific Business Basic program demobbw bbx establishes the Basic Web Utility CGI environment It then locates the CGI value of pgm to determine which sample program to run If no pgm value is specified a menu is presented The Customer Inquiry application uses the programs democlst bbx and demoilst bbx These in turn use the HTML document template files democlst txt and demoilst txt The Customer Maintenance application uses the programs democent bbx and democupd bbx The democent bbx links to the customer list p
82. Utmmoin wbb Convert Memo Field text area tag CGI Input to Blocked Text Utmmoout wbb Format Text Containing CR LF Characters As HTML Syntax call utcdate wbb strdate juldate call utcdtf wbb tojul format text juldate call utcnum wbb text value call utcprop wbb text call utcstr wbb text mask result Syntax call utmmoin wbb cgitext blocked block call utmmoout wbb textin textout OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing RS 232 Serial Connection Tools Program Rsread wbb Rsreadm wbb Rswatch wbb Other Tools Program Utaddr wbb Utenv wbb Utisip wbb Uttempfl wbb Description Read a record by way of an RS 232 serial connection UNIX only Read a record range by way of an RS 232 serial connection UNIX only Watch a RS 232 serial port on a target system UNIX only Description ADDR low level Basic Web Utility Routines Get Environment Variable Verify if the Remote Client Address Is in a List of Valid Addresses Create and Open a Temporary String File OSAS Web B2B User s Manual Syntax call rsread wbb filename mode ky knum rec errmsg call rsreadm wbb filename key1 key2 knum ky all rec all count errmsg rswatch sh d tty device s stty parameters v Syntax call utaddr wbb call utenv wbb name value call utisip wbb env iplist valid call uttempfl wbb
83. WSOMENU BAT OWLOOKUP BAT OWORD2 BAT OWORD6 BAT OWINVPR TMP OWPBRK BAT OWADDL BAT OWORDER BAT OWORDER2 BAT OWORDER3 BAT OWORDER4 BAT C 5 List of Files Copied OWORDER5 TMP OWORDER6 TMP OWORDER7 TMP OWORDERS BAT OWORDER6 BAT OWORDER7 BAT For both UNIX Linux and Windows based systems the CONFIG file is the same and is not renamed CONFIG TMP BB Web Components config bbx Many BB Web components are copied directly to the Remote Access web server Below is a list of the files copied BBWEB DOC BBWEB CNF DEMOBBW BBX DEMOCUPD BBX DOSCGI BAT RSREADM WBB RSWATCH WBB UTCDATE WBB UTCGIWIN WBB UTENCODE WBB UTEXIT WBB UTFRMOUT WBB UTHTMOUT WBB UTMMOIN WBB UTSEND WBB UTTEMPFL WBB C 6 GENSMPLI BBWEB SH DEMOCENT BBX DEMOILST BBX LICENSE TXT RSTTYS LCK STDCGLEXE UTCDTF WBB UTCNUM WBB UTENTITY WBB UTFRMGEN WBB UTHTMFIL WBB UTHTMSEL WBB UTMMOOUT WBB UTSUB WBB UTTPLBAS WBB GENSMPL2 BBWEB2 SH DEMOCLST BBX DEMOILST TXT README RSTTYS TXT JTACTV WBB JTCGI WBB JTCPROP WBB JTENV WBB JTFRMGN2 WBB JTHTMGEN WBB JTISIP WBB JTMORE WBB TTABLE WBB JTTPLCP WBB Ed Gh Gl EA r xc E GENSMPL3 BBWEBNT PL DEMOCLST TXT DEMOMENU TXT RSREAD WBB RSWATCH SH UTADDR WBB UTCGIACC WBB UTCSTR WBB UTERR WBB UTFRMIN WBB UTHTMKEY WBB UTMETA WBB UTSELECT WBB UTTAGS WBB UTWATCH WBB OSAS Web B2B User s Manual List of Files Copied BBWEB DOC GENSMPLI GENSMPL2 GENSMPL3 WINCGI BAT WINC
84. XRECS COUNT CURKEY INVOICE STRUCTURE INVLIST 0540 IF CURKEY gt THEN LET CURKEY CURKEY LEN CGI CUST_ID 1 0600 REM 1100 If there are more records in the file add a more records 0610 REM link URL to continue curkey contains the key to the 0620 REM next record required By placing this in a STBL the 0630 REM uthtmout wbb program that loads the HTML template can 0640 REM conditionally place it after the list 0650 LET X STBL MOREURL IF CURKEY THEN GOTO 0680 0660 CALL utencode wbb 0 CURKEY NEXT_STARTWITH OSAS Web B2B User s Manual Basic Web Utility Sample Program Reference 0670 LET MOREURL STBL MOREURL ENV SCRIPT_NAME pgm demoilst bbx amp startwith NEXT_STARTWITH amp cust_id CGI CUST_I D Both the customer information and the invoice list are substituted into the demoilst txt file using specific comments as place markers with the result sent to the user and the program exits 0680 REM 1100 Load the HTML template and add the list to it 0690 CALL uthtmout wbb CGI include demoilst txt HTML 0700 CALL utsub wbb HTMLS Customer Info gt CUSTINFOS 0710 CALL utsub wbb HTML3 lt Invoice Table gt TABLETOP 0A INVLIST TABLEBOT 0800 REM 1100 Send it to the user 0810 CALL utsend wbb HTML 1000 DONE REM 11000 Clean up and exit 1010 CALL utexit wbb CGI 1020 IF RETURN_TO_WATCH THEN RUN utwatch wbb 1030 RELEASE 2000 ERRTRAP RE
85. ads the CGI environment with a CALL to utcgi wbb and creates the data templates used by the other sample programs 0010 REM demobbw bbx startup for Basic Web Utility demo programs 0020 REM Copyright 1996 by Allen Miglore All rights reserved 0100 REM 100 Introduction 0110 REM This is the startup routine used by the Basic Web Utility demo 0120 REM program It reads the CGI input stream sets up the 0130 REM data templates loads a salesperson code table and then runs 0140 REM a specified program The default program is a customer list 0200 REM 100 get cgi inputs 0210 CALL utaddr wbb OSAS Web B2B User s Manual F 23 Sample Program Reference Basic Web Utility Guide F 24 0220 CALL utcgi wbb ENV CGI ERRMSG IF ERRMSG gt THEN GOTO LOADERROR 0300 REM 1100 Dim templates used by the files 0310 DIM CUSTS cust_id c 5 name c 30 case upper addr 1 c 30 caption Address_ 1 case upper addr2 c 30 caption Address_2 case upper city c 20 case upper state c 2 case upper zip c 5 phone c 10 mask 000 000 0000 date_last_sale c 8 date yymd date_last_pmt c 8 date yymd class c 2 sIsp c keys stbl_ SLSPID vals stbl_ SLSPNM sep formtype list rows 1 terms c 2 credit_limit n 8 mask 0 ytd_sales n 10 mask 7 0 00 mtd_sales n 10 mask 0 00 ytd_cost n 10 mask 0 00 mtd_cost n 10 mask 0 00 0320 DIM INVOICE cust_id c 5 invoice c 5
86. alue call utcprop wbb text call utcstr wbb text mask result call utencode wbb decode text result call utentity wbb text call utenv wbb name value call uterr wbb errnum linenum progname call utexit wbb cgi call utfrmgen wbb tpl flds captions flags captags work call utfrmgn2 wbb tpl flds captions flags captags actionval submitval resetval placement work call utfrmin wbb cgi tpl OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Reference Overview Program Utfrmout wbb Uthtmfil wbb Uthtmgen wbb Uthtmkey wbb Utfrmout wbb Uthtmsel wbb Utisip wbb Utmeta wbb Utmmoin wbb Utmmoout wbb Utmore wbb Utselect wbb Description Merge Template Data Into HTML Form Output Generate HTML List from a File Given a Key Range and Format Definition Generate HTML Tags and Text from a Template Generate HTML List from a File Given a List of Keys Merge HTML Text with Data from a Data Template Generate HTML List from a BBx or PRO 5 Select Verb Verify if the Remote Client Address Is in a List of Valid Addresses Scans Text For Special Substitutions Convert Memo Field text area tag CGI Input to Blocked Text Format Text Containing CR LF Characters As HTML Create More Records Information Either As a URL or As Hidden Form Tags Create Select Where Clause from CGI Input Fields OSAS Web B2B User s Manua
87. ame system where OSAS is installed If you use remote processing the programs and data files reside on the web server If you are using a Windows Web Server that accesses data through a UNIX Data Server see on page 4 7 For a list of the files copied see appendix C OSAS Web B2B User s Manual 4 5 Install Web Server Components Set Up Web Components Install Web Server Components MEE Commands Edit Modes Other Help 2xe rel mu OK Abandon Path from OSAS to Web Server Programs Path Jc inetpub wwwroat osasweb Path from OSAS to Web Server Images Path Jc inetpub wwwroat osasweb image Path from Web Server to BBx Interpreter Path Data File Path c osas65 data System File Path Web Server System c 0sasE5 progAM c osas65 sample Je fosas65 systil Web Server Resource Manager Path Jc osas65 progAM Web Server Local Programs Path Jc inetpub wwwroat osasweb Web Server Local Images Path Jc inetpub wwwroot osasweb image DOS X Web Server Interpreter WPRO5 EXE Field Definitions Field Name Web Server Programs Path Web Server Images Path BBx Interpreter Path Data File Path 4 6 Company H 11 06 2000 Terminal T000 INS Description Enter the full path from the OSAS system to the web server programs path Enter the full path from the OSAS system to the web server images path Enter the full path from th
88. and finally by lowercase letters No matter what you enter in the From and Thru fields however your entries are sorted in alphabetical order unless the function provides an option to sort the information differently Sorting by alphabetical codes or IDs is easy For example the ID ACL comes before the ID BB because A comes before B OSAS Web B2B User s Manual 1 61 Reports Introduction Use caution when you enter codes or IDs consisting of characters other than letters the order might not be what you expect For example if 20 items are labeled 1 through 20 and all are included in a report you might enter 1 at From and 20 at Thru expecting them to be listed 1 2 3 19 20 However since OSAS sorts in alphabetical order the numbers are listed in this order 1 10 19 2 20 In this example numbers 3 9 are not included in the sort since they fall after 20 in an alphabetical sort To prevent this situation pad extra spaces in codes and IDs with zeros so that numbers in alphabetical order are also in numerical order In the example above the items would be labeled 000001 through 000020 Output the Report The type of menus you use controls which options are available to output reports If you are using graphical function screens you have the following output options Printer Print Preview File or E mail for selected reports If you are using text function screens you have these options Printer Preview File Screen o
89. ands Help 2x Be man g OK Abandon Group Code Customer ID ACE BUILDERS Group Code Group Description APPLIANCE Appliances DOORS Doors HEAT AIR Heating and Air Conditioning Equipment INTERIOR Interior Materials Paint Wallpaper Supplies MATERIALS Materials MILLWORK Millwork Trim and Doors Cabinet Replacement Parts Windows Lb p o Lia bad First Next Prev laSt Append aLl nOne Header Goto Company H 11 05 2002 Terminal TODO OVR Inquiry To list the group codes a specific customer can access leave the Group Code Maint field blank and enter the customer ID you want to view in the Customer ID field The item groups this customer can access appear Commands Use these commands to work with the information on the screen e Press F to view the first item group or customer on file e Press N to view the next item group or customer on file e Press P to view the previous item group or customer on file e Press S to view the last item group or customer on file 3 18 OSAS Web B2B User s Manual File Maintenance Customer Groups e Press A to add a customer or item group to the list then enter the ID or code to add e Press L to add access for all customers or item groups to the list e Press O to clear the list for the selected item group or customer Press H to return to the header section to select a different cu
90. argument is null the cgi variable bbweb s is checked If present it is used as the starting point for the list On exit if more records are available the program generates a global string STBL moreurl that contains the full URL with any cgi fields retained and with bbweb s incremented for the next page This can be used in a hyperlink for a continuation if moreurl gt a href moreurl gt More records amp ldots lt a gt end This feature assumes that the value of where sortby and opt will be duplicated between executions F 96 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utisip wbb Verify if the remote client address is in a list of valid addresses Syntax CALL utisip wbb env iplist valid One method of implementing security in an Internet application is to verify that the client request appears to be coming from a valid IP address or domain This low level routine checks the validity and includes support for wildcards and multiple addresses The string template env is returned by utcgi wbb iplist contains a semi colon delimited list of valid IP addresses and or domain names The list may contain wildcards For example 192 0 0 would return as valid any IP address that starts with 192 0 0 Another example localhost acme com would allow any localhost access plus any systems in the acme com domain valid returns 1 if the client address is in ipli
91. as the specified number of rows high For memo fields columns and rows is used to define the text area dimensions If unspecified then 60 columns and 15 rows is assumed Also the wrap value adds a wrap option to the textarea tags For image tag displays the altz option can be used to specify the alternate description browsers use if the image cannot be displayed F 84 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing uthtmfil wbb Generate HTML list from a file given a key range and format definition Syntax CALL uthtmfil wbb chan first last keynum maxrec count curkey tpl text work linkexpr This high level program simplifies the process of producing an HTML listing of records from a single file using traditional Business Basic commands to read the file channel for a specified key range supporting multi keyed files throughtheir key chain numbers and supporting a maximum record count so that the resulting HTML page size can be controlled chan is the channel that the file to be read is opened on and must be opened before CALLing this program first and last are text strings that indicate the key range of records to process In particular if the user is to scroll through the file first should be set to the value of curkey from the last page scrolled through The program processes all records from first forward whether or not first exists as a key in the file unti
92. at does not conflict with names used in the application If the value is changed it must be set before utcgi wbb is CALLed Stores the version of the Basic Web Utility Use in standard structure options added to the lt body gt tag Stores the data of cgi for use in programs that do not have access to cgi Stores the string template definition for cgi Points to the shared directory used by utwatch wbb and bwu2 sh if the shared directory model is used by the application Used by utwatch wbb and should match the value used by bwu2 sh Triggers the placement of cookies on the browser This must be set to a comma delimited list of names that reference global string values to be stored as cookies This must be set before the first CALL to utsend wbb The carriage return portion of a text file line termination Null on UNIX and ASCII 13 on Windows Stores the data of env to use in programs without access to env F 47 Global String Reference Basic Web Utility Guide Global String STBL envipl errdesc errnum filename fieldname imagelib imageurl infile F 48 Usage Stores the string template definition for env The uterr wbb program reports the description An error occurred for any error value passed to it It does however look for this global string for the description For example setting errdesc 0 to A locked file or record was encountered would report that message for an error
93. ata files are used for OSAS Web B2B functions You must copy the optional files to the web server at least once if you want your customers to be able to view history or inquire on invoices OSAS Web B2B User s Manual 6 5 Copy Data Files to Web Server Remote Access Copy Data Files to Web Server Screen 6 6 Copy Data Files to Web Server a lzl xl Commands Edit Modes Other Help xt 5mmu e DK Abandon Web Server Data Path d httpd htdocs osasweb Copy Optional Data Files lv Warning Any existing data in the Web Server Data Path will be overwritten Company H 11 06 2000 Terminal T000 INS The web server data path you entered in the Install Web Server Components function page 4 5 appears Press Enter to use this path or enter the full path from the OSAS system to the data path on the web server The AR Detail History file can be large and may take some time to copy You can choose to skip copying this file to speed up the copy process To copy the file select the Copy Optional Data Files check box or enter Y in text mode To skip the file clear this check box or enter N in text mode Use the Proceed OK command to begin the copy process When copying finishes the Remote Access menu appears OSAS Web B2B User s Manual Copy OSAS Programs to Web Server Use the Copy OSAS Programs to Web Server function to set up the web server for remote processing This program copies the
94. atement s MODE opt clause A common use of opt would be to control the optimization performed by BBx or Pro5 such as opt nosort maxrec indicates the maximum number of records to include in the HTML output skip indicates the number of records to skip before including records in the HTML output Because the SELECT statement does not provide a reliable means of starting a list at a specific point in the file scrolling applications must know how far the previous page had read through the file This variable is typically transferred in a more records URL It is automatically incremented by the number of records read or returns 0 if the end of the SELECT is reached count returns the actual number of records included in the HTML output The data template tpl reads records from the file indicated by chan OSAS Web B2B User s Manual F 95 Toolkit Program Functional Listing Basic Web Utility Guide The string variable text contains the HTML format for each record along with embedded data name tags For each record the program uthtmout wbb is CALLed using this as the format text See the uthtmout wbb information for more details work returns the HTML text for the records The global string list also contains this value The text string linkexpr is used by uthtmout wbb to generate any href links from the records to another page See the uthtmout wbb information for more details Automatic pagination support If the skip
95. ay elements separated by a BR tag within the column If flds begins with it is assumed to contain a list of exceptions so that all the fields in the template tpl are used to generate the HTML output Those found in flds are referenced with the formatting tags included in flds for example if flds contained the data type checkbox keys 1 2 valsz Type 1 Type 2 then all fields in the template would be generated and the field type would be treated as a checkbox input See the utfrmout wbb program documentation for information about formatting options Any field that begins with lt is assumed to be fixed HTML that is added to the document generated If a table format is being generated the field is allocated a full row using td colspan 2 gt when creating that particular row If flds begins with then all fields in the template except those listed after the first comma are included in the generated document OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing captions is a string template that contains captions for any field to be included in the form any in flds or if flds is null then any field in tpl The data for any field found in captions is used as the caption for the field If a field to be used on the form is not present in captions and the user attribute caption is not present in the template a default caption is generated from the field name by converti
96. bal string values are created automatically by uthtmfil list contains the record list returned in custlist and moreurl contains either null if the end of file is reached or a URL to continue the list These can be referenced in democlst txt as list and moreurl respectively 0680 REM 100 Load the HTML template and add the list to it 0690 CALL uthtmout wbb CGI include democlst txt HTML 0700 CALL utsub wbb HTML lt List Here gt CUSTLIST 0800 REM 100 Send it to the user 0810 CALL utsend wbb HTML 1000 DONE REM 11000 Clean up and exit 1010 CALL utexit wbb CGI 1020 IF RETURN TO WATCH THEN RUN utwatch wbb 1030 RELEASE It is important to trap all errors because Basic Web Utility programs run in background mode 2000 ERRTRAP REM 1000 generic error trap 2010 CALL uterr wbb ERR TCB 5 PGM 2 2020 GOTO DONE OSAS Web B2B User s Manual Basic Web Utility Sample Program Reference Customer Invoice History demoilst bbx The customer invoice history display is used by the Customer Inquiry application to show a listing of invoices associated with a given customer The application uses the Scrolling Customer Listing program and each customer listed is linked to this program through a URL containing the customer ID 0001 SETERR ERRTRAP 0010 REM demoilst bbx Basic Web Utility Customer Invoice Listing Demo 0020 REM Copyright 1996 by Allen Miglore All rights reserved 0030
97. basis vpro5 WebConfg bbx set MEM 1024 set BBTERM IO set USERID dummy OSAS Web B2B User s Manual F 9 The Basic Web Utility and CGI Basic Web Utility Guide If a shortcut is created for testing purposes set the Working Directory to D wwwrooti cgi bin because this is where the program resides Run Visual PRO 5 with the following command line D basis vpro5 vpro5 exe tTO m1024 cD basis vpro5 WebConfg bbx Enter the following program and save it to D BBW progs as Webtest bbx 0005 SETERR 50 0010 CALL utcgi wbb ENV CGIS ERRMSGS 0020 CALL uttags wbb h1 My First Web Test Program HTML 0030 CALL utsend wbb HTML 0040 CALL utexit wbb CGI 0050 RELEASE Executing the CGl Program Script Start the browser Internet Explorer or Netscape and point it to the web server s cgi bin directory stdcgi exe For example http web_server cgi bin stdcgi exe Once it finds the Web Server and executes the program saved above the words My First Web Test Program appear in a bold header font Troubleshooting Errors can often occur when developing web based applications and the above suggestions combined with the following troubleshooting guide can help get an application working quickly Error Messages Remember all applications should include error trapping to handle any problems that may arise Errors that can be trapped include user escapes missing files and end of file errors These errors can occur outside t
98. bb h1 Customer Entry Form HTML 0320 CALL uttags wbb hr Enter new customer information or use the Customer List link HTML 0330 CALL uttags wbb to select a customer record to edit HTML 0340 CALL uttags wbb p href ENV SCRIPT_NAME pgm democlst bbx amp linkto democent bbx Customer List HTML 0350 CALL uttags wbb HTMLS 0360 CALL uttags wbb href ENV SCRIPT_NAMES Return to the Menu HTML 0370 REM msg can be sent from democupd bbx if there is an error 0380 IF MSG gt THEN CALL uttags wbb h3 MSG HTML 0390 LET WORK HTML HTML CALL uttags wbb center WORK HTML 0400 CALL uttags wbb hr CUSTFORM HTML 0410 CALL uttags wbb body bgcolor E8E8E8 HTML BODY 0420 CALL uttags wbb head title Basic Web Utility Demo Customer Entry Form HEADING 0430 CALL uttags wbb html HEADING BODY DOCUMENT 0500 REM 1100 Send it to the user 0510 CALL utsend wbb DOCUMENTS 1000 DONE REM 11000 Clean up and exit 1010 CALL utexit wbb CGI 1020 IF RETURN TO WATCH THEN RUN utwatch wbb 1030 RELEASE 2000 ERRTRAP REM 1000 generic error trap 2010 CALL uterr wbb ERR TCB 5 PGM 2 2020 GOTO DONE Customer Update democupd bbx This program is launched from the Customer Maintenance form It reads the CGI input stream for form values and adds or updates the customer record accordingly OSAS Web B2B User s Manual F 33 Sample Program Reference Basi
99. by Basic Web Utility programs and BBXEXEC is the name of the PRO 5 executable The CONFIG file must be edited so the PREFIX contains the Basic Web Utility installation directory PGMzdemobbw bbx MEM 5 12 modify these values per your bbx configuration MAXTRIES 5 ERRORLOG usr lib pro5 webb error log CONFIG Z usr lib pro5 webb bbweb cnf BBXEXEC usr lib pro5 pro5 MEM MEM 512 if PGM then echo Content type text plain echo echo Invalid pgm argument exit fi umask 0 RETRIES 0 This section starts PRO S If it fails it retries sends the user an HTML message and records the error to the ERRORLOG file until RETRIES gt MAXTRIES do BBXEXEC q c CONFIG m MEM PGM 2 gt tmp bberr if s tmp bberr OSAS Web B2B User s Manual Basic Web Utility Sample Program Reference then RETRIES expr RETRIES 1 sleep 1 read msg lt tmp bberr rm tmp bberr 2 gt dev null else RETRIES 99 rm tmp bberr 2 gt dev null fi done if SRETRIES 99 then echo date msg gt gt ERRORLOG 2 gt dev null echo Content type text plain echo echo The database server is too busy Sorry about that echo Please try again later echo echo By the way we have recorded this problem and will add echo capacity if it happens frequently fi Startup Program demobbw bbx This program is started by the demobbw sh shell script It lo
100. c Web Utility Guide F 34 0001 SETERR ERRTRAP 0010 REM democupd bbx Basic Web Utility demo customer update from entry form 0020 REM Copyright 1996 by Allen Miglore All rights reserved 0030 REM Permission to derive programs from this is hereby granted provided 0040 REM said programs utilize licensed copies of the Basic Web Utility 0100 REM 1100 Open customer file 0110 LET CUSTCHAN UNT OPEN CUSTCHAN GENSMPL1 For a new customer entry the CGI value cust id contains blanks and the program jumps to the new customer entry label An existing customer selected from the customer list will have a hidden value on the form that contains the ID and the current record is read into CUST 0200 REM 100 Get current record 0210 EXTRACT RECORD CUSTCHAN KEY CGI CUST_ID DOM NEW_CUSTOMER CU ST On an existing record the contents of the form are updated into the contents of the CUST record using the utfrmin wbb program The record is then updated and the program continues Concurrency issues are not addressed in the sample programs because the task that loaded the maintenance form cannot retain a lock on the record There are several methods for managing records that cannot be locked during maintenance One method is to store a CRC value as a hidden field on the form calculated from the record used to generate the form When the current record is loaded in the update program the CRC values can be compared to determine if a
101. change was made to the record after the form was displayed and appropriate action can be taken 0300 REM 100 Fill in form data 0310 CALL utfrmin wbb CGI CUST 0400 REM 100 Update record 0410 WRITE RECORD CUSTCHAN CUST OSAS Web B2B User s Manual Basic Web Utility Sample Program Reference When the customer is updated or added a message is stored in MSG indicating success The customer entry program is run which builds a new form for the customer showing their changes and also displays the MSG value so the user can see that the last update was successful 0500 CONTINUE REM 100 redisplay form to show updated data 0510 LET MSG Updated CVS CUST NAMES 3 CUST CUST_ID 0520 DIM CUST FATTR CUST 0530 RUN democent bbx When the CGI value cust id does not contain a valid customer number a new customer is added The CUST data template is filled in from the form CGI data by calling utfrmin wbb The customer ID is generated by adding 1 to the last key in the file and formatting a new 5 digit key Once successful the program continues 0600 NEW CUSTOMER REM 100 Get new customer ID by adding 1 to highest current ID 0610 CALL utfrmin wbb CGI CUST 0620 LET LASTKEY KEYL CUSTCHAN KNUM 0 0630 LET CUST CUST_ID STR NUM LASTKEY 1 FILL LEN CUST CUST_ID 0 0640 WRITE RECORD CUSTCHAN DOM NEW_CUSTOMER CUSTS 0650 GOTO CONTINUE Although a normal exit from this program runs utcent bb
102. d See Inventory Lookup on page 1 50 for more information Uses the item detail lookup when the IN Search flag appears for an Item ID field See Inventory Lookup on page 1 50 for more information Uses the lot lookup when the IN Search flag appears for an Item ID field See Inventory Lookup on page 1 50 for more information Uses the serial number lookup when the IN Search flag appears for an Item ID field See Inventory Lookup on page 1 50 for more information Uses the item description lookup when the IN Search flag appears for an Item ID field See Inventory Lookup on page 1 50 for more information 1 35 OSAS Text Functions Introduction Command Alternate Key Key Description Ctrl F Toggles quick entry on and off If this option is Quick off the cursor stops at every field possible If you Entry want to skip the fields that are not required thus speeding data entry turn this option on Quick entry is on when the Quick flag appears at the bottom of the screen Ctrl G Toggles the bell on or off If the bell is on it Bell sounds at an error or when you must verify a command Ctrl O Toggles function key display on and off If this Online option is on the available function keys appear at Hints the bottom of the screen to remind you of their use Ctrl V Toggles verification on and off If verification is Verify turned on you must press a key twice to verify that you want t
103. data directory on the web server When you used the Install Web Server Components function you did not enter the Data File Path You must set up this path before you can use the Build Sale Orders from Internet function You cannot delete a group that has items set up for it The group code you are trying to delete has items set up for it Use the Internet Inventory Item Groups function on the File Maintenance menu to delete all the items from this group You must have Inventory installed for this company to use item groups The OSAS Inventory application must be installed to use this function You must set up internet companies before setting up internet items The company for which you are trying to set up items does not have Internet access Set up Internet access for the company before using this function A 4 OSAS Web B2B User s Manual System Messages You must have Inventory installed for this company to use pictures The OSAS Inventory application must be installed to use this function You cannot delete a group that is currently set up under a customer The group code you are trying to delete has customers set up for it Use the Customer Groups function to delete all the customers from this group You must run Install OSAS Web Components first You have not run the Install Web Server Component Function from the Set Up Web Components menu You must run this function before you can use any function on the Sales Order Proces
104. display only The program utfrmgn2 wbb constructs the complete form including Submit and Reset buttons and a form tag to start the demobbw sh script into the variable CUSTFORMS The non template field pgm is specified as a hidden field As in URL links this must be specified for the startup program to run the correct program The democupd bbx program is used to update the customer file from the contents of the form 0200 REM 100 create entry form with update link to democupd bbx 0210 LET FLDS FLDS cust_id hidden name addr1 addr2 city state zip phone slsp date last sale show date last pmt show credit limit show mtd sales show ytd sales show input type hidden name pgm value democupd bbx gt 0220 CALL utfrmgn2 wbb CUST FLDSS table border ENV SCRIPT_NAMES Update record Reset form 0 CUSTFORM Multiple calls to uttags wbb build the HTML document body Body tags are added a header is generated and the complete document is generated into DOCUMENTS The result is sent to the user and the program exits In addition it is necessary to shuffle HTML values with a temporary variable to add surrounding tags such as lt center gt and lt center gt and not double up the text in HTML because uttags wbb always appends to the last argument OSAS Web B2B User s Manual Basic Web Utility Sample Program Reference 0300 REM 1100 Use uttags wbb to generate the rest of the document 0310 CALL uttags w
105. ds form actionz action method post gt and lt form gt form up Adds form action action method post enctype multipart form data gt and lt form gt h1 6 adds lt hn gt and lt hn gt head adds lt head gt and lt head gt OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing Hidden name replaces text with lt input type hidden name name value text gt Hr prepends a lt hr gt tag Href name adds lt a href name gt and lt a gt If name contains an ASCII 2 02 character the data before the 02 is used as the href portion of the link and data after the 02 is added to the lt a gt tag after the href element This is useful for specifying things such as target frames in a link For example if the name is cgi bin showpage id 1 02 target A the generated tag would be a href cgi bin showpage id 1 target A gt lt a gt Html adds lt html gt and lt html gt I adds lt i gt and lt i gt Img altname replaces text with lt img src text alt altname gt P prepends a lt p gt tag to text Pre adds lt pre gt and lt pre gt Rem same as comment Reset replaces text with lt input type reset name text gt Submit value replaces text with lt input type submit value value name text gt Title adds lt title gt and lt title gt text receives pre and post html tags in the order listed in tags except where text
106. duction Description Switches insert mode on and off When the Insert flag appears at the bottom of the screen characters you enter push characters after the cursor over When insert mode is turned off characters you enter write over existing ones Moves the cursor to the beginning of the field Moves the cursor to the end of the field Restores a field to the way it was before you changed 1t You can use this command only while you are in the field once you move past it you must use the Abandon F5 command Deletes the characters in the field to the right of the cursor If insert mode is turned off and you enter a character in the field s first position everything in the field is deleted Copies the contents of the current field Pastes the value you copied from a previous field into the current field OSAS Web B2B User s Manual Favorites Menu The Favorites menu operates in any of the menu formats and gives you quick and easy access to the OSAS functions you use most allowing you to add selections for entire menus or particular functions After you ve set up the menu you can access the functions either by pressing F2 or by selecting Change to Favorites from the graphical Favorites pull down menu With the Favorites menu you save time by eliminating the need to switch between applications For example if you perform tasks in several applications such as using the Transactions and Cash Receipts function in
107. e When you specify a range of items for a report the Thru value you enter must be greater than or equal to the From value The code you want to use for a master password is already being used The master password you entered is already set up for one of your customers Choose another password Access code faccess code is a master password The password you are entering for the customer is already set up as a master password Choose another password There are no internet companies set up to make a login page for You must flag at least one company for Internet access using the Company Information function in Resource Manager before you can create your login page The last character of your path must be a The path entered is too long The path name must end in a 7 OSAS Web B2B User s Manual A 3 System Messages Unable to open data directory for the Web Server locate OWORDLOG log file open specified directory find SOTHxxx on Web Server Path find SOTDxxx on Web Server Path open specified directory open specified path for your home page open osasweb directory on the Web server open BBx directory to the server open osasweb directory on the Web Server The system was unable to find the path you entered Find the correct path name and enter it You must have Sales Order installed to use Build Sales Orders The OSAS Sales Order application must be installed to use this function You must set up the
108. e you can use the mirror web site to create what your customers see when you personalize your site This saves the potential down time that occurs when you test various OSAS Web B2B functions solve problems and make repeated web site modifications without constantly updating your ISP web site When you update your files and functions make your modifications to your mirror web site check them and then copy the updates to your ISP web site 3 To update your login page use the Create Login Page function and enter the path for the document directory on the mirror web site 4 To update all the OSAS Web B2B programs use the Install OSAS Web Components function and set the paths to use the directories on the mirror web site 5 To update the remote data files and remote programs use the Copy Data Files to Data Server and Copy OSAS Programs to Web Server functions After completing these functions set the ISP path to match the mirror web site 6 To update the image files copy them into the image directory on the mirror web site 7 When you finish updating your files on the mirror web site you can use FTP file transfer protocol software to move all the files in each directory to the matching ISP directory Pm using BMP file formats for my pictures and they don t display correctly Many Internet browsers do not support the viewing of bitmap BMP images You should try using JPG or GIF file formats instead Files saved in these
109. e E and server information on drive C You must enter the dsksyn command for drives A B and D to avoid errors When you enter multiple dsksyn settings you must enter each command on a separate line Modifying Batch and Script Files If the interpreter is on a different path than the BBx directory you will need to change the four BAT files on DOS if you are using UNIX you will need to change the four EXE scripts DOS Changes D 2 All of the DOS batch files in OSAS Web B2B are similar The MENU BAT file is shown here You can make similar changes to the other batch files OWMENU BAT echo off rem This batch file will work under O Reilly Website s DOS CGI interface rem You can make copies under any name you want and execute it via rem http cgi dos name bat Each copy can be associated with a BBx rem program rem set BBPROG to be your BBx program BBEXEC BBCONFIG and MEM for rem BBx startup set BBPROG owmenu bbx set BBEXEC c server bbx vpro5 exe This line must contain the full path to the interpreter set BBCONFIG config bbx set MEM 1024 q set BBTERM IO set USERID osasweb OSAS Web B2B User s Manual Editing Files if os Windows_NT goto NT rem Win 95 Website uses OUTPUT FILE if LREQUEST_METHOD POST goto WIN9SCONTENT BBEXEC m MEM BBPROG gt OUTPUT_FILE doscgi goto DONE WIN95CONTENT BBEXEC m MEM BBPROG lt CONTENT_FILE gt OUTPUT_FILE go
110. e for creating the contents of the resultant html page BBEXEC Specifies the full path to the vpro5 executable BBCONFIG Specifies the config bbx file to be used by Visual PRO 5 The configuration file should have an alias that matches the BBTERM value below It must also have proper DSKSYN s and a PREFIX that allows Visual PROJ 5 to load the Basic Web Utility programs and the program specified by BBPROG above MEM Specifies the amount of memory with which to start Visual PRO 5 OSAS Web B2B User s Manual F 7 The Basic Web Utility and CGI Basic Web Utility Guide Parameter Description BBTERM Refers to a terminal alias in BBCONFIG Often this has an invisible or minimized mode Note that some web servers will not allow a console mode window to activate regardless of this setting In this case debugging must be done with error trapping and logging USERID Specifies the userid value to use when connecting to a data server If no Data Server is required use a dummy value Requisite Knowledge Before using BB Web you must install and run a web server on the same system where Business Basic is operating The web server needs to be configured with at least one way of invoking CGI scripts this is always the default configuration anyway but an understanding of the naming conventions and directory locations for CGl is essential You must be familiar with the use of a web browser such as Netscape Navigator or Microsoft Inte
111. e information used in the OSAS Web B2B system If any of the information on a master file list 1s incorrect use the appropriate function on the File Maintenance menu to correct it then reprint the master file list You produce all master file lists the same way Use the instructions below to print a master file list modifying the procedure as necessary for the list you are printing For example if the screen for the list you want to print does not contain check box options ignore that step and continue to the next Follow these steps to print a master list 1 Select the list you want to print from the Master File Lists menu The selection screen for that list appears The Internet Inventory Item Groups List screen is shown below as an example la Commands Edit Modes Other Inventory Lookups Help xt mammu e OK Abandon Item ID From 100 El Thru 820003 aj Location ID From CA0001 El Thu T 0001 aj Group Code From APPLIANCE aj Thu WINDOWS aj Print By Item ID Group Code Company H 11 06 2000 Terminal TODO INS OSAS Web B2B User s Manual 7 3 Printing a Master File List Master File Lists 7 4 Select the range of information to include in the list in the From and Thru fields The Inquiry F2 command is usually available for these fields to let you select beginning and end range values from the list that appears Leave these fields blank to include all values in the list If the screen contains
112. e lt a gt expression from the dataname value The format of the url value is specified in the linkexpr variable If multiple link formats are specified in linkexpr the format linkn can be used where n specifies the link format number to use with this dataname encode forces the dataname value to be URL encoded image causes an img src data value gt tag to be generated from the dataname value If the global string variable imageurl is defined it is used as a prefix to the dataname value In addition if the global string variable imagelib is defined it is used to locate the physical image file if it resides on the host system and determine the image dimensions for the IMG tag pad ensures that a right padded rather than trimmed dataname value is used pad ensures that a left padded rather than trimmed dataname value is used Padding is only necessary on pre formatted output such as between pre and lt pre gt tags OSAS Web B2B User s Manual F 93 Toolkit Program Functional Listing Basic Web Utility Guide options may include keys item1l item2 itemn vals desc1 desc2 desen sep char or hex alt image altname passthru y or n The sep option is used to define the separator character used in keys and vals By default it is a semicolon but may be set to any value including nonprintable values except a quote If keys and vals are specified then the dataname value is compared
113. e name convention of filename in will contain the name of a Business Basic program to RUN along with the environment and CGI data The specified program is RUN and must use utsend wbb for all its HTML output When it is finished it must CALL utexit wbb and RUN utwatch wbb Typically this program runs from one or more background tasks The more tasks the more likely that CGI requests will be responded to quickly The global variable commdir should be set to the name of the shared directory before utwatch wbb is run If it is not set the current directory is used Normally utwatch wbb scans the shared directory completely and pauses for one second before scanning again The number of seconds from 0 to any value allowed by the WAIT directive can be specified in the global variable waitsec The format of a request file is program name env 1 val 1 env 2 val 2 env n val n blank line CGI standard input stream with line feed appended EOF OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing The first line is the Business Basic program that utwatch wbb should RUN The next lines up to a blank line contain the environment variables and their values Following the blank line is the CGI input stream that the CGI script received on its standard input handle with a line feed appended to force an additional line The last line is the text string EOF The UNIX shell script bwu2
114. e the Irem Group Codes function to add item groups or change the description of existing item groups The groups you create are used to restrict access to your inventory files You can place the same inventory items in multiple groups or exclude inventory items from all groups as you like You can then specify the groups to which each customer has access Item Group Codes Screen The screen lists the group codes and their descriptions Item Group Codes Commands Edit Modes Other Scroll Commands Help 101 x 2xXte aelaal g Gk Abandon Group Code APPLIANCE Description Appliances Dishwashers Doors Lo p lor Heating and Air Conditioning Equipment Interior Materials Paint Wallpaper Supplies Materials Millwork Trim and Doors Paints Cabinet Replacement Parts Refrigerators Stoves and Ranges Paint Supplies Windows Ud tad La Enter edit Append OSAS Web B2B User s Manual Company H 11 04 2002 Terminal TODO OVR 3 3 Item Group Codes File Maintenance Use these commands to work with the group codes Press Enter to edit the selected item group code description The Edit Group Code screen appears e Press A to add a new item group to the list The Append Group Code screen appears e Press Gto go to a specific item group code then enter the code This command is available
115. e web server to the location of the BBx interpreter Enter the full path from the web server to the OSAS data files If you use remote processing enter the path where the data file copies are kept OSAS Web B2B User s Manual Set Up Web Components Install Web Server Components Field Name System File Path Web Server Resource Manager Path Web Server Local Programs Path Web Server Local Images Path Web Server System Description Enter the full path from the web server to the OSAS sysfil path If you use remote processing enter the path where the sysfil copies are kept Enter the full path from the web server to the location of the Resource Manager programs Enter the full path to the directory mapped to the virtual osasweb directory on the web server Enter the full path to the directory mapped to the virtual images directory on the web server If the web server resides on a UNIX Linux system enter U If the web server resides on Novell or Windows 95 98 or NT enter D To save your entries or begin the copy process use the Proceed OK command When the copy process finishes the Set Up Web Components menu appears Windows Web Server UNIX Data Server If you are using a Windows Web Server that accesses data through a UNIX Data Server you must set up a UNIX user ID on the UNIX Data Server On the UNIX computer accessing the OSAS Web B2B data files set up osasweb as a UNIX user ID Note If
116. ears at the bottom of the screen and gives you access to commands that allow you to move around the screen add or edit information change settings for selected lines or select output devices Press the highlighted key to use a command Enter edit Append View Workstation ID Header The commands that are available depend upon the function you are using Consult the user s manual for the appropriate application for information on commands in the command line Commands and Flags Like the text menu text function screens also contain several commands that allow you to perform tasks related to the function you are using Some of these commands are not available for every function when a command is available a flag appears at the bottom of the screen 1 32 OSAS Web B2B User s Manual Introduction OSAS Text Functions To access a command press the corresponding key If you re working with a keyboard that lacks function keys labeled with an F followed by a number or if you re working with an emulator in UNIX which can cause function keys to become unavailable press the appropriate alternate key combination to access the command Command Alternate Key Key Description Enter Moves the cursor to the next field and accepts the data entered or access a line for editing Esc Opens a window listing available commands for the screen Ins Toggles between insert and overwrite modes for entry When the Ins flag appears the characte
117. ecutables stdcgi exe and wincgi exe are provided to manage the process The stdcgi exe program supports the Standard CGI specification and is more commonly used This program should be used when the web server is running Microsoft IIS or Microsoft Personal Web Server for Windows NT or Windows 95 The wincgi exe program is used for web servers that do not support the Standard CGI specification but rather support the Win CGI specification instead When Visual PRO 5 is run on the server it is executed in the background This means that SYSWINDOW is not be available for debugging purposes If Visual PRO 5 encounters an untrapped error while running a program it stops running the program and lists the error in console mode Since it is in the server s background this window is not be visible and it appears as though both the Client and web server are hung In reality they are simply waiting for the Visual PROJ 5 session to complete Because of this it is very important that all of the programs trap for unanticipated errors This is typically done with the SETERR verb The first step in configuring the utility set is to copy the appropriate cgi executable stdcgi exe or wincgi exe to a scripting directory on the Windows web server typically called wwwroot cgi or wwwroot cgi bin The wwwroot directory is the root directory of your web server and the cgi or cgi bin directory contains scripts and programs that are executed by the web server F 6 O
118. ed by uthtmfil wbb uthtmkey wbb and uthtmsel wbb It can also be CALLed by custom programs when single file processing is inadequate It merges Business Basic data with HTML text and produces results in work The intent is to produce a standard HTML page so no input fields are generated as with an input form If an input form is desired utfrmout wbb is used The program is sensitive to the user defined format attributes in the data template tpl as well as format tags in the text template The template attributes are discussed in the Data Templates section The data template specified can be filled by the CALLing program using data from a number of sources In applications where multiple data templates do not share data field names this program can be CALLed multiple times to produce a final HTML output with different data merged on each CALL tpl is a data template used as the source for data field names It contains data types and user defined formatting attributes See the Data Templates section for more information text is an HTML text string that may contain any text meta instruction or field tag reference It is evaluated and copied with possible substitutions and insertions into work work returns the HTML result of merging text with data in tpl OSAS Web B2B User s Manual F 91 Toolkit Program Functional Listing Basic Web Utility Guide linkexpr may contain one or more link definitions to be used if any data f
119. ed in CALLs to uthtmout wbb which can use text containing list to merge the value of work automatically linkexpr is a text string used by uthtmout wbb to generate any href links from the records to another page See the uthtmout wbb information for more details Automatic pagination support If the first argument is null the cgi variable bbweb_s is checked and if present is used as the starting point for the list On exit if more records are available the program generates a global string STBL moreurl that contains the full URL with any cgi fields retained and with bbweb_s incremented for the next page This can be used in a hyperlink for a continuation if moreurl gt a href moreurl gt More records amp ldots lt a gt end F 86 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing uthimgen wbb Generate HTML tags and text from a template Syntax CALL uthtmgen wbb tpl flds captions flags captags linkexprs work This high level program generates a data page in HTML format based on a template and other information It is capable of creating data as loose text preformatted and aligned text or as a bordered or borderless table tpl is a data tempate that contains both the fields and data to generate the didsplay fields Various user attributes can be defined in the template to control how field data is handled See the Data Templates information for a d
120. en you enter the serial number you can use the and wildcard characters to restrict or widen the search Searches for an item based on item description When you enter the description you can use the and wildcard characters to restrict or widen the search 1 43 OSAS Graphical Functions Introduction 1 44 Function Screen Toolbar XX tm pean g Like the main menu s toolbar the toolbar located near the top of function screens gives you quick access to frequently used commands Click the appropriate button to access a command Button x amp gt U e a mp gi e la Result Opens the appropriate File Maintenance function to update information about the field you are in Deletes the information on the screen Since this command can delete an entire record use it with caution Moves the cursor back to the first field on the screen or to the first field after the key field without erasing any entries or changes Copies the contents of the current field Pastes the contents you copied from a previous field into the current field Opens the OSAS calculator screen Opens the pop up calendar Use the calendar to add and review reminders for any date Displays information about the field you are in Opens your PDF file viewer so that you can view the online documentation OSAS Web B2B User s Manual Introduction OSAS Graphical Functions Right Click Menu Online Documentation
121. en Systems Inc Copyright 19988 2001 Open Systems Holdings Corp All rights reserved ri Local intranet Make corrections to the shipping information as necessary Refer to the field definitions for descriptions of specific fields When you finish click Submit to process your order After your order is submitted successfully the Order Number Web Page appears 8 28 OSAS Web B2B User s Manual The Web Interface Field Definitions Field Name Name Address City State Zip Country Ship Method Your P O Number Your P O Date Requested Ship Date Additional Comments Order Entry Description Enter a company s or individual s name for the shipment Enter 1 3 lines of address information for the shipment Enter the city state zip code and country to which the shipment will be sent Select a shipping method from the list presented Enter your purchase order number if necessary Enter the date of your purchase order Enter the month day and year in the appropriate fields Enter the date by which you want to receive the shipment Enter the month day and year in the appropriate fields Enter any additional information you want to pass along about your order You might use this field to specify alternative items to request a rush order to request a phone call before the order is shipped and so on If you close your browser or leave the Order Entry web pages your shopping cart remains i
122. enu you can assign a two character prefix to order numbers for web orders OSAS then uses this convention to assign order numbers XX000001 RF Alphabetic prefix Order number that increments you assign with each new order If you assign only a one character prefix the remaining numeric portion contains seven numbers instead of six When you use prefixes orders entered through the web appear in Sales Order as price quotes with order numbers in the format described above even if you use remote processing Use these prefixed order numbers to quickly distinguish between quotes entered via the web and those entered internally 5 4 OSAS Web B2B User s Manual Transaction Journal The Transaction Journal function produces a list of the orders entered on the web site This list serves as an audit trail of the transactions as well as an edit register to check for necessary changes or incomplete entries If you use remote data files you can print the Transaction Journal before moving the orders to your live Sales Order files as an audit trail When you use the Build Sales Orders from Remote Files function page 5 7 this report reprints automatically to show any order number changes that have been made in the copy process Transaction Journal Screen j amp Transaction Journal E JO x Commands Edit Modes Other Help X ta amp 28 2 e DK Abandon Web Server Programs Path c inetpub wwwroot osasweb Company H
123. eral commands are available within the menu to perform various tasks such as changing the system date entering access codes switching between sample data and live data and so on You can access commands in these ways if a button or pull down menu selection is muted or gray it is not available for use e Click the appropriate graphical tool button e Select the command from a pull down menu Press the associated keyboard hot key If you use the graphical menu you can select application menus and functions by clicking the function or menu name on the menu or by highlighting your choice and pressing Enter If you choose the start style menu you can select applications from the main menu by using the arrow keys to highlight your choice and pressing Enter by clicking the selection or by holding the mouse cursor over the selection until the menu appears From any application menu you can select a button from the previous menu to move directly to that menu If you are several menu levels away from the main menu you can return to the main menu by clicking items on the previous menus OSAS Web B2B User s Manual 1 21 OSAS Graphical Menu Introduction Graphical Main Menu j T000 OPEN SYSTEMS Accounting Software B zi xj File Modes Tools Favorites Other Help Coae m B EO QSAS OPEN SYSTEMS Accounting Software Main Menu General Ledger 2002 Journal Transactions GENERAL Report Writer Jour
124. erpret your action as two separate clicks and may not perform the desired function OSAS Web B2B User s Manual 1 13 Conventions Introduction To deselect an object move the cursor off the icon or folder onto a blank space within the window and press the left mouse button Some mouse manufacturers allow you to change the function of the mouse buttons for those who prefer for example to use the mouse with their left hand In this case reverse the commands when you use them For example a click refers to a single press of the right mouse button while the term right click refers to a single press of the left button GUI Text Command Conventions When you see the phrase use the Proceed OK command in the user s manuals press PgDn in either text or graphical mode In graphical mode clicking OK has the same effect as pressing PgDn GUI Text Menu and Function Conventions When you start OSAS the main menu appears and lists the applications available for use If you are using UNIX or Linux the text main menu appears If you are using Windows you can choose between the text main menu the graphical main menu or the start style main menu Use the Defaults function under the Resource Manager Workstation Configuration menu to select the style of menu you want to appear by default or you can press Shift F5 to toggle between the menu styles from any menu You can use any of the menus regardless of whether you use the text o
125. es F 104 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utsend wbb Send text back to the client browser Syntax CALL utsend wbb text This high level routine sends HTML text to the client It works on all Basic Web Utility platforms regardless of the output destination and automatically adds the Content type header as needed to the first output On the first CALL to utsend wbb if text begins with Location text is sent with a trailing blank line On the first CALL to utsend wbb if text begins with Content type a header is not added by utsend wbb and the application is responsible for the header and trailing blank line This enables the application to send any MIME data type to the browser OSAS Web B2B User s Manual F 105 Toolkit Program Functional Listing Basic Web Utility Guide utses wbb Manage session record Syntax CALL utses wbb mode sesrec errmsg This program provides an interface to read write and delete the session record 1f present Session tracking can be initiated in the program by creating a global string STBL sestpl before CALLing utcgi wbb This string is a string template definition to describe what session data the Basic Web Utility should store The Basic Web Utility generates an HTTP cookie sesid to retain the session ID code that the data is stored under mode can be 0 to read the session record 1 to write it or 2 to delete it I
126. es List function 7 5 sample 7 5 item groups 3 3 J Jump function key 1 39 pull down menu command 1 39 Jump command function key 1 42 pull down menu command 1 42 L Last Line command function key 1 42 1 51 pull down menu command 1 42 OSAS Web B2B User s Manual Left Arrow report command 1 66 Left Arrow function key 1 51 Lists printing 7 3 live data changing to 1 24 1 29 Lot Inventory Lookup function key 1 43 1 50 pull down menu command 1 43 Maintenance function key 1 38 pull down menu command 1 38 tool button 1 44 manual conventions 1 13 master access codes setting up 3 13 Master File Lists menu structure 1 10 Master Lists printing 7 3 Menu styles 1 14 menus information menu 1 55 structure in OPEN Web 1 10 messages A 1 C 1 D 1 mouse commands click 1 13 deselect 1 14 double click 1 13 right click 1 13 MS DOS prompt tool button 1 28 N Next Line command function key 1 42 1 51 pull down menu command 1 42 Next Page command function key 1 42 1 51 pull down menu command 1 42 O OK Proceed function key 1 38 pull down menu command 1 38 Online Documentation function key 1 41 pull down menu command 1 41 tool button 1 44 OPEN Web description 1 7 installation checklist 2 6 interfaces 1 11 menu structure 1 10 Requirements and Applications 2 5 OPEN Web Login page HTML screen 8 3 opening documents 1 60 Order Entry Group Codes HTML screen 8 22
127. ese instructions to maintain the EMAIL table using the Tables function l Zn gt 3 22 Select Tables from the File Maintenance menu A blank Tables screen appears Enter EMAIL in the Table ID field The EMAIL table s description number of columns column length type alphanumeric or numeric headings and data appear AE Commands Edit Modes Other Help 2x re ma g OK Abandon Table ID i Description E Mail Address in case of problems Number of Cols 1 Column Length 50 Type Ar Email Address Company H 11 05 2002 Terminal TOO OVR Enter the e mail address of the person in your company who should be contacted in the event of web problems Use the Proceed OK command to save your changes The cursor returns to the Table ID field Use the Exit F7 command to return to the File Maintenance menu OSAS Web B2B User s Manual Set Up Web Components Create Login Page Install Web Server Components OSAS Web B2B User s Manual 4 3 4 5 4 1 Create Login Page Use the Create Login Page function to build the login page for the web server You must run this function to e create your OSAS Web B2B login page for the first time change the title used on the login page Create Login Page Screen Create Login page Acl Commands Edit Modes Other Help 2xe Bea mal g DK _Abandon Login Page Title Builders Supply Web Server Documents Path c httpd htdocs
128. ess 6 3 Copy Data Files to Web Server 6 5 Copy OSAS Programs to Web Server 6 7 OSAS Web B2B User s Manual 6 1 Remote Access When you set up OSAS Web B2B you can elect to allow access to your OSAS data files directly from the Internet or to allow access to copies of your files stored on the web server The process of using copies of your files is known as remote processing See chapter 2 for more information about remote processing Use the functions on the Remote Access menu to set up the programs and to refresh your data files 1f you use remote processing e Use the Copy OSAS Programs to Web Server function to set up remote processing e Use the Copy Data Files to Web Server function regularly to refresh the data stored on your web server In addition you should run this function every time you use the Build Sales Orders from Remote Files function on the Sales Order Processing menu OSAS Web B2B User s Manual 6 3 Copy Data Files to Web Server Use the Copy Data Files to Web Server function to refresh the data that is stored on the web server if you have chosen remote processing This program copies the OSAS data files to the web server for the inquiry and sales order entry functions This function copies the Inventory Accounts Receivable and Sales Order files for use by OSAS Web B2B functions You need to run this function only if you are using remote processing If you are not using remote processing your live OSAS d
129. ession is valid the tags are removed but the text between them is retained datafield can be either a field in the data template or a global string variable name The operator opr can be gt lt gt lt lt gt in or in The in and lin operators perform position checks on text fields and values If datafield is numeric in the template then value must be a simple number If datafield is defined with a user attribute of date format then value should be a text date such as 11 30 95 if end tags may be nested If datafield is not found in the data template and is not a global string variable the meta instruction is retained in the text OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing Note that datafield should not be enclosed by brackets and there must be at least one space between datafield and opr and opr and value Field tags Field tags are placed in text in the format dataname format control options dataname is a data template field name or a global string variable name If it is not found in either form then it is retained for subsequent CALLs with other data templates format control is an optional format control word used to indicate special formatting of the merged data These values can optionally be placed before the dataname for compatibility with earlier releases Valid values are link or linkn used to create an lt a href url value gt data valu
130. ew or update master file information This command is available when the Maint flag appears at the bottom of the screen Esc M Exits from the function Esc L Allows you to output the current screen to a printer to a print preview window or to a file Esc U Clears the contents of the current field Ctrl Z Deletes information to the end of the line Esc l Opens an information menu for the function when the Info flag appears at the bottom of the screen The commands that are available depend on the applications you have installed See Information Menu on page 1 41 for more information OSAS Web B2B User s Manual Introduction OSAS Text Functions Command Key Shift F3 Shift F4 Part Lookup Shift F5 Item Detail Lookup Shift F6 Lot Lookup Shift F7 Serial Number Lookup Shift F8 Item Descr Lookup Alternate Key Esc B Esc C Esc G Esc K Esc N Esc Q OSAS Web B2B User s Manual Description Uses the item alias lookup when the IN Search flag appears for an Item ID field See Inventory Lookup on page 1 50 for more information In Sales Order pressing this key combination allows you to enter purchase requisitions from the Ordered Units Shipped and Backordered fields In sales tax fields pressing this key combination allows you to view sales tax breakdowns Uses the customer vendor part number lookup when the IN Search flag appears for an Item ID fiel
131. f mode is 0 sesrec returns the session record If mode is 1 it is used to update the session record It is ignored if mode is 2 errmsg returns a description if any error occurred If this value is not blank on exit there was a problem in session tracking and the application should take measures to display and or work around the error This program uses the file utses dat stored in the Basic Web Utility directory and is created automatically if not found It has a key size of 22 and a record size of 512 utsub wbb F 106 Substitute occurrences of text with replacement text Syntax CALL utsub wbb text from to This low level routine substitutes all occurrences of from with to in text It is nonrecursive so to may contain from or conversely from may contain to OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing uttable wbb Create HTML table from an array Syntax CALL uttable wbb caption options dat all work HTML tables are time consuming to create manually in part because the markup tags are required for each cell This high level routine reduces the effort 1f the data for the table can be stored in a 2 dimensional array The string variable caption ontains the table caption if any The string variable options contains the table options for the lt table gt tag The most common option is border or border 1 Table options are not consistent among br
132. g an existing picture as in the example above you cannot change the item ID Instead return to the Item Picture screen use the Delete F3 command to delete the item from the item picture file and then press A to add a new picture Enter the picture s file name then use the Proceed OK command to save your changes and return to the Inventory Item Pictures screen OSAS Web B2B User s Manual 3 7 Internet Inventory Item Groups Use the Internet Inventory Item Groups function to Add inventory items to an item group e Add subgroups to an item group e Change the inventory locations included in an item group e Remove inventory items or locations from an item group Item groups organize inventory items together for display and security purposes on the Item Inquiry and Order Entry web pages You can restrict access to the items by the groups you set up Use the Item Group Codes function page 3 3 to add item groups to the system Internet Inventory Item Groups Screen MEE Commands Edt Modes Other Scroll Commands Help 2 xt Belma amp OK Abandon Group Code INTERIOR Interior Materials Paint Wallpaper Supplies Sub Item ID Subgroup Code Description Loc ID Picture Interior Materials Interior Materials MDO001 Interior Materials MNOOOT Interior Materials TX0001 Wallpaper Contemporary C40001 Wallpaper Contemporary MDO001 Wallpaper Contemporary MNODOT Wallpaper Contemporary TX0001 Wal
133. gh the Internet You must have Internet access and Internet server software in addition to OSAS Web B2B The Internet server software you use must support Standard CGI scripting in order to use it with OSAS Web B2B CGI is an acronym for Common Gateway Interface a method of communicating information from one web page to another There are two types of CGI scripting standards Windows CGI and Standard CGI OSAS Web B2B uses Standard CGI A familiarity with HTML Hypertext Markup Language is recommended if you want to modify the web pages constructed by the Create OSAS Web B2B Login Page and Install Web Server Components functions OSAS Web B2B is different from other OSAS applications because of the web interface It helps to think of the software as two pieces that are joined together the web server application and the OSAS application OSAS Web B2B on the Web Server The web server application is the part of OSAS Web B2B that your customers see It is a connected group of HTML screens some of which function as menus and others that display and prompt for information These screens communicate with OSAS Web B2B using standard CGI scripts OSAS Web B2B User s Manual 1 7 The OSAS Web B2B System Introduction Your Internet server software must be installed and configured on the web server before you can use OSAS Web B2B The web server can be located on the same computer on which you run OSAS or it can be located on a diffe
134. gram In some cases the program passes data to the standard input handle of the script process The environment variables plus the format definition of the data sent on the standard input channel to the executable are defined by the CGI specification OSAS Web B2B User s Manual Basic Web Utility The Basic Web Utility and CGI The program sends an HTML document back to the server on its standard output handle and then exits The server in turn sends the document back to the browser that made the original request Some servers running in non UNIX environments have additional methods of communicating with the executable An example is O Reilly s WebSite for Windows NT and Windows 95 which uses a file based interface called Win CGI Netscape s Fast Start server also supports Win CGI The data passed to the program is normally made up of name value pairs passed either through the document request itself or through an HTML form The program evaluates the names and associated values performs an action based on the data and returns an HTML formatted document For example http www yourcomp com cgi showcust custnum 5 In this example the executable showcust is given the data custnum 5 which is used to find a customer record and format an HTML document showing customer information Because Business Basic interpreters cannot directly communicate with the web server a middle layer is provided by the Basic Web Utility There are two
135. han 10 orders for this customer the Next and Previous buttons appear Click these buttons to scroll through the order numbers If you have access to Order Inquiry detail information you can view it by clicking on any highlighted order number The screen changes to list detail for that order number When you finish viewing order information close the browser to end your session or choose a different menu selection from the side or top menus OSAS Web B2B User s Manual 8 19 Order Inquiry The Web Interface Order Detail HTML Screen OSA omer ORder Detail Lookup oso ernet Explore ana 3 nl x File Edit View Favorites Tools Help Ar Qs r O x x E O Search Se Favorites A Meda e PEM p Information Inventory Orders Order Inquiry ACEDO Order Entry CATE ACE BUILDERS MEE 505 555 1646 Login Page Line ltem Item Item Ordered Shipped Backordered Unit of Extended Number ID Location Description Qty Qty Qty Measure Price Electrical 100 CADOD1 Package 1 0000 0000 0000 PKG 380 55 002 150 caooo Plumbing 30000 0000 0000 PKG 3 173 75 Package Top of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved Idm Local intranet This page lists up to 10 line items for the
136. he billing and ship to addresses you set up for the customer in the Accounts Receivable Customers and Ship to Addresses appear in the Ship To list box this list is limited by available memory If you have not set up any ship to addresses only the customer s billing address appears in the list and is used as the default address Select the address to which to ship goods Click Submit to proceed to the Shipping Information page where you can verify and change shipping address data OSAS Web B2B User s Manual 8 27 Order Entry The Web Interface Shipping Address Information HTML Screen es Orde osoft Internet Explore pe lol x File Edit View Favorites Tools Help ae Q rex y o z x 2 O JO Search 57 Favorites A media 2 E e Ind 33 Links gt SYSTEMS INC Information Inventory Orders Order Inquiry CET ACEOO1 Ship To Order Entry PETT ace BUILDERS Name LAURA JOHNSON vem Locke 1588 SE 31ST STREET Address 1588 SE 3IST STREET View Shopping Cart SUITE 105 Login Page PADUCAH City PADUCAH u Mi sum EI FT 29655 7005 zip 28655 7865 us Country U S A Ship Method Federal Exp 2n0 Day z MOI LEA DET ETERNI Your PO Date ue MM DD YYYY mn ku Nudge 115469 Requested Ship Date 1 15 2002 MM DD YYYY Additional Comments Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software tom Op
137. he calls to the Basic Web Utility set OSAS Web B2B User s Manual Basic Web Utility The Basic Web Utility and CGI The BASIS Web Utility programs include error trapping as an aid during the development cycle If any errors occur a log file BWWERR log is created in the current working directory of the program being run This may not necessarily be the current working directory of PRO 5 but the directory where the script stdcgi exe resides Errors returned by the stdcgi exe reported to the browser and the BWWERR log are Error Message Description Can t generate work file 1 Could not create the first temporary file Can t open work file 1 Could not open the first temporary file Can t generate work file 2 Could not create the second temporary file Can t open work file 2 Could not open the second temporary file Can t open parameter file Could not open the batch file stdcgi bat Couldn t start task Could not start vpro5 or other exe specified in the batch file Result couldn t be found Could not open temp file that contains the output from vpro5 Errors returned by the wincgi exe reported to the browser and the BWWERR log are Error Message Description Can t open parameter file Could not open the batch file wincgi bat Sorry can t start CGI task Could not start vpro5 or other exe specified in Try again later the batch file OSAS Web B2B User s Manual F 11 The Basic Web Utility and CGI Ba
138. ield contains the link lead in option If multiple link expressions are contained in linkexpr they must be separated by an ASCII character 1 01 An example of a use for a link expression links a record in a list to a full page display of that particular record Typically the full page display is based on the record s key field The following example assumes there is a script that will be given the records key through the ID field linkexpr z cgi bin showpage ID G encode ID If any link expression contains an ASCII 2 025 character the data before the 02 is used as the href portion of the link and data after the 02 is added to the a gt tag after the href element This is helpful when specifying things such as target frames in a link For example if the link expression is cgi bin showpage id 1 02 target A the generated tag would be lt a href cgi bin showpage id 1 target A gt lt a gt Note that uthtmout wbb is CALLed recursively to format the actual URL used in the link so the same formatting information applies to text and linkexpr Meta Instructions include filename loads the text file filename into text This method creates HTML template files and incorporates them in an application filename must be accessible to Business Basic if datafield opr value end evaluates the expression datafield opr value If it fails any text between the if and end tags is suppressed If the expr
139. iew comments for the first ID on record e Press N to view comments for the next ID on record e Press P to view or edit comments for the previous ID on record e Press Lto view or edit comments for the last ID on record Press G to go to a specific comment This command is available only when there is more than one screen of comments OSAS Web B2B User s Manual 1 57 Information Menu Introduction History 1 58 Adding or Editing Comments The Append Comment screen appears when you add a new comment The Edit Comments screen appears when you edit an existing comment Other than the title these screens are identical 2 Edit Comment A E el x Commands Edit Modes Other Help 2xe Be mtu 28 DK Abandon Date 06 15 2002 Reference 003 Comment SPOKE WITH JON RE EMAIL CONF AND ORDER TRACKING 1 Ifyou are working with a new comment the system date appears otherwise the date entered for the comment you are editing appears Accept this date or enter a different date 2 The current terminal ID appears in the Reference field Edit this reference 1f necessary 3 Enter or edit the comment then press Enter to save the comment record When available the History command gives you access to customer history in a manner similar to OSAS Inquiry functions Select the customer for which you want to view detail information enter a date from which to view information 1f desired then press Enter to view invoice or
140. if you want to print it in compressed width Click OK or press Enter to begin printing the report If you want to stop printing after it has begun press Ctrl Break Click OK or press Enter to continue View the Report using Print Preview Windows Workstations Only The Print Preview option is only available for workstations running Windows However before Print Preview will work you must add a sysprint device line in the config bbx file for that printer Use the Devices function on the Resource Manager Workstation Configuration menu to add this line Follow these steps to view a report using Print Preview 1 2 Select Print Preview in graphical screens or enter R in text screens If multiple printers are available for the terminal either select the printer from the list or enter the appropriate code for the printer and press Enter Use the Devices function on the Resource Manager Workstation Configuration menu to add printers to the terminal Click OK or press Enter to continue OSAS Web B2B User s Manual 1 63 Reports Introduction 4 When available either select Standard or enter S if you want to view the report in standard width or select Compressed or enter C if you want to view it in compressed width 5 Press Enter The Print Preview screen displays the report as it will look when printed out in hard copy 6 To print from this screen select Print from the File menu To exit from this screen select
141. in certain applications The functions on the menu are determined by the applications installed The Information menu also gives you access to documents attached to customer vendor employee invoice or other records When the Information menu appears select the appropriate Documents command to open the Documents screen where you can view document information or open attached documents OSAS Web B2B User s Manual 1 41 OSAS Graphical Functions Introduction Scroll Commands Menu Commands Edit Modes Other Scroll Commands Information Help XX ts mE First Line lt Home gt Previous Page lt PgUp gt Previous Line lt Up gt Next Line Down Next Page lt PgDn gt Last Line lt End gt Insert lt Ins gt Delete lt F3 gt Jump The Scroll Commands menu appears only on screens with scroll regions Command First Line Previous Page Previous Line Next Line Next Page Last Line Insert Delete Jump 1 42 Description Moves the cursor to the first data entry field Displays the previous page Moves the cursor up to the previous line Moves the cursor down to the following line Displays the following page Moves the cursor to the last data entry field Inserts characters between pre existing entries in a field Deletes the selected characters Moves the cursor to the next section of the screen in some functions OSAS Web B2B User s Manual Introduction OSAS Graphical Functions
142. in scrolling regions e Ifa screen appears prompting for the kind of information to enter or maintain such as on File Maintenance or Transactions screens select the appropriate option and click OK to continue e Press PgDn if prompted to move to the next section e Click Header when it appears to return to the screen s header section e Press F7 to exit the screen and return to the main menu OSAS Web B2B User s Manual 1 37 OSAS Graphical Functions Introduction Graphical Function Screen Elements 1 38 Like the main menu graphical function screens also contain pull down menus and toolbars These menus and toolbars are described below Function Pull Down Menus Commands Menu Commands Edit Modes Other Information Help Inquiry Maintenance Proceed Start Over Field Up Field Down Abandon Delete Jump Exit F2 F6 lt PgDn gt lt PoUp gt lt Up gt lt Down gt lt F5 gt lt F3 gt lt Ctrl J gt lt F7 gt Command Inquiry Maintenance Proceed OK Start Over Field Up Field Down Abandon Delete Description Lists valid entries for the current field Opens the appropriate File Maintenance function Proceeds to the next screen or saves your entries Moves back to the first field on the screen or to the first field after the key field without erasing any entries or changes Moves the cursor to the previous field Moves the cursor to the next field
143. information about the Application applications you have installed Info Shift F5 Esc G On Windows workstations pressing this key Menu combination toggles between graphical and text Style main menus Shift F6 Esc K On Windows workstations pressing this key Toggle GUI combination toggles between graphical and text screens function screens PgUp Moves back one menu level Tab Moves back to the main menu from any application menus Enter Selects an application menu or function from a menu Up Down Moves the cursor up or down through the menu arrow selections 1 20 OSAS Web B2B User s Manual OSAS Graphical Menu In a Windows environment you can choose from two types of graphical style menus The standard graphical menu features application selections that resemble many Windows functions The start style menu is named so because of its functional resemblance to the Start menu in Windows 95 98 NT and 2000 Both graphical menus provide pull down menus convenient tool buttons and easy access to your installed applications and their functions using either the mouse or keyboard The two graphical menus provide you with a visual choice in your interaction with OSAS and your data When you select an application in either graphical OSAS menu the application s main menu presenting several related functions appears beside the OSAS menu Selecting a function leads you to either a function screen or another menu Sev
144. ional Listing uttempfl wbb Create and open a temporary string file Syntax CALL uttempfl wbb tempfile tempchan This low level routine is used in the Win CGI environment where temporary files are sometimes needed It can also be used when files are uploaded and parsed through utcgi wbb or by the application developer if a temporary string file is needed tempfile returns the name generated for the file If the environment variable TEMP is defined it is assumed to point to a temporary file directory Otherwise in UNIX the tmp directory is used and finally the current directory is used To override this directory selection create a global string STBL called tempdir and set its value to the directory to be used tempchan returns the channel number used to open the file uttplcp wbb Copy matching values from source to destination templates Syntax CALL uttplcp wbb source dest This low level routine simplifies the task of copying data from one template to another It scans the destination template and any matching field names and array elements in the source template are copied OSAS Web B2B User s Manual F 111 Toolkit Program Functional Listing Basic Web Utility Guide utwatch wbb F 112 Interface with a shared directory CGI request process Syntax RUN utwatch wbb This program continuously scans a directory for files that contain CGI requests The request file which must follow th
145. iscussion of these attributes flds is a text string that contains a comma delimited list of field names and optional format options If flds is null a default list is generated from all the fields in tpl flds can refer to individual array elements name n or it can refer to all array elements name in which case the form is generated with all defined array elements separated by a lt BR gt tag within the column If flds begins with itis presumed to contain a list of exceptions so that all the fields in the template tpl are used to generate the HTML output Those found in flds are referenced with the formatting tags included in flds For example if flds contained the data giffile image then all fields in the template would be generated and the field giffile would be treated as an image reference If flds begins with then all fields in the template except those listed after the first comma are included in the generated document See the uthtmout wbb information for formatting options captions is a string template that can contain captions for any field to be included in the form Specifically any in flds or if flds is null then any field in tpl The data for any field found in captions is used as the caption for the field If a field to be used on the form is not present in captions and a caption user attribute is not present in the template string a default caption is generated from the field
146. iting the data The string text blocked returns a version of the text passed in cgitext blocked based on the block size specified in block block indicates the block size to use when constructing blocked cgitext is analyzed for paragraph boundaries and all other line breaks are suppressed The paragraphs are word wrapped on block boundaries and appended to the blocked variable Paragraph breaks are indicated by blank line in blocked OSAS Web B2B User s Manual F 99 Toolkit Program Functional Listing Basic Web Utility Guide utmmoout wbb Format text containing CR LF characters as HTML Syntax CALL utmmoout wbb textin textout Web browsers ignore white space when formatting HTML output To force data output that contains CF LF line breaks to retain the breaks include lt P gt and lt BR gt tags in the HTML output This low level routine performs this function by analyzing textin and substituting the appropriate line or paragraph breaks The string variable textin contains the data with CR LF line breaks textout returns a HTML version of the text with lt P gt and lt BR gt tags where appropriate This routine is not a mirror of utmmoin wbb F 100 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utmore wbb Create more records information either as a URL or as hidden form tags Syntax CALL utmore wbb cgi flds moreurl morehidden When developing record
147. ive text contains the text to be converted and value returns the numeric value or 0 if the conversion fails utcprop wbb Convert a text string to proper case Syntax CALL utcprop wbb text This routine is used by various high level Basic Web Utility programs when a user attribute case proper is specified in a string template text contains the text to be reformatted and returns the formatted text OSAS Web B2B User s Manual F 71 Toolkit Program Functional Listing Basic Web Utility Guide utcstr wbb Unmask a string based on a mask and return an internal Syntax CALL utcstr wbb text mask result This program returns a value suitable for reformatting with the same mask using the STR function Business Basic developers often store formatted text values without any formatting and then display or print formatted versions using the STR function For example a US zip code stored as 957625555 could be reformatted as 95762 5555 with the mask 00000 0000 This low level routine examines a formatted text string and returns the unformatted result text string by comparing characters in text to the format specification in mask The Basic Web Utility high level programs use this routine to convert formatted CGI input when a template specifies a nonnumeric data type and a user attribute of mask mask utencode wbb F 72 URL encode and decode a text value Syntax CALL utencode wbb decode text result
148. l Syntax call utfrmout wbb tpl text work call uthtmfil wbb chan first last keynum maxrec count curkey tpl text work linkexpr call uthtmgen wbb tpl flds captions flags captags linkexprs work call uthtmkey wbb chan keys keylen tpl text work linkexpr call utfrmout wbb tpl text work call uthtmsel wbb fl where sortby opt maxrec skip count tpl text work linkexpr call utisip wbb env iplist valid call utmeta wbb tpl text call utmmoin wbb cgitext blocked block call utmmoout wbb textin textout call utmore wbb cgi flds moreurl morehidden call utselect wbb cgi tpl where andor F 55 Toolkit Program Reference Overview Basic Web Utility Guide Program Utsend wbb Utses wbb Utsub wbb Uttable wbb Uttags wbb Uttplbas wbb Uttempfl wbb Uttplcp wbb Utwatch wbb Description Send Text Back to the Client Browser Manage Session Record Substitute Occurrences of Text with Replacement Text Create HTML Table from an Array Append Text with Specified HTML Markup Tags to a HTML String Load Data Template from Basis Data Dictionary Create and Open a Temporary String File Copy Matching Values from Source to Destination Templates Interface with a Shared Directory CGI Request Process Syntax call utsend wbb text call utses wbb mode sesrec errmsg call utsub wbb tex
149. l a record is read with a key greater than last FF If first or last are null the records are processed from the first through the last records respectively first and last apply to the key chain specified in keynum keynum is the key chain number used when processing the file maxrec indicates the maximum number of records to include in the HTML output count returns the actual number of records included in the HTML output OSAS Web B2B User s Manual F 85 Toolkit Program Functional Listing Basic Web Utility Guide curkey is returned as null if the end of the file is reached Otherwise it contains the value of the key after the last one included in the HTML output This variable can be used to indicate a starting key value first for the next page in a scrolling type of application Typically it must be URL encoded before including it in a more records URL to continued scrolling URL encoding is performed by utencode wbb tpl is a data template used to read records from the file indicated by chan text is a string variable that contains the HTML format for each record along with embedded data name tags so that a list format or paragraph breaks are generated between records For each record the program uthtmout wbb is CALLed using this as the format text See the uthtmout wbb information for more details work returns the HTML text for the records The global string list also stores this value and can be us
150. les from OSAS Web B2B files are automatically created renamed and copied to in their destination drive The tables below shows the original file name the temporary file that is created and the final file name For a UNIX Linux based system the files are Original File owmenu tm2 owarmenu tm2 owinmenu tm2 owsomenu tm2 owlookup tm2 Temporary File Destination File Builds owmenu sh owmenu exe Builds owarmenu sh owarmenu exe Builds owinmenu sh owinmenu exe Builds owsomenu sh owsomenu exe Builds owlookup sh owlookup exe OSAS Web B2B User s Manual oword2 tm2 owpbrk tm2 owaddl tm2 oworder tm2 oworder2 tm2 oworder3 tm2 oworder4 tm2 oworder5 tm2 oworder6 tm2 oworder7 tm2 Builds oword2 sh Builds owpbrk sh Builds owaddl sh Builds oworder sh Builds oworder2 sh Builds oworder3 sh Builds oworder4 sh Builds oworder5 sh Builds oworder6 sh Builds oworder7 sh List of Files Copied oword2 exe owpbrk exe owaddl ex oworder exe oworder2 exe oworder3 exe oworder4 exe oworder5 exe oworder6 exe oworder7 exe For a Windows system a temporary file is not created The original file is copied and renamed to the destination file Original File OWMENU TMP OWARMENU TMP OWINMENU TMP OWSOMENU TMP OWLOOKUP TMP OWORD2 TMP OWORD6 TMP OWINVPR TMP OWPBRK TMP OWADDL TMP OWORDER TMP OWORDER2 TMP OWORDER3 TMP OWORDER4 TMP OSAS Web B2B User s Manual Destination File OWMENU BAT OWARMENU BAT OWINMENU BAT O
151. lication The program reads up to 10 customer records in name order from the customer master file using key chain 1 the Name sort key If additional records are available there are about 30 in the file a More records link is provided to continue the list 0001 SETERR ERRTRAP 0010 REM democlst bbx Basic Web Utility Customer Listing Demo 0020 REM Copyright 1996 by Allen Miglore All rights reserved 0030 REM Permission to derive programs from this is hereby granted 0040 REM provided said programs utilize licensed copies of the Basic Web Utility 0100 REM 1100 If restarting this list the CGI field startwith 0110 REM will contain the starting point This can come 0120 REM either from the form contained at the end of the 0130 REM democlst txt HTML template or from the more records 0140 REM continuation link A CGI variable startwith is passed to this program in two cases If the current execution is a continuation of the list then the more records URL will contain this field In addition at the bottom of the HTML page is a form with a startwith entry field to allow the user to restart the list at any time 0150 LET STARTWITH STARTWITH CVS FIELD CGIS startwith ERR 0200 4 F 26 OSAS Web B2B User s Manual Basic Web Utility Sample Program Reference These lines set the values for the uthtmfil wbb program identifying the key chain records per page and record structure The HTML template file
152. ling of data fields as input fields It is sensitive to the user defined format attributes in the data template tpl as well as format tags in the text template The template attributes are discussed in the Data Templates section The HTML text string text may contain any text meta instruction or field tag reference It is evaluated and copied with possible substitutions and insertions into work Meta Instructions include filename loads the text file file name into text This method creates HTML template files and incorporates them into an application filename must be accessible to Business Basic through a physical path or prefix search if datafield opr value end evaluates the expression datafield opr value If it fails it suppresses any text between the if and end tags If the expression is valid the tags are removed but the text between them is retained datafield can be either a field in the data template or a global string variable name The operator opr can be gt gt lt lt gt in or in The in and in operators in or not in perform position checks on text fields and values If datafield is numeric in the template the value must be a simple number If datafield is defined with a user attribute of date format the value should be a text date such as 11 30 95 if end tags may be nested If datafield is not found in the data template and is not a global string variable
153. llows them to load faster If you do not associate a graphic file with an inventory item OSAS Web B2B uses the convention of item ID GIF to search for images This convention can save you time Instead of taking the time to associate graphic image files with items using this function name your images with the appropriate item ID and place them in the directory specified for the virtual image directory on the web server When a customer accesses a web page that uses item images OSAS locates the appropriate graphic file according to the convention and displays it on the page In order to appear correctly on the web page the image files must be located in the directory specified for the virtual image directory on the web server OSAS Web B2B User s Manual 3 5 Inventory Item Pictures File Maintenance Inventory Item Pictures Screen 3 6 Inventory Item Pictures E 2151 xl Commands Edit Modes Other Scroll Commands Help 2xe re ma g Dr Item ID Description Picture Electrical g electric gif zj Plumbing Package plumbing ipg 2 Furnace fumace gif aj Water Heater wheater jpg Air Conditioner aircond pg Water Softener softener gif Sump Pump sumppump gif Humidifier humid gif Interior Door doorl ipg Entry Door door3 ipg Slide by Window 24 x 40 windows1 gif Slide by Window 30 X 40 windows3 gif Standard Window 24 X 40 wind
154. lpaper Traditional 240001 Wallpaper Traditional MDO001 Wallpaper Traditional MNODOT Wallpaper Traditional Tx0001 y Paints 3 r sumeiES PanSupes CE CT Pg First Next Prev laSt Append aLl nOne Header add Range Go to item Company H 11 05 2002 Terminal TODO OVR Lo p or F F n r r n n r r r r La OSAS Web B2B User s Manual 3 9 Internet Inventory Item Groups File Maintenance Inquiry Maint After you select a group code the screen lists the subgroups and items set up for that code Only the group codes you set up in the Item Group Codes function page 3 3 appear in the Group Code field If you have set up a picture for an item using the Inventory Item Pictures function page 3 5 the graphics file name appears in the Picture field The Sub field indicates whether the line item is a subgroup if the check box is selected or if YES appears in text mode the line item is a subgroup if it is clear or if NO appears in text mode the line item is an inventory item To set up a subgroup first set up the subgroup code and description using the Item Group Codes function page 3 3 Next enter that code in the Group Code field and add inventory items to it Finally enter that group code as a line item for a different group code When the Is this item a subgroup message appears select the check box or enter Y i
155. lt body bodyopt gt stdhead When utexit wbb is called and if this global string exists the following text is added to the document stdfoot lt body gt lt html gt othe rhead A global string to add additional HTML heading elements to the document A common example would be a lt META gt tag such as meta namez keywords content sdsi bbweb gt To improve viewing of the HTML source place a line feed between each header element in the global string OSAS Web B2B User s Manual F 39 Standard Structure Options Basic Web Utility Guide bod yopt A global string that if present is appended to the lt body gt tag inside the closing bracket Establishes default colors or background tile images stdh ead A global string to reference a physical disk file that is loaded at the top of each document just below the lt body gt tag stdf oot A global string references a physical disk file that is loaded at the end of each document by a call to utexit wbb To invoke the standard structure the first call to utsend wbb should be the first body text of the document It is possible to call utsend wbb with a Location or Content type header The Basic Web Utility does not interfere with control of the output or the inclusion of the standard structure elements If disk files are used as the page source and standard structure features are also used eliminate all heading and closing codes generated by
156. ly include aging balances and credit information You can specify the information available on this page using the Customer Internet Access Codes function on the File Maintenance menu Account Information HTML Screen 4 0SAS Customer Lookup Microsoft Internet Explorer Ban ini xi EEG A Ay Qe O x 12 cm JO sem speres QU meda el Tee unis 3l E 7 Zu Mem 4 SYSTEMS INC Information Inventory Orders Account Information Customerin Ac Eoo A CE ACE BUILDERS MSM 605 555 1646 IcreditLimit 315 000 00 Invoice Inquiry IIS TCR 2PCT Discount 2 10 Days Net Due 30 Days Login Page Period to Date Quarter to Date Year to Date Sales 26 650 89 216 761 42 1 665 331 24 Number of Invoices 2 4 14 TESTA 12670074 ESSEN ET 12 21 2000 New Finance Charge 5 00 Unpaid Finance Charge 5 00 History Inquiry Click Top of Page to return to XE 5135 735 44 i the top of the web page When you finish reviewing the 5 information close the browser Unappnad Credit Sd to end your session or choose 135 738 44 a different menu selection from the side or top menus Bs Top of Page of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved y OF RJ Local intranet OSAS Web B2B U
157. m Product Suggestions Application Options Inquiry Global Inquiry General Information Inquiry Support Information User Comments EIS Dashboard Display EIS Dashboard History 1 26 Pop Up Calendar Inventory Price Calculator Command Description Calculator Opens the OSAS calculator Execute an Operating System Command Call a PRO 5 Program Product Suggestions Application Options Inquiry Global Inquiry General Information Inquiry Support Information User Comments EIS Dashboard Display EIS Dashboard History Allows you to enter an operating system command from within OSAS Allows you to execute a PRO 5 program Creates a report for future OSAS product suggestions Allows you to view the application options you have set up for a particular application Allows you to search across your data You can select from the installed applications which data to search Allows you to search for information on employees customers and vendors Displays the OSAS Support Information Allows you to record comments for your own use Displays the EIS Dashboard Displays the EIS Dashboard history OSAS Web B2B User s Manual Introduction OSAS Graphical Menu Command Description Pop Up Calendar Allows you to create and read date reminders in OSAS Inventory Price Allows you to calculate prices and view quantity Calculator cost and pricing information for inventory items Help Menu File Modes Tools Fav
158. mand 1 66 scroll region command 1 42 1 51 user s manual conventions 1 13 V verification button Abandon 1 45 Proceed OK 1 45 Verify exit mode pull down menu command 1 39 Verify PgDn mode pull down menu command 1 40 View inquiry command 1 49 View Submit Current Order HTML screen 8 25 Order Number HTML screen 8 30 Select Shipping Address HTML screen 8 27 Shipping Address Information HTML screen 8 28 viewing comments 1 56 documents 1 60 Ww web pages OSAS Web B2B User s Manual Account Information 8 5 Aged Trial Balance 8 7 Customer History Lookup 8 9 Customer Invoice Inquiry 8 11 Customer Lookup 8 5 Customer Order Lookup 8 19 History Inquiry 8 9 Invoice Inquiry Lookup 8 11 Order Entry group codes 8 22 Order Entry Items 8 23 Order Entry Line Item 8 24 Order Inquiry 8 19 Order Number 8 30 OSAS Web Login Page 8 3 Select Shipping Address 8 27 Shipping Address Information 8 28 View Shopping Cart 8 25 WEBPATH table 3 21 Workstation date entering in graphical menus 1 24 tool button 1 24 OSAS Web B2B User s Manual
159. mation On the graphical and start style main menus the right click menu gives you quick access to commands that help you manage commands on your Favorites menu switch between sample and live data perform certain setup tasks and view function information To access the menu click the right mouse button anywhere on the graphical or start style main menu OSAS Web B2B User s Manual Introduction OSAS Graphical Menu Command Description Add to Remove Use the Add to Remove Favorites Menu button to Favorites F10 add the desired submenu or function to or from your Favorites menu Change to Favorites Toggles your display menu between the Favorites Main and main menus F2 Sample Data Live Switches between sample and live data Data F5 Setup F9 Performs certain application setup tasks For example in General Ledger you can select the year with which you want to work If Setup is required in an application the application s user s manual describes its use Function Displays information about the selected function Information F1 Data Set Data Set Live Data C Sample Data On the start style main menu you can select the Live Data radio button to work with live data or select the Sample Data radio button to work with sample data You can also press F5 to toggle between sample and live data Change Company Field H Builders Supply m On the start style or graphical main menu select the company to change to from
160. methods used by the Basic Web Utility the on demand method and the shared directory method On Demand Method The most efficient method is to start a Business Basic task for each request Because requests are usually answered quickly and the task exits problems with user count restrictions are few A shell script called bwu sh is included with the Basic Web Utility and can be used for this interface method Also bwu sh can be copied to a PATHed directory and CGI scripts written bin sh PGM program bb export PGM MEM 312 export MEM exec bwu sh OSAS Web B2B User s Manual F 13 The Basic Web Utility and CGI Basic Web Utility Guide Replace program bb with the Business Basic program name to be started by bwu sh An alternative is to copy bwu sh to the desired script name in the CGI directory and edit it to include the PGM and MEM variables internal to that script With Windows NT and Windows 95 use stdcgi exe or wincgi exe depending on the web server s CGI support Most support standard CGI Others such as O Reilly Website also support Win CGI Associated bat files must be provided for stdcgi exe and wincgi exe to work On Demand Programming Example Once the Business Basic program is started it must read the CGI input and develop a HTML response A CALL to utcgi wbb is needed to read the input A variety of routines are available to produce the output and should be sent out through CALLs to utsend wbb When the output i
161. n Questions 5 3 5 5 5 7 5 11 6 3 6 5 6 7 7 3 7 5 7 9 7 11 7 13 7 15 7 17 8 3 8 5 8 7 8 9 8 11 8 13 8 19 8 21 A 1 B 1 OSAS Web B2B User s Manual Contents List of Files Copied Editing Files Files for Remote Access Basic Web Utility The Basic Web Utility and CGI Data Templates Sample Program Reference Suggestions and Tips Standard Structure Options HTTP Cookies Automatic Session Tracking File Uploading Support Global String Reference Toolkit Program Reference Overview Toolkit Program Functional Listing Index OSAS Web B2B User s Manual C 1 D 1 E 1 F 1 F 3 F 17 F 21 F 37 F 39 F 41 F 43 F 45 F 47 F 53 F 57 I 1 Introduction Welcome to OSAS The OSAS Web B2B System Conventions OSAS Text Menu OSAS Graphical Menu OSAS Text Functions OSAS Graphical Functions Menu and Function Commands Favorites Menu Information Menu Reports OSAS Web B2B User s Manual Welcome to OSAS The OPEN SYSTEMS Accounting Software OSAS product line consists of several accounting applications Each application addresses a different phase of your financial operations together they form a powerful accounting solution to your daily and periodic accounting needs Customer Support Open Systems Inc has a strong commitment to customer service and product quality If you have difficulty using Open Systems Inc products consult your user s manual and other OSAS reference materials
162. n of items To save your entries press Enter at the Item ID or Subgroup Code field To exit to the File Maintenance menu use the Exit F7 command Add Range of Items Screen The Add Range of Items screen appears when you press R on the Internet Inventory Item Groups screen to add a range of items to an item group BIET Commands Edit Modes Other Inventory Lookups Help zx ts ae mi 20 OK Abandon Item ID From 100 Le llo Thru 200600 Location From MN0001 aj Thu MNO002 aj Product Line From APPLIANCE aj Thu HEAT AIR aj Select the range of item IDs locations and product lines to add to the inventory item group To add all items for a location to an item group enter only the location IDs whose items you want to add To add all items from an inventory product line to a group enter only the product lines OSAS Web B2B User s Manual 3 11 Customer Internet Access Codes You grant Internet access to your data for your customers through Internet access codes You can limit access for certain customers to particular web pages and item groups You can set up multiple access codes for specified customers This function allows some of your customers employees access to limited data while others can access more extensive information You can also set up master access codes that are not associated with a particular customer For example these access codes can be given to your sales representatives allo
163. n text mode to indicate that you are adding a subgroup then enter the subgroup code To exclude an item or item location from the list select the line to exclude and use the Delete F3 command to remove it from the list Commands 3 10 Use these commands to work with the items and subgroups for a group code e Press F to view items for the first item group on file e Press N to view items for the next item group on file e Press P to view items for the previous item group on file e Press S to view items for the last item group on file e Press A to add an item or subgroup to the group The Is this item a subgroup message appears To add a subgroup to this group select the check box or enter Y in text mode and then enter the subgroup code OSAS Web B2B User s Manual File Maintenance Internet Inventory Item Groups To add an item to this group clear the check box or enter N in text mode and then enter the item ID All locations for the item are added to the list e Press L to include all inventory items in this item group e Press O to remove all inventory items from this group e Press H to select a different group code e Press R to add a range of item IDs to the group The Add Range of Items screen appears Press G to move to a specific item then enter the item ID or use the Inquiry F2 command to select the item from the list that appears This command is available only when there is more than one scree
164. nal Transactions Transactions ODBC Kit Reports Copy Recurring Entries Bills of Materials Kitting Periodic Processing GL Joumal Bank Reconciliation File Maintenance GL Activity Report Payroll with Direct Deposit Statement Maintenance GL and Transaction Inquiry Fixed Assets Master File Lists General Ledger Post to Master Inventory Job Cost Purchase rder Sales Order More IL Company H Terminal T000 08 14 2002 11 30 AM You can exit from a graphical menu in these ways e Select a button from a previous menu e Press the Tab key to go to the OSAS menu e Click the Close box in the upper right corner of the window Use Exit F7 e Select Exit from the File menu 1 22 OSAS Web B2B User s Manual Introduction OSAS Graphical Menu Start Style Main Menu TODO OPEN SYSTEMS Accounting Software a Agel xl File Modes Tools Favorites Other Help noe mumkgo Date and Time y Data Set H Builders Supply zl 08 14 2002 Live Data 11 32AM C Sample Data I GENERAL Report Writer I obec kit I Bills of Materials AKitting Bank ion I Payroll with Direct Deposit LL Fixed Assets LL General Ledger C Inventory I Job Cost I Purchase Order I Sales Order C More s gt INS C Reconciliation gt Sy Void Checks and Stop Payments LI File Maintenance N BR Journal L Master File Lists gt Bank Account Register N Post Transaction
165. name by converting underscores to spaces and formatting the name with the proper case OSAS Web B2B User s Manual F 87 Toolkit Program Functional Listing Basic Web Utility Guide F 88 Note that a null field in captions results in no caption for that field flags is a text string containing various formatting controls in any order The flags supported include table Formats the captions and input fields in table columns one row per field tre Use pre format tags to format the form allowing perfect column alignment without relying on table structures but using fixed pitch fonts lt p gt Indicates there should be extra space between each row align value For tables sets horizontal alignment of the caption or cellalign value cell to value typically left or right valign value For tables sets vertical alignment to value such as top or bottom font value Add lt font value gt and lt font gt tags to the text in cells hdrfont value and captions respectively Because there can be no spaces in value use underscores for multiple options For example font size 4_color blue cellopt value When the table option is used add value to the end of hdropt value the lt td gt and lt th gt tags respectively No spaces are allowed For multiple options these are separated with an underscore see above border border n For table forms there should be a border around each cell right Captions are placed to the right of
166. nc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved silii Local intranet The items and subgroups that belong to the group you select appear Units of measure and unit prices appear for items in the group e When you click on a subgroup ID you see the items in that group e When you click on an item ID the Order Entry Line Item page appears e When you click on a highlighted description you see additional description information and an image of the item if available see page 8 17 for a sample of the additional descriptions page The screen lists up to 10 items and subgroups for the item group If there are more than 10 items the Next and Previous buttons appear Click these buttons to scroll though the items and subgroups OSAS Web B2B User s Manual 8 23 Order Entry The Web Interface You can also search for a specific item within any available group by entering the item ID and clicking Search for Item If there are items in your shopping cart the View Shopping Cart command appears in the side menu Click View Shopping Cart to list its contents If you close your browser or leave the Order Entry web pages your shopping cart remains intact for 24 hours When you return to the site within the allotted time period you can resume your order entry from where you left off Order Entry Line Item HTML Screen es Orde osoft Internet Explore ES 15 x File Edit View Favorites Tools Help ar
167. ned with a value the end of the file was not reached and a More records URL is constructed to continue where the list ended This URL is placed in the global string MOREURL which is referenced in the HTML text template democlst txt 0500 REM 100 Construct List 0510 REM uthtmfil wbb reads from a channel and builds list of 0520 REM records using a particular structure into a string 0530 CALL uthtmfil wbb CUSTCHAN STARTWITHS KNUM MAXRECS COUNT CURKEY CUSTS OSAS Web B2B User s Manual F 27 Sample Program Reference Basic Web Utility Guide F 28 STRUCTURES CUSTLIST LINKEXPR 0600 REM 1100 If there are more records in the file add a more records 0610 REM link URL to continue curkey contains the key to the 0620 REM next record required By placing this in a STBL the 0630 REM uthtmout wbb program that loads the HTML template can 0640 REM conditionally place it after the list 0650 LET X STBL MOREURL IF CURKEY THEN GOTO 0680 0660 CALL utencode wbb 0 CURKEY NEXT_STARTWITH 0670 LET MOREURL STBL MOREURL ENV SCRIPT_NAME pgm democlst bbx amp startwith NEXT_STARTWITH The HTML file democlst txt is loaded and parsed into the variable HTML In that file is a comment lt List Here gt which is substituted with the contents of the CUSTLISTS variable generated above The full text of HTML is sent with the utsend wbb program and the program exits In version 1 1 two glo
168. nents function This path must be set up before you can use this function A 6 OSAS Web B2B User s Manual Common Questions When try to access the web get an error Why A drive in your computer is mapped but not used by OSAS Web B2B and should be excluded in the CONFIG BBX file Add this line to your CONFIG BBX file specifying the appropriate drive letter dsksyn E Specify a dsksyn line for each drive mapped but not used by OSAS Web B2B Read Appendix D for more help on editing your CONFIG BBX file How many users can access OSAS Web B2B at the same time The number of customers OSAS Web B2B allows to access your data depends on two things your web server and the BBx interpreter While the number of users depends on the program s limitations you can control the number of users within certain parameters The web server can be set to allow only a limited number of users depending on the server s capabilities Consult your web server s guide for more help Your BBx interpreter can handle a given number of users depending on your activation key If more than that number of users try to access functions in OSAS Web B2B at the same time the users that logged on last will receive an error An interpreter session is only open for as long as it takes to load the HTML page When the page is finished loading the session closes allowing another user to have access OSAS Web B2B User s Manual B 1 Common Questions
169. ng underscores to spaces and formatting the name with proper case A null field in captions results in no caption for that field flags is a text string containing various formatting controls each separated by at least one space in any order The supported flags include table pre p align left center right cellalignzleft center right valignztop bottom border borderzn hdroptzoptions celloptzoptions OSAS Web B2B User s Manual Formats the captions and input fields in table columns one row per field Use pre format tags to format the form allowing perfect column alignment without relying on table structures but using fixed pitch fonts Indicates there should be extra space between each TOW Sets horizontal alignment for table captions Sets the horizontal alignment for table data cells Sets vertical alignment to top or bottom for tables For table forms there should be a border around each cell Adds options to the th and td tags respectively No spaces are allowed but underscores can be used for multiple options hdropt bgcolor red_align right for example generates th bgcolorzred align right gt F 77 Toolkit Program Functional Listing Basic Web Utility Guide F 78 font fontopts Adds a lt font fontopts gt tag to each data cell and hdrfont fontopts caption cell respectively Use underscores for spaces For Example size 4_color black adds lt font size 4 col
170. ntact for 24 hours When you return to the site within the allotted time period you can resume your order entry from where you left off OSAS Web B2B User s Manual 8 29 Order Entry References Order Number HTML Screen File Edit View Favorites Tools Help Qu Q Back M z x E JO Search Se Favorites QU Media e e y E En 29 Links gt amp yy DPEND SYSTEMS INC Information Inventory Orders Order Inquiry Order Entry F Your order number is 00000012 Login Page Top of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved SJ Local intranet The number assigned to the order appears After you record the order number you can close the browser to end your session or choose a different menu selection from the side or top menus If you use remote processing this number may change when you run the Build Sales Orders from Remote Files function page 5 7 on the Sales Order Processing menu 8 30 OSAS Web B2B User s Manual System Messages Access code access code for company company ID and customer customer ID does not exist The access code from which you are trying to copy is not set up for the customer and company entered Check the access code and verify that it is
171. ntry Orders Order Enty 0 0 0 0 0 0 0 0 0 NN A web pages from E within the listed Enter togge ai Delete Append Edt Options like these give customers access to the type of information listed for that web page The Link to Order Entry options give apa web page 170672002 Terminal TODO ova Select this option to show customers on Select this option to show customers the hand inventory item quantities on the message Available on the Order Entry Order Entry web page web page when on hand quantities exist in Inventory You must elect to show on hand quantities before you can use this option If no on hand quantities exist in inventory the message Out of Stock appears instead Inquiry 1 Enter the customer ID to which you want to give access To set up a master password leave this field blank Inquiry 2 Enter the access code A customer may have multiple access codes Inquiry 3 If you enter a new access code the Copy From Company ID field appears You can copy access parameters from a customer in this company or in another company Enter the company ID from which you want to copy customer access codes or press Enter to proceed without copying 3 14 OSAS Web B2B User s Manual File Maintenance Customer Internet Access Codes 5 If you entered a company ID the Copy from Customer ID field appears Enter the customer ID from which you want t
172. o copy an access code The customer ID you specify must use the same access code you specified in the Access Code field Enter the inventory location ID you want to use to calculate prices for this customer If the customer has access to the listed web page or its related information the Access check box is selected or YES appears in text mode If the customer does not have access the box is clear or NO appears in text mode Press Enter to toggle access on and off for the selected option or use the commands to toggle access for all options Use these commands to work with the HTML page options in the list e Press Enter to toggle access for the selected option on and off e Press Lto give the customer access to all the page information listed e Press N to deny the customer access to all the page information listed e Press W to save your changes e Press C to return to the Customer ID field to select another customer e Press Gto open the Customer Groups screen page 3 18 where you can specify which item groups this customer can access e Press D to remove this access code for this customer e Press A to add an HTML page option to the list Press E to edit an HTML page option You cannot edit system pages To save your entries press W Next enter another customer ID and access code or use the Exit F7 command to return to the File Maintenance menu OSAS Web B2B User s Manual 3 15 Customer Groups Use the Cu
173. o description is available APPLIANCE STOVE No description is available DISHWASHER 910001 Dishwasher Black caoool dwasherb gif DISHWASHER 910001 Dishwasher Black mpoool dwasherb gif DISHWASHER 910001 Dishwasher Black MNOO01 dwasherb gif DISHWASHER 910001 Dishwasher Black TX0001 dwasherb gif DISHWASHER 910002 Dishwasher White CAO001 dwasher gif DISHWASHER 910002 Dishwasher White Mpoo01 dwasher gif DISHWASHER 910002 Dishwasher White MNOOOL dwasher gif DISHWASHER 910002 Dishwasher White TX0001 dwasher gif DISHWASHER 910003 Dishwasher Almond caoool dwashera gif DISHWASHER 910003 Dishwasher Almond mpoool dwashera gif DISHWASHER 910003 Dishwasher Almond MNOOOL dwashera gif DISHWASHER 910003 Dishwasher Almond TX0001 dwashera gif DOORS 300 Interior Door CAO001 door300 3jpg DOORS 300 Interior Door Mpoo01 door300 3jpg DOORS 300 Interior Door MNOO01 door300 3jpg DOORS 300 Interior Door TX0001 door300 3jpg DOORS 350 Entry Door caoool door350 jpg DOORS 350 Entry Door MDOOOl door350 jpg DOORS 350 Entry Door MNOOOL door350 3pg DOORS 350 Entry Door TX0001 door350 3jpg HEAT AIR 200 Heating Cooling Package caoool HEAT AIR 200 Heating Cooling Package mpoool HEAT AIR 200 Heating Cooling Package MNOO01 HEAT AIR 200 Heating Cooling Package TX0001 HEAT AIR 200100 Furnace CAO0001 HEAT AIR 200100 Furnace mpoool HEAT AIR 200100 Furnace MNOO01 HEAT AIR 200100 Furnace TX0001 OSAS Web B2B User s Manual 7 11 Internet Access Codes List The
174. o perform an operation Verification is on when the Verify flag appears at the bottom of the screen Messages Messages appear at the bottom of the screen when a command is unavailable or when OSAS needs information to continue r Verification Press lt PgDn gt to proceed 1 36 OSAS Web B2B User s Manual OSAS Graphical Functions On Windows workstations you can choose to use the graphical mode for function screens These screens contain all the functionality of text screens presented in a graphical mode similar to other Windows software programs La Textocations M Tix Commands Edt Modes Other Scroll Commands Help gr Abandon 2 gt xec pajma 7 e Tax Location MNMPLS aj Tax Level 2 Authority Tax Liability Acct Class Description Consumer Goods n Resale Sales 00 amp 02 Exempt Sales 00 aj Ind gr Prod 0 000 0 000 00 00 Interstate Comm 0 000 0 000 oo 00 Motor Vehicles 0 000 0 000 oo 00 Food Products 0 000 0 000 00 00 Clothing 0 000 0 000 00 00 y Gasoline 0 000 0 000 oo 00 y Services 0 000 0 000 oo 00 zj Total 00 00 Calculated 00 00 ver Short 00 00 Enter edit Tax Loc First Last Next Prev View Header Company H 08 23 2002 Terminal T000 OVR You can move around the screen in these ways e Use the mouse or press Tab to move from field to field Use the scroll buttons to move from line to line
175. ocessing Build Sales Orders from Remote Files Build Sales Orders from Remote Files Log 11 01 2002 4 51 PM Order No 00000142 00000144 00000145 00000146 00000149 11 01 2002 11 01 2002 11 01 2002 11 01 2002 11 01 2002 End of report OSAS Web B2B User s Manual Builders Supply Sales Orders from Remote Files New Order No 00000155 00000156 00000157 00000158 00000153 Additional Comments Please process promptly Note Shipping Address Change May substitute standard window 5 9 Purge Log File Use the Purge Log File function to clear the log file for new orders If you use remote processing you should use this function after you use the Build Sales Orders from Remote Files function page 5 7 You should print the Transaction Journal page 5 5 before you run this function to preserve an audit trail of the orders that have been entered Purge Log File Screen puroeLogrie Ax Commands Edit Modes Other Help 2xresbelma amp OK Abandon Web Server Programs Path c inetpub wwwroot osasweb Company H 11 06 2000 Terminal TODO INS The web server programs path you entered in the Install Web Server Components function appears Press Enter to accept this path or enter a different one Use the Proceed OK command to begin the purge process When the purge finishes the Sales Order Processing menu appears OSAS Web B2B User s Manual 5 11 Remote Access Remote Acc
176. ome End F7 Exit Left Right Tab Toggle Up Down Operation Moves to the previous page of the report Moves to the next page of the report Moves directly to the top of a group of pages Moves directly to the bottom of a group of pages Exits to the menu from any point in the report Moves left one character Moves right one character Toggles between the left and right halves of a report Moves a line up and down the screen to line up information when you toggle between halves of a report OSAS Web B2B User s Manual Installation and Setup Installing the Web Server Installing OSAS Web B2B OSAS Web B2B User s Manual 2 3 2 5 2 1 Installing the Web Server Before you install and set up OSAS Web B2B you must install and configure your web server OSAS Web B2B works with most popular web servers However the web server you use must have the ability to use Standard CGI You can install the web server on the same system on which OSAS is installed or you may choose to install it on a separate computer If you choose to use a different computer for a web server you must be able to establish communications between your OSAS system and the web server through a network or modem connection The web server and the OSAS system must be able to communicate because OSAS Web B2B provides several functions that move data files and programs from OSAS to the web server and back again When you set up your web server
177. on demand method but it allows control of user counts and can also be implemented in environments where Business Basic cannot work with standard input and output handles The Business Basic program utwatch wbb can be in the background and watch a directory or run other programs based on requests in that directory The UNIX shell script bwu2 sh can also be used to create shared directory requests Shared Directory Programming Example In the on demand mode the Business Basic program is RELEASEd while in the shared directory mode the program utwatch wbb is repeated until the next request An option in BBx4 Pro5 installations uses the BACKGROUND directive to start utwatch wbb before completing the request The program starts more quickly to respond to other requests and takes advantage of the BASIS user count logic of eight background slots per foreground slot When BACKGROUND is used successfully the task running in background should RELEASE OSAS Web B2B User s Manual F 15 The Basic Web Utility and CGI Basic Web Utility Guide The first attempt to pass control back is with the background verb If successful the current program is running under a different task and it sets the bkg variable flag to 1 The original task again runs utwatch wbb Note that utcgi wbb must be called before the background verb because if successful standard input handles are no longer available This example is identical to the previous one except that con
178. only when there is more than one screen of item group codes When you finish use the Exit F7 command to return to the File Maintenance menu Append Edit Group Code Screen 3 4 The Append Group Code Screen appears when you add a new group code to the list The Edit Group Code Screen appears when you edit an existing group code Other than the title these screens are identical E Commands Edit Modes Other Help xtme amp mu e OK Abandon Group Code APPLIANCE Description Appliances Enter the group code up to 10 characters If you are editing an existing group code as in the example above you cannot change the group code Instead return to the Group Codes screen use the Delete F3 command to delete the incorrect code then press A to enter a new code Enter the code s description then use the Proceed OK command to save your changes and return to the Group Codes screen OSAS Web B2B User s Manual Inventory Item Pictures Use the Inventory Item Pictures function on the File Maintenance menu to associate a graphic file with your inventory items The graphic image associated with the item appears on the Item Inquiry and Order Entry web pages You can use a variety of graphic image formats including JPG and GIF image files Not all graphics formats can be viewed with all browsers Generally GIF and JPG images are recommended because most browsers can display them and because their small file size a
179. ontents The global string imagelib may be used to specify the physical path to the image files and is prepended to the data from the template to find the image file and calculate pixel dimensions for gif files Also the global string imageurl is prepended to the image src tag image src STBL imageurl data value gt options may include keys item1 item2 itemn vals desc 1 desc2 descn sep char or hex cols columns OSAS Web B2B User s Manual F 83 Toolkit Program Functional Listing Basic Web Utility Guide TOWS IOWS alt alternate image description wrap value The sep option defines the separator character in keys and vals By default it is a semicolon but may be set to any value including nonprintable values except a quote The options are used in different ways by the different field input types For radio and checkbox groups keys generates the returned value for each group item and vals is used as a caption for each item In addition if columns is less than 2 items are positioned vertically If columns is between 2 and 98 items are placed in a table of the specified number of columns across If columns is over 98 items are placed horizontally and the browser breaks the lines in an unpredictable manner For list and mlist groups keys and vals are combined to form each listbox item in the format of itemn descn In addition if rows is specified then the list box is defined
180. ookup 1 43 Modes 1 39 Other 1 40 Scroll Commands 1 42 graphical menus 1 24 Favorites 1 25 File 1 24 Help 1 27 Modes 1 25 Other 1 26 Tools 1 25 Purge Log File function 5 11 screen 5 11 Q Quick mode pull down menu command 1 40 R Remote Access E 1 Remote Access functions overview 6 3 Remote Access menu structure 1 10 remote processing defined 2 5 5 3 6 3 files copied C 1 function of files copied in OPEN Web C 4 report commands 1 66 Down Arrow 1 66 End 1 66 Exit 1 66 F7 1 66 Home 1 66 PgDn 1 66 PgUp 1 66 Right Arrow 1 66 Tab 1 66 Up Arrow 1 66 Reports conventions 1 61 including all information 1 61 limiting information 1 61 OSAS Web B2B User s Manual selecting information for 1 61 Resource Manager features of 1 3 Right Arrow report command 1 66 Right Arrow function key 1 51 right click defined 1 13 S sales order numbers 5 4 Sales Order Processing checklist 5 3 Sales Order Processing menu structure 1 10 sample data changing to 1 24 1 29 scroll region commands 1 51 Down Arrow 1 42 1 51 End 1 42 1 51 Enter 1 51 F3 1 42 1 51 Home 1 42 1 51 Ins 1 42 1 51 PgDn 1 42 1 51 PgUp 1 42 1 51 Tab 1 42 Up Arrow 1 42 1 51 Security Procedures and Devices Firewalls 2 4 Serial Inventory Lookup function key 1 50 pull down menu command 1 43 Set up application 1 29 Setup Item Group Codes screen 3 3 5 5 Setup OPEN Web Components menu str
181. or black gt and lt font gt tags to the data right Captions are placed to the right of the input fields top Captions are placed above the input fields In addition if pre or table is specified the data is arranged in columns and array values in the template are scrolled within the column captags is a text string that contains any tag used to format the captions before being placing in HTML form This string is used in a CALL to uttags wbb Refer to that program page for more information work is a text string that returns the HTML version of the form This form is incomplete as returned and needs a Submit button and the lt form gt lt form gt HTML tags It may be necessary to use this feature to build a form from several data templates The following code creates a simple form CALL utcgi wbb env cgi errmsg rem generate heading CALL uttags wbb h1 Customer Update Form html rem create template for new customer dim rec id c 5 name c 40 street c 40 city c 30 state c 2 case upper zip c 9 mask 00000 0000 rem if existing customer the rec template could be filled here rem create form fields in table format note ID is a hidden field and can t be changed OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing CALL utfrmgen wbb rec id hidden name street city state zip table border formhtml rem add submit button CALL uttags wbb
182. ore information Starting OSAS in Windows To start OSAS on a computer running Windows double click the OSAS shortcut on the desktop or access the program from the Start menu Starting OSAS on Other Operating Systems To start OSAS on an operating system other than Windows enter osas at the operating system prompt The osas command can recognize three parameters t c and a The terminal ID t is the identification code assigned to the terminal you are using to run OSAS On multiuser systems each terminal usually has a default ID assigned when the terminals were added to the system Use the t parameter only when you want to log on with an ID other than the default ID The terminal parameter is valid only if you are using Resource Manager for LANs The company ID c is the identification code assigned to a company If your system carries two or more companies and you do not enter a company ID the menu of the company entered by the last person who used the terminal appears The access code a is your personal password Use the Access Codes function on the Resource Manager Company Setup menu to set up access codes The most general expression for getting into OSAS takes all the parameters into account For example if you are on terminal 2 T2 working with company B and the password is apple specify that information to access the system osas t T2 c B a apple OSAS Web B2B User s Manual Introduction Welcome to OSAS
183. orites Other Help Ees Em GE NS he Help F1 About OSAS Command Description Help Opens help descriptions for the application menus and functions About OSAS Opens the About OSAS dialog box Main Menu Toolbar The main menu toolbar gives you quick access to frequently used OSAS commands To access a command click the appropriate button Baw BEENS Button Description raj Opens the Workstation Date dialog box to change the date See Workstation Dates on page 1 15 for more information El Opens the Access Code dialog box to switch between access codes See Access Codes on page 1 15 for information s Displays the Application Information dialog box OSAS Web B2B User s Manual 1 27 OSAS Graphical Menu Introduction 1 28 Button Description Opens help descriptions for the application menus and functions lo Opens the OSAS calculator El Displays the pop up calendar screen You can use the calendar to add and review reminders for any date me Opens an MS DOS command window Bu Displays a screen for calling any BBx program that does not require variables to be passed to it For more information see Appendix F in the Resource Manager User s Manual o Toggles between the Favorites and main menus See 73 i p Favorites Menu on page 1 53 for more information Right Click Menu Add to Favorites Change to Favorites Sample Data GL Setup Function Infor
184. ou finish viewing price and price break information use your browser s Back button to return to the Item Inquiry web page When you finish reviewing items close the browser to end your session or choose a different menu selection from the side or top menus OSAS Web B2B User s Manual Order Inquiry The Order Inquiry web pages display the orders on file from a customer The information includes the shipping status of the order and optionally the line item detail for individual orders Order Inquiry HTML Screen d OSAS Customer Order Lookup Microsoft Internet Explorer File Edit View Favorites Tools Help Qa O x 2 JO search Se Favorites Media Ir AS AREN p sa ug SYSTEMS INC Information Inventory Orders Order Inquiry CET ACEO01 Order Entry Customer Name____ JeS BUILDERS LOTE OTT iP E TET 605 555 1646 Login Page Order Requested Ship PO PO Type Invoice cunt Number Date Number Date P Number ooo00009 10 21 2002 Returned 24889107 973 96 00000011 10 31 2002 Unshipped 3 554 30 Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved al al E i RI Local intranet 4 The screen lists up to 10 orders for this customer Returned orders appear in red If there are more t
185. ou have two options regarding data access local processing and remote processing Local processing allows direct access to your data files This method provides the most timely information to your customers and is easy to set up and maintain Remote processing allows access only to copies of your data files Remote process is more secure allowing you to isolate the web server and Internet users from your other accounting data The method that you choose determines the tasks you need to perform to maintain the OSAS Web B2B system OSAS Web B2B User s Manual 1 9 The OSAS Web B2B System Introduction OSAS Web B2B Menu Structure The OSAS Web B2B menu structure is similar to the structure of other OSAS applications functions appear roughly in order of use Sales Order Processing Use the functions on the Sales Order Processing menu to process and track the orders entered through the web server You can produce a list of new orders and purge the order log You can also copy the orders to your OSAS data files if you are using remote processing Remote Access Use the functions on the Remote Access menu to copy data files and programs to the web server if you are using remote processing File Maintenance Use the functions on the File Maintenance menu to establish groupings for Inventory item display to add references to graphical pictures of items and to set up and establish access to your item and customer information
186. owal gif Standard Window 30 X 40 windowa jpg Cabinets cabinet gif Refrigerator Black fridgeb gif y 3 zl Append Enter edit Go to item Company H 11 05 2002 Terminal T000 OVR The screen lists the inventory items and descriptions set up in the Inventory Items function along with associated pictures If you did not associate a picture with an item the item does not appear in the list Use the commands to work with inventory item pictures e Press Enter to edit a picture name The Edit Item Picture screen appears e Press A to add a new picture The Append Item Picture screen appears e Press G to go to a specific item then enter the item ID or use the Inquiry F2 command to select an item from the list that appears This command is available only when there is more than one screen of pictures When you finish use the Exit F7 command to return to the File Maintenance menu OSAS Web B2B User s Manual File Maintenance Inventory Item Pictures Append Edit Item Picture Screen The Append Item Picture screen appears when you add a picture to a new item The Edit Item Picture screen appears when you edit an existing picture Other than the title these screens are identical Tixi Commands Edit Modes Other Inventory Lookups Help 2xe re ma g OK Abandon Item ID 108 aj Description Electrical Package Picture electric gif Enter the item ID The item s description appears If you are editin
187. own Tax location not on file SAT 2020 lick Top of Page Non Taxable Taxable Sales Tax Freight Misc _ invoice Total 00 21722 07 00 00 00 21722 07 o return to the top 5 00 f the web page CE 2172 07 lose the browser o end the session r select an option Problems or Questions mail Webmaster buildets supply com rom the top or This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software ide menus from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved zl PT RJ Local intranet P 8 12 OSAS Web B2B User s Manual Item Inquiry The Item Inquiry web page lists the inventory item groups to which this customer has access The groups provide a convenient way to organize items for viewing Use the Customer Groups function page 3 17 on the File Maintenance menu in OSAS to change the item groups that this customer can view Use the Internet Inventory Item Groups function page 3 9 on the File Maintenance menu in OSAS to change the items and subgroups in an item group Use the Customer Internet Access Codes function page 3 13 on the File Maintenance menu in OSAS to choose whether to view quantities and price breaks on this web page Screen Use Screen Description Item Group Codes Use this screen to select the items you want to list Item Inquiry This screen lists the items and subgroups in the group you select The items appear in groups of 10
188. owsers so care must be taken when using them dat all contains the data to be converted to table cells This must be a 2 dimensional array with columns as the first dimension and rows as the second If row 0 exists it is used for column headings column 0 is similarly used for row headings All other data is used as regular cells work is returned as the HTML table definition OSAS Web B2B User s Manual F 107 Toolkit Program Functional Listing Basic Web Utility Guide uttags wbb F 108 Appends text with specified HTML markup tags to a HTML Syntax CALL uttags wbb tags text html This high level routine is used to add HTML markup tags to text When there are no structure conflicts multiple tags can be added with a single CALL by separating the tags with commas In all cases tags are applied to text and the result is appended to html along with a CR LF sequence If there are no tags text is appended to html along with a CR LF sequence to aid readability tags is a comma separated list of tags some of which may contain options In many cases a tag causes both a pre and a post tag to be added to text because there are many HTML tags with both opening and closing parts The tags supported are b adds lt b gt and lt b gt body options adds lt body options gt and lt body gt br appends lt br gt center adds lt center gt and lt center gt Comment adds lt and gt form action ad
189. payment information Use the commands at the bottom of the screen to switch between or change customers view totals or select the line item to view Use the Exit F7 command to return to the function screen from which you accessed the History command OSAS Web B2B User s Manual Introduction Information Menu Documents The Documents command lets you view or open documents attached to certain master file records You cannot use this command to attach a document to a record instead use the appropriate File Maintenance function to attach documents Before you can open documents you need to have the appropriate file associations set up in the File Types function on the Resource Manager Workstation Configuration menu The entries you make in this function help OSAS identify which software applications to use to open attached documents See the Resource Manager User s Manual for more information The Documents screen appears after you access the Documents command The Employee Documents screen is shown below as an example amp Employee Documents E 2151 xl Commands Edit Modes Other Scroll Commands Help xt 85 amp imu e OK Abanden 2 Boure Linda C Employee ID BouU001 Document Name ID doc Lo bb o Lia Jada a Line No 001 of 003 Header First Last Next Prev View Open Document Goto Company H 10 08 2002 Terminal TODO
190. pts of string templates and global variables or STBLO values Basic Web Utility Contents F 4 Toolkit Contents e UNIX shell scripts for launching Business Basic programs as CGI scripts Both on demand and shared directory models are supported Visual PRO 5 version of Business Basic Windows executables for launching either standard console based CGI or WIN CGI applications e Business Basic programs ut wbb designed to simplify Business Basic CGI programs Most of these programs are CALLed e Business Basic programs rs wbb to perform simple data transfer over a dedicated serial line facilitating safe data access to live data from a nearby web server e Business Basic programs rs wbb to perform simple data transfer over a dedicated serial line facilitating safe data access to live data from a nearby web server OSAS Web B2B User s Manual Basic Web Utility The Basic Web Utility and CGI Installing and Configuring the Basic Web Utility UNIX The Basic Web Utility works with PRO 5 on any version of UNIX and with any web server that supports standard CGI All web servers support standard CGI including NCSA Cern Apache and Netscape To install the Basic Web Utility copy bwu sh to a CGI directory or a name recognized as a CGI script cgi Then edit the script to start both PRO 5 and the program to run Parameter Description PGM The program to run when PRO 5 starts MEM An optional parameter defining the
191. r E mail for selected reports See the following instructions for details If you are using graphical screens the Output Information dialog box appears after you select the range of information to print in the report Output Information E xj Windows Default Printer Laser PDL Print Dialog Laser Printer PSL Print Setup Laser LPD Windows Default Printer Dot Matrix PDD Print Dialog Dot Matrix Loyer ET C Pint Preview PSD Print Setup Dot Matrix ao LPW Windows Default Printer Wide Carriage C Eile PDW Print Dialog Wide Carriage Dot Matrix Compressed PSW Print Setup Wide Carriage Dot Matrix File Name C OSAS65 data Browse OK Cancel If you are using text screens these options appear at the bottom of the screen after you select what to print in the report and how it is organized Output device P rinter p Rjeview F ile S creen Bj na 1 62 OSAS Web B2B User s Manual Introduction Reports Print the Report 1 2 6 Select Printer in graphical screens or enter P in text screens If multiple printers are available for the terminal either select the printer from the list or enter the appropriate code for the printer and press Enter Use the Devices function on the Resource Manager Workstation Configuration menu to add printers to the terminal When available either select Standard or enter S if you want to print the report in standard width or select Compressed or enter C
192. r graphical modes for the OSAS functions In addition if you are using Windows you can use either text or graphical function screens independently of the main menu For example you can use text function screens even if you are using the graphical main menu and vice versa Select GUI Functions from the Modes menu or press Shift F6 to toggle between the text and graphical modes for function screens 1 14 OSAS Web B2B User s Manual Introduction Conventions Access Codes Your company can limit use of the system by defining access codes and assigning them to employees Each code allows access to specific applications menus and functions If you cannot select a menu your access code is not authorized for it Use the Access Codes function on the Resource Manager Company Setup menu to set up access codes If you have more than one access code select Access code from the File menu or press F4 The Access Code box appears the example below uses the graphical mode Enter the access code you want to change to then click OK or press Enter Workstation Dates To change the workstation date select Workstation date from the File menu or press F6 The Workstation Date box appears the example below uses the graphical mode La set Workstation Date E OK Peel LUS 3 System Date Abandon Exit Use the buttons or your keyboard to enter the date and click OK or press Enter to change the workstation date Click System Date
193. rams store it in a file rather than a URL and hidden field Instead of many individual fields assign and track only a session ID Keep date and time stamps on session records and periodically clear out old ones If the application supports cookies use the automatic session tracking support built into Basic Web Utility 1 1 HTML can be generated in programs however for complex documents it is often easier to create HTML files There are a number of HTML editing programs available that function as word processors The tags needed by uthtmout wbb and utfrmout wbb can be embedded in the file and the file referred to by a single include phrase in any uthtm or utfrm program text include filename txt call uthtmout wbb tpl text html OSAS Web B2B User s Manual F 37 Standard Structure Options In most web sites it is important to maintain a consistent appearance on all pages including those generated by CGI This can include a consistent background color tiled image or a standard header and footer on each page The Basic Web Utility looks for the the following case sensitive global strings title A required global string that acts as a trigger All the other global strings are optional If the string does not exist the standard structure is not invoked If it does exist the following tags are added on the first call to utsend wbb lt html gt lt head gt lt title gt title lt title gt otherhead
194. rate HTML List from a BBx or PRO 5 Select Verb Create Select Where Clause from CGI Input Fields Syntax call uthtmfil wbb chan first last keynum maxrec count curkey tpl text work linkexpr call uthtmkey wbb chan keys keylen tpl text work linkexpr call uthtmsel wbb fl where sortby opt maxrec skip count tpl text work linkexpr call utselect wbb cgi tpl where andor Form and HTML Creation and Capture Tools Program Utfrmgen wbb Utfrmgn2 wbb Utfrmin wbb Uthtmgen wbb Description Generate Form Input Tags from a Template and an Optional List of Fields and Parameters Generate a Complete HTML Form from a Template Copy CGI Input to a Data Template Generate HTML Tags and Text from a Template Syntax call utfrmgen wbb tpl flds captions flags captags work call utfrmgn2 wbb tpl flds captions flags captags actionval submitval resetval placement work call utfrmin wbb cgi tpl call uthtmgen wbb tpl flds captions flags captags linkexprs work OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing Other CGI Tools Program Utencode wbb Utentity wbb Utmeta wbb Utmore wbb Utses wbb Utsub wbb Uttable wbb Uttags wbb Description URL Encode and Decode a Text Value Convert HTML Markup Entities to Browser Displayable Format Scans Text For Special
195. rates in a Win CGI environment it may create work files to store large CGI input values Before exiting these work files should be erased This routine examines the CGI string template produced by utcgi wbb and erases any files It should be CALLed before exiting the Business Basic environment in any Win CGI installation OSAS Web B2B User s Manual F 75 Toolkit Program Functional Listing Basic Web Utility Guide utfrmgen wbb F 76 Generate form input tags from a template and an optional list of fields and parameters Syntax CALL utfrmgen wbb tpl flds captions flags captags work This high level program generates the input tags for an HTML form or part of a form based on a template and other information It program is also capable of creating the form as loose text preformatted and aligned text or as a bordered or borderless table tpl is a data tempate that contains both the fields and data to generate the form input fields A variety of user attributes can be defined in the template to control how field data is handled See the Data Templates information for an explanation of these attributes flds is a text string that contains a comma delimited list of field names and optional format options If flds is null then a default list is generated from all the fields in tpl flds can refer to individual array elements name n or to all array elements name in which case the form is generated with all defined arr
196. rent computer If you choose to use a different computer for a web server you must be able to communicate between your OSAS system and the web server through a network or modem connection The web server and OSAS must be able to communicate because OSAS Web B2B provides several functions that move data files and programs from OSAS to the web server and back again If you run your web server on a different system than OSAS and the two systems cannot communicate directly you will need to move these files and programs manually using software designed for that purpose such as FTP File Transfer Protocol software For details about the HTML screens used with OSAS Web B2B see chapter 8 OSAS Web B2B Functions in OSAS The OSAS side of OSAS Web B2B includes several functions that you use to set up and maintain the web server side including e creating your login page e determining which inventory items are accessible e granting access to your customers by assigning them passwords e moving information between your OSAS system and the web server 1 8 OSAS Web B2B User s Manual Introduction The OSAS Web B2B System Local and Remote Processing Remote Processing Web Server with Firewall Protection Local Processing Web Server and OSAS You can control how the data on your system is accessed when you set up OSAS Web B2B Y
197. require an entry in certain application functions select the option If verification is turned on you must press PgDn twice to proceed to the next screen or to save your entries Other Commands Menu Commands Edit Modes Other Help 3x ra a Calculator Execute an Operating System Command Call a PRO 5 Program Product Suggestions Application Options Inquiry Global Inquiry General Information Inquiry Support Information User Comments EIS Dashboard Display EIS Dashboard History Pop Up Calendar Inventory Price Calculator See Other Commands Menu on page 1 26 for information on this menu s commands Help Menu Commands Edit Modes Other Information Help RX Be MH 2 amp About OSAS Command About OSAS Command Help Command Help Help lt Fl gt Online Doc lt Shft F1 gt Description Opens the About OSAS dialog box Opens the OSAS Key Help screen OSAS Web B2B User s Manual Introduction OSAS Graphical Functions Command Description Help Lists information about the field on which you are working Online Doc Launches your PDF file viewer and opens the documentation for the appropriate OSAS application Information Menu Commands Edit Modes Other Scroll Commands Information Help 2X tz I eR a 26 Vendor Information Vendor Comments Vendor Documents Item Information Ttem Documents The Information menu appears on some function screens
198. riables Based on the Operating System Environment and CGI Input Stream OSAS Web B2B User s Manual Syntax call rsread wbb filename mode ky knum rec errmsg call rsreadm wbb filename key1 key2 knum ky all rec all count errmsg rswatch sh d tty device s stty parameters v call utaddr wbb call utcdate wbb strdate juldate call utcdtf wbb tojul format text juldate call utcgi wbb env cgi errmsg F 53 Toolkit Program Reference Overview Basic Web Utility Guide Program Utcgiwin wbb Utcnum wbb Utcprop wbb Utcstr wbb Utencode wbb Utentity wbb Utenv wbb Uterr wbb Utexit wbb Utfrmgen wbb Utfrmgn2 wbb Utfrmin wbb Description Win CGI Support Convert Formatted Numeric Text String to a Number Convert a Text String to Proper Case Unmask a String Based on a Mask and Return an Internal Value URL Encode and Decode a Text Value Convert HTML Markup Entities to Browser Displayable Format Get Environment Variable Generic Error Display Routine Clean Up Basic Web Utility Work Files in the Win CGI Environment Generate Form Input Tags from a Template and an Optional List of Fields and Parameters Generate a Complete HTML Form from a Template Copy CGI Input to a Data Template Syntax Used internally by the Basic Web Utility when the Win CGI environment is detected and should never be CALLed directly call utenum wbb text v
199. ring STBL on PRO 5 is created for each environment variable as well The cgi template holds the values of any input values set by the CGI input stream These are sent to the CGI application in two ways The first is through the URL where name value pairs are present following a character in the URL For example this URL would set four values in the cgi string template http abc com cgi bin runapp state CA amp type A B amp zip amp name A 9626P Market The following identifies the cgi string template cgi state CA cgi type A B cgi zip cgi name A amp P Market The second method is through an HTML form post where input form values are passed to the CGI input stream on the stdin file handle though the Win CGI specification passes values through a file OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing In both methods the data sent into the CGI application is URL encoded all nonprintable and some special characters are converted to hex notation and spaces are replaced with characters utcgi wbb decodes these values before placing them in the cgi template In the Win CGI environment large values are stored in temporary disk files If any cgi variable value begins with a FF the balance of the value contains a disk file name to store the value sent by the browser This also makes it important to CALL utexit wbb before exiting the Business Basic environment
200. rnet Explorer and you must have a basic understanding of HTML and how browsers display HTML documents There are scores of good books about HTML as well as many sources of information on the Internet as well You must be familiar with Business Basic and in particular the relatively new concepts of string templates and global variables or STBL values new that is relative to the age of the Business Basic language Configuration Requirements and Samples after Installation To use Basic Web Utility ensure the following are installed e A web server such as Microsoft Personal Web Server PWS or IIS Internet Information Server F 8 OSAS Web B2B User s Manual Basic Web Utility The Basic Web Utility and CGI Visual PRO 5 revision 2 x e The utility set BASIC WEB UTILITY Configuration Visual PRO 5 Configuration The config bbx file can be modified to contain only minimal information to get Basic Web Utility to work For example assuming that Web Server Basic Web Utility and Visual PRO S reside in different subdirectories on D create a WebConfg bbx file ALIASES 100 FCBS 128 CIBS 128 STBLEN 4096 SETOPTS 00000060000000 PREFIX D BBW D BBW progs D BBW temp alias TO syswindow DSKSYN A DSKSYN B DSKSYN C DSKSYN E DSKSYN Z In the stdcgi bat file that was copied to D wwwrooti cgi bin make the following changes set BBPROG Webtest bbx set BBEXEC d basis vpro5 vpro5 exe set BBCONFIG d
201. rogram presented in the Customer Inquiry application These programs do not use HTML templates Source code and comments for each of the sample applications are presented on the following pages CGI Startup Shell Script The shell script bwu sh is copied to a cgi directory and named demobbw sh Most servers contain a standard cgi bin directory in the directory mapping structure defined in the server configuration files bin sh Copyright C 1996 by Allen Miglore All rights reserved bwu sh is a standard shell script that can be used to start a BBx Pro5 task in a UNIX environment This script can be copied to the cgi directory given whatever name you need or it can be used as is by other scripts that would set PGM and optionally OSAS Web B2B User s Manual F 21 Sample Program Reference Basic Web Utility Guide F 22 MEM before exec ing this script Set PGM and MEM to desired values for the bbx program and start size these can be set in another script that execs this one The PGM environment variable must be set to the name of the Business Basic program in this case demobbw bbx If the program requires more or less than 512 pages the MEM variable can also be set The values for ERRORLOG CONFIG AND BBXEXEC must also be modified to match the configuration The file name ERRORLOG stores messages related to problems starting Business Basic CONFIG points to the PRO 5 configuration file used
202. rs you enter push other characters in the field to the right If there is no Ins flag the characters you enter overwrite other characters in the field PgUp Moves back to the first field on the screen or the first field after the key field without erasing any entries PgDn Approves the data on the screen updates the data file accordingly and proceeds to the next field or section Tab Moves the cursor to the next block or field that requires an entry Up Down Moves the cursor up or down through the fields arrow F1 Help Esc H Opens the help description for the current field OSAS Web B2B User s Manual 1 33 OSAS Text Functions Introduction 1 34 Command Key F2 Inquiry F3 Delete F4 Others F5 Abandon F6 Maint F7 Exit F8 Print Screen F9 Undo Typing F10 Delete Shift F2 Info Menu Alternate PANT Description Key Esc W Opens the Inquiry screen for the current field This command is available for a field when the Inquiry flag appears at the bottom of the screen See Inquiry Commands on page 1 48 for more information Esc D Deletes the current record or line item when allowed Esc O Opens a utility menu similar to the Other Commands menu on graphical screens See Other Commands Menu on page 1 26 for more information on the commands available Esc X Abandon processing or clear all fields Esc F Opens the appropriate File Maintenance function where you can vi
203. s OSAS OPEN SYSTEMS Accounting Software ra 4 Yvvvvvvvvvvv OPEN SYSTEMS Accounting Software You can exit from a menu in these ways Press the left arrow key to go to the previous menu one menu up e Hold the mouse over a different menu choice Press the Tab key to go to the OSAS menu e Click the Close box in the upper right corner of the window to close OSAS e Use Exit F7 to close OSAS e Select Exit from the File menu to close OSAS OSAS Web B2B User s Manual 1 23 OSAS Graphical Menu Introduction Main Menu Elements 1 24 Pull Down Menus When using the graphical menus you can use the pull down menus and toolbar buttons to access functions without using the function keys While the function keys work in graphical menus the menu bar and toolbar buttons give you a choice in accessing these functions The OSAS pull down menu bar is shown below TOOO OPEN SYSTEMS Accounting Software File Modes Tools Favorites Other Help To access the menu s commands click one of the menu titles The menu for that heading appears and lists available commands followed by any hot key combinations in brackets To use a command either click the command name or press the hot key s listed File Menu File Modes Tools Favorites Other Help Access code lt F4 gt ES O Sample dataset lt FS5 gt Workstation date lt F6 gt Exit F7 Command Descrip
204. s To abandon your entire order and empty your shopping cart click Cancel Order The Order Entry Group Codes page appears If you are a tax exempt customer but you must pay tax on this order click Change Order to Taxable to calculate the sales tax for the order When you are satisfied with your order click Check Out The Shipping Information page appears If you close your browser or leave the Order Entry web pages your shopping cart remains intact for 24 hours When you return to the site within the allotted time period you can resume your order entry from where you left off OSAS Web B2B User s Manual The Web Interface Order Entry Select Shipping Address HTML Screen d l x File Edit View Favorites Tools Help ar Q rex T x 2 A J2 Search 57 Favorites A media amp A E a 2o mmen p EP mE INC Links gt Information Inventory Orders Order Inquiry Bill To ETA Aceoo1 Order Entry CEMA ACE BUILDERS Item Lookup 1588 SE 318T STREET View Shopping Cart Login Page PADUCAH KY 28655 7865 us Ship To LAURA JOHNSON 1588 SE 318T STREET PADUCAH KY 28655 7865 US y Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software tom Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved zi a ll Local intranet p T
205. s Use the Exit F7 command to return to the function screen from which you accessed the Documents command when you finish viewing documents 1 60 OSAS Web B2B User s Manual Reports Selecting a Range of Information Sorting To produce a report you must specify the amount of information you want in the report e To produce a report that includes all the available information leave the From Thru fields on the report screen blank For example if you want information about all the vendors to be in a report leave the Vendor ID From and Thru fields blank e To limit the amount of information in the report enter the range of information in the From Thru fields For example if you want a report to include information only about vendor ACE001 enter ACEO01 at both From and Thru If you want the report to include information only about vendors that start with CO enter CO at From and COZZZZ at Thru Each field where you enter information on a report screen usually restricts the overall output of the report For example if you leave the Vendor ID From and Thru fields blank the report contains information about all the vendors But if you enter invoice 100 in the Invoice Number From and Thru fields and invoice 100 is assigned only to vendor ACEO01 the report includes information only about vendor ACEOO01 Information for reports is sorted first by a space _ then by special characters then by digits then by uppercase letters
206. s List shows the tables that are on your system for the range of IDs you select Tables List 11 06 2002 Builders 11 57 AM Tables OSAS Web B2B Table ID COPYPATH Description Web Path Table No of Columns l Column Length 60 Type c inetpub wwwroot osasweb c osas65 data c osas65 progRM Table ID EMAIL Description E Mail Address in case of problems No of Columns 1 Column Length 50 Type A Email Address Webmaster builders supply com OSAS Web B2B User s Manual 7 17 The Web Interface OSAS Web Login Page Account Information Aged Trial Balance History Inquiry Invoice Inquiry Item Inquiry Order Inquiry Order Entry OSAS Web B2B User s Manual 8 3 8 5 8 7 8 9 8 11 8 13 8 19 8 21 8 1 OSAS Web Login Page The OSAS web login page is the first of the web pages presented to Internet users Your customers use this page to enter their customer ID and password and to choose the company for which to view information or enter orders The login page is created by the Create Login Page function on the Set Up Web Components menu See Chapter 4 for more information about this function OSAS Web Login Page HTML Screen OSAS Web Microso plore zax File Edit View Favorites Tools Help ay o Back y o x 2 JO Search Se Favorites A Media e ha ee A gt 3 o a AA ee i SYSTEMS INC Builders Supply Login Customer ID ACE001 Password sa Company
207. s complete a CALL to utexit wbb completes the task Below is an example that builds a list from a small file call utcgi wbb env cgi errmsg call uttags wbb h1 Data File Listing html dim tpl id c 5 name c 30 line lt li gt id name chan unt open chan data fil call uthtmfil wbb chan 0 0 0 tpl line work call uttags wbb ul work html call utsend wbb html call utexit wbb cgi release This example was created with the following steps 1 The CGI input is read 2 A HTML heading is placed into the variable html 3 A template is defined for reading data from data fil 4 A line structure is specified to be used for each record from the file OSAS Web B2B User s Manual Basic Web Utility The Basic Web Utility and CGI 5 The file is opened 6 Alist of all records using the specified line structure for each is placed in work 7 The unordered list tags are added to work and the result is added to html 8 html which now contains a HTML document is sent back to the user 9 The task is formatted and released Shared Directory Method A second method uses a shared directory with a script or other executable started by the web server generating files that contain requests and one or more Business Basic tasks running in the background monitoring the same directory and producing results in associated files This method is less efficient that the
208. s dynamically from database information available on the host system The Basic Web Utility provides an easy to use interface between the CGI API and Business Basic programs enabling quick development of web based applications that read and write legacy data stored in Business Basic data files There are a large number of uses for this technology both for internal networks and for businesses that share data with other businesses For example a web based product catalog that comes directly from a live inventory file with up to the second product availability information and always current pricing information The Basic Web Utility is a set of CALLable Business Basic programs and platform specific scripts or programs that interface Business Basic programs using the Basic Web Utility to various web server platforms OSAS Web B2B User s Manual F 3 The Basic Web Utility and CGI Basic Web Utility Guide Before You Begin Before using the Basic Web Utility a web server must be installed and operating on the same system where Business Basic is operating The web server must also be configured with a method of invoking CGI scripts this is the default configuration An understanding of the naming conventions and directory locations for CGI is essential Developers should be familiar with e Web browsers such as Netscape Navigator or Microsoft Internet Explorer e HTML and how browsers display HTML documents e Business Basic conce
209. scribed below skip steps 2 and 4 if you do not use remote processing 1 Print the Transaction Journal to list the orders that have been entered along with any comments from the customers 2 If you use remote processing run the Build Sales Orders from Remote Files function to transfer your customers orders from the remote data files to your live OSAS data files 3 Use the Purge Log File function to prepare the log file for the next day s entries 4 If you use remote processing run the Copy Data Files to Web Server function on the Remote Access menu OSAS Web B2B User s Manual 5 3 Sales Order Processing on the Web Sales Order Processing Order Numbers By default OSAS Web B2B uses the numbers set up in Sales Order to number sales orders entered through the web When a customer enters an order through the web the system determines the next available order number and enters the order as a price quote with that order number If you use remote processing the system scans for available numbers a second time when you build sales orders from remote files in order to prevent overwriting quotes entered internally through Sales Order Any changed order numbers print on a log after web orders are copied to your live system You may prefer to set up order numbers to easily distinguish between orders entered internally and those entered through the web Using the Company Information function on the Resource Manager Company Setup m
210. ser s Manual Stores the result of uthtmfil wbb uthtmkey wbb and uthtmsel wbb Use this to merge the results into HTML documents as list Can be defined on a UNIX system with the mail command to notify an administrator of an error reported by uterr wbb It should be set to an email address reachable by the web server It should not be set on anon UNIX system If the utmmoout wbb program tries to retain leading spaces set this global string to y to have the Basic Web Utility add lt spacer size cols gt to the text Browsers that support the lt spacer gt tag then render the indents As with the memospacer this attempts to retain leading spaces on lines but uses a lt table gt structure with lt td colspan cols gt tag to control the spacing Set this global string to y to trigger this behavior Stores a URL suitable for continuation of a list generated by uthtmfil wbb uthtmkey wbb or uthtmsel wbb All values sent in CGI are retained Suitable for use in HTML text as a href moreurl gt More records amp ldots lt a gt Used in standard structure options added before the lt body gt tag Use this tag to add lt meta gt tags or other tags that go between the lt head gt and lt head gt tags except lt title gt An internally maintained value used by utsend wbb An internally maintained value used by utwatch wbb F 49 Global String Reference Basic Web Utility Guide Global String STBL Usage
211. ser s Manual 8 5 Aged Trial Balance The Aged Trial Balance web page on the Information menu lists the balance and aged invoices for the customer s account from the OSAS ARINx file Aged Trial Balance HTML Screen E OSAS Customer Aged Trial Balance Microsoft Internet Explorer File Edit View Favorites Tools Help Q ea y Z x 2 L Search e Favorites a A Tree Information Inventory Orders Ed Account Information Customer iD _ ACEO Aged Trial Balance CustomerName ACE BUILDERS LETE A CLG 505 555 1646 History Inquiry Invoice 31 91 12670046 09 05 2000 Released Invoice 74 619 56 00 00 00 00 74 519 56 00 Login Page 12670064 11 24 2000 Released Invoice 35 467 99 00 00 00 00 35 467 99 00 12670074 12 21 2000 Released Invoice 21 722 07 3 00 00 00 00 21 722 07 00 24889030 12 09 2000 Released Invoice 4 928 82 00 00 00 00 4 928 82 00 Top of Page Problems or Questions E mail Webmaster builders supply com This screen was produced through OSAS Web B2B and OPEN SYSTEMS Accounting Software from Open Systems Inc Copyright 1998 2001 Open Systems Holdings Corp All rights reserved ERE ay Local intranet Click Top of Page to return to the top of the web page When you finish reviewing the information close the browser to end your session or choose a different menu selection from the side or top menus OSAS Web B2B User s Manual 8 7
212. sic Web Utility Guide Debugging Programs during Development The most common method of debugging a program is to single step through it Additional information on the single step verb can be found in the Commands Manual under Single Step Always set Byte 1 Bit 08 of the options vector before beginning or errors may occur in public or called programs This also enables console mode and debugging in public programs An alternate method of debugging an application is to have the program create dummy files before each step of the program This method makes it possible to know exactly which utility failed Using the example from the Configuration section above a line was added to create a string file before each call to a Basic Web Utility program to help determine exactly which call failed 0005 STRING d bwu progs bwustarted ERR 0050 0010 CALL utcgi wbb ENV CGI ERRMSG 0015 STRING d bwu progs bwu15 ERR 0050 0020 CALL uttags wbb h1 My First Web Test Program HTMLS 0025 STRING d bwu progs bwu25 ERR 0050 0030 CALL utsend wbb HTML 0035 STRING d bwu progs bwu35 ERR 0050 0040 CALL utexit wbb CGIS 0045 STRING d bwu progs bwuworked ERR 0050 0050 RELEASE CGI Basic Web Utility Applications CGI Application A web server receives a request for a document that is through naming conventions or directory mapping an executable program The web server establishes an environment and starts the pro
213. sing menu You must set up the osasweb directory on the server first When you used the Install Web Server Components you did not enter the Web Server Programs Path This path needs to be set up before you can use this function You must set up internet companies before setting up customer groups The company for which you are trying to set up customer groups does not have Internet access Set up Internet access for the company before using this function You must set up group codes before setting up customer groups The company you are trying to set up customer groups for does not have item group codes set up Setup item group codes for the company before using this function You must have Accounts Receivable installed to set up customer groups The OSAS Accounts Receivable application must be installed to use this function OSAS Web B2B User s Manual A 5 System Messages You must have Sales Order installed to view the transaction journal The OSAS Sales Order application must be installed to use this function You must have Accounts Receivable installed to set up this Company The OSAS Accounts Receivable application must be installed to use this function You must have Sales Order installed to use purge log file The OSAS Sales Order application must be installed to use this function You must set up the BBx directory to the server first You did not specify the Web Server Programs Path using the Install Web Server Compo
214. sing uses a different set of Sales Order files the order numbers may change when you copy the orders to the live system This function reprints the Transaction Journal after the copy to show the new order numbers assigned during the copy process A sample of the Build Sales Orders from Remote Files Log is on page 5 9 OSAS Web B2B User s Manual 5 7 Build Sales Orders from Remote Files Sales Order Processing Build Sales Orders from Remote Files Screen 5 8 Build Sales Orders from Remote Files P loj xl Commands Edit Modes Other Help xt 5amu e OK Abandon Web Server Programs Path c inetpub wwwroot osasweb Remote Data Files Path c osas65 data Destination Batch ID 000001 aj Company H 11 06 2000 Terminal T000 INS The web server programs path you specified in the Install Web Server Components function appears Press Enter to accept the path shown or enter a different path The remote data files path you used in the Install Web Server Components function appears Press Enter to accept the path shown or enter a different path Enter the batch ID you want to use for the quotes that are created during the copy process Select the output device to produce the log See Output the Report on page 1 62 for more information on output devices After the orders have been copied and the log prints the Sales Order Processing menu appears OSAS Web B2B User s Manual Sales Order Pr
215. st or O if not Not all web servers return a domain name and those that can are often configured not to However most servers provide the client IP address OSAS Web B2B User s Manual F 97 Toolkit Program Functional Listing Basic Web Utility Guide utmeta wbb Scans text for special substitutions Syntax CALL utmeta wbb tpl text This program is CALLed by the uthtmout wbb and utfrmout wbb programs and can also be called directly The purpose of this program is to allow easy file inclusion in text strings and to provide some conditional control over the content of HTML text without resorting to in line Business Basic coding The data template tpl is used when evaluating conditional suppression See the Data Templates section for more information The text string text contains the meta commands and also returns the result after substitutions are performed include filename loads the text file filename into text This method creates HTML template files and incorporates them in an application filename must be accessible to Business Basic if datafield opr value end evaluates the expression datafield opr value and if it fails suppresses any text between the if and end tags If the expression is valid the tags are removed but the text between them is retained datafield can be either a field in the data template or a global string variable name The operator opr can be gt gt lt lt gt
216. stomer Groups function to e Add customer access to an item group e Change the customers that have access to an item group e Remove customer access from an item group You can work with customers and item groups in two ways You can either e Specify a group and enter the customers that have access to it e Specify a customer and enter the groups the customer can access Customer Groups Item Group Screen MEE Commands Edit Modes Other Scroll Commands Help xts 5 amp lmun e OK Abandon Group Code INTERIOR 2 Interior Materials Paint Wallpaper Supplies CustomerID 13 Customer ID Customer Name ACE BUILDERS zj CASH SALES OAKLAND CA a CASH SALES BALTIMORE MD aj CASH SALES MINNEAPOLIS CASH SALES DALLAS TX CASH SALES DALLAS TX DALLAS FT WORTH DOME HOMES GREATER NEW YORK DOMES INC KANSAS CITY GEODESIC HOMES LOS ANGELES CONSTRUCTION CO SUNSHINE HOMES INC TENNESSEE SHELTERS INC y VISA y zj First Next Prev laSt Append all n ne Header Goto Company H 11 05 2002 Terminal T000 OVR Inquiry To list the customers that have access to a specific group code enter the code in Maint the Group Code field The customers with access to that group appear OSAS Web B2B User s Manual 3 17 Customer Groups File Maintenance Customer Groups Customer Screen A Customer groups BEE Commands Edt Modes Other Scroll Comm
217. stomer or item group Press G to go to a specific customer or item group in the list then enter the ID or code This command is available only when there is more than one screen of information OSAS Web B2B User s Manual 3 19 Tables Tables store information and options used by the system Use the Tables function to set up and maintain the OSAS Web B2B EMAIL table The EMAIL table stores the address of the contact person for web problems This address appears on the web pages as the customer s contact if any problems occur while viewing information OSAS Web B2B also uses these tables The HOMEPATH table stores your entries when you use the Create OSAS Web Login Page function e The WEBPATH table stores your entries when you use the Install Web Server Components function e The COPYPATH table stores your entries when you use the Copy Programs to Web Server and Copy Data Files to Web Server functions e The IMGPATH table stores the path to the directory where you store image files for use by the web server The HOMEPATH WEBPATH COPYPATH and IMGPATH tables are automatically created and maintained by the functions described above You should not change these tables using the Tables function Instead change the information in these tables using the functions listed Use the Tables function to maintain only the EMAIL table OSAS Web B2B User s Manual 3 21 Tables File Maintenance Tables Screen Follow th
218. t from to call uttable wbb caption options dat all work call uttags wbb tags text html call uttplbas wbb dict fl control tpl errmsg call uttempfl wbb tempfile tempchan call uttplcp wbb source dest run utwatch wbb OSAS Web B2B User s Manual Toolkit Program Functional Listing CGI Processing Tools Program Description Syntax Utcgi wbb Set Template Variables Based on the call utcgi wbb env cgi errmsg Operating System Environment and CGI Input Stream Utsend wbb Send Text Back to the Client Browser call utsend wbb text Uterr wbb Generic Error Display Routine call uterr wbb errnum linenum progname Utexit wbb Clean Up Basic Web Utility Work call utexit wbb cgi Files in the Win CGI Environment Utwatch wbb Interface with a Shared Directory CGI run utwatch wbb Request Process Data Merging Tools Program Description Syntax Uthtmout wbb Merge HTML Text with Data from a call utfrmout wbb tpl text work Data Template Utfrmout wbb Merge Template Data Into HTML call utfrmout wbb tp1 text work Form Output OSAS Web B2B User s Manual F 57 Toolkit Program Functional Listing Basic Web Utility Guide File Listing Tools Program Uthtmfil wbb Uthtmkey wbb Uthtmsel wbb Utselect wbb Description Generate HTML List from a File Given a Key Range and Format Definition Generate HTML List from a File Given a List of Keys Gene
219. t Menu Command Alternate Key Key Description F1 Help Esc H Opens the help description for the selected application function You must be within an application menu to access this command F2 Esc W Toggles between the Favorites and main menus Favorites F3 Change Esc D Allows you to switch to a different company Company F4 Access Esc O Allows you to enter an access code Code mer Pressing this key or key combination twice opens a utility menu similar to the Other Commands menu on graphical screens See Other Commands Menu on page 1 26 for more information on the commands available F5 Live Esc X Switches between live and sample data Sample Data F6 Esc F Allows you to change the workstation date Workstation Date F7 Exit Esc M Exits from OSAS F8 Print Esc L Allows you to output the current screen to a Screen printer print preview window or file F9 Change Esc U Allows you to change to a different fiscal year Year when you are inside the General Ledger or Payroll menus OSAS Web B2B User s Manual 1 19 OSAS Text Menu Introduction Command Alternate Key Key Description F10 Add to Ctrl Z Pressing this key or key combination on the Delete main menu adds the selected application or Favorites function to your Favorites menu Pressing this key on the Favorites menu removes the selected application or function from the Favorites menu Shift F2 Esc l Opens a screen listing
220. the HTML document demomenu txt is loaded and displayed By using the text include filename and calling utmeta wbb a disk based document can be loaded 0600 REM 100 Run the program specified in pgm or default to the menu 0610 RUN FIELD CGIS pgm ERR 0620 ERR 0620 0620 LET TEXT include demomenu txt 0630 CALL utmeta wbb TEXT 0640 CALL utsend wbb TEXTS 0650 DONE RELEASE 1000 LOADERROR REM 1000 problem with utcgi fatal problem 1010 REM If we are here there was a REAL BIG PROBLEM Without 1020 REM proper initialization the DOS WIN environment has no way 1030 REM of contacting the browser of this so the best thing is 1040 REM just to leave gracefully but silently On UNIX with 1050 REM stdout support a notification of the error can be sent 1060 REM to the browser 1070 IF POS DOS INFO 0 0 gt 0 OR POS WIN INFO 0 0 gt 0 THEN GOTO DONE 1080 PRINT Content type text html 0A 1090 PRINT The following error message was returned by utcgi wbb lt br gt 1100 PRINT ERRMSG 1110 GOTO DONE OSAS Web B2B User s Manual F 25 Sample Program Reference Basic Web Utility Guide Scrolling Customer Listing democlst bbx This program is used by both sample applications and is the lead program in the Customer Inquiry application in which customers are listed Each customer has a link to a detailed invoice page It is also used to select a customer to edit in the Customer Maintenance app
221. the letter key associated with the window sort You can see the available sorts in any Inquiry window by pressing Esc Command Help To shorten your data search use a partial key inquiry to cut down the size of the inquiry list For example if you know that the ID starts with JAR enter JAR in the ID field before you use the Inquiry command The Inquiry list starts with JAR and runs through the end of the list 1 48 OSAS Web B2B User s Manual Introduction Menu and Function Commands The following commands are available inside Inquiry windows The scroll buttons are available in graphical mode only Key Button Home z PgUp g Up aj Down y PgDn y End E Ins Look Up F7 Exit Enter Esc View Commands OSAS Web B2B User s Manual Description Moves directly to the first item on file Displays the previous page of the window Moves up one item Moves down one item Displays the next page of the window Moves directly to the last item on file Toggles between Search mode and Sort mode Leaves the Inquiry window without selecting anything Selects the item to which the cursor is pointing Opens a window that shows Inquiry window commands and the Window ID The Esc key is available in text mode only In graphical mode select Command Help from the Help menu to view a list of commands available 1 49 Menu and Function Commands Introduction Inventory Lookup 1 50 If you use the
222. the list box OSAS Web B2B User s Manual 1 29 OSAS Text Functions Like the text menu OSAS text function screens can be used on all operating systems On Windows workstations text function screens can also be used with graphical menus or vice versa the text menu can be used with graphical function screens Function screens provide you an interface to the data in your data files allowing you to view update and change information as needed Function screens also allow you to print reports or perform tasks on your data such as calculations purges or the resetting of accumulated totals oxi Settings Edit Print Help MINNEAPOLIS WAREH You can move around the screen in these ways e Press the down arrow or Enter to move from field to field e Select the appropriate command on the command bar OSAS Web B2B User s Manual 1 31 OSAS Text Functions Introduction Use commands to access information screens or to toggle commands on and off See Commands and Flags on page 1 32 for more information e Ifa screen contains more than one section press PgDn when prompted to move to the next section e Ifa menu appears prompting you for the kind of information to enter or maintain such as on Transaction or File Maintenance screens select the appropriate option and press Enter e Press F7 to exit the screen and return to the main menu Text Function Screen Elements Command Line The command line app
223. the meta instruction is retained in the text OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing Note that datafield should not be enclosed by brackets and there must be at least one space between datafield and opr and opr and value Field tags Field tags are placed in text in the format dataname type options type is optional and if not specified defaults to text If dataname is not found in the data template tpl and a global string variable is found by that name it is used as simple text output rather than input type can be any of the following words text hidden password radio checkbox memo list mlist show image or encode These are inserted as form input fields in the following formats text boxes hidden fields password input boxes radio button group checkbox group textarea entry listbox multi selection list box display only image tags and URL encoded display only respectively URL encoded display only format is useful if the insertion is being placed in the middle of a URL link The show type provides display only fields in the form Radio checkbox and list boxes produce groups of selections based on the on keys vals and sep options Note this regarding image types unlike uthtmout wbb this program does not look for the image y user attribute Therefore by default a form displays the field as a text entry box for maintenance of the data c
224. thruzy OSAS Web B2B User s Manual Force text case on input and output This caption is used by default when generating forms or HTML documents using the utfrmgen wbb and uthtmgen wbb programs Captions may not contain spaces because of the way user attributes are accessed Therefore the Basic Web Utility converts underscores to spaces Customer Name becomes Customer Name Use the STR data format for output and utcstr wbb option to map input for text values such as Zip codes or phone numbers where there is formatted external presentation but unformatted internal storage If set to y then output data is NOT scanned for correction of HTML entity markup characters allowing HTML formatted text to be included in the data F 17 Data Templates Basic Web Utility Guide Text Fields image y Tf set to y then output is formatted as a HTML lt img src data tag keys item list The uthtmgen wbb and utfrmgen wbb programs can format check lists radio buttons and selection lists the formtype from keys vals and sep values These can be placed in the field tags parsed by these programs or can be set to the defaults in the data template item list is a list of items keys with no spaces use underscores for spaces delimited by the sepchar value or a semicolon if no sepchar is specified vals desc list desc list is a list of descriptions associated with the keys in item list The descriptions cannot contain spaces
225. tion Access Code Opens the Access Code dialog box See Access Codes on page 1 15 for more information Sample data set Live Toggles between Sample and Live data data set Workstation date Opens the Workstation Date dialog box See Workstation Dates on page 1 15 for more information Exit Exits OSAS OSAS Web B2B User s Manual Introduction OSAS Graphical Menu Modes Menu File Modes Tools Favorites Other Help Ex w GUI Functions lt Shift F6 gt Scale GUI Screens lt Shift F7 gt Command Description GUI Functions Toggles between graphical and text function screens Scale GUI Screens Toggles scaling of graphical screens on and off When selected this command enlarges graphical screens When off the command restores the OSAS screens to their original size This command does not take effect until you access a function Tools Menu File Modes Tools Favorites Other Help rs B s Calculator j 5 o Command Description Calculator Opens the OSAS calculator Favorites Menu Fie Modes Tools Favorites Other Help rs B s Change to Favorites lt F2 gt Command Description Change to Favorites Toggles between the Favorites and main menus See Favorites Menu on page 1 53 for more information OSAS Web B2B User s Manual 1 25 OSAS Graphical Menu Introduction Other Commands Menu File Modes Tools Favorites Other Help 8 on 2 m Calculator Execute an Operating System Command Call a PRO 5 Progra
226. tion that is used to calculate prices for this customer Use the Item Group Codes function page 3 3 to set up item groups for item inquiry and sales order entry web functions Use the Internet Inventory Item Groups function page 3 9 to add items or item subgroups to the groups you set up Use the Inventory Item Pictures function page 3 5 to associate graphic images with inventory items for display in the item inquiry and sales order entry web functions OSAS Web B2B User s Manual Installation and Setup Installing OSAS Web B2B 7 Use the Customer Groups function page 3 17 to set up the item groups to which each customer has access during the item inquiry and sales order entry web functions 8 Use the Tables function page 3 21 to set up the EMAIL table which stores the E mail address your customers use to contact you if they encounter problems using the web functions 9 Usethe Create Login Page function on page 4 3 to build your login page and to copy it to your web server directory 10 Use the Install Web Server Components function on page 4 5 to set up the communication between the web server and OSAS and to copy the OSAS Web B2B programs and drivers to the web server You may need to edit the CONFIG BBX file created on the web server after completing the Install Web Server Components function Consult Appendix D for more information on modifying the CONFIG BBX file Follow these additional steps if
227. to DONE NT rem Win NT Website uses stdout IF REQUEST_METHOD POST goto WINNTCONTENT BBEXEC m MEM BBPROG goto DONE WINNTCONTENT BBEXEC m MEM BBPROG lt CONTENT_FILE DONE UNIX changes All of the UNIX script files in OSAS Web B2B are similar The MENU EXE file is shown here You can make similar changes to the others script files OWMENU EXE Set PGM and MEM to desired values for the bbx program and start size these can be set in another script that execs this one PGM OWCUST BBX MEM 512 modify these values per your bbx configuration MAXTRIES 5 ERRORLOG usr local etc httpd bbx error log CONFIG usr local etc httpd bbx config bbx BBXEXEC usr local etc httpd bbx pro5 This line must contain the full path to the interpreter OSAS Web B2B User s Manual D 3 Editing Files D 4 MEM MEM 512 if SPGM then echo Content type text plain echo echo Invalid pgm argument exit fi umask 0 RETRIES 0 until RETRIES gt MAXTRIES do BBXEXEC q c CONFIG m MEM PGM 2 gt tmp bberr if s tmp bberr then RETRIES expr RETRIES 1 sleep 1 read msg lt tmp bberr rm tmp bberr 2 gt dev null else RETRIES 99 rm tmp bberr 2 gt dev null fi done if SRETRIES 99 then echo date msg gt gt ERRORLOG 2 gt dev null echo Content type text plain echo
228. to change the workstation date to match the operating system date click Abandon to restore the original date or click Exit or press F7 to close the box without changing the date OSAS Web B2B User s Manual 1 15 OSAS Text Menu The text main menu can be used on all operating systems Using text based menus the text menu shown below offers easy access to your applications ioi xi Settings Edit Print Help 08 21 2002 Company H Builders Supply 3 21 PM Main Menu GENERAL Report Writer TODO STEMS R Accounting Software PEA When you select an application the application s menu which presents several related functions is superimposed over the main menu Selecting a function leads you to a function screen or to another menu You can select applications from the main menu in these ways e Use the arrow keys to move the cursor up or down highlighting the application you want to use Then press PgDn or Enter to select it e Press the first letter of the application you want to use The cursor jumps to the first application beginning with the letter Continue to press the letter key or the down arrow until the application you want is highlighted When your choice is highlighted press PgDn or Enter to select it OSAS Web B2B User s Manual 1 17 OSAS Text Menu Introduction e Position the mouse cursor over the application and click The application briefly highlights and switches
229. to read and return All records from key1 00 through key2 FF are included so 001 for both would successfully return key values from 001001 through 001ZZZ knum is the secondary key chain to use if the target file is a multi keyed file ky all and rec all are arrays that store returned keys and associated records Values are stored in ky 1 count and rec 1 count If count is O the the arrays may not be defined count contains the number of records returned in the ky and rec arrays or O if no records were found errmsg returns an error message if an error occurred OSAS Web B2B User s Manual F 63 Toolkit Program Functional Listing Basic Web Utility Guide rswatch wbb rswatch sh Watch a RS 232 serial port on a target system This program communicates with requests for records issued by CALLs to rsread wbb and rsreadm wbb Each rswatch task communicates through one serial port and uses one Business Basic user slot Syntax UNIX rswatch sh d tty device s stty parameters v rswatch sh may be run in background and started by UNIX at boot time by placing a startup script in the etc rc directory structure The tty device must be a disabled logins are not allowed tty device connected to the web server system If it does not start with dev this prefix is automatically added The stty parameters must be enclosed in quotes if any white space is included and are used to set the baud rate and other
230. to remove any temporary files that may have been created Names used in both the env and cgi string templates are fixed to be valid variable names if necessary by replacing any nonletter nondigit character with an underscore and by trimming long names to 32 characters Sequences of more than one underscore are changed to a single underscore In addition any names that do not start with a letter are prefixed with an X_ If any CGI input value is in the format name n then an array element is created in cgi All high level routines understand arrays and the format name n when moving data to and from the CGI environment For example if a CGI input stream name is keywords 1 the cgi string template variable would be referenced as cgi keywords 1 The global string arraysep may be specified before calling utcgi wbb to override the use of a single dash as the element delimiter For example setting STBL arraysep causes the name keywords 1 to be treated as described above This is important to scripting languages such as Javascript that cannot work with elements named with dashes This program stores two global strings for use by another program or application if necessary cgi stores the cgi string and cgitpl stores the template definition To recreate cgi dim cgi stbl cgitpl cgi stbl cgi OSAS Web B2B User s Manual F 69 Toolkit Program Functional Listing Basic Web Utility Guide File Uploading
231. to the application screen e To jump to the first application on the menu press Home To jump to the last application on the menu press End To select a function from an application menu highlight and select your choices the same way you do on the main menu with one exception you can press PgDn only when an option leads to another menu You must press Enter to select a function On an application menu you can press PgUp to move to the menu immediately above it If you are several menu levels away from the main menu you can return to the main menu by pressing PgUp repeatedly or by pressing the Tab key You can exit from a menu in these ways e Press PgUp to go to the previous menu one menu up Press the Tab key to go to the main menu e Use Exit F7 to go to the operating system Commands Several commands are available within the menu to perform various tasks such as changing the system date entering access codes switching between sample data and live data and so on To access a command press the corresponding key If you re working with a keyboard that lacks function keys labeled with an F followed by a number or if you re working with an emulator in UNIX which can cause function keys to become unavailable press the appropriate alternate key combination to access the command Command Alternate Key Key Description Esc Opens a menu listing available commands OSAS Web B2B User s Manual Introduction OSAS Tex
232. to the list of item values and the corresponding desc value is merged rather than the dataname value itself If the image lead in option is specified the image altname is used to specify the alt name in the HTML image tag The default name is image Normally any dataname value that comes from the data template is modified for HTML markup entities If passthruzy is specified the utentity wbb routine is not CALLed allowing HTML text to be stored in the data template The passthru user defined attribute in the data template is overridden by any value specified in the options here OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing uthimsel wbb Generate HTML list from a BBx or PRO 5 SELECT verb Syntax CALL uthtmsel wbb fl where sortby opt maxrec skip count tpl text work linkexpr This high level program simplifies the process of producing an HTML listing of records from a single file using the BBx Pro5 SELECT verb It supports a maximum record count and skip record count to control the resulting HTML record set The text string fl contains the name of the file to issue the SELECT from The text string where contains the optional WHERE clause without the word WHERE for use in the SELECT statement The text string sortby contains the optional SORTBY clause without the word SORTB Y for use in the SELECT statement The text string opt is used in the SELECT st
233. tomers can use the Account Information History Inquiry Invoice Inquiry and Aged Trial Balance functions If Inventory is installed on your system your customers can access the Item Inquiry function If Sales Order is installed your customers can use the Order Inquiry function If you have both Inventory and Sales Order installed your customers can use the Sales Order Entry function OSAS Web B2B User s Manual 2 5 Installing OSAS Web B2B Installation and Setup OSAS Web B2B Setup Checklist 2 6 Follow these steps to install and set up OSAS Web B2B on your computer Many of the functions you use during the setup process ask you for path or directory names where certain web server files programs and data files reside Read the instructions for these functions carefully Some path names describe the directory from the web server to the OSAS system and others describe the directory from the OSAS system to the web server Use Resource Manager to install OSAS Web B2B on your computer See the Resource Managers User s Manual for installation instructions Use the Company Information function in Resource Manager see the Resource Manager User s Manual to set up each company for which you want to provide web access Use the Customer Internet Access Codes function page 3 13 to control which of your customers can access the OSAS Web B2B functions the functions to which each customer has access and the Inventory Loca
234. trol is passed back to the program utwatch wbb rather than to the operating system call utcgi wbb env cgi errmsg rem try background bkg 0 background utwatch wbb err continue bkg 1 continue call uttags wbb h1 Data File Listing html dim tpl id c 5 name c 30 line lt li gt id name chan unt open chan data fil call uthtmfil wbb chan 0 0 0 tpl line work call uttags wbb ul work html call utsend wbb html call utexit wbb cgi rem if background worked then release if bkg then release run utwatch wbb OSAS Web B2B User s Manual Data Templates Many of the programs in the Basic Web Utility depend on data definitions found in string templates for data formatting and conversion HTML however is a text format with no provision to convert data to or from binary formats or to filter invalid data before it is passed to or received from the server The Basic Web Utility automatically performs translations to convert data between HTML text and the internal format used by Business Basic This is controlled with the data templates both through the data type included with each template data field and through user defined attributes The following user defined attributes may be used to allow the Basic Web Utility to properly handle data stored in various formats Text Fields case upper case lower case proper caption phrase mask format pass
235. tton to provide another version of a link to a subsequent list OSAS Web B2B User s Manual F 101 Toolkit Program Functional Listing Basic Web Utility Guide F 102 This routine is sensitive to the presence of two cgi variables bbweb count and bbweb skip If bbweb count is present bbweb skip is automatically incremented by the value of bbweb count when added to moreurl and morehidden OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utselect wbb Create SELECT WHERE clause from cgi input fields Syntax CALL utselect wbb cgi tpl where andor This program simplifies the parsing of cgi input from an HTML query form The query form would contain input fields for certain data fields and once the user filled in and submitted the form this program would create the WHERE clause of a SELECT statement based on the user entries It is sensitive to user defined formatting attributes in the data template The string template cgi is returned by utcgi wbb The data template tpl is used in the SELECT statement and can include user defined formatting attributes as defined in the Data Template section where returns the WHERE clause suitable for use in a SELECT statement with the syntax WHERE CPL WHERES The assumed data template name used in where is rec rec state 2 CA For example if rec is not the right name a substitution should be performed before executing the SELEC
236. tures List shows the image files that you have associated with your inventory items for display on the web You can select the range of items you want to include in the list Inventory Item Pictures List 11 06 2002 Builders Supply 12 39 PM Inventory Item Pictures List Item Description Electrical Package Plumbing Package 200200 Water Heater 200300 Air Conditioner 200400 Water Softener 200500 Sump Pump 200600 Humidifier 300 Refrigerator Black 301 Refrigerator White End of report OSAS Web B2B User s Manual Page Image File 150 jpg 200200 jpg 200300 jpg 200400 jpg 200500 jpg 200600 3pg 900 jpg 901 jpg Internet Companies List The Internet Companies List shows the companies that you have set up for Internet access for the companies you select Internet Companies List 11 06 2002 Builders Supply 11 54 AM Internet Companies List Comp ID Company Name Builders Supply 000001 End of report OSAS Web B2B User s Manual 7 9 Internet Inventory Item Groups List The Internet Inventory Item Groups List shows the item groups and the items that belong to them The list can be printed for the items locations or group IDs you select and can be sorted by item ID or by group code Internet Inventory Item Groups List 11 06 2002 Builders Supply 12 18 PM Internet Inventory Item Groups List Group Code Item Description APPLIANCE DISHWASHER No description is available APPLIANCE REFRIG N
237. u can control which files and data are available to Internet users OSAS Web B2B User s Manual Conventions This manual helps you install OSAS on any standard computer running any of several popular operating systems and helps with your accounting software questions Use the manual as a reference for the OSAS interface and application functions Manual Conventions This manual is divided into the following sections e This introduction provides an overview of this application and the OSAS system the basic functionality of the application including graphical and text based application features and function key references e The remainder of the chapters explains the set up workflow and functions of the application where each function fits within the application and how to use each function to get the most out of the application Mouse Conventions The standard mouse has two buttons left and right each performing certain functions In this manual these terms are used for operating the mouse click right click double click and deselect The click is a single press on the left mouse button Place the cursor over the desired function and press the left button to enable or select that function A right click is a single press of the right mouse button To double click move the cursor over the desired function and quickly press the left mouse button twice If there is too long a pause between clicks the computer may int
238. ucture 1 10 Shift F2 menu 1 55 Comments command 1 56 Documents command 1 59 History command 1 58 Information command 1 55 Shift F1 function key 1 41 Shift F10 function key 1 39 1 52 Shift F3 function key 1 50 Shift F4 function key 1 50 Shift F5 function key 1 50 Shift F6 function key 1 43 1 50 Shift F7 function key 1 43 1 50 Shift F8 function key 1 43 1 50 Shift F9 function key 1 39 1 52 Start Over function key 1 38 pull down menu command 1 38 tool button 1 44 Start style menu exiting from 1 23 features of 1 21 right click menu 1 28 1 45 sample screen 1 23 System Messages A 1 T Tab report command 1 66 scroll region command 1 42 Tables screen 3 22 tables COPYPATH 3 21 EMAIL 3 21 HOMEPATH 3 21 IMGPATH 3 21 WEBPATH 3 21 Tables List function 7 17 sample 7 17 terminal parameter 1 4 toggle between halves of reports 1 66 tool button Access Code 1 24 Application Information 1 27 Calculator 1 25 1 44 change to from Favorites 1 25 Copy 1 44 Delete 1 44 Help 1 27 1 44 Maintenance 1 44 MS DOS prompt 1 28 Online Documentation 1 44 Paste 1 44 Pop Up Calendar 1 44 PRO 5 Command 1 28 Start Over 1 44 Workstation Date 1 24 toolbar function screen toolbar 1 44 graphical menus 1 27 Transaction Journal function 5 5 sample 5 6 U Undo function key 1 39 1 52 pull down menu command 1 39 Up Arrow inquiry command 1 49 report com
239. use underscores for spaces Each description is delimited by the sepchar value or a semicolon if no sepchar is specified sep sepchar sepchar species the delimiter character or characters used in the item list and desc list If the value begins and ends with a it is assumed to be a hexadecimal value formtype form form entry type can be text memo radio checkbox list mlist image file or entry type hidden This serves as the default entry type in form generation Hidden values are suppressed from text generated by uthtmout wbb wrap value For memo type fields adds a wrap value option to the lt textarea gt tag multisep sepval If the data field can store multiple occurrences sepval defines the separator character used to delimit individual occurrences If sepval starts and ends with a it is assumed to be a hexadecimal value F 18 OSAS Web B2B User s Manual Basic Web Utility Data Templates Text Fields border pixels Specifies that a table used to format checkbox and radio button columns and rows have a border around each cell cols columns Specifies the default number of columns when generating checkbox radio buttons or memo fields in form generation rows rows Specifies the default number or rows when generating checkbox radio buttons selection lists or memo fields in form generation Numeric Fields scale n Scale number by n decimal places The internal number 10000 becomes 100 00 when n is 2
240. ust copy this file which is necessary for the History and Invoice Inquiry functions Later you can skip copying this file because it can grow quite large and depending on your computer system can take quite a long time to copy Copy Programs to Web Server Use the Copy Programs to Web Server function on the Remote Access menu to copy these programs GENGETOP PUB GENOPEN PUB GENTAX PUB INCALCPR PUB INUPD PUB INUPDSET PUB E 2 OSAS Web B2B Manual Basic Web Utility The Basic Web Utility and CGI F 3 Data Templates F 17 Sample Program Reference F 21 Suggestions and Tips F 37 Standard Structure Options F 39 HTTP Cookies F 41 Automatic Session Tracking F 43 File Uploading Support F 45 Global String Reference F 47 Toolkit Program Reference Overview F 53 Toolkit Program Functional Listing F 57 rsread wbb F 62 rsreadm wbb F 63 rswatch wbb rswatch sh F 64 utaddr wbb F 65 utcdate wbb F 66 utcatf wbb F 67 utcgi wbb F 68 utcgiwin wbb F 71 utcnum wbb F 71 utcprop wbb F 71 utcstr wbb F 72 utencode wbb F 72 utentity wbb F 73 utenv wbb F 73 uterr wbb F 74 utexit wbb F 75 utfrmgen wbb F 76 utfrmgn2 wbb F 80 utfrmin wbb F 81 utfrmout wbb F 82 OSAS Web B2B User s Manual F 2 uthtmfil wbb uthtmgen wbb uthtmkey wbb uthtmout wbb uthtmsel wbb utisip wbb utmeta wbb utmmoin wbb utmmoout wbb utmore wbb utselect wbb utsend wbb utses wbb utsub wbb uttable wbb uttags wbb uttplbas wbb uttempfl wbb uttplcp wbb utwatch
241. wbb Basic Web Utility Guide F 85 F 87 F 90 F 91 F 95 F 97 F 98 F 99 F 100 F 101 F 103 F 105 F 106 F 106 F 107 F 108 F 110 F 111 F 111 F 112 OSAS Web B2B User s Manual The Basic Web Utility and CGI The popularity of the Internet has led to the development of many software products that take advantage of the capabilities of TCP IP networking and inexpensive graphical World Wide Web clients called browsers In addition to use on the Internet companies have found that these same software products can also be used on their own networks providing a less expensive alternative to developing graphical applications These internal networks are called Intranets Browsers interpret and display specially formatted text called HTML in a graphical format The document can include links to other documents or files in line graphical images and data input forms that can be used to send information to a World Wide Web server HTML documents consist of text and markup tags Examples of tags include lt br gt line break lt p gt paragraph break lt h1 gt highest level heading and lt hr gt horizontal rule HTML information is available on the Internet and in many books The web server software or HTTP servers respond to browser requests for documents and files and can also perform tasks for browsers through a standard API known as a Common Gateway Interface CGI Through CGI it is possible to produce HTML document
242. wing them remote access to multiple customers data Master passwords cannot match any customer specific passwords you set up Use the Customer Internet Access Codes function to Add access codes for a customer e Change the information that a customer can access with an access code e Set up additional access codes for a customer e Set up master passwords for your staff e Remove access for customers e Set up the inventory location to use when calculating prices for a customer You must set up access codes for your customers before they can access the information on your web site OSAS Web B2B User s Manual 3 13 Customer Internet Access Codes File Maintenance Customer Internet Access Codes Screen Commands Edit Modes Other Scroll Commands Help RX lz Ba laa 20 Gk Abandon Customer ID 3 Access Code Test sj Location ID ANDOOT El HTML Page Options Access Information Account Information a Information Account Information Show Credit Limit nformation Aged Trial balance Information History Inquiry Information History Inquiry Link to Order Entry Information Invoice Inquiry Inventory Item Inquiry Inventory Item Inquiry Additional Description Inventory Item Inquiry Link to Order Entry Inventory Item Inquiry Show On Hand Quantity Inventory Item Inquiry f Show On Hand Quantity as Available customers access Show Price Qty Breakdown to the Order E
243. x the error routine may need to exit this way 1000 DONE REM 11000 Clean up and exit 1010 CALL utexit wbb CGI 1020 IF RETURN_TO_WATCH THEN RUN utwatch wbb 1030 RELEASE 2000 ERRTRAP REM 11000 generic error trap 2010 CALL uterr wbb ERR TCB 5 PGM 2 2020 GOTO DONE OSAS Web B2B User s Manual F 35 Suggestions and Tips There are a variety of ways to write a given program The following are some basic steps to make CGI programs more portable and easier to maintain e Usea single point of entry for CGI applications Rather than multiple CGI directories with many scripts a single script to start a single Business Basic program can be used to determine where to go based on a flag passed through the URL or hidden form fields The benefits to this method include the startup routine performing the initialization such as calling utcgi wbb creating templates and loading code tables Parameterize the script name using ENV SCRIPT NAMES because all routines use the same script The application becomes more portable to other sites and platforms that may have a different CGI directory structure e Usea single point of exit By using a single exit program code becomes portable between dynamic and shared directory methods as well as other interface methods that may be developed Ensure that all exits including error trapping logic exit through the single routine e For tracking large volumes of information between CGI prog
244. y Guide F 30 The customer record is read into CUSTS and a table is built from a list of fields in the CIST template The HTML text for the table is placed in CUSTINFO 0450 REM 1100 Get Customer Data and Create Display 0460 READ RECORD CUSTCHAN KEY FIELD CGIS cust id ERR NODATA DOM 0470 CUST 0470 CALL uthtmgen wbb CUST cust_id name addr1 addr2 city state zip phone slsp table border mu CUSTINFOS A list of invoices up to MAXRECS at a time is loaded into the variable INVLIST The list begins with the customer ID plus the invoice number indicated in the STARTWITHS and continues until all invoices for the customer ID have been read If there are more than MAXRECS invoices the CURKEYS contains that next one in line after the customer ID is trimmed off This is used to construct the global string MOREURL which is referenced in the HTML text file demoilst txt to allow the user to continue the list Note the use of the startwith value in the URL The CGI environment variable SCRIPT_NAME contains the name of the cgi script that launched this program Because the same script is used for all the sample programs it provides a convenient way of building another URL 0500 REM 1100 Construct Invoice List 0510 REM uthtmfil wbb reads from a channel and builds list of 0520 REM records using a particular structure into a string 0530 CALL uthtmfil wbb INVCHAN CGI CUST_ID STARTWITH CGI CUST_ID K NUM MA
245. year or day month year and the text string is parsed In BBx and Pro5 the value of STBL DATE is used for this analysis The following steps are performed e fstrdate is blank a julian number of 0 is returned e fstrdate is today s date and time are returned If a time is found at the end of strdate it is analyzed and converted to a fraction of a day noon is 5 6 00 pm is 75 to be added to the julian integer The time must be in the format h mm and may be followed by a word starting with p to force a pm assumption If possible month names are replaced with month numbers strdate is tested for simple numeric dates such as 030196 or 11301995 and converted to a julian value Finally strdate is scanned for three numerics separated by any non numeric delimiter such as 3 1 96 or 11 30 1995 and converted to a julian number e fno year is found the current year is assumed e Ifthe conversion cannot be performed the juldate value is returned as 0 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing utcdtf wbb Convert typical and OEM text date formats to from julian date Syntax CALL utcdtf wbb tojul format text juldate Many Business Basic applications store dates in a string format rather than a julian number Common formats include fixed digits such as YYMMDD and packed decimal requiring a special formula to unpack into the month day and year elements This
246. yntax CALL uthtmkey wbb chan keys keylen tpl text work linkexpr This high level program simplifies the process of producing an HTML listing of records from a single file using a predefined list of keys that can be iterated with a specified key length The CALLing program builds the list of primary keys and CALLs this program to create HTML for each record specified in that list chan is the channel that the file to be READ is opened on must be opened before CALLing this program keys is a string variable that contains the list of keys to process Each key must be the same length as indicated in the keylen variable keylen indicates the length of each key in keys tpl is a data template to read records from the file indicated by chan text is a string variable that contains the HTML format for each record along with embedded data name tags For each record the program uthtmout wbb is CALLed using this as the format text See the uthtmout wbb information for more details work returns the HTML text for the records linkexpr is a text string used by uthtmout wbb to generate any href links from the records to another page See the uthtmout wbb information for more details F 90 OSAS Web B2B User s Manual Basic Web Utility Toolkit Program Functional Listing uthtmout wbb Merge HTML text with data from a data template Syntax CALL uthtmout wbb tpl text work linkexpr This program is a high level routine CALL
247. you are using remote processing with OSAS Web B2B 11 Use the Copy OSAS Programs to Web Server function page 6 7 to copy certain special OSAS programs to the web server These programs perform tasks such as accessing inventory quantity and pricing information calculating balances and so on If your web server can access the Resource Manager programs path directly at all times you can skip this step 12 Use the Copy Data Files to Web Server function page 6 5 to copy your data files to the web server You must copy the optional data files when setting up OSAS Web B2B OSAS Web B2B User s Manual 2 7 Installing OSAS Web B2B Installation and Setup Using copies of your data files may provide a higher level of security but it requires you to update the files periodically on both the OSAS system and on the web server You can update files using the functions on the OSAS Web B2B menus See chapter 5 for more information about these periodic tasks 2 8 OSAS Web B2B User s Manual File Maintenance Item Group Codes Inventory Item Pictures Internet Inventory Item Groups Customer Internet Access Codes Customer Groups Tables OSAS Web B2B User s Manual 3 3 3 5 3 9 3 13 3 17 3 21 3 1 Item Group Codes Use item groups to group inventory items together for display and security purposes on the Item Inquiry and Order Entry web pages You can restrict access to the items by the groups you set up Us
248. you can review your order or check out If you close your browser or leave the Order Entry web pages your shopping cart remains intact for 24 hours When you return to the site within the allotted time period you can resume your order entry from where you left off View Shopping Cart HTML Screen Z Sales ORder Entry Microsoft Internet Explorer File Edit View Fav gem gem i y y SEN Information Inventory Orders Order Inquiry Customer Men Order Entry CA ACE BUILDERS Item Lookup SETE AE 005 555 1646 View Shopping Cart To remove an item change the quantity to zero Login Page litem ID Item Description __ Quantity Unit Price Extended Price 550 Millwork Package 300 PKG 1275 1920 3 825 58 250 Exterior Panels 1000 csz 14100125 1 410 01 650 Steel Supports 10000 PKGx 14 6526765 14 652 68 00 19 888 27 Check Out Recalculate Cancel Order Change Order to Taxable e Local intranet The screen lists up to 10 line items for this order If there are more than 10 items the Next and Previous buttons appear Click these buttons to scroll through the list of line items OSAS Web B2B User s Manual 8 25 Order Entry The Web Interface 8 26 Review the items you ordered You can change the quantity of any line item or cancel a line item by changing the quantity to zero If you change the quantity of a line item click Recalculate to recalculate the order totals based on your change
249. you do not want to use osasweb as your user ID you must change the userid entries in the OW tmp files in the progOW directory Edit the OW tmp files before you use the Install Web Server Components function OSAS Web B2B User s Manual 4 7 Sales Order Processing Sales Order Processing on the Web Transaction Journal Build Sales Orders from Remote Files Purge Log File OSAS Web B2B User s Manual 5 3 5 5 5 7 5 11 5 1 Sales Order Processing on the Web If you allow your customers access to the sales order processing functions on the web use the functions on the Sales Order Processing menu When you set up OSAS Web B2B you can elect to allow access to your OSAS data files directly from the Internet or to allow access to copies of your files stored on the web server The process of using copies of your files is known as remote processing See chapter 2 for more information about remote processing When your customers enter sales orders through the Internet OSAS Web B2B stores the orders as quotes in the Sales Order Header and Detail files If you are using remote processing OSAS Web B2B uses the files kept on the web server If not OSAS Web B2B uses the same files used in Sales Order Processing In either case OSAS Web B2B keeps a log file of the orders that have been entered and any comments customers enter along with their orders Use the functions on the Sales Order Processing menu on a daily basis as de

OSAS Web (OW) - White Ware, Inc

Contents

Download Pdf Manuals

Related Search

Related Contents