Table of Contents:
 
 

1. Web EZ Overview 
2. Documentation
3. Web EZ Procedures

• • Table Conversion Procedure
  • How to Setup Custom Buttons
  • How to Setup Dynamic Error Messages
  • Hiding Buttons

1. Web EZ Overview:

The ABBASOFT Technologies Web EZ Table Designer allows the user to convert Pick based applications into web-based systems. The creation of new tables and screens that can be driven by the master program, UT100 is the result. The file TABLE contains the table items that are selected by UT100. The user can create a new table and screen or modify existing tables for use with UT100.

Each input prompt of a single screen is identified by what is called a Record ID. A Table is the collection of Record ID's for a single screen. The Table determines how input for each prompt will be accepted by UT100. UT100 looks for the table called for by the menu and uses the table information to drive the screen.

Each table starts with a Record ID of zero (0) and increments by one. Each table record contains input information for a different prompt. An example of a table and its record ID's might be:

Table name: CUSTOMER-TABLE

Record ID's and descriptions:

0 = CUSTOMER NBR 1 = NAME 2 = BUS.TYPE 3 = PHONE NBR
 
 
 
 

Web EZ Standard Screen sample

Web EZ Output Screen Sample

Web EZ Input Screen Sample

2. Documentation:

ENTER RECORD ID

This is the Record ID or prompt number for the input line. The Record ID tells how the input line will be identified in the Table.

 

Generally the record ID's are numbered 0, 1, 2, 3, etc. but if two prompts are desired for one input number on the screen, then you could use 2.1 as a record ID. An example of this is number 6 on the vendor input routine. The screen shows state and zip being prompted for at input 6. If you look at the table which drives the vendor input routine you will find 6 and 6.1. The first number is 6 which is the state and 6.1 is the zip.

 

When in the change mode the system only stops at whole number IDs. The system will not stop at the above example, 6.1.

 

If you want to make the record ID for your data a combination of two items then make the prompts 0 and 0.1. The system will concatenate these two items together to make the record ID. If more items are desired to create data record ID's then use 0, 0.1, 0.2, 0.3, and so on.

Buttons

After you have entered a new or previously established Record ID press this button to bring you to the 'Standard' Table Designer screen in order to enter or edit record information.

Press this button if you would like to use the Keyword Search routine to search for a particular Record ID.

Press this button to exit Table Designer.

Press this button to view the Help documentation for any item on the Standard, Output, or Input screens.
 

Standard Screen

ATTRIBUTE POSITION

This is the attribute in the file where input at this prompt is stored. An example of this is the Vendor input routine. The attribute position for the input prompt number 1, is 1. Whatever is input at prompt one will be stored in attribute number one of the vendor record.

 

The attribute position is not necessarily the same as the input prompt number. An example of this is the Contact name of the Vendor maintenance routine. The contact input prompt number is 8 on the screen but the attribute where the contact is stored is number 32.

 

If input is not to be stored in this record enter 999 for this attribute. The program (UT100) does not store this field if it sees 999 as the attribute position.

VALUE COUNTER

This field designates the location of the value in a multi-valued attribute. For example, a value of 3 would mean that the data entered at this field is to be located in the third position of a multi-valued attribute.

PHYSICAL LENGTH

This is the maximum length of input for this field.

A special feature of the system counts the input characters for any prompt. The system does an automatic return when the number of characters input equals the maximum. Therefore, the system will not let you input more than the maximum size input defined here.

LOGICAL LENGTH

Enter the logical maximum length.

MINIMUM LENGTH

This field carries the minimum number of characters that can be input for this prompt.

To allow a user to skip a given prompt, the minimum must be set to zero. If the minimum is set greater than zero, the system will require some kind of input.

INPUT REQUIRED

A "Y" entered at this location will require input for this prompt. If an "N" is selected, the user is allowed to pass this prompt with a <CR only. The user can get by this field by entering a space.

VISIBLE DEPTH

If a window is desired for this field, enter the number of lines allowed. This line shows the number of sub-values that will be accepted at this prompt when more than one piece of data may be stored in a single attribute. Each of the values entered for the prompt will be stored in the same attribute number. To exit the multi-value prompt, enter "++".

ACTUAL DEPTH

Indicate how many logical rows you can scroll down.

SCREEN NAME

NOTE: If this entry is for Record #0, leave this field blank.

This is the name of the screen that the master program (UT100) will read and display when prompting for the items in this table. The screen name is also used as the record ID for the on-line documentation. The master program takes the screen name and connects a dash and the prompt number to it to form the record ID in the DOC file.

LINK TO PROMPT

There are two options on this prompt.

A. Conditional Call: Format IF Conditional Ex THEN Prompt # (Link)

It always starts with an "IF" and ends with a "THEN" followed by prompt number. For example:

AR (AUTO-RETURN/AUTO ADD)

When the Auto-return flag is set to "Y" in the Add mode, the cursor will pass the selected prompt not allowing any data to be input. This can be useful if the user wants to skip fields that are not necessary for their application. When set to a "N" in the Add mode, the system stops at the selected prompt and waits for input from the user.

 

When the Auto-return flag is set to "Y" in the Change mode, the user will not be able to change the data displayed at the selected prompt. This helps protect verified data from being changed accidentally. When set to "N" in the Change mode, the Auto-return function allows the data displayed at the selected prompt to be changed.

 

NOTE: The auto return flag does not work if the Required Input flag is set to 1 (YES) and the Default Value is blank.

 

The "N" option in auto return change mode only works if the Required Field option is set to "Y."

The decimal display becomes corrupted if the change mode auto return is set to a "Y," add mode is set to a "Y," and required field is flagged with a 0 (NO).

CHANGE MODE

When the Auto-return flag is set to "Y" in the Change mode, the user will not be able to change the data displayed at the selected prompt. This helps protect verified data from being changed accidentally. When set to "N" in the Change mode, the Auto-return function allows the data displayed at the selected prompt to be changed.

EDIT PATTERN

The edit pattern is what the system uses to error check the input.

Examples of edit patterns and what the program checks for are:

1N = The program checks for one numeric character
4A = Checks for four alpha characters
0N = Checks for any number of numeric characters
15X = Checks for fifteen of any kind character
0X = Checks for any number of any kind character

If a single question mark is input at any prompt, the appropriate edit pattern for that prompt will be displayed at the bottom of the screen.

FIELD VALUES

You can enter at this point data field values that you want your input checked against.

 

An example of this might be a Y,N. The program will require the input to be either a Y or an N. The possible inputs must be separated by commas and can be more than one character.

 

If you want to test for a valid department to be input, then you would load 001,002,003,004 in this field. The input program for this prompt would require the input to be either 001 or 002 or 003 or 004.

 

This field is commonly used instead of a matrix to verify input.

DISPLAY TEXT FOR FIELD VALUES

Input text you would like displayed in the drop down box.

DISPLAY TYPE

Specify Display Type by clicking on 'Drop Down' box 'Radio' box, 'Check' Box or 'Standard' entry in the Drop Down box provided. Standard Entry is the default selection.

DISPLAY CONVERSION

This field is used for conversions of the data to be displayed on your terminal. All data is stored in the internal format, meaning that decimals and dashes etc. are not stored.

 

The display conversion lets you input the dollars without having to input decimals, and converts date entries to the proper format. If you set display conversion as a MD2 and input 444 then the system will display 4.44 as the amount. If you set the display conversion as a D2/ then you can input 8/9 and the system will convert it to 08/09/85.

 

The table uses the same conversions that the dictionaries use in Standard Pick. There is an exception to this in the case when dashes are needed, for example of phone number, enter 3-3-4 for the phone number. This will insert dashes after the third and sixth numbers.

SUBMIT

Press the "Y" button for yes if you would like to submit this table to the database after this prompt or "N" if you would not.

FIELD VERIFICATION

This line is used to indicate the name of a file where input for this prompt must be contained in order for the input to be valid.

 

An example of this is found when entering the Terms Code in the Vendor file maintenance routine. When the Terms Code is entered, the system reads the Terms Code file and verifies that the input exists. If the code entered does not exist in the file, then the entry is not accepted by the system.

 

The format for the verification here is like a Standard Pick translation. An example of the vendor terms code verification format is: TAPTERMS;X;1;1 APTERMS is the file to verify against.  This field is for verifying data entered in the table. Set to '1' for immediate field verification right after you enter a value in the table.

 

Set to '2' and then add UT124 to the last prompt of the table if you wan tall the verification done at the end.

 

Note: The prompt where you add subroutine UT124 can't be an auto return = 'Y' prompt

LINK ID

Put an "A" before the attribute number (ex. A11). This identifies which ID number of the table will be used.

LINK TABLE

This specifies which table the information will be pulled from. Put an "A" before the attribute number.

DEFAULT VALUE (C OR A)

This line is used to indicate data that will be displayed automatically at the prompt. Two types of default data can be specified: Constant or Attribute. Constant default data is indicated by the letter "C," placed in front of the data. An example of Constant default data appears below.

 

CCA = If return was entered then CA would automatically be entered for that prompt and would be stored in the file for this prompt.

 

Attribute default data is indicated by the letter "A", placed in front of the attribute number of the file that contains the desired data to be displayed. Examples of Attribute data types appear below.

 

A3 = The program will default to attribute 3 of the record being input. Remember, not prompt 3, but attribute 3.

 

A3,*,A15 = Takes attribute 3 of this record and multiplies it by the value in attribute 15.

 

NOTE: a comma, including the multiplier must separate each item in the constant.

 

A12,*,A13,*,A14 = This will take attribute 12, which might be a value set earlier by a default, and multiplies it by attribute 13. Then the product of A12*A13 multiplied by A14. An example of where this might be used is if attribute 12 is the unit price which was default from another prompt multiplied by A13 which could be the quantity ordered multiplied by attribute 14 which could be the discount.

 

A3,TINV;X;17;17 = Take attribute 3 of this record, do a translation to the inventory file and default to attribute 17 of that inventory record whose ID is the same as attribute 3.

 

A3,TINV;X;17;17,*,A15 = Take attribute 3 of this record, do a translation to the inventory file and use attribute 17 of that inventory record times attribute 15 of this record.

 

USER NOTE - EXPLANATION OF LPV LOGIC: Displays the last previous value as the default.

HIDE

This hides the prompt in Flashconnect if "Y" is entered. It is there, but does not show up on the screen it is displayed.

OUTPUT POSITION

This indicates the screen coordinates for printing information verified through line 10 (Field Verification). The X,Y coordinates must be 2 characters each so leading zeros (01,09) must be used. Columns across and rows down.

 

TEXT

 

Enter the text that is to display for the user right before the input field. As an example: 'Name:' or 'Address' or 'Enter Record ID', etc.

 

CELL WIDTH

 

Enter the cell width. Maximum header cell width would be 400. A smaller cell width would be 125, average cell width would be about 250. Each alphanumeric character takes up about 10 pixels so go figure...'Name:' would take up a cell width of 50 pixels. Consult your Design & Development Manager for more specific direction on Cell Width on the project you are working on.

 

JUSTIFICATION

 

Click on the drop down box to choose your Justification. Default is Left Justified although you may choose either 'Center' or 'Right' justified.

 

FONT COLOR

 

Click on the drop down box to choose your Font Color. 'Black', 'White', 'Navy, etc.

 

FONT SIZE

 

Click on the drop down box to choose your Font Size. Default is '4' although you may enter any size between 1 to 6 or (-3 to +3).

 

FONT FACE

 

Click on the drop down box to choose your Font Face. Default is Times New Roman.

 

BOLD

 

Click the check box to choose the Bold font feature. Default is the standard font type.

 

BACKGROUND COLOR

 

Click on the drop down box to choose your Background Color. Default is 'Light Gray'.

INPUT POSITION

This line indicates the screen coordinates where input for this prompt is to be entered. This is the location where the input characters specified on line 17 are printed to the screen. Each X,Y coordinate must be 2 characters so leading zeros (01,09) must be used if necessary.

 

If "80,24" is used, line will not be printed on the screen. This is used for dummy prompts.

 

TEXT

 

The text of the prompt can also be indicated here for clarity.

 

CELL WIDTH

 

Enter the cell width. Maximum header cell width would be 400. A smaller cell width would be 125, average cell width would be about 250. Each alphanumeric character takes up about 10 pixels so go figure...'Name:' would take up a cell width of 50 pixels. Consult your Design & Development Manager for more specific direction on Cell Width on the project you are working on.

 

JUSTIFICATION

 

Click on the drop down box to choose your Justification. Default is Left justified although you may choose either 'Center' or 'Right' justified.

 

FONT COLOR

 

Click on the drop down box to choose your Font Color. 'Black', 'White', 'Navy, etc.

 

FONT SIZE

 

Click on the drop down box to choose your Font Size. Default is '4' although you may enter any size between 1 to 6 or (-3 to +3).

 

\FONT FACE

 

Click on the drop down box to choose your Font Face. Default is Times New Roman.

 

BOLD

 

Click the check box to choose the Bold font feature. Default is the standard font type.

 

BACKGROUND COLOR

 

Click on the drop down box to choose your Background Color. Default is 'Light Gray'.

Buttons
 

Press this button to bring you to the Previous screen. If you are on the 'Output' screen pressing this button would bring you back to the 'Standard' screen.

Press this button to bring you to the Next screen. If you are on the 'Standard' screen pressing this button would bring you to the 'Output' screen.

Press this button if you would like to Delete a Table Record from the database.

Press this button if you would like to use the Keyword Search routine for any prompt with the Flashlight Icon next to it.

Press this button to exit the table record you are working on without saving any of the changes you have made to that record.

Press this button to view the Help documentation for any item on the Standard, Output, or Input screens.

Press this button to refresh this table record without exiting it. The changes you have made will not be saved. Record will revert back to how it was before you entered it.
 

Additional Prompts Screen
 
 

SCREEN TEXT

Enter the text you would like to appear in one of the Icons in the Top Navigational Toolbar. As an example: For the "Ship To" Icon that appears in the Top Navigational Toolbar on the Order Entry screen you would have entered "Ship To" here.

SCREEN IMAGE

Enter the Image associated with this function as described above.

STOP IF BLANK?

Press the "Y" radio button if in the change mode you would like the cursor to stop in this blank field.

DISPLAY IN FLASHCONNECT

To display this table in Flashconnect, enter "Y" for Yes. "N" for No. Default is "Y."

GENERAL LEDGER #

Indicate whether this prompts for a General Ledger number. If "Y," when a table is transferred, the system will update the prompt for the proper GL format based on your company data. "N" or a blank is not updated during this process.

 

If you fix, change, add, or delete a GL prompt, you must make sure Field 15, Edit Pattern, has the proper field verification to translate to Syscon and verify. Do not modify this if you are unsure how to. In the Installation menu, you must update the Location Entry of EZ GLS option. Failure to complete these steps will result in major damage in updates.

CONDITION & SUBROUTINE

There are two options on this prompt.

A. Conditional Call: Format IF Conditional Ex THEN Sub name.

Always start with an "IF" and end with a "THEN" followed by subroutine name. For example:

• IF A1+A2 A3 THEN GL100
  This will test if sum of attribute 1 & 2 is greater than attribute 3, call subroutine GL100.

 

NOTE: EZ does not go to the sub routine in Change modes if its flag is set for auto return. However, if the prompt is moved down and a 999 prompt is created above it, that is not an auto return change mode.

 

Also, if two sets of prompts are going to update the same fields, depending on which type of prompts you use, you want the flag to be set to "N."

ADD-ON FLY TABLE NAME

Enter the table the record added on the fly should be added to.

KEY ATTRIBUTE

*** NOTE: This field entered only for table record 0 ***

 

Enter the attributes you want to see displayed when a keyword search is done on this field.

The format for this attribute is 0N. This should be the attribute number where data will display when you do a keyword search.

 

Up to 4 attributes can be entered. The system will build a record from each string of characters in the attributes specified. The records will be stored in a file called KEY.(data file). An example of this is the AR file which would be KEY.AR where the records would be stored. Each record will contain all record ID's of any records in the data file that has that string of characters in the specified attributes.

 

An example of the keyword search routine might be for the customer master file:

 

Also note that when someone is trying to do a keyword look-up, the field they're trying to do the look-up on must have a value in attribute 8 of its record ID. This is how the system knows where the keywords are located. Attribute 8 is the field verification for that prompt.

IMAGE

WIDTH

 

Enter the Image Width in pixels.

 

HEIGHT

 

Enter the Image Height in pixels.

 

BORDER

 

Enter the Border Width you would like around the Image. This border width can be from 1-6.

OUTPUT

ITALIC

 

Click the check box to choose the Italic font feature. Default is the standard font type.

 

UNDERLINE

 

Click the check box to choose the Underline feature. Default is the standard font type without the underline.

 

BORDER COLOR

 

Click on the drop down box to choose your Border Color.

 

BORDER SIZE

 

Enter the Border Size you desire, if applicable.

 

TABLE PADDING

 

Enter your Table Padding. This adds extra space on all sides of the cell.

 

TABLE SPACING

 

Enter your choice of Table Spacing. This adds extra space between cells.

INPUT

ITALIC

 

Click the check box to choose the Italic font feature. Default is the standard font type.

 

UNDERLINE

 

Click the check box to choose the Underline feature. Default is the standard font type without the underline.

 

BORDER COLOR

 

Click on the drop down box to choose your Border Color.

 

BORDER SIZE

 

Enter the Border Size you desire, if applicable.

 

TABLE PADDING

 

Enter your Table Padding. This adds extra space on all sides of the cell.

 

TABLE SPACING

 

Enter your choice of Table Spacing. This adds extra space between cells.

HYPERLINK VALUE

Enter the Hyperlink Value.

TARGET FRAME

Enter the Target Frame for the Hyperlink.

IMAGE NAME

Enter the Image Name. The Image type must be either a '.gif' or '.jpeg'.

IMAGE TARGET

Enter the Image Target frame.

FORMAT (L.S.)

Enter the Format (L.S.).

ADDITIONAL JAVASCRIPT

Enter any additional Javascript.

ADDITIONAL HTML

Enter any additional HTML.

Buttons

Press this button to bring you to the Previous screen. If you are on the 'Output' screen pressing this button would bring you back to the 'Standard' screen.

Press this button to bring you to the Next screen. If you are on the 'Standard' screen pressing this button would bring you to the 'Output' screen.

Press this button if you would like to Delete a Table Record from the database.

Press this button if you would like to use the Keyword Search routine for any prompt with the Flashlight Icon next to it.

Press this button to exit the table record you are working on without saving any of the changes you have made to that record.

Press this button to view the Help documentation for any item on the Standard, Output, or Input screens.

Press this button to refresh this table record without exiting it. The changes you have made will not be saved. Record will revert back to how it was before you entered it.
 

3. Web EZ Procedures:

Table Conversion Procedure

This procedure is specific to the ABBASOFT system. Your table conversion procedure may be slightly different although but the principals will remain the same. This describes the process of converting our character based Pick system into a completely browser based system. Your Design and Development Manager will give you more specific instructions on how the finished table should appear on screen.

1. Go to the first screen of the Web EZ Table Designer and enter the Table Name in which you would like to edit. A listing of tables that have been recently worked on will appear and you can click on one of these as well. If you do so the table will automatically appear in the 'Enter Table Name' field. To edit the table press the 'Edit' button and continue with the process described in number 2 of this procedure.

If this is a completely new table enter the name of it in the Table Name field and then press the 'New' button to establish this as a new table.

2. The 2nd screen of the Web EZ Table Designer allows you to enter a particular table ID record in which you would like to edit. To do so, enter the Record ID in the field provided and then click on the 'Next' button. Each Record ID represents a particular field on a screen. As an example the 'Enter Record ID' prompt itself is a Record ID somewhere. The first ID on a screen is usually '0' and this one is no exception.

If this is a new table record, enter the new Record ID and press the 'Next' button to bring you to the Standard information entry screen.

3. The Standard Entry screen gives the basic information regarding this prompt. The physical and logical lengths, visible and actual rows, key word search attributes, etc. See the corresponding documentation for detail information regarding each prompt. When complete press the 'Next' button to get to the Output Entry screen.

4. The Output Entry screen gives the detail information regarding output for this prompt. 'Output' is what we call the text that tells the user what to do and what information to input in a particular field. Also covered on the Output screen is the location of the text on the screen, if the text will be bold or not, etc. When you have completed entering the information press the 'Next' button to get to the Input Entry screen.

5. The Input Entry gives the detail information regarding input for this prompt. 'Input' refers to the field itself where the user enters information.

6. Once you have completed the entry of all table information you will need to copy the table information into the Partner II format. See the corresponding menu option on the Web EZ module menu.

How to Setup Custom Buttons

This procedure describes how to setup custom buttons in Web EZ Table Maintenance. These are buttons that are not included in your Standard ‘arsenal’ of buttons and may only turn up on a single table.

1. Set the ATR Value.

2. Leave the Output and Input position values blank.

3. Set the Output Text to the Button Text

How to Setup Dynamic Error Messages

This procedure describes how to setup Dynamic Error Messages to display for specific users. This would be used to alert a user that they have entered an invalid password as an example.

1. In Table, set Default:: sprofile0,stw3msg;x;?;?

Hiding buttons

This procedure describes how to hide standard buttons from user display on screen.

To hide the ‘delete’ button as an example you would need to set delete sub to ‘NONE’.

Thus if you want to hide the ‘reset’ button, press the ‘Edit Header’ button then set the ‘Show Button’ prompt to ‘N’.