FME Form

Hi All,I am working a project ,where client asked us to add suffix to a attribute value .This attribute value is not a Unique , in order to make it unique we have ad suffix values as shown below image , requesting you all to provide a solution ? to reach this requirement! (the suffix number should be 4 numbers)Thanks in advance.

291 / 5000  ÜbersetzungsergebnisseI'm looking for a transformer with which I can create a buffer around a line. This buffer should have a defined width. The line has z-coordinates.At the end I would like to continue using the buffer polygon that was created and the polygon should receive the z-coordinates of the line.  

I am currently using a ChangeDetector to determine which fields have been updated in two different databases. The change detector works as intended and creates a list of different fields have that have been updated. The problem I have is that all the updates need to be written to a database on a one-by-one basis and currently I cannot find a way of sorting the updates by the specific field that has been updated. The updated list created by the ChangeDetector has specific attributes called "attributeName" and "revisedValue". I want to use those two attributes to create a new single attribute which is named after "attributeName" and has the value from "revisedValue" that indicates to my database which field need to be updated and the value that has changed.

Hey community! how can I convert a point cloud in this sense? When I put my obj in Unity I have this problem....

Hi, the API comes back with the number of totalPages (say 10 pages), how can I loop the API call through all these pages (1,2,3...10) to get all data? Is there a tutorial I can refer? thanks, Song

Is it possible to transform .gdb files into .ifc files. If yes, what transformers do you use? Sincerely Thomas

I've got a 3D DGN of a bridge out of Bently. I'm following the instructions in the Creating FMEAR Datasets from 2D Cad models article. Since it's already a 3d model, I'm assuming that I dont need the extruder or offsetter. So it should just show up if I convert it, right? I do get a layer list and scale information in the app, but the surface dots disappear once it loads, and nothing else shows up.

This is an error I get when I try to refresh an existing layer in a feature service on ArcGIS Online. ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'Environmental_Inspections'. The error code from the server was '1000' and the message was: 'String or binary data would be truncated.The statement has been terminated.'Has anyone else run into this?

The work flow of this process is that there is an excel spreadsheet from another department that is updated with one new record everyday. This excel document is the source for another spreadsheet that we use in our department where there are formulas that update columns. What we are noticing is that when the workbench is run the next day it will not pull the new record automatically. If I open this excel spreadsheet and save it manually then the FME excel reader will pull the new record. What can I do to get the FME workbench to pull the new record?  Thank you, Laura

Hi, We have a very basic workflow where a user enters a value into a parameter, and we write that value to a CSV which is stored on a network share drive. We have an external facing website that we would like to have access to this CSV so that it can publish the latest value found in this CSV.  I am not a web developer, I am a GIS Guy, so I am a little out of my depth. Is there some way I can save this CSV on the FME server so that it is available via the Website to read?  I am unsure if that is the best way to explain it, sorry for the n00b terminology.

Whenever running a workspace the log start with pointing out how to run the workspace at the command-line. No doubt it works when I open the command-line and run the workspace.My issue though is that I have a little ui in C# where I do not call cmd.exe, but go with Process.Start() and start directly fme.exe.My approach works as well, however, it takes 4 minutes to run the workspace in cmd.exe and 30 minutes when calling directly fme.exe. Is there an explanation why it takes so much more time when calling fme.exe instead running it through cmd.exe?

So the problem is that I have a hard time to refresh my updated data. The 1st time I run the data is fine. When I tried to edit the source data and click "RUN" again, the data doesn't update the data. However, if I click view source data, it is the updated one. I tried "Reader => update feature types" and it doesn't work as well. I have to close the program and reopen the fmw file in order to get the newest version of data.  Is there any way that I can update the data inside the FME environment? Thank you very much. Zach

I have data for various sites and some sites have been digitised more than once and have overlapping polygons. However, these are not virtually identical polygons. They only partially overlap. I want to find the sites that have overlapping polygons. I tried using SpatialRelator with "Intersect", using the same data as both Requestor and Supplier but it picked up instances where one polygon was actually adjacent to another but probably just overlaps a tiny bit. This resulted in 3700 out of 3900 having more than 1 related candidate which doesn't really shortcut the process. "Contains" wouldn't work because not all overlapping polygons are completely contained.

Hello Sir/ Madam,​I am trying to check if the input "units" and within " floors". ​There are two floors and many units, which they both have "base level" attribute.​The following are what I would like to find out separately.​1) units that are completely outside of each floors2) units that touch the floor boundary yet part of the portion is outside the floors I am not sure how to do ​let FME know how to process each baselevel ( 4.53 and 10.3) in this case one by one. The attached documents are in shapefile. I also attached my fmw in here.​Could someone please tell me what I did wrong? Thank you in advance. 🙂 Zach

I have 1 table that has one column called mbipk with a number value and then another column called sales with a number in it. I want to run it against 16 other tables which also have that same mbipk column, I want it to match only the mbripk number and if that matches then I want it to inject a new column called sales_2 and put the sales number from the 1st table into sales_2 into table 2. Is this possible?

I had an issue with a workspace with a disabled junction. I then discovered that disabled junctions won't get grouped in the navigator as disabled transformers and disabled connections do. Is this on purpose or is this something that can be improved? I expected them in the "Disabled Transformers" group. The workaround is to search for "junction" in the workspace search, this will display all junctions and mark the disabled junctions grey. Tested in 2021.1.1.0 (20210730 - Build 21619 - WIN64)

Hi,I created an FME workbench which contains python script at FME shutdown. This python script uses Arcpy library to make database connection. The workbench execute successfully and insert the data in database when executed manually. However, the script fails when we publish the FME workbench in FME server. It shows transaction is successful with message as 'FAILURE'. The FME job fails to insert data in database. Please advice.

I have a workbench in which I translate XML files to featureclasses in an ESRI SDE geodatabase. The featureclasses are versioned. I use a featurereader in which I specify the child version. That version is then created by the featureader since it doesn't exist before the start of the translation. Updates are done with an SDE geodatabase writer in this version. I specify in the parameters that the version is to be reconciled and posted after the translation. After posting, the version should be deleted. This is also indicated by setting the appropriate parameter. When I run this workbench in FME desktop, this works fine. However, when I publish the workbench to FME server and run it via an automation, the version is reconciled and posted, but it is not deleted. The log displays the following error:Error deleting the version 'versionname'. The error number from ArcObjects is: '-2147217140'. The error message from ArcObjects is: {T

I have some data that i am trying to replicate from 1 DB to another, but I cannot create the readers for several FCs that contain arcade expressions. I get the The error number from ArcObjects is: '-2147211773' message. I am running FME 2021 (64 bit), and have ArcPro installed and the Esri ArcGIS Capability is set to Pro. One thing I can't seem to get is the ArcPro Python listed under Python Compatibility. But I do see that listed in FME 2019 on the same machine. Any thoughts on whether or not this should be working and if so, how I can get it to work?

Greetings,I'm running a workspace through FME Python API using FMEWorkspaceRunner, and need to ensure that the 'redirect to fme data inspector' parameter is toggled off prior to running. How can one access this workspace parameter?Thank you,TylerFME 2021.0.0.1Python 3.7

I have been using the neighbour finder to create a line between an existing point and road line, which works fine up to a point. I am sure the below is fairly straightforward but have been racking my brains to no avail. I have tried the group by which is giving some strange results too... Both the Road and Point Datasets have a RoadID attribute meaning that all points should be linked to the correct road, this is not currently happening with some points being linked the shortest distance to the nearest road and not to the correct road. Any suggestions how i can get the points to link to the correct road via the RoadID field? The image below shows the results i am getting with the Yellow lines drawn on where the links should be going.

Hello, I have created a list of one specific attribute (Listbuilder), which I have finally cleaned from duplicate entries (ListDuplicateRemover). So the list contains several elements, but they cannot be duplicated. As a next step I want to select all geomtria from another dataset which are contained in the list. When trying to do this with the FeatureReader, it seems that I can only specify one element in the WhereClause query. How can I select all geometries contained in the list in one step? I would like to avoid the detour via the PythonCaller 8-). Thanks a lot.

I'm new to FME and tried to use the Rcaller transformer. However, the software lags at the log point "processing Rscript" and does not finish the translation but does not give back an error. This is also the case if I try to run the Rcaller example dataframe() script without any input data. See screenshots for details. Any help much appreciated.I'm using FME 2019.2 with R >=3.6. Translation log:Rcaller parameters:FME Translation Options:

I'm trying to create a series of adjacent wedges from a central point. I have built a workflow that builds one wedge (polygon) then I'm attempting to use the Rotator to create a new wedge at every 1.8 degree rotation 200 times to encompass a full 360 degrees. I suspect there is a simpler method but this is what I have done so far. I'm using the XY-MM coordinate system. Any thoughts on the best way to accomplish this task? Thank you,Gil

Hello, before writing a Python script, I'd like to know if there is a way to retrieve the lines between a point A and a point B using classic transofrmers?