Product Type Book (by moku)

[gxjenkins]

Hi,
I followed the install instructions for v2 but under Product Types I expected to see a new product, but didn't.
I have added a new product before installing this MOD, could it be conflicting?
Thanks.

[hareslade]

gxjenkins
yes in V2 you should see a new admin product type 'book-product', (i.d is 7) did you apply the sql patch?. Are there tables in the database named '...book...'?

Maybe it needs the database tables inspecting, the sql patch line that inserts book type is

INSERT INTO product_types VALUES (7, 'Product - Book', 'product_book', '1', 'Y', '', now(), now());

so inspect the 'product_types' table in phpmyadmin, probably from your host cpanel.

- it doesn't matter what products you already put in in 'other' product types, a new book product is addable once you have the book product type files installed, with the database sql patch **successfully** applied.

[gxjenkins]

I made some progress last night. I found under 'Admin', 'Extras' some things for Books, so something did happen. I still didn't have a Product Type for books.
I uploaded the files in the MOD for "EXTENDED_BOOK_MAIN_FILES", and in the catalog directory there was a folder "RUN_THIS_SQLPATCH_FOR_DATABASE". After running this patch the new Product Type was there.
I haven't figured out what the "Book DD2-DD" is for, but sofar everything seems to be working fine.
BTW, is anyone running the BETA? Does it fix any issues, or provide more than what is in V2? Just wondering.

[hareslade]

book dd2 (in extras) is one of the extra 'multiple value' fields, if you switch it on in admin | product type books | edit layout, it sticks an extra book field in your 'collect info' book page in admin, and on book cart display.

The six dd's fields can have more than one value selected .. the authors is an example (it's dd1 actually), you can link any number of authors to a single book.

There are many other 'unused' fields lurking as well there.. you don't have to use them unless you need them. The simpler ones are just single value fields, while the dd's can provide multiple values per book, chosen from your entered values in the corresponding 'extras'.

And before anyone asks.. blame moku for having to stick authors in admin 'extras' separately .. but he had very good reason to do it that way, it enables the book display of authors being immediately searchable for other books by that author, and this method a neater way of ensuring authors don't get repeated, with entering say one called 'D.J.Smith' and one called 'D.Smith' (and one Dave Smith) all at different times, once you forget what you called him first time..

=====
BETA 3

Well give the Beta 3 a chance.. its only been up a few days. I'm encouraging people to use V3 because I won't be updating V2 when a new zencart version comes out. Although V2 is quite ok, V3 is going to be the ongoing one.

I can't support updating V2 above 1.3.7, it means double work.. V3 code is handling potential multiple languages, the database has extra 'language i.d fields' not present in V2, the php coding is more complex.

V3 is the multi-language version, which the book product 'should' have been from day 1... so someone should use it and tell me anything needs fixing..

Most people will probably use V3 in single language anyway.. and you can upgrade from V2 to V3 using the upgrade section in the V3 download.

The main difference you notice in V3 versus v2, is that in single language you get a language flag by a lot of the book fields (even though its running single language), and the books admin page for products is laid out differently because it may need to display sets of data 'per language' when running multiple languages.

[hareslade]

btw
just to expand on the six 'dd' multiple choice fields,

For each book, imagine that values stored in that book's database field for 'authors' is a list separated by commas,

each 'author name' in that list is one of those selected in the book admin, from the 'multiple selection' dropdown box' for authors,

the master dropdown box list itself is created directly from the 'dd' entries (e.g authors) that you already loaded into in admin | extras.

Once you use it, it becomes obvious what it does...

[gxjenkins]

Thanks for the explanation. I added a few books last night, and I like it. I'm glad I only had 3 books listed before adding this MOD. I will get to V3 after a do a backup. I'm trying to sell one of my three stores, and I need to be ready to move the stock over if it sells. My poor little Thrift Shop is going to go from 90 items to about 1000. I hope the seems don't break.
Thanks for your help.

[raunharman]

I need to display the Book Title in a bigger font than other details. How do I do it.

Also if I donot write anything in the subtitles, can I stop the titel getting repeated in product display.

[amilcar]

hareslade
Just great job on V3 of PTB especially its support for multi languages! However, some little problems :
Authors and Publishers fields do not register any input in DB except for the images (V2 had no problems with that)
I upgraded from V2 to V3 and applied all the patches but errors occur when applying the last part of patch file ADMIN_PATCH_SQL_EXTENDED_BOOK_TYPE_V3
specifically the last section about filters :

#-- -------
#-- Filters
#-- -------

#jph added the other two blank fields to clear a 1.3.5 php error etc

INSERT INTO get_terms_to_filter (get_term_name, get_term_table, get_term_name_field)
VALUES ('book_genre_id','TABLE_BOOK_GENRE_DESCRIPTION','book_genre_name');
INSERT INTO get_terms_to_filter (get_term_name, get_term_table, get_term_name_field)
VALUES ('book_type_id','TABLE_BOOK_TYPE_DESCRIPTION','book_type_name');
INSERT INTO get_terms_to_filter (get_term_name, get_term_table, get_term_name_field)
VALUES ('book_authors_id','TABLE_BOOK_AUTHORS','book_authors_name');

#-----------< END >--------------------------------------------------

The error produced by the admin sql patch is:

1062 Duplicate entry 'book_genre_id' for key 1
in:
[INSERT INTO zen_get_terms_to_filter (get_term_name, get_term_table, get_term_name_field) VALUES ('book_genre_id','TABLE_BOOK_GENRE_DESCRIPTION','book_genre_name');]

Other than that other stuff works fine so far. I'm still testing this beta V3 and I'll share the experience with you all.

[hareslade]

Hi Amilcar

Thanks for trying V3 upgrade, the 'Duplicate entry 'book_genre_id' etc probably indicates you applied the full V3 sql patch for a new V3 install, rather than an upgrade patch?

You're supposed to use the update sql patch if you already have V2 book installed, maybe I didn't make that clear

Restore your backup V2 book database before your upgrade attempt, (you may now have the V3 actual books fileset uploaded, but thats ok)

now apply the update sql 'sql_update_V2_TO_V3LANGS.txt' in folder 3_UPGRADE_EXISTING_BOOK_V2_TO_V3_LANGS

This is a cut-down sql patch, that only updates some book table fields (and keys) in the database,

The full V3 sql that you appear to have used will indeed probably only half complete, and the missing authors etc are probably due to that. Cross fingers..

[hareslade]

I need to display the Book Title in a bigger font than other details. How do I do it.

Also if I donot write anything in the subtitles, can I stop the titel getting repeated in product display.

raunharman, yes the subtitle label display should not appear if you leave the book subtitle empty

and the book title main display text size/appearance is controlled by page html

<h1 id="productName" class="productGeneral".....

So... you can change the 'h1' (heading 1) css setting in the zencart stylesheet file,

Currently stylesheet.css standard zencart has

h1 {
	font-size: 1.5em;
	color: #9a9a9a;
	}

You can increase the em value for size, but this will change ALL h1 text on your cart

Or you could use the id, insert this into the css file, it should only of course change the product name size
..

#productName {
	font-size: 3em;
	color: #9a9a9a;
	}

Suggestions only, you need to read up a little on css styles, if you do these things.

I could have changed the class or id in the html page template, to relate to books only, e.g 'productBook', but I didn't.