Thanks. What kind of data bases have you created? ----- Original Message ----- From: "Rhonda Clark" <[EMAIL PROTECTED]> To: "Braillenote List" <[email protected]> Sent: Friday, July 15, 2005 9:47 PM Subject: re: [Braillenote] data bases?
1. Open the Word Processor. 2. Go to Create a document. 3. Choose the KeyList folder. 4. Press BACKSPACE with X to cycle through the types of documents that can be created, until you get to "Create a KeyList definition file". 5. Input the name of your new database and press ENTER. 6. Now you are at the top of a blank document, where you see computer Braille is required. 7. From here, we want to insert the KeyList definition file called address list. Open the Block commands menu by pressing SPACE with B. 8. Press I for "insert file." You are prompted, "insert document from drive?" Select the Flash Disk. 9. At the folder prompt, select the KeyList folder. Press BACKSPACE with X until you arrive at the list of all files in KeyList. 10. Now, move down through this list of files in your KeyList folder until you get to "address list." Press ENTER. This inserts the file into your newly created word processing document, and places you at the bottom of the file. Go to the top by pressing SPACE with dots 1-2-3. 11. You will then see "database Address list", followed by $ (dollar sign) P. Remember, dollar sign in computer Braille is dots 1-2-4-6. 12. Delete the words, "Address list", and replace them with the name of your desired database. Be sure to initial cap the first letter of the first word of your new database name. 13. Now, as you read through the file, you will see that each line begins with a number followed by a comma, then the field name followed by a comma, then the field type followed by a comma, then the field label in quotation marks. 14. Delete the fields you do not want by deleting the line from the number to just past the new paragraph marker, dollar sign p. 15. Leaving a number at the beginning of each new line, change the words in quotes (the field labels) to text that will reflect your database needs. Be sure to leave only one new paragraph marker, dollar sign p, between each line. Each new line must begin with a number, and end with a dollar sign p. Remember, the field label must always be in quotes, with initial caps on the first word of the field label only. 16. Once all editing is done, exit the file by returning to the Main Menu. 17. Move to the address list database. Select your newly created definition file by pressing SPACE, moving you down through the list of definition files, just as you do in any other folder or file list. Once you arrive at the newly created definition file, press ENTER. 18. Now, you are in the familiar KeyList menu. 19. Select add address. It will tell you that your database does not exist and ask if you want to create it. Press Y. 20. Now it is time to start filling in those fields you have created, just as you do in your address list database. Here is also some other information that may help that was given a while back. Line 1 must contain the word "database" or the file will not be recognized as a valid database definition file. Optionally, the word "database" may be followed, on the same line, by the name of the cdb file which will be created in association with that definition file. It could be any name, even different from the name of the definition file, but of course consistency is recommended. If you do not write anything after the word "database", then the name of the definition file will automatically be the name of the associated database. Line 2 must contain any number, two-digit. It's a number assigned to databases when using other programs for compatibility purposes, but in Keysoft, it has no use. However, the second line of the definition file must contain a number; otherwise, you'll get an error referring to line 2. The numbers at the beginning of every line describing fields is just an identification number. It's possible values are between 1 and 65535, inclusively. Note that those you see in the current Keysoft definition files are random, and they do not have to be consecutive or five digits long. Just make sure you do not repeat the same number for two lines, because these numbers are there to distinguish each field line. On the same line describing the field, the identification number is followed by the field type. This lets Keysoft know how to treat the information entered into the field. Examples that can be seen in Keysoft databases are the types called time, date, time-and-date, boolean and udword. For example, you wish to have a definition file with a birthday field. The correct field type to use is "date" In such a field, you can just enter the birthday of a person, say, "January 12, 1980" (write as is, but and when you hit ENTER, then view the field entry, it would say, "Saturday January 12, 1980", that is, the day o Also, the field type "boolean" characterizes the field as having only two possible values for entries, like yes or no (see the definition file for the Directory of Services as an example). Some fields do not have a specified field type. If none is written, then the general field type "string" (having up to 250 characters) is assumed. The next part of a field line is called usage. Examples of this are Name (which will cause abbreviations like D R to be read as "doctor", not "drive"), address (which will cause abbreviations like S T to be read as "street", not "saint"), state (which will tell the BN to read the letters entered as the If no usage is specified, then the "general" usage (meaning, the entry will be read as it would be anywhere else in Keysoft) is assumed. See the web address field as an example. The fourth part of a field line is the modifier. This is optional. Examples are autocap (which automatically capitalizes the first letter you type), autonum (which automatically puts a number sign so you don't have to type dots 3-4-5-6, but can just go ahead and type the numbers using the upper part of the cell, unless this The fifth part of a field line is the Braille grade. Those that you can write are G2 (for contracted Braille), G1 (for uncontracted Braille), and G0 (for computer Braille). This would control the Braille grade for typing in entries, but with the e-mail database definition file, since most are fields with e-mail as the usage, entries are still in computer Braille (which is the default for that field usage), yet will be display The sixth part of a field line is what you see within quotation marks. This is the prompt, giving you the field name when you access the selection list for fields in Keylist. They must be between quotes, and should only be a certain number of characters in length; I cannot remember exactly right now, but if memory serves, it's 24 characters, not including the colon automatically appended to the prompt. The seventh part is again optional. This is called the default value of the field. It is entered in the format d equals "value" where value is whatever entry will be automatically entered or selected (say, y or n for boolean type fields) when you create a record. The value must be written between quotes and can only be 50 characters long. For an example, look at the definition file for the Directory of Services. This is how you can make a Reply-Toaddress appear on every e-mail you compose in Keymail. The eighth part, Help Message, is again optional. This is written between quotes. Examples can be seen in the password fields in the Directory of Services definition file. You can use this if you want to be reminded about what to type or how to enter information into a field. This is accessed when you press SPACE with H (HELP key) for the context-sensitive help while you are on that field, and your help message will be announced or appended to the default Keysoft help message. Other parts of a definition file are the sort order, announcement order, and concatenation (concat) lines. Concat lines will help define how fields are referred to in the sort and announcement order lines. For the concat lines, their identification number must be 24594 (if the information is accessed in the Keylist menu) and 24595 (if the information is accessed in Keymail). Parts of a field line must be separated by a comma and space. Remember to select Keylist definition file as the file type to create, because such files are not just text documents, but have the disklt extension. >----- Original Message ----- >From: "Sarai D. Bucciarelli" <[EMAIL PROTECTED] >To: "Braille Note" <[email protected] >Date: Fri, 15 Jul 2005 21:13:44 -0500 >Subject: [Braillenote] data bases? >Hey, >I was reading the chapter on creating data bases. Has anyone ever done it >for the BN, if so, what kind did you create and do you have any advice? How >do you back up the main address list just incase you screw it up? >Thanks, >Sarai D. Bucciarelli >___ >To leave the BrailleNote list, send a blank message to >[EMAIL PROTECTED] >To view the list archives or change your preferences, visit >http://list.humanware.com/mailman/listinfo/braillenote ___ To leave the BrailleNote list, send a blank message to [EMAIL PROTECTED] To view the list archives or change your preferences, visit http://list.humanware.com/mailman/listinfo/braillenote
