External Content Type data is exported to Excel spreadsheet, so that from Excel spread sheet the data can be imported in another implementation of the SharePoint Web create external content types.
Example: Export from staging site and import with in production site to create custom content types.
So far external content types are exported to spreadsheet. The issue is with Workflow related content type and look up values as elaborated below.
1. What is the best approach to store Lookup data?
2. Configuration for the workflow content type can be multiple i.e., configuration 1, configuration 2 etc.
Each configuration {i.e, configuration1} can have multiple panels with configuration.
what is the best approach to store this workflow content type data in spreadsheets.
Insight and help greatly appreciated.
Best
