The OCLC Developer Network supports the use of OCLC Web Services—a set of tools and APIs that expose data and services for WorldCat and our member libraries and partner institutions or companies. learn more »
© 2010 OCLC Domestic and international trademarks and/or service marks of OCLC Online Computer Library Center, Inc. and its affiliates
Comments
A couple of suggestions
This looks like an interesting application, with potential for small libraries. A few comments & suggestions for minor fixes, before it goes to production:
1) Why does the application run on the user's server, instead of on OCLC's? This seems like a service OCLC could offer. Would target users for this application have the technical expertise to install/maintain/secure it themselves?
2) The app asks for a TSV file. There should be a "help" link the user can click to learn about the format required (what columns, in what order).
3) Typo: should be "separated".
Thanks --Andy
Thanks for the comments and
Thanks for the comments and suggestions. I've tried to answer your questions below
The application is designed to run on a user's servers because it was built from the perspective of a developer in an individual library. The idea was to showcase what a developer in an individual library would be able to build and potentially share the code with others via something like Github. That being said I certainly will pass along to the groups that consider new products and services internally the idea that OCLC could offer a compare this spreadsheet of stuff with a library holdings service.
Yes, the app could have some sort of indication of how to format the TSV file. As what is being consumed is an Alibris specific format that they use with their customers, this didn't go into the original planning of the application and is kind of wrong for the application is originally conceptualized. It can't take any old TSV nor should it. It has to be a TSV representing Alibris' current inventory for a given subject area. Alibris sends these spreadsheets to libraries all the time and I didn't want to ask users who had a these proprietary spreadsheets to have to do much fiddling with them to use this app. As a result the app is meant to just deal with THAT kind of spreadsheet which has not just the book metadata but also the Alibris pricing, condition and inventory numbers. Ultimately the app needs all the Alibris specific data to get the job done and a more generalized TSV wouldn't have that information.
That being said, some potential refactoring is going on with this application right now. Some of that has to do with the fact that I'd like to provide a more generic, compare this spreadsheet of stuff with a given library's holdings application, which would potentially not need to have the data submitted with particular columns. Another possibility would be to fork the code and refactor it to provide a generic create an order from a TSV tool as well. A final option would be to build a application that consumes a file of metadata for items, goes out and provides pricing and availability information from several supplies and then lets the library staff person select what should be ordered. The beauty of this model is that the application could be designed to be smart enough to create seperate orders within WMS for each vendor being ordered from.
Ultimately, there are lots of possibility. My hope in creating this was to get people thinking about the possibilities that having these types of web services available presents and to demonstrate some practical applications of what could be built.