Transformers

Hello, We use an FME Web app to upload a single file to a workspace for subsequent processing. Is there a way to submit multiple files to the workspace at the same time without having to submit them individually ?

I have flatten xml file, and some data are missed. For example <p>Свободная ёмкость — <b>627 млн.м<sup>3</sup></b>        <span class="up">11</span></p> it should be 627 млн.м, but it skipped and only values 3 and 11 are in place. In xml ex1 i have highlighted items which are missed in xml example.png. Also attached workbench.

Hi, we have 3D polygons inside the database. Now we wanna convert them into Multipatch. Oracle support this kind of geometry.I did it by using FaceReplacer.Inside the 3D polygons we have already some kind of splitter elements (area<0.0xxx). Is there a way like Simplifier or Dissolver to unify these features? That we can eliminate these elements during the process to create Multipatch features.Furthermore it seems that after multipatch generation there are some gaps between the elements:  If the 3D polygon is closed uand after using face replacer it should be closed too right? 

Hi, I need an easy way to split a string at a desired lengt, but I want to avoid splitting words. There once was a WordWrapper but it's not working anymore. Any suggestions?

Hello everyone, I have a dataset contaning several polygons, with sometimes hundreds of vertices and one containing lines, each polygon is paired with a line by a unique ID. I am looking to build a workspace that reads the coordinates of each polygon vertex, projects them along the corresponding line and then calculates the two projections futher down each side of the line or its extension and returns their coordinates. I have used VertexCounter and CoordinateExtractor or CoordinateConcatenator to get the number of vertices and their coordinates and I have a workspace that can calculate the projection of a point along a line, but I am having trouble connecting the two through a Custom Transformer Loop to cycle through all vertices. Any help would be appreciated. Feel free to suggest any improvements to the overall thinking process as well.

I am running into a issue with OffsetCurveGenerator. There are some instances where it drops nodes from the original linework and breaks the output line into an aggregate, I assume this is beacuse it folds on itself.The uppermost grey line below is the original. The green lines are generated offsets at various distances. Note that the one at the bottom has lost a vertice towards the corner. The linecount coming out of the transformer is correct, but if I run a deaggregator, the total number of lines has increased. As the red line illustrates it has split at the corner. This is not an issue in most occurrences, but I want to run some Snippers on the start and end vertex downstream and the Snipper treats the lines as if they where deaggregated. I tried working around this by first running a Deaggerator followed by a LineCombiner. But if I do the lines sometimes flip their original direction (depending on the order in which it was rebuilt), which results in the end vertex

We have tried using FME but it always generates an error saying that it "Could not open File Geodatabase dataset". Below is the log error: FME API version of module 'FILEGDB' matches current internal version (3.8 20210302) Geodatabase Error (-2147024893): The system cannot find the path specified. Could not open File Geodatabase dataset `C:\\Users\\guillermo.rendon\\OneDrive - SYSTEMWARE INC\\Documents\\PCS\\Database Tables\\SYSAPP1CLONE copy of PCS database\\SWIS.GDB' for reading FILEGDB reader: A fatal error has occurred. Check the logfile above for details Failed to obtain any schemas from reader 'FILEGDB' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information FME Session Duration: 0.3 seconds. (CPU: 0.0s user, 0.2s system)END - ProcessID: 23880, peak process memory usage: 44604 kB, current process memory usage: 44120

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

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.

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.

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.

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

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

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 wa