[Koha] Export Athena / import Koha

[RAC IT Department]

Actually here is the link..

https://www.dropbox.com/sh/dqxe494bn2gzo9z/AADIPau4cjKxbjbdn-80A5sha/marc?dl=0

In His Service,
Bill Kingsley
Rutland Area Christian School
IT Department Director
itdept at racsonline.org
www.racsonline.org


On Thu, Oct 2, 2014 at 8:02 PM, RAC IT Department <itdept at racsonline.org>
wrote:

> 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
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>
>>
>