Easy Populate & Products Attributes

September 22, 2006

Hi All,
I'm running the EP 2.76c. It works great except for it places the price in the wrong field. It places into the Gross field and not the Net.

Have I done something wrong or is this a known issue

thanx

there is a setting in the easypopulate file for the tax. it should be set to false, that should fix it

zondo · September 22, 2006

there is a setting in the easypopulate file for the tax. it should be set to false, that should fix it

Thank you that worked...and thaks for really really fast response

SeanC391 · September 22, 2006

Am I correct that if I'm using PHP5 and I make the change of replacing

array_walk($readed, 'walk');

with

foreach ($readed as $readed_record) {

walk($readed_record);

}

easypopulate will work correctly with PHP5? I've been attempting to get easypopulate to work for three days. Same problem of no downloading or uploading of the sample file included with easypopulate. I'm curious what versions of PHP and MySQL people are using who have had success with easypopulate. I've also tried different versions of ep. Any help appreciated.

September 22, 2006

Am I correct that if I'm using PHP5 and I make the change of replacing
array_walk($readed, 'walk');

with

foreach ($readed as $readed_record) {

walk($readed_record);

}

easypopulate will work correctly with PHP5? I've been attempting to get easypopulate to work for three days. Same problem of no downloading or uploading of the sample file included with easypopulate. I'm curious what versions of PHP and MySQL people are using who have had success with easypopulate. I've also tried different versions of ep. Any help appreciated.

MySQL 4.1.21-log

PHP Version 4.4.4

all versions working fine on this server

balynce · September 22, 2006

So just to confirm... admin/includes/configure.php should have this...

define('DIR_FS_DOCUMENT_ROOT', '$DOCUMENT_ROOT'); // where the pages are located on the server

what about regular catalog/ configure?

Thanks :)

sonictrip.net · September 22, 2006

in your EP file, search for the line were there is the INSERT

there is a problem next to your product_image_med: there is a double quote missing.

check also next to the product model, there is probably a quote missing.

here is how the match between the fields and values looks like when itemized
FIELDS

products_image
products_image_med
products_image_lrg
products_image_sm_1
products_image_xl_1
products_image_sm_2
products_image_xl_2
products_image_sm_3
products_image_xl_3
products_image_sm_4
products_image_xl_4
products_image_sm_5
products_image_xl_5
products_image_sm_6
products_image_xl_6
products_model
products_price
products_status
products_last_modified
products_date_added
products_date_available
products_tax_class_id
products_weight
products_quantity
manufacturers_id)

VALUE

''
"
""
""
""
""
""
""
""
""
""
""
""
""
""
" '111113'
'10.95'
'1'
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP
NULL
''
''
'1000'
'NULL')

Hi, thanks for the reply, that makes sense anyway!

Im not too sure what needs to be changed on easy_populate.php though, it all looks right to me...

Here's a few lines around the part that i think is related, can you tell me what changes i need to make in order for these missing quotes to be included? Thanks

//   insert into products

		$sql = "SHOW TABLE STATUS LIKE '".TABLE_PRODUCTS."'";
		$result = tep_db_query($sql);
		$row =  tep_db_fetch_array($result);
		$max_product_id = $row['Auto_increment'];
		if (!is_numeric($max_product_id) ){
			$max_product_id=1;
		}
		$v_products_id = $max_product_id;
		echo "<font color='green'> !New Product!</font><br>";

		$query = "INSERT INTO ".TABLE_PRODUCTS." (
									products_image,
									products_image_med,
									products_image_lrg,
									products_image_sm_1,
									products_image_xl_1,
									products_image_sm_2,
									products_image_xl_2,
									products_image_sm_3,
									products_image_xl_3,
									products_image_sm_4,
									products_image_xl_4,
									products_image_sm_5,
									products_image_xl_5,
									products_image_sm_6,
									products_image_xl_6,
				products_model,
				products_price,
				products_status,
				products_last_modified,
				products_date_added,
				products_date_available,
				products_tax_class_id,
				products_weight,
				products_quantity,
				manufacturers_id)
					VALUES (
						'$v_products_image',"
									. $v_products_image_med . '", "'
									. $v_products_image_lrg . '", "'
									. $v_products_image_sm_1 . '", "'
									. $v_products_image_xl_1 . '", "'
									. $v_products_image_sm_2 . '", "'
									. $v_products_image_xl_2 . '", "'
									. $v_products_image_sm_3 . '", "'
									. $v_products_image_xl_3 . '", "'
									. $v_products_image_sm_4 . '", "'
									. $v_products_image_xl_4 . '", "'
									. $v_products_image_sm_5 . '", "'
									. $v_products_image_xl_5 . '", "'
									. $v_products_image_sm_6 . '", "'
									. $v_products_image_xl_6 . '", "';

		// unmcomment these lines if you are running the image mods
		/*
			$query .=		. $v_products_mimage . '", "'
						. $v_products_bimage . '", "'
						. $v_products_subimage1 . '", "'
						. $v_products_bsubimage1 . '", "'
						. $v_products_subimage2 . '", "'
						. $v_products_bsubimage2 . '", "'
						. $v_products_subimage3 . '", "'
						. $v_products_bsubimage3 . '", "'
		*/

		$query .="				'$v_products_model',
							'$v_products_price',
							'$v_db_status',
							CURRENT_TIMESTAMP,
							$v_date_added,
							$v_date_avail,
							'$v_tax_class_id',
							'$v_products_weight',
							'$v_products_quantity',
							'$v_manufacturer_id')
						";
			$result = tep_db_query($query);
	} else {
		// existing product, get the id from the query
		// and update the product data
		$row =  tep_db_fetch_array($result);
		$v_products_id = $row['products_id'];
		echo "<font color='black'> Updated</font><br>";
		$row =  tep_db_fetch_array($result);
		$query = 'UPDATE '.TABLE_PRODUCTS.'
				SET
					products_price="'.$v_products_price .
									'" ,products_image="'.$v_products_image .
								   	'" ,products_image_med="'.$v_products_image_med .
									'" ,products_image_lrg="'.$v_products_image_lrg .
									'" ,products_image_sm_1="'.$v_products_image_sm_1 .
									'" ,products_image_xl_1="'.$v_products_image_xl_1 .
									'" ,products_image_sm_2="'.$v_products_image_sm_2 .
									'" ,products_image_xl_2="'.$v_products_image_xl_2 .
									'" ,products_image_sm_3="'.$v_products_image_sm_3 .
									'" ,products_image_xl_3="'.$v_products_image_xl_3 .
									'" ,products_image_sm_4="'.$v_products_image_sm_4 .
									'" ,products_image_sm_4="'.$v_products_image_xl_4 .
									'" ,products_image_sm_5="'.$v_products_image_sm_5 .
									'" ,products_image_xl_5="'.$v_products_image_xl_5 .
									'" ,products_image_sm_6="'.$v_products_image_sm_6 .
									'" ,products_image_xl_6="'.$v_products_image_xl_6;

		// uncomment these lines if you are running the image mods
/*
			$query .=
				'" ,products_mimage="'.$v_products_mimage.
				'" ,products_bimage="'.$v_products_bimage.
				'" ,products_subimage1="'.$v_products_subimage1.
				'" ,products_bsubimage1="'.$v_products_bsubimage1.
				'" ,products_subimage2="'.$v_products_subimage2.
				'" ,products_bsubimage2="'.$v_products_bsubimage2.
				'" ,products_subimage3="'.$v_products_subimage3.
				'" ,products_bsubimage3="'.$v_products_bsubimage3;
*/

		$query .= '", products_weight="'.$v_products_weight .
				'", products_tax_class_id="'.$v_tax_class_id . 
				'", products_date_available= ' . $v_date_avail .
				', products_date_added= ' . $v_date_added .
				', products_last_modified=CURRENT_TIMESTAMP
				, products_quantity="' . $v_products_quantity .  
				'" ,manufacturers_id=' . $v_manufacturer_id . 
				' , products_status=' . $v_db_status . '
				WHERE
					(products_id = "'. $v_products_id . '")';

		$result = tep_db_query($query);
	}

	// the following is common in both the updating an existing product and creating a new product
			if ( isset($v_products_name)){
		foreach( $v_products_name as $key => $name){
						if ($name!=''){
				$sql = "SELECT * FROM ".TABLE_PRODUCTS_DESCRIPTION." WHERE
						products_id = $v_products_id AND
						language_id = " . $key;
				$result = tep_db_query($sql);
				if (tep_db_num_rows($result) == 0) {
					// nope, this is a new product description
					$result = tep_db_query($sql);
					$sql =
						"INSERT INTO ".TABLE_PRODUCTS_DESCRIPTION."
							(products_id,
							language_id,
							products_name,
							products_description,
							products_url)
							VALUES (
								'" . $v_products_id . "',
								" . $key . ",
								'" . $name . "',
								'". $v_products_description[$key] . "',
								'". $v_products_url[$key] . "'
								)";

Any ideas? Thanks for the reply! :)

September 22, 2006

there we go! there is a typo after the $v_products_image, so the quotes around the image names are not passed correctly

look for:

 products_weight,
				products_quantity,
				manufacturers_id)
					VALUES (
						'$v_products_image',"
									. $v_products_image_med . '", "'
									. $v_products_image_lrg . '", "'
									. $v_products_image_sm_1 . '", "'

and replace by:

products_weight,
				products_quantity,
				manufacturers_id)
					VALUES (
						'$v_products_image. '", "'
									. $v_products_image_med . '", "'
									. $v_products_image_lrg . '", "'
									. $v_products_image_sm_1 . '", "'

Let me know how it goes

sonictrip.net · September 22, 2006

there we go! there is a typo after the $v_products_image, so the quotes around the image names are not passed correctly

look for:

 products_weight,
				products_quantity,
				manufacturers_id)
					VALUES (
						'$v_products_image',"
									. $v_products_image_med . '", "'
									. $v_products_image_lrg . '", "'
									. $v_products_image_sm_1 . '", "'

and replace by:

products_weight,
				products_quantity,
				manufacturers_id)
					VALUES (
						'$v_products_image. '", "'
									. $v_products_image_med . '", "'
									. $v_products_image_lrg . '", "'
									. $v_products_image_sm_1 . '", "'

Let me know how it goes

Wow man, that was a fast reply! :)

I think we're almost there, just a parse error thats coming up now when i click the Easy Populate link in the Admin...

It's saying there's a parse error on this line:

'$v_products_image. '", "'

from this snippet:

VALUES (
						'$v_products_image. '", "'
									. $v_products_image_med . '", "'
									. $v_products_image_lrg . '", "'
									. $v_products_image_sm_1 . '", "'
									. $v_products_image_xl_1 . '", "'
									. $v_products_image_sm_2 . '", "'
									. $v_products_image_xl_2 . '", "'
									. $v_products_image_sm_3 . '", "'
									. $v_products_image_xl_3 . '", "'
									. $v_products_image_sm_4 . '", "'
									. $v_products_image_xl_4 . '", "'
									. $v_products_image_sm_5 . '", "'
									. $v_products_image_xl_5 . '", "'
									. $v_products_image_sm_6 . '", "'
									. $v_products_image_xl_6 . '", "';

Any more ideas? Thanks for the help! :)

Brown Knight · September 22, 2006

So just to confirm... admin/includes/configure.php should have this...

define('DIR_FS_DOCUMENT_ROOT', '$DOCUMENT_ROOT'); // where the pages are located on the server

what about regular catalog/ configure?

Thanks :)

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

no tick marks around document_root

September 22, 2006

there we go! there is a typo after the $v_products_image, so the quotes around the image names are not passed correctly

look for:

 products_weight,
				products_quantity,
				manufacturers_id)
					VALUES (
						'$v_products_image',"
									. $v_products_image_med . '", "'
									. $v_products_image_lrg . '", "'
									. $v_products_image_sm_1 . '", "'

and replace by:

products_weight,
				products_quantity,
				manufacturers_id)
					VALUES (
						'$v_products_image. '", "'
									. $v_products_image_med . '", "'
									. $v_products_image_lrg . '", "'
									. $v_products_image_sm_1 . '", "'

Let me know how it goes

try this (I remove the single quote in front of $products_image

products_weight,
products_quantity,
manufacturers_id)
VALUES (
$v_products_image. '", "'
. $v_products_image_med . '", "'
. $v_products_image_lrg . '", "'
. $v_products_image_sm_1 . '", "'

Edited September 22, 2006 by pixclinic

balynce · September 22, 2006

try this (I remove the single quote in front of $products_image

products_weight,
products_quantity,
manufacturers_id)
VALUES (
$v_products_image. '", "'
. $v_products_image_med . '", "'
. $v_products_image_lrg . '", "'
. $v_products_image_sm_1 . '", "'

I am stuck at this part too, as well as my page won't upload or download. there are a few sections with the image listed... not sure if those are right either.. but for this section mine is giving me an error and I am not sure how to fix it.

Parse error: parse error, unexpected ',' in

/hsphere/local/home/balynce/store.balynce.com/admin/easypopulate.php on line 1715

$query = "INSERT INTO ".TABLE_PRODUCTS." (
				products_image,
				products_model,
				products_price,
				products_status,
				products_last_modified,
				products_date_added,
				products_date_available,
				products_tax_class_id,
				products_weight,
				products_quantity,
				manufacturers_id)
					VALUES (
						$v_products_image . '", "'
						. $v_products_subimage1 . '", "'
						. $v_products_subimage2 . '", "'
						. $v_products_subimage3 . '", "'
						. $v_products_subimage4 . '", "'
						. $v_products_subimage5 . '", "'
						. $v_products_subimage6 . '", "'



		$query .="				'$v_products_model',
							'$v_products_price',
							'$v_db_status',
							CURRENT_TIMESTAMP,
							$v_date_added,
							$v_date_avail,
							'$v_tax_class_id',
							'$v_products_weight',
							'$v_products_quantity',
							'$v_manufacturer_id')
						";

September 22, 2006

Hi all,

Is there a trick to adding html to the product description field in easy populate via the excel speadsheet. I can upload everything just fine except the fields with html code in them. Also, excel adds another set of quotations to things that are already quoted. For example, width="130" somehow becomes width=""130""

Everything works fine other than the html, just looking for a solution so I do not have to add descriptions through admin one by one. I've seen the problem mentioned a couple times but found no real solutions.

Any help would be greatly appreciated

Thanks

September 22, 2006

try to replace

manufacturers_id)
					VALUES (
						$v_products_image . '", "'
						. $v_products_subimage1 . '", "'

by

manufacturers_id)
					VALUES (
						"$v_products_image . '", "'
						. $v_products_subimage1 . '", "'

September 22, 2006

Hi all,

Is there a trick to adding html to the product description field in easy populate via the excel speadsheet. I can upload everything just fine except the fields with html code in them. Also, excel adds another set of quotations to things that are already quoted. For example, width="130" somehow becomes width=""130""

Everything works fine other than the html, just looking for a solution so I do not have to add descriptions through admin one by one. I've seen the problem mentioned a couple times but found no real solutions.

Any help would be greatly appreciated

Thanks

look for this at the beginning of the EP.php

// **** 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;

and take appropriate action :-)

September 22, 2006

look for this at the beginning of the EP.php

// **** 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;

and take appropriate action :-)

I tried that and it gives me a bunch of errors wherever there is an apostrophy and it still doesn't import any html.

One thing I found is that when i upload html through admin and export the file it appears in excel in a different format then would be if I had just copied and pasted from frontpage or deamweaver.

Here is an examle of html code that works in excel when added through admin.

<div class="HubpageIntroHeading"> AMD Opteron 150 Socket 939 Processor. </div> <ul> <li>Maintain software compatibility with simultaneous 32-bit and 64-bit computing environments</li> <li>Operate 32-bit applications while you migrate to 64-bit computing, saving you time and money on software migrations or new purchases of software</li> <li>Decreased run-time cycles with increased bandwidth for incoming requests, allows you to allocate resources to other important projects and help increase system productivity</li> <li>Improved system throughput for faster networking connectivity to help speed decision support for those who need it</li> <li>Achieve the next level of computing performance while maintaining a balanced thermal and wattage solution </li> </ul> Technical Information: <div class="bodyContent"> <div class="bodyContent"> <table border="0" cellspacing="0" cellpadding="0"> <tbody><tr> <td> <table border="1" width="400"> <tbody><tr> <td class="gridTitle" colspan="2"> AMD Opteron™ Processor Details</td> </tr> <tr> <td class="rowHeader" width="150" align="left">CPU ID</td> <td class="rowItem" align="center">AMD Opteron™ Processor Model 150</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Model</td> <td class="rowItem" align="center">150</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Ordering Parts Number (OPN)</td> <td class="rowItem" align="center">OSA150BNBOX</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Stepping</td> <td class="rowItem" align="center">E4</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Frequency</td> <td class="rowItem" align="center">2.4GHz</td> </tr> <tr> <td class="rowHeader" width="150" align="left"> HyperTransport™ Technology Speed</td> <td class="rowItem" align="center">1000MHz</td> </tr> <tr> <td class="rowHeader" width="150" align="left"> Integrated Memory Controller</td> <td class="rowItem" align="center">2.4GHz</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Core Voltage</td> <td class="rowItem" align="center">1.35 V/1.4 V</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Case Temperature</td> <td class="rowItem" align="center">49° C to 71° C</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Wattage</td> <td class="rowItem" align="center">85.3.0W</td> </tr> <tr> <td class="rowHeader" width="150" align="left">L2 Cache Size</td> <td class="rowItem" align="center">1 MB</td> </tr> <tr> <td class="rowHeader" width="150" align="left">L2 Cache Speed</td> <td class="rowItem" align="center">2.4GHz</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Manf. Technology</td> <td class="rowItem" align="center">.09 micron SOI</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Socket</td> <td class="rowItem" align="center">Socket 939</td> </tr> <tr> <td class="rowHeader" width="150" align="left">Amperage</td> <td class="rowItem" align="center">60 A</td> </tr> </tbody></table> </td> </tr> </tbody></table> </div> </div>

Here is code that doesn't work.

"<div class=""greyScan468"">

Specifications</div>

<tr>

Model</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Brand</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Model</td>

</tr>

<tr>

Interface</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Interface</td>

<td>PCI Express x16</td>

</tr>

<tr>

Chipset</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Chipset Manufacturer</td>

<td>NVIDIA</td>

</tr>

<tr>

<td>Geforce 7950GX2</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Core clock</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">PixelPipelines</td>

</tr>

<tr>

Memory</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Memory Clock</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Memory Size</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Memory Interface</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Memory Type</td>

</tr>

<tr>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">DirectX</td>

<td>DirectX 9</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">OpenGL</td>

<td>OpenGL 2.0</td>

</tr>

<tr>

Ports</td>

</tr>

<tr>

</tr>

<tr>

<td>HDTV/S-Video/Composite Out</td>

</tr>

<tr>

</tr>

<tr>

General</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Vista Ready</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Dual-Link DVI

Supported</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Tuner</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">RAMDAC</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Max Resolution</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">SLI Supported</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Cooler</td>

<td>Heatsink and Fan</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Operating Systems

Supported</td>

<td>Windows XP/XP x64/MCE 2005</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">System Requirements</td>

<td>Minimum of a 450 Watt power supply.

(Minimum recommended power supply with +12 Volt current rating of 28

Amp Amps.)

Minimum 550 Watt for SLI mode system.

(Minimum recommended power supply with +12 Volt current rating of 36

Amp Amps.)

An available 6 pin PCI-E power connector (hard drive power dongle to

PCI-E 6 pin adapter included with card)</td>

</tr>

<tr>

Features</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Features</td>

<td>Full Microsoft DirectX 9.0 Shader Model 3.0

Support

NVIDIA CineFX 4.0 Engine

Full-Speed 128-Bit Studio-Precision Computation

Transparency Antialiasing

NVIDIA Intellisample 4.0 Technology

True High Dynamic-Range (HDR) Rendering Support

90nm Process Technology

NVIDIA PureVideo Technology

Important Note: SLI support for the e-GeForce 7950 GX2 will be

provided through a future NVIDIA ForceWare driver release, and will

only be available initially through authorized system builders.</td>

</tr>

<tr>

Packaging</td>

</tr>

<tr>

<td class=""tblEmp"" width=""130"">Package Contents</td>

<td>HDTV Cable

Power Cable

S-Video Cable

DVI Adapter x2

Driver CD

Manual</td>

</tr>

</table>

</div>

"

Not sure what the problem is, it seems excel is adding these quotation marks.

balynce · September 22, 2006

try to replace

manufacturers_id)
					VALUES (
						$v_products_image . '", "'
						. $v_products_subimage1 . '", "'

by

manufacturers_id)
					VALUES (
						"$v_products_image . '", "'
						. $v_products_subimage1 . '", "'

It looks like that now except i get this error...

Parse error: parse error, unexpected T_VARIABLE in /hsphere/local/home/balynce/store.balynce.com/admin/easypopulate.php on line 1715

September 22, 2006

I tried that and it gives me a bunch of errors wherever there is an apostrophy and it still doesn't import any html.

Not sure what the problem is, it seems excel is adding these quotation marks.

I meant: did you put it to false?

the other thing you can do if it doesn't work is remove all your quotes from the excel file with a search ad replace before you save it and upload

Edited September 22, 2006 by pixclinic

September 22, 2006

It looks like that now except i get this error...
Parse error: parse error, unexpected T_VARIABLE in /hsphere/local/home/balynce/store.balynce.com/admin/easypopulate.php on line 1715

what is on line 1715?

September 22, 2006

I meant: did you put it to false?

the other thing you can do if it doesn't work is remove all your quotes from the excel file with a search ad replace before you save it and upload

Ok, I tried replacing the quotes, and it says my formula is too long.

Does anyone know if there is a character limit or line limit that would cause it to not upload in ep?

balynce · September 22, 2006

what is on line 1715?

"$v_products_image . '", "'

September 22, 2006

"$v_products_image . '", "'

try to replace by

 '"' . $v_products_image . '", "'

and let me know

September 22, 2006

Ok, I tried replacing the quotes, and it says my formula is too long.

Does anyone know if there is a character limit or line limit that would cause it to not upload in ep?

I am pretty sure I'm having problems with the format of the html that I insert into excel causing EP to not import any html code.

This is my original html code that i would paste into excel and import it...this doesn't work

<div class="greyScan468">
<b><font color="#0000CC">Specifications</font></b></div>
<div class="contSInf">
<table class="tblSpecs" border="1" cellpadding="0" cellspacing="0" width="35%" id="table1" bordercolor="#C0C0C0">
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">Model</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Brand</font></td>
  <td><font size="2">eVGA</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Model</font></td>
  <td><font size="2">256-P2-N554-AX</font></td>
 </tr>
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">Interface</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Interface</font></td>
  <td><font size="2">PCI Express x16</font></td>
 </tr>
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">Chipset</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Chipset Manufacturer</font></td>
  <td><font size="2">NVIDIA</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">GPU</font></td>
  <td><font size="2">Geforce 7600GT</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Core clock</font></td>
  <td><font size="2">580MHz</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">PixelPipelines</font></td>
  <td><font size="2">12</font></td>
 </tr>
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">Memory</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Memory Clock</font></td>
  <td><font size="2">1500 MHz (effective)</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Memory Size</font></td>
  <td><font size="2">256MB</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Memory Interface</font></td>
  <td><font size="2">128-bit</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Memory Type</font></td>
  <td><font size="2">GDDR3</font></td>
 </tr>
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">3D API</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">DirectX</font></td>
  <td><font size="2">DirectX 9</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">OpenGL</font></td>
  <td><font size="2">OpenGL 2.0</font></td>
 </tr>
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">Ports</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">DVI</font></td>
  <td><font size="2">2</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">TV-Out</font></td>
  <td><font size="2">HDTV/S-Video Out</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">VIVO</font></td>
  <td><font size="2">No</font></td>
 </tr>
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">General</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Vista Ready</font></td>
  <td><font size="2">Yes</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Dual-Link DVI 
  Supported</font></td>
  <td><font size="2">Yes</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Tuner</font></td>
  <td><font size="2">None</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">RAMDAC</font></td>
  <td><font size="2">400 MHz</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Max Resolution</font></td>
  <td><font size="2">2560x1600</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">SLI Supported</font></td>
  <td><font size="2">Yes</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Cooler</font></td>
  <td><font size="2">Heatsink and Fan</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Operating Systems 
  Supported</font></td>
  <td><font size="2">Windows XP/XP x64/MCE 2005</font></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">System Requirements</font></td>
  <td><font size="2">Minimum of a 400 Watt power supply.<br>
  (Minimum recommended power supply with +12 Volt current rating of 18 
  Amp Amps.)<br>
  Minimum 450 Watt for SLI mode system.<br>
  (Minimum recommended power supply with +12 Volt current rating of 24 
  Amp Amps.)<br>
 </font></td>
 </tr>
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">Features</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Features</font></td>
  <td><font size="2">NVIDIA CineFX 4.0 engine<br>
  NVIDIA Intellisample 4.0 technology<br>
  NVIDIA nView multi-display technology</font></td>
 </tr>
 <tr>
  <td colspan="2" class="tblSpecsGroup"><b>
  <font size="2" color="#0000CC">Packaging</font></b></td>
 </tr>
 <tr>
  <td class="tblEmp" width="130"><font size="2">Package Contents</font></td>
  <td><font size="2">HDTV Cable<br>
  S-Video Cable<br>
  DVI to VGA Adapter<br>
  Driver CD<br>
  Manual</font></td>
 </tr>
</table>
</div>

When I enter it into the product description section and export and download the Ep excel file this same code looks like this.

<div>  <strong><font>Specifications</font></strong></div> <div>  <table border="1">   <tbody><tr>	<td><strong>	<font>Model</font></strong></td>   </tr>   <tr>	<td><font>Brand</font></td>	<td><font>eVGA</font></td>   </tr>   <tr>	<td><font>Model</font></td>	<td><font>256-P2-N554-AX</font></td>   </tr>   <tr>	<td><strong>	<font>Interface</font></strong></td>   </tr>   <tr>	<td><font>Interface</font></td>	<td><font>PCI Express x16</font></td>   </tr>   <tr>	<td><strong>	<font>Chipset</font></strong></td>   </tr>   <tr>	<td><font>Chipset Manufacturer</font></td>	<td><font>NVIDIA</font></td>   </tr>   <tr>	<td><font>GPU</font></td>	<td><font>Geforce 7600GT</font></td>   </tr>   <tr>	<td><font>Core clock</font></td>	<td><font>580MHz</font></td>   </tr>   <tr>	<td><font>PixelPipelines</font></td>	<td><font>12</font></td>   </tr>   <tr>	<td><strong>	<font>Memory</font></strong></td>   </tr>   <tr>	<td><font>Memory Clock</font></td>	<td><font>1500 MHz (effective)</font></td>   </tr>   <tr>	<td><font>Memory Size</font></td>	<td><font>256MB</font></td>   </tr>   <tr>	<td><font>Memory Interface</font></td>	<td><font>128-bit</font></td>   </tr>   <tr>	<td><font>Memory Type</font></td>	<td><font>GDDR3</font></td>   </tr>   <tr>	<td><strong>	<font>3D API</font></strong></td>   </tr>   <tr>	<td><font>DirectX</font></td>	<td><font>DirectX 9</font></td>   </tr>   <tr>	<td><font>OpenGL</font></td>	<td><font>OpenGL 2.0</font></td>   </tr>   <tr>	<td><strong>	<font>Ports</font></strong></td>   </tr>   <tr>	<td><font>DVI</font></td>	<td><font>2</font></td>   </tr>   <tr>	<td><font>TV-Out</font></td>	<td><font>HDTV/S-Video Out</font></td>   </tr>   <tr>	<td><font>VIVO</font></td>	<td><font>No</font></td>   </tr>   <tr>	<td><strong>	<font>General</font></strong></td>   </tr>   <tr>	<td><font>Vista Ready</font></td>	<td><font>Yes</font></td>   </tr>   <tr>	<td><font>Dual-Link DVI	 Supported</font></td>	<td><font>Yes</font></td>   </tr>   <tr>	<td><font>Tuner</font></td>	<td><font>None</font></td>   </tr>   <tr>	<td><font>RAMDAC</font></td>	<td><font>400 MHz</font></td>   </tr>   <tr>	<td><font>Max Resolution</font></td>	<td><font>2560x1600</font></td>   </tr>   <tr>	<td><font>SLI Supported</font></td>	<td><font>Yes</font></td>   </tr>   <tr>	<td><font>Cooler</font></td>	<td><font>Heatsink and Fan</font></td>   </tr>   <tr>	<td><font>Operating Systems	 Supported</font></td>	<td><font>Windows XP/XP x64/MCE 2005</font></td>   </tr>   <tr>	<td><font>System Requirements</font></td>	<td><font>Minimum of a 400 Watt power supply.<br />	(Minimum recommended power supply with +12 Volt current rating of 18	 Amp Amps.)<br />	Minimum 450 Watt for SLI mode system.<br />	(Minimum recommended power supply with +12 Volt current rating of 24	 Amp Amps.)<br />  </font></td>   </tr>   <tr>	<td><strong>	<font>Features</font></strong></td>   </tr>   <tr>	<td><font>Features</font></td>	<td><font>NVIDIA CineFX 4.0 engine<br />	NVIDIA Intellisample 4.0 technology<br />	NVIDIA nView multi-display technology</font></td>   </tr>   <tr>	<td><strong>	<font>Packaging</font></strong></td>   </tr>   <tr>	<td><font>Package Contents</font></td>	<td><font>HDTV Cable<br />	S-Video Cable<br />	DVI to VGA Adapter<br />	Driver CD<br />	Manual</font></td>   </tr>  </tbody></table> </div>

I suspect this might be the reason why I cannot import html in my description column, is there a way to format my code like this in frontpage or dreamweaver to look like this? I can see there is a difference I'm just not sure what it is.

September 22, 2006

I don't even know how to use Dreamweaver or Frontpage, so I can't help you with this. Maybe try EP 2.9 and see if it handles the HTML better

balynce · September 23, 2006

try to replace by
 '"' . $v_products_image . '", "'
and let me know

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /hsphere/local/home/balynce/store.balynce.com/admin/easypopulate.php on line 1715

September 23, 2006

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /hsphere/local/home/balynce/store.balynce.com/admin/easypopulate.php on line 1715

I give up :-) Somebodyelse's turn please!

Easy Populate & Products Attributes

Recommended Posts

Guest

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

tgely

Guest

surfalot

Posted Images

Guest

Guest

Guest

Guest

Guest

Guest

Guest

Guest

Guest

Guest

Guest

Guest

Guest

Guest

Join the conversation