138 replies to this topic

[kymation]

BretSpark, on 26 August 2011, 14:26, said:

Hi Jim,

Just a quick question. i scrapped the previous version i had because i was having problems with the ckeditor addon. I have now downloaded oscommerce 2.3. Is it possible to include this document manager addon (version 2.2) my website that is version 2.3??

From what i can see the only page that will give me issues is the product_info.php? do you think it is possible ? If so where about do i change the code in the product_info page?
If it is not possible do you know of any other addons where i can add product manuals etc to my site?

Regards

Bret

Document Manager is not hard to convert. You'll need to update the documents.php file and the boxes to the new style. You can add the code to products_info.php just below the products_description.

Regards
Jim

[BretSpark]

thanks, i will have a go

[kymation]

gfasal, on 29 August 2011, 10:09, said:

Associate drop down list -
<snip>

$products_query_raw = "select products_name,
products_model,
products_id

Regards
Jim

[BretSpark]

Hi Jim,

all seems to be working now. I am using the Document manager to upload the documents and associate them to the product. when i go to the product the attachments are displayed under the 'More Info' TAB.

Just a quick question . In the catalog/includes/modules/documents_tab.php file on line 323

<?php
// The Documents tab
if ($documents_tab == true) {
echo ' <div id="tabs-12">';
include( DIR_WS_MODULES . FILENAME_DOCUMENTS );
echo ' </div>';
}
?>
</div>

i have changed to

<?php
// The Documents tab
if (DOCUMENTS_SHOW_PRODUCT_INFO == 'True') {
echo ' <div id="tabs-12">';
include( DIR_WS_MODULES . FILENAME_DOCUMENTS );
echo ' </div>';
}
?>
</div>

Will this code be ok???

Regards

Bret

[kymation]

Either one will work. The constant just needs to be set in the Admin. Use whatever works for you.

Regards
Jim

[kenkja]

Hi Jim,

I have your contribution working in a v2.3.1 installation.

My site is a motorcycle spares retailer and I've uploaded around 50 odd .pdf's supplied by the manufacturer which breaks down the bikes into the component parts and complete bikes I sell.

The site is very new and only has around 2,500 parts uploaded and 4 complete bikes, realistically there are probably 20 times as many to upload.

It is possible that 1 part number may related to say 3 bike "models" and may have been used anywhere from 1 to 5 years, each year having its own parts.pdf, this would give, for example, up to 15 associations for each part number.

So I'm trying to figure out if there is way of displaying a parts.pdf on the documents listing without having actually created an association, so that a user could click on the documents box=>Parts.pdf, find the part he needs and then use the search functions to find the parts they require.

ken

[kymation]

The Document Manager was designed to associate the document with the product. I never thought about it being used for parts.

Association is the only way to connect a document with a product in the current code. You would have to code up something different if you don't want to do it that way.

Regards
Jim

[kenkja]

Hi Jim, thanks for info.

I'm trying to think of a work around solution for my issue, on the lines adding a field to TABLE_DOCUMENTS which would be, for example, CATEGORY_ID, then linking catalog/documents.php, to this new field rather than to PRODUCTS_TO_DOCUMENTS=>DOCUMENTS_ID.

I'm not very good at php, am I correct in thinking

								   " . TABLE_PRODUCTS_TO_DOCUMENTS . " p2d, 
								   " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, 
								   " . TABLE_CATEGORIES_DESCRIPTION . " cd 
							  where d.document_types_id = '" . $type . "' 
							    and dt.document_types_id = d.document_types_id 
							    and d.documents_visible = 'True' 
							    and d.documents_id = p2d.documents_id 
							    and p2d.products_id = p2c.products_id 

That the first and last line of the code above, being lines 43 & 50 of catalog/documents.php, are the ones select documents which have had an association created.

thanks

ken

[kymation]

You need to add

    and cd.categories_id = p2c.categories_id

to link the categories_description table to the products_to_categories table. Then it should work.

Regrds
Jim

Edited by kymation, 10 October 2011, 17:50.

[kenkja]

Thanks JIm

[Jossz]

Hi Jim,

I downloaded from the "OsCommerce Community Add-Ons" side the "Document Manager 1.0.4" add-on.
Very useful programme, this likes me extremely.
I am not PHP a programmer.
My question : to make a a little of modifications , in which a counter counts , a document how many times they downloaded ?
This he could be to see on the Admin page between items of information of the document .
This would give me useful information.

Best Regards

Peter

Edited by Jossz, 22 November 2011, 15:19.

[kymation]

That's a good idea. I'll add it to the wish list. It may be a while before I get to this though.

Regards
Jim

[Jossz]

I thank You Jim...[img]http://forums.oscommerce.com//public/style_emoticons/default/thumbsup.gif[/img]

[Jossz]

Hi Jim,

My question : approx. when the counter is getting ready?
I would like to use it...

Regards

Peter

[liuhoward]

Dear Jim, this would be the exact add-on for my project if it works with oSCommerce 2.3.1. Do you have a newer version in the pipeline? Thanks!

[gfasal]

is ther any code out ther to be able to add the doc upload on the admin product entry page?

[gfasal]

think i found a small error, can anyone confim this:

see image attached.

the sort order and Document Title in this document's information does not update when update is pressed.

PLeae confirm or deny...

Attached Files

•  Untitled-1.jpg   41.07K   3 downloads

[gfasal]

mibo, on 09 January 2010, 20:53, said:

HI!

'Delete' is not working.

I can't delete the uploaded file. It can delete the title and the sort order; it also deletes it from the web page till you click 'Update'. But in doesn't delete it from the server. Help !

mibo

Having the same issue running on 2.3 --- anyone solved this?

[gfasal]

gfasal, on 22 February 2012, 13:02, said:

think i found a small error, can anyone confim this:

see image attached.

the sort order and Document Title in this document's information does not update when update is pressed.

PLeae confirm or deny...

Resolved - FIXED - no problem