FME Form

hello,   I have a workspace with 2 tables. these tables are automatically populated. in the translation is a FeatureJoiner (left join) which joins the data from these 2 tables and "moves" it further.. Is it any possibility to stop the translation after running it if one of the input tables is empty(no records)?   Thank you Nicu 

The mentioned database is available under the following url: https://www.opengeodata.nrw.de/produkte/geobasis/3dg/lod2_gml/lod2_gml/ . According to a very brief documentation the database is provided as an ATOM Download-Feed. But unfortunately I don't understand how to handle it in FME and will appreciate any advise. Best regardsAlex

Hello, is it possible to set the cell/column width in a dynamic Excel Writer. I can imagine to precalculate the width for each column or to use a auto mode. Hendrik

I have GeoJason data from USGS site which contains Epoch time such as 1650016756409 or 1649948565590. I tried to read them in either %s$ or %Es% using DateTimeConverter, all failed and cannot convert. I am using FME desktop 2021.2. Please help.

What type of Autocad drawing was used in training that showed road names and other information as attributes. Usually DWG does not have any attribute unless we use AutoCAD Civil 3D etc. I need to tell my AutoCAD staff to provide me CAD data in that same format so I could easily convert the DWG into feature classes with useful attributes directly coming from the source DWG.

Where can I find FME 2021.x Technical Specifications?

Hello, please, I wanna ask. If I wanna export many viewports of DWG in FME Desktop, is there any way how to define which layers will be frozen in each viewports? I need little bit different composition of layers for every viewport. Thanks a lot for tips!Lubo

Will applying the FME Extension for ArcGIS in the FME Integration Console, as an administrator, persist the settings to any user of the machine or is it profile specific? Also, will this cause any user of ArcGIS, on startup, to consume an FME license?

Is it possible to use one a basemap with the MapnikRasterizer similar to the way you can use it in the HTMLReportGenerator

Hi,I have a dendritic river network (lines only) which I would like to use to generate catchments upstream of certain points. I have run the NetworkTopologyCalculator which generates entire river catchments (by assigning all joined branches a network_id which I can then group. But I would like to specify certain segments for which I would like to generate an upstream network. Is this possible?I would like to do this en-masse and have multiple catchments generated, defined by the origin segment id.Thanks

Hi everyone,  I'm still quite new to FME so I'm hoping this is not a dumb question! I am trying to write out basemaps in 3D perspective for a client. The goal is to get a more realistic image by avoiding the orthographic view. However, whenever I try to output the basemap, I get the orthographic view. In 3D view the Data Inspector does give a nice perspective view. Whenever I switch to 2D, the orthographic view is visible. I feel like using the ImageRasterizer transformer (or any other transformer I tried) will force the data into 2D and removes the perspective.  To showcase the desired output perspective versus the current output perspective, I've attached two images: the perspective output (2nd image) is what I'd like! They're just of a rectangular box that has been rotated in 3D. Any tips/ideas are greatly appreciated. A vector-based approach is also welcome!  Thanks in advance.

Our Tenable Security Scanner keeps complaining about the Tomcat version inside FME Server. We're ready to upgrade to 2021.2.5.0 but we want to know if it will solve the TC version issues.  

I would like to build a server app that will use specific folder locations as dynamic choice values. I have the basic values set up as user parameters.the user selects a project name (unc folder location). Then the user selects 1 or more files in a subfolder of the selected project.I used the import button on the choice value/description. the problem is these are not dynamic. The project folder would only show folders that are already created. and the file chooser would only show the one folder used to import the values. there seems to be no good way to accomplish this. After speaking with support it seems maybe python is the only way i am going to accomplish this. However i am at a loss as to how to get started.

I've scoured the help pages and cannot seem to find the answer. I don't want to just copy and paste my python script in to the Startup Python script, I want to actually run the file and config file from FME. Is this possible?

Hi people, I have a list of addresses which needs to be split from 'Street+BuildingNumber ' to 'Street' and 'BuildingNumber'.  I have a file with REGEX that might work on these addresses, so running each REGEX one by one (in top-down order) against my addresses will eventually split the address into Street and BuildingNumber.Once this is achieve, it goes to the next record and try to split it with those REGEX. Is there a way to achieve this? As it is a lot, I don't want to use SQLCreator and put every REGEX in there. Looking forward for any light at the end of the tunnel...

Hi,I have some points (boundary stones) that should be aligned on the contour of boundary polygons. Since the field location accuracy is known to be inaccurate, I want to snap the points to the contour of the polygons.I supposed that AnchoredSnapper was the transformer to do this. And it seems to work fine. However, when I further apply a PointOnAreaOverlayer transformer, although all the points visually seem to be on the polygon contour, some points have 0 _overlaps.when I check the output of PointOnAreaOverlayer some snapped features have _overlaps = 0I was careful to link the snapped output of AncoredSnapper to PointOnAreaOverlayer.What am I missing ?

Hi,I would like to read a json file from an url. Read only the schema and translate the schema to be the main attributes in my workspace. So I'm able to map another dataset onto the main attributes from the read json file.  Example json dataset:{ "json_featuretype" : "ExampleDataset1", "Attribute1" : 100, "Attribute2" : 5, "Attribute3" : 0.7, "json_geometry" : { "type" : "LineString", "coordinates" : [ [ x,y ], [ x,y ] ] } },After reading the schema I would like to see something like this in my attribute manager. I would like to automate this proces and not manually enter the attributes in a attributecreator/attributemanager. Since attributes can be added to the read json file from the url in the future.  I tried reading the json url with the schema reader or the <schema> output port from the FeatureReader but so far I've been unable to translate the attribute{}.name values to be the main attributes.  I'm curious if the FME community has a solution! Thanks!

Welcome to the roundup of FME news for this (and last) week... FME Conference and World TourPreparation for the FME user conference in August is proceeding well.   The presentation lineup is now decided, with folks like Frederic (Using FME to Study/Preserve Marine Mammals) and myself (Raster Algebra and FME) being informed of our acceptance. The training lineup will be published soon, though I can reveal that I'm working on a course on Dynamic Workspaces, including use of the SchemaScanner.  And one other thing I'm working on is an evening Hackathon event. In short, the whole conference is going to be great and there is still Early Bird pricing for a few weeks. As Frederic says, "I'm looking forward to seeing so many of my highly-missed fme-addict friends there." The Safe Software part of the FME World Tour (the Brunch and Learn) is now complete, but registrations are still open! Why? So that you can access all of the talks and presentations from the event.   Othe

how can import ADE in a CityGML LOD3 model

I am currently importing a dgn file into FME and I am trying to filter the cells based on the following attributes igds_cell_name and igds_cell_insertion_x/y/z . With the AttributeFilter one is able to filter based on one attribute, however I would thus like to filter based on the above mentioned 4 attributes , so I can aggregate afterwards the cells that have the same value for the above mentioned attributes. Does anyone know how I might be able to achieve that. I wouldn't want to make use of a TestFilter, since with a TestFilter you have to write manually out all the possible values with AND clauses. That would be too much work for me.

 my department should provide me with data to read by FME but they requires me to choose the format file for the data that FME could read and works at higher performance as excel ,csv ,sqlite ,...etc . other formats are available also .which format from your experiences will be best performance than others ,why ?FME Desktop 2020Thanks in advance.

I have a table of linear sections, each with a unique SectionID. Each section has From XYs, and To XYs. There is anywhere from 1 to N points between from and to, depending on the section.  Right now, each row represents one of these "in-between" points, with a SequencenNumber attribute saying what order they appear in.  My goal is to create 2 additional rows per SectionID. One that is sequence 0, and populates the regular X and Y fields with the From XY values. Another that is sequence N, where N is the highest occuring sequence number, plus 1, that populates the regular X and Y fields with the To XY values. I can re-order them afterwards with Sorter if need be, but they need to be in order both by sectionID and sequentially so that LineBuilder draws them properly. I know I can group by SectionID in LineBuilder as well.  I'm a bit of an FME noob, so any help would be appreciated! I really can't think of what transformer or workflow to use to make this happen!

I have an attribute that contains a string with 1 or more comma separated integers. The range of integers is 1 to 13. Here are some example values:102,3,57,8,9,103,25,6I need to replace each integer with a text value that I've looked up from a table such as an Excel file. I know how to use the DatabaseJoiner to look up values, but I'm not sure how to process a list of lookup values. Ideally, I'd like to sort the integers before looking up the text values. For example, "3,2" would be "2,3" before the lookup. I'd also like the option of separating the text values with a new line character instead of comma. Is what I'm trying to do possible with FME Desktop?

Hello! I have not been able to figure out to generate polygons from the roads that are of intresest. What I need to do is to generate a polygon from all points that are within 3000 meters from "from_point". That park work fine. But when I try to genereate the surface it doesnt follow the lines good enought. It's to generalized. Please se the PDF to see what I mean.  How do I generation the surface so they follow my routing better? For this task is very important because the roads are filtered only to use safe roads to my target group. With the results I get now from hullaccumulator sometimes points will be inside the polygon even tough they should not be.  Only the points that has 3000 meters or less should be included in the surface. Can anyone help me? Best regardsJesper

Hi all, I am trying to filter and extract rows from dataset A based on partial and exact match to values of dataset B. Dataset B will be different each time I run the workbench.B is actually a subset of A, generated from a separate query as part of another process. So There will always be an exact match, but there may or may not be partial matches. Where partial matches are found it will be in the form of a suffix to the ID (eg ‘v1’ at the end).My reading of this forum suggests there are two issues that make this filter more complicated: 1. dataset B is an output of another query so the values will always vary2. I need to extract instances of partial matching as well as exact matching. example:dataset A (n=4000)IDMRR_1234v1MRR_1234v2MRR_1234TR_5678TR_5678v2FG_9876 dataset B (same table structure at B, n<20)IDMRR_1234TR_5678 i want an excel output of dataset A, that contains only the rows where the ID contains that of the ID field values for B. Attribute only, no geometry. In the exa