6.9 External display of features - LUPMISManual

Go to content

Main menu:

6. Presentation

6.9 External Display of Features

Level of expertise required for this Chapter: Advanced; general Map Maker training


There are various ways to display additional information on-screen - beside the map display (see  Chapter 1.2).


6.9.1 Retrieve Database Information

Information of the database (attribute data) can be retrieved either in tabular form, when clicking on the unit, or as a thematic, coloured map. The procedures are explained in  Chapter 4.3.


6.9.2 Link to External Documents

It is possible to link an external document, which refers to a geographical unit, and have a specific document displayed, when clicking on the unit. An ‘external document’ can be a Word document, a graphic file, a
PDF file or similar, including the possibility to edit the document after being loaded.

For example, when clicking on a parcel, LUPMIS will then show the application form, the permit issued (see  Chapter 8.4 for Permit Tools), a photograph or similar.


Currently, it is possible to have following data of the
DRA file as references:

  • id

  • style

  • label


The item in the id, style or label field must have an equivalent file name (without extension). For parcel references, the easiest is to have the UPN (see Chapter 7.7.1) as the display label and files with the file name of the UPN.

In the Project manager window: Select the layer (1, see below) > Data link (2) > On-hit (3) > Tick ‘Make layer hit-able’ (4) > Document or link (5) > Link layer (6) > EXE (7) > Change Program > Select folder and file of program (8, see table below for some program examples, others are possible) > Send parameters: Specify path, data field in parentheses (<>) and extension (9, see examples below), all in double quotations) > OK (10)



You will have to select the Data-tool on the toolbar left (11) and click on the unit of interest.

Examples of calling programs (step
8):


Program

Program file

For display of:

MS Office Picture Manager

C:\Program Files\Microsoft Office\Office12\OIS.EXE

For graphic files: JPG, BMP, TIF etc

MS Word

C:\Program Files\Microsoft Office\Office12\WINWORD.EXE

For Word documents (DOC, DOCX)

Adobe Acrobat Reader

C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe

For PDF documents (PDF)

MS Excel

C:\Program Files\Microsoft Office\Office12\EXCEL.EXE

For Excel spreadsheets (XLS, XLSX)


Examples of the command line entry (step 9, observe the double quotations):
“C:\LUPMIS\Permits\Kasoa_Permits\<label>.jpg”
“C:\LUPMIS\Permits\Ejisu_Permits\<style>.docx”
“C:\LUPMIS\Temp\<id>.pdf”


The location (path) of the program file might be different due to different installations and operating systems.

After you have set up the link reference, you better save it as a project
(Main menu > File > Save project as), because any copying to the live layer or temporary other hit-definitions will delete the original link reference.

See also Annex 17.3 for examples.

- - - - -


Alternatively, you can call a macro in MS Access, even without the Change Program selection with following syntax:
<access> "Databasefile.mdb" /x Macro1 /cmd "<id>"

For example:
<access> "C:\LUPMIS\Permits\Kasoa_Permits.mdb" /x Macro1 /cmd "<id>"



- - - - -


Alternatively, MS Access data can be called through an Access form (active, if an MDB file has been loaded):
Project manager > Data link > Database > Choose database > File type: MDB > Select folder and file > Open > Choose Access table window: Select table > OK > On hit > Tick ‘Make layer hit-able’ > Database > Use Access form > Select form > Select id field (reference in form) > OK




  


 
Back to content | Back to main menu