Move to another Storage Location Multiple Items

[marcolino7]

Hi, I have to move multiple items to another Storage Location. Is it possible to achieve this? And in general is this possible to perform a massive update to items? I Have the development version checked out a couple of week ago.

Thanks

[christianlupus]

You can use drag and drop in the partlist.

Apart from that, you can directly access and tweak the database.

[marcolino7]

How I can change Storage Location using Drag and Drop? Thanks

[christianlupus]

I am sorry, I misread your text. I thought you were referring the categories.

I fear the fastest way is to change the database itself.

[ghost-from-the-past]

Dear Marcolino If you have direct access to your server you can do it via SQL scripts, is not too hard. some tips https://readthedocs.web.cern.ch/display/PARTK/12+-+Dealing+with+MySQL https://readthedocs.web.cern.ch/display/PARTK/Partkeepr+tables https://readthedocs.web.cern.ch/display/PARTK/scripts+to+update+different+things

you need to search in https://readthedocs.web.cern.ch/display/PARTK/table+Part for the storage location (old id) and replace with the storage location (new id) at the field storageLocation_id of Parts table. the storage location ids are in https://readthedocs.web.cern.ch/display/PARTK/table+StorageLocation