FME Form

I have a FME worbench that is reading an excel file and merging it with data in a SDE geodatabase. For each record in the table I need to create an ID field that consists of a consistent initial 3 letters depending on the company, then a 2 digit year, and then 4 digits. It would need to be unique as well. I would need to find the last 4 digit number used by the company and add one to it.I would then need to put this all together into one ID field attribute. Any ideas of how to do this would be appreciated!

I have set up a very simple reader/writer combination that reads an ArcGIS raster from a file geodatabase (File Geodb Raster Dataset) and writes the raster to an ArcGIS Enterprise SDE SQLServer database (ArcSDE Geodb Raster Dataset). This operation fails repeatedly with the message:  “Failed to write raster data tile when writing to raster dataset 'r1_max'. The error number from ArcObjects is: '-2147155566'” I am able to successfully write the raster to a different file geodatabase, and am able to successfully write vector layers to the SDE SQL Server Dbase, so my database connection file is correct. This same error has been referenced in other postings, but I have not seen a solution that resolves the issue. Any help is greatly appreciated.Software versioningOS: Windows Server 2019SQL Server Enterprise: 15.0.2080.9FME Workbench:  v2020.2.1ArcMap:  v10.8.2

In the FME Server I have an Automation: FTP Watch. This checks on a regular interval (15min) to see if the ftp directory has changed. If it detects a CREATE event, it will call upon my workbench. In the workbench I try to download the file from the FTP server to a network server. Sometimes I have no problems, but other times I get a Time-out error. These are my connection parameters: I never have an issue when there's only one new file. It's always when there are multiples. Does it have something to do with the amount of connections? Should I manually close the FTP connection after each run? Thanks!

I have a string in a attribute. At the end of the string there are brackets containing one or more words. I would like the contents, including the brackets to be put into a new attribute. Ex:Attribute = "cat mouse (cheese crackers)"Desired new attribute = "(cheese crackers)"NOTE: sometimes there is one, two or more words with in the brackets, and I want all of them in the new field. Using a RegEx (\\(([\\w]+( [\\w]*)*)\\)$) I can select that portion of the string, but I don't know how to put that portion into a new attribute.  Currently I have an AttributeCreator with Attribute Value = @FindRegEx(@Value(Attribute),"\\(([\\w]+( [\\w]*)*)\\)$")but the result is not the string, but numbers.  Thank you in advance for your time.Julia

Hi All,I'm attempting to take a table that has 600K+ rows that have an individual value for a type of utility per location in it, join/merge the up to 8 values into one row to be able to join to another feature class at a later date based on the location unique id. I've tried aggregator, feature merger and feature joiner. Nothing is giving me the desired results. I've used the aggregator to get the unique location id, then used feature merger or joiner to attach the additional columns to the one location id. Tried to create the list, still not getting desired results. I get only one filled in. I've used testers to put yes in the named utility column based on the code type, and then where the values remained missing/null, I used the NullAttributeMapper to change them all to N in order to concatenate the data and get all columns accounted for, still missing some of the values.It's likely something that I'm overlooking, but have been working

I am reading in a CSV file. I need to reference the first cell (Column MA and row 1) and extract the date and time from this cell, and use these two values to populate two new columns - Date and Time, and add these two new columns to my output along with existing columns such as MA, 1, 2, 3 from current CSV files. I like to get hep on how to reference and extra the cell value, and then add the two columns through AttributeManager or AttributeCreator. Thanks in advance for your help.

From this Q&A;: Geometry Template, problem getting list attributes when using variable for indicesIn fact, I've never used Geometry Template in the XMLTemplater, but I noticed that the GUI of the transformer won't recognize a Geometry Template when testing a solution for the question above. This configuration works as expected, but the property button is still red and the tooltip reports that "GEOM" does not exist.

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.

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

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