8.3 Export (NOT IN FREEWARE VERSION) ---------------------------------------------------------- The Export command means your data is not trapped in BlueBook. If you want it out for mail merge or some other purpose, or if you want to upgrade to some other database product (we can't imagine why), then Export will output it for you in the universal "lowest common denominator" comma-delimited format that most all programs understand. This means avoiding the cost of rekeying, and allows you to "commit" to BlueBook in safety and with confidence. But you WILL have to "register" to use it. C'est la vie! ---------------------------------------------------------- With records selected, click Export or type E on the List screen. A dialog box pops up with a variety of check boxes labelled in red (on left) and blue (on right). The lefthand red boxes determine which database fields/lines (from the currently selected records) will be exported. The default is ALL. If you have clicked some field(s) and wish to return to ALL, don't click ALL. UNcheck the individual fields (from X to blank) instead. The righthand (blue) column of check boxes and fields lets you choose to insert line breaks after (1) each record is output, (2) each field is output, and (3) each individual Note LINE is output (Note being FOUR lines but ONE field); and define both the delimiter character and the NAME of the output file - default is ".CSV". (The output file is always written into the same directory as the database itself!) A line break is the ASCII character pair "CR/LF" (Carriage Return/Linefeed) inserted into the file. ---------------------------------------------------------- A BRIEF NOTE ABOUT COMMA-DELIMITED FORMAT: Each 'field' (line in a database record) is written out to an ordinary text file, surrounded by a DELIMITER character (the double " mark is the accepted character) and separated by a simple comma (,). So, for example, you might get this: "SMITH, John","Burglar","Cell 30","","Pentonville Prison" *-----------* *-------* *-------* ** *------------------* (5 fields: the *---*'s are just for illustration) To let the program which will be reading this IN know what it all means, you can START the file with field NAMES, eg: "PERSON","OCCUPATION","ADDRESS-1","ADDRESS-2","ADDRESS-3" Armed with this information, a word-processor can do mail merge, or create other nicely formatted reports, by reading in the exported data and embedding it into a fixed layout of other text, etc. ---------------------------------------------------------- Normally there are no line breaks. But we give you the option. Likewise, you should never need to change the '"' delimiter character, but we give you that option too (just in case you have data with the characters "," imbedded in it, which might well confuse the receiving program). If exporting for mail-merge, you'll probably need to 'X' the "Include Field Names?" option, as explained above. When ready, click Export or type E (in the dialog box). To abort, just click or hit any key. ---------------------------------------------------------- There is no corresponding Import facility supplied (yet). Since most users are likely to be starting from scratch, and development time is not unlimited, and the format of data that COULD be imported is infinitely variable, it was not economic to include an Import function. One could easily be developed, however, and may have been. So if you want to import bulk data - contact us. ----------------------------------------------------------