This method will store a constant value instead of supplying an attribute. To fix this, right-click the cell and choose Open Text Editor, then type in the name of the column. Notice that if you type "Department" or "Cases" into the Column Name, FME will automatically choose the attribute value instead of a constant. Under Column settings, we'll create two columns, one for Department and one for Cases.
#Kml to csv area update#
Your dialog should look like this:Ĭlick the cell under Header in Page Contents and select Table from the drop-down:Ĭlick somewhere under Content Settings to update the parameters for a Table block. These settings give us a header with the local area name in each section of the report. For Text, choose the Local Area attribute. From the drop-down, select Header:Ĭlick somewhere under Content Settings to update the parameters for a Header block. This table is used to add elements to the report. Next, click where it says Chart (Bar) under Page Contents. Doing so will tell the transformer to create a section of the report for each local area separately. Add an HTMLReportGenerator and connect it to the Summary port of the StatisticsCalculator:ĭouble-click the HTMLReportGenerator to open its parameters. We want to add it after the StatisticsCalculator, so it uses our summarized data, but we don't want to write out to CSV.
To create an HTML report, we will use an HTMLReportGenerator. You can also use the Open Containing Folder button and open localareas.kml with Google Earth if you have it installed: Once the translation is complete, click the Inspect button.
Once your KML reader and writer feature types are connected, click the KML writer feature type. This part of your workspace should look like this now: Click and drag to connect your KML reader feature type local_areas_region to it. Type in local_areas_region as the name for our writer feature type.Ĭlicking OK adds the KML writer feature type to the canvas. The feature type parameters dialog will open. Your dialog should look like this:Ĭlick OK. In the next exercise we'll be connecting data from our summary table to this writer feature type, so we chose Automatic for our feature type definition. Enter the following: Writer FormatĬ:\FMEData2018\Output\Training\localareas.kml Click Writers > Add Writer, or press Ctrl + Alt + W. Next, let's add a KML writer for the local areas. When prompted, select only the "local_areas_region" feature type this is the layer containing polygons of the local areas:Ĭlick OK again to add the reader. Note: You can also access the data locally at C:\FMEData2018\Data\Boundaries\LocalAreas.kmlĬlick OK. Click Readers > Add Reader, or press Ctrl + Alt + R. 2) Add a KML Readerįirst, let's add a KML reader for the local planning areas. Alternatively, you can open C:\FMEData2018\Workspaces\IntroToDesktop\. Start Workbench (if necessary) and open the workspace from Exercise 3.3. We will also use a transformer to generate the HTML report. In this exercise, we will add a KML reader feature type, a KML writer feature type, and an HTML writer feature type. This task requires adding additional readers and writers to our workspace. You have decided to create an HTML report with tables and charts and a KML ( Keyhole Markup Language, a spatial data format used by Google Earth) map to share with them.
0 kommentar(er)
