Transformers

Hi there. I'm looking to add grid locations (GRID_ID) from a polygon feature class to a line feature class dataset in fme, but it does not seem to recognize the start and end of these lines, thus leaving the GRID_ID's the same. There is a lot of transformers and things going on in this workspace, but the two bookmarks are essentially duplicates, just different grid polygon datasets used.

I have an input table that looks like this(input table):Important here is that this table can change in terms of number of rows and names. So the next time the model runs it could have 5 points or 10 or 1, with random names. Names are never duplicated. Based on the input table my fme model then creates an output table as this(table2):I want to create a new table based on the same parameters, with a schema like this(table3): So each row in table3 is a unique date form "DateProcessed" and each value from the coulumn "Name" from input table will get an own column in table3, containing the corresponding DistanceToIce value. The tricky part here is that I want this to happen dynamicly, so that the number of columns that will be created in table3, and their names will follow the input table.  The data will never get large, maximum 10-20 points/names and 14 dates. So recreating Table3 from scratch each time the model runs would be fine. Have read a couple of other answers

Hi, I have some problems to write some georeferenced data to a SKP-file.I have read a lot of the questions regarding the problem with coordinates and Sketchup. My data is a KMZ-file which i convert to a SKP-file i FME. Make som changes and the export i back to KMZ from Skethup.  What i´ve understand, the "Move to Local Coordinate System: Yes" should move the origin to the center of the data. However, when I look at the data in Skethup the axis is at the edge of the dataset. And to confirm the lat/long under "Model Info"-"Geo Location" is the exakt point of the axis. So for some reason the origin isn't in the center of the data.: When I export the data from Skethup to a KMZ, the data have moved a few meters and isn´t i the right place anymore. So one of my thougts is because that the origin isn´t in the center, that might have something to do with it.  Is there any explanation to why the origin isn´t set in the center of the data (why it happens)? And c

I used basic steps to add new Annotation FCL as target feature in FME Workbench:In ArcGIS Pro 2.3Create FGDB Add only one new Annotation FCL with only system attributesIn FME 2019.1.3.1Add new FFS Reader with reference to FGDB (GEODATABASE_FILE)Import feature class from datasetFrom the table list, chose newly created annotation feature classConfirm Import on OKCRASH!In Windows 10 Event Viewer I see following messages for each crashDoes anybode have an idea what can cause such problem?

Hi guys, I have the following attributes:783784AYHI would like to add 1 in front of any attribute starting with 7 and avoid adding to another field. What would be the best transformer to use for this? I have tried and tested the stringpadder but can't seem to get it working. Any help would be great.

Hi I tried Change Detector & Update Detector to compare records in 2 tables based on a unique key. Lets say input tables have 10 attributes in unchanged port output of change detection I get few records but attribute value of all except the unique key specified for comaprison is NULL. Is there anyway I can get attribute values in unchanged port as well As I need to do further processing based on these attribute values of Unchanged records.

Hello all,I have a TestFilter that directs my input data into multiple branches for further transformation and I have dozens of test conditions within this TestFilter, similar to below:If Test condition @Value(field1) = A to Output port 'Road'Else If Test condition @Value(field1) = B to Output port 'River'Else If Test condition @Value(field1) = C to Output port 'School'etc, etc..... Is there a way i can then use these port values to replace the original input attribute value for this field? For example: Replace all attribute values of 'A' with 'Road'Replace all attribute values of 'B' with 'River'etc, etcI'm trying to find a way of avoiding having to create dozens of repetitive transformers after each port to make this attribute value change and hoping to reuse the effort made thus far with in creating the existing TestFilterDoes anyone know if this is achievable?TIA,R

For a customer, I am upgrading a FME 2015 Workflow to FME 2019. At some point, an FFS file with measures is written. In a later stage, it is read with a FeatureReader. It still contains the Measures, 0 for the starting point, 100 for the ending point. After passing through the Rubbersheeter, they are lost. The customer still has older versions available. It still works in the 2016 and 2017 versions. From FME 2018.1 (I do not have the 2018.0 version) onwards, the rubbersheeter does not output the measures. However, it is not possible to upgrade the transformer. It still has the same name. In the 2019.0 version, you can upgrade (adding the group by possibility), but the measures behaviour is still the same. Anyone else having this problem?

When I use the PointOnAreaOverlayer and the LineOnAreaOverlayer on FME Desktop 2019.1, the resulting _overlaps appear correct.When I set the 'Group by' option to group by an attribute on the either the PointOnAreaOverlayer or the LineOnAreaOverlayer, the resulting _overlaps is set to 0 for all features. @steveatsafe

Hello,I am trying to geocode some addresses. The input is excel. But I don't want to use available geocoder services. Instead, we have our own geocoding API key. Is it possible to use it through any of the transformers?

I'm sure the transformer is somewhere, but I simply cannot find a transformer that would accept stream of features with attributesvalue to calculate..and it would calculate this value into the designated field.  Example: I have a statistic calculator that I need a _max value from. I want to feed this value to all the records in the stream into a field _max. I will then use the counter to assign the ids.How can I achieve that?Thank you  

As stated in the title,I want to compare two schemas to see if they have duplicate field names.My idea is to use the Change Detector, but i do not know how to expose field names from an reader Any thoughts?  

I have an Excel Sheet where I need to find Arabic Words and separate them.For example, I have data like this://olyservice/GIS-TANSIQ01/Storage/46-????? ????? ???? -????? ??????/???? ????? ??????? ??????????????? ???????? ????????.rar//olyservice/GIS-TANSIQ01/Storage/111-????? ?????? ??????? -/Layers.zip //olyservice/GIS-TANSIQ01/Storage/100-????? ????? ???? -/????? ????? ???????? ??????? ?????????? ???? ????? ???? - ????????.rarI'm looking for:1st column: ????? ????? ????2nd column: ????? ??????3rd column: RARIf there is no ????? and ????? words, the columns should be blank.Is there any transformtion and formula which i can to get the information ??

What I want is to detect (new) buildings from a aerial photo. I have a 7.5 cm resolution aerial photo. Furthermore, I already have a large dataset with polygons of buidings (around 150.000 buildings). Can I use this dataset to create an annotation file for the positive samples to use in the RasterObjectDetector?  And can I also create negative samples by taken regions from the aerial photo where no buildings are located?

I have Google Spread sheet for project Managemnet .. what I am trying to do is end of week i get the Value from one specfic column and add on week Number Im attching the week FLow where you get the idea what extacly im looking for  i just need get percentage from Sheets  

normal reader is used not feature reader because i need to reproject data first . result writing 1000 record takes around one minute . also resources of server are almost taken by fme engine

Cloner, duplication issues after 10,000 rowsMy issue is, my 'source' dataset (6,600 rows) needs to clone each single row 54 times, example - Row '2' is cloned 54 times so the 'output' has 54 identical rows of '2' (to then later be transposed..etc..); I have noticed once the completed 'Output' dataset reaches 10,000 rows it starts again from the top (row 2 of source again), so row 2 has 54 correct clones and then it repeats again at 10,002, 20,002, 30,002 etc......  The issue: Original row 2 repeated again at row 10,002    Simplified set-up: Hope someone can help? regards, Richard

Hi,I have 2 shapefiles. One file contains road names and another contains locality name. In Road name file the names contain Locality names as well. is there any way I could identify if the names of the locality file. is available in road name file Please note that the words may not be exact. Here the reference file is locality and the target is road file. Any help is well appreciated. Thanks in advance

Input: Several .Las and one SHP file with several segments. Objective: trim the .LAS using the shp segments. Could exist more than one segment covered by the same .LAS. Buffer 0 and square.Output: .Las trimed by the shp file segment and with the SHP file segment attribute name

I am trying to label a grid I have created, the Y axis should be the elevation and the X axis is the station along the centerline.I have the above grid writing to model space in AutoCAD, I think I can get the labels on the X axis but the Y is proving more difficult here is what I am trying to do. See below.

Hi! I've been struggling with this task for a while now and need some help. I have a set of 2D lines (sewage lines if anyone is interested), with a "_lineID" attribute. I also have set of known 3D points on those lines. Some are on end nodes, some are on a vertex. These points also have the corresponding "_lineID" attribute.  Now I want to use these known points to get the lines into 3D, interpolating any line vertices in between which doesn't have a known height. However, I'm having problems with this.I've tried to implement a NeighborFinder with a Group By: _lineID to help where there are points located in the same XY position, only differing in height (see attached screen shot below - the yellow dot is actually four points in the point file, each with a different "_lineID").  This is followed up by a 3DForcer. This part works fine, but I can't manage to re-build the lines again (using a LineBuilder) since there are now both these 3D

I'm trying to create a multipage PDF with one map for each "delområde" (=part of area) in a city on every page (along with text information later as well). My problem is that both map extents and text do not fit in correct in the frames. I want my map extent to fill out the whole frame as defined in PDFPageFormatter. This is probably an easy task but this is the first time I'm working with pdf's in FME so I feel like I'm missing out on something. As far as for the text, I just want them to be centered in the frame "Delområde". The text is created with TextAdder from the same data as the map extent, which means it still has the geometry and therefore I guess that they are spatially distribuated across the page according to their geometry. Thanks for any help!!

I have a workbench that writes three mapinfo tables to a folder on one file server which I then want to filecopy the mapinfo tables to a folder on a different file server.I think I've got it to work, but I wanted to confirm.I use three FeatureWriters to write the mapinfo tables to a folder on the first file server. Then all three FeatureWriters go to a single FileCopy transformer.The parameters for the FileCopy are;Destination File Copy Folder = folder on first file serverfilecopy_source_dataset = folder on first file serverfilecopy_dest_dataset = folder on second file serverfilecopy_dest_filename = <blank>Is this correct?I have the address of the first file server in twice, once for the Destination File Copy Folder and again for filecopy_dest_dataset. Do I really have to enter this twice?filecopy_dest_filename is blank, which means I get a red arrow. But it runs anyway. Should I really leave this blank?It all seems to work, but it feels like I have not configured it correctl

Hello. I have a b/w raster with only one band but in each band there are 255 palettes with a RGB combine each one. Is it possible extract each combine like a RGB combine value?Thanks a lot.This is the example of the issue.

Hi guys,Is it possible to extract a list of PDF document path and filenames from an O365 Sharepoint folder as you would with a normal network drive?? FILE/PATH Transformer Eg, Date, name, File Location, etc....I can't seem to get this to work with a copy of the share URL for the folder. Maybe there's another way. Thank you.Tim