Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

VJ

Easy Populate & Products Attributes

Recommended Posts

leave that alone in your configure.php. Most already have that set correctly. What i means is this:

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

the main concern is the temp path setting in your easypopulate.php file. Please download and try the version I uploaded v2.76d. Go through the settings in the easypopulage.php file since this version has all the settings in the file itself. You shouldn't have any trouble using the default settings with $excel_safe_output set to true (and the temp path mensioned earlier of course)

 

Okay now it works. Thanks alot!

 

But now there is another problem as well, this is what it says when I try and upload:

File uploaded.

Temporary filename: /tmp/php7UWaKo

User filename: _EP2007feb25-2210.txt

Size: 24316

##Can not open CSV file for reading. Script will terminate.

 

Is my temp directory correct? The directory layout is domain.com/shop/catalog/ and the easypopulate.php file says:

$tempdir = DIR_FS_DOCUMENT_ROOT . "/shop/catalog/temp/";

Edited by d.aspo

Share this post


Link to post
Share on other sites
Okay now it works. Thanks alot!

 

But now there is another problem as well, this is what it says when I try and upload:

File uploaded.

Temporary filename: /tmp/php7UWaKo

User filename: _EP2007feb25-2210.txt

Size: 24316

##Can not open CSV file for reading. Script will terminate.

 

Is my temp directory correct? The directory layout is domain.com/shop/catalog/ and the easypopulate.php file says:

$tempdir = DIR_FS_DOCUMENT_ROOT . "/shop/catalog/temp/";

 

Problem solved! I had $DOCUMENT_ROOT inside '', I removed those and it worked and gave a nice new error message:

 

"No products_model field in record. This line was not imported"

Share this post


Link to post
Share on other sites
are you simply turning the same export file around to import? how about posting a link to the file you are trying for me to look at.

 

 

Hi,

 

I am downloading the file, amending information either adding descriptions, changing prices, adding products and then uploading it back up.

 

Worked well with 2.76c on my old host but seem to be struggling with this?

 

here's a link for you - i have just shown the first 10 products in the list.

 

http://domain1260540.sites.fasthosts.com/feed.csv

 

Many Thanks

D4

Share this post


Link to post
Share on other sites
Problem solved! I had $DOCUMENT_ROOT inside '', I removed those and it worked and gave a nice new error message:

 

"No products_model field in record. This line was not imported"

"/shop/catalog" is probably part of your DIR_FS_DOCUMENT_ROOT, so try this:

$tempdir = DIR_FS_DOCUMENT_ROOT . "/temp/";

 

I see in the error, you have uploaded a txt file and EP is expecting a CSV file. if you have enabled $excel_safe_output, you will need to save your excel files as DOS CVS, not tab-TXT, for import.

 

Make sure you import file has the first column as the model_number. It must also be unique for all products.

Share this post


Link to post
Share on other sites
Hi,

 

I am downloading the file, amending information either adding descriptions, changing prices, adding products and then uploading it back up.

 

Worked well with 2.76c on my old host but seem to be struggling with this?

 

here's a link for you - i have just shown the first 10 products in the list.

 

http://domain1260540.sites.fasthosts.com/feed.csv

 

Many Thanks

D4

doesn't appear that you have offered this information yet:

php ver? globals (on/off)?

MySQL ver?

 

you are not getting any message after the upload? just a refresh of the page?

Share this post


Link to post
Share on other sites
"/shop/catalog" is probably part of your DIR_FS_DOCUMENT_ROOT, so try this:

$tempdir = DIR_FS_DOCUMENT_ROOT . "/temp/";

 

I see in the error, you have uploaded a txt file and EP is expecting a CSV file. if you have enabled $excel_safe_output, you will need to save your excel files as DOS CVS, not tab-TXT, for import.

 

Make sure you import file has the first column as the model_number. It must also be unique for all products.

 

I've done all those things and saved the file as a MS-DOS CSV file instead but still I get this:

File uploaded.

Temporary filename: /tmp/phpQnfXZs

User filename: 22EP2007feb25-2210.csv

Size: 118472

##Can not open CSV file for reading. Script will terminate.

 

However the other issues are gone.

 

Okay I changed the DIR_FS_DOCUMENT_ROOT back and now I get these lines again

 

No products_model field in record. This line was not imported

 

| 1565;;2 Do

 

No products_model field in record. This line was not imported

Edited by d.aspo

Share this post


Link to post
Share on other sites

Well duh, excel saved it with semicolons instead... replaced them and it worked, well kinda, categories are all wrong.

Share this post


Link to post
Share on other sites
your problem is most likely the Register Globals: Off.

This contribution is not register globals off compatible. See if your host allows you to override it with a local php.ini

 

My site is configured for register globals off (and so without re-configuring can't have them on) and from what I have read the consunsus is thats the way it should be.

 

Also the easy populate contribution of 12 of feb suggests is does work with globals off.

I can see its not your contribution but you seem to think it doesn't work? can you give any advice as to why not?

 

Many thanks

Graeme

Share this post


Link to post
Share on other sites
doesn't appear that you have offered this information yet:

php ver? globals (on/off)?

MySQL ver?

 

you are not getting any message after the upload? just a refresh of the page?

 

Hi,

 

globals = off

php ver = 4.4.1 (Zend: 1.3.0)

mysql ver = 4.1.22-standard

 

no error message being received just a quick reload/refresh of the page.

 

Hope this helps

 

Many Thanks

D4

Edited by d4funky1

Share this post


Link to post
Share on other sites

Hi everyone

 

i have come across a problem with images i want in my description and Easy Populate muddles the code when its up loaded?

 

I basically have some other images in my product description using basic html, this is an example of the code ive used:

 

<img src="http://www.mystore.co.uk/images/products/examplepic.jpg" align="baseline" border="0" />

 

when i use this code in the normal way of adding products via OSC it works fine and the image shows, however if i use this code in the excel file im using to upload my products it doesnt show? Ive tried adding the \ before the " like you need to with the apostrophe character and no joy?

 

Ive looked at the code of the page and instead of there been a " character there is & # 34 but bunched together, ive just edited this as it showed a " instead of the code on this post??

 

Is there a special way of adding the " character or a way of adding images to the product description, i must have missed something.

 

thanks for your help

 

Russel

Share this post


Link to post
Share on other sites
Hi everyone

 

i have come across a problem with images i want in my description and Easy Populate muddles the code when its up loaded?

 

I basically have some other images in my product description using basic html, this is an example of the code ive used:

 

<img src="http://www.mystore.co.uk/images/products/examplepic.jpg" align="baseline" border="0" />

 

when i use this code in the normal way of adding products via OSC it works fine and the image shows, however if i use this code in the excel file im using to upload my products it doesnt show? Ive tried adding the \ before the " like you need to with the apostrophe character and no joy?

 

Ive looked at the code of the page and instead of there been a " character there is & # 34 but bunched together, ive just edited this as it showed a " instead of the code on this post??

 

Is there a special way of adding the " character or a way of adding images to the product description, i must have missed something.

 

thanks for your help

 

Russel

Try dropping the " as the code generally works okay without them (that is in my case) in product descriptions, however you may need to add a contrib called "Embed Link with SID in Description" to help your html work correctly. Basically, instead of using " you use %%+ and %%- you can find it here;- http://www.oscommerce.com/community/contri...ks+contribution

 

Steve


____________________________________________________________________

____________________________________________________________________

Share this post


Link to post
Share on other sites

Hi Steve

 

thanks very much buddy, your suggestion to drop the " works perfectly, wonder why it doesnt understand them??

 

Anyway thanks again for your help, you saved me from pulling my hair out!

 

top man!!

Share this post


Link to post
Share on other sites
I've done all those things and saved the file as a MS-DOS CSV file instead but still I get this:

File uploaded.

Temporary filename: /tmp/phpQnfXZs

User filename: 22EP2007feb25-2210.csv

Size: 118472

##Can not open CSV file for reading. Script will terminate.

 

However the other issues are gone.

 

Okay I changed the DIR_FS_DOCUMENT_ROOT back and now I get these lines again

 

No products_model field in record. This line was not imported

 

| 1565;;2 Do

 

No products_model field in record. This line was not imported

seee post 4939 for instructions on a modification for those not in the US. Seems like EU format for windows tells excell to use semi-colons for separtors.

Share this post


Link to post
Share on other sites
My site is configured for register globals off (and so without re-configuring can't have them on) and from what I have read the consunsus is thats the way it should be.

 

Also the easy populate contribution of 12 of feb suggests is does work with globals off.

I can see its not your contribution but you seem to think it doesn't work? can you give any advice as to why not?

 

Many thanks

Graeme

Have had reports that it doesn't address the entire issue. I have not tried it, I'm working on a different version with more solid and complete non-use of globals. sorry, no ETA yet.

Share this post


Link to post
Share on other sites
Hi,

 

globals = off

php ver = 4.4.1 (Zend: 1.3.0)

mysql ver = 4.1.22-standard

 

no error message being received just a quick reload/refresh of the page.

 

Hope this helps

 

Many Thanks

D4

this contribution is not register globals off friendly. (see above post) (and many other posts about this)

Share this post


Link to post
Share on other sites
Hi everyone

 

i have come across a problem with images i want in my description and Easy Populate muddles the code when its up loaded?

 

I basically have some other images in my product description using basic html, this is an example of the code ive used:

 

<img src="http://www.mystore.co.uk/images/products/examplepic.jpg" align="baseline" border="0" />

 

when i use this code in the normal way of adding products via OSC it works fine and the image shows, however if i use this code in the excel file im using to upload my products it doesnt show? Ive tried adding the \ before the " like you need to with the apostrophe character and no joy?

 

Ive looked at the code of the page and instead of there been a " character there is & # 34 but bunched together, ive just edited this as it showed a " instead of the code on this post??

 

Is there a special way of adding the " character or a way of adding images to the product description, i must have missed something.

 

thanks for your help

 

Russel

I added an excel safe output option to allow v2.76d contribution to handle special character. Set that option to true, should allow any HTML in your code.

Edited by surfalot

Share this post


Link to post
Share on other sites
Guest

HELLO

 

I HAVE A SERIOUS PROBLEM WITH EASY POPULATE, IT WORKS PERFECTLY IN MY TWO STORES BUT ..

 

NOW IT LOGS OUT WHEN IMPORTING A FILE IN OTHER STORE, DONT UPLOAD AND LOGOUT, IF I TRY TU PUT THE IMPORT FILE IN TEMP DIRECTORY, JUST LOGOUT, ONLY HAPPENS WITH EASY POPULATE.

mY STORE AS INSTALLED SPPC, ADMIN ACCESS LEVELS 2.2, EASY POPULATE 2.76, PHP 4, MYSQL 4.1, REGISTER GLOBALS OFF (other stores have the same characteristics and same server)

 

this store works as multishop, with different products table for each shop:

ex: audio_products

info_products

with different admin for each shop

 

CRITICAL PLEASE HELPP

 

P.S. - Sorry my english

Share this post


Link to post
Share on other sites
HELLO

 

I HAVE A SERIOUS PROBLEM WITH EASY POPULATE, IT WORKS PERFECTLY IN MY TWO STORES BUT ..

 

NOW IT LOGS OUT WHEN IMPORTING A FILE IN OTHER STORE, DONT UPLOAD AND LOGOUT, IF I TRY TU PUT THE IMPORT FILE IN TEMP DIRECTORY, JUST LOGOUT, ONLY HAPPENS WITH EASY POPULATE.

mY STORE AS INSTALLED SPPC, ADMIN ACCESS LEVELS 2.2, EASY POPULATE 2.76, PHP 4, MYSQL 4.1, REGISTER GLOBALS OFF (other stores have the same characteristics and same server)

 

this store works as multishop, with different products table for each shop:

ex: audio_products

info_products

with different admin for each shop

 

CRITICAL PLEASE HELPP

 

P.S. - Sorry my english

both your other stores have register globals off? Have you had to install the osC register golbals patch for all three shops?

Share this post


Link to post
Share on other sites

nevermind. :thumbsup:

Edited by surfalot

Share this post


Link to post
Share on other sites

Ok so I'm trying to install EZpopulate version 2.76c into my oscommerce store and I've read the manual through and the read me first thing, but I'm having trouble on this part:

 

4. Make sure that you have a directory called catalog/temp, and that it's permissions are set to allow writes to that directory (while you're in the catalog directory, execute "chmod 777 temp"). If you have changed the directory structure of your OSC install (i.e. you don't have /catalog/temp/ in your document root anymore), then you'll need to go into easypopulate.php and change the setting of "$tempdir".

 

My permissions are set to allow writes, but my directory structure has changed and I dont have a temp folder anymore or directory or whatever. Anyway, the part where it says change the setting of "$tempdir".

 

CHANGE IT TO WHAT??? is the thing I'm having trouble with. Thanks in advance!

Share this post


Link to post
Share on other sites
I'm sorry, I have not worked with that contribution. the help in the EP docs are:

 

I would suggest starting with an export and taking a look at the format. You first need to know what the ID# for the groups are that you have created. (look at the export)

I suspect it will be something like this. (note the second group id and price id numbers)

hope that helps

 

Thanks for your help. Surfalot

 

It didnt work but I suspect that has as much to do with the incompetence of the guys gouging me for "support" rather than the contribution

Share this post


Link to post
Share on other sites

Please guys I need some desperate help with this.

 

What I have done is duplicate my existing shop, basically exported the SQL database.

 

I then installed a fresh copy of Oscommerce, copied over all the files of the original shop and imported the database. So in theory both shops are exact duplicates.

 

Well not what I thought, everything works 100% except the Easy Populate, when I upload the EP file, it uploads everything but the Attributes for the products.

 

Is there some files I maybe forgot to upload? or is there something else I am doing wrong?

 

 

Please help! blush.gif

Share this post


Link to post
Share on other sites
Thanks for your help. Surfalot

 

It didnt work but I suspect that has as much to do with the incompetence of the guys gouging me for "support" rather than the contribution

did you do the export? what where the group IDs you saw?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×