Excel Import Synchronizer
This Synchronizer allows data to be imported from an Excel Spreadsheet into a MooD repository.
A wizard is used to guide you through the process of selecting the correct layout, the data range, and the data types for the spreadsheet. Typically, the Simple layout is used to create or update elements in a repository. Each row in the spreadsheet is mapped to a single element. The wizard allows you to say what you want to map and then use the Mapping tab to map this to a target in the repository.
The Simple layout expects a single continuous range of data. The wizard will scan the range of highlighted data; allow you to make minor adjustments, and then give you a table for it in the source area of the Mapping tab. In the case of the Excel Import Synchronizer, the source is always from an Excel Spreadsheet.
The tools in the Mapping tab can then be used to map the source to the target. The target is an element in the repository, e.g. Epoch, Theme, etc. New elements will be created as children of this element. A target table is created showing the structure of these elements.
Please sign in to leave a comment.