1. Enhancing to prevent Cannot insert duplicate key row in object 'dbo.speitems' with unique index 'NCU_spfitems_menid_sfi_smefk_sequence', Errorlog | EventFoodItem Update ex:
In Elecate, the errolog table shows a significant number of errors (6) in the "EventFoodItem Update ex" form:
A fix was implemented for the following errolog:
Exception during update process: Error updating Event Equipment item record: Cannot insert duplicate key row in object 'dbo.spfitems' with unique index 'NCU_spfitems_menid_sfi_smefk_sequence'. The duplicate key value is (X, Y, Z).
The statement has been terminated.
2. Wanting a partial save to be added to the "Event Proposal Editor Window" Performance | Partial/Full Save:
When changes are done in the text fields only, partial save will be applied. This will help to decrease the loading time, and the user won´t have to wait too much time for the system to complete the action, the partial save will apply when: Creates a new page, add the food items to the right side, removed item from the right side and tries to reorder the items.
1. On the left side panel, go to Sales & Marketing
2. Click on Event & Order Management
3. Select Event Management - All Status Types Included
4. Open an existing event, go to the order details tab
5. Split the items by departments, in the order review you will see 7 different options at the beginning of each department, look for Edit proposal option.
3. Wanting a partial save to be added to the "Event Item Locations", Performance | Partial/Full Save:
When changes are done in the text fields only, partial save will be applied. This will help to decrease the loading time, and the user won´t have to wait too much time for the system to complete the action, the following columns or actions will cause a ¨Partial Save¨: Action, Location, Batch Update.
1. On the left side panel, go to Sales & Marketing
2. Click on Event & Order Management
3. Select Event Management - All Status Types Included
4. Open an existing event, go to the order details tab
5. Split the items by departments, in the order review section, you will see 7 different options at the beginning of each department, look for Edit Item Location.
4. Wanting a partial save to be added to the Edit Item Print Option, Performance | Partial/Full Save:
When changes are done in the text fields only, partial save will be applied. This will help to decrease the loading time, and the user won´t have to wait too much time for the system to complete the action, the following columns will cause a ¨Partial Save¨: Edit Item Print Option and Page No.
1. On the left side panel, go to Sales & Marketing
2. Click on Event & Order Management
3. Select Event Management - All Status Types Included
4. Open an existing event, go to the order details tab
5. Split the items by departments, in the order review section, you will see 7 different options at the beginning of each department, look for Edit Item Print Option.
5. Wanting a partial save to be added to the Edit Item Prop Section/Group, Performance | Partial/Full Save:
When changes are done in the text fields only, partial save will be applied. This will help to decrease the loading time, and the user won´t have to wait too much time for the system to complete the action, the following columns will cause a ¨Partial Save¨: Edit Item Print Option and Page No.
1. On the left side panel, go to Sales & Marketing
2. Click on Event & Order Management
3. Select Event Management - All Status Types Included
4. Open an existing event, go to the order details tab
5. Split the items by departments, in the order review section, you will see 7 different options at the beginning of each department, look for Edit Item Prop Section/ Group.
6. Enhancing to prevent Cannot insert duplicate key row in object 'dbo.speitems' with unique index 'NCU_speitems_pequid_sei_spefk_sequence', PART 2 | Errorlog | Event Equipment Item Update ex:
We need to add the following prompt message:
Sequence Already Exists (header): The sequence “[insert sequence value]” is already in use. Please enter a unique sequence.
1. On the left side panel, go to Sales & Marketing
2. Click on Event & Order Management
3. Select Event Management - All Status Types Included
4. Open an existing event, go to the order details tab
7. Seeing a warning when an event is being used either on Menu Builder or Event Sales Menu:
If an event is in used by another user, a warning will be displayed in Menu Builder or Event Sales Menu.
1. On the left side panel, go to Sales & Marketing
2. Click on Event & Order Management
3. Select Event Management - All Status Types Included
4. Open an existing event by clicking on the pen icon
OR
5. In the Event & Order Management
6. Click on Main Sales View
7. Select Menu Builder
8. Changing the size field from the Special Instructions to varchar (2000):
The user will have the option to adjust the appsetting: EventsSpecialInMaxLength, in order to increase or decrease the characters on this section.
How to adjust the appsetting:
1. At the top of the screen, on the right side click on the Gear Icon
2. Select Appsettings
3. Look for EventsSpecialInMaxLength
4. Enter the number of characters that you want to see on this section
THEN
5. On the left side panel, go to Sales & Marketing
6. Click on Event & Order Management
7. Select Event Management - All Status Types Included
8. Open an existing event by clicking on the pen icon
9. Go to the Delivery Tab, on the right side of the window, go to the Special Instructions section