Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
Bruce, I just did a 5.3 bib data extraction a few weeks ago. These steps did the trick for me: Make sure to use short report option. Bib Data Extraction: Select Materials > Export Select All Materials from Export menu All the options should gray-out except for the output file Select USMARC/852 Holdings Data Click Browse to desktop and in the Output file field, enter your desired name. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O From: partners-bounces@bywatersolutions.com [mailto:partners-bounces@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partners@bywatersolutions.com Subject: [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 I realize we are probably one of the oldest and last hold outs converting from Spectrum 5.3 to a modern system. Anyone else convert from Spectrum to Koha that could give me some tips on extracting the data, our reports and exports just don't look like good usable data. I have submitted and support ticket to Bywater, just thought I would ask the community to see if anyone had any tips. Thanks Bruce -- Bruce Morgan Technology Director District MOSIS Contact Potosi R-3 Schools www.potosir3.org brucem@potosir3.org
Sorry, put the wrong email list in the CC box. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Joel Sasse Sent: Monday, March 17, 2014 3:33 PM To: 'Bruce Morgan' Cc: Koha@lists.katipo.co.nz Subject: Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 Bruce, I just did a 5.3 bib data extraction a few weeks ago. These steps did the trick for me: Make sure to use short report option. Bib Data Extraction: Select Materials > Export Select All Materials from Export menu All the options should gray-out except for the output file Select USMARC/852 Holdings Data Click Browse to desktop and in the Output file field, enter your desired name. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O From: partners-bounces@bywatersolutions.com [mailto:partners-bounces@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partners@bywatersolutions.com Subject: [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 I realize we are probably one of the oldest and last hold outs converting from Spectrum 5.3 to a modern system. Anyone else convert from Spectrum to Koha that could give me some tips on extracting the data, our reports and exports just don't look like good usable data. I have submitted and support ticket to Bywater, just thought I would ask the community to see if anyone had any tips. Thanks Bruce -- Bruce Morgan Technology Director District MOSIS Contact Potosi R-3 Schools www.potosir3.org brucem@potosir3.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Well he did say community :-) Chris On 18 March 2014 10:38:06 am NZDT, Joel Sasse <jsasse@plumcreeklibrary.net> wrote:
Sorry, put the wrong email list in the CC box.
Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Joel Sasse Sent: Monday, March 17, 2014 3:33 PM To: 'Bruce Morgan' Cc: Koha@lists.katipo.co.nz Subject: Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
Bruce,
I just did a 5.3 bib data extraction a few weeks ago. These steps did the trick for me:
Make sure to use short report option.
Bib Data Extraction:
Select Materials > Export
Select All Materials from Export menu
All the options should gray-out except for the output file
Select USMARC/852 Holdings Data
Click Browse to desktop and in the Output file field, enter your desired name.
Joel Sasse
Network Systems Administrator
Plum Creek Library System
507-376-5803
O
From: partners-bounces@bywatersolutions.com [mailto:partners-bounces@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partners@bywatersolutions.com Subject: [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
I realize we are probably one of the oldest and last hold outs converting from Spectrum 5.3 to a modern system. Anyone else convert from Spectrum to Koha that could give me some tips on extracting the data, our reports and exports just don't look like good usable data.
I have submitted and support ticket to Bywater, just thought I would ask the community to see if anyone had any tips.
Thanks
Bruce
--
Bruce Morgan
Technology Director
District MOSIS Contact
Potosi R-3 Schools
www.potosir3.org
brucem@potosir3.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Now I forgot to put anything in the CC address. Glad it’s 5 PM. True, so it wasn’t so bad after all. :-) Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O From: Chris Cormack [mailto:chrisc@catalyst.net.nz] Sent: Monday, March 17, 2014 4:48 PM To: Joel Sasse Cc: Koha@lists.katipo.co.nz; ByWater Partners List Subject: Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 Well he did say community :-) Chris On 18 March 2014 10:38:06 am NZDT, Joel Sasse <jsasse@plumcreeklibrary.net> wrote: Sorry, put the wrong email list in the CC box. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Joel Sasse Sent: Monday, March 17, 2014 3:33 PM To: 'Bruce Morgan' Cc: Koha@lists.katipo.co.nz Subject: Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 Bruce, I just did a 5.3 bib data extraction a few weeks ago. These steps did the trick for me: Make sure to use short report option. Bib Data Extraction: Select Materials > Export Select All Materials from Export menu All the options should gray-out except for the output file Sele ct USMARC/852 Holdings Data Click Browse to desktop and in the Output file field, enter your desired name. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O From: partners-bounces@bywatersolutions.com [mailto:partners-bounces@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partners@bywatersolutions.com Subject: [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 I realize we are probably one of the oldest and last hold outs converting from Spectrum 5.3 to a modern system. Anyone else convert from Spectrum to Koha that could give me some tips on extracting the data, our reports and exports just don't look like good usable data. I have submitted and support ticket to Bywater, just thought I woul d ask the community to see if anyone had any tips. Thanks Bruce -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
You can also export the circ logs (historical checkouts) and other information if you want circ history to be transferred over. (we did this last summer). we printed some for our own reference and some we sent to BywaterSolutions staff to load Advance bookings.csv fines.csv reserves.xls checkout history (as csv) patrons materials MaterialsChkedOut.csv materials messages (matmess.csv) Patron messages (patmess.csv) email me if you need specific instructions and I'll dig them out. Nancy Ladd Pillsbury Free Library PO Box 299 Warner NH 03278 (603) 456-2289 From: Joel Sasse Sent: Monday, March 17, 2014 5:59 PM To: 'Chris Cormack' Cc: Koha@lists.katipo.co.nz; ByWater Partners List Now I forgot to put anything in the CC address. Glad it’s 5 PM. True, so it wasn’t so bad after all. :-) Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O From: Chris Cormack [mailto:chrisc@catalyst.net.nz] Sent: Monday, March 17, 2014 4:48 PM To: Joel Sasse Cc: Koha@lists.katipo.co.nz; ByWater Partners List Subject: Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 Well he did say community :-) Chris On 18 March 2014 10:38:06 am NZDT, Joel Sasse <jsasse@plumcreeklibrary.net> wrote: Sorry, put the wrong email list in the CC box. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Joel Sasse Sent: Monday, March 17, 2014 3:33 PM To: 'Bruce Morgan' Cc: Koha@lists.katipo.co.nz Subject: Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 Bruce, I just did a 5.3 bib data extraction a few weeks ago. These steps did the trick for me: Make sure to use short report option. Bib Data Extraction: Select Materials > Export Select All Materials from Export menu All the options should gray-out except for the output file Sele ct USMARC/852 Holdings Data Click Browse to desktop and in the Output file field, enter your desired name. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O From: partners-bounces@bywatersolutions.com [mailto:partners-bounces@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partners@bywatersolutions.com Subject: [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3 I realize we are probably one of the oldest and last hold outs converting from Spectrum 5.3 to a modern system. Anyone else convert from Spectrum to Koha that could give me some tips on extracting the data, our reports and exports just don't look like good usable data. I have submitted and support ticket to Bywater, just thought I woul d ask the community to see if anyone had any tips. Thanks Bruce -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
If it helps, we did this just last year. We're still working some kinks out, and probably will continue to do so for some time, but here are the notes I put together as I worked through the process. Joel Coehoorn Director of Information Technology York College, Nebraska 402.363.5603 jcoehoorn@york.edu *The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society* On Mon, Mar 17, 2014 at 4:59 PM, Joel Sasse <jsasse@plumcreeklibrary.net>wrote:
Now I forgot to put anything in the CC address. Glad it's 5 PM.
True, so it wasn't so bad after all. :-)
Joel Sasse
Network Systems Administrator
Plum Creek Library System
507-376-5803
O
From: Chris Cormack [mailto:chrisc@catalyst.net.nz] Sent: Monday, March 17, 2014 4:48 PM To: Joel Sasse Cc: Koha@lists.katipo.co.nz; ByWater Partners List Subject: Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
Well he did say community :-)
Chris
On 18 March 2014 10:38:06 am NZDT, Joel Sasse <jsasse@plumcreeklibrary.net> wrote:
Sorry, put the wrong email list in the CC box.
Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Joel Sasse Sent: Monday, March 17, 2014 3:33 PM To: 'Bruce Morgan' Cc: Koha@lists.katipo.co.nz Subject: Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
Bruce,
I just did a 5.3 bib data extraction a few weeks ago. These steps did the trick for me:
Make sure to use short report option.
Bib Data Extraction:
Select Materials > Export
Select All Materials from Export menu
All the options should gray-out except for the output file
Sele ct USMARC/852 Holdings Data
Click Browse to desktop and in the Output file field, enter your desired name.
Joel Sasse
Network Systems Administrator
Plum Creek Library System
507-376-5803
O
From: partners-bounces@bywatersolutions.com [mailto:partners-bounces@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partners@bywatersolutions.com Subject: [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
I realize we are probably one of the oldest and last hold outs converting from Spectrum 5.3 to a modern system. Anyone else convert from Spectrum to Koha that could give me some tips on extracting the data, our reports and exports just don't look like good usable data.
I have submitted and support ticket to Bywater, just thought I woul d ask the community to see if anyone had any tips.
Thanks
Bruce
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Chris Cormack -
Coehoorn, Joel -
Joel Sasse -
pfl@tds.net