FME Form

Add one field with values from existing attribute table to another existing attribute table. Can any one help me with this problem.

I have workbenchs published to FME server that lets an end user upload a file (KML, SHP, DWG, TAB) that will convert to (KML, SHP, DWG, TAB) plus re-project if the output coordinate is set.If the input file has a coordinate system everything works fine, but if a uploaded file is missing a coordinate system the workbench fails and the end user doesn't know why as they can't see the error logs.This is where I had the idea to give them a txt file saying, add an Input coordinate system. I don't want to make the input coordinate system required as the end user might not know or might enter it incorrectly (I'm trying to make it idiot proof as much as possible 😀 ). Now comes my issue. How do I test for all three conditions; Has coordinates = Converts dataHas no coordinates = Txt FileHas coordinates and no coordinates = Converts data and doesn't send txt file.So far I can only do the first two. There is possibly a better way than what I have come up with. Any sugges

Hello!Once again, I've come across an error I have never seen before and can't find online.I'm adding a new ArcGIS Online feature layer to an existing workbench, which matches points inside polygons (using the PointOnAreaOverlayer) and gives the points the project number attribute from the polygon.This works fine for all the layers inside it, but this new layer gives the following error:ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in '<layerName>'. The error code from the server was '1000' and the message was: '24126: Point coordinates cannot be infinite or not a number (NaN).'I checked the point which was sent to the layer (using the feature caching), it shows on the map just fine and according to the attributes it's an IFMEPoint. But at the end of the coordinates it shows <nan>, regardless of the X, Y and Z values. The main difference between this layer and the others is this one is the first with a Z-value attached. So I expect that's the pro

Sample figure shows the 36 points within a MAIN Polygon (purple color). Each have its respective the data point value and summing up comes to 666. With the sub-polygon it crosses these points and have its own total of the data points within it. Need to take of the sum of the sub-polygon from the overall total (main polygon - 666) and get the % of each result with respect to overall total of main polygon. See table

Hi, I am trying to merge two datasets, one being the primary dataset that has Levels and the second dataset that has Zones. Each level has all the zones associated to that the level. I would like to achieve a dataset that displays this merged dataset. I have created a small sample of the actual larger dataset below. I think the solution involves some sort of list handling but I have tried out several list transformers but so far haven’t been successful, I would like the desired outcome in columns as shown above and not in rows as I think can be achieved by exploding attributes. If this cannot be achieved using transformers, I am happy to use a python script inside the pythoncaller if someone doesn’t mind sharing a script. Appreciate any advice either way.  Thanks in advance.

Using ArcGIS Notebooks in ArcGIS Online (AGOL), I've been able to create users as an admin with the following code from this documentation:from arcgis.gis import GISgis = GIS("home")gis.users.create(username='TESTTWO@newwestcity.ca',                     password=None,                     firstname='TEST',                     lastname='TWO',                     email='gis@newwestcity.ca',                     user_type='Creator',                     role='org_user',                     groups=None)However, when I try this code using PythonCreator, according to this example:from arcgis.gis import GIS def FeatureCreator(feature):    gis = GIS(profile="gis_services1")        gis.users.create(username='TESTTHREE@newwestcity.ca',                     password=None,                     firstname='TEST',                     lastname='THREE',                     email='gis@newwestcity.ca',                     description='TEST USER',                     user_type='Creator',                     le

Hi,If I Check Geometry in the ChangeDetector does comparing Shape in the Check Attributes do anything additional or are the Shape attributes compared as part of the Check Geometry?Thanks,David

Can we extract arcpy code via fme?

I would like to know if there is any way that I can host an Fme Server application on my organization's website (for example) that is published using cPanel. What I would like to do is that through a public website, some of our clients can access a server application. I know that I can connect some other web application to the fme server using rest API or url webhooks if the server has a public IP address, which can be accessed from an external network. Can anyone enlighten me on this issue? I am just getting started in web development and these questions come to mind. Thanks

I have a workbench which has a complex custom transformer added in which a python caller is present. I wanted to check what is happening in that python caller so I used some print statements. But I cannot find those print statements in logs that is being generated. How to get the log of a custom transformer in FME Desktop 2019.

I want to reopen an old case that is still of interest:Geodatabase Error (-2147219884): The Field already exists (safe.com)My error isn't of the "reserved word" origin nor related to having "shape" as an attribute name.When trying to dynamically create tables in a GDB I get the "Field already exists" error. If I send each feature type to a corresponding table it runs.For what I am trying to do, connecting readers and writers by hand is not worth it.Can someone from Safe comment on this?

Hello everyone!There is a SQL Server named on my local machine, for testing purposes.I can not connect the fme to sql, no matter what I write in the login line,He's giving me an error.What am I doing wrong?Thank you!

Hello everyone, I recently updated to FME 2019, since then the IFC - Cesium3DTiles conversion does not preserve geometry colors (it was working fine with FME 2018). I think the problem comes from the Deaggregator. When I inspect the IFC, colors are preserved, but they disappear right after the Deaggregator. Has someone got into the same issue ? Thankssj 

Please refer this above two snapshots for better understanding. Hello,I have 20 shapefiles with no unique attributes in them.This all shapefiles are Line features. I want to generate the output with ovelapping part with exact overlap, and lines which are not overlapping but are parallel to each other at 3 meters distance.for example see below image output seen and generated in ArcGIS for 2 shapefiles. Need to generate same result for 20 shapefile in FME. Need help or solution for this problem.

Both transformers allow using schema mapping defined in an external file (csv, etc). The AttributeRenamers output gives me the desired results, the original values in a new schema. The SchemaMapper, however, requires the addition of an attribute exposer to show the new attributes, and an attribute renamed to remove the old attributes. I assumed the SchemaMapper would be easier to use than the AttributeRenamer but it seems much more cumbersome, especially having to manually expose and remove the old schema attributes. Is it possible I am doing something incorrectly? Is there a benefit to the SchemaMapper I am overlooking? 

Which transformer can we use for finding Dangled Nodes from a Road Network ? (:

Hi FME team, I've tried to find an answer on the community on this and whilst there are definitely similar ones, none quite solve my issue.I'm trying to find the angle of intersection between lines, specifically using a many-to-one relationship. So I have a base line that I want to identify angles of intersection with multiple other lines. So I end up with something like this:Base Line ID Intersecting Line ID Angle1 A 341 B 1341 C 2651 D 70For the exercise I am doing, the closer the angle to 0 or 180 the better.Is this doable? Thanks

i would like to read the name of all excel files in folder and subfolders but i found it takes long time , any ideas please .

i am trying this example:https://playground.fmeserver.com/using-the-rest-api/jobs/ the synchronous job start from a fresh local FME server installationI can succesfully execute the query to get the parameters of the workbench but starting the job returns in a http 400I use postman the token can be generated as well succesfully how can i figure out what i did wrong?

Hi,I would simply need to integrate rasterio's python function for raster sieving into FME Workbench's PythonCaller transformer. Indeed there is no native raster sieving function in FME.As I'm not familiar with Python I quickly read through this article but examples there do not apply to raster specifically. Due to my ignorance of Python scripting I am not sure from a syntax point of view how to make the reference to the raster and its bands (if required). Basically my purpose is to eliminate polygons which have a number of cells equal or less than 4. Which essential code lines would be required around the following?:import fmeimport fmeobjectsimport rasterio def rasterioSieving(feature):     rasterio.features.sieve(source, 5, out=None, mask=None, connectivity=8)Actually if you have an example workspace with Python code acting on a raster for any operation, then I would also be interested. As I'm more curious to how the raster is actually being referred to inside the Python script for 

I'm looking for this article: https://www.safe.com/blog/2020/10/build-virtual-conference-booth/Does anybody know why it is taken down?

I was wondering if anyone here can help me out with an FME expression that is part of a larger FME puzzle. Skip ahead for the FME expression I'm trying to write, or read the whole thing for background information. As most of us know, there is probably more than one solution to the overall puzzle. Background information about the FME puzzle:I have a Table1 with a column called USERNAME that is a list of names, and a column called called USERPHONE that is a list of associated phone numbers. I have a different Table2 with a column called BLDG_INSP with a list of names, and an empty column called BLDG_INSP_PHONE. Based on the information in Table1, I want to populate BLDG_INSP_PHONE. Initially I tried various Joins and conditional statements in AttributeManager, but no luck. So, I combined USERNAME and USERPHONE into a single column called USERNAMEUSERPHONE, separated by a comma, to use as a bridge. Ex: <Anthony Stokes,123-456-789> The idea is that I can write a conditional state

As mentioned in the title, I am trying to rotate faces to conform to their corresponding surface normals. I got the surface normals by calculating them from 3D points (turned to convex polygons, grouped by ID) and extracted the normals as attributes. Then I merged these attributes with flat surfaces (using common IDs) and applied these measures to the surfaces using GeometryPropertySetter. I assumed that would do the trick in rotating the surfaces, but the faces remain completely flat, even with the surface normals applied. Is there something that I am missing, or some other way to do what I am aiming for?I appreciate any help on this. Thanks a bunch!

I'm using the AttributeExploder to prepare a two line table for an HTML report, the header as 'name' column and the value line has another.  How to avoid unwanted 'values' or hide them? It adds those two:fme_geometry fme_undefinedfme_type fme_no_geom Or is there a way to filter out value before using in the HTML report transformer?

Is it possible to use FME to calculate the optimal route that covers all roads in a network?  The scenario is that the garbage truck needs to ensure that all houses have their garbage collected in the most optimal way? Has anyone done something like this - similar to a travelling sales person problem but they are going to every property?