Transformers

Hi All,Hopefully an easy one. Using the leaflet map option from the HTML report generator. Is there a simple way to position the maps centrally instead of width 100%? Thanks

Hello,  I send 2 shapes each containing a fully populated field for each record in an AreaOnAreaOverlayer. I get a shape with the table below.Each of these 2 fields comes from one of the 2 shapes. I do not understand why not all records are filled in for each of the 2 fields ?  Thank you

I have depth zones where there are some square-ish polygons that once where covered by depth labels. These labels are no longer used and the square areas have become an eyesore. They are not terribly important so I would like to remove them all together. Please note that there are other areas and donut holes that should not be touched.  My question is twofold:* How do I mark only the square-ish areas? (for later deletion)* How do I mark only the square-ish donut holes? (to be closed with donutbuider) 

I tried to provide 2 phone numbers separated by a comma but it looks like it just removes the comma resulting in 1 long numeric string - which fails. Also tried with the full +1... in front with comma and space and same thing. It parses out all non-numeric characters/spaces. Is it possible to adapt the transformer to allow CSV?

Hello, i'm new in FME. I don't know how to transform .rvz BIM data into 3d-tiles cesium.js format. I use FME-revit plugin to convert the .rvt to .rvz. Next, I add a reader in FME to read the converted .rvz data(IFC). Then i add a transformer(writer) to write the data into CESIUM3DTILES format. But the translation failed.

Hi, I am trying to get the footprint of multiple rasters that are stored in the same directory.I am using a Directory and File Path names to read the directory and the RasterExtentsCoercer transformer to generate a shapefile with all of them.But only works when the reader is a single raster.Any idea? Thank you

hi, i read some question from other user. But i don´t read what i need.from to xml i create vertex and i don´t know what i do to create the raster. i use "imageRasterizer" but i have a error and no create it. is the log file.

I am trying to use the SQLExecuter to identify records from an archived ArcSDE database where the ID does not exist in another table by utilizing the _matched_records output. My SQL Statement is this:Select SCRD_ID from gis.STREET_CENTERLINE where SCRD_ID = '@Value(SCRD_ID)'I know that SCRD_ID: 3745 does not exist in the STREET_CENTERLINE table, but because this data is archived it is coming back with a _matched_record count of 2 instead of 0Does anyone know how to only read/query the CURRENT data from the ArcSDE database?

Hi everyone,Here a newbie queston. I want to duplicate a shapefile 18 times (instead of manually duplicating the shapefile) and then attach information from 18 tables to those shapefiles based on the key value: NamePark. I tried the Cloner, however then instead I got a shapefile with so many features, so I was wondering what to do insteadSo basically I have two questions:1) Is there a transformer available to copy/duplicate a shapefile X times2) How can I join the tables to the shapefiles based on a key value. I looked at featurmerger, but I cant find the key values.  I have attached an image of my current workflow

I am using FME Workbench 2018.1.0.1 in Windows 10. I am inputting a kmz file. The only parameter I am reading from it is PLACEMARK because I see no reason to read the others. I need to copy format attributes kml_name and kml_description to NAME and CAPACITY, respectively. I don't see in the AttributeCopier transformer where I can do this. Its Import Wizard does not seem to be made to do this

I have two string fields (TimeStartedCTZone, TimeEndedCTZone) formatted as shown below. How can I calculate the difference in Hours despite having strings as inputs instead of datetime data types?

In 2016.1.1, when trying to add 10 hours to a DateTimeCalculator I receive the following error:DateTimeCalculator_DateFormatter: @Tcl2 -- failed to evaluate expression `DateTimeCalculator_DateFormatter_formatter {FME_NULL_VALUE}' -- wrong # args: should be "string range string first last"  What am I doing wrong?Screenshot seemed to fail upload.Attribute(encoded: utf-8) : `Last_edited_date' has value `20180601010111'

I have a script which is fetching multiple images with an imageFetcher. Sometimes the external services stops responding and the script never stop running. See pic attached showing the last rows from the log.To avoid building a never ending queue I would like to limit this specific script to 15 minutes but I don't find any built feature. I have tried some python callers like timer and time.sleep but nothing really matches the requirement.Any suggestions?

Hi, I've been racking my brains trying to think of a solution to this problem for a few days and no inspiration is coming my way! I have a series of polygons containing populations. The goal is to create bigger polygons from these until they are all within a certain range of population (e.g, between 2000 and 10000). It does not matter if these become multipart polygons.I have used Dissolvers and Aggregators to combine where polygons are touching, however sometimes the populations in the resulting polygons are either: too big (where there is a large cluster of intersecting polygons) or, too small still (because they are not intersecting any other polygons).I have thought about using some form of looping transformation where there are iterations of joining polygons together until the population range is met, then filtering those out and performing the loop again with the remaining polygons.Sorry, it's a bit of a specific question - but if anyone has any ideas around this I will b

Hello Everyone, I have a network of local roads and I need to find the intersecting "from" and "to" streets for select road segments. For example, in the following image, for the circled segment of Hendon Ave, I need to be able to identify that the segment goes from "Grantbrook St" to "Carney Rd". Order doesn't matter. It could be from Carney Rd to Grantbrook St. My network is fully segmented at each intersection. Each segment has the attributes "from_node" and "to_node". The image below shows a typical segment within the network.I am having a hard time identifying the "from" and "to" streets. I tried using spatial relator, which successfully gives me the related candidates. But in a case like this, I will get 4 related candidates. I considered using linejoiners to join Street B and Street A, but I will lose the from_node and to_node information. That information is useful when I have more than 4 relate

This is more to document the trials and issues I encountered writing from a file geodatabase of polygons to an SDE instance with polygons. While one would think that polygons stored in one ESRI format would be fine when written to another and not need validation, that is not the case. Here are the issues i encountered when I switched to FME to find and bypass a bad feature that killed my dataload because of a tiny nearly collinear triangle with area of 1x10^-20...First I tried to just insert straight from GDB to SDE. This gave me the error:An error occurred while attempting to insert a row into the table 'PARCEL_DATA' using a cursor. The error number from ArcObjects is: '-2147215968'. The error message from ArcObjects is: {Linestring or poly boundary is self-intersecting}Then I tried to run geometryvalidator, with these settings, sending both passing and repaired polygons to sde. This gave me the error : Cannot write a non-area feature to an area feature classFurther in

I'm using SQLExecutor to fire queries like this at an SQL Server Spatial point layer (Geometry data type), except the polygon geometries are much more complex:SELECT Count(MyField) AS CountMyField FROM [db].[owner].[table] WHERE WKB_Geometry.STWithin(geometry::STGeomFromText('MULTIPOLYGON (((527049.5 137150.4,527056.6 137139.7,527063.3 137134.4,527049.5 137150.4)))', 27700)) = 1However, after about 2400 features have entered the Initiator port, I get this error and the translation fails:"The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found."Ultimately I will be processing hundreds of thousands of features so I need a solution that will work with that volume of data, not just a few thousand input features.I know I can read the point layer in to my Workspace, but SQLExecutor is SO much faster.Any suggestions?

Hello, Internal auditors are asking me whether any data that is read into FME via a reader is ever detailed in any log files. Does anyone know whether this ever happens? I'm assuming not, but thought it best to check.This is not referring to statistical data that Safe may collect, but data sets we read into FME. Thank you,Daniel

Hido you know if it's possible to replicate the action Collapse Dual Lines To Centerline in Arcgis also in FME.  I tried the centerline repacer but it works with polygons but I have lines not poly (and I don't want to convert lines to polygons).  Can you help me ?  thx  Francesco

Hey,i like to transform NAS Files ((German AAA GML Exchange Format(NAS) OpenData like fachinformation_11001_dba.xml) in a shapefile that can i open with a GIS program.In total, i have 65 NAS Files, the problem i got is, i need for every file a new reader and writer, is it posiible to transform the data with one reader and one writer ? The filename can be the same, like this...fachinformation_11001.xml ----> fachinformation_11001.shx (simplified)Regards Kai 

Hi all,I want to replace not equal to "0" to "1" and if any value missing replace to "0" OriginalAttribute1Attribute2Attribute3Attribute4Attribute5Attribute6Attribute7Attribute8231212301235650 231230231000031240000370232102312234340000320001220023232123120127700   Expected result Attribute1Attribute2Attribute3Attribute4Attribute5Attribute6Attribute7Attribute8110110010100001000011010111000010001001110110000 Please advise

I have a date field called 'Date Started' and a text field called 'Time Started' in military format.Based on those two, I'd like to create a new column called 'Date Time Combo' (shown above) in the following format: mm/dd/yyy hh:mm AM/PM.What's the best method to achieve this?

I have created a sample table below of a much larger dataset.I want to be able to group each ID and then be able to compare the New and Old Values to see if they are the same, in some cases the order is wrong, or there is a semi colon and space or there are duplicates. How do I clean all this out, so that I can make a more accurate comparison of the two columns?

Is there a way to detect parallel lines in a road network and simplify the parallel segments to one main line as shown in this picture? I've tried this with the FuzzyParallelLineFinder but it didn't work and the performance was very low. Thanks in advance. Steven Loosman

Hi, I´m currently struggling with retrieving a Published Parameter via a FMEServerJobSubmitter. The Published Parameter is a Attribute Value, which I have run through a StringConcatentor. Either the parameter can´t be found, or I end up with the Parameter Name as textstring. In short, what I´m trying to achive is to fetch the File-Name of each .txt I produce in one of my Workbenches. This is to allow my next workbench(Via a second FMEServerJobSubmitter) to find the files under the temp Folder. Everything is handled in one "Control"-Workbench. I have also tried to fetch the file Name(path_rootname) via a Feature Reader, without any luck.  Overview of the "Control Workspace" The first FMEServerJobSubmitter and Example issues with Published Parameters According to the log in FME-Server, the File Name can´t be found. Please also see log-File(). I just can´t get my head around what to do. I´m sure some of you smart people have some super intelligent advice to share.