data.sql

jsp程序开发系统

INSERT INTO tech_internal_help_entry VALUES (115,13,'<P>Specify whether you wish to receive notifications for new tickets as they are submitted. For each event, you can be notified via regular e-mail, or via SMS, or both.</P>\r\n\r\n<P><U>All Tickets</U> - For \"New Tickets\", selecting one or both of these options will send you notifications whenever a ticket is submitted to DeskPRO, regardless of category, priority, default owner, etc. For \"Ticket Replies\", selecting one or both of these options will send you notifications whenever a reply is submitted to a ticket, regardless of who owns it.</P>\r\n\r\n<P><U>Tickets You Own</U> - Selecting one or both of these options will send you notifications whenever a ticket you own is replied to.</P>',0,'E-mail: Ticket Notifications');
INSERT INTO tech_internal_help_entry VALUES (116,13,'<P>Instead of being notified for all new tickets and replies, you can individually select your desired notification (if any) for each category and priority in DeskPRO. For any category or priority here where you select one or both options for \"New Tickets\", tickets created in the selected categories and/or priorities will generate a notification. For \"Ticket Replies\", any reply to any ticket in the specified categories or priorities will generate a notification.</P>\r\n\r\n<P>In all cases, DeskPRO will first check that you have permission to view the ticket before notifying you about it. Otherwise, ownership of tickets is not considered for notifications; you\'ll be notified for all tickets you\'ve selected here that you have permission to view, whether you own them or not.</P>',0,'E-mail: Category and Priority Notifications');
INSERT INTO tech_internal_help_entry VALUES (117,13,'<P>You can customize which fields are displayed in search results generated from your searches. Select among these fields to display when your searches return results:</P>\r\n\r\n<P><U>Category</U> and <U>Priority</U> - Ticket category and priority.</P>\r\n\r\n<P><U>User/Email</U> - Username and e-mail address of ticket submitter.</P>\r\n\r\n<P><U>Tech Owner</U> - Username of the technician who owns the ticket, if any.</P>\r\n\r\n<P><U>Time awaiting a tech reply</U> - Amount of time the ticket has been awaiting a reply from a technician.</P>\r\n\r\n<P><U>Time since ticket created</U> - Amount of time the ticket has been opened.</P>\r\n\r\n<P><U>Show Ticket Actions</U> - Selecting this option will display a menu of ticket actions available directly from the search results page.</P>\r\n\r\n<P><U>Other Fields</U> - Other fields may be listed here as well depending on the site configuration (as defined by your administrator).</P>\r\n\r\n<P><U>Unassign myself from all my tickets</U> - This automatically removes your ownership of <I>all</I> tickets assigned to you, opened or closed.</P>\r\n\r\n<P><U>Unassign myself from my open tickets</U> - This automatically removes your ownership of all <I>open</I> tickets assigned to you. This can be useful for vacations and leaves of absence.</P>',0,'Ticket Display');
INSERT INTO tech_internal_help_entry VALUES (118,15,'<P>DeskPRO permits you to save useful resources (like bookmarks, notes, and files) directly in your account. You can organize each of these resources into folders as well.</P>\r\n\r\n<P>Use the \"Folders\" link to manage the folders you store different resources in. You can also use this link to manage folders to save tickets into.</P>\r\n',0,'Overview');
INSERT INTO tech_internal_help_entry VALUES (119,15,'<P>You can save as many URL bookmarks as needed in the Bookmarks page. Existing bookmarks can be deleted or moved in bulk (or individually) by checking the boxes next to each one, then selecting the desired operation. If you\'re moving bookmarks to another category, select that category first. Select \"Process\" to process each selected bookmark.</P>\r\n\r\n<P>To add a new bookmark, select the \"Add Bookmarks\" link. Enter up to ten bookmarks here and submit the form to add them. Repeat the process if necessary to add more bookmarks.</P>\r\n\r\n<P>To edit the folders you can file bookmarks into, select the \"Edit Folders\" link.</P>\r\n',0,'Bookmarks');
INSERT INTO tech_internal_help_entry VALUES (120,15,'<P>Notes can be used as quick reminders, references, instructions, and more. Existing notes can be deleted or moved in bulk (or individually) by checking the boxes next to each one, then selecting the desired operation. If you\'re moving notes to another category. select it first. Select \"Process\" to process each selected note.</P>\r\n\r\n<P>To add a new note, select the \"Add Notes\" link and fill in the form. To edit the folders you can file bookmarks into, select the \"Edit Folders\" link.</P>\r\n',0,'Notes');
INSERT INTO tech_internal_help_entry VALUES (121,15,'<P>Files can be uploaded directly into your account for later use. Existing files can be deleted or moved in bulk (or individually) by checking the boxes next to each one, then selecting the desired operation. If you\'re moving files to another category. select it first. Select \"Process\" to process each selected file.</P>\r\n\r\n<P>To add a new file, select the \"Add Attachments\" link and fill in the form. To edit the folders you can file attachments into, select the \"Edit Folders\" link.</P>\r\n',0,'Files');
INSERT INTO tech_internal_help_entry VALUES (122,15,'<P>Folders are used to organize your stored resources and saved tickets. To add, delete, or rename folders used for each type of resource, select the desired folder type, then make changes to the list presented. To delete a folder, clear its name from the list. To add a new folder, enter a folder name in an empty field. To rename a folder, edit its name in place and submit the form.</P>\r\n',0,'Folders');
INSERT INTO tech_internal_help_entry VALUES (123,16,'<P>News entries can be created and shown for both your end-users and for technicians.</P>\r\n\r\n<P>User news entries are shown on the user interface home page, and can be used to announce a new major software releases, changes in support policies, and so on.</P>\r\n\r\n<P>Technician news entries are shown on the technician interface home page (and in News/View Tech News), and can be used to make announcements welcoming new technical staff, explaining procedural changes, and more.</P>',0,'Overview');
INSERT INTO tech_internal_help_entry VALUES (124,16,'<P>To add an entry to either user or technician news, select the appropriate \"Add new ...\" entry from the News menu. Enter a title and the article body, then submit the form. The article will be added and shown as news in the appropriate interface.</P>\r\n\r\n<P>For user news entries, you can also specify whether logged in users and anonymous users can see each article.</P>',0,'Adding Entries');
INSERT INTO tech_internal_help_entry VALUES (125,16,'<P>To edit an entry, select its \"edit\" link, make the desired changes, and submit the form. The changes are immediate.</P>\r\n\r\n<P>To delete an entry entirely, select its \"delete\" link. This will permanently remove the entry from the news display.</P>',0,'Editing and Deleting Entries');
INSERT INTO tech_internal_help_entry VALUES (126,11,'<P>This display shows a list of users currently connected to DeskPRO, and briefly describes what they\'re doing (viewing a FAQ article, reading a ticket, etc.). Whenever possible, a link to the exact ticket, article, or area is provided.</P>',0,'Online Users');
INSERT INTO tech_internal_help_entry VALUES (127,11,'<P>To add many users at once, use the Users/Mass Add Users page.</P>\r\n\r\n<P>Enter a list of e-mail addresses, separated by commas, one for each user you wish to add. Usernames will be automatically generated based on the each e-mail address, and each new account\'s password will be generated randomly.</P>\r\n\r\n<P>If \"Send Welcome E-mail\" is set to \"yes,\" each new user will be e-mailed a welcome message providing their login details.</P>\r\n\r\n<P>Note that this process can be time consuming if many e-mails must be sent (this is entirely dependent on how quickly your mail server accepts mail for delivery).</P>',0,'Mass Add');
INSERT INTO tech_internal_help_entry VALUES (128,12,'<P>Private messages are used to communicate privately between two technicians; such conversations occur outside the scope of an individual ticket. To view a message, select it from the list of messages.</P>\r\n\r\n<P>Read and unread messages are listed separately; to view the other list of messages, select \"View Read PMs\" or \"View Unread PMs\" (only the relevant one is shown).</P>\r\n\r\n<P>To delete messages or mark them (un)read, select each message to delete or change, select \"Delete\" or \"Mark ...\", then select \"Process\".</P>',0,'Viewing');
INSERT INTO tech_internal_help_entry VALUES (129,10,'<P>When one or more tickets are found during a search, many actions are available to you for each ticket. You can perform an action for each ticket listed; that action can be unique to each ticket or the same for every ticket (bulk deleting, for instance, or assigning each ticket to the appropriate technician).</P>\r\n\r\n<P>To take action on a ticket, select the action from the list presented for that ticket. Some actions have additional choices available; these will appear when applicable. When you\'ve made your selections, select the \"Process Tickets\" button to act on each ticket as specified.</P>\r\n\r\n<P><U>Delete Ticket</U> - This will delete the selected ticket. Deleting a ticket deletes all attachments, replies, notes, billing entries, etc., associated with the ticket.</P>\r\n\r\n<P><U>Delete Ticket, Delete User, and Ban E-mail</U> - This will delete the selected ticket, delete the user who created it, and ban that user\'s e-mail address from submitting any more tickets or registering again as another user. Deleting a ticket deletes all attachments, replies, notes, billing entries, etc., associated with the ticket. Deleting a user deleted all tickets created by that user. Only an administrator can remove a banned e-mail address. Use this option with caution.</P>\r\n\r\n<P><U>Assign to Tech</U> - This assigns the ticket to the specified technician. A list of technicians will be presented when this option is selected.</P>\r\n\r\n<P><U>Close Ticket</U> - This closes the ticket. A second list of options will be shown when this option is selected -- choose \"Email User\" to send a notification of the ticket closure to the user, or \"Do Not Email User\" to close the ticket without sending a notification.</P>\r\n\r\n<P><U>Set as awaiting a user response</U> - This sets the ticket to \"awaiting user response\" status.</P>\r\n\r\n<P><U>Set as awating a technician response</U> - This sets the ticket to \"awaiting technician response\" status.</P>\r\n\r\n<P><U>Reply with quick reply</U> - This responds to the ticket with the specified quick reply, and sets the ticket to \"awaiting user response\" status. A list of quick replies is presented when this option is selected.</P>\r\n\r\n<P><U>Change priority</U> - This changes the ticket\'s priority to the specified one. A list of priorities is presented when this option is selected.</P>\r\n\r\n<P><U>Change category</U> - This changes the ticket\'s category to the specified one. A list of categories is presented when this option is selected.</P>\r\n\r\n<P><U>Set \"Spam\" flag for this ticket</U> - This marks the ticket as \"spam,\" effectively removing it from ticket lists and search results (unless explicitly searched for).</P>\r\n\r\n<P><U>Remove \"Spam\" flag for this ticket</U> - This marks the ticket as \"normal,\" putting it back in ticket lists and search results.</P>\r\n',0,'Search Results');
INSERT INTO user_help VALUES (1,3,'login',0);
INSERT INTO user_help VALUES (2,3,'register-no-val',0);
INSERT INTO user_help VALUES (3,3,'register-user-val',0);
INSERT INTO user_help VALUES (4,3,'register-manual-val',0);
INSERT INTO user_help VALUES (5,3,'register-both-val',0);
INSERT INTO user_help VALUES (6,2,'new-ticket-regged',0);
INSERT INTO user_help VALUES (7,2,'new-ticket-not-val',0);
INSERT INTO user_help VALUES (8,2,'new-ticket-not-regged-no-val',0);
INSERT INTO user_help VALUES (9,2,'new-ticket-not-regged-val',0);
INSERT INTO user_help VALUES (10,2,'ticket-list',0);
INSERT INTO user_help VALUES (11,3,'general-settings',0);
INSERT INTO user_help VALUES (12,3,'update-password',0);
INSERT INTO user_help VALUES (13,3,'update-email',0);
INSERT INTO user_help VALUES (14,1,'subscriptions',0);
INSERT INTO user_help VALUES (15,1,'viewing',0);
INSERT INTO user_help VALUES (16,1,'advanced-search',0);
INSERT INTO user_help_cats VALUES (1,0,0,'FAQ');
INSERT INTO user_help_cats VALUES (2,1,0,'Tickets');
INSERT INTO user_help_cats VALUES (3,2,0,'Profile');
INSERT INTO user_help_entries VALUES (18,1,1,'Logging In','<P>To log into your account on the helpdesk, enter your username and password on this login form. If you cannot remember your account details, we can retrieve it for you if you can provide either its username or your e-mail address. If a match is found, account details will be sent to the e-mail address we have on record.</P>');
INSERT INTO user_help_entries VALUES (23,3,1,'Registering a New Account','<P>To create a new account at our helpdesk, simply fill out the form shown here. Your password should be at least five characters long, as should your username. Submit the form when you are finished, and your account will be created. If there are any problems with your entries, you will be asked to correct the problem and try again.</P>\r\n\r\n<P>Once your account has been created, you will be mailed a confirmation message to the e-mail address you provide to us. By following the URL in that message, your account will be validated. Until the account is confirmed, tickets you create will not be shown to our technicians.</P>\r\n');
INSERT INTO user_help_entries VAL