IRC log for #koha, 2019-06-17

All times shown according to UTC.

Time S Nick Message
00:49 inlibro joined #koha
01:49 inlibro joined #koha
02:04 dpk__ joined #koha
02:49 inlibro joined #koha
03:50 inlibro joined #koha
04:15 m23 joined #koha
04:50 inlibro joined #koha
05:34 josef_moravec joined #koha
05:34 josef_moravec morning #koha
05:42 cait joined #koha
05:44 calire joined #koha
05:44 Reza joined #koha
05:46 cait joined #koha
05:46 Reza Hi. We have shutdown one our libraries. I will have to transfer all the books from that branch to a new branch. How can I do it in bulk?
05:46 Reza Like transferring all the itmes from one branch to another
05:47 Reza Also, if I could rename the branch code it would solve the problem as well.
05:47 Reza Anyone has any idea how to deal with this>
05:47 Reza Anyone has any idea how to deal with this?
05:50 inlibro joined #koha
06:04 cait Reza: how many books are we talking about?
06:09 Reza about 20 thousand
06:18 josef_moravec left #koha
06:26 kohaputti Reza, there is probably some tool for this but you can always grep the kohastructure.sql (schema) for branchcode and see where you would have to change it for this conversion and then just do it with sql.
06:27 kohaputti e.g. UPDATE items SET holdingbranch = "NEW_CODE" WHERE holdingbranch = "OLD_CODE";
06:28 kohaputti maybe a bit dangerous so use some tool if there is
06:32 fridolin joined #koha
06:34 reiveune joined #koha
06:35 reiveune hello
06:35 Reza Yeah. I am checking. Branch code is foreign key in 30 tables.
06:37 marcelr joined #koha
06:37 marcelr hi #koha
06:38 AndrewIsh joined #koha

| Channels | #koha index | Today | Search | Google Search | Plain-Text | plain, newest first | summary