FME Transformers: 2024.1
Categories and Related Transformers
Categories
Cartography and Reports
Prepares features for output to the Microsoft PowerPoint Writer by providing a convenient interface to set a variety of Microsoft PowerPoint format-specific attributes.
Usage Notes
-
For more information regarding PowerPoint styling, see the Microsoft PowerPoint Writer section in the FME Readers and Writers manual (in FME Workbench, select Help > FME Readers and Writers Reference)
Configuration
Parameters
Slide Layout
|
Slide Type |
Chooses what kind of slide is to be generated by features going through this styler. Most of the options style a single feature to produce a single slide. Map Slide has the option of using several features to combine their geometries onto one slide. Custom (Advanced) allows the user full freedom of what layout to use, and how multiple features coming through the feature correlate to aspects of that slide. To use this option, the user must be willing to setup some layouts beforehand through PowerPoint. See Using Custom Slide Layouts for more information. The types correspond to the following layouts that are present to every PowerPoint presentation:
The GUI types with multiple corresponding PowerPoint layouts are further specified by the Slide subtype GUI option. Note Changing any of these slide layouts in your PowerPoint template file, will affect and potentially break functionality. Format attribute set: powerpoint_type |
Title Slide
|
Title |
The text that will be placed in the title placeholder. Format attribute set: powerpoint_title_text |
|
Subtitle |
The text that will be placed in the subtitle placeholder Format attribute set: powerpoint_subtitle_text |
Slide
|
Slide Subtype |
This specifies whether a title or caption will accompany the slide content. Format attribute set: powerpoint_type |
|
Title |
The text that will be placed in the title placeholder Format attribute set: powerpoint_title_text |
|
Caption |
The text that will be placed in the caption placeholder. Any line breaks in this text area will create a new paragraph in the caption. Depending on the placeholder’s settings, this might be a typical paragraph, or it may be a new bullet or list item. Format attribute set: powerpoint_caption_text |
Title
|
Title |
The text that will be placed in the title placeholder Format attribute set: powerpoint_title_text |
Body
|
Text |
The text that will be placed in the content placeholder. Any line breaks in this text area will create a new paragraph in the caption. Depending on the placeholder’s settings, this might be a typical paragraph, or it may be a new bullet or list item. Format attribute set: powerpoint_paragraph_text |
||||||||||||||||||||
|
Override Font |
The font name, size, and styling properties. If this is left blank the content placeholder in the template’s “Title and Content” Layout will determine the font attributes. To edit this parameter, click the browse button to the right of the text field. Note that strikeout text is not supported for Microsoft PowerPoint writing at this time. Format attribute set: fme_powerpoint_font_data |
||||||||||||||||||||
|
Override Font Color |
The color of the text foreground for this list item. If this is left blank the content placeholder in the template’s “Title and Content” Layout will determine the font attributes. Specifying Colors Colors may be entered directly or chosen from the color picker via the ellipsis button. Syntax
Colors can be specified by RGB values or hex codes. RGB values may be either 24-bit or decimal (0 - 1). If the value type is unclear, as in (1,1,1), the 24-bit interpretation is used. Hex codes are accepted with or without a hash sign (#).
Format attribute set: powerpoint_font_color |
Image
|
Image Scaling |
This option allows control over the size of the image. The image will always fit within its placeholder, and if it is sufficiently large, will be cropped to made fit. Fit Width makes the image width the same as the placeholder’s width. Fit Height makes the image width the same as the placeholder’s height. Best Fit sizes the image so that no cropping is required. Fill stretches the image to fit width and height without cropping. Fill (Lock Aspect Ratio) sizes the image so that the minimum amount of cropping is required to fill both the placeholder’s width and height. Format attribute set: powerpoint_image_fit |
|
Image Source |
Image Source has two options: From File and From Feature. If From File is selected, then the Image Filename parameter is used to select a file. If From Feature is selected, then the styled feature must have a raster geometry. Its raster geometry is written to the Microsoft PowerPoint document. Format attribute set: powerpoint_image_source |
|
Image Filename |
Specifies the path to the desired image. To browse your file system for an image, click the browse button to the right of the text field. This parameter is only enabled if Image Source is From File Format attribute set: powerpoint_image_filename |
Hyperlink
|
Hyperlink Address |
If this attribute is set for any content, then that content will be given a hyperlink pointing to the specified address. Format attribute set: powerpoint_hyperlink |
Table
|
Table Style |
These styles control the table’s colors and line styles. The colors depend on the PowerPoint theme colors if a template is selected. These styles can all be seen in PowerPoint in the ribbon while editing a table. Format attribute set: powerpoint_table_style |
|
Alternate Row Color |
If set to Yes, adjacent rows in the table will differ in color by a small amount, so that rows are easily distinguished. Format attribute set: powerpoint_table_banding |
|
Width Units |
This in conjunction with Column Width specifies how wide each column should be. Format attribute set: powerpoint_measurement_units |
Table Columns
This table in the GUI will set one format attribute.
Format attribute set: fme_powerpoint_table_data
|
Column Header |
The text to appear in the first row of the particular column. Header cells are stylized to stand out from the rest of the column cells. Format attribute set: powerpoint_table_header |
|
Column Values |
The text values to appear in the particular column of a table. Format attribute set: powerpoint_table_value |
|
Column Width |
This in conjunction with Width Units specifies how wide each column should be. If Percentage of Table Width was chosen for Width Units, then 100 means the entire table width, while 1 means only one percent. |
Chart
|
Chart Type |
From here you can pick from a list of unique charts. The names match up with the charts you can select in PowerPoint after pushing the insert chart button. Format attribute set: powerpoint_chart_type |
||||||
|
Label Data |
If Yes, then the series in the charts (whether they are slices of a pie, bars, etc) will be labelled with their numeric value. Format attribute set: powerpoint_chart_has_labels |
||||||
|
Legend |
If checked, a legend will appear with the chart. Format attribute set: powerpoint_chart_has_legend
|
Chart Data
|
Categories |
This attribute specifies what each successive value in the series represents. The length of categories should match the length of each series values attribute. This must be a list attribute. Format attribute set: powerpoint_chart_categories |
The next three parameters, which are part of a table in the GUI, all set the same format attribute: fme_powerpoint_chart_data
|
Override Color |
The color for this particular series. If this is left blank, then one of the theme’s default colors will be picked. Specifying Colors Colors may be entered directly or chosen from the color picker via the ellipsis button. Syntax
Colors can be specified by RGB values or hex codes. RGB values may be either 24-bit or decimal (0 - 1). If the value type is unclear, as in (1,1,1), the 24-bit interpretation is used. Hex codes are accepted with or without a hash sign (#).
|
||||||||||||||||||||
|
Series Name |
The name of the series. This is usually only relevant if the legend is shown. |
||||||||||||||||||||
|
Series Values |
This attribute specifies what each successive value in the series represents. The length of categories should match the length of each series values attribute. This must be a list attribute. |
Map
Label
|
Label Text |
This optional parameter specifies the text to appear centered on a map. Format attribute set: powerpoint_map_label |
||||||||||||||||||||
|
Override Font |
The font name, size, and styling properties. If this is left blank a reasonable set of defaults will be chosen. Note that strikeout text is not supported for PowerPoint writing at this time. Format attribute set: fme_powerpoint_font_data |
||||||||||||||||||||
|
Override Color |
The color for this particular series. If this is left blank, then PowerPoint will attempt to choose a color that will be visible over the shape’s color. Specifying Colors Colors may be entered directly or chosen from the color picker via the ellipsis button. Syntax
Colors can be specified by RGB values or hex codes. RGB values may be either 24-bit or decimal (0 - 1). If the value type is unclear, as in (1,1,1), the 24-bit interpretation is used. Hex codes are accepted with or without a hash sign (#).
Format attribute set: powerpoint_font_color |
Fill
|
Fill Pattern |
This optional parameter specifies a pattern for the map shape. If left blank then the entire map will be the foreground color. Format attribute set: powerpoint_map_fill_pattern |
||||||||||||||||||||
|
Foreground Color |
The pattern foreground for the map shape. If this is left blank, then one of the theme’s default colors will be picked. Specifying Colors Colors may be entered directly or chosen from the color picker via the ellipsis button. Syntax
Colors can be specified by RGB values or hex codes. RGB values may be either 24-bit or decimal (0 - 1). If the value type is unclear, as in (1,1,1), the 24-bit interpretation is used. Hex codes are accepted with or without a hash sign (#).
Format attribute set: powerpoint_map_fill_fore_color |
||||||||||||||||||||
|
Background Color |
The pattern background for the map shape. If the pattern was left blank, then this parameter is inconsequential. If this is left blank, then PowerPoint will attempt to choose a color that will be visible over the shape’s color. Specifying Colors Colors may be entered directly or chosen from the color picker via the ellipsis button. Syntax
Colors can be specified by RGB values or hex codes. RGB values may be either 24-bit or decimal (0 - 1). If the value type is unclear, as in (1,1,1), the 24-bit interpretation is used. Hex codes are accepted with or without a hash sign (#).
Format attribute set: powerpoint_map_fill_back_color |
Border
|
Line Style |
The style of the line bordering the map shape. If left blank then a single solid line will be used. Format attribute set: powerpoint_map_border_style |
||||||||||||||||||||
|
Border Width |
The width of the line bordering the map shape. If this is 0, then no line will be visible. Format attribute set: powerpoint_map_border_width |
||||||||||||||||||||
|
Border Color |
The color of the line bordering the map shape. Specifying Colors Colors may be entered directly or chosen from the color picker via the ellipsis button. Syntax
Colors can be specified by RGB values or hex codes. RGB values may be either 24-bit or decimal (0 - 1). If the value type is unclear, as in (1,1,1), the 24-bit interpretation is used. Hex codes are accepted with or without a hash sign (#).
Format attribute set: powerpoint_map_border_color |
Feature Handling
|
Create Slide From |
The choices are Single Feature and Multiple Features. If Single Feature is selected, then each feature will make one slide when styled by this Styler. If Multiple Features is selected, then features will be grouped by the next attribute Slide Group ID, and each group will make one slide. The different features will all contribute a single shape to a map inside the content placeholder, and the styling properties of each feature will apply just to that one shape. This means that different areas of the map could have different hyperlinks, fill colors, etc. If Multiple Features is selected, then the Slide Parameters of the first arriving feature will be used, and the rest ignored. Format attribute set: powerpoint_merge_features |
|
Slide Group ID |
The id for a group of features. This can be of any type, and all features given the same id will contribute to the same slide. Format attribute set: powerpoint_merge_id |
Layout
|
Layout Name |
This name must match some layout in the PowerPoint template file. That layout will be used. This parameter is case insensitive. To create a layout in PowerPoint, go to View > Slide Master > Insert Layout. Customize it however you please. To name the layout right click on it on the left in PowerPoint and select rename. |
||||||
|
Placeholders |
A table containing the following three parameters all sets the Format attribute: fme_powerpoint_placeholders_data
|
||||||
|
Create Slide From |
The choices are Single Feature and Multiple Features. If Single Feature is selected, then each feature will make one slide when styled by this Styler. If Multiple Features is selected, then features will be grouped by the next attribute Slide Group ID, and each group will make one slide. Format attribute set: powerpoint_merge_features |
||||||
|
Slide Group ID |
The id for a group of slides. This can be of any type, and all features given the same id will contribute to the same slide. Format attribute set: powerpoint_merge_id |
Slide Ordering
|
Slide Order Group By |
If this is left as Automatic, then all the features going to the Microsoft PowerPoint Writer will be written to a presentation as slides in the same order they arrive. If a value is provided, then the features will be sorted by that value. Features with numeric values come before those with non-numeric values. If more than one feature has the same Slide Order Group By value, then their order is determined by the Slide Order Within Group parameter. Automatic is actually the same as 0. If some slides are given orders and some are left as Automatic, then the ones that are left as Automatic will be ordered before any positive or non-numeric slide order, and after any negative slide order. Format attribute set: powerpoint_slide_order |
|
Slide Order Within Group |
This parameter determines how slides are ordered when they have the same Slide Order Group By value. If this is left as Automatic, then all the features going to the Microsoft PowerPoint Writer will be written to a presentation as slides in the same order they arrive. If a value is provided, then the features will be sorted by that value. Features with numeric values come before those with non-numeric values. Automatic is actually the same as 0. If some slides are given orders and some are left as Automatic, then the ones that are left as Automatic will be ordered before any positive or non-numeric slide order, and after any negative slide order. Format attribute set: powerpoint_sub_order |
Editing Transformer Parameters
Transformer parameters can be set by directly entering values, using expressions, or referencing other elements in the workspace such as attribute values or user parameters. Various editors and context menus are available to assist. To see what is available, click 
beside the applicable parameter.
How to Set Parameter Values
Defining Values
There are several ways to define a value for use in a Transformer. The simplest is to simply type in a value or string, which can include functions of various types such as attribute references, math and string functions, and workspace parameters.
Using the Text Editor
The Text Editor provides a convenient way to construct text strings (including regular expressions) from various data sources, such as attributes, parameters, and constants, where the result is used directly inside a parameter.
Using the Arithmetic Editor
The Arithmetic Editor provides a convenient way to construct math expressions from various data sources, such as attributes, parameters, and feature functions, where the result is used directly inside a parameter.
Conditional Values
Set values depending on one or more test conditions that either pass or fail.
Parameter Condition Definition Dialog
Content
Expressions and strings can include a number of functions, characters, parameters, and more.
When setting values - whether entered directly in a parameter or constructed using one of the editors - strings and expressions containing String, Math, Date/Time or FME Feature Functions will have those functions evaluated. Therefore, the names of these functions (in the form @<function_name>) should not be used as literal string values.
Content Types
| These functions manipulate and format strings. | |
|
Special Characters |
A set of control characters is available in the Text Editor. |
| Math functions are available in both editors. | |
| Date/Time Functions | Date and time functions are available in the Text Editor. |
| These operators are available in the Arithmetic Editor. | |
| These return primarily feature-specific values. | |
| FME and workspace-specific parameters may be used. | |
| Creating and Modifying User Parameters | Create your own editable parameters. |
Dialog Options - Tables
Table Tools
Transformers with table-style parameters have additional tools for populating and manipulating values.
|
Row Reordering
|
Enabled once you have clicked on a row item. Choices include:
|
|
Cut, Copy, and Paste
|
Enabled once you have clicked on a row item. Choices include:
Cut, copy, and paste may be used within a transformer, or between transformers. |
|
Filter
|
Start typing a string, and the matrix will only display rows matching those characters. Searches all columns. This only affects the display of attributes within the transformer - it does not alter which attributes are output. |
|
Import
|
Import populates the table with a set of new attributes read from a dataset. Specific application varies between transformers. |
|
Reset/Refresh
|
Generally resets the table to its initial state, and may provide additional options to remove invalid entries. Behavior varies between transformers. |
Note: Not all tools are available in all transformers.
For more information, see Transformer Parameter Menu Options.
FME Community
The FME Community is the place for demos, how-tos, articles, FAQs, and more. Get answers to your questions, learn from other users, and suggest, vote, and comment on new features.
Search for all results about the PowerPointStyler on the FME Community.