1

Topic: Import wizard

When importing spreadsheet data via the Wizard is it possible to populate the Administrative Areas tab in Geo Info for the location when a new location is created? If not could the Import wizard code be modified to do that?

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

2

Re: Import wizard

Hi

It depends a bit on what you are expecting.  Are you thinking that the Admin Area would be automatically populated based on the location spatial ref, or were you thinking of providing the Admin Area  in the import file ?  If your location is already an Admin area then it can be imported now.

Mike Weideli

3

Re: Import wizard

Basically, if I have a spreadsheet of records to import via the Wizard, with locations and an Admin Area (or VC number) included in the import file, when I get to the matching stage with locations and I have to create a new location, I want the newly-created location to include the VC in the Geo Info tab. The reason for this is that I need to produce a county checklist with separate VC columns (using the report that you did for me some years ago which relies on the location having a VC field populated in the Geo Info tab).
Vice-county number appears in the Column type selection list but when VC is included in the import file and a new location created at the matching stage, Admin Area in the Locations/Geo Info tab remains empty.

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

4

Re: Import wizard

Thanks.  Understood. If we include a new field say  Location Vice County and make this a new Import Wizard columns  then when a new Location is created it would add this as the VC. Would the VC number be Ok or would the name or both be better ? . I will investigate to see if it can be done just with database entries (ie without a  change to core R6). If it can I will give it  go.

Mike Weideli