Testimonial Manager Support Thread

By the way, I did find an issue in the admin after the upgrade that was easy to solve. In the upgrade SQL script you did not include adding the update field, which did not exist in the 1.37 table - so I ran the following script and it corrected the error -

ALTER TABLE `zen_testimonials_manager` ADD `last_update` datetime NULL DEFAULT NULL AFTER `date_added` ;

Just thought you might want to add that to the script for those upgrading from v1.37

Ruth

I have a modified version of your tesimonial system on my wifes site, using it as a guestbook, without lots of the features for display, it works fine, however we are now starting to see spam entries, which on the one hand we can live with since they do not display on the site unless my wife approves them, which she obviousley does not, however would a captcha addition be something that would be easy to implement for this system.

spottedhaggis:

I have a modified version of your tesimonial system on my wifes site, using it as a guestbook, without lots of the features for display, it works fine, however we are now starting to see spam entries, which on the one hand we can live with since they do not display on the site unless my wife approves them, which she obviousley does not, however would a captcha addition be something that would be easy to implement for this system.

You'd have to install one of the captcha mods and then modify a couple of files in template manager so that it would work with the captcha mod you install.

:blink: Im so sorry! I got to page 20 something and saw somone asked about scrolling this and then page 30 something and my will gave in to read any more.

Can anyone please tell me what file to alter to stick a marquee down tag so the testimonials on my side box scroll through a 150 px high view rather than having a whole bunch of testies taking up most of my side panel.

I presume it is the tpl_testimonails_manager.php in TEMPLATE/sideboxes but where ever I slap the Marquee comand it boogers up my whole store.

Any pointers would be cool.

Thanx! :D

greatness_183:

:blink: Im so sorry! I got to page 20 something and saw somone asked about scrolling this and then page 30 something and my will gave in to read any more.

Can anyone please tell me what file to alter to stick a marquee down tag so the testimonials on my side box scroll through a 150 px high view rather than having a whole bunch of testies taking up most of my side panel.

I presume it is the tpl_testimonails_manager.php in TEMPLATE/sideboxes but where ever I slap the Marquee comand it boogers up my whole store.

Any pointers would be cool.

Thanx! :D

You can limit the number of random testimonials that appear in the sidebox:
admin -> configuration -> Testimonials Manager ->
Number Of Testimonials to display in Testimonials Sidebox

If you wish to have scrolling, then look at any of the scrolling sidebox mods available in the downloads section to see how the code is implemented.

clydejones:

look at any of the scrolling sidebox mods available in the downloads section to see how the code is implemented.

See, if I had my brain in I would have thought of that! :laugh:

Thank you, I shall do just that.

Thank you very much for this, it works great.

One thing. I already have a page containg many testimonials that have been emailed to uour company over the years. I don't want to lose these, so I have been adding these to Testimonial Manager through 'Admin>Tools>Testimonials Manager'.

The only thing, there is no way of changing the date for these entries to correspond with the correct dates that they were sent to us.

I have changed the options in 'Admin>Configuration>Testimonials Manager' so that the date doesn't show any more, but I'd really like it if I could change the setting back to show the dates, but before doing this I will need to edit the entries that I have submitted to include the correct dates.

I would appreciate any advice. :smile:

bonheddwr:

Thank you very much for this, it works great.

One thing. I already have a page containg many testimonials that have been emailed to uour company over the years. I don't want to lose these, so I have been adding these to Testimonial Manager through 'Admin>Tools>Testimonials Manager'.

The only thing, there is no way of changing the date for these entries to correspond with the correct dates that they were sent to us.

I have changed the options in 'Admin>Configuration>Testimonials Manager' so that the date doesn't show any more, but I'd really like it if I could change the setting back to show the dates, but before doing this I will need to edit the entries that I have submitted to include the correct dates.

I would appreciate any advice. :smile:

A couple of things come to mind.

First would be to use phpmyadmin and edit the individual entries in the testimonials table with the original dates of submission.

Second would be to write a specialized sql script for these testimonials (using the original date of submission) and then run that script . (this would be the equivalent of running a "bulk" upload of the testimonials.) Depending on the number of testimonials you have, this would probably be the eaisest way to go.

Thank you very much for this. Is there a way of including a field to edit the date in 'Admin>Tools>Testimonials Manager' where it is possible to change details such as Author's Name, Email, City, Testimonial Title, Testimonial, Image etc?

bonheddwr:

Thank you very much for this. Is there a way of including a field to edit the date in 'Admin>Tools>Testimonials Manager' where it is possible to change details such as Author's Name, Email, City, Testimonial Title, Testimonial, Image etc?

I'm looking into that right now.

It will require some recoding of that particular section and may take a while to complete.

If you'd like some help on doing the "bulk" sql statement, you can always PM me. I'd be glad to help.

Hi Clyde,
I tried to search and read ALL the posts in this thread, but I fell asleep at the comp and bashed my head on the keyboard on the way down, so I figured I would just ask instead....

In the admin/configuration/testimonials manager, when I try to increase the number of testimonials that show up in the sidebox to anything above 5, the sidebox "loses" its left and right borders. Well, not all of it's borders, but the upper part disappears.

I have quite a bit of text on my main page, and want the testimonials to flow down the page to eliminate the "dead space" on the right.

Is it a CSS thing, or an image thing?

The site is http://mistkits.com , but I have set the # to display back to 5 so it doesn't look too funky to the customers.

You make some awesome mods and are very graciuos helping everyone. Thanks.

daneh:

Hi Clyde,
I tried to search and read ALL the posts in this thread, but I fell asleep at the comp and bashed my head on the keyboard on the way down, so I figured I would just ask instead....

In the admin/configuration/testimonials manager, when I try to increase the number of testimonials that show up in the sidebox to anything above 5, the sidebox "loses" its left and right borders. Well, not all of it's borders, but the upper part disappears.

I have quite a bit of text on my main page, and want the testimonials to flow down the page to eliminate the "dead space" on the right.

Is it a CSS thing, or an image thing?

The site is http://mistkits.com , but I have set the # to display back to 5 so it doesn't look too funky to the customers.

You make some awesome mods and are very graciuos helping everyone. Thanks.

I'll be guessing here, but from the way you are describing what is happening, I'd have to say that the content of the sidebox is breaking the height of the sideboxContent graphic.

in other words - the graphic has a height of 750px and if your content exceeds that height then you would get what you describe.

The solution would be to edit the graphic for the sideboxContent and increase the height to 1200px or so.

That was pretty much as I thought. I wasn't sure though.
Thanks for the reply.

Worked like a charm!!!:smartalec:

clydejones:

I'm looking into that right now.

It will require some recoding of that particular section and may take a while to complete.

If you'd like some help on doing the "bulk" sql statement, you can always PM me. I'd be glad to help.

Here's the sql statement.

Just unzip the file open the bonheddwrl.sql file

run this sql patch using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches)

copy-and-paste the code into the query field and press 'Send' instead.

[Attachment no longer available]

clydejones:

Here's the sql statement.

Just unzip the file open the bonheddwrl.sql file

run this sql patch using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches)

copy-and-paste the code into the query field and press 'Send' instead.

[Attachment no longer available]

Clyde, you are a legend. Thank you so much for allof your help. Greatly appreciated. :clap:

Sorry to be a nuisance again. I added the SQL statement you created,and itworked a charm. :smile:

I then followed the SQL format to add the last batch of Testimonials, but for some reason I get an error message. I must have messed up somwhere, please view attachment... :oops:

bonheddwr:

Sorry to be a nuisance again. I added the SQL statement you created,and itworked a charm. :smile:

I then followed the SQL format to add the last batch of Testimonials, but for some reason I get an error message. I must have messed up somwhere, please view attachment... :oops:

This should fix the problem

[Attachment no longer available]

bonheddwr:

Clyde, you are a legend. Thank you so much for allof your help. Greatly appreciated. :clap:

This should take care of the duplicate entires and also display the testimonials in both languages

[Attachment no longer available]

Thank you so much. You have been of great assistance, and it now works perfectly for our needs. This is a great add-on, everyone should add it! :clap:

Is there a link where I can make a contribution, because I would love to see this add-on developed even further!