Forums / Setting Up Categories, Products, Attributes / Product Type Book (by moku)

Product Type Book (by moku)

Started by moku on 12 May 2006, 6:37 AM · Views: 203,732

Results 481 to 500 of 647
19 Jan 2009, 9:58 PM
#481
donaldmo avatar

donaldmo

New Zenner

Join Date:
Jan 2009
Posts:
5
Plugin Contributions:
0

Product Type Book (by moku)

Yes!
I just followed your instruction and the problem was solved. Even there is no option for "PRODUCT Attribute Price Prefix - Default" ,
but this problem is gone, now my extra attribute price looks neat! now it looks , for example, ( +$5.00) and this is what I want!
Thank you very much Hareslade !

23 Jan 2009, 7:17 PM
#482
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: Product Type Book (by moku)

I'm reading thru this thread but was hoping someone might be able to save me some time (been at work on this and my other sites for a week and the mind is going:wacko:).
I actually have 2 sites that I'm hoping to use this on, but I need to know if it DOES or DOESN'T work with Easy Populate?
So far, I seem to have read a bit of both.

IF it does work, can someone tell me which should be installed first? This add-on OR the Easy Populate add-on?
I have EP installed already, but can reinstall a copy of my site prior to that install if it works better to do this one first.

Also, since one of the my 5 sites is for comics, is it easy enough to change fields, like the Author for example, to another name (Volume, Publish Date, Series #...)? OR can you turn off that field and use one of the custom fields for those ?

If anyone can offer any info on these questions it would be greatly appreciated by me and my family who don't seem to recognize me anymore unless I'm sitting infront of the computer scratching my head :unsure:
Thanks so much!

23 Jan 2009, 9:02 PM
#483
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: Product Type Book (by moku)

PLEASE HELP!

I installed following instructions and when I go to apply the sql patch I receive :

Error

SQL query:

DEFAULT CHARSET=latin1;

#-- --------------------------------------------------------
#-- DEFAULTS
#-- --------------------------------------------------------
#-- -------------
#-- Product Type:
#-- -------------
DELETE FROM product_types WHERE type_handler = 'product_book';

**MySQL said: **[IMG]http://lilleypadcove.com:2082/3rdparty/phpMyAdmin/themes/original/img/b_help.png[/IMG]
#1146 - Table 'jnothing_zc1.product_types' doesn't exist

what did I do wrong??? :cry:

23 Jan 2009, 9:52 PM
#484
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi Lilley etc
I don't think easy populate is compatible because it can't create the extra book data required
Its a technical prob, to do with the difference between creating a book in admin, and trying to do it 'remotely'

Various people have had a go at easypopulate, they may reply if they see this


sql complaining about 'jnothing_zc1.product_types' I assume your prefix (for all tables) is 'jnothing_zc1'
Its possibly saying the product_types table is missing, which is strange as its a zencart core table

Suggest you use your cpanel to check out the database tables prefixes, that means using phpmyadmin
Check what prefix they actually have, if its not 'jnothing_zc1' then you have a prob

Maybe you have several separate zc test sites, with different databases / table prefixes and they got mixed up during using backups . Not quite sure I understand any more than you do :) but I have an excuse because I've been working on joomla lately.

Regarding changing field display text labels yes that can be done by changing defines
for instance search the book fileset for 'Author', it'll be defined in /languages/english /somewhere

However, sometimes a particular field has a specifically set up display, for instance Authors are a special case, as you'll see from the way several authors can exist for a book and there is a special sidebox etc for searches,.

If you get to know the book filest and dabble in understanding basic php, find the display template via /includes/templates/(classic)/tpl_product_book_info_display.php thats where the fields are displayed

You can turn them on and off in admin as a lay person, use admin's product types, book, edit layout. There are lots of switches there.

zencart mods do tend to get you sat at the computer :) theres quite a lot of book setup info in the book fileset readme's

23 Jan 2009, 10:04 PM
#485
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: Product Type Book (by moku)

Thanks so much for replying.
Your first sentence says it all tho :cry: ... if it won't work with Easy Populate, then it won't work for me.
I have over 30,000 comics (just product for this store only!) and I enter them into a online database (ComicBookRealm.com) so that I can check cover pics to see that I have the correct book and info. I'm not a collector or know that much about comics, tho I have learned some stuff in the past few years since I obtained this large lot, but this gives me a way to check that all of my info is correct. My plan to make life so much easier was to download the exported file from there with all of the info and make a few changes to order and such to match up to the EP file and in one tap of a key, have a pile/box of 100+ books added with their correct info and all we have to do is scan and upload the pictures. Was supposed to be the easiest of my 5-7 stores :lookaroun.
I guess I will just have to figure out a way to get the info needed to match up to the Description field in EP and upload it from there. Guess I will have to get personal with Excel ...lol.. and see what it has to offer as far as the easiest way to get info from several fields merged into one field. I'm sure something is possible...was just hoping for the easiest.
I'm open to suggestions if anyone has anything to offer.
Thanks so much!
Lalla
P.S. I still might be able to use this for my Romance Novel store that I'm moving over to Zen from osC. Probably won't be using EP there because that is the site my Mom will be focusing on....have about the same amount of books, but at 81 she doesn't need the hassle EP can cause :wacko:.
Thanks again!:D

23 Jan 2009, 10:24 PM
#486
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Yeah you'll have to do it data-manually per book in zc admin probably

To be precise, EP can only upload title and other 'normal' fields as in an ordinary zc product, so you might if lucky, be able to upload just title, description, manufacturer (publisher) and price etc, but the extra data tables that book uses such as author, and publish dates etc .......those tables' data needs inserting by hand in zc admin so to speak.

To make EP work for books is so far defeating everyone, because the extra book data needs to know the new book's zencart i.d , and EP can't do two-stage partial uploads for each book. In other words, it doesn't know what i.d zencart will give the next book, so it can't generate the extra data.

I found EP rather unfriendly, it refuses to say why things don't work.. thats the limitation of a browser file upload system.

I'd really like to see EP converted for book data upload, or a bespoke php solution ...fraid its too big a job for me just now, but someone might go nuts and spend a month or 6 developing it (offers, anyone?)

23 Jan 2009, 10:33 PM
#487
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: Product Type Book (by moku)

If I'm not mistaken, osC has found a way to allow for both, but the whole package of creation there is harder then Zen so I don't even want to think about it. It might help someone in the future to check into it tho...especially if they are familuar with how both osC and Zen work and their differences.
I, however, don't have that kinda time or mind to even attempt it:smile:.
I've posted about excel and maybe someone will be able to help me there with just merging some info together and having it show in the fields that work with EP.
Thanks so much again!
Lalla

24 Jan 2009, 12:39 AM
#488
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: Product Type Book (by moku)

Ok, got the EP to work with a edited Excel file and was able to use a text editor to find tricks to get info merged together in the places that I needed it merged (since I can't make additional fields).

But

Can I still use the part of this add-on to create the Combined Search box ?
Or is that out for same reasons the rest of the add-on is out?

Thanks!

Ok, just reread the install file and it says that this is to add the Combined Search box for those fields added with this add-on... which I can not use because I really need Easy Populate to work ... so is there another thread that explains how to do that with in other ways?

30 Jan 2009, 10:30 PM
#489
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: Product Type Book (by moku)

Well, I'm back:blink:.
I have installed this on another of my sites for romance novels but I can't seem to figure out the fields and get them to work correctly.
For example, under Author, I can NOT stop and add a author everytime I add a book, so I normally use the first letter of the author's last name. This isn't working. Should I be putting that under Subtitle (By Nora Roberts) and then use the Author list to choose "R"? If so, how does a customer browse thru Author's by the letter R ?
Also, I need a field that is used for Series since some books are continued storylines but different authors and customers like to search for ones in the series that they are missing?
I just can't seem to wrap my brain around how some of this works. :cry:
Thanks!

30 Jan 2009, 11:34 PM
#490
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: Product Type Book (by moku)

I've been reading and re-reading and found that I needed to turn on the Author box, which I did... but ... it looks like it will only work "correctly" if I list the complete author's names. I see that I can "add" the name as I enter a book, but it takes you away from the product editing/insert page and doesn't take you back. It just seems insane to add every single author's name to a list instead of just sorting into categories by last name initial... but if I use the Author box for that you don't see who wrote the darn book all you see is a letter!
I must be looking at this in a totally wrong way.
My old site was a osC site so I am probably just confused because of the change over...well...atleast that's my excuse and I'm sticking to it! :D
Still haven't found a field to use for Series.

3 May 2009, 12:38 PM
#491
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Lilleypadgifts
its insanely stupid for me to reply months later, I didn't come here much I am doing a house up :)
.. the authors system can be a pain if one just doesn't want to do it like that..

The original design by Moku was done in this way because it eases the way the data is held... I used to run two logged in browser windows of admin, one to add authors, the other doing the normal product insertion once the new author is in.

The authors search sidebox does just list authors in alpahabetical order.. But if someone wants a another way of searching they can use the normal zencart searchbox to trace products , it should search authors names in its general search.

So use the full authors name otherwise it will give an odd authors sidebox search list just of your first letters.

5 May 2009, 3:09 PM
#492
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Re: Product Type Book (by moku)

Looking at product info (product_book_info) I can click on Author
and it should show me all books by that author Unfortunately it only does a refresh of the current page. I've seen that on several other sites it uses the "Hareslade-filters". How can I tell this ZenCart to use the "Hareslade-filters" ?
I'm using ZenCart 1.3.6.
Thanks!

5 May 2009, 11:16 PM
#493
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi biscayne
difficult to know why you get that prob, actually its almost certainly not a simple page refresh, its doing whatever it should, but there is some error arising on doing it, so the page is being returned to its source page on a 'redirect'. Which book zip are you using?

8 May 2009, 12:39 PM
#494
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Re: Product Type Book (by moku)

I'm using the filters from the ZC1.3.6d zip-file.
When I continue testing I see the following behaviour.
If there's more than 1 book by this author clicking on author links to the home page:
http://www.theatrebookshop.eu/index.php?main_page=index&book_authors_id=15620&typefilter=book_authors&zenid=qgo5an9bbot8tolvfsaqe17e70
If there's only 1 book by this author clicking the author refreshes the page:
http://www.theatrebookshop.eu/index.php?main_page=product_book_info&products_id=11603&zenid=qgo5an9bbot8tolvfsaqe17e70
I can't understand why this is happening :unsure:

8 May 2009, 1:29 PM
#495
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Re: Product Type Book (by moku)

Actually the problem shows with more than one book per author.
When I do an advanced search on author name with a program I wrote myself I get the correct result:
http://www.theatrebookshop.eu/index.php?op=2&zenid=qgo5an9bbot8tolvfsaqe17e70&typefilter=book_authors&main_page=advanced_book_search_result&keyword=Elia+Kazan&x=19&y=10
Also checked the data and they seem to be correct as well.
Why don't I get this result with :
http://www.theatrebookshop.eu/index.php?main_page=index&book_authors_id=15620&typefilter=book_authors&zenid=qgo5an9bbot8tolvfsaqe17e70
?
:frusty:

8 May 2009, 4:13 PM
#496
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

HI
The second link you quoted was

 /index.php?main_page=index&book_authors_id=15620&typefilter=book_authors

one from my own my own site,

 /index.php?book_authors_id=6&typefilter=book_authors&main_page=index

theres no diffence in the page url request format (given its two different id's on 2 sites) so it looks ok

but book_authors_id=15620 is a very high number, is there a reason for this?

you'll maybe have to work out how the book authors search works in the php, its too difficult to analyze from a distance,
specially as i get pages in german, and the book authors searchbox isn't apparently currently showing on your site

8 May 2009, 4:50 PM
#497
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Re: Product Type Book (by moku)

Thanks for thq quick reply.
The pages are in Dutch and in English
(http://www.theatreandfilmbooks.eu).
Search on author name is part of our own version of Advanced Search.
The number 15620 is rather high but even if it was 99999 that should not be causing this problem.
Putting the URL the same as your URL indeed does not change anything. Have there been any changes in data of the Product Type Book since ZC version 1.3.5 ?

8 May 2009, 10:13 PM
#499
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

oops, between us we are doing a terrible job of this. I am most apologetic to mix up dutch and german.. !

regarding the 15620 I was just interested to see how it got that high, usually it starts from author id = 1

---> history...

V1 book was for zencart 1.3.6, it was single language, currently i can't locate it on my site maybe it dropped off during the site changeover, or i thought the v2 for 1.3.7 was the better one to use.

I did the updated single language version for v1.3.7, ZC1_3_7_EXTENDED_MOKU BOOK_TYPE_JPH_V_2.zip 20 March 2007
at
http://www.jphuk.co.uk/zc/index.php?main_page=document_general_info&cPath=51&products_id=482
there was then also a V3 beta version of the multilanguage for 1.3.7 as well, see the green text on that page. Note, I am using the V3 beta in single language mode, on the above website.

The v1.3.8 book version v4 is at
http://www.jphuk.co.uk/zc/index.php?main_page=document_general_info&cPath=54&products_id=490

But you are using zencart v1.3.6 you say, so you're on v1 of book, but that only runs with a single language..? yet your site has two languages.. you need V3 (beta) multilanguage for multilanguage zencarts, and you need zencart v1.3.7 to run it in...
or use the v4 / zencart 1.3.8 setup

To run V3 beta in 1.3.6 zencart you'd have to go back and look at what zencart changed 1.3.6 -> 1.3.7, i can't tell if it works retrospectively.

To be honest yes, there were search bugs/mistakes fixed through those v1 to v4 versions, V4 is the best one, for zencart 1.3.8.
You should find a txt file in each version's fileset saying approximately what changed.

I know I sound like a company, 'but strictly you should be using latest zencart 1.3.8 if using multilanguage,' as the book v4 is the best debugged one, ...its a complex bit of kit the book add-on, i improved and corrected various things over time.

I don't have the book demo's for the 1.3.7 multilanguage any more, I dropped them when i moved website domain. The 1.3.8 demo's are on my signature below.

14 May 2009, 7:55 AM
#500
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Re: Product Type Book (by moku)

Indeed the cause of the high id for authors is historical (converted data).
Ever since installing the first Moku version of Product Type Book, I've been modifying and adding also quite a lot, so upgrading to version 1.3.8 will be not a straight forward job, also the bookstore does not see the advantage of having the latest version, they are OK with my "tailor made" version.
I'll dig into the several versions to see if I can find out what is causing this weird problem.
Thanks a lot for your explanation and all the links, this makes my job easier.