2015-12-07 11:09 AM - edited 2015-12-08 08:14 AM
Abstract: The EDM-Pack includes a general-purpose Data Source that can read from a Microsoft Excel spreadsheet directly into a WFA custom scheme and dictionaries. Those dictionary tables are then available to workflows for search and selection in user interface Queries, Filters, Finders, and Commands. This allows workflows to align with customer business rules, organization and environmental information. In addition, a workflow is included which will export an existing WFA scheme to an Excel spreadsheet allowing viewing and reporting of data within the WFA Cache Database.
The attached files include:
New features incorporated in this release include:
This is a two person project. I came up with the simple idea in version 1 of the tool. Mirko Van Colen added table relations and rewrote the DS for PSExcel. We then collaborated on development resulting in this new packaged version we're calling EDM for Excel Data Management. Ideas for features in future versions are welcome.
NOTE: This EDM-Pack supercedes the ACE-DS Data Source referenced preiviously in this community at: http://community.netapp.com/t5/OnCommand-Storage-Management-Software-Discussions/ACE-DS-A-reusable-Data-Source-for-acquiring-from-Excel-spreadsheets/m...
2015-12-10 01:10 AM
Oh I see that you are bundling the PS Module in the workflow using the "Help-Content". Very Clever.
2016-01-27 11:40 AM
While attempting to install the EDM-Pack on a Windows 2008 R2 server I discovered the EDM-Pack is dependent on .NET 4.5 for proper operation. I believe .NET 4.5 is built-in or included with Win2012_R2 but evidently not with Win2008_R2. As such, if you are on a Win2008_R2 server that doesn't have .NET 4.5 installed, you may get an error when running the EDM000 Pack Initialize workflow similar to this (or see screenshot below):
Could not load file or assembly 'System.IO.Compression.FileSystem, Version=188.8.131.52, Culture=neutral, PublicKeyToken=b77a5c561934e089 or one of its dependencies. The system cannot find the file specified....
To install .NET 4.5 on the WFA Win2008 R2 server:
After the WFA server reboots, connect to WFA again and run the EDM000 Pack Initialize workflow again.
===== EDM000 error when .NET 4.5 missing =====