ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

T3 dim 4.0 (flex dim) technical discussion

?Download as PPT, PDF?
?
Chris Lee
Chris Lee

The Data Interface Module (DIM) is a tool that allows the exchange of data between the university's ASI system and other campus systems like dining, maintenance, and card access. It has been redesigned using Adobe Flex to be platform independent and open architecture. Actions, which are ColdFusion code files, perform tasks like importing, exporting, reporting, and updating data. The DIM configures and stores parameters for Actions and can rebuild Action files when needed.

1 of 26
Download to read offline
DIM 4.0 Technical Discussion Monday : 1:00pm ¨C 2:30pm A S U G 2010 Session ¨C T3
A S U G 2010 Session ¨C T3 What is the Data Interface Module (DIM)? exchange of data between ASI and other systems How does it interact with other systems? web service API¡¯s exchange of files direct exchange data with database tables and views What other campus systems? dining maintenance card access Why the change to Adobe Flex? Introduction
A S U G 2010 Session ¨C T3 Current DIM is a Microsoft Windows app requires a Windows server and is always running Platform independent Complete redesign into an open architecture no ¡°black box¡± Ability to add many new features Power users can add virtually unlimited functionality with customization Switching to Adobe Flex
A S U G 2010 Session ¨C T3 Imports, exports, etc. are enacted by ColdFusion files that contain code to perform an action files run by CF Scheduler or launched by an app DIM is now a tool to create those files (Actions) configure CF Scheduler settings within DIM parameters used to build Action stored in DIM database can therefore rebuild Action file any time DIM Overview
Actions ¨C cfc files A S U G 2010 Session ¨C T3 ColdFusion code is set of instructions for moving data and performing other tasks stored as a .cfc file on web server import/export based on any criteria and any business logic send email notifications mail merge email reports perform any function that CF can handle cfc file is available to your IT staff can be edited infinite possibilities
?
Import Action A S U G 2010 Session ¨C T3 an xml file defines what data can be imported and how name of table and primary keys fields that can be imported into table for importing data into custom fields related tables for ID fields DIM screen for creating the Action set external datasource match external fields to internal fields notify upon error or completion cfc file created by DIM all ColdFusion code to run import indents and comments included in generated file
?
?
?
?
Report Action A S U G 2010 Session ¨C T3 Send an email based on a previously saved report Email data to a group of staff members or faculty report data included in email body report data attached as a file schedule weekly reports Email a mail-merge letter to everyone listed in report based on previously saved mail-merge template specify the data field in the report holding the email address also copy the letter to a group of staff members or faculty filter criteria in report determines who is included
?
Trigger Action A S U G 2010 Session ¨C T3 An xml file defines what events can trigger an Action list of parameters being passed into function table and primary keys for affected data DIM screen for creating the Action set conditions for running the Action based on how data is being changed send notification or update data when event is triggered mail-merge letter to person involved cfc file created by DIM all ColdFusion code to run notification or update indents and comments included in generated file
?
?
?
Launcher Action A S U G 2010 Session ¨C T3 One Action that launches multiple Actions Set the order of Actions to be run Error management in case one Action in list fails
?
Export Action A S U G 2010 Session ¨C T3 Data to be exported is pre-configured in saved reports reports can include sophisticated database functions Export Options web services API¡¯s delimited or fixed-width text files direct to database tables scheduled, real-time, on-demand Examples room and dining fees prorated room change credits and fees room assignments to card access system damage billing fees dining points total to dining system work orders to external work order system parking tickets
?
?
?
?
Update Action A S U G 2010 Session ¨C T3 Schedule the updating of data based on criteria use a previously saved report Examples 1 st year students who have selected rooms but no dining plan at a set time, automatically assign a dining plan to them automatically flag a Probation sanction as complete once the sanction due date has been reached
Questions & Answers A S U G 2010 Session ¨C T3 Now¡¯s your chance!

More Related Content

T3 dim 4.0 (flex dim) technical discussion

  • 1. DIM 4.0 Technical Discussion Monday : 1:00pm ¨C 2:30pm A S U G 2010 Session ¨C T3
  • 2. A S U G 2010 Session ¨C T3 What is the Data Interface Module (DIM)? exchange of data between ASI and other systems How does it interact with other systems? web service API¡¯s exchange of files direct exchange data with database tables and views What other campus systems? dining maintenance card access Why the change to Adobe Flex? Introduction
  • 3. A S U G 2010 Session ¨C T3 Current DIM is a Microsoft Windows app requires a Windows server and is always running Platform independent Complete redesign into an open architecture no ¡°black box¡± Ability to add many new features Power users can add virtually unlimited functionality with customization Switching to Adobe Flex
  • 4. A S U G 2010 Session ¨C T3 Imports, exports, etc. are enacted by ColdFusion files that contain code to perform an action files run by CF Scheduler or launched by an app DIM is now a tool to create those files (Actions) configure CF Scheduler settings within DIM parameters used to build Action stored in DIM database can therefore rebuild Action file any time DIM Overview
  • 5. Actions ¨C cfc files A S U G 2010 Session ¨C T3 ColdFusion code is set of instructions for moving data and performing other tasks stored as a .cfc file on web server import/export based on any criteria and any business logic send email notifications mail merge email reports perform any function that CF can handle cfc file is available to your IT staff can be edited infinite possibilities
  • 6. ?
  • 7. Import Action A S U G 2010 Session ¨C T3 an xml file defines what data can be imported and how name of table and primary keys fields that can be imported into table for importing data into custom fields related tables for ID fields DIM screen for creating the Action set external datasource match external fields to internal fields notify upon error or completion cfc file created by DIM all ColdFusion code to run import indents and comments included in generated file
  • 8. ?
  • 9. ?
  • 10. ?
  • 11. ?
  • 12. Report Action A S U G 2010 Session ¨C T3 Send an email based on a previously saved report Email data to a group of staff members or faculty report data included in email body report data attached as a file schedule weekly reports Email a mail-merge letter to everyone listed in report based on previously saved mail-merge template specify the data field in the report holding the email address also copy the letter to a group of staff members or faculty filter criteria in report determines who is included
  • 13. ?
  • 14. Trigger Action A S U G 2010 Session ¨C T3 An xml file defines what events can trigger an Action list of parameters being passed into function table and primary keys for affected data DIM screen for creating the Action set conditions for running the Action based on how data is being changed send notification or update data when event is triggered mail-merge letter to person involved cfc file created by DIM all ColdFusion code to run notification or update indents and comments included in generated file
  • 15. ?
  • 16. ?
  • 17. ?
  • 18. Launcher Action A S U G 2010 Session ¨C T3 One Action that launches multiple Actions Set the order of Actions to be run Error management in case one Action in list fails
  • 19. ?
  • 20. Export Action A S U G 2010 Session ¨C T3 Data to be exported is pre-configured in saved reports reports can include sophisticated database functions Export Options web services API¡¯s delimited or fixed-width text files direct to database tables scheduled, real-time, on-demand Examples room and dining fees prorated room change credits and fees room assignments to card access system damage billing fees dining points total to dining system work orders to external work order system parking tickets
  • 21. ?
  • 22. ?
  • 23. ?
  • 24. ?
  • 25. Update Action A S U G 2010 Session ¨C T3 Schedule the updating of data based on criteria use a previously saved report Examples 1 st year students who have selected rooms but no dining plan at a set time, automatically assign a dining plan to them automatically flag a Probation sanction as complete once the sanction due date has been reached
  • 26. Questions & Answers A S U G 2010 Session ¨C T3 Now¡¯s your chance!