Wow -- I hadn't even started looking, thank you. I am familiar with PostgreSQL -- used to design data bases, mostly Informix and PostgreSQL looks an awful lot like Informix (even comes with a version of ESQL/C for embedding SQL in a C program -- done a whole lot more of that than I like to think about). I've been switching my MySQL geographic data bases to PostgreSQL and that's going pretty well (and the dang thing is faster, too). That fiddling with locale was just one of those never-looked-at-before things in the midst of never-done-with before (Ant, Maven, Tomcat? Arrgghh!).
I've become familiar with Dublin Core (and MARC, the other coding schemes and who knows what-all) in the process of evaluating library management systems for this purpose; rapidly discovered that library management wasn't going to cut the mustard thus DSpace. Looked at Evergreen: no. Looked at KOHA: nope. Looked at a couple of other things that were interesting but incomplete for our needs. Even though about rolling my own (what the heck, LAMP is not a bad model), but no. That link to PgDBF is the berries -- probably save a whole heckuva lot of time and effort to get whatever we do actually have (and I have no idea how many records there are but I at least have a more-or-less schema so I at least know what's what). Thank you so much for that. About the personal collection, yeah, might as well do it in DSpace if for just the exercise (well, no, it's a good thing to get into DSpace). Nice thing about Tellico is that you can enter a title or an ISBN, do a search and import all the info from Amazon or other sites about a given book then update that from LOC and some other sites. You can input a UPC or ISBN and do the same for videos (including the cast list, director, producer, composer, etc.). Kind of like that. Quick, easy, useful but, according to the developer, a stretch for 60,000+ titles (with no ISBN, UPC, and probably not even a LOC number). It's a nice little application. So, off to the DSpace-General list and ask there, thanks. A riddle, wrapped in a mystery, inside an enigma but that's my story and I'm stickin' to it. On 07/31/2013 12:52 PM, helix84 wrote: > On Wed, Jul 31, 2013 at 6:16 PM, Thomas Ronayne > <[email protected]> wrote: >> Nope, no metadata, just a whole lot of physical items. Well, not quite -- >> there is a WinXP box with FoxBase (you know, obsolete since 1997 and totally >> unsupported and I'm not even sure how to spell FoxBase let alone have I ever >> seen it) that I'm going to need to unload to CSV files (I hope), massage >> with AWK or sed or something then try loading in the development system. If >> that proves to be impossible then we'll have just start from scratch and get >> on with it. > Don't do that. This tool worked for me: > http://pgdbf.sourceforge.net/ > > If you're not comfortable with Postgres, just goodle for something > like dbf to csv or dbf to Excel. > >> At a personal level, though, I have a library of some 2,000 books that are >> recorded in Tellico, a KDE-based collection manager that records and manages >> multiple collections (like books, music CD-ROM, videos, wine, coins, stamps, >> etc.) that I'm thinking about exporting and importing in my personal copy of >> DSpace. Robby Stevenson, the developer of Tellico, was the guy that >> suggested DSpace in the first place and he's willing to pitch in on >> exporting in reasonable format. That'll wait a few days (or weeks) until I >> get the institute going but it'll be an interesting exercise because all my >> books have acquired date, cost, vendor, ISBN, LOC numbers, genre, key words, >> descriptions and cover images, pretty complete (even has Dewey Decimal). >> Nice application but not multi-user and not DBMS. > So it seems like you want to catalogue your personal collection? We > mostly hear from institutions here, so usually there's someone they > can turn to locally. In your case you may not have a cataloguer easily > available. You might want to at least read something about Dublin > Core, which is the metadata standard DSpace uses internally. And of > course, dspace-general would be a good place to ask for help. > > In general, once you get your input data in XML, it's quite easy to > work with that using XSLT and get it to DSpace. There's even an > importer in DSpace that performs the transformation for you (once you > provide it with an XSLT stylesheet). > > > Regards, > ~~helix84 > > Compulsory reading: DSpace Mailing List Etiquette > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > ------------------------------------------------------------------------------ Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
