Re: [CODE4LIB] Preserving hyperlinks in conversion from Excel/googledocs/anything to PDF (was Any ideas for free pdf to excel conversion?)
Hi, Could you use perl's PDF::Create? (http://search.cpan.org/~markusb/PDF-Create-1.06/lib/PDF/Create.pm) Alternatively, on a bash command line I've used a couple of commands to print a given file to a pdf: enscript -q --margins=::10: -L 60 -B -p outputfile.ps inputfile.txt ps2pdfwr outputfile.ps outputfile.pdf This took a file and used enscript to make it a .ps file, then converted ps to pdf with ps2pdfwr. This worked fine for plain text, but I can't swear that it will work with a bunch of hyperlinks. Hope this helps! Joe Montibello, MLIS Library Systems Manager Dartmouth College Library 603.646.9394 joseph.montibe...@dartmouth.edu On 3/5/12 8:46 AM, Matt Amory matt.am...@gmail.com wrote: Does anyone know of any script library that can convert a set of (~200) hyperlinks into Acrobat's goofy protocol? I do own Acrobat Pro. Thanks On Wed, Dec 14, 2011 at 1:08 PM, Matt Amory matt.am...@gmail.com wrote: Just looking to preserve column structure. -- Matt Amory (917) 771-4157 matt.am...@gmail.com http://www.linkedin.com/pub/matt-amory/8/515/239 -- Matt Amory (917) 771-4157 matt.am...@gmail.com http://www.linkedin.com/pub/matt-amory/8/515/239
[CODE4LIB] OAI provider testing tool
Dear Code4Lib, This is a simple one page web form that creates correctly formatted OAI requests that appear as live links on the page. All code is html and javascript contained in the one file. There is a menu for switching between different base URLs because we have multiple providers and test platforms. I have followed the rules set out in http://www.openarchives.org/OAI/2.0/openarchivesprotocol.htm#Protocol... There are links on the web page to help the user quickly locate specific terms and rules from openarchives.org. I try to catch errors that occur as the web form is filled out, but no guarantees! This webpage is at: http://diglib.lib.utk.edu/oai/testOAI/ Feel free to use in place or to download and revise to suit your own needs. cheers! Cricket Deane
[CODE4LIB] Microsoft Transit-SQL
I am looking for a good text on Microsoft Transit-SQL. I have searched high and low and all I find are books focused on Microsoft SQL Server. I am not setting up a server, I need to teach myself the database structure and language. Any suggestions? I did order Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies from Amazon because it has a large section on Transit-SQL. - Wilfred (Bill) Drew, M.S., B.S., A.S. Assistant Professor Librarian, Systems and Tech Services/Electronic Resources/Serials Tompkins Cortland Community College (TC3) Library: http://www.tc3.edu/library/ Dryden, N.Y. 13053-0139 Follow the library: http://twitter.com/TC3Library E-mail: dr...@tc3.edu Phone: 607-844-8222 ext.4406 SKYPE/Twitter:BillDrew4 SMS/TXT Me: 6072182217 Website: http://BillTheLibrarian.com StrengthsQuest Strengths: Ideation, Input, Learner, Command, Analytical http://www.facebook.com/billdrew One thing about eBooks that most people haven't thought much is that eBooks are the very first thing that we're all able to have as much as we want other than air. -- Michael Hart, Project Gutenberg Please consider the environment before printing this e-mail or document.
Re: [CODE4LIB] Microsoft Transit-SQL
I am looking for a good text on Microsoft Transit-SQL. I have searched high and low and all I find are books focused on Microsoft SQL Server. Do you mean Transact-SQL (which I usually just see abbreviated T-SQL) ? The online documentation at msdn isn't great, but it's not horrible. That's usually what I use. I mean, usually it's just a matter of looking up how it implements SQL and some of the local variants. (Do you need recommendations for books on SQL?) Jon Gorman
Re: [CODE4LIB] OAI Provider Testing Tool
You might also want to look here, http://re.cs.uct.ac.za/, which allows you to interactively explore an OAI provider, and it can also run a suite of tests against an OAI provider. Tom -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Cricket Sent: Tuesday, March 06, 2012 10:48 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] OAI Provider Testing Tool Dear Code4Lib, This is a simple one page web form that creates correctly formatted OAI requests that appear as live links on the page. All code is html and javascript contained in the one file. There is a menu for switching between different base URLs because we have multiple providers and test platforms. I have followed the rules set out in http://www.openarchives.org/OAI/2.0/openarchivesprotocol.htm#Protocol. .. There are links on the web page to help the user quickly locate specific terms and rules from openarchives.org. I try to catch errors that occur as the web form is filled out, but no guarantees! This webpage is at: http://diglib.lib.utk.edu/oai/testOAI/ Feel free to use in place or to download and revise to suit your own needs. cheers! Cricket Deane
Re: [CODE4LIB] Autoscaling and streaming apps on EC2
The variability in traffic and the support for streaming in CloudFront does make this look like a good use of AWS. Just out of curiosity what is the user and staff client software that you are talking about? http://variations.sourceforge.net/ The demo movies at http://www.dlib.indiana.edu/projects/variations3/demos.html give a good introduction to what it does If you store your content in S3, and clients stream it directly from there (through CloudFront) you may not even need to autoscale your app. But I guess I'm still not clear on what the app is. Is it some kind of catalog of audio files. Is it distinct from the client/staff software you mentioned? The core use case we're interested in (which appears to be the same one this software was designed for) is to support streaming music reserves. In other words, staff catalog and upload music and there's an easy interface that allows people to listen to music for specific classes that's access controlled as appropriate. It also lets you do stuff like diagram the structure of the music or read scanned scores. There is a web interface, but the functionality is not the same as the Windows and MacOS client/staff setup at this time kyle -- -- Kyle Banerjee Digital Services Program Manager Orbis Cascade Alliance baner...@uoregon.edu / 503.999.9787
Re: [CODE4LIB] Microsoft Transit-SQL
There's the O'Reilly book Transact-SQL Programming: http://shop.oreilly.com/product/9781565924017.do However, it's worth noting that the book is really out of date at this point. Mark On Tue, Mar 6, 2012 at 12:01 PM, Jon Gorman jonathan.gor...@gmail.com wrote: I am looking for a good text on Microsoft Transit-SQL. I have searched high and low and all I find are books focused on Microsoft SQL Server. Do you mean Transact-SQL (which I usually just see abbreviated T-SQL) ? The online documentation at msdn isn't great, but it's not horrible. That's usually what I use. I mean, usually it's just a matter of looking up how it implements SQL and some of the local variants. (Do you need recommendations for books on SQL?) Jon Gorman
Re: [CODE4LIB] Microsoft Transact-SQL
I was going to suggest O'Reilly's Transact-SQL Programming, but it's apparently out of print. Do you have access to Safari Books Online through your institution? If so, you can choose from many appropriate titles there and you can hop among them without commiting to any one in particular. Mark -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Wilfred Drew Sent: Tuesday, March 06, 2012 9:05 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Microsoft Transact-SQL I did mean Transact-SQL!! Sorry. I am after book recommendations. -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Jon Gorman Sent: Tuesday, March 06, 2012 12:02 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Microsoft Transit-SQL I am looking for a good text on Microsoft Transit-SQL. I have searched high and low and all I find are books focused on Microsoft SQL Server. Do you mean Transact-SQL (which I usually just see abbreviated T-SQL) ? The online documentation at msdn isn't great, but it's not horrible. That's usually what I use. I mean, usually it's just a matter of looking up how it implements SQL and some of the local variants. (Do you need recommendations for books on SQL?) Jon Gorman
[CODE4LIB] Job announcement: Director of Library Information Technology @ Cal State Northridge
DIRECTOR OF LIBRARY INFORMATION TECHNOLOGY Oviatt Library, California State University Northridge Under the general direction of the Dean, the Director of Library Information Technology is responsible for the conception, design, implementation, and operation of all systems and technology within and relating to the Library. This position provides creative vision and expertise in systems planning, using technologies that enhance operational effectiveness and improve access to library resources. For more details, required qualifications, and how to apply go to: http://www-admn.csun.edu/ohrs/employment/ The university is an equal opportunity, affirmative action employer, and does not discriminate on the basis of race, religion, national origin, sexual orientation, gender, marital status, age, disability, disabled veteran or Vietnam-era status.
Re: [CODE4LIB] Brett Bonfield wants to chat
You had me at chat, Brett Bonfield! On Tue, Mar 6, 2012 at 13:06, Brett Bonfield pace...@gmail.com wrote: --- Brett Bonfield wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-e9a82d6f75-ebad154aeb-xi0XRFne0OFA0g69pVkX2gOi91Y You'll need to click this link to be able to chat with Brett Bonfield. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with Brett Bonfield, visit: http://mail.google.com/mail/a-e9a82d6f75-ebad154aeb-xi0XRFne0OFA0g69pVkX2gOi91Y Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into conversations - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser).
Re: [CODE4LIB] Microsoft Transact-SQL
It is actually for a job I am interested in. I have no SQL experience in depth at all. Just some using Access. -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Jon Gorman Sent: Tuesday, March 06, 2012 1:39 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Microsoft Transact-SQL On Tue, Mar 6, 2012 at 11:05 AM, Wilfred Drew dr...@tc3.edu wrote: I did mean Transact-SQL!! Sorry. I am after book recommendations. Right, sorry, should have made myself clearer. Do you have previous experience with creating database queries? I can't say I have any real recommendations, but it might help others. (And you might be able to get away with a more general book on sql and then look through the online documentation for specific problems). Jon Gorman
Re: [CODE4LIB] Microsoft Transact-SQL
Then you might be best starting with a really good book on SQL in general, or 'standard' SQL. On 3/6/2012 1:42 PM, Wilfred Drew wrote: It is actually for a job I am interested in. I have no SQL experience in depth at all. Just some using Access. -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Jon Gorman Sent: Tuesday, March 06, 2012 1:39 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Microsoft Transact-SQL On Tue, Mar 6, 2012 at 11:05 AM, Wilfred Drewdr...@tc3.edu wrote: I did mean Transact-SQL!! Sorry. I am after book recommendations. Right, sorry, should have made myself clearer. Do you have previous experience with creating database queries? I can't say I have any real recommendations, but it might help others. (And you might be able to get away with a more general book on sql and then look through the online documentation for specific problems). Jon Gorman
Re: [CODE4LIB] Preserving hyperlinks in conversion from Excel/googledocs/anything to PDF (was Any ideas for free pdf to excel conversion?)
What exactly are you trying to do? Take a list of links and turn them into...a list of hot links in a PDF file? On Mon, Mar 5, 2012 at 8:46 AM, Matt Amory matt.am...@gmail.com wrote: Does anyone know of any script library that can convert a set of (~200) hyperlinks into Acrobat's goofy protocol? I do own Acrobat Pro. Thanks On Wed, Dec 14, 2011 at 1:08 PM, Matt Amory matt.am...@gmail.com wrote: Just looking to preserve column structure. -- Matt Amory (917) 771-4157 matt.am...@gmail.com http://www.linkedin.com/pub/matt-amory/8/515/239 -- Matt Amory (917) 771-4157 matt.am...@gmail.com http://www.linkedin.com/pub/matt-amory/8/515/239 -- Bill Dueber Library Systems Programmer University of Michigan Library
Re: [CODE4LIB] Preserving hyperlinks in conversion from Excel/googledocs/anything to PDF (was Any ideas for free pdf to excel conversion?)
Sounds like a job for LaTeX and a short bash script to me. cheers stuart On 07/03/12 07:55, Bill Dueber wrote: What exactly are you trying to do? Take a list of links and turn them into...a list of hot links in a PDF file? On Mon, Mar 5, 2012 at 8:46 AM, Matt Amorymatt.am...@gmail.com wrote: Does anyone know of any script library that can convert a set of (~200) hyperlinks into Acrobat's goofy protocol? I do own Acrobat Pro. Thanks On Wed, Dec 14, 2011 at 1:08 PM, Matt Amorymatt.am...@gmail.com wrote: Just looking to preserve column structure. -- Matt Amory (917) 771-4157 matt.am...@gmail.com http://www.linkedin.com/pub/matt-amory/8/515/239 -- Matt Amory (917) 771-4157 matt.am...@gmail.com http://www.linkedin.com/pub/matt-amory/8/515/239 -- Stuart Yeates Library Technology Services http://www.victoria.ac.nz/library/
Re: [CODE4LIB] Brett Bonfield wants to chat
Oh no. That didn't really happen. Sorry everyone. Brett On Tue, Mar 6, 2012 at 1:36 PM, Michael J. Giarlo leftw...@alumni.rutgers.edu wrote: You had me at chat, Brett Bonfield! On Tue, Mar 6, 2012 at 13:06, Brett Bonfield pace...@gmail.com wrote: --- Brett Bonfield wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-e9a82d6f75-ebad154aeb-xi0XRFne0OFA0g69pVkX2gOi91Y You'll need to click this link to be able to chat with Brett Bonfield. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with Brett Bonfield, visit: http://mail.google.com/mail/a-e9a82d6f75-ebad154aeb-xi0XRFne0OFA0g69pVkX2gOi91Y Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into conversations - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser).
[CODE4LIB] Fwd: New, lower pricing for Amazon EC2, RDS, and ElastiCache
We had this discussion last month about using EC2 for production services. They have dropped their pricing again, so a reserved 'small' instance is now $17.57/month after paying the one-time reservation fee of $160 for a 1-year term. That averages out to about $31/month. Peter Begin forwarded message: From: Amazon Web Services no-reply-...@amazon.commailto:no-reply-...@amazon.com Date: March 6, 2012 3:46:29 AM EST To: jes...@dltj.orgmailto:jes...@dltj.org jes...@dltj.orgmailto:jes...@dltj.org Subject: New, lower pricing for Amazon EC2, RDS, and ElastiCache [http://www.amazon.com/gp/r.html?R=39AI26RRIDYF9C=3A1P6LQ1HVVRHH=7YRAXSKNDAYZE02FQJGSBCSOPSYAT=OU=http%3A%2F%2Fimages.amazon.com%2Fimages%2FG%2F01%2Fnav%2Ftransp.gif] [http://g-ecx.images-amazon.com/images/G/01/webservices/AWS_LOGO._V2289989_.gif]http://www.amazon.com/gp/r.html?R=39AI26RRIDYF9C=3A1P6LQ1HVVRHH=RD1DSYS6HGAQGNIT4KWSX57RS94AT=CU=http%3A%2F%2Faws.amazon.com%3Fref_%3Dpe_12300_22960310 Dear Amazon Web Services Customer, We are excited to announce a reduction in Amazon EC2, Amazon RDS, and Amazon ElastiCache prices. Reserved Instance prices will decrease by up to 37% for Amazon EC2 and by up to 42% for Amazon RDS across all regions. On-Demand prices for Amazon EC2, Amazon RDS, and Amazon ElastiCache will drop by up to 10%. We are also introducing volume discount tiers for Amazon EC2, so customers who purchase a large number of Reserved Instances will benefit from additional discounts. Today’s price drop represents the 19th price drop for AWS, and we are delighted to continue to pass along savings to you as we innovate and drive down our costs. All of your On-Demand usage will automatically be charged at the new lower rate as of March 1st. New Reserved Instance prices will only apply to Reserved Instances purchases made on or after March 6th. With the new pricing, Reserved Instances will provide savings of up to 71% compared to On-Demand instances, so you may want to take this opportunity to review your current usage and to determine if you would like to purchase additional Light, Medium, or Heavy Utilization Reserved Instances. Please visit the Amazon EC2http://www.amazon.com/gp/r.html?R=39AI26RRIDYF9C=3A1P6LQ1HVVRHH=8A41IAA2LAD0AVEOSCH1CZMIA2QAT=CU=http%3A%2F%2Faws.amazon.com%2Fec2%2Fpricing%2F%3Fref_%3Dpe_12300_22960310, Amazon RDShttp://www.amazon.com/gp/r.html?R=39AI26RRIDYF9C=3A1P6LQ1HVVRHH=XIJESFUZLG5OD5CNDWZYCNPQCKCAT=CU=http%3A%2F%2Faws.amazon.com%2Frds%2Fpricing%2F%3Fref_%3Dpe_12300_22960310, and Amazon ElastiCachehttp://www.amazon.com/gp/r.html?R=39AI26RRIDYF9C=3A1P6LQ1HVVRHH=GLYVCASAOS6VZPYFJDWG0ZXCN70AT=CU=http%3A%2F%2Faws.amazon.com%2Felasticache%2Fpricing%2F%3Fref_%3Dpe_12300_22960310 pricing pages for the complete list of new lower prices and an overview of the new volume discount program. Sincerely, The Amazon Web Services Team We hope you enjoyed receiving this message. If you wish to remove yourself from receiving future product announcements and the monthly AWS Newsletter, please update your communication preferenceshttp://www.amazon.com/gp/r.html?R=39AI26RRIDYF9C=3A1P6LQ1HVVRHH=C3YPF5330PVZ42PVZACPNRQIKCOAT=CU=https%3A%2F%2Faws-portal.amazon.com%2Fgp%2Faws%2Fdeveloper%2Faccount%2Findex.html%2F104-4543842-2170300%3Fie%3DUTF8%26action%3Dedit-communication-preferences%26ref_%3Dpe_12300_22960310. Amazon Web Services LLC is a subsidiary of Amazon.comhttp://Amazon.com, Inc. Amazon.comhttp://Amazon.com is a registered trademark of Amazon.comhttp://Amazon.com, Inc. This message produced and distributed by Amazon Web Services, LLC, 410 Terry Ave. North, Seattle, WA 98109-5210. [http://www.amazon.com/gp/r.html?R=39AI26RRIDYF9C=3A1P6LQ1HVVRHH=DBTZL17FPQDDLWDXUZ5MOAFKAXAAT=EU=http%3A%2F%2Fimages.amazon.com%2Fimages%2FG%2F01%2Fnav%2Ftransp.gif]
[CODE4LIB] 'Send to Kindle' link
Can anyone advise on how to implement Send to Kindle' , as seen on the OpenLibrary site ( e.g. http://openlibrary.org/works/OL729827W/Correspondence) https://www.amazon.com/gp/digital/fiona/web-to-kindle?clientid=IAitemid=gauguing00gauguoftdocid=gauguing00gauguoft It looks like some sort of relationship with Amazon is necessary, but I can't seem to come up with any of the details.
Re: [CODE4LIB] 'Send to Kindle' link
It looks like that may even be a special relationship between OL/IA and Amazon/Kindle http://www.teleread.com/paul-biba/send-selected-full-text-ebooks-from-open-library-to-a-kindle-with-only-a-couple-of-clicks/ All other services that I know of need to use the Amazon Send to Kindle app or the Send to Kindle email address that is unique to each user. Pat On Wed, Mar 7, 2012 at 1:02 AM, Sara Amato sam...@willamette.edu wrote: Can anyone advise on how to implement Send to Kindle' , as seen on the OpenLibrary site ( e.g. http://openlibrary.org/works/OL729827W/Correspondence) https://www.amazon.com/gp/digital/fiona/web-to-kindle?clientid=IAitemid=gauguing00gauguoftdocid=gauguing00gauguoft It looks like some sort of relationship with Amazon is necessary, but I can't seem to come up with any of the details.