waves2ris was written by Peter Cordes , and is free to use and share, under the terms of the GNU GPLv2 (or later). http://www.gnu.org/licenses/gpl.html The easiest way to use this program (in Windows) is by dragging a .csv onto waves2ris.bat. A .ris file will be created in the directory the .csv is in. e.g. c:\foo\bar.csv is processed into c:\foo\bar.ris. If the waves2ris doesn't run into any problems, it will just exit when it's done, so the DOS window will close. If there is a problem with the CSV, the .bat file will pause, so the window stays open for you to read the error message. (That's the "press any key to continue . . ." message.) That's probably everything you need to know, but if you run into problems, you might find the rest of this README helpful. waves2ris reads CSV files from http://inter01.dfo-mpo.gc.ca/waves2/index.html They are formatted like: "1234","title: \"quoted text\" in the title","other fields","", ... don't break them by loading them in Excel with the wrong CSV settings: Excel defaults to " instead of \ as the escape character for the text delimiter inside strings. waves2ris writes out a file in RIS format, which will import into ProCite pretty well. Some things just end up in the Notes, because that's all ProCite can do with them. Also, the English and French abstracts get stuck together into one giant paragraph. This is ProCite's fault: I put them in separate RIS N2 tags. To install all this on a Windows computer, you will need: - perl, for example ActivePerl from http://activestate.com/activeperl/ when you install, choose the default of having it add Perl's bin directories to your Windows PATH and setting up .pl files to be run by perl, or the bat file won't work. - the Text::CSV perl package (use ActivePerl's ppm to install it) - The perl scripts and bat files (in e.g. "C:\Program Files\waves2ris") Probably you can move the directory this readme is in to c:\Program Files. (The actual location doesn't matter, but Program Files is a good place for it. The only reference to that directory will be the shortcut to the .bat file on the desktop.) - a shortcut (e.g. on your desktop) to the waves2ris.bat file, where you can drag .csv files onto it. In Windows, if you drag a file icon onto a .bat icon, it runs the bat file with the file as a parameter. This is easier than writing a GUI! If I make improvements to the script, you can update your copy with the darcs (http://darcs.net/) revision control system. http://wiki.darcs.net/DarcsWiki/Binaries. I used http://homepage.mac.com/kirby81_it/darcs/darcs-2.2.1-win1.zip but by the time you read this, a newer version of darcs may have replaced that, so get the "semi-official non-cygwin" binary from the wiki. Extract the darcs .zip to c:\Perl\site\bin (or to c:\program files\waves2ris, but ...\bin is better because ActivePerl's installer adds that to your PATH already.) Then you can run update-from-cordes.bat in the waves2ris directory. It will ask you whether you want to pull each available patch into your copy of the script. Probably you want to say yes (hit y) for each of them. Probably there will only be new patches if somebody asks me to improve something, so no need to check frequently. To install this on non-Windows, you probably only want the .pl. It writes to a .ris file of the same name as the first input file. Use it however you like. :)