Easy Populate & Products Attributes

iantates · August 9, 2004

Warning: file(/home/wendy/simplyfancydress-www/catalog//simplyfancydress-

I think I have found the problem there appears to be two // before the simplyfancydress also it appears its been duplicated.

Is that normal?

deroguy · August 10, 2004

post an example line of a product

Here is the code. I know it is a little rough but, eh..html is not my strength.

<html>

<BODY>

<TABLE>

<TBODY>

<TR>

<TD class=deschdr><STRONG><U><font color="#A52A2A"><font size="2">Item

Includes</font></U></STRONG></TD></TR></TBODY></TABLE>

<TBODY>

<TR>

<BR>

<TABLE>

<TBODY>

<TR>

<TD class=deschdr><STRONG><U><font color="#A52A2A"><font size="2">Description</font></U></STRONG></TD></TR></TBODY></TABLE>

<TABLE>

<TBODY>

<TR>

High-performance, L-series telephoto zoom lens combining light weight and compactness with an f/4 maximum aperture. Inner focusing and the ring USM enable quick and quiet autofocusing. Also, a circular polarizing filter can be attached and used without difficulty because the front lens element does not rotate during focusing. The tripod collar (sold separately) is the same one used with the EF 300mm f/4L USM.</TD></TR></TBODY></TABLE>

<TABLE>

<TBODY>

<TR>

<P><STRONG><U><font color="#A52A2A"><font size="2">Specifications</font></U></STRONG></P></TD></TR></TBODY></TABLE>

<TBODY>

<TR>

<TD class=specq><strong><font size="2">Construction</strong></TD>

<TD class=speca><font size="2">13 groups /16 elements</TD></TR>

<TR>

<TD class=specq><strong><font size="2">Angle of view</strong></TD>

<TR>

<TD class=specq><strong><font size="2">F stop range</strong></TD>

<TR>

<TD class=specq><strong><font size="2">Closest Focusing Distance</strong></TD>

<TR>

<TD class=specq><strong><font size="2">Maximum Magnification</strong></TD>

<TR>

<TD class=specq><strong><font size="2">Filter Size</strong></TD>

<TR>

<TD class=specq><strong><font size="2">Dimensions (Length x Diameter)</strong></TD>

<TR>

<TD class=specq><strong><font size="2">Weight</strong></TD>

Here is the code taken once it has been uploaded by easy populate

<html>

<BODY>

<TABLE>

<TBODY>

<TR>

<TD class=deschdr><STRONG><U><font color="#A52A2A"><font size=Ŗ">Item

Includes</font></U></STRONG></TD></TR></TBODY></TABLE>

<TBODY>

<TR>

<BR>

<TABLE>

<TBODY>

<TR>

<TD class=deschdr><STRONG><U><font color="#A52A2A"><font size=Ŗ">Description</font></U></STRONG></TD></TR></TBODY></TABLE>

<TABLE>

<TBODY>

<TR>

High-performance, L-series telephoto zoom lens combining light weight and compactness with an f/4 maximum aperture. Inner focusing and the ring USM enable quick and quiet autofocusing. Also, a circular polarizing filter can be attached and used without difficulty because the front lens element does not rotate during focusing. The tripod collar (sold separately) is the same one used with the EF 300mm f/4L USM.</TD></TR></TBODY></TABLE>

<TABLE>

<TBODY>

<TR>

<P><STRONG><U><font color="#A52A2A"><font size=Ŗ">Specifications</font></U></STRONG></P></TD></TR></TBODY></TABLE>

<TBODY>

<TR>

<TD class=specq><strong><font size=Ŗ">Construction</strong></TD>

<TD class=speca><font size=Ŗ">13 groups /16 elements</TD></TR>

<TR>

<TD class=specq><strong><font size=Ŗ">Angle of view</strong></TD>

<TR>

<TD class=specq><strong><font size=Ŗ">F stop range</strong></TD>

<TR>

<TD class=specq><strong><font size=Ŗ">Closest Focusing Distance</strong></TD>

<TR>

<TD class=specq><strong><font size=Ŗ">Maximum Magnification</strong></TD>

<TR>

<TD class=specq><strong><font size=Ŗ">Filter Size</strong></TD>

<TR>

<TD class=specq><strong><font size=Ŗ">Dimensions (Length x Diameter)</strong></TD>

<TR>

<TD class=specq><strong><font size=Ŗ">Weight</strong></TD>

Well, I hope you can help me work out why my font size variables are being changed. Who know it may even be my dodgy coding.

Mibble, Thanks in advance

August 10, 2004

your problem is most likely in your configure.php file for the admin section, post that here without the database user info, name, password.

deroguy · August 10, 2004

Sorry for wasting your time Mibble. It wasn't until I looked at the two lots of code side by side that I worked out you won't need quotes around numbers. Hence the reason it is going crazy. Once I correct this I am sure it will be fine.

Thank you for your help anyway. And fast replies

krisdv · August 10, 2004

I'm running EP 2.74 and after exporting, changing the price and importing the file the order in "available options" for the products have changed.

For example it used to be:

Memory : 4 MB (selected by default)

Memory : 16 MB +50 euro

Memory : 32 MB +70 euro

And now it changed to:

Memory : 32 MB +70 euro (selected by default)

Memory : 16 MB +50 euro

Memory : 4 MB

What could be the reason for this? Or more important how can I put it back?

Sorry if this has been handled before, I must have overlooked it then.

djgizmo · August 10, 2004

krisdv, I'm in the same boat as you. I've been informed to use the Attribute Sort Order contribution.

also, big FYI to everyone who has catagories that use '

Example "CD's"

When you upload your products from the tab delimited file, it will duplicate an additional catorgory that has the apostrophe.

Example you have a catagory already on the site called CD's, you're updating the information some products in that catagory, when you upload it will duplicat that Catagory, and save those changes to the duplicated catigory along with any sub-cat's.

I just discovered this last night.

August 10, 2004

Sean, did you find that for only categories with an apostrophe?

The sort order does work well, as it adds the additional fields required for the sort.

wlpywd · August 11, 2004

Does anyone know how to get easypopulate to work with other languages, or unicode support? specifically, non-US, non-roman based languages (i dont remember the iso-XXXXx name right now...) (non roman languages, basically. spanish, german, english, etc. works but i believe someone had russian problems before, i've asian language problems.) i can't use it to enter anything, even with a non-US windows excell (that saves in unicode txt files). I can enter the charictors from admin manually, and the database takes them; i can create txt files. but somewhere i the easypopluate transfer, upload and download, it won't recognize them and enters whole discriptions, item names, categories as :

????

ANY help would be great! I know it's not OSCOMMERCE or the database, my server, or txt files. It's somewhere in easypopulate..........

Edited August 11, 2004 by wlpywd

August 11, 2004

somewhere about 5 to 10 pages back in the thread this is discussed. most things people are asking are here somewhere in the thread.

djgizmo · August 11, 2004

John, I haven't really tested beyond my current setup... (which of course is small since I'm comepletely re-doing my store... ) Item's themselves with apostrophe or quotes do not seem to be affected... I'll try tonight and let you know.

djgizmo · August 11, 2004

Ok, I confirmed it... if you use apostrophes in Product names it does not duplicate it. I hope this helps Mibble.

August 11, 2004

I have not had time to test, what happens if you go in and remove the apostrophes on the current categories, and then run an update ep file without apostrophes.

wlpywd · August 11, 2004

No, it hasn't. I've read through this entire thread twice. This has nothing to do with the proper table in the database for a second language nor the language of the menus of EP for admin integration. This deals with the character-sets and encoding of the txt file during EPs handing of the file. it's sorta similar to the person who had EP corrupting the text for no apparent reason. Any western-latin encoding is handled fine, be it french, spanish, german, or english. As soon as you use a character-set that requires new page encoding, such as russian, chinese, or japanese, EP does not handle the file correctly and enserts the text into the database using the iso-8859-1 (table 28951 i think) -- which doesn't have the chinese, russian, etc. characters in the table. Resulting in a loss of data. The data put into the database reverts to the "unrecognized character"-character, which is a ?question mark. I don't know how EP handles the txt document OR how it interacts with the database... i know OSCOMMERCE interacts with the database correctly because it will save the items and descriptions in the native language just fine when done manually. I don't think it's the txt file either, because txt files can be created on non-english windows systems with proper encoding, saved and reopened with excel just fine. EP also does not download the data correctly from the database if it's not english. i've read where EP isnt non-english compatible but also where some have it to work. ...something along the lines of the gal that was getting corrupted symbals, some fix along those lines. but i can't figure it out, and i know just a little php. Any links or suggestions out there?

mattmcb · August 12, 2004

Does anyone know of a way to import a file with 10,000 records into easypopulate?

I have adjusted the timeout and maxrecords with no success. I run it, I don't get any errors and no data is commited to the DB. Any ideas?

August 12, 2004

you must use the split files with that many products as the server times out before everything gets done. or else increase the server time in php.ini to 10 minutes.

mattmcb · August 13, 2004

Does anyone know of a way to import a file with 10,000 records into easypopulate?

I have adjusted the timeout and maxrecords with no success. I run it, I don't get any errors and no data is commited to the DB. Any ideas?

mattmcb · August 13, 2004

Lets say I split the files... then what. I have to load 300 products at one time when I want to load 135000 products?

August 13, 2004

you did not state if you used the split record function. thevery first thing you need to do is try a small sampling of info, to see how it goes.

it could be you have errors in your data, so try 10 to 20 records.

on one of my servers, i have uploaded 3000 items at once, with no problem.

it is easier for me to split at a setting i know which works for one of my servers i control for the client.

some of my other servers i can increase, but they dont use osC.

Edited August 13, 2004 by Mibble

August 13, 2004

you can always write a custom vb script to do it. it is a bit of work, lots depends upon if you are using product attributes or not.

siavash · August 13, 2004

hi there,

i know that someone else had this issue when uploading html codes using EP but i still don't know what the solution is!

when i upload products, the descriptions (input using html) don't seem to upload right. when i checked my source code of the uploaded product i realized that the codes were messed up with strange characters. see example below:

part of the original code :

<table border="0" style="font-size: 9pt" style="border-collapse: collapse" width="100%">
?<tr>
? ?<td width="180">
? ?<font color="#990000">

and the code after upload w/ EasyPopulate:

<table border=?0" style=font-size: ?9pt?r" style="border-collapse: collapse" width=薄%">
?<tr>
? ?<td width="薄"> 
? ?<font color=?#990000"> 
? ?

as a result i get weired characters or table style on my product description page!

what do i need to do?

i guess i can probably disable the html thingy that inserts \ for ' s but then i make it difficult for myself in some otherway. have you bumped into this? what's the solution round it?

appreciate your help.

Edited August 13, 2004 by siavash

August 13, 2004

on or around line 72 in easypopulate.php it states this:

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

siavash · August 13, 2004

John,

did that .. changed $replace_quotes = true; to false! but got worse!! this is waht i got as a result in my EP admin:

File uploaded. 
Temporary filename: /tmp/phpcrIGwx
User filename: testupload.txt
Size: 2407
| 1570013 | brands/phi | Philips bS | Philips's | | 994.1 | | | | | Philips | Projectors | Business | | Taxable | !New Product!
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 bCool XG1 has SmartDimmer Mode? also known as Eco mode among

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '144', 1, 'Philips bSure SV2 Brilliance', 'Philips's bCool XG1 has SmartDimmer Mode? also known as Eco mode amongst other manufacturers, which reduces the brightness to 1500 lumens resulting in an increase in lamplife of up to 30% (1900 hrs total life) and reduces fan noise from 35dB to 33dB for those occasions when full brightness is not needed.
Security Max? provides a password based security system with user definable time setting to give a some form of projection against theft.

The bCool XG1 is best suited for people on the move and who give presentations to audiences numbering from 2 to 20 people.

Luminance (ANSI Lumen): 1700 
Lamp Life (hrs): 2000 
Resolution: XGA 
Weight (kg): 1.6 
Contrast Ratio: 2000:1 
Noise (dB): 35 
Audio Output: 2W mono  
Wireless Capacity: No 
Projection Size: 25" - 292" diagonal 
Warranty Info: 1 year loan support + 2 years return to base  
', '' )

[TEP STOP]

the table and fonts shouldn't look like this at all and anyway the product was not uploaded. process stopped!!

what now?

August 13, 2004

could be with using apostrophes and quites, you may have to use the \ preceding them. just test one product , two different lines, one with the \ and the other without the \ and see the display results. product model must be different between the two.

siavash · August 13, 2004

most probably this is the case john but when i change $replace_quotes back to true and upload the product gets uploaded right in all respect even the apostrophe in the description or product title. the only thing this is messed up is the table in my html product description field.

wait cause now it is getting even more interesting!!!

i went to admin to see the product description where you can edit it. i did not touch a single thing at all but clicked preview and then update. guess what!? when i go back to the shop everything is perfectly alright and there's absolutely no problems at all!!!!!!! bear inmind that the weired characters and strange stuff are still in my code since i didn't touch anything. they are still there when i view the source code of the peoduct page but it shows alright!!!!

i wonder why this happens? and how it can affect the way it appears on users' monitors? and obviously i don't want to go to product page for 2000+ products to ensure that the description works alright!!

any ideas?

August 13, 2004

not really for ideas, i would need to look at the data. you can send to me and i will look thru your data file.

Easy Populate & Products Attributes

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

tgely

Guest

surfalot

Posted Images

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Join the conversation