Dear Zine Union Catalogers, I'm trying to convert Barnard Zine Library export files <https://lito.cul.columbia.edu/extracts/zines/> (mrc, txt, xml) to something I can open in a spreadsheet (csv, ods, xls, xlsx, idc) and map to import into CollectiveAccess, and I'm flailing around with zero success. I've asked the internet for help and poked around MARCedit and an XML converter, and they're all laughing at me. Anyone have a minute or thirty to help me out? Jenna -- http://lowereastsidelibrarian.info http://zines.barnard.edu http://leslzine.storenvy.com http://zinecat.org she, her _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org

INAL, and I don't have a ton of time today to throw at it, but in my cursory 3 minutes with teh googs, it looks like you might be able to go from MARCEdit to a tab-deliminated file?  From there you should be able to open it in LibreOffice or Eel and make it a csv? xoxoM -- Milo Miller Co-Founder the Queer Zine Archive Project http://www.qzap.org milo@qzap.org They/Them On 11/2/19 3:41 PM, Jenna Freedman wrote: > Dear Zine Union Catalogers, > > I'm trying to convert Barnard Zine Library export files > <https://lito.cul.columbia.edu/extracts/zines/> (mrc, txt, xml) to > something I can open in a spreadsheet (csv, ods, xls, xlsx, idc) and > map to import into CollectiveAccess, and I'm flailing around with zero > success. I've asked the internet for help and poked around MARCedit > and an XML converter, and they're all laughing at me. > > Anyone have a minute or thirty to help me out? > > Jenna > > -- > http://lowereastsidelibrarian.info > http://zines.barnard.edu > http://leslzine.storenvy.com > http://zinecat.org > she, her > > _______________________________________________ > Zlunioncat mailing list > Zlunioncat@lists.qzap.org > http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org

I found a converter <https://www.aconvert.com/>! Now I have an xlsx file that's AMJ columns long. Good times! On Sat, Nov 2, 2019 at 5:02 PM Milo <milo@qzap.org> wrote: > INAL, and I don't have a ton of time today to throw at it, but in my > cursory 3 minutes with teh googs, it looks like you might be able to go > from MARCEdit to a tab-deliminated file? From there you should be able to > open it in LibreOffice or Eel and make it a csv? > > xoxoM > > > -- > Milo Miller > Co-Founder > the Queer Zine Archive Projecthttp://www.qzap.orgmilo@qzap.org > They/Them > > On 11/2/19 3:41 PM, Jenna Freedman wrote: > > Dear Zine Union Catalogers, > > I'm trying to convert Barnard Zine Library export files > <https://lito.cul.columbia.edu/extracts/zines/> (mrc, txt, xml) to > something I can open in a spreadsheet (csv, ods, xls, xlsx, idc) and map to > import into CollectiveAccess, and I'm flailing around with zero success. > I've asked the internet for help and poked around MARCedit and an XML > converter, and they're all laughing at me. > > Anyone have a minute or thirty to help me out? > > Jenna > > -- > http://lowereastsidelibrarian.info > http://zines.barnard.edu > http://leslzine.storenvy.com > http://zinecat.org > she, her > > _______________________________________________ > Zlunioncat mailing listZlunioncat@lists.qzap.orghttp://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org > > _______________________________________________ > Zlunioncat mailing list > Zlunioncat@lists.qzap.org > http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org > -- http://lowereastsidelibrarian.info http://zines.barnard.edu http://leslzine.storenvy.com http://zinecat.org she, her _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org

And...the columns don't actually map by field, so never mind. On Sat, Nov 2, 2019 at 5:15 PM Jenna Freedman <leslzine@gmail.com> wrote: > I found a converter <https://www.aconvert.com/>! Now I have an xlsx file > that's AMJ columns long. Good times! > > > > On Sat, Nov 2, 2019 at 5:02 PM Milo <milo@qzap.org> wrote: > >> INAL, and I don't have a ton of time today to throw at it, but in my >> cursory 3 minutes with teh googs, it looks like you might be able to go >> from MARCEdit to a tab-deliminated file? From there you should be able to >> open it in LibreOffice or Eel and make it a csv? >> >> xoxoM >> >> >> -- >> Milo Miller >> Co-Founder >> the Queer Zine Archive Projecthttp://www.qzap.orgmilo@qzap.org >> They/Them >> >> On 11/2/19 3:41 PM, Jenna Freedman wrote: >> >> Dear Zine Union Catalogers, >> >> I'm trying to convert Barnard Zine Library export files >> <https://lito.cul.columbia.edu/extracts/zines/> (mrc, txt, xml) to >> something I can open in a spreadsheet (csv, ods, xls, xlsx, idc) and map to >> import into CollectiveAccess, and I'm flailing around with zero success. >> I've asked the internet for help and poked around MARCedit and an XML >> converter, and they're all laughing at me. >> >> Anyone have a minute or thirty to help me out? >> >> Jenna >> >> -- >> http://lowereastsidelibrarian.info >> http://zines.barnard.edu >> http://leslzine.storenvy.com >> http://zinecat.org >> she, her >> >> _______________________________________________ >> Zlunioncat mailing listZlunioncat@lists.qzap.orghttp://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org >> >> _______________________________________________ >> Zlunioncat mailing list >> Zlunioncat@lists.qzap.org >> http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org >> > > > -- > http://lowereastsidelibrarian.info > http://zines.barnard.edu > http://leslzine.storenvy.com > http://zinecat.org > she, her > -- http://lowereastsidelibrarian.info http://zines.barnard.edu http://leslzine.storenvy.com http://zinecat.org she, her _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org

 I found a converter <https://www.aconvert.com/>! Now I have an
 xlsx file that's AMJ columns long. Good times!



 On Sat, Nov 2, 2019 at 5:02 PM Milo <milo@qzap.org
 <mailto:milo@qzap.org>> wrote:

     INAL, and I don't have a ton of time today to throw at it, but
     in my cursory 3 minutes with teh googs, it looks like you
     might be able to go from MARCEdit to a tab-deliminated file? 
     From there you should be able to open it in LibreOffice or Eel
     and make it a csv?

     xoxoM


     --
     Milo Miller
     Co-Founder
     the Queer Zine Archive Project
     http://www.qzap.org
     milo@qzap.org  <mailto:milo@qzap.org>
     They/Them

     On 11/2/19 3:41 PM, Jenna Freedman wrote:

     Dear Zine Union Catalogers,

     I'm trying to convert Barnard Zine Library export files
     <https://lito.cul.columbia.edu/extracts/zines/> (mrc, txt,
     xml) to something I can open in a spreadsheet (csv, ods, xls,
     xlsx, idc) and map to import into CollectiveAccess, and I'm
     flailing around with zero success. I've asked the internet
     for help and poked around MARCedit and an XML converter, and
     they're all laughing at me.

     Anyone have a minute or thirty to help me out?

     Jenna

     -- 
     http://lowereastsidelibrarian.info
     http://zines.barnard.edu
     http://leslzine.storenvy.com
     http://zinecat.org
     she, her

     _______________________________________________
     Zlunioncat mailing list
     Zlunioncat@lists.qzap.org  <mailto:Zlunioncat@lists.qzap.org>
     http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org

     _______________________________________________
     Zlunioncat mailing list
     Zlunioncat@lists.qzap.org <mailto:Zlunioncat@lists.qzap.org>
     http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org



 -- 
 http://lowereastsidelibrarian.info
 http://zines.barnard.edu
 http://leslzine.storenvy.com
 http://zinecat.org
 she, her

Are there fields that you might want to dump exclude before export?  Things that just might not map to xZINECOREx/ZiMM? -- Milo Miller Co-Founder the Queer Zine Archive Project http://www.qzap.org milo@qzap.org They/Them On 11/2/19 4:22 PM, Jenna Freedman wrote: > And...the columns don't actually map by field, so never mind. > > On Sat, Nov 2, 2019 at 5:15 PM Jenna Freedman <leslzine@gmail.com > <mailto:leslzine@gmail.com>> wrote: > > I found a converter <https://www.aconvert.com/>! Now I have an > xlsx file that's AMJ columns long. Good times! > > > > On Sat, Nov 2, 2019 at 5:02 PM Milo <milo@qzap.org > <mailto:milo@qzap.org>> wrote: > > INAL, and I don't have a ton of time today to throw at it, but > in my cursory 3 minutes with teh googs, it looks like you > might be able to go from MARCEdit to a tab-deliminated file?  > From there you should be able to open it in LibreOffice or Eel > and make it a csv? > > xoxoM > > > -- > Milo Miller > Co-Founder > the Queer Zine Archive Project > http://www.qzap.org > milo@qzap.org <mailto:milo@qzap.org> > They/Them > > On 11/2/19 3:41 PM, Jenna Freedman wrote: >> Dear Zine Union Catalogers, >> >> I'm trying to convert Barnard Zine Library export files >> <https://lito.cul.columbia.edu/extracts/zines/> (mrc, txt, >> xml) to something I can open in a spreadsheet (csv, ods, xls, >> xlsx, idc) and map to import into CollectiveAccess, and I'm >> flailing around with zero success. I've asked the internet >> for help and poked around MARCedit and an XML converter, and >> they're all laughing at me. >> >> Anyone have a minute or thirty to help me out? >> >> Jenna >> >> -- >> http://lowereastsidelibrarian.info >> http://zines.barnard.edu >> http://leslzine.storenvy.com >> http://zinecat.org >> she, her >> >> _______________________________________________ >> Zlunioncat mailing list >> Zlunioncat@lists.qzap.org <mailto:Zlunioncat@lists.qzap.org> >> http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org > _______________________________________________ > Zlunioncat mailing list > Zlunioncat@lists.qzap.org <mailto:Zlunioncat@lists.qzap.org> > http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org > > > > -- > http://lowereastsidelibrarian.info > http://zines.barnard.edu > http://leslzine.storenvy.com > http://zinecat.org > she, her > > > > -- > http://lowereastsidelibrarian.info > http://zines.barnard.edu > http://leslzine.storenvy.com > http://zinecat.org > she, her > > _______________________________________________ > Zlunioncat mailing list > Zlunioncat@lists.qzap.org > http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org

I’m having MARCedit issues on my home computer. I should be able to do it for you on my work computer if you can wait till Monday. Typed on a teeny tiny keyboard. > On Nov 2, 2019, at 5:23 PM, Jenna Freedman <leslzine@gmail.com> wrote: >  And...the columns don't actually map by field, so never mind. > On Sat, Nov 2, 2019 at 5:15 PM Jenna Freedman <leslzine@gmail.com> wrote: > I found a converter! Now I have an xlsx file that's AMJ columns long. Good times! > > > >> On Sat, Nov 2, 2019 at 5:02 PM Milo <milo@qzap.org> wrote: >> INAL, and I don't have a ton of time today to throw at it, but in my cursory 3 minutes with teh googs, it looks like you might be able to go from MARCEdit to a tab-deliminated file? From there you should be able to open it in LibreOffice or Eel and make it a csv? >> >> xoxoM >> >> >> >> -- >> Milo Miller >> Co-Founder >> the Queer Zine Archive Project >> http://www.qzap.org >> milo@qzap.org >> They/Them >> On 11/2/19 3:41 PM, Jenna Freedman wrote: >>> Dear Zine Union Catalogers, >>> >>> I'm trying to convert Barnard Zine Library export files (mrc, txt, xml) to something I can open in a spreadsheet (csv, ods, xls, xlsx, idc) and map to import into CollectiveAccess, and I'm flailing around with zero success. I've asked the internet for help and poked around MARCedit and an XML converter, and they're all laughing at me. >>> >>> Anyone have a minute or thirty to help me out? >>> >>> Jenna >>> >>> -- >>> http://lowereastsidelibrarian.info >>> http://zines.barnard.edu >>> http://leslzine.storenvy.com >>> http://zinecat.org >>> she, her >>> >>> >>> _______________________________________________ >>> Zlunioncat mailing list >>> Zlunioncat@lists.qzap.org >>> http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org >> _______________________________________________ >> Zlunioncat mailing list >> Zlunioncat@lists.qzap.org >> http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org > > > -- > http://lowereastsidelibrarian.info > http://zines.barnard.edu > http://leslzine.storenvy.com > http://zinecat.org > she, her -- http://lowereastsidelibrarian.info http://zines.barnard.edu http://leslzine.storenvy.com http://zinecat.org she, her _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org

Thanks, love! I'm hoping to have a file to work with this weekend. I'm watching a 2010 Terry Reese video and getting error messages when I try to replicate his instructions. [image: image.png] Jenna On Sat, Nov 2, 2019 at 6:30 PM Rhonda Kauffman <rykauffman@gmail.com> wrote: > I’m having MARCedit issues on my home computer. I should be able to do it > for you on my work computer if you can wait till Monday. > > Typed on a teeny tiny keyboard. > > On Nov 2, 2019, at 5:23 PM, Jenna Freedman <leslzine@gmail.com> wrote: > >  > And...the columns don't actually map by field, so never mind. > > On Sat, Nov 2, 2019 at 5:15 PM Jenna Freedman <leslzine@gmail.com> wrote: > >> I found a converter <https://www.aconvert.com/>! Now I have an xlsx file >> that's AMJ columns long. Good times! >> >> >> >> On Sat, Nov 2, 2019 at 5:02 PM Milo <milo@qzap.org> wrote: >> >>> INAL, and I don't have a ton of time today to throw at it, but in my >>> cursory 3 minutes with teh googs, it looks like you might be able to go >>> from MARCEdit to a tab-deliminated file? From there you should be able to >>> open it in LibreOffice or Eel and make it a csv? >>> >>> xoxoM >>> >>> >>> -- >>> Milo Miller >>> Co-Founder >>> the Queer Zine Archive Projecthttp://www.qzap.orgmilo@qzap.org >>> They/Them >>> >>> On 11/2/19 3:41 PM, Jenna Freedman wrote: >>> >>> Dear Zine Union Catalogers, >>> >>> I'm trying to convert Barnard Zine Library export files >>> <https://lito.cul.columbia.edu/extracts/zines/> (mrc, txt, xml) to >>> something I can open in a spreadsheet (csv, ods, xls, xlsx, idc) and map to >>> import into CollectiveAccess, and I'm flailing around with zero success. >>> I've asked the internet for help and poked around MARCedit and an XML >>> converter, and they're all laughing at me. >>> >>> Anyone have a minute or thirty to help me out? >>> >>> Jenna >>> >>> -- >>> http://lowereastsidelibrarian.info >>> http://zines.barnard.edu >>> http://leslzine.storenvy.com >>> http://zinecat.org >>> she, her >>> >>> _______________________________________________ >>> Zlunioncat mailing listZlunioncat@lists.qzap.orghttp://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org >>> >>> _______________________________________________ >>> Zlunioncat mailing list >>> Zlunioncat@lists.qzap.org >>> http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org >>> >> >> >> -- >> http://lowereastsidelibrarian.info >> http://zines.barnard.edu >> http://leslzine.storenvy.com >> http://zinecat.org >> she, her >> > > > -- > http://lowereastsidelibrarian.info > http://zines.barnard.edu > http://leslzine.storenvy.com > http://zinecat.org > she, her > _______________________________________________ > Zlunioncat mailing list > Zlunioncat@lists.qzap.org > http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org > -- http://lowereastsidelibrarian.info http://zines.barnard.edu http://leslzine.storenvy.com http://zinecat.org she, her _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org

Update: I got the file wrangled (thanks Tina Gross!). We've uploaded ABC No Rio and Carnegie Library of Pittsburgh so far. We'll get Barnard, Denver, Duke, and QZAP tomorrow if we're blessed. w00t or even yeet, which is what the kids are saying these days! Jenna On Sat, Nov 2, 2019 at 6:58 PM Jenna Freedman <leslzine@gmail.com> wrote: > Thanks, love! I'm hoping to have a file to work with this weekend. I'm > watching a 2010 Terry Reese video and getting error messages when I try to > replicate his instructions. > > [image: image.png] > > Jenna > > On Sat, Nov 2, 2019 at 6:30 PM Rhonda Kauffman <rykauffman@gmail.com> > wrote: > >> I’m having MARCedit issues on my home computer. I should be able to do it >> for you on my work computer if you can wait till Monday. >> >> Typed on a teeny tiny keyboard. >> >> On Nov 2, 2019, at 5:23 PM, Jenna Freedman <leslzine@gmail.com> wrote: >> >>  >> And...the columns don't actually map by field, so never mind. >> >> On Sat, Nov 2, 2019 at 5:15 PM Jenna Freedman <leslzine@gmail.com> wrote: >> >>> I found a converter <https://www.aconvert.com/>! Now I have an xlsx >>> file that's AMJ columns long. Good times! >>> >>> >>> >>> On Sat, Nov 2, 2019 at 5:02 PM Milo <milo@qzap.org> wrote: >>> >>>> INAL, and I don't have a ton of time today to throw at it, but in my >>>> cursory 3 minutes with teh googs, it looks like you might be able to go >>>> from MARCEdit to a tab-deliminated file? From there you should be able to >>>> open it in LibreOffice or Eel and make it a csv? >>>> >>>> xoxoM >>>> >>>> >>>> -- >>>> Milo Miller >>>> Co-Founder >>>> the Queer Zine Archive Projecthttp://www.qzap.orgmilo@qzap.org >>>> They/Them >>>> >>>> On 11/2/19 3:41 PM, Jenna Freedman wrote: >>>> >>>> Dear Zine Union Catalogers, >>>> >>>> I'm trying to convert Barnard Zine Library export files >>>> <https://lito.cul.columbia.edu/extracts/zines/> (mrc, txt, xml) to >>>> something I can open in a spreadsheet (csv, ods, xls, xlsx, idc) and map to >>>> import into CollectiveAccess, and I'm flailing around with zero success. >>>> I've asked the internet for help and poked around MARCedit and an XML >>>> converter, and they're all laughing at me. >>>> >>>> Anyone have a minute or thirty to help me out? >>>> >>>> Jenna >>>> >>>> -- >>>> http://lowereastsidelibrarian.info >>>> http://zines.barnard.edu >>>> http://leslzine.storenvy.com >>>> http://zinecat.org >>>> she, her >>>> >>>> _______________________________________________ >>>> Zlunioncat mailing listZlunioncat@lists.qzap.orghttp://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org >>>> >>>> _______________________________________________ >>>> Zlunioncat mailing list >>>> Zlunioncat@lists.qzap.org >>>> http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org >>>> >>> >>> >>> -- >>> http://lowereastsidelibrarian.info >>> http://zines.barnard.edu >>> http://leslzine.storenvy.com >>> http://zinecat.org >>> she, her >>> >> >> >> -- >> http://lowereastsidelibrarian.info >> http://zines.barnard.edu >> http://leslzine.storenvy.com >> http://zinecat.org >> she, her >> _______________________________________________ >> Zlunioncat mailing list >> Zlunioncat@lists.qzap.org >> http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org >> > > > -- > http://lowereastsidelibrarian.info > http://zines.barnard.edu > http://leslzine.storenvy.com > http://zinecat.org > she, her > -- http://lowereastsidelibrarian.info http://zines.barnard.edu http://leslzine.storenvy.com http://zinecat.org she, her _______________________________________________ Zlunioncat mailing list Zlunioncat@lists.qzap.org http://lists.qzap.org/listinfo.cgi/zlunioncat-qzap.org