@DATABASE "DBMSV1.0PL.guide"
@AUTHOR "Jakub Zalepa"
@WIDTH 40

@NODE Main ""

                     D B   M A N A G M E N T   S Y S T E M  v2.1                      

				     FREEWARE

			      (c) 1996 Simon/Maniacs


 				@{" Overview            " LINK Opis}
				@{" Idea                " LINK Koncepcja}
				@{" Instalation         " LINK Instalacja}
				@{" Legal Stuff         " LINK PrawaAutorskie}
				@{" Disclaimer          " LINK Disclaimer}
				@{" Manual              " LINK Instrukcja}
				@{" Prefs               " LINK Preferencje}
				@{" History             " LINK HIstoria}
				@{" Plans For Future    " LINK PlanyNaPrzyszîoôê}
				@{" Author              " LINK "Autor"}

@ENDNODE

@NODE "Opis"

	DBMS  is  pack  of  Arexx's scripts which can be used to manage bigger
  data bases,  generated  by  DB  by David Eckholm.  That scripts will do many 
  boring things instead you.

	I didn't  made it thinking about every data bases that can be made for 
  DB. This is for database, that I'm using to store information about many
  programs. 

	This pack contains:

	@{"DB_CopyContents" LINK CopyContentsDB}   - copies contents of previous record to next, but it
			     will be made only for selected fields.

	@{"DB_KonsolidujBazë" LINK KonsolidujBazëDB} - removes spces from names of programs, allow to save
			    some place on HD and simplify sorting.

	@{"DB_PokaûKategorie" LINK PokaûKategorieDB} - it's a little long, click to read details.

	@{"DB_ShowDataBase" LINK ShowDataBaseDB}  - exports  database,  but  only  records,  containing
			   infos about e.g.  newest programs  or  something you 
			   want.

        @{"DB_SzukajCiâgu" LINK SzukajCiâguDB}   - finds string in field 'Nazwa' and shows that, which
			    contains that string.

	@{"DB_SzukajAlternatywy" LINK SzukajAlternatywyDB} - finds  record  by  alternative  of  keys,   not
			       coniunction.

        @{"DB_OpusDB" LINK DB&OpusDB}            - select filename in Opus and order DB to find it
			       in database!

	@{"DB_Copy" LINK DBCopy}             - kopies record from one to another database.

	@{"DB_WyczyôêPola" LINK DBWyczyôêPola}      - clears all or selected fields in actual record.

	@{"DB_VisualInfo" LINK VisualInfo}	    - allow you to include gfx in database e.g. photos.
     
	@{"DB_CopyFilename2Realname.rexx" LINK CopyFilename} - copies data from one field, containing
					 datas about names of programs, to another.

@ENDNODE

@NODE "PrawaAutorskie"

  DB Managment System (c) Simon/Maniacs 1996
  DB (c) David Ekholm

	This product  is Freeware.  It means,  I give it away for personal use
  of everyone who wants to.  You can distribute it freely,  but in condition :
  no changes in original archive. 

	I'm not going  to  get fee for  it's distribution.  Other distributors
  may get small fee (costs of energy and media).

@ENDNODE

@NODE "Disclaimer"

	AUTHOR DOESN'T TAKE ANY RESPONSIBILITY  OF  ANY  DAMAGE CAUSED BY THIS 
  PRODUCT. IT IS GIVEN "AS-IS" WITH NO WARRANTIES. REMEMBER: YOU WERE  WARNED!

@ENDNODE

@NODE "Koncepcja"

	If you want to get all advantage of DBMS,  have  to accept my original
  ideo of the database,  which is independent of  same  DB  program.  It means
  standard model  of  database,  utilised to store informations about programs
  which are for example in your own collection.

	Now I explain construction of the database, field by field:

	Name            -  stores the name of program (or so on,  which are in
	(polish = Nazwa)   your database)
	 			  
	Description     - short description
	(polish = Opis) 

	Bytes           - bytes occupied by program
	(polish = Objëtoôê)

	Requirements    - no comments
	(polish = Wymagania) 

	HD              - can it be launched from HD?
	FD 		- can it be launched from FD?

	Category        - it is category to classify program
	(polish = Typ)		  

	Sub-Category    - it is second category to  classify program
        (polish = Rodzaj)    
					    
	Legal           - is the program Shareware, Freeware
	(polish = PrawaAutorskie)   
					    
	Documentation   - what language is documetation of program typed
	(polish = dokumentacja w jëzyku) 
							 
	Age             - This field means, if it is newest version of program
			  or not (in MY database,  in your  -  it may be other 
			  meaning). If it is newest version, this field MUST
			  be empty, if it is older version - this field MUST
			  contain sign like this: "*".

	Such a construction of database  is for only one purpose,  but you can
  use it for other one. It only depend on your invention! Look for section
  @{"Plans For Future" LINK PlanyNaPrzyszîoôê}.

	Most important function of the database is fast access to information.
  It's why I introduce fields Category and Sub-Category to database. Advantage
  of it - is faster searching through database and easier reading printed-out
  database. It is like directories and subdirectories.

@ENDNODE

@NODE "Instrukcja"

			@{" DB_CopyContents      " LINK CopyContentsDB}
			@{" DB_KonsolidujBazë    " LINK KonsolidujBazëDB}
		        @{" DB_PokaûKategorie    " LINK PokaûKategorieDB}
			@{" DB_ShowDataBase      " LINK ShowDataBaseDB}
		        @{" DB_SzukajCiâgu       " LINK SzukajCiâguDB}
			@{" DB_SzukajAlternatywy " LINK SzukajAlternatywyDB}
		        @{" DB_DOpus             " LINK DB&OpusDB}
			@{" DB_Copy              " LINK DBCopy}
			@{" DB_WyczyôêPola       " LINK DBWyczyôêPola}
			@{" DB_VisualInfo        " LINK VisualInfo}	

@ENDNODE

@NODE "CopyContentsDB"

	I COPY CONTENTS

	It's very simple script. It copies from previous record to next one
  contents of some fields (it depends of prefs settings). It's very useful
  proggy, you can avoid manual typing that fields which won't be change in
  next record.

@ENDNODE

@NODE "KOnsolidujBazëDB"
	
	II KONSOLIDUJ BAZË

	With this script, you can save some place in database.  It may be used
  to simplify sorting database. It cuts spaces from fields.  You know,  if the
  database contains for example fields like this:

	Ami Copy
	AmiCopy
	Ami  Copy

	then it is hard to searching for program by name, becouse you have few
  fields which contains  the  same  name,  but spaces causes searching  to  be 
  difficault.

	You can choose,  which fields will be scane by this script.  To do it, 
  you have  to  type  the names of fields  in  file  DBMS.prefs.  After  line:  
  "; Konsoliduj bazë"  you can select field  to compress and 3 strings,  which
  will be cut and string, will be insert instead of them.

	Example of preferences file is inculed in this package. 

@ENDNODE

@NODE "PokaûKategorieDB"

  III POKAÛ KATEGORIE

	This script converts DB database to amigaguide document or ACII file.
  This document or file will contain records from database sorted by category
  and in such category sorted by name. This document will be constructed like
  this:

		      Category ---
                                  I                  
                            	  --- Sub-category No 1    --- Description No 1
                            	  I                        I
                            	  --- Sub-category No 2    ------
                            	  I                        I
 	                          --- ..........           --- Description No 2
                                  I
                            	  --- Subcategory No n

	ASCII file will be like this:

	--------------------------------------
	- Category 1 - Sub-category
	--------------------------------------

        | name.1  | bytes.1    | description.1 | requirements.1 |
	.........................................................
	| nazwa.n | objëtoôê.n | opis.n        | wymagania.n    |

	--------------------------------------
	- Category.2 - Sub-category.2
	--------------------------------------	

	Etc.

	It can simplify look through database somebody,  who  don't close with 
  your base.  In addition  by this operation you can verify errors made by you
  when typed in categories.

@ENDNODE

@NODE "ShowDataBaseDB"

  IV SHOW DATA BASE

	It generate file, which contains only this records, which not contains
  sign:  "*"  i n "Age" field.  With this script you can simply eliminate from 
  database e.g. oldest versions of programs. Result file will be in RAM:.

@ENDNODE

@NODE "SzukajCiâguDB"

  V SZUKAJ CIÂGU

	It searching for gived string through 'Name' fields in database. (DB
  can find string only if field is starting from it, my script - always, if
  only field contain it) This string you have to type in mode 'Find'.

@ENDNODE

@NODE "SzukajAlternatywyDB"

  VI SZUKAJ ALTERNATYWY

	This script searching gived category of program through database, but
  shows that records, which contains category or sub-category or category and
  sub-category. Same DB, can't do it. First, you have to type something in
  mode 'Find' in 'Category' and (or) 'Sub-category' fields. For example, 
  database is like this:

	Name              I Description                                I Bytes    I Requirements I HD I FD I Category        I Sub-category         I Legal           I Documentation         I Age
        --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
	A1200HardFAQ	  I Pytania i odpowiedzi na temat budowy A1200 I 9K	  I	         I +  I +  I Akcesorium      I	Tekst	            I PD	      I Angielski             I 
	A1200HDConnerPatchI Usprawnienie HD Conner	               I 1K	  I OS2.0+       I +  I -  I Akcesorium      I	Elektronika         I                 I                       I
	A1200HDPatch	  I Usprawnienie pracy niektórych HD z A1200   I 12K	  I OS2.0+       I +  I +  I Akcesorium      I	Elektronika         I                 I                       I
	A1200ScreenFF1.0  I Poprawka                                   I 100K	  I OS2.0+       I +  I +  I Example         I	Flicker Fixer       I	PD            I                       I
 
	
	you typed  in  'Category' field:  'Akcesorium'  and  in 'Sub-category'
  field: 'Example'.  Then this script finds for you all fields from this short
  database. You can't make such searching with built-in DB functions.

@ENDNODE

@NODE "DB&OpusDB"

  VII DB & OPUS

	It makes communication DB with DOpus.  Simply select filename in Dopus
  and activate this script.  DB finds it  in  database  if  it  contain such a 
  filename.

@ENDNODE

@NODE "DBCopy"

  VIII DB COPY V1.0

	It copies contents of all fields in selected record from one database
  to another one. To do it, you must open two databases. Script will copy
  from first opened database to second opened one.

@ENDNODE

@NODE "DBWyczyôêPola"

  IX DB WYCZYÔÊ POLA V1.1	

	It clears all  or selected fields in actual record.  If not all fields
  you  want  to  clear,  you  have  to  type,   which  want  to  clear in file 
  "DBMS.prefs".

@ENDNODE

@NODE "VisualInfo"

  X DB VISUAL INFO V1.0

	It will make possible to include pics in database.  This pics you must
  copy to ONE directory, selected in prefs file. In database with graphics you
  must have two views:  "Techniczny" and "Zdjëcia" (like in example).  In view 
  named "Zdjëcia"  -  I make fields for name and description  of  pic  and two 
  categories for it.

	Second view, "Techniczny" is for names of pics.  Type in it real names
  and it's all you need to use this script.

@ENDNODE

@NODE "SplitDatabase"

  XI SPLIT DATABASE

	It splits database in two parts. One will contain only records match
  to pattern selected in  'Find' mode of DB.  From old database this records 
  will be cut.

@ENDNODE

@NODE "CopyFilename"

  XII COPY FILENAME TO REALNAME

	I had an idea of database, which contains two fields with datas about
  names of programs: one - named "Filename" and another - named "Real Name Of
  Program". It can simplify your movements through database.

@ENDNODE

@NODE "Autor"

	If you have any comments o suggestions, feel free to contact me:

   Jakub Zalepa
   Ul. Marysiïska 82/84 m5
   91-850 ÎÓDÚ
   tel./fax +48 (042) 573178
   modem    The Maniac's BBS! (8pm-8am) the same telephone
            Silver Dream's! BBS - here you can leave mail for me

@ENDNODE

@NODE "Preferencje"

	In actual version, all preferences can be set in one file, placed in
  directory "Sys:Prefs/" (file DBMS.prefs).

	In prefs, if any option is set this look like "SOMETHING = 1", else:
  "SOMETHING = 0". Ignore texts after signs ";". That are comments, acripts
  will ignore it to.

	And now, I explain how to prepare prefs file, but I think, example
  file should tell you everything:

		@{" Global            " LINK Global}
		@{" DB_KonsolidujBazë " LINK KonsolidujPrefs}
		@{" DB_WyczyôêPola    " LINK WyczyôêPrefs}
		@{" DB_PokaûKategorie " LINK PokaûKategoriePrefs}
		@{" DB_VisualInfo     " LINK VisualPrefs}
		@{" DB_SplitDatabase  " LINK SplitPrefs}	

@ENDNODE

@NODE "SplitPrefs"

	; Split Database
	Ram:Baza - it is path to result database.

@ENDNODE

@NODE "Global"

	This preferences are for all scripts. Today only one:

	; Global
	ENGLI = 0 - 0 = enabled, 1 - disabled.

@ENDNODE

@NODE "KonsolidujPrefs"

	Here type names of fields:

	; Konsoliduj Bazë
	FCHNG = Objëtoôê - field to compress
	CHNG1 = dysk     - first string to be cut
	CHNG2 = ów       - second string to be cut
	CHNG3 = i        - third string to be cut
	CHNGT = d        - string to insert instead of them
	                 - empty line or ALL if all fields must be compressed
	Nazwa
	Wymagania
	Objëtoôê
	Archiwum
	Typ
	Rodzaj

@ENDNODE

@NODE "WyczyôêPrefs"

	; Wyczyôê Pola
	ALL - if all fields you want to clear, else don't mention it, but then
	      it can't be "ALL".
 
	Nazwa
	Opis

	After "ALL" are names of fields, which  you want to clear,  if not all
  you want to clear.

@ENDNODE

@NODE "PokaûKategoriePrefs"
	
	; Pokaû kategorie
	GUIDE = 1 - 1 = script will generate amigaguide, 0 = ASCII.

	CHECK = 0 - verify categories every launch or not.

	FIELD = 0 - verify bames of kategories or not.

	GPTCH = Ram:T/Baza.guide - path for amigaguide.

	TPTCH = Ram:T/Baza.txt - path for ASCII.

@ENDNODE

@NODE "VisualPrefs"

	; Visual Info
	VPTCH = SYS:Utilities/MultiView WINDOW - path for pic viever.

	GPTCH = DH1:New/ - path to directory, you store pics.

@ENDNODE

@NODE "Instalacja"

	It's simple.  Copy all files  to  same directories such  in archive to 
  same directories in your system. After it, add to database following line:

	name [tab] name [tab] <- here is start of your database
        RFF=1.1,TYPE=RXMENU [tab] RXFILE=sys:Arexx/DB_CopyContents.rexx,NAME="Skopiuj poprzednie" [tab] RXFILE=sys:Arexx/DB_KonsolidujBazë.rexx,NAME=Konsolidacja [tab] RXFILE=sys:Arexx/DB_ShowDataBase.rexx,NAME=Wyrzuê_New [tab] RXFILE=sys:Arexx/DB_WyczyôêPola.rexx,NAME="Wyczyôê pola" [tab] RXFILE=sys:Arexx/DB&DOpusDB.rexx,NAME=Talk2DOpus [Tab] RXFILE=sys:Arexx/DB_PokaûKategorie.rexx,NAME="Pokaû Kategorie" [tab] RXFILE=sys:Arexx/DB_SzukajAlternatywnych.rexx,NAME="Szukaj Alternatywnych" [tab] RXFILE=sys:Arexx/DB_SzukajCiâgu.rexx,NAME="Szukaj Ciâgu" [tab] RXFILE=sys:Arexx/DB_Copy.rexx,NAME="Kopiuj"

	Add to start of this line sign like this "@".

@ENDNODE

@NODE "Historia"

	- V1.0 12/09/96 - first public version.
	- V1.1          - fixed script DB_ShowDataBase,  now it can be started
		 	  when  mode  'Find'   is  on.  Added  reguester  with 
			  question about start  or  not this script. Added new 
			  script  DB_Copy.   Changed  DB_KonsolidujBazë, added
			  prefs  to  it.  Added new script DB_WyczyôêPola  and 
			  prefs for it.

	- V2.0 01/10/96 - fixed script DB_PokaûKategorie.  I added  option  to
			  export database  as amigaguide and  as text .  Added
  			  prefs  to it.  I made new script DB_VisualInfo.  All
			  scripts are now optimized.

	- V2.1		- added  new  script DB_SplitDataBase,   which  is for 
			  splitting databases. Changed script DB_CopyContents.
		          Now you can  set  in  prefs file,  which fields want 
			  to copy. Bugfixed script "DB_PokaûKategorie", which
                          didn't formatted report well.

	- V2.2 20/12/96 - added new script, named "DB_CopyFileName2RealName".

@ENDNODE

@NODE "PlanyNaPrzyszîoôê"

	- make scripts faster. It means - rewrite them in asm.

	- searching any fields for string.

	- show pic as soon as you go to record.

	- DB with DBM  is  slow.  I plan  to  make  my  own database with this
	  features built in.

@ENDNODE