Jump to content



Latest News: (loading..)

* * * * * 12 votes

AJAX Attribute Manager support


  • Please log in to reply
1248 replies to this topic

#1   Nimmit

Nimmit
  • Members
  • 256 posts
  • Real Name:Sam West
  • Location:United Kingdom

Posted 21 February 2006 - 10:19 PM

AJAX Attribute Manager - v1 beta


What is this contribution??
The idea of this contribution is to make the administration of product options, option values and attributes much quicker and easier.

http://www.oscommerce.com/community/contributions,4063

[img]http://www.nimmit.co.uk/mainScreen.gif[/img]

http://www.oscommerce.com/community/contributions,4041

It uses a technology known as AJAX (Asynchronous Javascript And XML). This enables us to do is make page sub-reqests without refreshing a page.
In this case, it enables us to make a attribute manager that sits on the product addition page. From which, you can do everything (ish - see notes) that the product attributes page does but in a much more convenient and tidy way.
  • Installation takes 5 mins
  • Full Documentation in the package
  • Any future upgrades will require no editing
***** IMPORTANT *****
As this is a beta release. There will be updates to this contribution.
Please don't change anything and re-upload it the contribution section (even if it just a typo) untill it has been officialy released.
Please let us know of any bugs in the oscommerce forums - Thank you!

Any Comments welcomed

Nimmit  :thumbsup:

Edited by Johnson, 28 February 2006 - 12:36 PM.

Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D

#2   ugh

ugh
  • Members
  • 87 posts
  • Real Name:stacy
  • Location:Ladson, SC

Posted 22 February 2006 - 02:23 AM

Sounds like a great contribution!!  I am trying to use it, however, when uploading the files to my file manager, I get an error about the file name being too long.  So, I will try to figure out how I can accept longer file names and I will let you know how it works out!   :)

#3   Nimmit

Nimmit
  • Members
  • 256 posts
  • Real Name:Sam West
  • Location:United Kingdom

Posted 22 February 2006 - 02:40 AM

Whats your file manager? Just ftp it.
Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D

#4   ugh

ugh
  • Members
  • 87 posts
  • Real Name:stacy
  • Location:Ladson, SC

Posted 22 February 2006 - 03:11 AM

View PostNimmit, on Feb 21 2006, 09:40 PM, said:

Whats your file manager? Just ftp it.

Not sure what you mean - I use startlogic.  And yes, I just tried to upload using ftp and it doesn't work for me.   :blush:   I will keep trying though!

#5   Qihun

Qihun
  • Members
  • 561 posts
  • Real Name:miclosh
  • Location:planet Earth

Posted 22 February 2006 - 04:28 AM

Added this contribution on localhost shop and itis great
Thank you so much

I added this in two minutes

#6   chameleon

chameleon
  • Members
  • 44 posts
  • Real Name:Ingo

Posted 22 February 2006 - 09:57 AM

great contribution....now i can menage my attributs easy

one thing must be updated in next version:
the umlaut (ä,Ä, ö,Ö, ü,Ü, ß) is not shown in the drop down menue on categroies.php,
but its shown correct on the product.php
so its only a smal visual problem on the admin side ;-)

rest works great

#7   powerhouse

powerhouse
  • Members
  • 8 posts
  • Real Name:Jiri Farnik

Posted 22 February 2006 - 11:40 AM

Added this contribution on test shop with Admin Acces contrib and ther's problem.

AJAX Attribute Manager not working, Admin Acces hold it

#8   Nimmit

Nimmit
  • Members
  • 256 posts
  • Real Name:Sam West
  • Location:United Kingdom

Posted 22 February 2006 - 11:49 AM

View Postpowerhouse, on Feb 22 2006, 11:40 AM, said:

Added this contribution on test shop with Admin Acces contrib and ther's problem.

AJAX Attribute Manager not working, Admin Acces hold it


run this sql query, this will give access to the top administrator group (1). If you need more change the last value ('1') to include the other admin_groups_id eg '1,2,3'.

let me know if you have any problems
Sam


INSERT INTO `admin_files` VALUES ('', 'attributeManager.php', 0, 3, '1');

Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D

#9   powerhouse

powerhouse
  • Members
  • 8 posts
  • Real Name:Jiri Farnik

Posted 22 February 2006 - 02:15 PM

View PostNimmit, on Feb 22 2006, 02:49 PM, said:

run this sql query, this will give access to the top administrator group (1). If you need more change the last value ('1') to include the other admin_groups_id eg '1,2,3'.

let me know if you have any problems
Sam
INSERT INTO `admin_files` VALUES ('', 'attributeManager.php', 0, 3, '1');

Sam,

Thaks for your support now's it okay,

are there any support for multilanguages ... ?

Regards,
Jiri

#10   Nimmit

Nimmit
  • Members
  • 256 posts
  • Real Name:Sam West
  • Location:United Kingdom

Posted 22 February 2006 - 09:59 PM

View Postpowerhouse, on Feb 22 2006, 02:15 PM, said:

are there any support for multilanguages ... ?

Not in this release, perhaps in the next.

Edited by Nimmit, 22 February 2006 - 10:00 PM.

Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D

#11   ugh

ugh
  • Members
  • 87 posts
  • Real Name:stacy
  • Location:Ladson, SC

Posted 23 February 2006 - 04:07 AM

View Postugh, on Feb 21 2006, 10:11 PM, said:

Not sure what you mean - I use startlogic.  And yes, I just tried to upload using ftp and it doesn't work for me.   :blush:   I will keep trying though!


I figured out the whole ftp thing - duh.  Anyway, I got your contribution working and so far, it is great!  It is really making my life easier at this moment and it was super easy to install.  Thanks! :D

#12   kev2me

kev2me
  • Members
  • 9 posts
  • Real Name:Kevin
  • Gender:Male
  • Location:Columbus, Ohio

Posted 23 February 2006 - 02:09 PM

Great contribution, this will save so many headaches.

Thanks a lot!  :thumbsup:

#13   dynamoeffects

dynamoeffects
  • Members
  • 1,646 posts
  • Real Name:Brian Burton
  • Gender:Male
  • Location:Italy

Posted 23 February 2006 - 03:11 PM

Wow, very sexy.  I was just about to start redoing the attribute manager myself because it is such a pain to use, but you've created a great starting point.  Nice work.
Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

#14   dynamoeffects

dynamoeffects
  • Members
  • 1,646 posts
  • Real Name:Brian Burton
  • Gender:Male
  • Location:Italy

Posted 23 February 2006 - 04:35 PM

Woo, found your first bug.  If you try to add an option with a single quote ( ' ), it'll add a backslash.  For instance if you're trying to add a length: 10', 20', etc will all show up as 10\', 20\'.

To fix, open this file:

attributeManager/classes/DB.class.php

and change:

function input($str) {
return tep_db_input($str);
}

to:

function input($str) {
return tep_db_prepare_input($str);
}


Very slick contribution, nice work!
Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

#15   Mom2B

Mom2B
  • Members
  • 1 posts
  • Real Name:Marco

Posted 23 February 2006 - 09:03 PM

I love the contribution, saves a lot of work in my fashion store, however 1 Bug...

Our store uses multiple languages. Options are created in my language used to update the store (NL). New created options are not shown in En and Ge interface and it is not possible adding them in the Product attributes, they dont show up! Now I have a problem...


Marco
www.baby-on-board.nl

#16   Nimmit

Nimmit
  • Members
  • 256 posts
  • Real Name:Sam West
  • Location:United Kingdom

Posted 23 February 2006 - 09:58 PM

View Postdynamoeffects, on Feb 23 2006, 04:35 PM, said:

Woo, found your first bug.  If you try to add an option with a single quote ( ' ), it'll add a backslash.  For instance if you're trying to add a length: 10', 20', etc will all show up as 10\', 20\'.

To fix, open this file:

attributeManager/classes/DB.class.php

and change:

function input($str) {
return tep_db_input($str);
}

to:

function input($str) {
return tep_db_prepare_input($str);
}
Very slick contribution, nice work!


Hi thanks for this, It will be fixed in the next release
Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D

#17   Nimmit

Nimmit
  • Members
  • 256 posts
  • Real Name:Sam West
  • Location:United Kingdom

Posted 23 February 2006 - 10:04 PM

View PostMom2B, on Feb 23 2006, 09:03 PM, said:

I love the contribution, saves a lot of work in my fashion store, however 1 Bug...

Our store uses multiple languages. Options are created in my language used to update the store (NL). New created options are not shown in En and Ge interface and it is not possible adding them in the Product attributes, they dont show up! Now I have a problem...
Marco
www.baby-on-board.nl

Sorry to hear that, this beta release is not multiligual.
Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D

#18   tbruelan

tbruelan
  • Members
  • 93 posts
  • Real Name:TO Brueland
  • Location:Norway

Posted 23 February 2006 - 11:53 PM

Hmm, where did I go wrong...?

I get the message:
You cant access this page directly
.. on the new product page.

I have Access with Level Account installed.

Btw, I have already changed:

function input($str) {
return tep_db_input($str);
}

to:

function input($str) {
return tep_db_prepare_input($str);
}

#19   Nimmit

Nimmit
  • Members
  • 256 posts
  • Real Name:Sam West
  • Location:United Kingdom

Posted 24 February 2006 - 12:26 AM

View Posttbruelan, on Feb 23 2006, 11:53 PM, said:

Hmm, where did I go wrong...?

I get the message:
You cant access this page directly
.. on the new product page.

Strange...  :blink:

There is a session variable that is set on the products page which is then confirmed in the main script. I'll pm you because i have an idea what it is but i want to be sure before i post why in the forum.
Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D

#20   Nimmit

Nimmit
  • Members
  • 256 posts
  • Real Name:Sam West
  • Location:United Kingdom

Posted 24 February 2006 - 01:42 AM

Bug fix release
AJAX Attribute Manager - v1.1 beta

* install instructions updated
* Slash problem fixed - thanks dynamoeffects
* Simplification of stop direct access logic - thanks tbruelan
* rework of core page actions
* moved configuration into its own class to aid with future changes
* fixed session variable not being reset when new product addition is canceled
Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D