EasyPopulate 4.0 Support Thread

[chadderuski]

So I went through the first 15 pages of information and saw how you use a ^ between categories. Here is the thing; not knowing this until now, I used each of the V_categories_1-7 as different categories. Here is an example. Until now this has been working flawlessly. When I try to use the 7th column, it doesn't recognize it like the others were. Is there no other way?

Thanks for your help.

Are you SURE your using EP4?? Those additional category columns would go no where.... and all your products would be dumped into their main category...

[mrmanners]

Are you SURE your using EP4?? Those additional category columns would go no where.... and all your products would be dumped into their main category...

Yes sir. Check out the site. I built the entire database using csv and easy populate; categories and all. I tried using ^ but when I attempted to import, I got the max 32 character error. Is there a way around this?

[chadderuski]

Yes sir. Check out the site. I built the entire database using csv and easy populate; categories and all. I tried using ^ but when I attempted to import, I got the max 32 character error. Is there a way around this?

Yes, use your cpanel phpmyadmin to modify the database ... find the relevant field and increase to meet your needs.
This error arises when a single category name exceeds the maximum length.

You can see the other vital name lengths listed for your databases on the right side of the EP4 screen.

-chadd

[mrmanners]

Yes, use your cpanel phpmyadmin to modify the database ... find the relevant field and increase to meet your needs.
This error arises when a single category name exceeds the maximum length.

You can see the other vital name lengths listed for your databases on the right side of the EP4 screen.

-chadd

You are getting above my skill level now. I have not messed with the back end of the database in the cpanel at all.

[chadderuski]

You are getting above my skill level now. I have not messed with the back end of the database in the cpanel at all.

It's easy to do and has been discussed earlier in this thread. The length check is very important to the import so that's why I added it.

-chadd

[mrmanners]

It's easy to do and has been discussed earlier in this thread. The length check is very important to the import so that's why I added it.

-chadd

yeah so that pretty much didn't work. Found categories_name in the sql database. Increased it to 128 but it still won't access the naming convention. I also tried the ^. It created a whole different directory with ^ between the different words... Any ideas?

[chadderuski]

yeah so that pretty much didn't work. Found categories_name in the sql database. Increased it to 128 but it still won't access the naming convention. I also tried the ^. It created a whole different directory with ^ between the different words... Any ideas?

I replied to your PM... I really think you are using 1.2.5.4!

BTW: You ARE using Dr. Bytes MySQL Database Backup Tool? You should ALWAYS run a backup before working with EP4!

EP4 like most tools will do just what you tell it... it you give EP4 bad data (you made a mistake in your spreadsheet) EP4 will happily take that data and import it to your databases.

I've added some necessary data checking in some places that were vital like category names, etc.

I have many successful users with very large data sets using EP4... one user has over 900,000 records! On his dedicated server he can import about 50,000 in (if I remember right) about 12 seconds!

Hope this encourages you to keep working to learn EP4... BTW, if you didn't get your version from my github account I can't vouch for the code.

-chadd

https://github.com/chaddro/EasyPopulate-4.0