Hello, I have what my patrons have checked out in CSV format .... name, then barcode .. next line - name then barcode .. etc. is there a way to import this quickly into Koha? Or do I need to manually input who has what checked out .. Thanks! David W. Hartman Global Business Technology Strategy Library Team Disney 336N 407 828 4250 (8-222) FAX 407 828 4868 FOLLOW MY RESEARCH on Backlot<http://backlot.disney.com/> & Yammer<http://www.yammer.com/>! Learn about our research partners in the 2011 IT Research Competency Center<http://tink.corp.disney.com/?i=ko0> GBTS CAST can click to request AV Equipment<http://tink.corp.disney.com/?i=jbo>, Books<http://tink.corp.disney.com/?i=jbp>, & Research<http://tink.corp.disney.com/?i=jbn> WATCH the GBTS Library (Video) Update<http://tink.corp.disney.com/?i=2f0> ! CLICK for the GBTS VIRTUAL LIBRARY<http://tink.corp.disney.com/?i=1wn>portal site!! "This communication is confidential, intended only for the named recipients above and may contain trade secrets or other information that is exempt from disclosure under applicable law. Any use, dissemination, distribution or copying of this communication by anyone other than the named recipients is strictly prohibited. If you have received this communication in error, please immediately notify us by calling (407) 828-4250. Thank you." [cid:image001.gif@01CC560B.7F6FBCC0]Please consider your environmental responsibility before printing this e-mail [cid:image001.gif@01CC560B.7F6FBCC0] Think Environmentality! Reduce! Reuse! Recycle!
* Hartman, David W. - GBTS Library (David.W.Hartman@disney.com) wrote:
Hello,
I have what my patrons have checked out in CSV format ....
name, then barcode .. next line -
name then barcode .. etc.
is there a way to import this quickly into Koha? Or do I need to manually input who has what checked out .. Thanks!
Hi David Does it have date_due ? And is it name, not a unique identifier? Name is ok, as long as no 2 people have the same name :) Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
Yes, due date is provided and name - names are unique! :) Sent from my iPhone! Pardon typos, etc. On Aug 8, 2011, at 9:06 PM, "Chris Cormack" <chrisc@catalyst.net.nz> wrote:
* Hartman, David W. - GBTS Library (David.W.Hartman@disney.com) wrote:
Hello,
I have what my patrons have checked out in CSV format ....
name, then barcode .. next line -
name then barcode .. etc.
is there a way to import this quickly into Koha? Or do I need to manually input who has what checked out .. Thanks!
Hi David
Does it have date_due ? And is it name, not a unique identifier? Name is ok, as long as no 2 people have the same name :)
Chris
-- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
* Hartman, David W. - GBTS Library (David.W.Hartman@disney.com) wrote:
Yes, due date is provided and name - names are unique! :)
Right, then a script like Robin's is probably the way to go. Do you have perl skills (or someone on staff) who can help you out with that? If not, hope on IRC sometime and we can talk you through making the changes Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
2011/8/9 Chris Cormack <chrisc@catalyst.net.nz>:
* Hartman, David W. - GBTS Library (David.W.Hartman@disney.com) wrote:
Yes, due date is provided and name - names are unique! :)
Right, then a script like Robin's is probably the way to go.
Here is my script for doing something similar: https://github.com/MagnusEnger/LibrioTools/blob/master/tidem/loans.pl Again, this is tailored to one specific system/situation (where the data about current checkouts was in HTML format!), but it might give some hints... What I did was create a .koc-file with my script, which I could then import using Home › Circulation › Offline Circulation File Upload. I figured that would reduce the risk of putting data in the wrong place or missing some field in some table that should have data in it... The format of the .koc file is documented here: http://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format Best regards, Magnus Enger libriotech.no
Hie, For such data integrations, our company uses Talend Open Studio. It is a business-oriented data modeling software (an open-source based on Eclipse RCP). This means that no programing is needed. It can use and produce many file formats like SQL, XLS, CVS, ... You may use it to transform your CVS file into a SQL injection script. See : http://www.talend.com/products-data-integration/talend-open-studio.php -- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers@gmail.com On Tue, Aug 9, 2011 at 9:13 AM, Magnus Enger <magnus@enger.priv.no> wrote:
2011/8/9 Chris Cormack <chrisc@catalyst.net.nz>:
* Hartman, David W. - GBTS Library (David.W.Hartman@disney.com) wrote:
Yes, due date is provided and name - names are unique! :)
Right, then a script like Robin's is probably the way to go.
Here is my script for doing something similar: https://github.com/MagnusEnger/LibrioTools/blob/master/tidem/loans.pl Again, this is tailored to one specific system/situation (where the data about current checkouts was in HTML format!), but it might give some hints...
What I did was create a .koc-file with my script, which I could then import using Home › Circulation › Offline Circulation File Upload. I figured that would reduce the risk of putting data in the wrong place or missing some field in some table that should have data in it...
The format of the .koc file is documented here: http://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format
Best regards, Magnus Enger libriotech.no _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
Hartman, David W. - GBTS Library schreef op ma 08-08-2011 om 20:41 [-0400]:
I have what my patrons have checked out in CSV format ….
name, then barcode .. next line –
name then barcode .. etc.
is there a way to import this quickly into Koha? Or do I need to manually input who has what checked out .. Thanks!
Depending on the amount you have, it might be worth scripting. You'd have to look up the name to get the borrowernumber, and the barcode for the itemnumber, and then insert them in. I have a script that does something similar: http://git.catalyst.net.nz/gw?p=koha.git;a=blob;f=import/csv/waitaki_circ.pl... unfortunately it's a bit under-documented as it's for migrating from specific software, and I edit it each time I need to change things, but it may get you somewhere. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
participants (5)
-
Chris Cormack -
Fridolyn SOMERS -
Hartman, David W. - GBTS Library -
Magnus Enger -
Robin Sheat