1 Topic by FNRCinfoassist

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 75

Topic: reporting on Attribution for all surveys

Hello,
I asked a question in December 24 but looking at it now I wasn't clear.

Is there a report available to output the attribution data (from the licence tab) for all surveys in the database?
The St11 report doesn't include the licence tab fields.

Many thanks in anticipation
Mhairi
Fife Nature Records Centre

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: reporting on Attribution for all surveys

Hi

Attached is a revised rpeort ST 01 which includes the short name of the licence. If the attribution for the Suvey this will prooably require a new report. Let me know.

Mike

Post's attachments

JNCC_St01_SpObsvPerSurvey.xml 1.57 kb, 1 downloads since 2025-02-12 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website

3 Reply by FNRCinfoassist

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 75

Re: reporting on Attribution for all surveys

Hello Mike,

Thank you for responding to my query so promptly.

I don't think that st01 is the right report for what I want, I think st11 amended to include licence and attribution fields for all surveys would be best for me.

What I am hoping for is a report that will summarise all the survey information including the licence, attribution and private fields that are present on the Licence Tab for all surveys present in the database. This would help me greatly to keep all attribution and citation information up to date for those surveys that we download from the NBN and other sources that have attribution attached to them.

St11 seems a good choice with the new fields added? Is this possible? Or should it be a completely new report?

Many thanks again.
Warm wishes
Mhairi

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: reporting on Attribution for all surveys

Hi

I have looked at St11 and it could easily be adapted to add the other fields . I am just a bit pushed at the moment but will see waht I can do.

Mike Weideli

MikeWeideli's Website

5 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: reporting on Attribution for all surveys

Hi

Try this version of St11. Let me know if there are any issues.

Post's attachments

JNCC_St11_Survey Summary.xml 3.07 kb, 1 downloads since 2025-02-12 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website

6 Reply by FNRCinfoassist

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 75

Re: reporting on Attribution for all surveys

Thank you Mike,
I am afraid it didnt work for me the way I thought. It did work but it wont open in excel and opening in anything else just has all kinds of strange symbols and stuff. I have tried exporting to html and Access mdb, they open but not without extra symbols. I shall email you the html for your info. I think there may be too many characters within the Attribution field and maybe the Description field (NBN surveys mostly) for the system to cope with. I shall try to find my thinking cap :)
Thanks again
Mhairi

7 Reply by FNRCinfoassist

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 75

Re: reporting on Attribution for all surveys

Hi Mike, I got the report to work by saving it as HTML and dragging it into excel. Can I request the addition of the "Date of Import" field to the ST11 report please, that would be really useful for me in keeping track of when NBN datasets need refreshed.
Many thanks for all you do
Mhairi