Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
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 jcoeho...@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 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:chr...@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 > 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-boun...@lists.katipo.co.nz > [mailto:koha-boun...@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-boun...@bywatersolutions.com > [mailto:partners-boun...@bywatersolutions.com] On Behalf Of Bruce Morgan > Sent: Monday, March 17, 2014 9:11 AM > To: partn...@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 > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
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:chr...@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 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-boun...@lists.katipo.co.nz [mailto:koha-boun...@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-boun...@bywatersolutions.com [mailto:partners-boun...@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partn...@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
Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
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:chr...@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 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-boun...@lists.katipo.co.nz [mailto:koha-boun...@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-boun...@bywatersolutions.com [mailto:partners-boun...@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partn...@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
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 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-boun...@lists.katipo.co.nz >[mailto:koha-boun...@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-boun...@bywatersolutions.com >[mailto:partners-boun...@bywatersolutions.com] On Behalf Of Bruce >Morgan >Sent: Monday, March 17, 2014 9:11 AM >To: partn...@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 > >bru...@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. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [ByWater Partners] Data Conversion from Winnebago Spectrum 5.3
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-boun...@lists.katipo.co.nz [mailto:koha-boun...@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-boun...@bywatersolutions.com [mailto:partners-boun...@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partn...@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 bru...@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
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-boun...@bywatersolutions.com [mailto:partners-boun...@bywatersolutions.com] On Behalf Of Bruce Morgan Sent: Monday, March 17, 2014 9:11 AM To: partn...@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 bru...@potosir3.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha