FME Form

We have FME 2020.1 32 bits installed on a Windows 2019 Server, With ArCGIS Desktop 10.6 and ArcGIS Pro 2.5. With the 2 Oracle Clients 64bits and 32 bits, configured with 64bits before 32bits in the PATH. It works all fine fine for all users connecting to this server and using FME with the Esri Geodatabase (ArcSDE Geodb) reader/writer. But suddenly for one user the ArcSDE Geodb) reader/writer does not work anymore. The database client is failing to load. : -(   The error in the workspace is :Creating reader for format: Esri Geodatabase (ArcSDE Geodb)...Opening the Geodatabase readerAn ArcGIS license is already checked out. The product checked out is 'Standard'Installed ArcGIS version is '10.6'Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because th

Hi! I have two sets/layers of polygons, one containing boundaries for areas which my company have responsibility for, and one layer containing the categorization of the environment within these boundaries. The categorization layer should of course match the boundary layer exactly, but that is unfortunately not the case. Often, the categorization layer either overlaps the boundary, or there is a (very small) gap between the two. I have accomplished to remove the environment overlapping the boundary using the Clipper transformer.  What I want to do now is to fill in the gaps between the two layers, so that the categorization layer matches the boundary layer exactly. What I imagine I want to do is to fill in the gaps with the closest environment layer polygon, so that the polygon stretches out and snaps to the boundary. Any ideas on how to do this? I have tried to merge the two sets with each other, but since they do not have any common attributes that have failed.

In the JSONTemplater is there a way to cast an array of strings into an array of intergers? https://community.safe.com/s/question/0D54Q000080hA0SSAU/how-to-coerce-attribute-type-for-jsontemplater?t=1636407693748  answers the question for regular attributes   but this does not work with fme:get-list-attribute. {"ids": [(fme:get-list-attribute("_list{}.id"))] }returns {"ids": ["1","2","3"]}    I would like{"ids": [1,2,3]}  

Hello, Can you tell me if FME is compatible with SAP R / 3? Is there a connector for this system in FME? Did anyone used this? Thank you! Nicu

Hi every oneI have a lot of CityGML files and want to edit the roof type for some of them. After that I want to write it again as it was at first:1-Some normal Buildings and some Buildings containing Building parts2-Each address attached to a building3- roof, wall, and ground surfaces attached to each building But this part of connecting child and parent doesn't work. I attached my Fme file. Can somebody help me? It is really frustrating.

Hello FME Community,When I write the result, I choose Fantout based on an attribute. As a result, I get my data in Folders, but I would like to get my results not in a Folders but one after the other. I want to know if there is a solution for this. (The pictures show what I get as a result and what I actually expect) 

Hi All,I am trying to convert ERSI shapefile(LOD0) to Cesium 3D Tiles using FME 2017 Writer. Here is my workspace :When i use Cesium to visualize it, bounding volume of tile is skew like this:I use Cesium's Template code to visualize(change url to my tileset path) so i guess my code is fine.Could anyone help me on this?Thank you,

Can anyone explain what I need to do in FME to connect to an ArcGIS Pro Layout to create the PDF Map of the Layout. Do I need the FME Data Interop Extension in ArcGIS Pro to do this via Python? Does anyone have examples of this code?

Hi! I have a dataset with 75,000 entries that were user inputted, and therefore have several typos. For example, they are proper nouns, some are labelled "kathryn" vs "katheryn" vs "kathrye". I'm trying to find out how to use a fuzzymatcher where each of these is matched to the ID that they most align with. Some challenges here:1) This is a register, so there may be 50 entries that are labelled "katheryn" and 50 entries that are labelled "kathryn". If I use a fuzzymatcher which doesn't have a threshold, then it doesn't work for me as each one connects to itself. I'm considering a similarity ratio between 0.7 and 0.99 for this reason.2) I want to preserve all entries, as entries include other data that I need for further analysis. Ideally, the output would be a column which uses an identifier for all entries that fall within the similarity threshold. Do you know how I can do t

As stated, I am trying to add both geodb_polygon & geodb_attributes readers, and polygon gets added twice. Everything under General is grayed out and I am unable to change 'Allowed Geometries' on one of them to geodb_attribute. Geodb's were created using Arc 10.8.1

Child workspace is using a published parameter (integer) in a RasterExpressionEvaluator.The parameter is sent from a WorkspaceRunner.Translation fails with a fatal error. From log:"2021-11-07 13:01:35|  0.5| 0.0|ERROR |RasterExpressionEvaluator_3 (RasterEvaluationFactory): Failed to parse the EXPRESSION_LIST clause. 'A[0]' was successfully parsed, but '-/10' could not be parsed. Please ensure that your syntax is correct" The evaluated expression was supposed to be: A[0]- $parameter/10, but is left blank.

We have an ArcGIS Online hosted feature service that has ArcGIS attachments. Using FME, I have no problem downloading the feature service to a feature class in an ESRI file geodatabase, including the attachments. Now our users edited the downloaded feature class, I will need to upload the feature class to ArcGIS Online to overwrite the content of the previous hosted data. Overwriting the feature data works fine, but I can't find a way to bring along the attachments. I am trying to do a truncate/insert operation. Any idea how to do this correctly?

I have a problem after updating FME to 2021.2.I use a txt file to get the workbench in a batch depoyment.But after i have updated FME to version 2021.2 i get a notification that the file not exist. (name of the file txt.txt) I have this problem in all my workbenches who are running in a batch deployment. I have this problem after updating my FME.  Logfile:Processing C:Gladheidsbestrijding      xt.txt (1 of 1) Translation FAILED with 1 error(s) and 0 warning(s) (0 feature(s) output)Text File Reader: Source dataset 'C:Gladheidsbestrijding       xt.txt' does not exist An error occurred during the batch file execution of C:/Users/EJANSE~1/AppData/Local/Temp/FME_1636366013186_13572. 1 translation failed. The following error message was raised:#1 : Text File Reader: Source dataset 'C:Gladheidsbestrijding  xt.txt' does not existProgram Terminating Translation FAILED.

I am trying to write data to a xml data format. The problem is that I get an extra tag or element as shown in the following screenshot, so my first question is how can I get rid of the element which ends with -tabel? My second question is: In the element name I add some extra information like id and parent id. I add this in the xml writer Feature Type Name. This addition comes in the head of the element as well as in the tail as shown in the following screenshot. Is there a way to show it only in the head of the element? I want to have something like the following screenshot: I hope that someone have an idea an

Good Afternoon, I would like to remove the south and Est limit from bounding polygons. Indeed, I have a matrix composed of multiple bounding polygons, their limits are topologic. I need to make geometric operations on points intersecting these polygons. A point can belong to one unique polygon. Unfortunately, some points are located on limits from 2 polygons. The solution I would like to do is to create a new matrix where the limits south and est of each polygon are removed : Consequently, the polygons won't be topological anymore : In this case, a point cannot belong to 2 polygons unsing intersection method.I tried polygoncutter (using the polygon and the limits as Input), but it seems not to work : Any idea?Thank you  

Hello!I have a layer in AGOL named "park furniture".I want to make a backup via FME to a FGDB named the same.Im wondering if there is any example of a workspace were i can see wich transformers i need to use if i want to make a backup from a feature layer in AGOL to a FGDB. I dont have any schema in the FGDB but want to use the one from AGOL and also transfer the domains and attachments straight into the FGDB.  Or is it better to make a copy in Arcgis Pro first and the keep overwrite/update the FGDB.  /Tim

I am transforming a shapefile of roughly 25,000 Los Angeles County parcel polygons into cityGML for upload to Cesium Ion. The translation is successful in FME Workbench, but when it uploads to Cesium Ion, it makes the following error in the Cesium Ion assets browser:  We were unable to process your data due to the following issue:Error: Input does not contain any eligible features for tiling.Read about what data formats are supported on Cesium ion. which is not very helpful. When I view the resulting cityGML file in FME Data Inspector, I see that all of the separate parcel polygons have become one joined polygon (and the extent probably should be trimmed). I see from the tables that I have created one CityModel and roughly 25,000 GenericCityObjects with missing column data. I've a

Hi, I'm new on/to FME. How to check CVS header spelling. Example I have one CSV file and it contain name and location as it header. Header should be spell as name and location, if it spell as Name/NAME or Location/LOCATION it will return false/incorrect. Thank you.

Hello FME'ersHere's your weekly round-up of FME news, and there is a lot of content this week! FME2021.2 ReleaseYou'll have noticed that FME2021.2 was released yesterday.  What's new in that version? Well, we have a newly added CKAN reader/writer. Because it's delivered as a package this isn't totally new. It was added to the hub in August I think, and can even be used with older FME versions. But it's new enough to count!  What's definitely new is a reader/writer for Esri Knowledge Graph. I know very little, so luckily we have

Hi, I have the following table: What I want is to get the column names into a new table as values: Everyday there will be a new name for Column3,4,5,6. The new name should just be added to table without deleting the old values. How do i get the column names into the table?

Hi! I have a dataset with 75,000 entries that were user inputted, and therefore have several typos. For example, they are proper nouns, some are labelled "kathryn" vs "katheryn" vs "kathrye". I'm trying to find out how to use a fuzzymatcher where each of these is matched to the ID that they most align with. Some challenges here:1) This is a register, so there may be 50 entries that are labelled "katheryn" and 50 entries that are labelled "kathryn". If I use a fuzzymatcher which doesn't have a threshold, then it doesn't work for me as each one connects to itself. I'm considering a similarity ratio between 0.7 and 0.99 for this reason.2) I want to preserve all entries, as entries include other data that I need for further analysis. Ideally, the output would be a column which uses an identifier for all entries that fall within the similarity threshold. Do you know how I can do th

Hello FME Community! Year long learner, first time poster, please go easy on me.  I've been trying to add a prefix to all files within a directory. I have searched the forums for answers, and have tried a few different suggestions from previous posts but for some reason, my files don't get renamed. In this example, I would like to add "2022-" as a prefix to all filenames in a folder. So far, I have used the "Directory and File Pathnames" Reader with the following settings:Next, I have used the Attribute Manager to change the filename properties:Finally, using the File Copy Writer to put the files into the same directory:

I have a shapefile in which the download URLs of many tiff images are written in the attribute "RGB". I have to download all tiffs and save to my filesystem. I first tried with the HTTPcaller transformer which downloaded the files but named them all after the header description. I couldn't find a way to determine the filename in the transformer when "save response Body to" was set to "file". Then I saw a post from Takashi in which the FeatureReader transformer was used to download files. This downloads the files into an fme-Temp directory and I am able to name the indivual files according to an attribute in the Shapefile, but after the transformer has done it's work, all the tiffs are automatically deleted. Unfortunately I have no idea what's doing on here but i'm sure i'm only a short step away from being able to download the tiff files to a directory of my choice with the correct filename.

I have also a folder with many features shp .My goal ist to make at once a loop that for each features in the folder , i want to transforme in cad format , and eah feature will be store in differentes folders with the same name (the name oft he feature) 

I have a folder with many features shp .My goal is to make at once a loop that for each features in the folder ,  i will use one feature(a chosen feature) to clip each , and each feature will be store in differentes folders with the same name (the name oft he feature)