Easy Populate & Products Attributes

[surfalot]

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!

I can tell you what to set that to if you provide me with the info necessary.

what is the physical (file system) path to your osCommerce store front? If you don't know, ask you host.

is your shop installed in the default directory? (sitename.com/catalog/)

or is it in the root of the shop? (sitename.com/)

[surfalot]

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

if the attributes are in your import file, but not being added to the products when importing. This is the first I've heard of this kind of problem. PHP ver? PHP register globals (on/off)? MySQL vers? Same on both servers?

[graphicore]

if the attributes are in your import file, but not being added to the products when importing. This is the first I've heard of this kind of problem. PHP ver? PHP register globals (on/off)? MySQL vers? Same on both servers?

 

Easy Populate DOES NOT import/export Download Attributes at all. (If that's what's everyone is refering to).

[surfalot]

Easy Populate DOES NOT import/export Download Attributes at all. (If that's what's everyone is refering to).

oh, download attributes. yup, not there.

Edited March 1, 2007 by surfalot

[paladine]

if the attributes are in your import file, but not being added to the products when importing. This is the first I've heard of this kind of problem. PHP ver? PHP register globals (on/off)? MySQL vers? Same on both servers?

 

Its on the exactly the same server just under a different subfolder..

[Shadyone]

Hi all, having a slight problem while using Easy populate.

When I import a medium size file (100 or so lines) I get this error

 

Fatal error: Maximum execution time of 30 seconds exceeded in /home/wholesal/public_html/admin/includes/functions/general.php on line 1541

 

I've lived with it for a week or so since I've been using EP by having smaller sized files (30-50 lines)

I am now trying to update my entire database of close to 500 products, I used the split file update thingy thru EP and am getting this error. I'd rather not split my whole database up into tiny files and update individually and I think its about time I search for a fix.

 

Thanks to anyone that can offer some advice

 

Cheers

Darren

Edited March 1, 2007 by Shadyone

[Shadyone]

After searching for quite a while I found that this has been reported as a bug ( I knew sure as shit that I was not the only one)

The bug fix say to insert "ini_set('max_execution_time', 600);" at the top of your control file.

 

Can anyone tell me what and where is the control file.

 

Here's the link to the bug fix

http://www.oscommerce.com/community/bugs,1...ch,maximum+time

Edited March 1, 2007 by Shadyone

[Shadyone]

OK I think I have found where to put it

 

I inserted it at the top of the

 

home/wholesal/public_html/admin/includes/functions/database.php file and it seems to have worked.

 

I'll keep testing and see what happens but at least it lets me get past 30secs

[KPGroup]

Hello,

 

I am in the process of configuring EasyPopulate 2.76d.

 

I have made modifications to my PRODUCTS table (I have 5 new fields, QBI imported, dimensions (L, l, h), read_to_ship).

I also installed the "Fixed Price for Different Currencies" contribution, which means that the prices for the items are retreived from another table (FIXED_PRICES) instead of the PRODUCTS table.

 

Can anyone give me some indications of where I would have to make the modifications to handle this?

 

Thank you in advance for any tips you can give me!

 

Karim.

[HiOctane]

Hey All,

 

I have recently installed the Easy Populate module on our site and used it to populate the updates that I have been working on. The problem is that all the formating, image links and added little styles have been wiped out.

 

Does anyone know why this would be happening and how I can get around it, I thought that it may have been the fact that the " was causing issues so I added \" to see if that would work but no luck.

 

Here are some examples of the code:

 

What I entered:

 

<h5 align="center">**PLEASE NOTE: Prices listed here are EXCLUDING GST. GST will be added to your transaction upon order completion**</h5>
<hr width="80%" color="#ff0000" align="center">

 

It downloads fine when I export the data from the database and displays as above, when I upload the file the code changes to the following:

 

<h5 align="center">**PLEASE NOTE: Prices listed here are EXCLUDING GST. GST will be added to your transaction upon order completion**</h5>  <hr width=඘%" color="#ff0000" align="center">

 

The code is suppose to center the text and display a red line at 80% width under the text, now it is a 100% width green line under left aligned text which retains the H5 format.

 

Any help would be greatly appreciated as I have spent a lot of time editing all the previous products to the new format and now have lost all of it.

 

Cheers,

Pete

[JangoF]

This is a great contribution, but I am having a big problem importing products, and I cannot see what I am doing wrong.

 

I have one test product in the store, now I would like to add around 25 more by using Easy Populate (which I am using with the Extra Fields contribution). Downloading the complete CSV file to edit works fine, so does reimporting it with the one test product I have installed.

 

Now I have gone over the syntax in the file I am trying to import over and over in the last 2 hours, and I am going crazy. All I get when Import is this message:

 

No products_model field in record. This line was not imported

 

I know perfectly well that you have to include a products_model, something which I have done for all the products in the file. But I still get the message, I don't know why.

 

I have included both the exported file and the file that I am trying to import, you can download and view the archive here:

http://home.online.no/~kjetil.v/import.zip

 

Can anyone see what I am doing wrong?

[Guest]

This is a great contribution, but I am having a big problem importing products, and I cannot see what I am doing wrong.

 

I have one test product in the store, now I would like to add around 25 more by using Easy Populate (which I am using with the Extra Fields contribution). Downloading the complete CSV file to edit works fine, so does reimporting it with the one test product I have installed.

 

Now I have gone over the syntax in the file I am trying to import over and over in the last 2 hours, and I am going crazy. All I get when Import is this message:

I know perfectly well that you have to include a products_model, something which I have done for all the products in the file. But I still get the message, I don't know why.

 

I have included both the exported file and the file that I am trying to import, you can download and view the archive here:

http://home.online.no/~kjetil.v/import.zip

 

Can anyone see what I am doing wrong?

 

this happens when Easy populate reaches the last line to import. If you only have one product, it makes sense that it happens pretty quickly ;-)

[JangoF]

What do you mean, pixclinic? Did you read my post at all? :-"

[Guest]

What do you mean, pixclinic? Did you read my post at all? :-"

 

I thought you were testing with one product :-)

 

I opened your file and took a look. Try to work with tab delimited files instead of CSV

[JangoF]

Hehe, I just included that part so you would know that everything was going fine with importing/exporting with the test-product I already had in my store.

 

But anyway, I tested importing one product with tab delimited, and it worked fine. This seems very strange to me, as there should be practically no difference between dividers.

 

I would really like to use a comma delimited format, though. :(

[KPGroup]

Hello,

 

I am in the process of configuring EasyPopulate 2.76d.

 

I have made modifications to my PRODUCTS table (I have 5 new fields, QBI imported, dimensions (L, l, h), read_to_ship).

I also installed the "Fixed Price for Different Currencies" contribution, which means that the prices for the items are retreived from another table (FIXED_PRICES) instead of the PRODUCTS table.

 

Can anyone give me some indications of where I would have to make the modifications to handle this?

 

Thank you in advance for any tips you can give me!

 

Karim.

 

 

So not even a tip? :huh:

 

Apparently, the QBI field will just be ignored, so it's not a problem.

But what about the dimensions (for UPS shipping) and the prices in another table? Any tips on where to modify this?

Edited March 2, 2007 by KPGroup

[Guest]

So not even a tip? :huh:

 

Apparently, the QBI field will just be ignored, so it's not a problem.

But what about the dimensions (for UPS shipping) and the prices in another table? Any tips on where to modify this?

 

I posted a few pages ago about how to tweak easypopulate when adding fields to the main "products" table, search the thread (do a search for "products_weight" , that should show up in the results)

 

Regarding fields from an external table, that's a much harder task. Try to look where the manufacturers are processed with joins in order to be exported and imported, it should be a similar logic. Not granted if you are not an expert in myql queries though...

 

Hope this helps

[KPGroup]

I posted a few pages ago about how to tweak easypopulate when adding fields to the main "products" table, search the thread (do a search for "products_weight" , that should show up in the results)

 

Regarding fields from an external table, that's a much harder task. Try to look where the manufacturers are processed with joins in order to be exported and imported, it should be a similar logic. Not granted if you are not an expert in myql queries though...

 

Hope this helps

 

 

Unfortunately, I am not a MySQL expert ;)

 

Thanks for the tips Hugh,

 

Karim.

[JangoF]

Can anyone see what I am doing wrong?

I see now why it didn't work with a comma-delimited format. EP did not like that I had several commas in the description field. So I guess it's tab demilited all the way for me.:lol:

[surfalot]

[quote name='HiOctane' date='Mar 1 2007, 08:56 PM' post='1034560'

I have recently installed the Easy Populate module on our site and used it to populate the updates that I have been working on. The problem is that all the formating, image links and added little styles have been wiped out.

 

Does anyone know why this would be happening and how I can get around it, I thought that it may have been the fact that the " was causing issues so I added \" to see if that would work but no luck.

I'm no magician, so you need to provide some information with that request for help. THIS MEANS EVERYONE :lol:

PHP ver?

PHP globals (on/ofF)

MySQL ver?

EP vers?

EP settings?

Edited March 2, 2007 by surfalot

[Guest]

[quote name='HiOctane' date='Mar 1 2007, 08:56 PM' post='1034560'

I have recently installed the Easy Populate module on our site and used it to populate the updates that I have been working on. The problem is that all the formating, image links and added little styles have been wiped out.

 

Does anyone know why this would be happening and how I can get around it, I thought that it may have been the fact that the " was causing issues so I added \" to see if that would work but no luck.

 

I'm no magician, so you need to provide some information with that request for help. THIS MEANS EVERYONE :lol:

PHP ver?

PHP globals (on/ofF)

MySQL ver?

EP vers?

EP settings?

 

remove all quotes from your descriptions HTML tags

 

<img src="image.jpg">

 

must be turned into

 

<img src=image.jpg>

 

etc...

[surfalot]

Hehe, I just included that part so you would know that everything was going fine with importing/exporting with the test-product I already had in my store.

 

But anyway, I tested importing one product with tab delimited, and it worked fine. This seems very strange to me, as there should be practically no difference between dividers.

 

I would really like to use a comma delimited format, though. :(

yes, and I would like to know what problems you are having with using that method, since I wrote it.

[surfalot]

yes, and I would like to know what problems you are having with using that method, since I wrote it.

I don't understand what the problem was... you said "Downloading the complete CSV file to edit works fine, so does reimporting it with the one test product I have installed."

Edited March 2, 2007 by surfalot

[surfalot]

I see now why it didn't work with a comma-delimited format. EP did not like that I had several commas in the description field. So I guess it's tab demilited all the way for me.:lol:

that problem should have been handled with the excel safe output option. see the settins.

[surfalot]

remove all quotes from your descriptions HTML tags

 

<img src="image.jpg">

 

must be turned into

 

<img src=image.jpg>

 

etc...

I added the excel safe option in v2.76d to be able to handle that specifically. And other special character that have been plaguing this contribution. I'm trying to solve the problem, not just tell folks their data is wrong. Please work with me on this. If there is a problem with that code, I would like to work it out.