Transformers

Hei I am trying to convert a kml file into a geodatabase, because the kml file has attached pictures that were taken. If I do it via arcgis software I don't get the information, just the points. Via FME I can get the points, the information about the points, and that existes some jpg files attached to the points, but not the jpg files. Shapefiles don't allow to attach files into, but geodatabase allows that. Someone with experience on that?In attachment you can find an example to teste. Thank you in advance,Artur

I have used the quick transformer to convert Revit file to IFC format. The log message said the features were converted successfully but when I open the output, no features was found.

After the dynamic writer is done i need to update some column for each feature type being written.Something along the lines with (its not the actual SQL, this one is simplified for demonstration )   update public.$(feature_type_name) -- This is table nameset area = ST_area(geom)I want that to be run as    update public.parkset area = ST_area(geom)But fme_feature_type is not available. Can i do this without hardcoding the feature types names?

We are having two csv files, which are having address fields. We are trying to match the attributes column by column from two tables by using a feature joiner in the custom transformer's loop iterateWe are unable to iterate the list value in feature joiner, we are using feature joiner as below. Please help me with how to iterate the left attribute _list{0} to the next value.Thanks in advance for your help on this.

I am using a spatial filter to test if a candidate polygon is within the base polygon. The settings for the spatial filter are as follows:Filter Type - Single FilterPass Criteria - Pass against one filterSupport Mode - Support aggregatesSpatial Predicates to test - Contains CandidateUse bounding box - noCurve boundary rule - default For some reason it keeps failing and I'm not sure why. I've attached a sample of the data.

The PDFPageFormatter transformers handels as follows when more than one feature enters the input port.  "If more than one feature enters the same input port, the scaling and centering will be calculated based on the aggregate bounds of the input features. The features will be written to the PDF in the order they entered the input port." I would like the oposit. Is it possible that the PDFPageFormatter recalculates the bounds of the input feature for each input feature?  My workflow:Reading multiple pdf's with different pdf sizes/ heights and widthsThen merging all those pdf files in a single pdf.  I would like that the output PDF contains all the read pdf's and keep the original pdf page sizes for each page. (Reading spatial pdf's as rasterized pdf layers is fine!) Thanks,Mark

Hi all, I am trying to convert a CSV file generated from IoT censors to file GDB. The table got a geolocation field in which X and Y values were separated by comma. I wanted to get the data on LL-GDA94 projection. Although I was able to create a feature but it was not projected properly and appeared out of map extent in ArcGIS. Can anyone help me with the script that I have added here? I am attaching the CSV also. Thanks in advance.

Hi,I am trying to create From-To lines from every point in a shapefile to every other point. I have 45,989 points, so (in theory) each point should have 45,988 lines coming off and attaching to every other point. I have attempted to use both the FromToBuilder and the LineBuilder, but neither seem to work.Does anyone have any ideas that might work?Thanks

I have a workspace set up to terminate based on parameters that it has failed on. Is there any way for a message to come up as to why it failed that isn't in the log? Primarily for users running it that don't understand the log file and how to read through it so that they know why it failed?

Hi,I have a kml file that is created from a MapInfo Tab file that has 9 polygons, the polygons are all the one colour and will change to another colour if you hover over it. Now I want to remove the old outline colour and assign a different colour to each polygon using the Asset_Mgr_Region field to filter by, but still retain the highlight on hover. I am not sure where to place the Attribute Filter to achieve what I want, how do I use this? I have attached my workspace. Thanks

Hi,I need to denormalize rows into repetitive numbered columns. Here's an example.Here is the normal version as it is in the relational db. Note that the three rows all have the same value in ID_DETAIL field.Here is the desired result. Note that for this one DETAIL, we end up with three groups of columns (ID_MENTION, MENTION, PRECISION).How would one do this in FME ?The number of repetitive groups of columns would be defined by the detail in the dataset having the most mentions (in my example it was 3).I was thinking of some kind of grouping on ID_DETAIL and some kind of "for-each-loop". But any better suggestion appreciated !

Using the circle below as an example. I would like to close the gap, doesn't really matter if it is by snapping or adding a vertice. I have tried both Snapper and LineCloser, but they don't seem to work when there is only one geometry.  How can I connect the start and end points in the example below? I would rather not use the LineCloser of fear of self intersections (real world features are more complex than my example), and the HullReplacer is to slow.   

I have a python script that reads a set of values that we want to expose out of PythonCaller as a list; however, after several attempts, we are having issues outputting the list out of the Transformer. Running the script works outside of workbench, but having issues incorporating the script with FME. Debugging the script and writing to the log, we know the code is calculating the values for the list consisting a several attributes. And, the thinking is we are not formatting the list correctly or defining it. I have attached a simple workbench that contains a slimmed down script that we are trying to utilize to determine how to output a list at all. Any help in this regard is much appreciated. Here is a part of the slimmed down script listing the nested loop we want to use and the List name we want to output:   def input(self,feature):         npts = 3         # do a bunch of stuff with other input attributes to populate D     C = ['X','Y']    D = {'X':[230875

I have a WMS feed that I want to include in an HTML report but don't understand how to to get the HTMLReportGenerator to use it. I have a polygon layer that I group by, buffer it slightly and then user the feature reader on the WMS layer.  If I user the Map option the base map is present but no WMS. Any suggestions?

I have a CityGML file with some attributes containing numbers, but also strings. But for example, the folllowing attribute is supposed to be a float or integer in the 3DTiles format, but is written as a String, no matter what I specify as datatype in the writer's user attributes. <gen:stringAttribute name="DatenquelleDachhoehe">   <gen:value>1000</gen:value></gen:stringAttribute> What could be the reason for the 3Dtiles writer ignoring the specified datatypes?

Hi everyone, Is there and options for i would like to download data from OSM witch based on secondary property of the lines this time show that is it a roundabout or not. Or is there any transformer witch able to find them(roundabout).  Thanks :)

Greetings- I am trying to have a FeatureReader (set to format 'Directory and File Pathnames') fetch file properties for a list of 'Dataset' paths and 'Path Filters' which are incoming Attribute Features but have been unsuccessful in getting it to recognize them as valid. . only 'fixed' values seem to work. I've been through the help and Community posts on this and haven't found anything so far. Thanks in advance for any input.

Hi all,I'm trying to merge two separate excel spreadsheets. Both worksheets have the same names and number of columns. However, they do not have a common primary key to perform a join. All I'm looking for is to append the contents of the second spreadsheet to the end of the first so that I have a single spreadsheet at the end. How can we achieve this kind of merging without using the FME transforms inheriting from the SQL language (FeatureMerger or FeatureJoiner) in FME Desktop?

Hallo FME Community, I have a DWG file with about 100 layers. I managed to reduce the layers to 20 layers with FME by merging layers. Blocks in my DWG result are broken up into their component parts and they aren't one block but several lines. does anyone know how blocks can remain as blocks after transformation.Thanks in advance.  

Hey guys! How can I round to two decimal places while keeping zero on the second decimal place? I would like an attribute with a single digit like 450.199 to round off to 450.20 and not 450.2. Thanks for the advice in advance

I'm trying to replicate an analysis in FME that we have done both Esri and GDAL Zonal Stats tools. It is pretty basic. I have a single band raster layer of percent tree cover spanning the contiguous US. I need to summarize that data at the tract level. I.e. what is the mean tree cover for each tract within the US. I get identical results when doing the analysis with Zonal Statistics in Esri and GDAL. When I conduct a similar analysis in FME by clipping the raster to the tracts (merging attributes) and then use the RasterStatisticsCalculator on the result, I get a completely different answer. 

is there a way I can only display "Translation parameter values" window when I run a process via quick translator ? The background window "FME Quick Translator" somehow is redundand I think since I dont need it.   

Used arcmap to import xml of data schema only from arcsde into a file geodatabase. Using esri geodatabase (ArcSDE Geodb) reader to esri geodatabase (file geodb). receiving error message:An error occurred while attempting to open an insert cursor on the table 'Beacons'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [Beacons]}  

The data needs to output from Row 5 cell A to U. I can see you can use the start position of 5 which works but everything above get's wiped out so I loose the headers. How to I stop loosing the titles and headers from the output in Excel in FME?

Hi everyone,I'm trying to restore a arcgis polygon feature layer (feature 1) (that someone accidently ran a simplify geometry tool on) with the geometry of a backup feature layer (feature 2) from a older copy of the dataset. Problem is that I ONLY want to replace the geometry of feature1 and keep the attributes. The workbench that I build (see picture below) will replace both the geometry and the feature values/attributes of feature 1 Any tips on ONLY replacing the geometry? thanks in advance.