Portal Home > Knowledgebase > cPanel > SENS - Add Raving Fans Events
In a nutshell …
- · Create new Excel spreadsheet
- · Paste forwarded events
- · Parse data -- Four fields are require
1. EventName
2. EventDateTime
3. EventType
4. CreateDate
- · Data should look like …
EventName
EventDateTime
EventType
CreateDate
67's v. Peterborough
12/14/2012 19:30
2
12/21/2012 11:11
67's v.Kingston
12/31/2012 14:00
2
12/21/2012 11:11
67's v. Oshawa
1/9/2013 19:00
2
12/21/2012 11:11
67's v.Guelph
1/18/2013 19:30
2
12/21/2012 11:11
67's v. Owen Sound
1/20/2013 14:00
2
12/21/2012 11:11
MBNA Capital Hoops Classic
1/23/2013 18:00
2
12/21/2012 11:11
67's v. London
1/24/2013 19:00
2
12/21/2012 11:11
Elizabeth Manley
1/26/2013 19:00
2
12/21/2012 11:11
67's v. Sarnia
2/1/2013 19:30
2
12/21/2012 11:11
67's v. Peterborough
2/6/2013 19:00
2
12/21/2012 11:11
67's v. Windsor
2/8/2013 19:30
2
12/21/2012 11:11
67's v. Belleville
2/10/2013 14:00
2
12/21/2012 11:11
67's v. Barrie
2/13/2013 19:00
2
12/21/2012 11:11
67's v.Peterborough
2/15/2013 19:30
2
12/21/2012 11:11
67's v.Brampton
2/18/2013 14:00
2
12/21/2012 11:11
- · Save as a text file
- · Copy text file to \\coldfusion\c$
1. RDP to COLDFUSION
2. SQL Server Enterprise manager 2000
3. Connect to 10.0.10.1
4. Open CC db
5. Select the Reservation_Events table
6. All Tasks - Import Data
Add to Favourites 
Print this Article
