FME Form

Hi FME team,I want to create a list from attributes, retain the site IT and Metric - with the metric values. So effectively I will have a feature for each Site ID and Metric combination. I've tried ListBuilder and ListExploder but not working as I'd like. Attached is an example of what I have and where I need to get to. Any help would be very much appreciated! Thanks.

Hi, just learning FME.I would like to know what transformers to use when I need the ff: Identify points that are near each other (points within 30m buffer)Identify the similar attributes of the points within that 30m buffer The goal is to know the potential duplicate points based on XY and other attributes. Thank you!

I am struggling with creating centerlines in wall geometry from CAD, where some squirrely ones show up:I was hoping that I could filter by # of vertices, or separating by angle, but this is not reliable. Any ideas? Thanks,@larue​  

Sometimes one ends up with tables that contain empty columns. Is there a way to detect if an attribute is not being used, if it is "empty", and then remove it from the table? A automatic table cleaner of sorts. This would make the management of data "creep" a lot easier.

Hi,i want the start and endpoint of a line. So I use a Coordinateextractor and with coordinate index 0 I get the start and with -1 the endpoint. Normally it works fine but I have a line and suddenly the endpoint is somewhere in the line. I found out that the line was aggregated with FME and this somehow mixes the parts and the indexes of the line, so the endpoint is now in the line. In the help of the aggregator is listed: If the order of individual geometry parts within the resulting aggregate is important, you can first route the features through a Sorter. But I don’t have attributes to sort the line.If I use the dissolve function of Arcmap the line is dissolved correctly. So is there a way with FME to get a aggregated line where the coordinate index of start is 0 and coordinate index -1 is the end at the correct position?

Hello, Dynamicly filling the Where Clause in a FeatureReader (Arcgis Online feature Service) only gives an error in Automations. I want to retrieve notifications (meldingen) of the previous month (maand) of the year (jaar) out of Arcgis Online (on a certain point in a month). I want to put this functionality in an Automation. I do this using the following steps:-In an AttributeManager I take the current DateTime; extract the month and year and calculate the prevous month (use conditional value for use in January).-This values are put in a privat parameter: Maand (month); JAAR(year)-The private parameter is then used in the where clause.EXTRACT(MONTH FROM "REGISTRATIE_DATUM") = $(Maand) AND EXTRACT(YEAR FROM "REGISTRATIE_DATUM") = $(JAAR) This setup works in FME Desktop and on FME Server > (from log)where 'EXTRACT(MONTH FROM "REGISTRATIE_DATUM") = 7 AND EXTR

How can i do this? I tried everything i could.The number of columns needs to be dynamic.. if Town III is 5 times then there should be JB5 ZB5 and RT5.The RT1 Column is the Order in which they should be (see colour)

Hello, I am trying to make a REST API call to one of our servers from inside of a Workspace with an HttpCaller and I am not sure where would be ideal to store or pass credentials like username-password pairs/tokens that are required for this. I don't want to just leave it hardcoded in the Workspace, what I'm looking for is some kind of storing mechanism for sensitive data from where we can retrieve it later in a Workspace.(whether it's in the Cloud/Server does not matter, as long as it's via an FME feature) Any alternative/tipp would be greatly appreciated on the topic of credentials/security measures when working with the FME ecosystem. Thanks in advance!

I am trying to extract images (pdfs, tiffs, etc) from attachments in an ESRI geodatabase. I have been able to get what looks like the proper file but it won't open. Any ideas or perhaps know what to fix this?

i want to read an aprx or lyrx file in fme . is it possible?

Hi all,I wonder if it is possible to have FME expose the day of the week at the time of running the workbench? E.g. If the workbench is running today I would like to have an attribute "day_of_week" that has "Wednesday" as a value.If it is run tomorrow the attribute should read "Thursday" etc etc Thanks!Ed

I have attached the actual workbench below. SO in more detail, what I am trying to do is to output fanned out (by council name) shape files and GDBs to an already existing folder (of the same name as the council name attribute) on a drive somewhere. Is there a way to direct the output data to go into the different council folders when this workbench is run for all councils?The intention is to place this in the server and then schedule it to run on a quarterly basis.any thoughts?thanking you in advance.

Hello, I am passing in a list of values to a user parameter (eg: LGA LGATYPE ABBNAME). The user parameter is assigned to a parameter of ChangeDetector (Selected Attributes).  If I open the FME workbench and run it, the ChangeDetector recognises the parameter value passed as a list of attributes. It then uses those attributes to check for any differences between 2 datasets. That is as expected. However, if I run the tool from the command line and pass in the attribute list as a parameter, (eg: LGA LGATYPE ABBNAME), ChangeDetector does not recognise it as a list and does not find any attribute based changes.  If I reduce the command line parameter down to just one attribute (eg: LGA) then it works. The parameter is a list parameter: 

I have an excel spreadsheet with 3 columns (featureclass, tag, summary). I want to update the metadata.xml file that corresponding to the featureclass. These xml files are embedded in a column in an sde table gdb_items. I'm able to extract the xml, but I don't know how to add xml elements. I have seen the xmlUpdater which works but only when that tag exists in the xml. Also, the "tag" field in the excel is a list of tags separated by commas. I need to create multiple <keyword> tags, one for each item. Here's my workspace so far. shows the xml without the existing "summary" and "tag" <idPrup> <searchKeys> with child nodes <keyword>, respectively shows xml with those nodes (lines 80 to 86)

Hi everyone. I am new to XML and am having some difficulties using the XMLUpdater and XQuery. My issue is around updating 3 attributes within an xml element from 3 attributes in an FME list to create multiple children. When I do this for a record which has say 2 items in the list it’s producing 9 children instead of 2, do I need to group my data somewhere in my XQuery? I’ve attached a sample workbench and data. I am reading an Excel document, then creating a list of all LCS_Codes and their measures per TAC_Code. I then want this list to form the children of a location element within my XML. So I’d hope to go from something like this: Input table:To this output XML text: <tractionCurrentSection id="M58"><location>

Is there a way to have this python module in FME?  

I'm trying to convert a DWG with solids to an OBJ mesh.The conversion is good but the OBJ doesn't include the color of the solid ("autocad_color"). I tried GeometryColorSetter but I can't seem to set it up properly.I also tried the AppearanceSetter, following this post: https://community.safe.com/s/question/0D54Q000080he8G/how-to-set-the-color-of-an-ifc-objet-ifcproxy but I can't set it up correctly Could you give me some suggestions on how to setup the transformer GeometryColorSetter (or a better one) so that it takes the "autocad_color" of the geomet

Hi, Is there a way to replace curve rings in polygon geometries with vertices along the curve without generalizing the whole geometry. The input is a feature class in a file geodatabase. Thank you for the info! 

Hello, I have a line shape file which is in 2d. I want to drape it on terrain to make it 3d. I have the terrain data of the area which is a .las file.

I got over 380000 polygons of landcover data and I'd like to find out which of them have parts thinner than 0.2 meter and identify where these thin parts are located, so I can fix them.I've tried bufferer, but there's no luck for me, please help me, thanks very much!

We have certain coordinate system transfomation requirements for LLH to grid coordinate conversions that are difficult to satisfy using the available reprojectors.I would like to understand how to build and provide a custom projector to be used in our FME transformation pipelines.

Hi FME Guys I'm struggling with a data situation that occurs frequently in my daily work. When I have a polygon feature it may occur that this polygon is composed from "thin" and "thick" sections. See below a screenshot of such a situation.I'm now looking for a way toidentify affected polygon featuresidentify "thin" sections from this featureremove the thin sections or at least cut them from the "thick" parts.Each solution should keep existing Z-values as I'm dealing with 3D data. Any ideas how to achieve the desired result?

I have an idea about a collection of feature readers and writers (feature reader for DWG can break blocks 1 level. then checking if the entities resulting from that break is geometry ( ill keep the block containing that geometry from before the break) or if its a block (break again). then iterating over that until all i have is blocks that if breaked/exploded only consists of meshgeometry.  I would like to hear some feedback on this idea.

Hallo! I'm trying to set the folders in the zip-file for my data download service, as discribed in this question It works the first time I set the folders. But when I need to do a change in the zip-file order, the value of the 'Path to zip-file' are 'stuck'. Even if I edit them, they go back to the value they were initially set to. How do I get around this? Best regardsKicki M

I am trying to merge a set of tiles into a geopackage file. The sources have different geometries and schemas. The string transformers are beacuse the sources have (4) unique characters in the beginning that need to be removed in order to do the merging. I have successfully used a similar workspace to merge tiles into shapefiles in the past. This time all is well until I try to write the new file. There are quite a few errors reported but the geist of them seems to be: "OGCGEOPACKAGE writer: No definition found for input feature type 'NNNNNN'. Ensure that fme_template_feature_type is not set incorrectly and that the feature type name is valid". Any ideas on how to resolve this?