Transformers

Hi, I am working on translating data from numbers to phrases. I know using the String Replacer and Attribute Value Mapper is the best for this, but I am having issues when trying to map more than one value to one field. An example would be the reason_of_given_set has multiple values, I need these values to populate with given phrases, each number represents a phrase. I provided the parameters of the transformer I am using below. I also tried creating 14 different string replacers to represent each number and each time the output shows blank at the attributes with multiple values. I am probably using the Attribute Value Mapper transformer incorrectly and its not designed to do this, or I have the parameters set incorrectly. Does anyone know how I can fix this?

I have a "Directory and File Pathnames" reader that gives me a list of text files in a Windows folder. I want to pass those folder and filenames to a FeatureReader transformer and be able to read the text lines from them as output for further processing, but I can't seem to get anything out of the FeatureReader other than the results of the Directory and File Pathnames that go into it. How do I get the contents of the text files out?

Hi, I am facing an issue where wall was not rendered properly by the FME inspector as it has direction issue. I tried "SurfaceNormalExtractor" but I didn't get any information out of the transformer. Please find the screenshot. Could you please help me in this regard. Same issue was posted 6 years back https://community.safe.com/s/question/0D54Q000080hfTrSAI/citygml-generation Wall not render properly in FME inspector

I am utilizing the EsriReprojector and am getting limited results for datum transformation options from GCS_WGS_1984 to EPSG:6574. Is there a certain setting that needs to be applied to gain the other transformation options?

Is it possible to write into 'autocad_layer_desc'? A key piece of info/metadata that seems to be unavailable on DWG writers.

The documentation for autocad_dimension features says that you can use an attribute "autocad_text_rotation" to rotate the text of a dimension. See autocad_dimension However, I haven't succeeded in rotating the dimension text yet. I use "autocad_dimension_type" = autocad_aligned Any ideas?

Hi, I'm trying to write an XLS file based on a template (according to this help), with complete rewriting of the data (Overwrite Existing File = Yes) and I can't find a way to keep the order of the columns according to the template in the output XLS and not in the order in which FME processes the attributes. For example, I would like that if I invert 2 columns in the template, it also inverts it in the output xls, without setting this with an attribute manager. Did I miss a parameter in the xls output that would allow this or is there another method. Thanks a lot in advance for your answers and best regards. Antonin

We have a client that has a unique need and I'm wondering if it's even possible in FME. There goal is to have a csv or table that contains a dataset name, itemID, and layerID. They also have a GDB file containing the datasets. The would like to have a function to cycle through their csv table, and overwrite an individual layer in an AGOL hosted feature class. The caveat is this hosted feature class may contain many layers and as far as I know you can't update just one layer. We have been racking our brain and FME seems like it may be our last hope. Here's the short version of the workflow Read update table -> Read GDB -> Update Hosted Feature Service Layer Any advice would be appreciated, Chad

In an Esri SDE database, fields (attributes) have a property setting of isNullable (Allow NULL). This property determines if the field allows null values or not. I want to be able to set this property in FME when I create a new feature class. Is there a way to set this property with the Esri Geodatabase SDE writer? See screenshot below to see how to set the setting in ArcGIS Pro.

Hi all, I have building footprints, DEM and DOM data, I have finished 3D modelling for DEM with overlaying DOM, and 3D buildings, while the bottom part of some buildings, especially those located along the foot of the mountains, are under the terrain. I have tried many ways like 3Dforce with values minZ, or chopper buildings to points and acquire the points cooridinate Z value, and also clamp function, while all failed. Anyone can help? thanks a lot.

I want to convert a ESRI Multipatch Feature class to IFC and wonder what the best practice is to write the feature into IFC writer. I am using FME Form 2023. Appreciate your help! Thanks

Bonjour j'ai un "nuage de points" et je cherche a les trier par distance : le resultat attendu est le suivant: le point 2 est proche du point 1, le point 5 est proche du point 2, le point 3 est proche du point 5 etc... j'utilise un neighborfinder en candidates only mais le probleme est que dans ce cas j'ai comme resultat le point 2 est proche du point 1 et le point 1 est proche du 2 et je ne les trie pas il faudrait que lorsque le point 1 est traité il "disparaisse" je ne suis pas sur d’être très clair merci a la communauté de votre aide

i have two geodatabases. geodatabase 1 containing all lookup tables. One lookup table is source_table in which there is a column named "source_table_name" is added. Based on the values in "source_table_name " I want to select the feature class from geodatabase 2. I am getting output but its routing through generic port of the FeatureReader so no schema is being added. Can anyone help me solve this issue.

I'm new, so any help is appreciated. I have a SQL table that has lat/longs. Want to copy table into SQL Server SDE feature dataset with geom column. Tried the feature writer, but don't see where I can select the feature dataset.

I have a lookup table in which some feature class name is mentioned. I have to select in the feature reader only those features from geodatabase which in there in the lookup table. How to do that. One more problem here all my feature classes is in the feature dataset in input geodatabase. In output I want this outside feature dataset

Hi! I have a gml file that i have downloaded from the statistical bureau of sweden. This is the data source: https://share.scb.se/OV0105/Xml/PD/pd_befolkningsfordelning_totalbefolkning_nt.xml It is in GML format and the data is structured in 10km squares. However, I can't seem to be able to convert it to any other format. The geometry im getting is just a bounding box for the entire dataset, not the specific 10km squares. I have found very limited resources to help with this problem online. The final destination should be in an enterprise geodatabase. Has anyone else had trouble with this? Thankful for any help. /Alex

I am trying to run a Shell Script from the System Caller but am running into issues when accessing the various gdal programs that are called from within the script. These are stored away in usr/bin/ and "globally" accessible through the PATH file. The folder where the command is run is generated by FME in earlier steps, so its not as straight forward as copying the gdal files to the folder. Is there some workaround to get this functioning?

I have two datasets, one with 'old' parcels and one with 'new' parcels. I need to find out which old parcels turned into new ones and come up with a was - is list. Desired output: feature OLD parcel XX712 with a list with new parcel attribute(s): 557, 516 feature OLD parcel XX713 with a list with new parcel attribute(s): 584 feature OLD parcel XX713 with a list with new parcel attribute(s): 584 feature OLD parcel XX621 with a list with new parcel attribute(s): 189 What I have tried so far using the SpatialRelator with spatial predicates: Contains, Within, Equals Only works for parcels that stayed the same geometry wise. It is possible that geometry changed, see the example in the screenshots. Intersects This works but its giving me too much suppliers. When a parcel geometry has stayed the same its giving me a supplier from the parcel next to it because the outer lines are touching. Touches Giving me only the touching parcel to the side Am I doing something wrong with the settings in th

We have some Annotation points all in one feature class. We are looking to find duplicated annotation text that are close to each other. We used the NeighbourFinder and attached the attributes from the neighbouring annotation to the base annotation. This allows us to see that, for example, record OD=1 is close to OD=2. Then a Test Filter is used to check if the TextString is the same on the base annotation when compared to the neighbour. From the results of the TestFilter we have a list of annotations that can be reviewed as it looks like they are close to each other and have the same text string (which may not be needed). So, for an example, say there are 100 annotation points that come out of the TestFilter. For each of these points, one of the other points in that selection of 100 points is the point it is related to/neighbouring. So, we don't actually need a list of all 100 points, just 1 of the points from each relationship, resulting in 50 points. Currently we are missing a relat

Hello, I am writing features to a block that was created in a template. The attribute definitions in the block definition have their positions locked, but when I write a new file using the tempalte and block definition all the attribute definitions labels are moveable. I have been playing with settings and trying to figure out why it changes in the new file, but have not succeeded. Original Block New Feature (See all the insertion points on the text, text is also moveable)

When the user selects first parameters the second parameter values should populate based on the first parameter selected. EX: first parameters has values A,B,C Second parameter has values 1,2,3,4,5,6,7,8,9 If the user selects 'A' from first parameter; second parameter should display 1,2,3 values when the dropdown is selected.

Hi, I'm using the FTPcaller to upload data on a weekly basis. In order to preserve data already posted, the new file has an changing date in the file name. I've configured the Transfer > URL portion of the FTPCaller to accept an attribute value which works fine. However, when I try and do this with the Upload From A File > File To Upload portion, the FTPCaller fails, saying it cannot find the file: Any idea what I am doing wrong?

I have two datasets: A calibrated road dataset. Every vertex of the line has the measure value (kilometer point). A table with car accidents with a field that indicates the kilometer point where it happpened I need to create Point geometries for the accident using both datasets. In other words, I need to create a point event layer. As you can imagine, the accidents don't happen at an exact vertex of the road. Can FME create that point event layer? I've tried using the Snipper transformer, but I'm not getting the results I want.

I also want to know the relevance of this setting

I want to connect two databases (Oracle) in an SQLExecuter Transformer. This is to compare the changes. Currently I can add only one connection. Is it possible through User Parameter? Thanks in advance Harish