Transformers

Hello dear FME community members, I use the HTTPCaller with an output in HTML. From that output I want to get values from the HTML and get them exposed as attributes. Therefore I use the HTMLExtractor to extract the values of the CSS selector and return the output als a List Attribute.The result is that I see one feature with several listattributes. After that I want to explode the list with the ListExploder. The strange thing is that the ListExploder dies not see the List attribute. When I use a AttributeExposer and expose the list (list{}) then the ListExploder sees the list...a strange behavior!?!?  In several examples on the community the AttributeExposer is not mentioned or used to expose the list afther the HTMLExtractor, see an example: https://community.safe.com/s/question/0D54Q00008EcEOlSAN/how-can-i-isolate-html-table-values-td-based-on-attribute-name?t=1676911484807 I expected that the ListExploder sees the output list made in de HTMLExtractor. Is this a wrong assumption on

I have pull and transformed a series of table from a MS SQL Database. I am now trying to using FME to enter them into a specific sheet starting as a specified cell.  I feel like this should incredible simple, but I struggling to get it to do what I need.

If I have addresses in an address field formatted for example:1234 Elm St ...and I want to remove all spaces to change the field value to look like this:1234ElmSt What Transformer and Parameter would I use?

Hello,i would like to transform a .csv list which contains adresses with a given latitude and longitude to dxf/dwg file into my local coordinate system (AUT-GK31-5). The exported dxf/dwg should contain a point with the transformed coordinates. thank you for your help - i am working on FME workbench 2019.0 input: (wish) .csv or excel lat: xxxlong: xxx(text: xxx) output:dxf/dwgpoint: (correct transformed coordinates - AUT-GK31-5)(point-text:xxx)  Christoph

Dear Altruists, I am trying to convert NetCDF evaporation data to further processing, e.g. aggregate by month or calculating average value etc. However, I am struggling in the basic steps to unfold the multidimensional variables. When I am reading the data in NetCDF reader, it returned some attributes where I cannot see the lat/long or date file. But after using AttributeExposer to get the netcdf_subdataset_name; there I see lat, long and evaporation (apet) name but not sure how to get the values of these variables. I am given a python code in which the developer wrote a function to process the .nc data. Can anyone kindly tell me what FME transformers I need to use the replicate the python process as below: def funt_1(fileName, points, var):  nc_fid = netCDF4.Dataset(fileName, 'r')  prbc = nc_fid.variables[var]  lats, lons = nc_fid.variables['lat'], nc_fid.variables['lon']  time = nc_fid.variables['time'][:]  # Convert time to Julian  Y = int(nc_fid.var

Writing to an Esri Geodatabase (File Geodb Open API) fails with this error: ‘Geodatabase Error (-2147219115): The row contains a bad value. There's an empty table created instead of a point layer.The error suggests that something's wrong with the schema, but I can't find the cause. The issue stays even with only one feature and limited number of attributes.Writing the result to a shapefile or to SQL works fine. FME version is 2022.1  Anybody had similar issues with the Esri Geodatabase (File Geodb Open API) writer and knows how to solve this? Thanks, Ruth  

Hi all, I have an "issue" that is frustrating me to no end (probably because the answer is more simple than I'm making it), so I thought I'd run it by the community. I have a workbench where I am taking AGOL features and converting them to a dwg. The AGOL geometry that is giving me issues are the AGOL polygons after they are sent through a CLIPPER:  I understand why the 'RESULT' is passed through the CLIPPER and spit out as polygons still. And I have them also going through a GEOMETRY COERCER (to fme_line) and even a LINE ON LINE OVERLAYER -- all good to this point.  What I cannot figure out is how to remove the unwanted lines to obtain the "DESIRED RESULT", which would just be lines once they get into AutoCAD. There doesn't seem to be an attribute that I can use to differentiate whether the line came from the original polygon or if it is a result of the CLIPPER 'changing' the geometry (all geometry has the attribute "_clipped"

From Attribute Manager I have about 150 columns on which I have to run a series of condtitional query's to populate them. So far the only way I have found to do this is to open each "else if" option individually and adapt the text contained. The change could be easily done whith a simple "search/replace" process within a text editor such as Notepad++. The attached image shows the text circled in red that needs to be replaced with a another constant value.  Unfortunately I can't find any way to make those changes within FME's "text editor" in the Attribute Manager". 

Hello,  I regularly save a file in a GDB (GDB-Name\\Topic_<date>) and want to display the differences a week later. Manually - I enter the file names myself - this works wonderfully, but it always requires a manual intervention to enter the correct names. Now I would like to automate this work. For this purpose, I calculate a variable using the transformer "DateTimeCalculator", which calculates the date of the last execution of the script (-5days). Afterwards I want to read the last table (GDB-Name\\Topic_<date - 5days>) from the GDB using the FeatureReader. My problem now is that I do not manage to specify the correct table within the GDB, or the correct number of features is output at the Generic Port, but without geometry and attributes. So my question is, where can I specifiy the correct tablename? Could someone please help me to solve this problem? 

Hi there,  I am trying to publish from an Enterprise geodatabase layer into an existing AGOL feature service however get the following error.  I have tried setting the projection, used the Reprojector and Esri Reprojector but cannot seem to get past this issue.  Any pointers? Thanks!

I have a shapefile with parcels. With the transformator "MapTextLabeller" I am able to add the correct numbers to every parcel, and orient them correctly with the rule. How can I save the text labels in a shapefile or another data source in a way that preserves the labels created by the "MapTextLabeller" transformer, as seen in the FME Data Inspector? While the final result is visible in the data inspector, writing the labels again in a shapefile does not produce the same text labels. What steps can be taken to properly save the text labels, and ensure that they are encoded and stored correctly in a field of the output file? 

HiJust looking at the AR objects, there doesn't seem to be label/text. Would you need to do this via images?I want to have labels in a street as you pan around.thanks

I am working on a national dataset for Australia. The initial dataset had points that are converted to polygons based on the parcels they overlap using the Spatial filter transformer. For the points that do not overlap with any parcel, a buffer of 20m is created. Both the parcels and buffers are combined and exported as a dataset. I'm trying to filter those polygons created with buffer of 20m. Logically all the circles should have the same area and length but it is not the same. I wonder if it is because the dataset was in the Geographic Coordinate system when the buffer was created. However the formula works, is there any way we can filter all the polygons in the shape of circles? It is not working with filtering by area since I have to add a range and it is filtering other parcels which are not circles.  I appreciate your response in advance. My boss thinks it's very simple/logical but I can't seem to find a way to filter these circles :(

I have and AutoCAD DWG file with several polylines. I would like to get the coordinates from these lines saved to a .csv file. Is this possible? I am new to FME so will need a thorough explanation please.

Okay so I have two features, a point feature (addresses) and a line feature (fiber). My end goal is to create a new line feature from the point to the nearest spot on the existing line. I have that process figured out but now I am wanting to fine tune it a bit which is where I am stuck. Currently, it will "snap" the new lines within feet of each other on the existing line and I would like to get it set so that if the new lines snap point is within a certain distance, they snap together at a single spot on the existing span. I have attached a screen capture of my current work flow for reference. I feel like I need another CoordinateExtractor + AnchoredSnapper but my attempts with those aren't returning what I am hoping to do. Any advice for a FME newbie would be greatly appreciated!Here is the current outcome, Black is my existing line and red is the output.

Hello, when using the Bufferer transformer on points, a circular polygon is generated. The number of vertices constructing the circle is a function of parameters like the corner endcap type + interpolation angle. I'm good with this.  What I would like to know is if there is some logic to how the vertices of the buffer are generated. That is, how is the first point on the circle determined (since all others would follow from there based on the number of vertices / interpolation angle).  To provide context, we are capturing points that fall within the buffers and we have some edge cases that appear would be captured if only the circle were rotated or we increased the number of vertices. We want to see if there is a way other than increasing the number of vertices since this tends to slow down downstream transformers.  In the picture below, you will see that depending on the rotation of the points, the green dot may or may not be captured. In the case shown, it's captured by the

Hi,I'm attempting to use the PlusCodeGeocoder Transformer,The intention is to read a CSV of Google Plus (Open Location) Codes and then write an Esri shapefile. For example, map this as points:id,google_plus_code3,"53PP+34 Taromeo QLD, Australia"106,"Q9XG+PF Widgee QLD, Australia"511,"HGM4+5X Amamoor Creek QLD, Australia" I've configured the visible parameters in the transformer.   The email value is the email I have registered with the Google Maps Platform for my API key.When run, the status code is 200, meaning the request was received, but the output is routed to rejected with the _pc_response_body stating:{  "status": "NO_API_KEY"}Where in the Transformer can I provide the API key?CheersMic   

DEvo calcolare la percentuale di ricadenza dell'area di un foglio di mappa catastale, all'interno di un'altra area. Ho utilizzato il trasformatore CLIPPER, conosco Area foglio di mappa, area ottenuta dal clip. Devo calcolare (AreaClip/areaFoglio)*100

I have created a workspace, where the source data (File Geodatabase) is fed in the workspace as a Required & Published User Parameter. The last value chosen gets saved as the default value.The intention is that each time the workbench is run, the user selects the appropriate File GDB.When I run the workbench, I get the prompt window to select the appropriate source file (see image 1 attached). However, when a colleague tries to run the same workbench, she doesn't get the prompt to select the source file.The workaround presently is for the colleague to open the workbench, then go into the "Manage User Parameter" space to enter manually a default value (see image 2 attached). This is however not practical, and we would love for all user to get the same simple experience.Can anyone advise?

Could any body help me to start the process. The XML uses ADAC Schema version 5.0.1Thanks 

Run button grey's out Post successful execution . I'm running with Cache turned on. But SQL operation is not executed

Hi Everyone I have a nice complex workspace with a lot of linked transformers. I would like to embed all of the linked transformers. This is the resource page that I have been looking at:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/custom_transformer_embedding_linking.htm For some reason, I can only "edit" linked transformers but not embed them. Second test was to "Embed All Transformers" under the Menu>TransformersThis action is now greyed out..   Any tips how to get embed my linked transformers?I have a suspicion I cant embed them because the transformers are somehow part of my default Paths?   Any help will be appreciated! FME Build: 227822022.2.2.0. CheersFred

I am using Esri Geodatabase (File Geodb Open API) Reader to read a gdb file where some attributes are mapped to domains. If gdb contains any value not matching with domain, then reader is reading it as null.  For example: gdb has one column Citizen with domain value - 'Yes', 'No'. If any row contains 'yes' then reader is reading it as NULL because its not matching exactly with defined domain value. I am using FME(R) 2020.2.5.0 (20210510 - Build 20827 - WIN64)

Hi everybody I'm using FME to merge several different spatial feature classes to create a new one. The user of this product is one of our partners in the office who doesn't have the possibility to view the data with a GIS-system. Therefore the output should in form of an excel. At the end of the workspace I use two writer: one for the excel and one for the GDB. When I compare the two results regarding the total area of the features, only the GDB one is correct. It is important that the area-values in the Excel are correct because they are used the analyze the other attribute using Pivot-tables and so on... Thanks in advance for you help :-) 

Hell FME Community, i am trying to write the data into existing Oracle Spatial Point Cloud table. However, the translation fails with the following error: "ORACLE Writer: writing the point cloud failed because it has 3 extent dimensions, but the table 'AHN_BLCK' column 'BLK_EXTENT' contains data with 0 extent dimensions. The number of dimensions must match for all point clouds in a table."The "BLK_EXTENT" column has the SDO_GEOMETRY data type.Does anyone have any ideas? Best regards