|This program converts text files exported out of AutoCad into the proper format for importation into any program that can import the KISS format.
The program consists mainly of four screens shown in Figures 1 through 4. A short description of each screen and its function in the program follows each figure
Main Conversion Screen
Figure 1 - Main Conversion Screen
The screen shown in Figure 1 is the main screen that appears when the Ac2Kiss.Exe
program is executed. The screen consists of three input fields and several
push button options.
Figure 2 - Material Tab, Configuration Screen
Column Header Field
The Column Header field is where you would type in the text that appears at the top of a column on your bill of material. For example: If the top of your materials column on your BOM is "DESCRIPTION", you would enter this word into the Column Header field. Note: The Column Headers have to be unique and in the order as they are shown on the BOM from left to right. Column headers on the left side of the BOM should be at the top of the list with the ones on the right being at the bottom. For stacked column headers (i.e. "Ship Mark" with Ship on one line and Mark underneath), you can use either word in the Column Header field but we suggest and prefer that you use the lower of the two, in this case the word "Mark".
Column Type List
The Column Type list is used to identify the type of data that this column on the BOM contains. For example, the column that contains the description of the materials (W12x40, etc.) would be identified as "Material".
Most of the types are self explanatory except for the types representing piece marks. There are three types of piece marks, Major PC Mark, Minor PC Mark and Piece Mark. If you identify a column as a "Major PC Mark", regardless of the case (upper or lower) of the piece marks in this column, all of the piece marks will be converted to upper case. This is just the opposite for "Minor PC Mark". All of the piece marks will be converted to lower case characters if the column is identified as "Minor PC Mark". If you use the type "Piece Mark", the system will not convert the case of the piece marks in this column. If you used a combination of upper and lower case characters in this column, they will remain the way that you entered them on the BOM.
Fraction Substitution Check Box
The Fraction Substitution check box is used to identify columns of data on the BOM that use fractional substitution characters. If this column of data uses fractions substitution (i.e. a = 1/16, b=1/8, etc), click on the box next to the Fraction Substitution text. Be sure to confirm that the codes used for fractions match the codes in the Input File. You can check the fraction character set by clicking on the Fractions tab at the top of the Configuration window. See Figure 7 for more information on the Fractions window.
In most cases, vendors use different codes to represent the same material types. Selecting the Material push button will display the screen in Figure 3. On this screen you will identify the various codes for all the material types recognized by KISS. For further information on the Material Configuration screen, see Figure 3.
Figure 3 - Material Codes Configuration Screen
The Materials window, shown in Figure 3, is used to identify all the material type codes found on the bill of material to the conversion utility. The material codes that the KISS format expects to see upon import are shown to the left of the input fields. The codes that are being used on your BOM should be keyed into the fields beside the standard codes. When you click on the Convert or Export button on the Main window, the utility will convert the codes in the input fields to their corresponding standard code during the conversion process.
You can enter characters from the extended ASCII character set by holding down the ALT key on your keyboard and keying in the four digit numerical code that represents the character (you must use the numerical keypad for this operation) that is in your bill of material. If the code is only three characters long, proceed the number with a zero.
Also, there is a check box just below the MM material type. This option can be checked if your BOM contains main member information (Beam, Column, Diagonals, etc.) and you do not wish to have this information transferred into the KISS file. If checked, the MM material line in the BOM will be discarded and the next line in the BOM will become the major piece mark.
Fractional Substitution Configuration
Figure 4 - Fractional Substitution Configuration Screen
The Fractions window, show in Figure 4, is used to identify the characters
that represent fractions in the Input File. This window determines the
relationship between the characters in the Input File and how you want
them represented in a numerical fashion after you click on the Convert
or Export buttons on the Main window. If you click on the Case Sensitive
box, this will make the test of the substitution characters case sensitive.
For example, if the Case Sensitive box has been check, a lower case letter "a" is
not the same as an upper case letter "A". If the Case Sensitive
box is not checked, a lower case letter "a" is the same as
an upper case letter "A".