Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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! :)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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! :)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by pixclinic
Link to comment
Share on other sites

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')
						";

Link to comment
Share on other sites

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

Link to comment
Share on other sites

try to replace

 

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

 

by

 

 

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

Link to comment
Share on other sites

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 :-)

Link to comment
Share on other sites

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"> <font color="#0000cc"><strong>AMD Opteron 150 Socket 939 Processor.  </strong></font></div><span class="btext"> <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> <p><font color="#0000cc"><strong>Technical Information:</strong></font></p> </span> <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"><font color="#0000cc"> AMD Opteron™ Processor Details</font></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> <p> </p></div> <p> </p>

 

 

 

 

Here is code that doesn't work.

 

"<div class=""greyScan468"">

<font color=""#0000CC""><b>Specifications</b></font></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"">

<font color=""#0000CC"" size=""2""><b>Model</b></font></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"">01G-P2-N592-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 7950GX2</font></td>

</tr>

<tr>

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

<td><font size=""2"">500MHz</font></td>

</tr>

<tr>

<td class=""tblEmp"" width=""130""><font size=""2"">PixelPipelines</font></td>

<td><font size=""2"">48</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"">1200MHz</font></td>

</tr>

<tr>

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

<td><font size=""2"">1GB</font></td>

</tr>

<tr>

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

<td><font size=""2"">512-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""><font size=""2"">3D API</font></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/Composite 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 450 Watt power supply.<br>

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

Amp Amps.)<br>

Minimum 550 Watt for SLI mode system.<br>

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

Amp Amps.) <br>

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

PCI-E 6 pin adapter included with card)</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"">Full Microsoft DirectX 9.0 Shader Model 3.0

Support <br>

NVIDIA CineFX 4.0 Engine <br>

Full-Speed 128-Bit Studio-Precision Computation <br>

Transparency Antialiasing <br>

NVIDIA Intellisample 4.0 Technology <br>

True High Dynamic-Range (HDR) Rendering Support <br>

90nm Process Technology<br>

NVIDIA PureVideo Technology<br>

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.</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>

Power Cable<br>

S-Video Cable<br>

DVI Adapter x2<br>

Driver CD<br>

Manual</font></td>

</tr>

</table>

</div>

"

 

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by pixclinic
Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

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...