Changes for page YellowFox Geocoder

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

Summary

Details

Page properties
Content
... ... @@ -1,24 +1,16 @@
1 1  (% class="box" %)
2 -(((
3 -Table of Contents
4 -)))
5 -
2 +(((Table of Contents)))
6 6  {{toc/}}
7 7  
8 -= YellowFox Geocoder =
9 -
5 +=== YellowFox Geocoder [Original Seitentitel] ===
10 10  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 -
12 12  = program start =
13 -
14 14  After the start of "YellowFox Geocoder", the program is searching for new updates. 
15 15  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. 
16 16  Immediately the status bar displayed "ready", the starting proccess is done and you will seen approximately following window.
17 17  
18 - [[image:Mainwindow.jpg]]
19 -
12 + [[image:Mainwindow.jpg]]
20 20  = main menu =
21 -
22 22  (((
23 23  * File(((
24 24  * new project - creates a new project
... ... @@ -45,36 +45,24 @@
45 45  * about - information window of YellowFox Geocoder
46 46  )))
47 47  )))
48 -
49 49  = functions =
50 -
51 51  == new project ==
52 -
53 53  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. 
54 54  With the button "reload table" you will open the empty table and you are now able to insert new records.
55 -
56 56  == new update ==
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 -
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
60 60  == import csv file ==
61 -
62 62  In this dialog you set the attributes of the csv file you will imprt. It is divided into 6 steps.
63 -
64 64  === 1st step ===
65 -
66 66  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 -
68 68  === 2nd step ===
69 -
70 70  properties of the csv file:
71 -
72 72  (((
73 73  * seperator: Is the character, which seperates the single columns of the csv file.(((
74 74  * tabulator (<TAB>)
75 75  * comma (,)
76 76  * semicolon (;)
77 -* tilde ()
57 +* tilde (~)
78 78  * pipe (|)
79 79  * space (<SPC>)
80 80  )))
... ... @@ -87,63 +87,40 @@
87 87  
88 88  * sort field names - the field names of the import file will be sortet alphabeticly
89 89  )))
90 -
91 91  === 3rd step ===
92 -
93 93  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 -
95 95  === 4th step ===
96 -
97 97  In this step you will allocate the fields of the csv file to the fields of the YellowFox database.
98 98  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 -
100 100  === 5th step ===
101 -
102 102  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.
103 -reaction if a doublet was found:
104 -
77 +reaction if a doublet was found: 
105 105  (((
106 106  * Doublet: checks if the record already exists (checks for name1, name2, city, postcode, country, street, house number and position description)
107 107  )))
108 -
109 109  What kind of reaction do you want to proceed if a doublet was found?
110 -
111 111  (((
112 112  * 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.
113 113  * add doublet: Although a doublet was found, it will be added to the project
114 114  * discard doublet: If a doublet was found, the record will be discard. No additional insert into the project database.
115 115  )))
116 -
117 117  === 6th step ===
118 -
119 119  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.
120 120  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 -
122 122  == access code ==
123 -
124 124  === portal ===
125 125  
126 126  You will find the rti access codes in the extras menu RTI (interface)
127 -
128 128  === rti - company key ===
129 -
130 130  Is the authorization code from company.
131 -
132 132  === rti - import key ===
133 -
134 134  Is the authorization code from import.
135 -
136 136  === validation ===
137 -
138 138  The entered key pair will be checked.
139 -
140 140  == delete portal address database ==
141 -
142 142  Attention, this process can not be reversed!
143 143  All records from the address database in the portal will be deleted.
144 -
145 145  == language selection ==
146 -
147 147  (((
148 148  * available languages:(((
149 149  * German
... ... @@ -150,19 +150,13 @@
150 150  * English
151 151  )))
152 152  )))
153 -
154 154  The requested language can be selected in the menu under settings ~-~-> language.
155 -
156 156  == about ==
157 -
158 158  In this information window you get informations about the YellowFox Geocoder.
159 159  
160 160  = table =
161 -
162 -The table conatins all address entries, which are in the project database.
163 -
115 +The table conatins all address entries, which are in the project database. 
164 164  == structure ==
165 -
166 166  |=column name|=description|=format
167 167  |ID|continous id number|number (automatic)
168 168  |company|company description 1|text (max. 100 characters)
... ... @@ -181,10 +181,8 @@
181 181  |Online|address is transmitted|number (1/0) (not editable)
182 182  
183 183  == views ==
184 -
185 185  The view can be specialised by predefined filter values.
186 186  following data views are available:
187 -
188 188  (((
189 189  * show all
190 190  * only geocoded
... ... @@ -195,20 +195,13 @@
195 195  * not yet transmitted
196 196  * with certain content (selfdefinable filter for company/postcode/city/country/street/position description)
197 197  )))
198 -
199 199  == edit record ==
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 -
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.  
203 203  == delete displayed ==
204 -
205 205  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 -
207 207  == find address of displayed ==
208 -
209 209  With this function the geocoder will find the address values (street, hnr, city...) by the given coordinates (reverse geocoding).
210 -result colours**:**
211 -
153 +****result colours**:**
212 212  (((
213 213  * white: not yet geocoded
214 214  * green: already geocoded (1 address allocation)
... ... @@ -215,12 +215,9 @@
215 215  * beige: to edit (more than 1 possible address allocations)
216 216  * red: failing geocoded (no address allocation found)
217 217  )))
218 -
219 219  == geocode displayed ==
220 -
221 221  With this function you try to geocode all displayed records. If you want to change the displayed view, use the filter option 'data view'. 
222 222  **result colours:**
223 -
224 224  (((
225 225  * white: not yet geocoded
226 226  * green: already geocoded (1 address allocation)
... ... @@ -227,22 +227,14 @@
227 227  * beige: to edit (more than 1 possible address allocations)
228 228  * red: failing geocoded (no address allocation found)
229 229  )))
230 -
231 231  == use given coordinates ==
232 -
233 233  If the imported material contains longitude and latitude values alreay, you can use them without any further processing needed.
234 -
235 235  == transmit displayed ==
236 -
237 237  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 -
239 239  = failing geocoding =
240 -
241 241  possible reasons for an failing geocoding:
242 -
243 243  (((
244 244  * unknown country code (([[list of country codes>>http://en.wikipedia.org/wiki/List_of_international_vehicle_registration_codes]]))
245 245  * literal error in address submission
246 246  )))
247 -
248 248