Thanks Claudia, your help got me up and running with DSpace 6 CSV importing through BTE, and with multiple authors! I have moved my code from a gist to a full-fledged GitHub repository, if any others want to perform batch importing like me:
https://github.com/silvae86/install-dspace6-in-ubuntu16 Thanks again! quinta-feira, 4 de Maio de 2017 às 12:35:26 UTC+1, Claudia Jürgen escreveu: > > P. S. > Found out how to use multiple values with BTE one has to define the > property valueSeparator > see > > https://github.com/DSpace/DSpace/blob/master/dspace/config/spring/api/bte.xml#L276 > > so adding the property to the bean csvDataLoader, e.g.: > <property name="valueSeparator" value="#" /> > and using this sample > title,authors,issued,journal,abstract,jissn,subtype > "Test BTE","Doe, Jane#Doe, John",2016,"The Journal Title","The > abstract","the jissn","the subtype" > worked > > Hope this helps > > Claudia Jürgen > > > > Am 03.05.2017 um 18:58 schrieb João Silva: > > Hello again and THANK YOU! > > > > My importing is working finally, and with customized fields. This gist > > <https://gist.github.com/silvae86/5838df542637d5059106c82c92728806> > > contains all my configuration and setup code for DSpace 6 so far, for > > others who may be hitting their head against the wall like me :-) > > > > The only thing not working is when I have more than one author. I tried > > using the double pipe || between authors, changing the double quotes > like > > so: > > > > ,"António Costa || Mário Centeno", > > > > ,"António Costa" || "Mário Centeno", > > > > ,""António Costa" || "Mário Centeno"" > > > > But DSpace does not separate the authors. Anything wrong with my CSV > (see > > excerpt below)? Do I need to activate something in the DSpace > > configurations to enable multiple value parsing? > > > > ,language,subtype,"António Costa || Mário Centeno",editors,illustrators, > > > > > > > > > > quarta-feira, 3 de Maio de 2017 às 11:43:03 UTC+1, Claudia Jürgen > escreveu: > >> Maybe just use the default csv batch import, you need not to configure > >> anything for it. > >> a csv like > >> id,collection,dc.title,dc.contributor.author,dc.date.issued > >> +,COLLECTIONID,"Test Title", "Doe, Jane",2017 > >> > >> Where COLLECTIONID is to be replaced by the collection id you want the > >> item to be imported to. > >> > >> Hope that helps > >> > >> Claudia Jürgen > >> > >> > >> > >> Am 03.05.2017 um 10:34 schrieb João Silva: > >>> I just realized that i may have forgotten to parametrize the <bean > >> name=" > >>> outputMap" class="java.util.HashMap" scope="prototype"> section of the > >>> bte.xml. I will try to fix and get back to you. > >>> > >>> At the end of my "journey" I will publish all my code on Github and > >> share > >>> it here as well for others who may face the same issues. > >>> > >>> terça-feira, 2 de Maio de 2017 às 18:08:42 UTC+1, João Silva escreveu: > >>>> Thank you all for your valuable input. > >>>> > >>>> Based on it, I configured my bte.xml as follows (only relevant > section > >>>> shown): > >>>> > >>>> > >>>> > >> > https://gist.github.com/silvae86/5838df542637d5059106c82c92728806#file-bte-xml > > >>>> Then, I tried to import the files (CSV or TSV) in attachment; I then > >> got > >>>> an error also in attachment... Has anyone seen this before? > >>>> > >>>> Thanks! > >>>> > >>>> terça-feira, 2 de Maio de 2017 às 12:32:45 UTC+1, helix84 escreveu: > >>>>> Sorry, I won't help you with BTE imports at the moment, but take a > >>>>> look at the "native" CSV import DSpace uses. This one surely works. > >>>>> > >>>>> https://wiki.duraspace.org/display/DSDOC6x/Batch+Metadata+Editing > >>>>> > >>>>> > >>>>> Regards, > >>>>> ~~helix84 > >>>>> > >>>>> Compulsory reading: DSpace Mailing List Etiquette > >>>>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > >>>>> > >>>>> > >>>>> > >>>>> On Tue, May 2, 2017 at 1:20 PM, João Rocha da Silva > >>>>> <[email protected]> wrote: > >>>>>> Hello again, > >>>>>> > >>>>>> I am sorry to insist, but this is quite urgent as we are building a > >>>>>> repository on a deadline and need to start data insertion on > >> thousands > >>>>> of > >>>>>> bibliographic references. We really want to use DSpace but we do > not > >>>>> know > >>>>>> how to have a working, simple batch import from a CSV for easy data > >>>>> entry. > >>>>>> What is the latest stable version that works with the samples > >> provided > >>>>> in > >>>>>> your documentation? > >>>>>> > >>>>>> Thank you very much and again sorry for insisting. > >>>>>> João Rocha da Silva > >>>>>> > >>>>>> quinta-feira, 27 de Abril de 2017 às 20:23:06 UTC+1, João Silva > >>>>> escreveu: > >>>>>>> Hello, > >>>>>>> > >>>>>>> I am trying to import the sample csv file from the > sample-files.zip > >>>>>>> available here > >>>>>>> (https://wiki.duraspace.org/pages/viewpage.action?pageId=68064788) > > >>>>> into a > >>>>>>> DSpace 6 fresh installation through the web UI, but all the > metadata > >>>>> fields > >>>>>>> become jumbled. I tried with BibTeX, EndNote, and CSV, etc etc for > >>>>> days now. > >>>>>>> Thought it could be encoding, CRLF issues (Unix/Windows) but still > >>>>> nothing > >>>>>>> works. > >>>>>>> > >>>>>>> Please see the attached picture with the result of an import of > the > >>>>> CSV > >>>>>>> file present in the samples zip; all the metadata fields are > >> jumbled. > >>>>>>> Can you please point me towards a version of DSpace that works > with > >>>>> those > >>>>>>> templates? > >>>>>>> > >>>>>>> Thank you very much, > >>>>>>> João Rocha > >>>>>> -- > >>>>>> You received this message because you are subscribed to the Google > >>>>> Groups > >>>>>> "DSpace Technical Support" group. > >>>>>> To unsubscribe from this group and stop receiving emails from it, > >> send > >>>>> an > >>>>>> email to [email protected]. > >>>>>> To post to this group, send email to [email protected]. > >>>>>> Visit this group at https://groups.google.com/group/dspace-tech. > >>>>>> For more options, visit https://groups.google.com/d/optout. > >> -- > >> Claudia Juergen > >> Eldorado > >> > >> Technische Universität Dortmund > >> Universitätsbibliothek > >> Vogelpothsweg 76 > >> 44227 Dortmund > >> > >> Tel.: +49 231-755 40 43 > >> Fax: +49 231-755 40 32 > >> [email protected] <javascript:> > >> www.ub.tu-dortmund.de > >> > >> Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. > Sie > >> ist ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der > für > >> diese E-Mail bestimmte Adressat sein, unterrichten Sie bitte den > Absender > >> und vernichten Sie diese Mail. Vielen Dank. > >> Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen > >> ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher > >> Schriftform (mit eigenhändiger Unterschrift) oder durch Übermittlung > eines > >> solchen Schriftstücks per Telefax erfolgen. > >> > >> Important note: The information included in this e-mail is > confidential. > >> It is solely intended for the recipient. If you are not the intended > >> recipient of this e-mail please contact the sender and delete this > message. > >> Thank you. Without prejudice of e-mail correspondence, our statements > are > >> only legally binding when they are made in the conventional written > form > >> (with personal signature) or when such documents are sent by fax. > >> > > -- > Claudia Juergen > Eldorado > > Technische Universität Dortmund > Universitätsbibliothek > Vogelpothsweg 76 > 44227 Dortmund > > Tel.: +49 231-755 40 43 > Fax: +49 231-755 40 32 > [email protected] <javascript:> > www.ub.tu-dortmund.de > > Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie > ist ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für > diese E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender > und vernichten Sie diese Mail. Vielen Dank. > Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen > ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher > Schriftform (mit eigenhändiger Unterschrift) oder durch Übermittlung eines > solchen Schriftstücks per Telefax erfolgen. > > Important note: The information included in this e-mail is confidential. > It is solely intended for the recipient. If you are not the intended > recipient of this e-mail please contact the sender and delete this message. > Thank you. Without prejudice of e-mail correspondence, our statements are > only legally binding when they are made in the conventional written form > (with personal signature) or when such documents are sent by fax. > -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
