Invalid Event/Venue

In the ‘BuyOrder Insert.xlsx’, check the Eibo sheet to see if it’s not there already. If is it Copy+Paste the Event/Venue name into the corresponding Event/Venue Cell in the Buy Order sheet that’s causing the Error. This is to make sure it’s not a special character keeping this from happening. If it’s not there, follow the instructions below.

Open

1. Open SSMS

   1. Connect to 192.168.10.204

   2. Use the AppUser credentials.

2. Open a ‘New Query’ at the top of the page.

   1. Open

      

      This will open a new Query in which you can type into.

3. Select Eiboxoffice in the drop down menu. It defaults to master.

   1. Open

      

      After clicking ‘New Query’ this drop down should be available.

4. Open the code from the beginning of this page.

   1. Depending on if it’s a venue or event that’s invalid will depend on which ‘NULL’ you replace.

      1. Replace the respective NULL, with the venue/event name in ' '

5. Click the 'Execute' button below 'New Query'

   1. Open

      

      The button should be clickable.

       

6. Once it has run, at the bottom there should be a table with the Event Name/Venue Name and an Event ID/ Venue ID.

7. Open the ‘BuyOrder Insert.xlsx’ again, and go to the ‘Eibo’ Tab.

8. Scroll to the next open spot under the ‘EventName’ or ‘VenueName’ column

   1. Copy the Event/Venue Name that’s in the query table onto the next free space under ‘EventName’ or ‘VenueName’.

9. Go to the next Column over which should be titled ‘EventID’ or ‘VenueID’.

   1. Copy the Event/Venue Id that’s in the query table onto the cell right next to the Event/Venue Name you just put in.

10. The Invalid Event/Venue error should be fixed in the ‘BuyOrder Insert.xlsx’

    1. Run those lines in the BuyOrder script and turn them green.