1 / 17

CashNet/Colleague Integration

CashNet/Colleague Integration. Rob Allender - CashNet Jeff Butera – Hampshire College Session 10667 July 29, 2005 10:30AM - Room 106. NERDug 2005 – July 28-29 – Hampshire College. Outline. Student Perspective Technical Details Summary of Data Integration.

azure
Download Presentation

CashNet/Colleague Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CashNet/Colleague Integration Rob Allender - CashNet Jeff Butera – Hampshire College Session 10667 July 29, 2005 10:30AM - Room 106 NERDug 2005 – July 28-29 – Hampshire College

  2. Outline • Student Perspective • Technical Details • Summary of Data Integration NERDug 2005 – July 28-29 – Hampshire College

  3. Student Perspective NERDug 2005 – July 28-29 – Hampshire College

  4. Student Perspective • Student info calculated/stored nightly • PIN, current account balance • Student logs into WA • Select 'View/Pay My Bill' • Customized version of Datatel's Web AR Statement NERDug 2005 – July 28-29 – Hampshire College

  5. Student Perspective • Web AR Statement: • Displays charges, credits and pending financial aid • Balance (displayed at bottom) is stored in Unidata • Link to CashNet site 'Make Credit Card Payment' NERDug 2005 – July 28-29 – Hampshire College

  6. Student Perspective • CashNet link has login info embedded • See balance on CashNet and choose to make payment • Enter card info, amount • CashNet verifies transaction • If successful, payment posted back to Hampshire College NERDug 2005 – July 28-29 – Hampshire College

  7. Technical Details NERDug 2005 – July 28-29 – Hampshire College

  8. Technical Details • CashNet issues commands over https (encrypted) • We provide base URL for connection • URL passes username, password, command, arguments • CGI script receives request, parses URL arguments NERDug 2005 – July 28-29 – Hampshire College

  9. Technical Details • CGI script invokes small C program • C program connects to Unidata, invokes subroutine • Calls other subroutines to read/write data as needed • Data returned to C program and parsed by CGI NERDug 2005 – July 28-29 – Hampshire College

  10. Technical Details • Sample command: https://someserver.hampshire.edu:83/cgi-bin/cn_script.cgi ?username=jeff&password=secret&command=CUSTINFO&custcode=0023450 • Unidata returns: 'custcode':@VM:'0023450' 'lname':@VM:'Doe' 'fname':@VM:'Jane' 'pin':@VM:'123456' 'itemcode':@VM:'SBAL' 'itemdesc':@VM:'Student Account Balance' 'amount':@VM:'1732.43' NERDug 2005 – July 28-29 – Hampshire College

  11. Technical Details • CGI script returns data to CashNet as HTML: <HTML> <BODY> <CNDATA> custcode=0023450& lname=Doe& fname=Jane& pin=123456& itemcode=SBAL& itemdesc=Student Account Balance& amount=1732.43 </CNDATA> </BODY> </HTML> NERDug 2005 – July 28-29 – Hampshire College

  12. Summary of Data Integration NERDug 2005 – July 28-29 – Hampshire College

  13. Summary of Data Integration • Student logs into WebAdvisor, views A/R Statement • Select 'View/Pay My Bill' • Taken to CashNet's site, username/password embedded • CashNet takes username and issues CUSTINFO command NERDug 2005 – July 28-29 – Hampshire College

  14. Summary of Data Integration • Our server retrieves customer info (user, pass, balance) • CashNet displays balance • Student enters payment • Payment posted back to our server NERDug 2005 – July 28-29 – Hampshire College

  15. Summary of Data Integration Student views A/R Statement on WebAdvisor College Datatel Server College Web Server Student CashNet Server NERDug 2005 – July 28-29 – Hampshire College

  16. Summary of Data Integration Student selects Make Credit Card Payment College Datatel Server College Web Server Student CashNet Server NERDug 2005 – July 28-29 – Hampshire College

  17. Summary of Data Integration Student completes Credit Card Payment College Datatel Server College Web Server Student CashNet Server Bank/ Merchant NERDug 2005 – July 28-29 – Hampshire College

More Related