Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

Obviously, I need to know what the lines are terminated by and what it expects in the columns space. I don't, so, it's not importing.

 

 

Lines terminated by

 

 \r

Edited by pixclinic

Share this post


Link to post
Share on other sites

Hi all,

I'll admit right now I don't know much about this kind of stuff, but maybe there's an easy fix here.

 

My subcategory names are getting cut off at about 32 characters.. This causes products that should be in the same categories to each get thie own individual categories with a shortened name.

 

I know the easy workaround is to shorten the category names - but they are latin and I'd like to keep them if possible.

 

I'm using v2.76c

Share this post


Link to post
Share on other sites
Hi all,

I'll admit right now I don't know much about this kind of stuff, but maybe there's an easy fix here.

 

My subcategory names are getting cut off at about 32 characters.. This causes products that should be in the same categories to each get thie own individual categories with a shortened name.

 

I know the easy workaround is to shorten the category names - but they are latin and I'd like to keep them if possible.

 

I'm using v2.76c

 

Well, the mechanics of changing that are simple...run phpmyadmin and go to the categories_description table and change it from length 32 to whatever you want. HOWEVER, there could be fallout from that. For example, the info box that shows the categories, having very long category names might screw up the formatting. It should be easy to check though. Change the database to whatever length you want, create just one category name of that length, and then go to your home page, category page, product page, etc. and see what kind of damage it's done. If it's ugly, you'll then either have to fix the formatting, change the display of the category on those pages to a substring or a non-ugly length, or change the db back to length 32. That's my 2 cents anyway. Still waiting for anyone willing to chat with me about attributes...here or baalwww on YM. Thx.

Share this post


Link to post
Share on other sites
Well, the mechanics of changing that are simple...run phpmyadmin and go to the categories_description table and change it from length 32 to whatever you want.

 

 

Still waiting for anyone willing to chat with me about attributes...here or baalwww on YM. Thx.

 

Thanks, I will play with that for a bit...

 

I would chat with you, but I think I would just be wasting your time as I can't even get EP to work with SPPC....

Share this post


Link to post
Share on other sites
Ok, different method of attacking this until I can work with 2.9 long enough to get the feel for it.

 

I imported the text file of my inventory in Excel and saved it out as a CSV file as my MySQL database will import CSV files.

 

Now, I'm using phpMyAdmin and the CSV options are as follows;

 

CSV optionsReplace table data with file
Ignore duplicate rows
Fields terminated by ,
Fields enclosed by "
Fields escaped by \
Lines terminated by (box with Auto in it)
Column names (blank)

 

Obviously, I need to know what the lines are terminated by and what it expects in the columns space. I don't, so, it's not importing.

 

Any help here?

 

Thanks

 

Hello Druid

I had the same prob as you with that 1st line only...

Look at the page 205, right the first post and then 2nd post, that worked for me at 2nd attempt.

It was (and i quote ) :

 

array_walk($readed, 'walk');

 

replace with this

 

//array_walk($readed, 'walk');

foreach ($readed as $readed_record) {

walk($readed_record);

}

 

If it's NOT php5, don't change anything (end of quote)

 

Hope this help

 

reboot

Share this post


Link to post
Share on other sites
Hello Druid

I had the same prob as you with that 1st line only...

Look at the page 205, right the first post and then 2nd post, that worked for me at 2nd attempt.

It was (and i quote ) :

 

array_walk($readed, 'walk');

 

replace with this

 

//array_walk($readed, 'walk');

foreach ($readed as $readed_record) {

walk($readed_record);

}

 

If it's NOT php5, don't change anything (end of quote)

 

Hope this help

 

reboot

 

Reboot, THANK YOU!!!!

 

It worked perfectly and my inventory went in flawlessly. The version on my server WAS 5.x.x but it never even dawned on me to consider that as a cause of the problem and, quite frankly, 234 pages of problems and solutions would have been a bit much to wade through :-)

 

Pixclinic, thank YOU for your kind patience and all the invaluable help and insight you gave me into this diagnostic process.

 

I owe both of you a big one.

 

Next time I read about someone having this problem, I'll be able to help them. I try to help people avoid the problems I've gone through whenever I can.

 

Again, a big thank you to both of you

 

Richard


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Reboot, THANK YOU!!!!

 

It worked perfectly and my inventory went in flawlessly. The version on my server WAS 5.x.x but it never even dawned on me to consider that as a cause of the problem and, quite frankly, 234 pages of problems and solutions would have been a bit much to wade through :-)

 

Pixclinic, thank YOU for your kind patience and all the invaluable help and insight you gave me into this diagnostic process.

 

I owe both of you a big one.

 

Next time I read about someone having this problem, I'll be able to help them. I try to help people avoid the problems I've gone through whenever I can.

 

Again, a big thank you to both of you

 

Richard

 

I'm glad the problem has been solved, that was so frustrating!

I know what do do when my host will upgrade to php 5 (as it scares me, but i know this will happen one day!)

Share this post


Link to post
Share on other sites

Hello all

 

i would like to add this contrib to our site so i can add many products at once, however which one is the one to use, there are so many versions and bug fixes i am really confused. I have a clean install so to speak and want to be able to copy product attributes as well. Anyone advise, it will be a great help...

Share this post


Link to post
Share on other sites

Hi rustybolt

 

I personally went for the 2.90 a few days ago and all is working fine right now.

 

There were 2 dls that i did :

 

-the 2.90b

-the 2.90b fix ( i dont know if this is really necessary but just in case...)

 

reboot

Share this post


Link to post
Share on other sites
Hello all

 

i would like to add this contrib to our site so i can add many products at once, however which one is the one to use, there are so many versions and bug fixes i am really confused. I have a clean install so to speak and want to be able to copy product attributes as well. Anyone advise, it will be a great help...

 

I started with 2.9 and found that it had a lot of embedded contribs that I didn't really need and that getting rid of them would have been a rather lengthy process as there didn't seem to be an easy way to turn them off.

 

2.76c was reccomended as the best place to start and it lent itself my need to easily add fields to accomodate my Canada Post with Dimensions shipping module.

 

It's a clean load of 2.76 and contains the product attributes capability which is easy to turn on and off.

 

Look for

Easy Populate is EASY just start here FIRST !!!!

and that's the one. Using

New Fields with Easy Populate

and the latest fix there, I was able to set my inventory up the way I wanted it, rather than fitting it to someone else's idea.

 

After a week of it not working, Reboot and pixclinic came to the rescue by helping me troubleshoot it and supplying a fix for operating with the PHP5 version on my server.

 

So, although it took an hour to install, plug in the additional fields and get it all in working condition, it took a week to find out that a two line change was needed to work with PHP5 LOL

 

It comes down to what you NEED for your store, or what you MIGHT need in the future which version you start off with.


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites

Well, with nothing for anyone to work on ;) , I'll take one last try before I shoot myself.

 

Is EP meant to handle attributes by creating a few columns for EACH? If not, I really could use some help to find out why mine does. If so, how can one possibly have more than 256 / 4 attributes?

Share this post


Link to post
Share on other sites
Well, with nothing for anyone to work on ;) , I'll take one last try before I shoot myself.

 

Is EP meant to handle attributes by creating a few columns for EACH? If not, I really could use some help to find out why mine does. If so, how can one possibly have more than 256 / 4 attributes?

 

If that can make you feek better, I gave up with attributes in EP: I had a few products with attributes already loaded in my store, and when downloading the EP file, all products ended up being with the same attributes in their rows. So I turned that off and did that manually

Share this post


Link to post
Share on other sites
If that can make you feek better, I gave up with attributes in EP: I had a few products with attributes already loaded in my store, and when downloading the EP file, all products ended up being with the same attributes in their rows. So I turned that off and did that manually

 

Haaaaha. Well, I guess it probably wouldn't. Yes, I'm thinking I'll end up having to do the same. The problem is that among our items (1500+) will be some coats, jackets, sweaters, belts, etc., so manual is ugly.

 

I would have thought, being a software developer of old, that the way to do it, in the product/attribute export, would have been a row for each item/attribute, instead of trying to handle it with all product/attribute info in one row.

Share this post


Link to post
Share on other sites
Haaaaha. Well, I guess it probably wouldn't. Yes, I'm thinking I'll end up having to do the same. The problem is that among our items (1500+) will be some coats, jackets, sweaters, belts, etc., so manual is ugly.

 

I would have thought, being a software developer of old, that the way to do it, in the product/attribute export, would have been a row for each item/attribute, instead of trying to handle it with all product/attribute info in one row.

 

What version are you using?

 

I know when I didn't turn off the attribute download in 2.76c, I got extra columns with the attributes strung across them.

 

Since I don't need attributes, turning them off wasn't an issue.


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
thanks all, however 2.76c isnt there? i must be blind, anyone link for me?

 

Easy Populate is EASY just start here FIRST !!!!


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
thanks all, however 2.76c isnt there? i must be blind, anyone link for me?

 

Sorry, that didn't capture the link, so, the old-fashioned way.......

 

Ok, go to contributions and search for Easy Populate

 

Find the one that says Easy Populate & Products Attributes

 

Go down to the seventh (currently) entry that says Easy Populate is EASY just start here FIRST !!!!

 

It's a clean copy of 2.76c


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
Haaaaha. Well, I guess it probably wouldn't. Yes, I'm thinking I'll end up having to do the same. The problem is that among our items (1500+) will be some coats, jackets, sweaters, belts, etc., so manual is ugly.

 

I would have thought, being a software developer of old, that the way to do it, in the product/attribute export, would have been a row for each item/attribute, instead of trying to handle it with all product/attribute info in one row.

 

the way the system works, for adding products and attributes is a three step process, so understanding that is how you will understand how attributes and ep work together.

looking in the catalog/admin for attributes, you see you have to do it in steps, and thus ep has to do it the same way. kind of a pain tying it all together, if you click on the attribute you want in the ep file for your product, it makes the attribute active.

you can even setup drop down boxes, etc at the same time

Share this post


Link to post
Share on other sites
the way the system works, for adding products and attributes is a three step process, so understanding that is how you will understand how attributes and ep work together.

looking in the catalog/admin for attributes, you see you have to do it in steps, and thus ep has to do it the same way. kind of a pain tying it all together, if you click on the attribute you want in the ep file for your product, it makes the attribute active.

you can even setup drop down boxes, etc at the same time

What version are you using?

 

I know when I didn't turn off the attribute download in 2.76c, I got extra columns with the attributes strung across them.

 

I'm using 2.78. I understand how the attributes work in OsC. My problem is this. If EP were to populate a spreadsheet this way:

 

ITEM ATTRIB ATTRIB-VALUE ATTRIB-PRICE

00001 Size M

00001 Size L

00001 Color Red

00002

00003 Color Blue

 

Then no matter how many attributes are defined, everything will fit in the spreadsheet. What I get is

 

00001 Size M 0 L 0 XL 0 Red 0 Blue 0 Violet 0

 

and so on, with every possible attribute value listed, so that item 2's size attributes arent even listed as columns, because the complete list of possible colors across my 1500+ items, when changed into columns, 6 columns for each color (value, price, language), exceeds the 256 allowed columns, let alone the other attributes for other items such as sizes, shape, etc.

Share this post


Link to post
Share on other sites

thanks Druid, i have that version and its sort of working??

 

3 questions and hopefully 3 answers and i should be up and running!!

 

1. I have added the date as shown in PDF as 2006/11/08 in both dat added and date available fields but when looking at the product in admin it says date added and date available as the 20/11/2007, i have done this 3 times to make sure it didnt do anything wrong the 1st time but the with same outcome?

 

2. i have in my description a bit of html that dispays a small jpeg showing what colours are available ( <img src= blah, blah ) but when this is added to description in the description field and uploaded it doesnt display the pic, only a pic placement which i right clicked and in the address for the pic it has %22 in parts of it, what have i done wrong?

 

3. Lastly if i want to have new attibutes do i add these in admin first then download a blank file with these or if i create new ones in the spreadsheet then upload will they be automatically created for me.?

 

thanks everyone for the help..

Share this post


Link to post
Share on other sites
thanks Druid, i have that version and its sort of working??

 

3 questions and hopefully 3 answers and i should be up and running!!

 

1. I have added the date as shown in PDF as 2006/11/08 in both dat added and date available fields but when looking at the product in admin it says date added and date available as the 20/11/2007, i have done this 3 times to make sure it didnt do anything wrong the 1st time but the with same outcome?

 

2. i have in my description a bit of html that dispays a small jpeg showing what colours are available ( <img src= blah, blah ) but when this is added to description in the description field and uploaded it doesnt display the pic, only a pic placement which i right clicked and in the address for the pic it has %22 in parts of it, what have i done wrong?

 

3. Lastly if i want to have new attibutes do i add these in admin first then download a blank file with these or if i create new ones in the spreadsheet then upload will they be automatically created for me.?

 

thanks everyone for the help..

 

First, contrary to popular opinion, I'm not the resident expert on EP LOL. I've just had to screw around with it for so long to get it to do what I want it to do that I dream about the code.

 

1) This is strange as when something is added as a new product, it usually grabs the time and date from the server and uses that. Somewhere, it's getting the date of a little bit more than a year in the future. Also, the format of what you are putting in, and what you are getting out (yyyy/mm/dd vs dd/mm/yyyy) is different. Try putting the date added and date available in as 08/11/2006 and see what you get.

 

2) %22? Are you sure it isn't 20? 20 would indicate a space between the words in the image file name. What are you using to separate the words in the file name? It's always best if you just run all the words together in a filename in a situation like this as it saves a whole lot of grief.

 

3) Well, in theory, if the space exists in the spreadsheet to add another level of attributes, then inserting them into the spreadsheet would be the simplest approach, as the field would already exist in the item listing, just that it's unused. On this one, I'd wait to see what someone more knowledgable about attributes (I'm selling vintage computers and parts and they don't come in sizes or colours LOL) as I don't use them.

 

Hope some of this helps.

 

Richard


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites

Hi Guys

 

I have installed Easy Populate & Product Attributes v2.90b including the bug fix.

 

I have also installed the following contributions as required by 2.90b:

 

Separate Pricing Per Customer v4.1.5a

Quantity Price Breaks for Separate Pricing Per Customer v1.02

Product Extra Fields v2.0j

 

The above three contributions work just fine. I tested each of them out after installing all 3.

 

The problem i am having is that when i click on "Download .txt file with TAB delimited to edit ( Complete )" option it makes the txt file just fine but there are no columns of quantity/ price for the other 2 groups that i have. I have removed the "#" from easypopulate.php file as per instructions.

 

Also there is no columns for the extra fields either but when i click on "Download .txt file with TAB delimited to edit ( Products extra fields )" then only extra fields show up which is correct.

 

My understanding was when you click on complete it will do everything. IT will show seperate pricing columns per group and also extra fields.

 

I am more concerned about the sppc then extra fields. Has anyone got EP v2.90b to work with the above contributions.

 

Also i am using the latest version of osCommerce 2.2 Milestone 2 Update 060817

 

Any help would be much appreciated

Share this post


Link to post
Share on other sites

Mr Druid

 

i have sorted or nearly the problems with a little help from your post.

 

the html pic shouldnt have the http//www.etc instead it just starts with images/etc.jpg, i dont why this is or whats telling it where the image folder is as its only html and i presumed it needed the full address but hey its working!

 

and the date thing is everythime i put the date in excel it auto changes the correct way, ie 2007/11/08 is changed by excel to 08/11/2007 as soon as i press enter. thats why it looks a year in front. Where is the setting to turn this feature off in excel, its like an auto correct function

 

anyone help!!

Edited by rustybolt

Share this post


Link to post
Share on other sites

done it, with a little research in Office help, the date format is set in:

 

Start, control panel, regional and language settings, date can be changed from dd/mm/yyyy to yyyy/mm/dd, this updates Excel and now my contrib is working

 

i guess others will have to watch out for this as its a setting that needs to be changed in windows

 

thanks for the help guys

 

keep up the excellent work

 

Russel

Share this post


Link to post
Share on other sites

I've just added a piece of code to allow for deletion of products.

I've started a separate thread in contribution development.

Anyone willing to try / test this further, please use the separate thread.

http://forums.oscommerce.com/index.php?sho...mp;#entry967044

 

Thanks


KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

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

×