Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

I have a strange problem with importing some html codes in my product description with easypopulate latest version

 

All my " is converted to "

Which destroys the html layout. f.ex. COLSPAN="2" to COLSPAN=?"

Any way to fix this?...

 

Please help I'm waiting to enter many product descriptions using easypopulate

 

Thanks alot

 

try to escape your quotes, with a colspan=\"2\" in your txt file

Link to comment
Share on other sites

He he those codes are converted in my last messege :)

 

Trying again

I have a strange problem with importing some html codes in my product description with easypopulate latest version

 

All my " is converted to & # 3 4
Which destroys the html layout. f.ex.  COLSPAN="2" to COLSPAN=& # 3 4 2 & # 3 4

Any way to fix this?...

 

Please help I'm waiting to enter many product descriptions using easypopulate

 

Thanks alot friends

Edited by shaytaan

?,???`???,?? God must love stupid people, he made so many ??,???`???,?

Link to comment
Share on other sites

try to escape your quotes, with a colspan=\"2\" in your txt file

 

THanks for the fast reply :thumbsup:

I copy those html codes from my manufacturers and there are MANY for those for may products and it's a big extra work to convert them all

?,???`???,?? God must love stupid people, he made so many ??,???`???,?

Link to comment
Share on other sites

THanks for the fast reply :thumbsup:

I copy those html codes from my manufacturers and there are MANY for those for may products and it's a big extra work to convert them all

e

search for ="2" and do a replace all by =\"2\"

 

that shoud take hmmmm.... 10 seconds to excel

Link to comment
Share on other sites

e

search for ="2" and do a replace all by =\"2\"

 

that shoud take hmmmm.... 10 seconds to excel

 

Tried that... not helping it gives the same result :blush:

?,???`???,?? God must love stupid people, he made so many ??,???`???,?

Link to comment
Share on other sites

This is an ex. when I put this into excel and import the file using easypopulate I get a destoyed table

 

<TABLE WIDTH="98%" BORDER=0 CELLPADDING=3 CELLSPACING=0 ALIGN="center">
<TR>
	<TD CLASS="tblcelllblupperboldwhtxt" HEIGHT="16" COLSPAN=\"2\">Udvidede specifikationer</TD>
</TR>

<TR>
	<TD CLASS=tblcellgrbold COLSPAN=\"2\" VALIGN="top" WIDTH="34%">Technical Information  </TD>
</TR>

<TR>

	<TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH="34%">Clock Speed  </TD>
	<TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH="66%">2.66GHz  </TD>
</TR>

<TR>
	<TD CLASS=tblcellgr VALIGN="top" WIDTH="34%">Bus Speed  </TD>
	<TD CLASS=tblcellgr VALIGN="bottom" WIDTH="66%">533MHz FSB  </TD>
</TR>


<TR>
	<TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH="34%">Cache Memory  </TD>
	<TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH="66%"><li>32KB L1 (Data)  - 2MB L2 (Advanced Transfer)</li><li>24KB L1 (Execution Trace)</li>  </TD>
</TR>

<TR>
	<TD CLASS=tblcellgr VALIGN="top" WIDTH="34%">Architecture  </TD>

	<TD CLASS=tblcellgr VALIGN="bottom" WIDTH="66%">64-bit  </TD>
</TR>

<TR>
	<TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH="34%">Process Technology  </TD>
	<TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH="66%">90nm  </TD>
</TR>

<TR>

	<TD CLASS=tblcellgr VALIGN="top" WIDTH="34%">Multimedia Extensions  </TD>
	<TD CLASS=tblcellgr VALIGN="bottom" WIDTH="66%">Streaming SIMD Extension 3 (SSE-3)  </TD>
</TR>

<TR>
	<TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH="34%">Featured Technologies  </TD>
	<TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH="66%">Extended Memory 64 Technology  </TD>
</TR>


<TR>
	<TD CLASS=tblcellgr VALIGN="top" WIDTH="34%">Platform Support  </TD>
	<TD CLASS=tblcellgr VALIGN="bottom" WIDTH="66%">PC  </TD>
</TR>

<TR>
	<TD CLASS=tblcellwhboldblktxt COLSPAN=\"2\" VALIGN="top" WIDTH="34%">Physical Characteristics  </TD>
</TR>


<TR>
	<TD CLASS=tblcellgr VALIGN="top" WIDTH="34%">Form Factor  </TD>
	<TD CLASS=tblcellgr VALIGN="bottom" WIDTH="66%">LGA775 Socket  </TD>
</TR>

<TR>
	<TD CLASS=tblcellwhboldblktxt COLSPAN=\"2\" VALIGN="top" WIDTH="34%">Miscellaneous  </TD>
</TR>


<TR>
	<TD CLASS=tblcellgr VALIGN="top" WIDTH="34%">Additional Information  </TD>
	<TD CLASS=tblcellgr VALIGN="bottom" WIDTH="66%"><li>Execute Disable Bit</li> <li>Dual-Core Technology</li> <li>Platform Compatibility Guide: 05A</li>  </TD>
</TR>

<TR>

	<TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH="34%">Compatibility  </TD>
	<TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH="66%"><li>Intel D101GGC Desktop Board</li><li>Intel D945GCZ Desktop Board</li><li>Intel D945GTP Desktop Board</li><li>Intel D945GNT Desktop Board</li><li>Intel D945PAW Desktop Board</li><li>Intel D945PVS Desktop Board</li><li>Intel D945PLM Desktop Board</li><li>Intel D945PSN Desktop Board</li><li>Intel D955XBK Desktop Board</li><li>Intel D955XCS Desktop Board</li><li>Intel D975XBX Desktop Board</li>  </TD>

</TR>

<TR>
	<TD CLASS=tblcellgrbold COLSPAN=\"2\" VALIGN="top" WIDTH="34%">Warranty  </TD>
</TR>

<TR>
	<TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH="34%">Standard Warranty  </TD>
	<TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH="66%">3 Year(s) Limited  </TD>

</TR>

<TR class="noprint">
	<TD HEIGHT="16" COLSPAN=\"2\" ALIGN="right" VALIGN="MIDDLE"></TD>
</TR>
</TABLE>

 

And when I export the file again using easypopulate I get this

 

<TABLE WIDTH=ඪ%" BORDER=0 CELLPADDING=3 CELLSPACING=0 ALIGN="center">	 <TR>		 <TD CLASS="tblcelllblupperboldwhtxt" HEIGHT=൘" COLSPAN=Ŗ">Udvidede specifikationer</TD>	 </TR>		  <TR>		 <TD CLASS=tblcellgrbold COLSPAN=Ŗ" VALIGN="top" WIDTH=൪%">Technical Information  </TD>	 </TR>		  <TR>		  <TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH=൪%">Clock Speed  </TD>		 <TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH=ඊ%">2.66GHz  </TD>	 </TR>		  <TR>		 <TD CLASS=tblcellgr VALIGN="top" WIDTH=൪%">Bus Speed  </TD>		 <TD CLASS=tblcellgr VALIGN="bottom" WIDTH=ඊ%">533MHz FSB  </TD>	 </TR>		   <TR>		 <TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH=൪%">Cache Memory  </TD>		 <TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH=ඊ%"><li>32KB L1 (Data)  - 2MB L2 (Advanced Transfer)</li><li>24KB L1 (Execution Trace)</li>  </TD>	 </TR>		  <TR>		 <TD CLASS=tblcellgr VALIGN="top" WIDTH=൪%">Architecture  </TD>		  <TD CLASS=tblcellgr VALIGN="bottom" WIDTH=ඊ%">64-bit  </TD>	 </TR>		  <TR>		 <TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH=൪%">Process Technology  </TD>		 <TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH=ඊ%">90nm  </TD>	 </TR>		  <TR>		  <TD CLASS=tblcellgr VALIGN="top" WIDTH=൪%">Multimedia Extensions  </TD>		 <TD CLASS=tblcellgr VALIGN="bottom" WIDTH=ඊ%">Streaming SIMD Extension 3 (SSE-3)  </TD>	 </TR>		  <TR>		 <TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH=൪%">Featured Technologies  </TD>		 <TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH=ඊ%">Extended Memory 64 Technology  </TD>	 </TR>		   <TR>		 <TD CLASS=tblcellgr VALIGN="top" WIDTH=൪%">Platform Support  </TD>		 <TD CLASS=tblcellgr VALIGN="bottom" WIDTH=ඊ%">PC  </TD>	 </TR>		  <TR>		 <TD CLASS=tblcellwhboldblktxt COLSPAN=Ŗ" VALIGN="top" WIDTH=൪%">Physical Characteristics  </TD>	 </TR>		   <TR>		 <TD CLASS=tblcellgr VALIGN="top" WIDTH=൪%">Form Factor  </TD>		 <TD CLASS=tblcellgr VALIGN="bottom" WIDTH=ඊ%">LGA775 Socket  </TD>	 </TR>		  <TR>		 <TD CLASS=tblcellwhboldblktxt COLSPAN=Ŗ" VALIGN="top" WIDTH=൪%">Miscellaneous  </TD>	 </TR>		   <TR>		 <TD CLASS=tblcellgr VALIGN="top" WIDTH=൪%">Additional Information  </TD>		 <TD CLASS=tblcellgr VALIGN="bottom" WIDTH=ඊ%"><li>Execute Disable Bit</li> <li>Dual-Core Technology</li> <li>Platform Compatibility Guide: 05A</li>  </TD>	 </TR>		  <TR>		  <TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH=൪%">Compatibility  </TD>		 <TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH=ඊ%"><li>Intel D101GGC Desktop Board</li><li>Intel D945GCZ Desktop Board</li><li>Intel D945GTP Desktop Board</li><li>Intel D945GNT Desktop Board</li><li>Intel D945PAW Desktop Board</li><li>Intel D945PVS Desktop Board</li><li>Intel D945PLM Desktop Board</li><li>Intel D945PSN Desktop Board</li><li>Intel D955XBK Desktop Board</li><li>Intel D955XCS Desktop Board</li><li>Intel D975XBX Desktop Board</li>  </TD>	  </TR>		  <TR>		 <TD CLASS=tblcellgrbold COLSPAN=Ŗ" VALIGN="top" WIDTH=൪%">Warranty  </TD>	 </TR>		  <TR>		 <TD CLASS=tblcellwhblktxt VALIGN="top" WIDTH=൪%">Standard Warranty  </TD>		 <TD CLASS=tblcellwhblktxt VALIGN="bottom" WIDTH=ඊ%">3 Year(s) Limited  </TD>	  </TR>		  <TR class="noprint">		 <TD HEIGHT=൘" COLSPAN=Ŗ" ALIGN="right" VALIGN="MIDDLE"></TD>	 </TR> </TABLE>

?,???`???,?? God must love stupid people, he made so many ??,???`???,?

Link to comment
Share on other sites

And when I export the file again using easypopulate I get this

 

<TABLE WIDTH=ඪ%" BORDER=0 CELLPADDING=3 CELLSPACING=0 ALIGN="center">
.../...

 

I have the same problem... on dl, all quotes are replaced with & # 3 4

I was using a previous EP version : 2.62 and there was no problem. I changed for a new version, to have the attibutes! Argh.

Where is the dl function that ask EP to convert quotes? in EP code I dont find it...

Thakns for your help

Seb

Osc 2.2 MS2

Link to comment
Share on other sites

In 2.74 it's on line 72

 

// **** Quote -> Escape character conversion ****
// If you have extensive html in your descriptions and it's getting mangled on upload, turn this off
// set to 1 = replace quotes with escape characters
// set to 0 = no quote replacement
global $replace_quotes;
$replace_quotes = true;

 

2.74 (from 26 July 05) works well and I think it handles the attributes that you need.

 

 

I have the same problem... on dl, all quotes are replaced with & # 3 4

I was using a previous EP version : 2.62 and there was no problem. I changed for a new version, to have the attibutes! Argh.

Where is the dl function that ask EP to convert quotes? in EP code I dont find it...

Thakns for your help

Seb

Link to comment
Share on other sites

This contribution is in dire need of someone to take control of development and do a complete rewrite. Someone hardcoded SPPC column names into the latest version making it completely unusable for those with standard stores. PLEASE, don't modify these contributions to work only with your store and then upload them as a new version.

Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Link to comment
Share on other sites

OK, I tested many times again, with or without quotes, in upload and download, trying to modify the code in easypopulate.php around line 1220 (where quotes are tested) and...

now it works for me!

BUT , how bizarre, I still use the original code.

in Admin, Replace Quotes are on "False"

I'm using EP 2.79

 

Good luck for everyone! ;)

Osc 2.2 MS2

Link to comment
Share on other sites

Irene,

 

"So I thought I would solve this problem by specifying a TEMP directory thru the EZPopolate function, but can't find it."

 

You need to go to your server to add the TEMP directory (or folder). EasyPopulate will not have that function. And set the permission of the folder to CHMOD 777.

 

Moreover, Sessions should be also under Admin -> Configuration as well. I believe you have installed it correctly but having problems with the TEMP folder - It needs to be created before downloading anything.

Original Message:

*******************

Hello,

 

I am new to OS Commerce, I installed EZPopulate and wanted to use EZPopulate Admin function. Only I don't have it in my Admin --> Configuration section. It actually ends with "Sessions" function. I have a feeling that I don't have the right version. Please let me know what should I do. I actually want to specify a TEMP directory since it's constantly giving an error

 

Warning: fopen(/home/livenatu/public_html/EP_TEMP_DIREP2006Apr20-2109.txt): failed to open stream: Permission denied in /home/livenatu/public_html/admin/easypopulate.php on line 538

 

Warning: fwrite(): supplied argument is not a valid stream resource in /home/livenatu/public_html/admin/easypopulate.php on line 539

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/livenatu/public_html/admin/easypopulate.php on line 540

You can get your file in the Tools/Files under EP_TEMP_DIREPEP2006Apr20-2109.txt

 

So I thought I would solve this problem by specifying a TEMP directory thru the EZPopolate function, but can't find it.

************************************

Thank you for your reply. I did specify TEMP Directory in Pubic_html directory and gave all permission, but it still didn't help. I do have Sessions under Admin -> Configuration with Session Directory set to TMP. I tried to get around the problem and downloaded the used DOWNLOAD_EP_2COMPLETE_EP option, I got the file and changed it and tried to upload it. I checked the database and unfortunately nothing was changed.

Thanks for your help

Irene

Link to comment
Share on other sites

OK, I tested many times again, with or without quotes, in upload and download, trying to modify the code in easypopulate.php around line 1220 (where quotes are tested) and...

now it works for me!

BUT , how bizarre, I still use the original code.

in Admin, Replace Quotes are on "False"

I'm using EP 2.79

 

Good luck for everyone! ;)

 

Hi, what did you exactly changed in you easypopulate.php file? I tried to remove the codes but I got other errors, and I think there are many of those SQL syntax errors..

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's updated Hard disk drive technology, this Toshiba 100 GB 2.5-i

 

UPDATE products_description SET products_name='100 GB 5400RPM SATA ', products_description='This Hard Drive is the best solution for small Notebooks and small consumer electronics products. By using Toshiba's updated Hard disk drive technology, this Toshiba 100 GB 2.5-inch hard disk drive with SATA interface is a highly advanced product. SATA is low power consumption due to a reduced voltage of the signal lines.', short_desc='HARDDISK 100GB SATA-150 2.5IN 5400RPM', products_url='www.toshiba.dk' WHERE products_id = '267' AND language_id = '4'

[TEP STOP]

?,???`???,?? God must love stupid people, he made so many ??,???`???,?

Link to comment
Share on other sites

looks to me because of this: EP_TEMP_DIR that your configure.php file may not be set properly for your document_root

Thanks for your response.

Can you elaborate please on this. What should I do to make it work?

Thanks

Irene

Link to comment
Share on other sites

Hi, what did you exactly changed in you easypopulate.php file? I tried to remove the codes but I got other errors, and I think there are many of those SQL syntax errors..

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's updated Hard disk drive technology, this Toshiba 100 GB 2.5-i

 

UPDATE products_description SET products_name='100 GB 5400RPM SATA ', products_description='This Hard Drive is the best solution for small Notebooks and small consumer electronics products. By using Toshiba's updated Hard disk drive technology, this Toshiba 100 GB 2.5-inch hard disk drive with SATA interface is a highly advanced product. SATA is low power consumption due to a reduced voltage of the signal lines.', short_desc='HARDDISK 100GB SATA-150 2.5IN 5400RPM', products_url='www.toshiba.dk' WHERE products_id = '267' AND language_id = '4'

[TEP STOP]

 

You have to escape your single quotes '. Just replace the single quotes like this: \' and you will not have that problem.

Link to comment
Share on other sites

Hi, what did you exactly changed in you easypopulate.php file? I tried to remove the codes but I got other errors, and I think there are many of those SQL syntax errors..

Hi,

1- which EP version are you using ? I read posts that ver.3 and above should not be used. That's why I took the EP 2.79. with functions in admin side now.

2- on the admin side chosse "replace quotes" = False

3- Define precisely your problem; is it on upload or download that quotes are changed for & # 3 4 ?

Choose a product in your catalogue, put " many times inside it description, and download a EP file. Is there still the quotes ?

If yes, Then re-upload this files and go to the product description in your products catalogue to see again if " are still there.

4- Every problem has a solution... ;)

 

seb

Osc 2.2 MS2

Link to comment
Share on other sites

I hate to repost my message again, but I still don't understand what am I doing wrong. Please help.

 

Original Message:

*******************

Hello,

 

I am new to OS Commerce, I installed EZPopulate and wanted to use EZPopulate Admin function. Only I don't have it in my Admin --> Configuration section. It actually ends with "Sessions" function. I have a feeling that I don't have the right version. Please let me know what should I do. I actually want to specify a TEMP directory since it's constantly giving an error

 

Warning: fopen(/home/livenatu/public_html/EP_TEMP_DIREP2006Apr20-2109.txt): failed to open stream: Permission denied in /home/livenatu/public_html/admin/easypopulate.php on line 538

 

Warning: fwrite(): supplied argument is not a valid stream resource in /home/livenatu/public_html/admin/easypopulate.php on line 539

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/livenatu/public_html/admin/easypopulate.php on line 540

You can get your file in the Tools/Files under EP_TEMP_DIREPEP2006Apr20-2109.txt

 

So I thought I would solve this problem by specifying a TEMP directory thru the EZPopolate function, but can't find it.

************************************

I did specify TEMP Directory in Public_html directory and gave all permission, but it still didn't help. I do have Sessions under Admin -> Configuration with Session Directory set to TMP. I tried to get around the problem and used DOWNLOAD_EP_2COMPLETE_EP option, I got the file, changed it and uploaded it. I checked the database and unfortunately nothing was changed.

Thanks for your help

Irene

Link to comment
Share on other sites

I really really need help with this please :( . I am having problems creating EP files for froogle, and other purposes. It worked fine, right up until about 2 weeks ago. Now I get an Error 500 message, sometimes it works but it's like 1 out of every 50 clicks, and there's a 30 sec delay before I get the error 500. Anyone have a clue what might be causing this? BTW this problem started happeneing after I doubled the ammount of products. Oh and also if I just do the categories export it works fine. So I really don't know if it might have anything to do with time outs or something because the file d/l it is to big or something. Thanks in advance

Link to comment
Share on other sites

No products_model field in record. This line was not imported

 

I read this forum over and over and probally i missed some information. But i do have a problem with easy populate.

 

I am using EP_v2_72_MS2 and i did everything the exlanation told me. I set the right path to temp with the right permissions.

 

Downloaden off the products is not a problem. Splitting files is working just great but when i upload a list with files some things are going wrong.

 

The batch is ending with the line No products_model field in record. This line was not imported

 

The productsmodel is filled in with unique modelnumbers. like rheroe 0001 rheroe 0002 rheroe 0003 So i dont understand it.

 

However he does upload something. When i have a look to my catagories it is showing the products which i uploaded. But when i click on them the shop is telling me no products found.

 

So they are visible in the catagories but not real. You can have a look at my testshop my webshop I know it is a total new install with no changes made. It is only for testing.

 

how do i solve this problem, or what do you need to help me solve this problem

Link to comment
Share on other sites

Hi,

 

After using Import catalog's file:

 

I get at the bottom

--------

File uploaded.

Temporary filename: /tmp/phpf4tI0P

User filename: testupload.xls

Size: 20480

--------

 

But no products are added to the catalog.

 

The headers I am using in a .xls file are as follows:

 

v_products_model v_products_name_1 v_products_price v_products_description_1 v_products_weight v_products_image v_products_description_2 v_products_quantity v_categories_name EOREOR

 

 

Any ideas on what the problem could be?

 

Thanks for anyone who can offer any help.

 

 

edit: using version Easy Populater 2.90.

Edited by tonyfourthumbs
Link to comment
Share on other sites

I want to use Easy Populate with More Pics - is this just a matter of making new columns in excel for the extra images? Or can these 2 contribs not work together?

Link to comment
Share on other sites

The headers I am using in a .xls file are as follows:

 

v_products_model v_products_name_1 v_products_price v_products_description_1 v_products_weight v_products_image v_products_description_2 v_products_quantity v_categories_name EOREOR

Hi, I don't know if the headers must be in a particular order. But for me the header order would be :

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_products_quantity v_categories_name_1 EOREOR

 

Hope this helps.

Seb

Osc 2.2 MS2

Link to comment
Share on other sites

Hi, I don't know if the headers must be in a particular order. But for me the header order would be :

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_products_quantity v_categories_name_1 EOREOR

 

Hope this helps.

Seb

 

 

Will give it a blast and yet you know if it worked, thanks.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...