If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Started by langer on 9 May 2006, 9:44 PM · Views: 1,303,107

Results 161 to 180 of 3,834
7 Aug 2006, 11:04 PM
#161
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Easy Populate 1.2.5.4 support

that's WAY beyond the scope of easy populate.

Setting all the extra details for music products is a ton of extra coding and debugging to do.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 12:11 AM
#162
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

Hi all.

In post #138 I asked if current EP v.1254 has known conflicts with any other mods. Also on post #132 I asked if EP v.1254 had any issues running on ZC 1.3.0.2. But no responses to either post.

Anyhow I thoroughly read through this thread and the archived EP support thread, and the readme and install docs and wiki before installing. And then went ahead and downloaded EP v.1254 from modhole site. Installed without a hitch, and without conflicting with the other mods I have installed (as far as I can observe with very limited testing).

In EP I downloaded "Complete tab-delimited .txt file to edit (Attributes Not Included)" and opened in EXcel. The file containd my two test products. Then for testing purposes I added one product and saved in tab delimited txt format.

But before I upload and possibly make a mess of things, two questions...

In the "v_date_added" field column the entries in that column show in Excel with a format of
7/28/2006 1:44:10 AM (excel cell formatting option shows m/d/yyyy h:mm

Whereas if I open the file in a text editor I see a formatting of 2006-07-28 01:44:10

So I'm not clear on the date conversion process supported by EP and support for timestamps within the "v_date_added" field.

In Admin > Configuration > Easy Populate I see six different date formats to choose from, neither of which shows m/d/yyyy as an option or which suggests including a timestamp.

Question 1: So on upload does EP auto convert Excel m/d/yyyy to m-d-y format as I have set in EP "Upload File Date Format"

In the same admin menu I see a "Default Raw Time" setting with default value of "09:00:00".

Question 2: So does this mean that the time stamps in the "v_date_added" field shown in the downloaded file are ok as is, and when editing new products in the spreadsheet, if I do not enter a timestamp next to the date, then EP will auto append "09:00:00" to the "v_date_added" field?

Thanks for any pointers.

BTW I see the new Advanced version was just released today. Congratulations! Is there a side-by-side feature comparison table available? Will an updated "non-advanced" version be available soon to try out? Thanks again.

Woody

8 Aug 2006, 2:07 AM
#163
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Easy Populate 1.2.5.4 support

  1. EP auto-detects the date-separator and uses what you provide .... 3 valid choices are: - / .

  2. I believe this means that if no time is provided for "specials" start/end then it will use the time supplied in the configuration setting.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 3:28 AM
#164
lhhgbh avatar

lhhgbh

Zen Follower

Join Date:
Mar 2006
Posts:
177
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Any clue how to help me out from my post a few back? I cant seem to get my products to show up... I included what message Im getting when I add to DB, but nothing shows up. thanks!

Funny & Original T Shirts
https://www.such-a-tees.com
Flag Pride T Shirts
https://www.flagpridet-shirts.com

8 Aug 2006, 4:03 AM
#165
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Easy Populate 1.2.5.4 support

Sorry - I don't follow exactly what you've done.

If I understand properly, you have:

  • a v_products_model column (which you don't want to have, but require for EP)
  • a v_products_image column (which you hope to use to upload images with.. but cannot)
  • a sample spreadsheet with columns you don't want
  • and some errors

Where I would start:

  • delete the columns you don't have any data for ... except v_products_model (and keep the EOREOR column)
  • copy your v_products_name contents to the v_products_model column ... keeping the v_products_model title on the column
  • upload and import/insert

Then manually upload the images via FTP to the /images folder. You could upload them before importing if you prefer.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 4:14 AM
#166
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

lhhgbh:

I still cant get anything to show up... I changed the tab delimited file that the model column had two different made up names "suck1, suck2 as you can see below.. Everything seems to work fine, but no product showing up in the store.. Im using the import from temp dir. option to put them into the DB.. I use drag and drop from my hard drive to the ftp folder to upload the updated sheet.. So what have I missed?

Filename: 1st.txt

NEW PRODUCT! - Model: Suck1 | http://img | I Suck at | %0d%0a%0d% | | 9.99 | | | 8/6/2006 0 | 1000 | | I Suck/Rul | | | | | | | | 0 |
NEW PRODUCT! - Model: Suck2 | http://img | I Suck at | %0d%0a%0d% | | 9.99 | | | 8/6/2006 0 | 1000 | | I Suck/Rul | | | | | | | | 0 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | |
Upload Complete
Have you looked in the product catalog to see if they are there? It looks like you have set status = 0 (inactive) so they should be uploaded, but not visible. Status = 1 will make them visible.

8 Aug 2006, 4:21 AM
#167
lhhgbh avatar

lhhgbh

Zen Follower

Join Date:
Mar 2006
Posts:
177
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I had deleted the columns that I didnt have any data for before and that didnt work.. I kept the model column even though I didnt need it, that didnt work.. I put something generic in the model column, that didnt work.. its not that I cant get the images to show up.. I cant get anything at all to show up.. Here are the columns I use..."products image, product name 1, product description 1, products price, date added, qty, category name 1, category name 2, i use status, but have it set at 0 (not sure what the #'s mean), EOREOR

i dont use the following: products url 1, products weight, date available, manufacturer, category name 3, name 4, name 5, name 6, name 7, tax class

Are there certain columns that have to have something entered and I have left them off? Also for my description I use HTML... Thanks for any insight...

Funny & Original T Shirts
https://www.such-a-tees.com
Flag Pride T Shirts
https://www.flagpridet-shirts.com

8 Aug 2006, 4:23 AM
#169
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

Woodymon:

In the "v_date_added" field column the entries in that column show in Excel with a format of 7/28/2006 1:44:10 AM (excel cell formatting option shows m/d/yyyy h:mm, whereas if I open the file in a text editor I see a formatting of 2006-07-28 01:44:10

So I'm not clear on the date conversion process supported by EP and support for timestamps within the "v_date_added" field.

In Admin > Configuration > Easy Populate I see six different date formats to choose from, neither of which shows m/d/yyyy as an option or which suggests including a timestamp.

Question 1: So on upload does EP auto convert Excel m/d/yyyy to m-d-y format as I have set in EP "Upload File Date Format"

In the same admin menu I see a "Default Raw Time" setting with default value of "09:00:00".

Question 2: So does this mean that the time stamps in the "v_date_added" field shown in the downloaded file are ok as is, and when editing new products in the spreadsheet, if I do not enter a timestamp next to the date, then EP will auto append "09:00:00" to the "v_date_added" field?
Woody
Maybe I can add to this. Spreadsheet apps often show the time in their own format, even though it is raw time in the underlying file, hence the discrepancy. Saving in raw time is best, as it is the fastest to process, however spreadsheet apps can be uncooperative in this regard. The date format in config is for when dates that are not raw, how should Easy Populate handle these? This depends on your locale usually (in UK it is dd/mm/yy and in US it is mm/dd/yy) - is is the order only that is of interest - the rest can be figured out by ep.

The default raw time is the time appended to the current date where date fileds are blank. It is useful if you want to prevent a special from starting before a particular time for eg.

8 Aug 2006, 4:28 AM
#170
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Easy Populate 1.2.5.4 support

Here are the columns I use..."products image, product name 1, product description 1, products price, date added, qty, category name 1, category name 2, i use status, but have it set at 0 (not sure what the #'s mean), EOREOR

You said you used "something generic" for products_model. You can do that ... as long as it is unique per product ... that's why I suggested copying the products_name for it.

If you don't use the v_ prefixes then you will get no data loaded

products_status: 0=disabled, 1=enabled. If disabled, will not be visible to shoppers, but can be edited in Admin

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 4:32 AM
#171
lhhgbh avatar

lhhgbh

Zen Follower

Join Date:
Mar 2006
Posts:
177
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Okay the 2 tests finally showed up after changing the numbers to 1 so I guess what ever i changed beforehand I forgot to test it with the 1 so now I finally have some products showing up.. Now something new has happened.. The item has this: %0d%0a %0d%0a
%0d%0a
%0d%0a
showing up all through the page and its creating spaces through the html and screwing the page all up.. This same codes with all of my other listings that I have done manually... You can go to the absurdatees link below and click on the Suck/Rule at category to see it for yourself.. Its all out of wack! Im excited that they have made it though.. Now to fine-tune it a bit...

Funny & Original T Shirts
https://www.such-a-tees.com
Flag Pride T Shirts
https://www.flagpridet-shirts.com

8 Aug 2006, 5:13 AM
#172
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Easy Populate 1.2.5.4 support

%0d%0a .... those look like they might be carriage returns translated poorly from your text file....

You were uploading by FTP.... did you upload as ascii or binary?
Perhaps try uploading using the easypopulate "upload" option.... click Browse and select the file and then click Insert into db.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 6:15 AM
#173
lhhgbh avatar

lhhgbh

Zen Follower

Join Date:
Mar 2006
Posts:
177
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

That worked out good.. My html wont exactly work because I was taking the HTML from my Turbo Lister CSV and of course that code has links to Ebay and I dont want those, but i did actually get it to work and thats all I needed.. So once I put my images into the images folder everything should be okay from there... I really appreciate the help and Im sure I will be back here for questions on my next mod..

Funny & Original T Shirts
https://www.such-a-tees.com
Flag Pride T Shirts
https://www.flagpridet-shirts.com

8 Aug 2006, 10:49 AM
#174
thespunkylobster avatar

thespunkylobster

New Zenner

Join Date:
Sep 2005
Posts:
23
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

DrByte:

that's WAY beyond the scope of easy populate.

Setting all the extra details for music products is a ton of extra coding and debugging to do.

Fair enough :) Guess I have to make a choice whether to manually enter all as music products or skip that and just go with general. Hmmmm.

Anyway, on experimenting, I'm coming up with a couple of problems.

I get the error:

SKIPPED! - Model: SPV07676642 - No category provided for this new product

There is a category specified in my list.

And also:

SKIPPED! - Model: SPV09274492 - Category name(s) too long (max. 32)

When the category is B/Bon Appetite which is obviously less than 32 characters.

Any ideas?

8 Aug 2006, 12:16 PM
#175
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

TheSpunkyLobster:

I get the error: SKIPPED! - Model: SPV07676642 - No category provided for this new product

There is a category specified in my list.
is there a legitimate path though? Ie. v_category_1 1st, etc?
TheSpunkyLobster:

And also:

SKIPPED! - Model: SPV09274492 - Category name(s) too long (max. 32)

When the category is B/Bon Appetite which is obviously less than 32 characters.

Any ideas?
None... Can you post a few lines from the upload file into some CODE tags here?

8 Aug 2006, 12:39 PM
#176
thespunkylobster avatar

thespunkylobster

New Zenner

Join Date:
Sep 2005
Posts:
23
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Sure thing :)

"SPV08574072"	"shadowzone.jpg"	"Axel Rudi Pell - Shadowzone"	"2002 album from Germany's premier heavy metal guitarist.  <P>  Track Listing:<br>  1. The Curse Of The Chains (Intro)<br>  2. Edge Of The World<br>  3. Coming Home<br>  4. Live For The King<br>  5. Follow The Sign<br>  6. Heartbreaker<br>  7. Saint Of Fools<br>  8. Time Of The Truth<br>  9. All The Rest Of My Life<br>  10. Under The Gun<br>"					12.99						"A"	"Axel Rudi Pell"						"--none--"	1	"EOREOR"
"SPV07676642"	"theballads.jpg"	"Axel Rudi Pell - The Ballads"	"Track Listing:<br>  1.	You Want Love<br>  		2.	Forever Young<br>  		3.	Dreams Of Passion<br>  		4.	Your Life (Not Close Enough To Paradise)<br>  		5.	Tearin' Out My Heart<br>  		6.	When A Blind Man Cries<br>  		7.	Broken Heart - (demo version)<br>  		8.	Open Doors (Part 2) The Journey<br>  		9.	Falling Tears<br>  		10.	Broken Heart - (guitar version)<br>"					9.99						"A"	"Axel Rudi Pell"						"--none--"	1	"EOREOR"
"SPV08518672"	"balladsii.jpg"	"Axel Rudi Pell - The Ballads II"	"Track Listing:<br>  1.	Come Back To Me<br>  		2.	Broken Heart<br>  		3.	Clown Is Dead, The<br>  		4.	Oceans Of Time<br>  		5.	I Believe In You<br>  		6.	Ashes From The Oath<br>  		7.	Silent Angel (Guitar Version)<br>  		8.	Eyes Of The Lost, The<br>  		9.	Innocent Child<br>  		10.	Silent Angel<br>  		11.	Hey Joe<br>"					12.99						"A"	"Axel Rudi Pell"						"--none--"	1	"EOREOR"
"SPV08569962"	"balladsiii.jpg"	"Axel Rudi Pell - The Ballads III"	"Riding on the success of ""The Ballads” I + II German guitar hero Axel Rudi Pell shows his softer side once again.  <P>  But this is not only a compilation of his best and most recent ballads, it also includes 3 newly recorded tracks, including an acoustic version of the sleeper hit ""Forever Angel"" and a cover of RAINBOW’s ""The Temple Of The King"".   <P>  Since his 1989 solo debut WILD OBSESSION and no later than his breakthrough in 1991 with NASTY REPUTATION, Axel has been a firm fixture in the Melodic Hard Rock scene and these songs show why.  <P>  Track Listing:<br>  1. Don’t Say Goodbye <br>  2. Forever Angel (Acoustic) <br>  3. The Temple Of The King <br>  4. Heartbreaker <br>  5. The Line <br>  6. Sea Of Evil <br>  7. The Curse Of The Chain <br>  8. All The Rest Of My Life <br>  9. Forever Angel <br>  10. The Temple Of The Holy<br>  11. Under The Gun<br>"					12.99						"A"	"Axel Rudi Pell"						"--none--"	1	"EOREOR"

The two middle lines bring up the error no category, while the two either side import fine.

"SPV08572432"	"firesatmidnight.jpg"	"Blackmore's Night - Fires at Midnight"	"This is an Enhanced CD which contains regular audio tracks and multimedia computer files. The Enhanced portion includes a music video for ""The Times They Are A Changin'  <P>  Track Listing:<br>  1. Written In The Stars<br>  2. The Times They Are A-Changin'<br>  3. I Still Remember<br>  4. Home Again<br>  5. Crowning Of The King<br>  6. Fayre Thee Well<br>  7. Fires At Midnight<br>  8. Hanging Tree<br>  9. The Storm<br>  10. Mid-Winter's Night<br>  11. All Because Of You<br>  12. Waiting Just For You<br>  13. Praetorius (Courante)<br>  14. Benzai-Ten<br>  15. Sake Of Son<br>  16. Village On The Sand<br>  17. Again Someday<br>"					9.99						"B"	"Blackmore's Night"						"--none--"	1	"EOREOR"
"SPV08574992"	"ghostofarose.jpg"	"Blackmore's Night - Ghost of a Rose"	"On Ghost Of A Rose, Blackmore and Candice Night present a fascinating combination of rock music, folk and melodies from the 16th century that is interesting in every note. Blackmore sees his songs as an homage to renaissance music, and his band transpose the multi-faceted music of the Middle Ages, which blends romanticism and mysticism, passion and enthusiasm, into their very own sound with acoustic and electric guitars, strings, renaissance instruments like hurdy-gurdy and bagpipe and Candice Night's beguiling voice. Features 16 tracks including a bonus video track of 'Way To Mandalay'.  <P>  Track Listing:<br>  1. Way To Mandalay 	<br>  2. 3 Black Crows <br>  3. Diamonds And Rust 	<br>  4. Cartouche 	<br>  5. Queen For A Day (Part 1) 	<br>  6. Queen For A Day (Part 2) (Instrumental) 	<br>  7. Ivory Tower <br>  8. Nur Eine Minute (Instrumental)<br>  9. Ghost Of A Rose 	<br>  10. Mr. Peagram's Morris And Sword (Instrumental) <br>  11. Loreley 	<br>  12. Where Are We Going From Here 	<br>  13. Rainbow Blues 	<br>  14. All For One 	<br>  15. Dandelion Wine<br>"					11.99						"B"	"Blackmore's Night"						"--none--"	1	"EOREOR"
"SPV09274492"	"pasttimeswithgoodcompany.jpg"	"Blackmore's Night - Past Times With Good Company 2CD"	"The first live album for the Renaissance influenced rock act featuring legendary guitarist Ritchie Blackmore, recorded in Groningen, Holland & New York in 2002 from the Fires At Midnight Tour.  <P>  Track Listing:<p>  Disc 1:<br> 	  1. Shadow Of The Moon 	<br>  2. Play Minstrel Play 	<br>  3. Minstrel Hall 	<br>  4. Past Time With Good Company 	<br>  5. Fires At Midnight 	<br>  6. Under A Violet Moon 	<br>  7. Soldier Of Fortune<p>  Disc 2: 	<br>  1. 16th Century Greensleeves 	<br>  2. Beyond The Sunset 	<br>  3. Morning Star 	<br>  4. Home Again 	<br>  5. Renaissance Faire 	<br>  6. I Still Remember 	<br>  7. Durch Den Wald Zum Bachhaus 	<br>  8. Writing On The Wall 	<br>"					15.99						"B"	"Blackmore's Night"						"--none--"	1	"EOREOR"
"SPV99702"	"BlackmoresNight-TheVillageLaterne.jpg"	"Blackmore's Night - The Village Lanterne"	"With his band, Blackmore´s Night, featuring his partner, the vocalist Candice Night, Blackmore has certainly not broken with his previous creative forms of expression. Quite the opposite: the songs on his current album, The Village Lanterne, document unmistakably that there’s still the rock musician inside him.  <P>  Blackmore has not remained static in his development, he has allowed his penchant for medieval music, which already shone through on many of his hard rock compositions, to culminate in his very own, unique style of music. On The Village Lanterne, Blackmore´s Night combine great vocal melodies, seemingly archaic instrumentations and virtuoso guitar parts with lyrics that allow the listener to dive deep into a mysterious, romantic world.  <P>  Track Listing:<br>    1. 25 Years<br>  2. Village Lanterne<br>  3. I Guess It Doesn't Matter<br>  4. The Messenger<br>  5. World of Stone<br>  6. Faerie Queen<br>  7. St. Teresa<br>  8. Village Dance<br>  9. Mond Tanz / Child in Time<br>  10. Streets of London<br>  11. Just Call My Name<br>  12. Olde Mill Inn<br>  13. Windmills<br>  14. Street of Dreams<br>"					11.99						"B"	"Blackmore's Night"						"--none--"	1	"EOREOR"

Again here, the first one imports fine, the second says no cat specified, and the third says cat name too long, while the 4th imports fine.

Hope that's enough for now :) I can post the whole file if needed, but thought adding these around the errors would be most use.

8 Aug 2006, 2:04 PM
#177
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

you have tabs in your description fields..

8 Aug 2006, 2:27 PM
#178
thespunkylobster avatar

thespunkylobster

New Zenner

Join Date:
Sep 2005
Posts:
23
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Ok thanks for pointing that out :)

I've cut/pasted from an catalog export from litecommerce. What would be the easiest way to remove these tabs from the csv without manually having to re-enter all of the data?

8 Aug 2006, 4:08 PM
#179
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

TheSpunkyLobster:

Ok thanks for pointing that out :)

I've cut/pasted from an catalog export from litecommerce. What would be the easiest way to remove these tabs from the csv without manually having to re-enter all of the data?
If you are able to open it with a spreadsheet app, you may be able to copy each column and paste special (if it makes a difference - not sure). Or, you may be able to do a search & replace.

8 Aug 2006, 4:53 PM
#180
thespunkylobster avatar

thespunkylobster

New Zenner

Join Date:
Sep 2005
Posts:
23
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Thanks for the help so far :)

The paste/special solved the first two.

Doesn't seem to work on the second block though, and i still have the same problem with the category name too long error.