FME Form

I am attempting to use the arcpy.da in the python caller transformer in FME workbench 2021.1 build-21627 W 64 bit , ArcGISpro-2.9v installed. I am wondering if there are any suggestions to getting my workbench to successfully access the arcpy.da module. I have setup the preferred python interpreter in the FME options. If you provide any help /documentation related to the Arcpy in FME it would be highly appreciated. Also getting following error while running the FME Workbench? 

Hello everyone,In my workspace, I have one point cloud feature (IFMEPointCloud). The points have x y and z components , but many of these points have unnecessary digital precision. My goal is to round all coordinates up to two decimal digits. After reading the FME documentation and checking the FME Forum, it turns out that: "CoordinateRounder" does not work with point cloud datasets;"PointCloudExpressionEvaluator" only rounds float components using ceil and floor expressions, thus resulting in integers.As a workaround, I am trying to use "PythonCaller" to go through each individual point of the IFMEPointCloud and then round their xyz components. The documentation for IFMEPointCloud is, however, limited, and I don't know how to reach the point/component levels.Any ideas? Thank you in advance!

I am trying to utilize the Anchored Snapper to snap the edge of a zoning area to the underlying parcel boundaries. The tool visually works great; however, it is utilizing the vertices of both features resulting in overlaps and slivers that are later detected in our workflow. Is there a means to have the Anchored Snapper only utilize the vertexes of the anchor? Is there a better tool option that will not change the parcel feature?

Hello.I am looking to split some of the attributes of a filed into 2 separate fields while rest stay in the main field contents. even the split one part goes to separate field and rest stays in.example I have following data:Banana 24Banana 25Banana 26Banana 27Apple 01Apple 02Apple 03Apple 04Pear PearI want it like Banana stays in original field and 26 goes to separate field.but nothing happens to pear.I tried using tester to filter them out then attribute manager with string function to replace but length is not same for all attributes how do I handle different length?Thank youNikki

Hi All, Hoping an extra set of eyes on this might solve this.I am using XMLUpdater to update geodb_metadata_string and everything works fine until I use a Conditional Value. Then I produce the error below. I have tried several different conditional statements, with and without quotes and have run it as PlainText and as XQuery but always the error. Pics from the Updater and Conditional Value below. Thanks for any ideas.Starting translation...Unbalanced quotation marks encountered on line 438 of file E:\GIS\FME\test\wb-xlate-1644023348637_43516 -- line was `FACTORY_DEF {*} XQueryFactory2    FACTORY_NAME { XMLUpdater }    INPUT DOCUMENT_FEATURE FEATURE_TYPE AttributeExposer_OUTPUT    INPUT QUERY_FEATURE FEATURE_TYPE Sheet1_XLSXR_2    FLUSH_WHEN_GROUPS_CHANGE { <Unused> }    XML_TEXT { "@EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>geodb_metadata_string<closeparen>,XMLUpdater)" }    COLLECT_CONTEXT_ITEM_NAMESPACES YES    SEPARATE_DOCUMENT_FEATURES YES 

Hello,The following settings of the StringReplacer works for some feature attributes, and doesn't work for others.This is aimed to replace dots for commas (or vice-versa) in a decimal number.So, it normally works for example like 100.5 -> 100,5 But, I just used the very same transformer in a different feature, and the result is zero, for example: 100.5 -> 0 Both columns are 64-bit real. I can see in the the "cached features" in Data Inspector that a valid decimal number goes in, and out goes the zero. Any ideas?Thanks in advance

The ultimate goal here is to orient overlapping lines in the same direction so that later offsets will come out neat. The lines have been processed in multiple steps and when I apply a OrientationExtractor it says: no_orientation. Is there another way to get the orientation, other than the Topologybuilder which is quite slow and requires a few extra calculations? Also is the Orientor the only way to rewrite orientations to a line, or is it possible to copy it somehow with something like a FeatureMerger?

I'm playing around with security settings and it seems that if you password protect a custom transformer, it still spews out info in the logs from the internal guts of what's going on. Is there a way to prevent the internal guts of a custom transformer from being logged? Ie. I just want to show the input and output of the transformer. Is that possible? Seemed maybe like it was from this article https://community.safe.com/s/article/password-protection-for-fme-workspaces

I have tried reading out to a file geodatabase and then reading that out with the where clause to shapefile but would like to try something more direct

We can't seem to get it to work using any of the available transformers, nor any of the help we've searched for online. We just end up with either the data in the output table staying the same, or an error in the transformation. We are using a standard file GDB in ArcMap with a FC containing about 10 million records, and we want to replace about 200,000 of those records with updated info that is located in another FC in the GDB (based on a common field (county)).  Is there a way to do this??

Hello, I'm working with FME2020. I want to import several excel files with the same schema from one folder as different features. With a xlsx-reader (select multiple folders/files) all files are written in one feature. With a path reader I can't define a schema. Is there a way to read all the files with one reader or do I have to use one reader per file? Thanks in advance

Hi Guys, any ideas of how to solve this please (I'm a novice so take it easy please, I have a workbench that has 2 readers and 2 writers, the first part of the process reads and SDE featureclass , manipulates some attributes and writes to another SDE Featureclass - it has a run before and a run after sql for dropping indexes and constraints and recreating indexes and constraints and running a stored procedure. The second part of the process reads the updated featureclass and filters by query like value=1 then writes to a csv file. This all works however the second part does not select the correct number of records - its 6 records short. Its possible due to the before and after sql scripts taking a while to finish and commit. _ I can brake this into 2 workbenches and its all perfect but I'd like to keep them together - is it possible? Thanks Paulg 

Hello! I have a workbench in FME Desktop 2021.2 where I need to write out several XLSX files from the same dataset, with exactly 1500 rows in each, and each one named FileName_1.xlsx, FileName_2.xlsx, FileName_3.xlsx, etc. I have managed to do this using a Counter, and ExpressionEvaluator. The ExpressionEvaluator takes the attribute from Counter (_count) and creates a new attribute called "_result" using this expression: @floor(@Value(_count)/1500) + 1 So that gives me the sequential file numbers that I want to append to the file names based on 1500 rows in each one. I can do this if I include the "result" attribute in the Excel writer, and use a FanOut Expression like this: FileName_@Value(result).xlsx This produces the Excel files with the correct file names, with 1500 rows per file. However, my question is, how can I exclude this "result" attribute in the Excel files? I don't want that attribute being written out. If I remove it, there is then no

I want to do some transformation on a schema/datamodel of a GDB and write it into a new GDB (which should be basically the same schema with these adaptions). But i do not get any output if i use Format: schema (any) and feature reader. Does anyone has some ideas for me? I´m a newbee using FME.

I am in the process of developing a custom transformer that can write a coded domain list to a new file geodatabase file, using this article as inspiration: https://community.safe.com/s/article/creating-and-associating-geodatabase-domains-dynam  The hope is to create these domain values either from the existing data or a look-up table within FME. Then upload the file geodatabase with these new domains to ArcGIS Online. I have followed the guidance in the article and believe it should work. The attached transformer edits the schema feature of the relevant attribute to something like this: "attribute{7}.native_data_type (string: UTF-8): coded_domain(FloorType:char(255):2:"2":1:"1":0:"0")". But when trying to write dynamically to gdb from the Schema Feature, the domain doesn't carry through.I compared the syntax of writing a coded domain manually to gdb in FME (by editing the user attributes) and looking at the log, and the format is the same as

Hi, can FME write PDF/a format files? I don't see any options in the Geospatial PDF writer.

I'm using FME 2021 to convert Environment Agency 2m DTM data into either shapefile or mapinfo tab, primarily for consumption in InfoWorks.  I've used the RasterToPolygonCoercer to produce shapefiles but my users cannot import them in Infoworks. They receive the attached error. Not sure if its because I'm using a TIFF reader rather than GeoTIFF? The original files look like this:  Any help appreciated - new to this aspect of FME!

Hi! I'm validating geometry of the CityGML files and I want to find out the errors and the smallest corresponding parts of the same feature for visualization purposes. According to the GeometryValidator documentation, features from the InvalidParts output port should contain attributes explaining what issue the smallest part(s) correspond to. With the help of the ListExplorer transformer I can get the error name (i.e. issue_found), but not the details. So the question is, how can I access the details attributes from the InvalidParts output port? That is very relevant because usually error name does not contain all needed information (e.g. what is the subtype of error).  Of course, I could get the error details easily from IssueLocations output port, but then I get only point features instead of surfaces or solids. Is there any solution for this or am I understanding something wrong? Thank you!

Hello Friends, I'm new to FME. Here I'm facing a new issue about Arabic Font is not displaying properly after conversion. Converted data from shapefile to dgn with tags. in the dgn attribute field Arabic font is displayed as some special characters, but in the shapefile, it's displayed correctly. I would like to convert vice versa. legends, please help. Ps. sample csv file attached for your reference. Regards, 

Can any one provide guidance on how to convert a .TML file to a ESRI shapefile for feature class?  Unfortunately I'm not able to upload the .tml and schema to this forum. They can be accessed here: https://drive.google.com/drive/folders/1pnvv5YCRYUE9h5OOt1dNf3jAChWL686F?usp=sharing

I have a citygml file with detailed solid models and surfaces. I'm looking for a Workspace to convert to 3d SHP in separate layers, can anyone help?

I have polygons of two different shape files and would like to have a possibility that FME shows me (either with an attribute or with a flag or geometry) where there are gaps oder overlaps between both...the poylgons should have the same geometry but they haven't the same area.....the second shape is only a part of the first.i have tried some overlayers, intersectors or other transformer but none of them gives me that i want...i think its a combination of some transformers.i don't want to repair the polygons only find these errors!Any helps?Thx Franco

Hi, Need to extract each page from a pdf file and to write them to another distinct pdf file. The issue I have is that the content doesn't follow to the new generated pdf file . Secondly, I want to bind some specific pdf pages to one PDF file.  Thanks

How can I edit a AttributeSplitter feature list to have custom layers names

Hi all. I ran multiple spatial filters to identify intersects between two layers, and now have around 70 attributes (custom named to the name of the layer, rather than the default name), that contain either INTERSECTS or Null. I want to now replace all INTERSECTS with the name of the attribute, using String Replacer or the like. What is the best way to do this? I have attached an example screenshot below of what I have vs. what I want to do. Thanks!