Andrew J

I changed the spaces in the path before unfortunately I quoted an earlier message to show the model# lenght. The fact is that I have this 64 character limit in the image path and product name fields. The cut is happening after using EP to upload and insert the txt files into the database. Is there a way or variable in either EP php file or to control or set the lenght of the column fields?

Yes I didnt bec. I discovered it now. :) :blink: Please calm me down, you are looking in your database not in my? I believe sql databases are in a secure place on the server. Where should I modified the table? In the xls file? The product names will shortened after I upload the txt file via EP. The Original xls and the saved as txt file has the full lenght. I used some modified code to display the product name with model# instead only the model#. :) Model# table columns contains max. 10 char. As I posted earlier:

I tried without any success! There is still something with that 64 charater limit. I dont know what's wrong if I exceed the 64 char limit. I added two character to exceed the 64 charachter barrier in the xls file: Original: fenykepezogepek/nikon/digitalis_kompakt/halado_amator/E8700f.jpg Modified: fenykepezogepek/nikon/digitalis_kompakt/halado_amator/E8700fff.jpg I modified the filename at the server too to match the database. I uploaded the modified txt file via EP. Then the product image failed to appear at the product listing page. When I export the file from EP again I saw that the image path cutted at 64 character: I discovered one more thing: This 64 char. thingy can be seen at my shop: http://www.eware.hu/catalog/index.php/cPath/1_34_45 at 9th line: Microsoft Black Value Pack Win32 (PS/2) (Microsoft Multimedia Ke somehow the product name was cutted. I checked the original xls file and the product filename was untouched with full lenght. But there is no such limitation at the v_products_description column. Hmm! Maybe some wrong php setting or EP caused this cut? Andrew

Yes you can get your file from your server hosted by your hosting company. You need to connect to your server using any FTP client. Then go to the folder /catalog/temp and voila...

v_products_model | v_products_image | v_products_name_5 NIKDCX032 | fenykepezogepek/nikon/digitalis kompakt/halado amator/E8700f.jpg | Nikon CoolPix 8700 As u can see I didnt use those chars in the EP file. I upload the EP file from my local PC from a different folder then /catalog/temp/ I use that "browse and insert into db" feature at the top of the EP window in admin. It works fine at this time. I'll try to use "_" instead space. I'll will inform you about the results. :rolleyes:

Can you give a example of the path name? Do you mean where the files are located in OSC? Here's the sample, directory names are hungarian but it doesnt matter. EP csv files contains only the path after www.domain.com/catalog/images/... so the sample is: .../fenykepezogepek/nikon/digitalis kompakt/halado amator/E8700f.jpg This could be accepted by EP and OsC the image will appear at the right place. But if I add some characters to exceed the 64 char. then the image wont be visible.

After all images with long filenames wont appear in the catalog. I tested and realised that the image path is longer than 64 character (including the path+image filename with "dot" and extension) than the image wont appear in the catalog. So I think there is a character barrier in OsC or in EP. Any idea?

Are there any restrictions to upload long image filenames through EP or OsC woont accept filenames like this: E8700_Front_L.jpg or this D100_+_MB-D100_Side.jpg by default? Shorter filenames inserted successfully into the database. Hmm?

Can affect Master Product contibution the way how products are sorted in admin/catalog/categories&products? If I remember correctly after a base install of OsC the sort order feature will order by product_name? I'd like to have back the order by product_name way without loosing the advantages of Master Products. Here's my admin/categories.php code:

Its working now! I changed it to 10. THX!

You mean this? $max_categories = 3; // 7 is default

I'd like to add software products to my catalog with EP 2.74. I added uploaded and inserted this file Microsoft_MOLP_2004j?n30.txt into the database. Everything goes to its place fine under the directory catalog/softwares/microsoft/MOLP/... The directory structure is 4 level deep. Then I tried to insert the next one Microsoft_OSL_2004j?l01.txt but it goes to the directory catalog/OSL/... This dir structure is 6 level deep. Why dont want the OSL directory be under the folder catalog/microsoft/... ??? Both file has the same dir structure the only difference is the directory depht. My Webshop Please look on my txt files maybe one of you will find what cause this malfunction. Thx, Andrew

A littlebit offtopic but this topic was always very helpful to me: My products sort order wont work by product_name (from A-Z) in admin/catalog/categories&products. My admin area sort products like this: Office Pro 2003 Win32 Hungarian AE CD VC#.NET Std 2003 Win32 English AE CD Outlook 2003 Win32 English CD VStudio Tools for Off 2003 Win32 English AE CD Project Pro 2003 Win32 English VUP CD 1 Clt FrontPage 2003 Win32 Hungarian CD Excel 2003 Win32 English VUP CD Is there any chance that I caused this by an installation one of the following contributions? Master_products-v1.1.5 EasyPopulate2.74 with masterprod extension (distributed with EP 2.73) Admin Access With Levels 1.6.0 CategoryBoxEnhancement_v1.1 CustomerUpdateCartReminder_v20a Andrew :unsure:

Hi John! The above one was the reply of my question posted on Juni 2 2004, 02:40 AM? Or it was for another post? If yes than thank you!

:unsure: and what about with my post? Yes or not? I dont want to take down my site and the database? Please answer me. :blink:

It is possible with EP to redefine the image paths through a csv file? I mean if I delete all the pictures from the /catalog/images directory (because currently all the images are in the /catalog/images directory without any structure) and upload my own structured image categories (images will be grouped by type and manufacturers and etc) like: SoftwareMicrosoft Adobe Macromedia [*]Hardware WinchesterMaxtor Seagate [*]Videocards ATI Nvidia Matrox [*]Others then it is possible to fix the db through EP with a well corrected csv file? Im not native english. if something not clear to all of you please tell me. Best regards, Andrew

2.72 I do use master product. Ive found the problem it was a missing dot. echo FILENAME ': ' . $localfile . "<br>"; but should be echo FILENAME . ': ' . $localfile . "<br>"; I will try to install 2.74.

Hi! Great contrib. I just installed the mod and run in to this error: This is my 1317th line: What should I do? Thanks in adv. Andrew

Is there a way to display the gross price between brackets under the net price? Cheers Andrew

OK! This is the posted code .../english/product_info.php : <?php /* $Id: product_info.php,v 1.15 2002/11/19 01:48:08 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Master Products - JOHNSON - 05/11/2003 [email protected] Copyright © 2003 Suomedia - Dynamic Content Management Released under the GNU General Public License */ //Master Products define('TEXT_SLAVE_PRODUCTS', '*Please select the quantity for each item you wish to order and click the \'Add To Cart\' button below.'); //Master Products EOF define('TEXT_PRODUCT_NOT_FOUND', 'Product not found!'); define('TEXT_CURRENT_REVIEWS', 'Current Reviews:'); define('TEXT_MORE_INFORMATION', 'For more information, please visit this products <a href="%s" target="_blank"><u>webpage</u></a>.'); define('TEXT_DATE_ADDED', 'This product was added to our catalog on %s.'); define('TEXT_DATE_AVAILABLE', '<font color="#ff0000">This product will be in stock on %s.</font>'); define('TEXT_ALSO_PURCHASED_PRODUCTS', 'Customers who bought this product also purchased'); define('TEXT_PRODUCT_OPTIONS', 'Available Options:'); define('TEXT_CLICK_TO_ENLARGE', 'Click to enlarge'); define('TEXT_QUANTITY', 'Select quantity: '); define('TEXT_STOCK', '<font color="#ff0000"><b>Out of Stock</b></font>');define('TEXT_STOCK', '<font color="#ff0000"><b>Out of Stock</b></font>'); ?> Lines colored with red should move up between //Master Products and //Master Products EOF because my original code doesnt contains these lines and people like me wont copy these codes into their code so they will have the same errors. The define('TEXT_STOCK', '<font color="#ff0000"><b>Out of Stock</b></font>'); line is duplicated is this necessary? Just a piece of advice to make the contrib installation run perfect for dummys like me. Cheers Andrew B)

Hi Matti! Great contrib! I have the following contribs too: - Admin Access With Levels 1.6.0 - CategoryBoxEnhancement_v1.1 - CustomerUpdateCartReminder_v20a I have some errors after I installed the latest MP as shown on the picture. No matter what is the language. On product _info pages if my product stock is 0 prods displays TEXT_STOCK. The other problem is the TEXT_QUANTITY. Im would like to go live without these mistakes. Regards, Andrew

Dont want to turn back evrething to the previous state so I still need help. :o

In my case the 'buy now' button is displayed next to the [sold] products. In normal case 'buy now' buttons should displayed next to "unsold" products. There is something wrong with the code? Andrew

THX! Works fine! :rolleyes:

Hi! I translated this contr. to hungarian based on english files. Everything is fine exept when I switched to hungarian and when I try to log off I get this error: Warning: Cannot add header information - headers already sent by (output started at /web/companies/eware/html/admin/includes/languages/hungarian.php:607) in /web/companies/eware/html/admin/logoff.php on line 15 Anyone? Andrew