How to export attachments?

I have a question how to export attachments. We have a few distant ones
departments that use smart data. And they need photos in addition to tables.
I found 2 options for exporting attachments: 1) through queries 2) through reports.

  1. When exporting attachments to the query menu, photos are exported without information. Photo titles are not related with incidents. If the name contained, for example, the ID of the incident, then everything would be fine. (It is not clear what is in this photo and where it was taken).
  2. When I try to export a photo through reports I encountered the problem of what table is being created does not contain information - most columns are simply empty. Although the same table that uses the source the query contains all the data.
    I use smart 7.4
    Please share your experience of how to export attachments. I will be grateful.




Hi Volodimir,

You’re correct that the query export is just the image without the associated data. You do in fact need to use the report.

There’s some information on this in the Advanced Reporting Handbook.

The data you’re looking for should be available in the output columns. Can you double check that the output columns in fact contain the desired observations (i.e. they were input when the image was taken)? Could it be that for this observation these categories were not populated?

Cheers,

Alex

[quote=“Alex_Wyatt, post:2, topic:855, full:true”]
Hi Volodimir,

You’re correct that the query export is just the image without the associated data. You do in fact need to use the report.

There’s some information on this in the Advanced Reporting Handbook.

The data you’re looking for should be available in the output columns. Can you double check that the output columns in fact contain the desired observations (i.e. they were input when the image was taken)? Could it be that for this observation these categories were not populated?

Cheers,
Thanks for the answer.
I have now created a new report. Added two data sources to it. One called a request, the other a photo. Both of them are based on the request “Kevlev Raid 00006”. The only difference is that I created one through Data set type: query, and the other through Data set type: attachment. As a result, the first table contains data, but the second table does not. Only the date and several other system columns (coordinates, etc.) work in the second table. Am I doing something wrong or is it a smart problem? Could there be a problem with Data set type: attachment? Do you have all this working correctly?
I am attaching screenshots that illustrate my actions.









Result:


Hi Volodimir,

Ah, I see. Yes, you want to use the “SMART Query Attachments” as your data set type.

This, should, though allow you to see a table which includes the observations (whatever you select for your output columns) as well as the images (see example from my demo database below).

Thanks a lot for the screenshots. It looks like you’re doing everything correctly, so there’s no issue there.

Would it be possible to upgrade to SMART 7.5.3 to see if the issue is present in the more recent update?

Cheers,

Alex

I would like to upgrade to 7.5.3. Please send me the link by which I can download the new version of smart.
P.S.
All the speakers you have on your screen also work for me. Observation category 0, 1. Others that are deeper in the data model do not work. For example, the type of animal, the number of animals observed, a comment on the observation, and so on. And all of this works in Data set type: query.

Hi Volodimir,

Yes, sorry, it appears attribute data are not displaying which is not resolved in 7.5.3, so there’s no use in upgrading to get around this issue.

Thank you for bringing this to our attention. We’ll work to resolve this ASAP.

Cheers,

Alex

P.s. you can access 7.5.3 here for now while awaiting an updated version.

Thanks for the answer