FME Form

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?  

I need to check the encoding of several files. For this I can use a scripted parameter like so: featureType =open('F:\\PGV\\Projektarbejdsmapper\\P4\\SCSV_til_kontrol\\scsv_2021e1_2021e3\\\\2021e1_lev_k_fortidsminde.scsv')t = str(featureType)return t With a Creator and a ParameterFetcher i get the following attribute:<_io.TextIOWrapper name='F:\\\\PGV\\\\Projektarbejdsmapper\\\\P4\\\\SCSV_til_kontrol\\\\scsv_2021e1_2021e3\\\\2021e1_lev_k_fortidsminde.scsv' mode='r' encoding='cp1252'> When I try to do this with a useparameter like so: file = FME_MacroValues['SCSV_file']featureType =open(file)t = str(featureType)return t This returns the following log:Starting translation...INFORM: Using Python interpreter from `C:\\Program Files\\FME\\fmepython38\\python38.dll' with PYTHONHOME `C:\\Program Files\\FME\\fm

Hi authors.FME workspaces are stored in a specific and well-known structure on an FME Server. So finding the path of another workspace is feasiable.I'm wondering whether I can use WorkspaceRunner to submit other workspaces on an FME Server instead of FMEServerJobSubmitter ?Is this completely no-go, or are there benefits, such as running more workspaces within a single job ?It would also simplify building and debugging on desktop.Any insights are appreciated.Cheers

Hi.When you have a workspace with a published parameter of type text, and it has a default (e.g. testing) value, this gets used whenever the value isn't specified in JobSubmitter/WorspaceRunner.If I submit a blank text as a parameter value, this seems to be ignored, and the default value is used instead.Is this WAD ?If I want to overrule a default parameter value with a blank value, how is this achieved ? Cheers

Hi! I want to put points on lines with an interval of x (for example 100m) meters. I tried several ways to do that. (I beggin with FME). 1) I used the lenghtCalculator, then calculate how many points I can put in the line for 100m interval @int(@Value(_length)/100) , add a counter, copy the points distance attribute and get number of copy linked with the "cloner",copy the number of each lines*100, calculate at what lenght put the point @int(@Value(_length)-@Value(_copy)) AND snipper ! The problem with that solution is the "cloner", I have a VERY big database and it's make too much geometry... Is there a way to do it without touching or adding the geometry? Or maybe with a formula, ... python caller ?  2) I tried other ways too, like the chopper and the vertex, but it's not a strict interval of 100meters like this. 3) I also tried the method with measure generator, linedivider and

Hi everyone,I wonder if there is any way to force the SurfaceFootprintReplacer to not ignore holes in polygons?I have 3D cityGML data and want to get only the footprint, using the SurfaceFootprintReplacer the result is image Nr.2, all holes are gone and merged to one polygon. There is a custom converter called "GroundSurfaceExtractor" (I found somewhere in the web), what does it correct but this one takes around 10 times longer to calculate. Any hints?(btw: the cityGML does not include "ground_surface" elements to query for, I tried this one...)Thanks a lot!Building Polygon in 2D:SurfaceFootprintReplacer Result:

Hey all,I am using the ArcGIS Portal Feature Writer and when I push my edits to a feature service, it overwrites the editor tacking fields (eg. createdby, createddate, modifiedby, lastmodifieddate) with my username and today's date and time of upload, instead of values I have prepopulated. The table sits in a postgres database and I have turned editor tracking off against that table. Is it possible to push data using the FME writer without those values getting automatically populated?

Hello,An enterprise geodatabase reader interprets a value in a date field as: 20130426000000A file geodatabase reader interprets the same date value as: 20130426This is a problem when comparing date values in ChangeDetector, as they are always noted as an update, even though they are essentially the same value.Does anyone have any ideas on how to make the 2 dates comparable?