Updating physical locations for lots of items

[li...@orangeleaf.com]

Is it possible to batch update the physical location of lots of item level records via the AtoM front end?

For example where a whole store room of items is being re-located to another location?

[brzic...@gmail.com]

Would this be of interest to you ?

https://groups.google.com/forum/#!topic/ica-atom-users/ZuicQ6RMAbM

[Dan Gillean]

Hi Linda, 

The short answer is: not currently without using SQL, but there is a method coming in the 2.6 release! 

A bit more detail: 

In the 2.6 release there will be a new CSV import for physical storage locations. This will also include a means for importing CSV data as an update to existing storage locations - designed precisely to cover this kind of use case, where a lot of containers are moved to new locations. You can see a bit more in the relevant tickets here: 

• Add CSV import for physical storage locations:  https://projects.artefactual.com/issues/13183
• Add ability to update locations data via import:  https://projects.artefactual.com/issues/13185

That doesn't help you currently, unless you are willing to upgrade and use a development branch - which is not ideal if this is for a production site, as 2.6 is still undergoing active development and requires more functional testing before its final release. 

In the meantime, I will see if I can figure out a SQL query that might help - can you tell me a bit more about your use case? For example:

• Is this a bulk update of just the location field data for a number of storage containers?
• Do all the target containers requiring the update share the same current location data? If no, do they have any other common characteristics that might be used to select the right containers?

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

On Fri, Jan 31, 2020 at 11:48 AM <li...@orangeleaf.com> wrote:

Is it possible to batch update the physical location of lots of item level records via the AtoM front end?

For example where a whole store room of items is being re-located to another location?

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/11c4f99f-9c4f-44ac-bc45-2364fceea2fa%40googlegroups.com.

[li...@orangeleaf.com]

We can wait for v2.6 as there is no urgency to do this, thanks for the head's up.

To unsubscribe from this group and stop receiving emails from it, send an email to ica-ato...@googlegroups.com.