Разработчици Кемпински Хотел Зографски София

Разработчици 28 Юни 2012 г.2 Веселин Георгиев, SharePoint &.NET Developer Мартин Караиванов, SharePoint &.NET Developer Case Study: InfoPath, Excel Services and Word Document Generation

Разработчици 28 Юни 2012 г.3

Разработчици 28 Юни 2012 г.4

Разработчици A client who wants a time tracking system : – Employees enter information (input) – Managers examine reports (output) – Generating word documents (output) We know the client has a MOSS license 28 Юни 2012 г.5 What We Have

Разработчици Create electronic forms for gathering information efficiently and reliably Make complex form design easier Rich and user-friendly UI Develop advanced forms functionality without coding 28 Юни 2012 г.6 Microsoft Office InfoPath 2007

Разработчици 28 June InfoPath in Action - Demo

Разработчици Forms with several hundreds fields Complex business logic Frequent change requests – nightmare for every developer 28 Юни 2012 г.8 How Complex Things Can Be:

Разработчици 28 Юни 2012 г.9 Is Something Missing? How will we use InfoPath forms in the Web world?

Разработчици Bringing InfoPath forms to the web world AJAX-enabled ASP.NET web forms Develop once for web & smart client The process – Develop with InfoPath – Publish and Render with Forms Services – Use from Web Browser 28 Юни 2012 г.10 InfoPath Forms Services

Разработчици 28 Юни 2012 г.11 Architecture – Input

Разработчици 28 June InfoPath Forms Services - Demo

Разработчици Why Excel for reports – Outsource report definition to business people How to do it in Excel: – Excel imports data from SQL Server table – Excel provides pivot tables & pivot chart 28 Юни 2012 г.13 Microsoft Excel

Разработчици How to make Excel report web-enabled? 28 Юни 2012 г.14 But Something is Missing?

Разработчици Interactive web-based Excel – Integral part of Office Sharepoint Server – Great BI & data presentation tools – Dashboards and KPIs Its not a data entry tool for the web Making developers life easier 28 Юни 2012 г.15 Excel Services in SharePoint

Разработчици 28 Юни 2012 г.16 Architecture - Output

Разработчици 28 June Excel Services - Demo

Разработчици Component developed by us to satisfy the need of generating Word documents 28 Юни 2012 г.18 Word Document Generation

Разработчици 28 June Timesheet Report Generation - Demo

Разработчици 26 types of documents Template of 50 pages with more than 500 placeholders Generated documents of 20 pages Config files of 3000 lines per document 28 Юни 2012 г.20 How Complex Documents Can Be?

Разработчици Simple time tracking system Lots of technologies involved Big opportunities for developing complex and more complex systems Quick and efficient development 28 Юни 2012 г.21 Summary

Разработчици 28 Юни 2012 г.22 When You Do Not Fill Your Timesheet

Разработчици 28 Юни 2012 г.23 When You Do Fill Your Timesheet

Разработчици Q & A 28 June

Разработчици Абилитикс предлага IT решения, консултантски услуги, обучения, outsourcing, разработка, внедряване и поддръжка на приложения, както и на собствени продукти базирани на Microsoft технологиите - SharePoint, ASP.NET, Project Server, Dynamics CRM, Exchange, SQL Server & Business Intelligence. 28 Юни 2012 г Веселин Георгиев SharePoint &.NET Engineer MCPD: Windows Developer Мартин Караиванов SharePoint &.NET Engineer