Admin Notes 2.2

[rikpotts]

Can someone help me install this contribution please....

 

The sql file apparently needs editting before inserting but these are the edit instructions.......

 

 

####################################################################
# !!! YOU SHOULD MODIFY THE BELOW SECTION TO FIT YOUR NEEDS !!!
####################################################################
# What ever catagory you would like to add or have that your notes 
# may fall under, add them in here. Just block-copy one of the lines 
# below and change the name at the end. Don't make any other changes.
# For example: change 'Features' to 'Personal' and nothing else. This 
# will give you the Personal catagory like this...
#
# Change this:
# INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Features', 1);
#
# Into this:
# INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Personal', 1);
#
# You may have as many lines below as your wish
####################################################################

#
# Dumping data for table `admin_notes_type`
#

INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Administration', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Configuration', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Contributions', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Customers', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Discounts', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Features', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'General Notes', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Guests', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Payments', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Products', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Sales', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Shipping', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Suppliers', 1);
INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Other', 1);

#
# Dumping data for table `customers_notes`
#

ALTER TABLE customers ADD customers_notes LONGTEXT NOT NULL;

 

I dont understand any of it!

Its not so much the editting I cant do, I dont understand the text.......

 

What ever catagory you would like to add or have that your notes

may fall under, add them in here. Just block-copy one of the lines

below and change the name at the end. Don't make any other changes.

for example: change 'Features' to 'Personal' and nothing else. This

will give you the Personal catagory like this...

Edited December 25, 2005 by rikpotts

[Wendy James]

Basically it is just saying if you want to remove some of the categories they have already set up then you can remove them from the sql. Or, if you want ones that are not listed there, you can add them in.

 

Like you could add something like this.

INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Phone Sales', 1);

 

or say you don't want notes about Guests, Payments, or Products you can remove the lines they are on.

INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Guests', 1);

INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Payments', 1);

INSERT INTO admin_notes_type (type_id, type_name, status) VALUES (1, 'Products', 1);

Edited December 25, 2005 by wendyjames

[rikpotts]

Many Thanks Wendy!

 

Quite simple really! Ive got it installed and have added notes already!

 

Cheers