SLIDE 1
My paper
Classification basics
Classification basics Preparing classification lookup files Deployment of lookup files Version control Management system for lookup files Some special issues Some special issues
Management of Classification Lookup Files The basics of - - PowerPoint PPT Presentation
Management of Classification Lookup Files The basics of - - PowerPoint PPT Presentation
Management of Classification Lookup Files The basics of classification The basics of classification and more Fred Wensing fred wensing@softscape net au fred.wensing@softscape.net.au My paper Classification basics Classification basics
SLIDE 2
SLIDE 3
Thi t ti This presentation
Not enough time to cover everything
Not enough time to cover everything So will cover
– Preparation of lookup files – Version control – Deployment – Lookup File management system (Demo) S – Some special issues
SLIDE 4
P ti f l k fil Preparation of lookup files
Use of a classification consider
Use of a classification - consider
– Hierarchical Si l – Simple
Which entries to put in
– Basic entries – Synonyms
Types of indexes to provide
– Alpha – Trigram
SLIDE 5
P ti f l k fil Preparation of lookup files
Adding and retrieving other fields
Adding and retrieving other fields
– Proper description C d b – Code number – Weight
Add i l t i
Add special entries
– System entries like DELETE
SLIDE 6
P ti t ti fi Preparation – punctuation fixes
PROCEDURE proc_FixString PARAMETERS IMPORT OldText : STRING IMPORT OldText : STRING EXPORT NewText : STRING INSTRUCTIONS NewText := OldText NewText : OldText NewText := REPLACE(NewText,',',' ,') NewText := REPLACE(NewText,'(','( ') NewText := REPLACE(NewText ')' ' )') NewText := REPLACE(NewText, ) , ) ) NewText := REPLACE(NewText,':',' :') NewText := REPLACE(NewText,'/',' / ') ENDPROCEDURE ENDPROCEDURE
SLIDE 7
P ti L /Kbd fi Preparation – Lang/Kbd fixes
Fi f S i h t h t Fixes for Spanish accent characters
... NewText := REPLACE(NewText,'Ñ','N') NewText := REPLACE(NewText,'ñ','n') NewText := REPLACE(NewText,'á','a') NewText := REPLACE(NewText,'é','e') NewText := REPLACE(NewText,'í','i') NewText := REPLACE(NewText,'ó','o') NewText := REPLACE(NewText,'ú','u') ENDPROCEDURE
SLIDE 8
P ti dd C d b Preparation – add Code number
For coders who know the code numbers For checking the list
For checking the list
SearchString := Description+' '+Activity_Code
SLIDE 9
Deployment of lookup files p y p
Distributed computer deployment
Distributed computer deployment
– In the survey folder I ll l f ld – In a parallel folder
Network system
– Local folder (on user's computer) is best – Search path passed in calls to DEP via BCF (or INI file) via BCF (or INI file)
SLIDE 10
V i t l Version control
Version number in name Version number in name
eg: Countrylist_1_021 – Shared coder – Infrequent change – Historical – old and new available
Version number in folder name
\ \ \ eg: C:\DATA\PARCoder\Version_3_013 – Search path set in system (to match version)
SLIDE 11
Management system for Lookup files
Demo!
SLIDE 12
Some special issues
SLIDE 13
R f hi h Refreshing searches
Make sure to use CHECKRULESUNCHANGED Make sure to use CHECKRULESUNCHANGED
USES MyModel 'LFS98' UPDATEFILE Lfs: MyModel ('lfsdata', BLAISE) SETTINGS CHECKRULES = YES CHECKRULESUNCHANGED = YES MANIPULATE Lfs.WRITE
SLIDE 14
N t l i d t Not losing data
Use use a KEEP Use use a KEEP
IF ExternalList.SEARCH(Country_of_birth) THEN ExternalList.READ C t C d E t lLi t C t C d Country_Code:=ExternalList.CountryCode ELSE Country_Code.KEEP ENDIF
SLIDE 15
U f ASCII f ll l k Use of ASCII for small lookups
Data is loaded to memory (fast) Data is loaded to memory (fast) Easy to replace/update Trigram is not available
USES Citylist 'Citylist' EXTERNALS ExternalList : EXTERNALS ExternalList : CityList('Cities.csv',ASCII(SEPARATOR=',')
SLIDE 16
Finally
Read the paper for details Check the online assistant for other
information
Ask questions in the Blaise User