FieldStudiesCouncil / QGIS-Biological-Recording-Tools

QGIS plugin for biological recorders. Created with the FSC Tomorrow's Biodiversity project.
GNU General Public License v3.0
10 stars 4 forks source link

inactive / empty fields for Lat/Lon #40

Closed pnef75 closed 3 years ago

pnef75 commented 5 years ago

Hi Rich! Trying to use TomBio tools module for my scientific purposes, I faced with a problem concerning inactive or empty fields for X and Y columns, as well as for OS GridRef Column. I suspect it may depends on my csv file format, that might be wrong... I tried csv files containing 3 columns (Location, Latitude, Longitude) or only 2 columns (Latitude, Longitude) without any text strings - only 2 columns of figures. Anyway results were the same: I can't choose X and Y columns for coordinates - these fields are unable to be chosen. What should I do? Please, give me a clue how solve this puzzle. Thanks in advance! Best wishes, Pavel

burkmarr commented 5 years ago

Hello Pavel. Can you tell me what version of QGIS and what version of the plugin you are using? (Note that you can't select both GridRef column and X/Y columns together - this is by design.)

Rich

pnef75 commented 5 years ago

Hello Rich, I tried different versions of QGIS and installed the plugin proposed in the QGIS menu. Now I have several versions of QGIS at the same time. The list of them is given below: (1) QGIS 3.6.1-Noosa with TBT 3.2.2; (2) QGIS 3.4.4-Madeira with TBT 3.2.2; (3) QGIS 3.0.0-Girona with proposed ver. of TBT 3.2.2 - ERROR during installation: error ver. 3.2.2 in QGIS 3.0.0.docx (4) QGIS 2.0.1-Dufour with proposed ver. of TBT 2.0.9 - ERROR during installation: error ver. 2.0.9 in QGIS 2.0.1.docx (5) QGIS 2.12.3-Lyon with TBT 2.8.0 Best wishes, Pavel

burkmarr commented 5 years ago

Okay so I guess that you are experiencing the problem with QGIS 3.6.1-Noosa with TBT 3.2.2 - the latest of both QGIS and the tools. I need to reproduce your problem in order to understand it. Can you send me a cut-down CSV that demonstrates your problem? No need to send a lot of data, just a few rows to demonstrate your problem. Send it to rburkmar@ceh.ac.uk.

pnef75 commented 5 years ago

Thank you for quick reply! I have sent 2 files as an example to the e-mail you wrote.

burkmarr commented 5 years ago

I think that the problem arises from the fact that the field delimiters in the CSV files are semi-colons rather than commas:

Location No.;Lat;Lon 1;54.731448;84.747212

Opening the CSV files through the Biological Records tool doesn't doesn't cope - it expects commas. So easiest solution is to open your files by another method. You can either open them by using the QGIS Browser panel or by the 'delimited text' tab on the Data Source Manager browser (setting the 'custom delimiter' to semi-colon). If you use the Browser panel you will find that the easiest method by far - it seems to automatically detect that the CSV has the semi-colon delimiters.

Once open, you can select the CSV layer from the drop-down Source layer list in the Biological Records tool in the usual way and then set X column to Lon and Y column to Lat, your input CRS appropriately (I used EBPSG:4326 - WGS 84) and it all works.

pnef75 commented 5 years ago

Good morning Rich, thank you for your response!

As I thought the point is in the format of my CSV files - delimiters are semi-lonols instead of commas, expected in BR tools. But I save my CSV files in Excel with standart options - "Save as..." => CVS files (commas - delimiters)... I don't select any semi-colons in settings...

Anyway my CSV files are suitable for any versions of QGIS installed on my notebook - all files are opened without any troubles and I can see species locations as points on a map.

If I choose Data Source Manager browser and try to open any CSV file, I see in the menu File Format that QGIS automatically selects "Other delimiters" => semi-colons... And if I reselect "Commas (CSV)", I can't add the data, because the button "Add" is inactive. I tried to show it in screenshots (see attachment).

If I open my CSV file and see the points on the map, than try to select the CSV layer from the drop-down Source layer list in the Biological Records tool, as you wrote, neither OS Grid Ref Column nor X/Y columns become active. I can't select the column I need.

The problem is still persues me...((

Automatically the settings for CSV are as given below.docx

pnef75 commented 5 years ago

Good morning Rich, thank you for your response!

As I thought the point is in the format of my CSV files - delimiters are semi-lonols instead of commas, expected in BR tools. But I save my CSV files in Excel with standart options -  "Save as..." => CVS files (commas - delimiters)... I don't select any semi-colons in settings...

Anyway my CSV files are suitable for any versions of QGIS installed on my notebook - all files are opened without any troubles and I can see species locations as points on a map.

If I choose Data Source Manager browser and try to open any CSV file, I see in the menu File Format that QGIS automatically selects "Other delimiters" => semi-colons... And if I reselect "Commas (CSV)", I can't add the data, because the button "Add" is inactive. I tried to show it in screenshots (see attachment).

If I open my CSV file and see the points on the map, than try to select the CSV layer from the drop-down Source layer list in the Biological Records tool, as you wrote, neither OS Grid Ref Column nor X/Y columns become active. I can't select the column I need.

The problem is still persues me...((

Best wishes, Pavel

Вторник, 16 апреля 2019, 18:09 +07:00 от Rich Burkmar notifications@github.com:

I think that the problem arises from the fact that the field delimiters in the CSV files are semi-colons rather than commas: Location No.;Lat;Lon 1;54.731448;84.747212 Opening the CSV files through the Biological Records tool doesn't doesn't cope - it expects commas. So easiest solution is to open your files by another method. You can either open them by using the QGIS Browser panel or by the 'delimited text' tab on the Data Source Manager browser (setting the 'custom delimiter' to semi-colon). If you use the Browser panel you will find that the easiest method by far - it seems to automatically detect that the CSV has the semi-colon delimiters. Once open, you can select the CSV layer from the drop-down Source layer list in the Biological Records tool in the usual way and then set X column to Lon and Y column to Lat, your input CRS appropriately (I used EBPSG:4326 - WGS 84) and it all works. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

burkmarr commented 5 years ago

Hi Pavel,

Now I understand. You are opening your CSV file in QGIS in a way that allows QGIS to interpret the lat/lon locations and create points on the map. When you select a layer in the BR tool that already has points on the map (whether Shapefile, CSV or whatever), then the BR tool doesn't need you to specify either a grid reference field or x/y fields because QGIS already has the geometry! So it makes those selection boxes inactive, but you can go ahead and use the tool anyway, e.g. to create an aggregate map.

For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal.

The way I was using it before was to open your CSV without getting QGIS to create the points. Then the X/Y drop-downs in the BR tool are enabled and I can use it that way.

You can work either way - the results will be identical.

Rich

pnef75 commented 5 years ago

Hi Rich!

While I was waiting for your answer, I went on the other way to solve the problem with comma as a delimitation instead of a semilocon in CSV-format. Some people were faced with the same problem many years ago ( https://www.mrexcel.com/forum/excel-questions/439562-exporting-csv-format-using-comma-instead-semicolon.html ). Finally I have changed ";" on "," in my system settings using instruction from the link above, reset pc, and... now all my CSV files, which had been created earlier, need corrections because all data from former columns now have been placed in the first column and delimited with ";" from each other. When I corrected CSV file and saved it in a new format delimitation (=commas), I can create new layer using Data Source Manager / Delimited Text only with "Commas (CVS)" settings in File Format. I expected that now I can work with new CSV file with comma delimitations in the BR tools, but, unfortunately, no. The situation is identical with the former one. I can't use the plugin neither through 'Create source from CSV file' nor from 'Source layer' drop-down list.

Returning all system settings back, I followed your step-by-step instruction from this example:

For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected > that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal.

Yes, I can select 'Species' in the Taxon Column, than tagged 'Scientific names' / Output CRS tagged 'Other' and select EPSG:4978 - WGS 84, than clicked 'Reload taxa' and 'Check all' in Taxa tab, return to 'Data specification' and clicked on 'Create map layer'. As a result I see TEMP layers in the Layer Panel, but noone of them is visualized on the map indeed. All layers are invisible... What I am doing wrong? :) How to make all temporary layers visible?

Thank you very much for your help!

Best wishes, Pavel

Below are screenshots with points of CSV file and without tag on this CSV file:

Среда, 17 апреля 2019, 14:35 +07:00 от Rich Burkmar notifications@github.com:

Hi Pavel, Now I understand. You are opening your CSV file in QGIS in a way that allows QGIS to interpret the lat/lon locations and create points on the map. When you select a layer in the BR tool that already has points on the map (whether Shapefile, CSV or whatever), then the BR tool doesn't need you to specify either a grid reference field or x/y fields because QGIS already has the geometry! So it makes those selection boxes inactive, but you can go ahead and use the tool anyway, e.g. to create an aggregate map. For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal. The way I was using it before was to open your CSV without getting QGIS to create the points. Then the X/Y drop-downs in the BR tool are enabled and I can use it that way. You can work either way - the results will be identical. Rich — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

burkmarr commented 5 years ago

Hi Pavel,

First of all, I don’t understand why you can’t use the CSV file with comma separators by directly opening it in the BR tool. But rather than dwell on that – since you’ve already changed your system settings back – let’s try to sort out the problem with using the semi-colon separated files.

When you have opened the CSV with Data Source Manager, can you see the points on the map? (This is before you’ve even started using the BR tool).

Rich

From: pnef75 notifications@github.com Sent: 17 April 2019 11:39 To: FieldStudiesCouncil/QGIS-Biological-Recording-Tools QGIS-Biological-Recording-Tools@noreply.github.com Cc: Burkmar, Richard J. rburkmar@ceh.ac.uk; Comment comment@noreply.github.com Subject: Re: [FieldStudiesCouncil/QGIS-Biological-Recording-Tools] inactive / empty fields for Lat/Lon (#40)

Hi Rich!

While I was waiting for your answer, I went on the other way to solve the problem with comma as a delimitation instead of a semilocon in CSV-format. Some people were faced with the same problem many years ago ( https://www.mrexcel.com/forum/excel-questions/439562-exporting-csv-format-using-comma-instead-semicolon.html ). Finally I have changed ";" on "," in my system settings using instruction from the link above, reset pc, and... now all my CSV files, which had been created earlier, need corrections because all data from former columns now have been placed in the first column and delimited with ";" from each other. When I corrected CSV file and saved it in a new format delimitation (=commas), I can create new layer using Data Source Manager / Delimited Text only with "Commas (CVS)" settings in File Format. I expected that now I can work with new CSV file with comma delimitations in the BR tools, but, unfortunately, no. The situation is identical with the former one. I can't use the plugin neither through 'Create source from CSV file' nor from 'Source layer' drop-down list.

Returning all system settings back, I followed your step-by-step instruction from this example:

For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected > that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal.

Yes, I can select 'Species' in the Taxon Column, than tagged 'Scientific names' / Output CRS tagged 'Other' and select EPSG:4978 - WGS 84, than clicked 'Reload taxa' and 'Check all' in Taxa tab, return to 'Data specification' and clicked on 'Create map layer'. As a result I see TEMP layers in the Layer Panel, but noone of them is visualized on the map indeed. All layers are invisible... What I am doing wrong? :) How to make all temporary layers visible?

Thank you very much for your help!

Best wishes, Pavel

Below are screenshots with points of CSV file and without tag on this CSV file:

Среда, 17 апреля 2019, 14:35 +07:00 от Rich Burkmar notifications@github.com:

Hi Pavel, Now I understand. You are opening your CSV file in QGIS in a way that allows QGIS to interpret the lat/lon locations and create points on the map. When you select a layer in the BR tool that already has points on the map (whether Shapefile, CSV or whatever), then the BR tool doesn't need you to specify either a grid reference field or x/y fields because QGIS already has the geometry! So it makes those selection boxes inactive, but you can go ahead and use the tool anyway, e.g. to create an aggregate map. For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal. The way I was using it before was to open your CSV without getting QGIS to create the points. Then the X/Y drop-downs in the BR tool are enabled and I can use it that way. You can work either way - the results will be identical. Rich — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/FieldStudiesCouncil/QGIS-Biological-Recording-Tools/issues/40#issuecomment-484031381, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AI2HKrbAJH9kvOldliIJRfKFBlhNGjeKks5vhvnGgaJpZM4cxXDq.

This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete this email from your system. UK Research and Innovation has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before opening the attachments. UK Research and Innovation does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses. Opinions, conclusions or other information in this message and attachments that are not related directly to UK Research and Innovation business are solely those of the author and do not represent the views of UK Research and Innovation.

pnef75 commented 5 years ago

When I tried to open the CSV file in a new system format (with comma separators) directly in the BR tool, I faced with completely the same results as before - no possibilities to select grid or X/Y coordinate boxes. Let's rather than dwell on that - you are right.

Before I started using the BR tool, I always saw the points of species localities on the map for sure. And now I also can see the points as well. But unfortunately, I don't see the points through the BR tool... Here you can see - only points of CSV layer:

Среда, 17 апреля 2019, 18:06 +07:00 от Rich Burkmar notifications@github.com:

Hi Pavel,

First of all, I don’t understand why you can’t use the CSV file with comma separators by directly opening it in the BR tool. But rather than dwell on that – since you’ve already changed your system settings back – let’s try to sort out the problem with using the semi-colon separated files.

When you have opened the CSV with Data Source Manager, can you see the points on the map? (This is before you’ve even started using the BR tool).

Rich

From: pnef75 < notifications@github.com > Sent: 17 April 2019 11:39 To: FieldStudiesCouncil/QGIS-Biological-Recording-Tools < QGIS-Biological-Recording-Tools@noreply.github.com > Cc: Burkmar, Richard J. < rburkmar@ceh.ac.uk >; Comment < comment@noreply.github.com > Subject: Re: [FieldStudiesCouncil/QGIS-Biological-Recording-Tools] inactive / empty fields for Lat/Lon (#40)

Hi Rich!

While I was waiting for your answer, I went on the other way to solve the problem with comma as a delimitation instead of a semilocon in CSV-format. Some people were faced with the same problem many years ago ( https://www.mrexcel.com/forum/excel-questions/439562-exporting-csv-format-using-comma-instead-semicolon.html ). Finally I have changed ";" on "," in my system settings using instruction from the link above, reset pc, and... now all my CSV files, which had been created earlier, need corrections because all data from former columns now have been placed in the first column and delimited with ";" from each other. When I corrected CSV file and saved it in a new format delimitation (=commas), I can create new layer using Data Source Manager / Delimited Text only with "Commas (CVS)" settings in File Format. I expected that now I can work with new CSV file with comma delimitations in the BR tools, but, unfortunately, no. The situation is identical with the former one. I can't use the plugin neither through 'Create source from CSV file' nor from 'Source layer' drop-down list.

Returning all system settings back, I followed your step-by-step instruction from this example:

For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected > that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal.

Yes, I can select 'Species' in the Taxon Column, than tagged 'Scientific names' / Output CRS tagged 'Other' and select EPSG:4978 - WGS 84, than clicked 'Reload taxa' and 'Check all' in Taxa tab, return to 'Data specification' and clicked on 'Create map layer'. As a result I see TEMP layers in the Layer Panel, but noone of them is visualized on the map indeed. All layers are invisible... What I am doing wrong? :) How to make all temporary layers visible?

Thank you very much for your help!

Best wishes, Pavel

Below are screenshots with points of CSV file and without tag on this CSV file:

Среда, 17 апреля 2019, 14:35 +07:00 от Rich Burkmar < notifications@github.com >:

Hi Pavel, Now I understand. You are opening your CSV file in QGIS in a way that allows QGIS to interpret the lat/lon locations and create points on the map. When you select a layer in the BR tool that already has points on the map (whether Shapefile, CSV or whatever), then the BR tool doesn't need you to specify either a grid reference field or x/y fields because QGIS already has the geometry! So it makes those selection boxes inactive, but you can go ahead and use the tool anyway, e.g. to create an aggregate map. For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal. The way I was using it before was to open your CSV without getting QGIS to create the points. Then the X/Y drop-downs in the BR tool are enabled and I can use it that way. You can work either way - the results will be identical. Rich — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

— You are receiving this because you commented. Reply to this email directly, view it on GitHub< https://github.com/FieldStudiesCouncil/QGIS-Biological-Recording-Tools/issues/40#issuecomment-484031381 >, or mute the thread< https://github.com/notifications/unsubscribe-auth/AI2HKrbAJH9kvOldliIJRfKFBlhNGjeKks5vhvnGgaJpZM4cxXDq >.

This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete this email from your system. UK Research and Innovation has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before opening the attachments. UK Research and Innovation does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses. Opinions, conclusions or other information in this message and attachments that are not related directly to UK Research and Innovation business are solely those of the author and do not represent the views of UK Research and Innovation.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

burkmarr commented 5 years ago

Hi Pavel,

Attached is a zipfile containing a step recording map with Windows Steps Recorder. Unzip it then in folder pavel-demo-1 you will find a file Recording_20190417_1428.mht.

If you double-click that it will probably open in Windows IE. I think that you need IE to be able to view this nicely. Let me know if you struggle viewing it.

Rich

From: pnef75 notifications@github.com Sent: 17 April 2019 12:54 To: FieldStudiesCouncil/QGIS-Biological-Recording-Tools QGIS-Biological-Recording-Tools@noreply.github.com Cc: Burkmar, Richard J. rburkmar@ceh.ac.uk; Comment comment@noreply.github.com Subject: Re: [FieldStudiesCouncil/QGIS-Biological-Recording-Tools] inactive / empty fields for Lat/Lon (#40)

When I tried to open the CSV file in a new system format (with comma separators) directly in the BR tool, I faced with completely the same results as before - no possibilities to select grid or X/Y coordinate boxes. Let's rather than dwell on that - you are right.

Before I started using the BR tool, I always saw the points of species localities on the map for sure. And now I also can see the points as well. But unfortunately, I don't see the points through the BR tool... Here you can see - only points of CSV layer:

Среда, 17 апреля 2019, 18:06 +07:00 от Rich Burkmar notifications@github.com:

Hi Pavel,

First of all, I don’t understand why you can’t use the CSV file with comma separators by directly opening it in the BR tool. But rather than dwell on that – since you’ve already changed your system settings back – let’s try to sort out the problem with using the semi-colon separated files.

When you have opened the CSV with Data Source Manager, can you see the points on the map? (This is before you’ve even started using the BR tool).

Rich

From: pnef75 < notifications@github.com > Sent: 17 April 2019 11:39 To: FieldStudiesCouncil/QGIS-Biological-Recording-Tools < QGIS-Biological-Recording-Tools@noreply.github.com > Cc: Burkmar, Richard J. < rburkmar@ceh.ac.uk >; Comment < comment@noreply.github.com > Subject: Re: [FieldStudiesCouncil/QGIS-Biological-Recording-Tools] inactive / empty fields for Lat/Lon (#40)

Hi Rich!

While I was waiting for your answer, I went on the other way to solve the problem with comma as a delimitation instead of a semilocon in CSV-format. Some people were faced with the same problem many years ago ( https://www.mrexcel.com/forum/excel-questions/439562-exporting-csv-format-using-comma-instead-semicolon.html ). Finally I have changed ";" on "," in my system settings using instruction from the link above, reset pc, and... now all my CSV files, which had been created earlier, need corrections because all data from former columns now have been placed in the first column and delimited with ";" from each other. When I corrected CSV file and saved it in a new format delimitation (=commas), I can create new layer using Data Source Manager / Delimited Text only with "Commas (CVS)" settings in File Format. I expected that now I can work with new CSV file with comma delimitations in the BR tools, but, unfortunately, no. The situation is identical with the former one. I can't use the plugin neither through 'Create source from CSV file' nor from 'Source layer' drop-down list.

Returning all system settings back, I followed your step-by-step instruction from this example:

For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected > that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal.

Yes, I can select 'Species' in the Taxon Column, than tagged 'Scientific names' / Output CRS tagged 'Other' and select EPSG:4978 - WGS 84, than clicked 'Reload taxa' and 'Check all' in Taxa tab, return to 'Data specification' and clicked on 'Create map layer'. As a result I see TEMP layers in the Layer Panel, but noone of them is visualized on the map indeed. All layers are invisible... What I am doing wrong? :) How to make all temporary layers visible?

Thank you very much for your help!

Best wishes, Pavel

Below are screenshots with points of CSV file and without tag on this CSV file:

Среда, 17 апреля 2019, 14:35 +07:00 от Rich Burkmar < notifications@github.com >:

Hi Pavel, Now I understand. You are opening your CSV file in QGIS in a way that allows QGIS to interpret the lat/lon locations and create points on the map. When you select a layer in the BR tool that already has points on the map (whether Shapefile, CSV or whatever), then the BR tool doesn't need you to specify either a grid reference field or x/y fields because QGIS already has the geometry! So it makes those selection boxes inactive, but you can go ahead and use the tool anyway, e.g. to create an aggregate map. For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal. The way I was using it before was to open your CSV without getting QGIS to create the points. Then the X/Y drop-downs in the BR tool are enabled and I can use it that way. You can work either way - the results will be identical. Rich — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

— You are receiving this because you commented. Reply to this email directly, view it on GitHub< https://github.com/FieldStudiesCouncil/QGIS-Biological-Recording-Tools/issues/40#issuecomment-484031381 >, or mute the thread< https://github.com/notifications/unsubscribe-auth/AI2HKrbAJH9kvOldliIJRfKFBlhNGjeKks5vhvnGgaJpZM4cxXDq >.

This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete this email from your system. UK Research and Innovation has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before opening the attachments. UK Research and Innovation does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses. Opinions, conclusions or other information in this message and attachments that are not related directly to UK Research and Innovation business are solely those of the author and do not represent the views of UK Research and Innovation.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/FieldStudiesCouncil/QGIS-Biological-Recording-Tools/issues/40#issuecomment-484051488, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AI2HKqHpEpzhE595rxiO1kokn1APLTZqks5vhws6gaJpZM4cxXDq.

This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete this email from your system. UK Research and Innovation has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before opening the attachments. UK Research and Innovation does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses. Opinions, conclusions or other information in this message and attachments that are not related directly to UK Research and Innovation business are solely those of the author and do not represent the views of UK Research and Innovation.

pnef75 commented 5 years ago

Sorry Rich, but I don't see any attachment...

Среда, 17 апреля 2019, 20:53 +07:00 от Rich Burkmar notifications@github.com:

Hi Pavel,

Attached is a zipfile containing a step recording map with Windows Steps Recorder. Unzip it then in folder pavel-demo-1 you will find a file Recording_20190417_1428.mht.

If you double-click that it will probably open in Windows IE. I think that you need IE to be able to view this nicely. Let me know if you struggle viewing it.

Rich

From: pnef75 < notifications@github.com > Sent: 17 April 2019 12:54 To: FieldStudiesCouncil/QGIS-Biological-Recording-Tools < QGIS-Biological-Recording-Tools@noreply.github.com > Cc: Burkmar, Richard J. < rburkmar@ceh.ac.uk >; Comment < comment@noreply.github.com > Subject: Re: [FieldStudiesCouncil/QGIS-Biological-Recording-Tools] inactive / empty fields for Lat/Lon (#40)

When I tried to open the CSV file in a new system format (with comma separators) directly in the BR tool, I faced with completely the same results as before - no possibilities to select grid or X/Y coordinate boxes. Let's rather than dwell on that - you are right.

Before I started using the BR tool, I always saw the points of species localities on the map for sure. And now I also can see the points as well. But unfortunately, I don't see the points through the BR tool... Here you can see - only points of CSV layer:

Среда, 17 апреля 2019, 18:06 +07:00 от Rich Burkmar < notifications@github.com >:

Hi Pavel,

First of all, I don’t understand why you can’t use the CSV file with comma separators by directly opening it in the BR tool. But rather than dwell on that – since you’ve already changed your system settings back – let’s try to sort out the problem with using the semi-colon separated files.

When you have opened the CSV with Data Source Manager, can you see the points on the map? (This is before you’ve even started using the BR tool).

Rich

From: pnef75 < notifications@github.com > Sent: 17 April 2019 11:39 To: FieldStudiesCouncil/QGIS-Biological-Recording-Tools < QGIS-Biological-Recording-Tools@noreply.github.com > Cc: Burkmar, Richard J. < rburkmar@ceh.ac.uk >; Comment < comment@noreply.github.com > Subject: Re: [FieldStudiesCouncil/QGIS-Biological-Recording-Tools] inactive / empty fields for Lat/Lon (#40)

Hi Rich!

While I was waiting for your answer, I went on the other way to solve the problem with comma as a delimitation instead of a semilocon in CSV-format. Some people were faced with the same problem many years ago ( https://www.mrexcel.com/forum/excel-questions/439562-exporting-csv-format-using-comma-instead-semicolon.html ). Finally I have changed ";" on "," in my system settings using instruction from the link above, reset pc, and... now all my CSV files, which had been created earlier, need corrections because all data from former columns now have been placed in the first column and delimited with ";" from each other. When I corrected CSV file and saved it in a new format delimitation (=commas), I can create new layer using Data Source Manager / Delimited Text only with "Commas (CVS)" settings in File Format. I expected that now I can work with new CSV file with comma delimitations in the BR tools, but, unfortunately, no. The situation is identical with the former one. I can't use the plugin neither through 'Create source from CSV file' nor from 'Source layer' drop-down list.

Returning all system settings back, I followed your step-by-step instruction from this example:

For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected > that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal.

Yes, I can select 'Species' in the Taxon Column, than tagged 'Scientific names' / Output CRS tagged 'Other' and select EPSG:4978 - WGS 84, than clicked 'Reload taxa' and 'Check all' in Taxa tab, return to 'Data specification' and clicked on 'Create map layer'. As a result I see TEMP layers in the Layer Panel, but noone of them is visualized on the map indeed. All layers are invisible... What I am doing wrong? :) How to make all temporary layers visible?

Thank you very much for your help!

Best wishes, Pavel

Below are screenshots with points of CSV file and without tag on this CSV file:

Среда, 17 апреля 2019, 14:35 +07:00 от Rich Burkmar < notifications@github.com >:

Hi Pavel, Now I understand. You are opening your CSV file in QGIS in a way that allows QGIS to interpret the lat/lon locations and create points on the map. When you select a layer in the BR tool that already has points on the map (whether Shapefile, CSV or whatever), then the BR tool doesn't need you to specify either a grid reference field or x/y fields because QGIS already has the geometry! So it makes those selection boxes inactive, but you can go ahead and use the tool anyway, e.g. to create an aggregate map. For example, I just used the Data Source Manager to open the 'Altajosoma several species' CSV you sent to me as a points layer. Then I selected that layer in Source layer drop-down list on the BR tool. The OS Grid Ref, X and Y drop-downs were disabled as you noted. But I can still select 'Species' in the Taxon Column drop-down and use the tool as normal. The way I was using it before was to open your CSV without getting QGIS to create the points. Then the X/Y drop-downs in the BR tool are enabled and I can use it that way. You can work either way - the results will be identical. Rich — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

— You are receiving this because you commented. Reply to this email directly, view it on GitHub< https://github.com/FieldStudiesCouncil/QGIS-Biological-Recording-Tools/issues/40#issuecomment-484031381 >, or mute the thread< https://github.com/notifications/unsubscribe-auth/AI2HKrbAJH9kvOldliIJRfKFBlhNGjeKks5vhvnGgaJpZM4cxXDq >.

This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete this email from your system. UK Research and Innovation has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before opening the attachments. UK Research and Innovation does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses. Opinions, conclusions or other information in this message and attachments that are not related directly to UK Research and Innovation business are solely those of the author and do not represent the views of UK Research and Innovation.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/

— You are receiving this because you commented. Reply to this email directly, view it on GitHub< https://github.com/FieldStudiesCouncil/QGIS-Biological-Recording-Tools/issues/40#issuecomment-484051488 >, or mute the thread< https://github.com/notifications/unsubscribe-auth/AI2HKqHpEpzhE595rxiO1kokn1APLTZqks5vhws6gaJpZM4cxXDq >.

This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete this email from your system. UK Research and Innovation has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before opening the attachments. UK Research and Innovation does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses. Opinions, conclusions or other information in this message and attachments that are not related directly to UK Research and Innovation business are solely those of the author and do not represent the views of UK Research and Innovation.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or mute the thread .

-- Dr. Pavel Nefediev Ph.D. in Zoology Assistant Professor at the Altai State University Dept. of Ecology http://www.asu.ru/search/persons/776/