Download
cashnet colleague integration n.
Skip this Video
Loading SlideShow in 5 Seconds..
CashNet/Colleague Integration PowerPoint Presentation
Download Presentation
CashNet/Colleague Integration

CashNet/Colleague Integration

175 Vues Download Presentation
Télécharger la présentation

CashNet/Colleague Integration

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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