[Koha] Export Athena / import Koha

[RAC IT Department]

Hi Vikram,

It has been a busy week.,,

So I found a program that allowed me to export a .mrc file into an .xml
file which I opened in Microsoft Excel and then saved it to a .xlsx and
.csv file.

I converted all three files (one .mrc Athena export and two .mrc files that
were converted for import to Koha) and placed them in the following folder
so you can have a look...
https://www.dropbox.com/sh/dqxe494bn2gzo9z/AABywSMDgEaylTHOJPenxqZGa?dl=0

I was able to open all three different types of each file in Microsoft
Excel.

I took a look and it seems to me that the barcodes are present and in the
correct place for import into Koha. So the file seems to contain the
correct information. Could the problem be with the way that Koha is
handling the file? You mentioned something about mapping. Is there
something in Koha that I need to tweak in order to import this file?

Thank you for your time



Thanks,
Bill


On Tue, Sep 30, 2014 at 4:29 PM, RAC IT Department <itdept at racsonline.org>
wrote:

> So I looked high and low in Athena and did lots of research online and
> came up with nothing. The only way to export the Biblio from Athena is via
> .mrc file.
>
> I did find a program called MARC_Utilities.exe that will change it to csv
> but the file it outputs is odd... I put it in the dropbox folder i
> referenced earlier. Here is it again...
>
> https://www.dropbox.com/sh/og906kpdsh96u27/AABfm9UpGlUzgL6KNC53tFmza?dl=0
>
> I also added a txt file of the output from the mrc file exported from
> Athena. It is also in that folder.
>
> Hope that helps.
>
> I am away from my PC tonight on the road so I cannot connect with you.
>
> Thanks!
> Bill
>
>
>
> On Mon, Sep 29, 2014 at 3:35 AM, vikram zadgaonkar <
> vikramczadgaonkar at gmail.com> wrote:
>
>> I checked the file. We have only 5 fields :
>>
>>    1. call
>>    2. Title
>>    3. Author
>>    4. Barcode
>>    5. cost
>>
>> I think you need much more detials like publishing details, item
>> type(book/cd/serials).
>> Please check with your librarian and confirm.
>>
>> Vikram Zadgaonkar
>>
>> On Mon, Sep 29, 2014 at 8:56 AM, RAC IT Department <itdept at racsonline.org
>> > wrote:
>>
>>> https://www.dropbox.com/s/xgelmms3lminmmv/Biblio.pdf?dl=0
>>>
>>>
>>>
>>>
>>> Sent from my iPhone
>>>
>>> On Sep 28, 2014, at 11:22 PM, vikram zadgaonkar <
>>> vikramczadgaonkar at gmail.com> wrote:
>>>
>>> Ok. I will check.
>>> On 29-Sep-2014 8:51 AM, "RAC IT Department" <itdept at racsonline.org>
>>> wrote:
>>>
>>>> Yes. Ubuntu opens it. I will convert it to a PDF.
>>>>
>>>>
>>>>
>>>>
>>>> Sent from my iPhone
>>>>
>>>> On Sep 28, 2014, at 11:13 PM, vikram zadgaonkar <
>>>> vikramczadgaonkar at gmail.com> wrote:
>>>>
>>>> Can you read this file?
>>>>
>>>> Vikram Zadgaonkar
>>>>
>>>> On Mon, Sep 29, 2014 at 8:34 AM, RAC IT Department <
>>>> itdept at racsonline.org> wrote:
>>>>
>>>>> https://www.dropbox.com/s/6sf9r6hiczhf3ym/Biblio.xps?dl=0
>>>>>
>>>>>
>>>>>
>>>>> Sent from my iPhone
>>>>>
>>>>> On Sep 28, 2014, at 11:02 PM, vikram zadgaonkar <
>>>>> vikramczadgaonkar at gmail.com> wrote:
>>>>>
>>>>> I could not open this file. When I open in notepad data is corrupted.
>>>>>
>>>>> Vikram Zadgaonkar
>>>>>
>>>>> On Mon, Sep 29, 2014 at 7:58 AM, RAC IT Department <
>>>>> itdept at racsonline.org> wrote:
>>>>>
>>>>>> I poked around in Athena for a while and was able to generate the
>>>>>> attached file with a list of the holdings in Athena. Is this what you are
>>>>>> looking for?
>>>>>>
>>>>>> In His Service,
>>>>>> Bill Kingsley
>>>>>> Rutland Area Christian School
>>>>>> IT Department Director
>>>>>> itdept at racsonline.org
>>>>>> www.racsonline.org
>>>>>>
>>>>>>
>>>>>> On Sun, Sep 28, 2014 at 9:30 PM, vikram zadgaonkar <
>>>>>> vikramczadgaonkar at gmail.com> wrote:
>>>>>>
>>>>>>> Are you available ?
>>>>>>>
>>>>>>> Vikram Zadgaonkar
>>>>>>>
>>>>>>> On Mon, Sep 29, 2014 at 6:49 AM, vikram zadgaonkar <
>>>>>>> vikramczadgaonkar at gmail.com> wrote:
>>>>>>>
>>>>>>>> Connecting.
>>>>>>>> On 29-Sep-2014 6:42 AM, "RAC IT Department" <itdept at racsonline.org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> 863 460 978
>>>>>>>>> 29c4sn
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Sent from my iPhone
>>>>>>>>>
>>>>>>>>> On Sep 28, 2014, at 9:05 PM, vikram zadgaonkar <
>>>>>>>>> vikramczadgaonkar at gmail.com> wrote:
>>>>>>>>>
>>>>>>>>> I will be available in next 15 min.
>>>>>>>>> On 29-Sep-2014 4:42 AM, "RAC IT Department" <itdept at racsonline.org>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> I have loaded team weaver on to the PC with the Athena software
>>>>>>>>>> on it
>>>>>>>>>> and am at the location if you are available.
>>>>>>>>>>
>>>>>>>>>> Thanks,
>>>>>>>>>> Bill
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Sent from my iPhone
>>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>
>