Transformers

Result unexpected by Static Calculator i have A B C Columns,each column has different years so i want to count how many year duplicate or not in each column and sum the count attribute at the endso i should do count and sum for each column A B C and get table as result for 3 column in one table beside eachother .so what i did exactly i used 3 static calculator and each one i defined count and analyze to attribute and output of first a input for second and output of second as input for third but i found the result is incorrect but if i used two static calculator ,the result is erfect but only for 2 columns but i want to do for 3 column .then i used aggregator to sum the countDoes we have a way to use one static calculator and do sum for 3 columns and count once a time i want to count each the first 3 columns for year and get the sum of each count but i do not want to count empty cell if exist.Thanks .Thanks

I have two datasets which need to joined. Both datasets store the attributes 'CI_nummer' (numeric) and 'NaamObject'. An example value of the last looks like: ZN VKS MSI A16L 46,935 1I want to join the datasets if both these attributes match. . Beside this, the NaamObject also needs to match for a certain minimum of characters. ZN VKS MSI A16L 46,935 146,935 these numbers represent a distance value. 46 kilometres and 935 meters. When the difference between two distance values (dataset A versus B) is less than 500 meters I want FME to see these values as identical. For example:These two values should be considered as identical:ZN VKS MSI A16L 46,935 1ZN VKS MSI A16L 46,835 3 These two values should be considered as identicalN VKS MSI A16L 46,935 1ZN VKS MSI A16L 47,122 3These two values should not be considered as identicalN VKS MSI A16L 46,935 1ZN VKS MSI A16L 48,122 3I am thinking about something with a regular expression? Any ideas how to solve this issue?   

I am confused a little bit about TesterSo I have two questions about tester :At first :i have attribute and I want to write for the same attribute around 15 field ,if contains then pass .As example same attribute ,if contains v ,passed . So I have to write 15 times for same attribute , and it is too much ,is there easy way to give tester once a time to pass .if conditions occur . Second Question :I have around 100 field ,in Attribute named building ,I want From tester to check if Name includes as example sam , then pass with another attributes but I does not want to change the name of building every time from the parameter inside tester , I have too many names for building and I want to do excel file out my workspace but as input file inside my code and I change everytime in excel file ,the name of building that I want to pass with another attributes then I got my result only include this building name and another Attributes. Thanks in advance  

I have a question similar to this. However, following and reading the links, it is not addressing my task, so far I can tell.I have a million lines, which I need to analyze to a line density raster, usually done in ArcMap Spatial Analyst Line Density function. The function needs to: 1) take in input lines, 2) adjust cell size, 3) search radius, 4) area unit. I can do it ArcMap, no problem, but as the analysis task is a part of a longer data extraction and modifying process in FME Workbench, I try to keep it there.

Hello,I have a shapefile of points and 103 rasters. I wanna overlay the points on the 103 rasters and extract the values to attributes. The final aimed result is the shapefile containing 103 additionnal attributes with extracted values, I want also that attributes have the same names as the rasters. Is there any way to do this batch process ?I tried to load all the rasters into the PointOnRasterOverlayer but it seems that it connot do a batch process but work only on a single raster at once.Thank you very much.

Hello All,I am trying to follow the documentation in the Electric Migration Tools V1.zip that comes with the Electric Utility Network Migration Tools. There is a section in the documentation called "Import additional associations and rules to the Asset Package" that states that the Append command should be used to append the AssetPackageAdditions.zip to the Asset Package. I tried looking at this article: https://knowledge.safe.com/articles/32670/combining-multiple-streams-of-data.html but it doesn't seem like it has instructions to perform an Append. My question is how to use the Append command as the documentation states?

HelloFirst off all, I'm sorry for my English.I'm working with annotations with different textsizes, rotation, horizontal- and vertical alignments in ArcGIS Pro 2.1.3. I have to import and export this annotations to another format (Interlis) as a point feature class. ArcGIS Pro uses a different annotation format (compared to ArcGIS for Desktop).I can import a file to the file-geodatabase in the "old" annotation format (ArcGIS Desktop) and then i can upgrade it with python. So that's not a big problem.But I can't export the annotations. The File Geodb reader doesn't recognize the annotations of ArcGIS Pro. With the Open API reader, I can import the annotations as a polygon. But i need a point and the point doesn't have to be in the center of the polygon (alignments). Is there any workaround? I'm a beginner in FME. Or are there any plans to implement the support of the ArcGIS Pro Annotation? (How long does it take?)

What does EXTRA_POLYGON_FEATURE mean in PointOnAreaOverlayer?I've added a SpatialFilter on the Area dataset to reduce the number of unnecessary area features going to the PointOnAreaOverlayer and suddenly I get a load of rejected features out of the PointOnAreaOverlayer with EXTRA_POLYGON_FEATURE as the rejection code.It would be nice if the documentation gave some explanation of the codes rather than simply listing them...Update: This is in 64-bit FME 2018.1 on Windows Server 2012 and was using PointOnAreaOverlayer version 7. I upgraded the PointOnAreaOverlayer to version 8 and it worked, so presumably there was some bug fix in the new version of the Transformer.I'd still like to know what the rejection code means though.

Is there a way to create an Excel formatted table with FME? I can create only a named group of cells using this sintax in xls writer sheet name parameter : <sheet_name>/<group_name> as showed below Thank You

Hi guys, I have a small question which could probably be solved easily.I have 20 datasets. Each of these datasets needs to be given a new field called 'Trajectnaam'. This was done using 20 attribute creators.. this could be done easier I guess? This field needs to get the name of the corresponding dataset as value for each dataset respectively. Is there an option to enter the name of each dataset as new attribute value?Finally I want to merge the 20 datasets into 1 dataset with 20 lines.Thanks for your help!

Hi I'm calling a json api, that gives several geometrys. I can succesfully parse the json to kmz and see the features. Unfortinatly there are examples, where multipoints are used, and it gives more value (for me) to show it as polygons (each enclosed by a group of multipoints) . How do I change the multipoint to polygons?Im attaching my fme script, and a sample json.Using FME Workbench 19.1Adress of url of json api is in the script.Best RegardsDavid

Hi there, I have calculated an attribute by using the Python script in Python caller. I tried to add the attribute in the output using following code at the close function:for i in self.df2['Normalized_SAIDI_DPP2']: newFeature = fmeobjects.FMEFeature() newFeature.setAttribute('Normalized_SAIDI_DPP2',i) self.pyoutput(newFeature)The above code add the attribute in the output but the added attribute is not in-lined with the other attributes of the output. For instance, if the current output has 3 columns, and 100 rows of record, after adding new attribute, it would become 4 column, however, the value of 4th column after 100 rows of record, in the first 100 rows value of new column is missing. Could anyone guide about how to inline the value of new added column with the existing value?

I don't want multi-part features in my data so now I have to use deaggregator after every clipper.

This is a fantastic Christmas present. Thank you very much!Where can we access the documentation on the API?======================= FME 2017.0 "What's New" =======================------------------------- FME 2017.0 17217 20161221 -------------------------FME Objects Python: Added Python Raster API. (PR 50880). C86032 C88501 C88502 C93631 C107415 C120839 [Edit] OK. I found the doc in the FME 2017.0 beta build 17217 install directory :-)<FME 2017 HOME>/fmeobjects/python/apidoc/index.html fmeobjects.FMEBand / FMEBandProperties/ FMEBandTilePopulator / FMEPalette / FMERaster / FMERasterProperties / FMERasterTools / FMETile

Bonjour,J'ai une donnée géographique de 46 000 000 millions de points, je veux la fusionner (dissolve) dans FME desktop. J’ai essayé à plusieurs reprises faire le géotraitement sur ARCGIS mais, le logiciel plante. Donc, j'aimerais l'intégrer dans FME . Quel outil vous me suggérez pour générer cette couche.Merci beaucoup

Hello there,I try to read from a web service and write in Database but Datetime value from service came as string like /Date(1578560957763)/ . How can I change these string to actual datetime. I use FME(R) 2019.2.2.0 (20200103 - Build 19817 - WIN64)Thanks in advance.

I'm doing a CAD to CAD conversion, but my final file, is constantly losing the hatches, in most cases do not show the hatches in the output file. Could someone help me and tell you what's going on? Follow my template  Thank´s

Currently I'm running 2 datasets into a spatial Filter between 2 datasets to locate spatial differences, and then I have a few testers setup to filter the data to just what I'd like to see.For the spatial Filter I clicked merge attributes and added a prefix to differentiate between the two data sets and this works as intended for data that is outputted into the Pass portion but does not locate the prefix fields if I hook up the testers to the failed results. However when its hooked to the failed results this is the apperance of the tester after the spatial filterIt does not find the Package1 prefix fields.

Hello All,I have 2 polygon MapInfo files - land classification and farms. I want to update columns in the Farms table with the classification/s in the Land Classification table where they overlap. I can't work out how to do this as there may be multiple (though not overlapping) classification polygon areas for each Farm, so I want to update the % overlap for each column - Grade 1, Grade 2 etc. I can produce separate files for each grade, but not then update columns in the master Farms table.Any help would be much appreciated.Thanks,Jane

Hello every one. I have a folder with 700 .tiff raster files (images) and a external orientation text file with 700 rows of ID (name of the raster file), X, Y and rotation of the center point of each raster file. How could I convert all these in to geotiff? How do y manage to relate each row of the text file to its raster file? After this is solved I gess it should be easy to georeference them with the rastergeoreferencer...

I have a huge set of polygons which I would like to group by connectivity in FME 2016. In the following is a simplified example with a set of polygons where I would like to end up with three groups:I would like each polygon to afterwards have a group_id or similar describing which group it belongs to.This is easily done using a Dissolver, but with an increasing number of polygons the dissolver seams like a very expensive process and I feel like this could be done in a less expensive fashion.

How to configure 2 engines one is with 32 bit and another with 64 bit in same fme server

Hello,we have some trouble running FME Server (2017) workbenches. Italian characters are interpreted using Server system configuration instead of the italian one. Is it enough to include in the "environment" section of the fmeCommonConfig.txt file the LOCALE=it_IT ? Other configuration needed? ThanksRoberto

See image below, my z value that I need to pull with the contours in this DWG are here (circled): How do I expose the Z value circled (and/or the rest of the coordinates XY) in my workspace from a DWG? I can see this in inspector. I'm converting the contours to GDB.  

Hi,  I want to do a geographic analysis on height. Some cell values however are filtered out because of trees, etc and set to No Data. For this reason I want to change the no data values(brown) to the average of surrounding band values (green). I tried using the rasterConvolver, without success. Also I tried all these steps (https://knowledge.safe.com/questions/3796/fill-raster-nodata-values-with-minmaxaverage-value.html ) , also without luck, since I guess it requires a more profound understanding of FME.   Any help much appreciated!