Changes for page YellowFox Geocoder

Last modified by YellowFox_RD on 2025/01/20 13:52
From version 1.1
edited by YellowFox_RD
on 2024/12/19 10:12
Change comment: Imported from XAR
To version 2.1
edited by YellowFox_RD
on 2025/01/20 13:52
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,16 +1,24 @@
1 1  (% class="box" %)
2 -(((Table of Contents)))
2 +(((
3 +Table of Contents
4 +)))
5 +
3 3  {{toc/}}
4 4  
5 -=== YellowFox Geocoder [Original Seitentitel] ===
8 += YellowFox Geocoder =
9 +
6 6  This tool is designed as an import assistant to convert your preliminary database into your yellowfox portal address database. CSV files will be supported. The converted and self entried records can be previously geocoded.
11 +
7 7  = program start =
13 +
8 8  After the start of "YellowFox Geocoder", the program is searching for new updates. 
9 9  This procedure can take up to 1 minute, depending on your internet connection. If no new updates was found, the program is checking if you entered rti access codes.If you have ever started this tool and you not closed your previous project, the tool will starting this one. 
10 10  Immediately the status bar displayed "ready", the starting proccess is done and you will seen approximately following window.
11 11  
12 - [[image:Mainwindow.jpg]]
18 + [[image:Mainwindow.jpg]]
19 +
13 13  = main menu =
21 +
14 14  (((
15 15  * File(((
16 16  * new project - creates a new project
... ... @@ -37,24 +37,36 @@
37 37  * about - information window of YellowFox Geocoder
38 38  )))
39 39  )))
48 +
40 40  = functions =
50 +
41 41  == new project ==
52 +
42 42  To create a new project, just enter the wanted name of the project into the text box and click "ok". The YellowFox Geocoder will create an new project automaticly. 
43 43  With the button "reload table" you will open the empty table and you are now able to insert new records.
55 +
44 44  == new update ==
45 -After every program start and on every click in the menu extras ~-~-> "searching for new updates..." an update check will be procceded. If a new update is available, you will be informed about the current and the available version. If you want to procced the update, please click "yes" otherwise "no". **Not installing available updates may cause malfunction up to destroying your address database. **While the update is running the YellowFox Geocoder close himself, download the new update and restart
57 +
58 +After every program start and on every click in the menu extras ~-~-> "searching for new updates..." an update check will be procceded. If a new update is available, you will be informed about the current and the available version. If you want to procced the update, please click "yes" otherwise "no". **Not installing available updates may cause malfunction up to destroying your address database. **While the update is running the YellowFox Geocoder close himself, download the new update and restart
59 +
46 46  == import csv file ==
61 +
47 47  In this dialog you set the attributes of the csv file you will imprt. It is divided into 6 steps.
63 +
48 48  === 1st step ===
65 +
49 49  Source file selection. Click on "open" and select the file you want to import. The path including the filename will be shown in the textbox of step 1.
67 +
50 50  === 2nd step ===
69 +
51 51  properties of the csv file:
71 +
52 52  (((
53 53  * seperator: Is the character, which seperates the single columns of the csv file.(((
54 54  * tabulator (<TAB>)
55 55  * comma (,)
56 56  * semicolon (;)
57 -* tilde (~)
77 +* tilde ()
58 58  * pipe (|)
59 59  * space (<SPC>)
60 60  )))
... ... @@ -67,40 +67,63 @@
67 67  
68 68  * sort field names - the field names of the import file will be sortet alphabeticly
69 69  )))
90 +
70 70  === 3rd step ===
92 +
71 71  Check the import file - at this step the settings which you have selected will be checked. Additionally the field names of the csv file will be added to the selection fields.
94 +
72 72  === 4th step ===
96 +
73 73  In this step you will allocate the fields of the csv file to the fields of the YellowFox database.
74 74  In the textbox default value, you can input default text. You can yhoose, when they will be used. Whether only if there is nothing inputed into the field or always.
99 +
75 75  === 5th step ===
101 +
76 76  At this option group you can select between delete all records from the temporaray YellowFox Geocoder database and add the records you want to import to the temporary database.
77 -reaction if a doublet was found: 
103 +reaction if a doublet was found:
104 +
78 78  (((
79 79  * Doublet: checks if the record already exists (checks for name1, name2, city, postcode, country, street, house number and position description)
80 80  )))
108 +
81 81  What kind of reaction do you want to proceed if a doublet was found?
110 +
82 82  (((
83 83  * ask: If a doublet was found, you will be asked, what you will do. Do yout want to add this record or do you want to discard them.
84 84  * add doublet: Although a doublet was found, it will be added to the project
85 85  * discard doublet: If a doublet was found, the record will be discard. No additional insert into the project database.
86 86  )))
116 +
87 87  === 6th step ===
118 +
88 88  A click on "import start" the import procedure will be starting. A click on " close" will close the dialog and you will go back to the main window.
89 89  While the import process you will be informed in the status bar, how many records have been imported yet. Immediately the import procedure has been completed, you will be informed how many records toal have been imported.
121 +
90 90  == access code ==
123 +
91 91  === portal ===
92 92  
93 93  You will find the rti access codes in the extras menu RTI (interface)
127 +
94 94  === rti - company key ===
129 +
95 95  Is the authorization code from company.
131 +
96 96  === rti - import key ===
133 +
97 97  Is the authorization code from import.
135 +
98 98  === validation ===
137 +
99 99  The entered key pair will be checked.
139 +
100 100  == delete portal address database ==
141 +
101 101  Attention, this process can not be reversed!
102 102  All records from the address database in the portal will be deleted.
144 +
103 103  == language selection ==
146 +
104 104  (((
105 105  * available languages:(((
106 106  * German
... ... @@ -107,13 +107,19 @@
107 107  * English
108 108  )))
109 109  )))
153 +
110 110  The requested language can be selected in the menu under settings ~-~-> language.
155 +
111 111  == about ==
157 +
112 112  In this information window you get informations about the YellowFox Geocoder.
113 113  
114 114  = table =
115 -The table conatins all address entries, which are in the project database. 
161 +
162 +The table conatins all address entries, which are in the project database.
163 +
116 116  == structure ==
165 +
117 117  |=column name|=description|=format
118 118  |ID|continous id number|number (automatic)
119 119  |company|company description 1|text (max. 100 characters)
... ... @@ -132,8 +132,10 @@
132 132  |Online|address is transmitted|number (1/0) (not editable)
133 133  
134 134  == views ==
184 +
135 135  The view can be specialised by predefined filter values.
136 136  following data views are available:
187 +
137 137  (((
138 138  * show all
139 139  * only geocoded
... ... @@ -144,13 +144,20 @@
144 144  * not yet transmitted
145 145  * with certain content (selfdefinable filter for company/postcode/city/country/street/position description)
146 146  )))
198 +
147 147  == edit record ==
148 -If you want to edit a record, you must check this one. After that, input the favoured value into the cell. If you want to cancel your input press the key 'ESC'. To save the record uncheck thisone or check another cell. Inside the table you can navigate with mouse and the arrow keys of your keyboard. To change the value of 'on map' you must check this cell and press the 'SPACE' key or click into the selection box with the mouse arrow. The addresses which are already geocoded, but with the comment 'to edit'(beige background), has found more than one possible geocode address. To select which address you will allocate to this entry, right-click on the record and select 'to edit'. A selective-dialog will be shown (see picture), there you can select the wanted address you will allocate. By using the button GoogleEarth you can view the addresses in GoogleEarth. You need a working installation of GoogleEarth to use this feature.  
200 +
201 +If you want to edit a record, you must check this one. After that, input the favoured value into the cell. If you want to cancel your input press the key 'ESC'. To save the record uncheck thisone or check another cell. Inside the table you can navigate with mouse and the arrow keys of your keyboard. To change the value of 'on map' you must check this cell and press the 'SPACE' key or click into the selection box with the mouse arrow. The addresses which are already geocoded, but with the comment 'to edit'(beige background), has found more than one possible geocode address. To select which address you will allocate to this entry, right-click on the record and select 'to edit'. A selective-dialog will be shown (see picture), there you can select the wanted address you will allocate. By using the button GoogleEarth you can view the addresses in GoogleEarth. You need a working installation of GoogleEarth to use this feature. 
202 +
149 149  == delete displayed ==
204 +
150 150  With this option you celete all displayed records from the project database. To change the data view, you only must change the filter. If you want to delete only one record, just right-click them and select 'delete record'.
206 +
151 151  == find address of displayed ==
208 +
152 152  With this function the geocoder will find the address values (street, hnr, city...) by the given coordinates (reverse geocoding).
153 -****result colours**:**
210 +result colours**:**
211 +
154 154  (((
155 155  * white: not yet geocoded
156 156  * green: already geocoded (1 address allocation)
... ... @@ -157,9 +157,12 @@
157 157  * beige: to edit (more than 1 possible address allocations)
158 158  * red: failing geocoded (no address allocation found)
159 159  )))
218 +
160 160  == geocode displayed ==
220 +
161 161  With this function you try to geocode all displayed records. If you want to change the displayed view, use the filter option 'data view'. 
162 162  **result colours:**
223 +
163 163  (((
164 164  * white: not yet geocoded
165 165  * green: already geocoded (1 address allocation)
... ... @@ -166,14 +166,22 @@
166 166  * beige: to edit (more than 1 possible address allocations)
167 167  * red: failing geocoded (no address allocation found)
168 168  )))
230 +
169 169  == use given coordinates ==
232 +
170 170  If the imported material contains longitude and latitude values alreay, you can use them without any further processing needed.
234 +
171 171  == transmit displayed ==
236 +
172 172  With this function you try to send all displayed records to the portal address database. All successful transmitted records have a '1' in the column 'online'. Only these records will be shown the data view filter 'already transmitted'.
238 +
173 173  = failing geocoding =
240 +
174 174  possible reasons for an failing geocoding:
242 +
175 175  (((
176 176  * unknown country code (([[list of country codes>>http://en.wikipedia.org/wiki/List_of_international_vehicle_registration_codes]]))
177 177  * literal error in address submission
178 178  )))
247 +
179 179