Vox Populi(x) forum

Alexandria Book Library => Richieste (Requests) => Topic started by: Bert Heijenga on 10 January 2013, 22:27:51

Title: upgrade
Post by: Bert Heijenga on 10 January 2013, 22:27:51
Could you - the makers of Alexandria Book Library) - please have a thorough look at your upgrade process from version 1.1.2 to 2.0.4?
We are still running a Joomla 1.5 website, which we have to upgrade, because as you know 1,5 is no longer maintained. Our website historischleek.nl (about local history)  contains a library with over a 1000 entries. Apart from the booktitle and author we also have data for category, year, editor, library, location and bookcover.
In the upgrade process only booktitle and author are copied, whatever transfer method we try: sql or cvs (as mentioned on your site). The bookcovers do not show up, although they are during the Joomal upgrade process copied to the right directory /jupgrade/images/abook.
We are not looking forward to manually add again al the data! On your forum "support" we got no usefull answers to our questions.
At our site  you can see for yourself that version 1.1.2 is fully functional.
Greetings,
Bert Heijenga, maintainer.

beheerder@historischleek.nl
Title: Re: upgrade
Post by: federica on 11 January 2013, 13:48:16
Hi Bert,
what is the location where you have stored the images?
The 1.1.2 version is no longer developed. I put this information at our site, thank you for notice.
Title: Re: upgrade
Post by: Bert Heijenga on 11 January 2013, 15:18:57
I know that. Hence the upgrade!
Location of bookcovers is /jupgrade/images/abook

Bert
Title: Re: upgrade
Post by: A. Wayne Webb on 11 January 2013, 16:34:22
Quote from: Bert Heijenga on 11 January 2013, 15:18:57
I know that. Hence the upgrade!
Location of bookcovers is /jupgrade/images/abook

Bert

Bert,

Just a thought.  Your site is at <http://historischleek.nl/> and I am assuming that your upgrade site is at <http://historischleek.nl/upgrade>.  I see no difference between the two. I see a thumbnail of the book cover.  Can I assume that your problem has been successfully resolved. I was viewing this book (http://translate.google.com/translate?hl=en&sl=nl&tl=en&u=http%3A%2F%2Fhistorischleek.nl%2Fupgrade).  Which version of Joomla and ABL is on each site?

I might offer a suggestion, your facility being a regular library and not a personal book catalog.  In ABL in the Catalog Number field enter the string of text from your traditional cataloging system.  Furthermore, and I do not know if the Netherlands uses the Dewey Decimal System as we here in the United States do, using that string of text might be an option.  I created a library system for a group that had over 10,000 items, both archival material and books, and I plan on using ABL for their site.

One other thought...  Your library likely has stacks / book shelves that might be numbered.  Might I suggest that in ABL's Location field enter that data into it.  Use a string such as 23 / 1 which would be the 23rd stack and the 1st shelf in that stack.

In closing, I have upgraded about a half dozen or so sites now, using JUpgrade, and while it is fairly decent it is problematic.  Whatever you do, stay at J2.5.6 as each site I upgraded to J2.5.8 had problems.  I had similar problems as you are having so please do not feel bad. I will try to help if I can.

Cordially,
Wayne
Title: Re: upgrade
Post by: Bert Heijenga on 11 January 2013, 17:43:35
Hallo Wayne,
no, the new site is at <http://historischleek.nl/jupgrade>. (notice the letter j)
There is definitely a difference between the two, as you' ll see. I did not fine tune the template, just took one.
and no, my problems are not solved yet.
Concerning the library: I use that field to store the name op the publisher, and location as the place of publication, I translated it ( in Dutch to   " uitgever"  = publisher  and " plaats van uitgave"=place of publication.

thanx for your help.

Bert
Title: Re: upgrade
Post by: federica on 11 January 2013, 17:48:01
Hi Bert,
if you are able to access mysql you can solve the image trouble with a query.
Make a copy of the database then run this query:
UPDATE #__abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''
substitute "#_" to your prefix. eg. sdd_abbook
Title: Re: upgrade
Post by: A. Wayne Webb on 12 January 2013, 14:05:00
Quote from: Bert Heijenga on 11 January 2013, 17:43:35
Hallo Wayne,
no, the new site is at <http://historischleek.nl/jupgrade>. (notice the letter j)
There is definitely a difference between the two, as you' ll see. I did not fine tune the template, just took one.
and no, my problems are not solved yet.
Concerning the library: I use that field to store the name op the publisher, and location as the place of publication, I translated it ( in Dutch to   " uitgever"  = publisher  and " plaats van uitgave"=place of publication.

thanx for your help.

Bert

Morning Bert,

Or at least it is morning here on the east coast of the U.S.A.  It seems that Federica has the correct solution to your problem.  Or at least as much as I understand about MySql databases.  She's pretty smart in that regard.

As to the comment you made in regards to the "Location" field you are setting yourself up for a heartache later on.  For the publisher you should create a "Tag" (not day either), calling it Publisher and into that enter the name of the publisher of your book.  For my needs I also created another tag, calling it binding, into which I place either Hardbound or Paperback.

For the "Location" field, that is intended to indicate the physical location of where the book is stored.  I have some location entries indicating a closed stack which is common in many archives.  We don't want everybody having access to those precious 17th or 18th Century publications.  Or the earlier ones either, as they are all too fragile to handle on a come-as-you-may basis.

But since you already have it mixed up I am sure that Federica could come up with a MySql query correcting this oversight.  A few kronors, lire, dollars, etc. would definitely help to grease the wheels to use an American euphemism.  In other words, take the "Location" field, copy all those entries, and paste them into a "Tag" called Publisher.  I'm assuming that a routine would check to ensure that in the "ablocations" database it would check to make sure the data was correctly copied to the "abtag" database by the ID.  It would also need to take into account the "abbooktag" database.  This last database appears to be where the "abbook" and "abtag" databases meet, through the "idbook" and "idtag" fields.

As for how to use the "Location" field you can see this in play on my site (http://spidersrpgworld.com/index.php/home/boradorin-s-library/4-fiction-fantasy).  I set up the first two items, Bones of the Dragon and Bury Elminster Deep to demonstrate what I am saying.  Click into each of them and please note a string in the Location field.  The "Box 1" string it is in Box #1 which means it is stored in that archival box.  I do not have enough shelving to accommodate all of my collection and so a portion of it is stored away in boxes.  The string "Case 1 / 2" indicates that the book is housed in book case 1 on shelf 2.

A site I am developing for a historical society I work closely with needs to include another field that is used only here in America.  While everyone is accustomed to using the ISBN number, here in America we have another number used as well.  Our largest government archive is the Library of Congress.  For each item in their collection the maintain a catalog number.  This link (http://catalog.loc.gov/cgi-bin/Pwebrecon.cgi?v1=1&ti=1,1&Search_Arg=church%20of%20the%20brethren&Search_Code=TKEY%5E*&CNT=100&PID=ciZ6FCQ_fmdIwSi5zNbcHMTJ&SEQ=20130112073310&SID=3) is for those items with "Church of the Brethren" in their title.  They do not have every book though.

Meanwhile you may be familiar with WorldCat.Org.  This link (http://www.worldcat.org/search?q=church+of+the+brethren&qt=owc_search) is for the same partial title showing all their items.  Their numbering system is their own but since the organization is world wide it lists items not normally to be found here in America.  Again, they do not catalog everything. To be specific, and taking directly from your site I offer your listing from WorldCat for the first item in your catalog, "The Atlas of Huguenin, 1819-1829."  It can be found here (http://www.worldcat.org/title/atlas-van-huguenin-militair-topografische-kaarten-van-noord-nederland-1819-1829/oclc/65853600&referer=brief_results).  I would highly recommend that you use this site to fill in your database.

Hopefully in future renditions of ABL Federica and her cohorts will put in place other fields needed by bibliophiles and institutions.  I posted some of my thoughts in the "Suggestions" forum. I am especially interested in an add-in whereby I can ask ABL to go to WorldCat and plug in the data for a book or item.  She could use their OCLC number as a new field, similar to the ISBN field.

Cordially and with Best Wishes,
Wayne

P.S  I am a historian, and a bibliophile.  I have been a bibliophile since I was 6 years old, still owning some of my earliest books.  My personal collection includes many works of fiction as well as non-fiction extending mostly into historical works.  I have in my collection also many, many original archival documents from the late 18th and of the 19th Centuries.  Therefore my catalog, I run two of them, must meet many needs.
Title: Re: upgrade
Post by: Bert Heijenga on 12 January 2013, 19:38:49

QuoteUPDATE #__abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''
substitute "#_" to your prefix. eg. sdd_abbook
do you mean with " prefix"  the local storage location?
Bert
Title: Re: upgrade
Post by: Bert Heijenga on 12 January 2013, 19:49:24
Quote


Morning Bert,

Or at least it is morning here on the east coast of the U.S.A.  It seems that Federica has the correct solution to your problem.  Or at least as much as I understand about MySql databases.  She's pretty smart in that regard.

As to the comment you made in regards to the "Location" field you are setting yourself up for a heartache later on.
Maybe, but in version 1.1.2 there was no such thing as a Tag

QuoteFor the "Location" field, that is intended to indicate the physical location of where the book is stored.
I got that, but don't need it, all books are stored in one place.

QuoteBut since you already have it mixed up I am sure that Federica could come up with a MySql query correcting this oversight.  A few kronors, lire, dollars, etc. would definitely help to grease the wheels to use an American euphemism.  In other words, take the "Location" field, copy all those entries, and paste them into a "Tag" called Publisher.  I'm assuming that a routine would check to ensure that in the "ablocations" database it would check to make sure the data was correctly copied to the "abtag" database by the ID.  It would also need to take into account the "abbooktag" database.  This last database appears to be where the "abbook" and "abtag" databases meet, through the "idbook" and "idtag" fields.

What you are suggesting requires a knowledge of Mysql I suppose, that I do not have


QuoteMeanwhile you may be familiar with WorldCat.Org.  This link (http://www.worldcat.org/search?q=church+of+the+brethren&qt=owc_search) is for the same partial title showing all their items.  Their numbering system is their own but since the organization is world wide it lists items not normally to be found here in America.  Again, they do not catalog everything. To be specific, and taking directly from your site I offer your listing from WorldCat for the first item in your catalog, "The Atlas of Huguenin, 1819-1829."  It can be found here (http://www.worldcat.org/title/atlas-van-huguenin-militair-topografische-kaarten-van-noord-nederland-1819-1829/oclc/65853600&referer=brief_results).  I would highly recommend that you use this site to fill in your database.

I'll have a look into that, but first things first.

thanx again for your cooperation!

Bert
Title: Re: upgrade
Post by: federica on 12 January 2013, 20:03:12
In the old database (ABL 1.1.2) there isn't the complete path for the images but the filename only. You have to run the query for add the path before the filename for each book.
You can see the database table prefix in the joomla global configuration->server->database settings->Database Tables Prefix
Title: Re: upgrade
Post by: dario on 12 January 2013, 20:31:15
Hi Bert, i'll try to help you if possible.
Quote from: Bert Heijenga on 12 January 2013, 19:38:49
QuoteUPDATE #__abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''
substitute "#_" to your prefix. eg. sdd_abbook
do you mean with " prefix"  the local storage location?
Bert

QuoteWhat you are suggesting requires a knowledge of Mysql I suppose, that I do not have
Yes, but also not so much. There are some programs that can help you to do that job. For example there is one called PhpMyAdmin that i can be very useful for that.

Follow what Federica said :
QuoteYou can see the database table prefix in the joomla global configuration->server->database settings->Database Tables Prefix

Then use PhpMyAdmin to execute the query:
UPDATE #__abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''
the two characters "#" and the second "_" must be substituted with the prefix you found in configuration, then, for example if your prefix is "aaa" the query will be
UPDATE aaa_abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''

If you have access to the console of the server in which joomla is installed you can input the query from command line. But let us to know if you can use PhpMyAdmin.

I hope I have made less confusion!
Title: Re: upgrade
Post by: Bert Heijenga on 13 January 2013, 15:54:13
Federica and Dario,
Thank you. I misunderstood the term prefix, of course it's the prefix for the Mysql-table - j17 in my case. I have indeed access to PhpMyadmin on the server, and was able to fix the path to the folder containing the covers. That' s working now. Only four problems left now, the "author", "editor" , " library"  and " location " issues.
If that could also be solved with mysql queries you would make me very happy!
and FYI: after I imported all the books via CVS, the mysql -tables j17_abauthor, j17_abbookauthor,  j17_abeditor, j17_ablibrary and j17_ablocations all seem to be empty. (Most of) the bookinfo is in j17_abbook. The corresponding  Joomla 1.5 tables with prefix jos_ are still in the database and they contain the right data. Might it - mayby after some mods - be possible to rename them to j17_ tables, or is this a stupid remark?

Bert
Title: Re: upgrade
Post by: dario on 13 January 2013, 19:01:21
Well Bert, yes, after some mods those tables can be used on behalf of new tables. In particular you have to check which column are present in new tables and add them. Also there are some column to rename. After that you can rename to j17_ prefix.
Keep in mind that: you can create (in new tables of abook) a sample book,author,category, and so on for every tables. Then compare what you find here with what you have in old tables. Make appropriate modification for colums ad relative content. This will give you abook working.

I'm working to make a tutorial to do that or to make a script that automate this. But I don't know when this will or could be done.
Then I think you can achieve successful results in minor time with managing tables by yourself  :)
Title: Re: upgrade
Post by: Bert Heijenga on 27 March 2013, 11:58:01
Do you have a solution already for my problem? You said you were working on a script. I tried to convert the old tables in the database; it's a hell of a job, and some worked, others did not, so I still do not have a working library in Joomla 2.5 - and my provider is urging me to upgrade!I had to  upgrade the site to Joomla 2,5, so now we do not have a working library!

greetz,
Bert
Title: Re: upgrade
Post by: dario on 09 May 2013, 10:48:47
Hi Bert, there's no spare time. We are working hard on business activities and we can't spend time on this. I'm sorry, I hope to do something in future, but for now there's no light down the the tunnel :)