Best Answers

Hi i am trying to read lots of excel using the feature reader transformer,  passing in the locations form a directory path reader. all the excel have different tab names but the data always start on row 10. As the dataset is a file path the option for telling it to start on row 10 are blanked out. anyone know how i get around this?Many thanks,Andy  

Currently I am working on writing to an IFC-file. One of the classes I would like to write is IfcZone. However, when I try to do that, I get the warning: IFC: Unable to write objects of type 'IfcZone'Now I am wondering whether I did something wrong and I am missing some settings or whether FME does not (yet) support writing to IfcZone?@DaveAtSafe

I am trying to write PDF file using PDF writer, when I add @Value(Scan_Location) in fanout dataset it creates 2 different files as output. And that is not what i want . I just want this name ….20240621 NI2-HK-L03 As-built_PDMS Comparison Report F1.pdf and just one file     

Hi all,I am trying to read a json file, that contains a collection of objects. It is NOT an array, and the objects have no name, they have just a number. It’s that number I am interested in, but I can’t seem to find a way to get it exposed. My Json looks like this:{ "1": { "name": "msg_status", "data": { <snip> }, "port": 4, "timestamp": 1717497996, "timestamp_parsed": "2024-06-04 12:46:36" }, "2": { "name": "msg_ublox_location", "data": { <snip> }, "port": 2, "timestamp": 1717498735, "timestamp_parsed": "2024-06-04 12:58:55" }, "3": { "name": "msg_ublox_location_short", "data": { <snip> }, "port": 13, "timestamp": 1717498741, "timestamp_parsed": "2024-06-04 12:59:01" }, "4": { "name": "msg_ublox_location", "data": { <snip> }, "port": 2, "timestamp": 1717499651, "timestamp_parsed": "2024-06-04 13:14:11" }}and so on, for a couple of thousand objects per file. The d

Good morning,I am trying to open tutorials for the Demos using this link:https://engage.safe.com/demos/When I am truing to go to the Tutorial, I have this browser window opening up:https://community.safe.com/Can someone let me know if this is an issue or there might be a different link? Thank you.

So I have a workspace that reads a DWG, and writes another one after setting viewport attributes according to this article: https://support.safe.com/hc/en-us/articles/25407658483341-Working-with-AutoCAD-LayoutsHowever, even though I’ve set autocad_viewport_view_center_x, autocad_viewport_view_center_y, autocad_viewport_center_point_x and autocad_viewport_center_point_y to display the view at the center of the page, I keep getting the viewport centered at 0, 0 in paper space, so my viewport content is centered close to the lower left corner of the page on output.  I have quintuple-checked that all the required viewport attributes are set correctly.  It seems like the writer is simply ignoring my viewport center settings.I’ve been banging on this for more than a day now, and have made no headway against it.  Hopefully some kind soul out there will have an idea of what could be going wrong.The layout pageThe viewport, 1st page of attributesThe viewport, 2nd papge of attributes + geometry 

I am trying some network analisys (isochrones and route/gpx creation) and I am obviously doing something wrong, I just can't figure out what.I am using OSM highways, unfiltered (I also tried a local route network, same result). The only manipulation I did is convert it to espg 28992RDnew (because it's in meters) before using it as an input for the topologybuilder (also tried topology calculator). Since I have multiple start points I created a road network Per stop_id and used ‘group by’ on the topologybuilder and networkcostcalculator.  The results are very weird. Connected and (way too many) not connected seem random: (green = connected, red = not connected) Zoomed in:I tried pretty much all settings on the networkcostacalculator. When I try the shortestpathfinder it's also clear that something is off, it refuses to use some (random) paths/roads/lines. So it's obvious I am doing something wrong, I just cannot figure out what.  

Does anyone know if there would be a performance difference between having linked transformers stored on a shared external drive compared to a local drive?I do not have much experience with linked custom transformers yet, but my current understanding is that there may be slightly longer load times when opening the workspace using the linked transformer, however no performance decrease in translation. Would this be correct?

I am running FME 2023.2 and have a dynamic workspace that is creating a File Geodatabase (FGDB) with a FeatureWriter, and I am running against ArcGIS Pro 3.2. Recently, I have wanted to access some annotation class properties in that GDB, but I find that I cannot access them. ArcGIS Pro says that the FGDB is version 10.0 and that I need to upgrade the FGDB to the latest version to activate those properties. I looked at the log for the last run that built the FGDB, and I see "Created and connected to the ArcGIS 10.0 File Geodatabase at '[Location]\\template_General_Prod.gdb'" I checked the FeatureReader geodatabase version parameter, and it is set to "Current." So, ArcGIS Pro is telling me that there is a later FGDB version than 10.0, while FME, though set to "Current," is creating a 10.0 version FGDB.  I am confused. Can FME only create a maximum 10.0 FGDB version, or is there actually no later FGDB version ... or is something else going on? 

I have two feature classes (FC) that are linked by a 1:1 relationship. Both FCs contain about 4,000,000 objects, of which I ultimately need about 20,000 objects. I understand that I could join all 4,000,000 objects, but that would take a considerable amount of time, which I want to save.My idea is to select the required objects in FC A and create a new list using the join attribute. Later, I want to use the FeatureReader and a WHERE clause query to read and process the required objects in FC B. Unfortunately, I am having a problem with the creation of the WHERE clause, so no objects are being read.My workflow is as follows:Read and select objects from FC A Prepare the join attribute for the WHERE clause (add quotes) Create the list using the join attribute Convert the list to a string with commas as separators Read the objects using FeatureReaderEverything seems to work except for the last step. If I enter the WHERE clause manually (without the list), it works. Below is my current work

Hi All, I would like to know thatis there any possible way to trigger mail while running my workbench in FME Desktop/ Forms if it is facing a error?.FYI : I am using FME Desktop 2020.1.1 version. Thanks in advance!

HiI am using the HTTPCaller to get the information from Issues page in Autodesk Construction Cloud (ACC).The AuthorizationToken has been created and looks good but once I am using HTTPCaller to get information form issues page,  the result created in “_response_body” is not in the json format so consequently I am not able to use JSON extractor Is there any step that I am missing?P.S:In “HTTPCaller4”in requested URL I used “https://developer.api.autodesk.com/docs/issues/projects/$(PID)/issues”*I have predefined $(PID) in User Parameter. In Header I used “Authorization Token” created in 1st stepThanks

Surely there’s a better way than this???I have a json file with lots of attributes hidden in lists. So I use 5 ListExploders to expose those attributes.The ultimate goal is to then combine all of those attribute fields into one massive table, using the unique identifier field of “NODE_ID”.As you can see in the screenshot the Node list then feeds into AttributeFilter to reduce the number of features a little.So far so good… but this is where it goes a bit mad. I then need to combine all of those 5 exposed lists into one table. FeatureJoiners are then used to try to merge the datasets together.Those in the left hand bookmark are joined using an inner join to try to get as many features with the same NODE_ID value combined into the same row in the table.Those in the right hand bookmark then use a full join to pick up any stragglers from the first bookmark.I have 200 JSON files to work on, and this example uses just one of them, so I have to try to account for all output ports, to ensure n

HiI got an ZFS Pointcloud (here) with integrated RGB colors. These are greytones (concrete) and visible in Autodesk Recap. From Recap i can export the PointClound to an e47 file and the colors are still included.But i got over 1’000 files, so I want to convert them with FME. With the ZFS Reader i can load the PointClound, filter it with the header information as decribed in the help (reflection), but the color is missing. Regarding the help, FME can read the color from an color file, linked in one of the header information, but I got no such files, the colors are integrated. How can I get access to these RGB values (color_red, color_green, color_blue)?

This script works, but leaves out the geometry and original attributes.  My hunch is there’s something wrong with the close(self) function, but I’m stumped.  The code takes a feature id number and list of nearby ids from a NeighborFinder list, where it matches them up and assigns a _group_id attribute to  use with the Aggregator.  Really, it should be part of NeighborFinder.  The way I had been grouping features is to use two or more AttributeCreators and assign a common Id from the feature and id list.  It’s a hassle because you end up with duplicate features.  Very inelegent. I have seen a few posts on missing attributes, but I can’t see how they apply to my code: import fmeimport fmeobjectsfrom collections import defaultdictclass FeatureProcessor(object): def __init__(self): self.og_ids = [] self.closest = [] self.lines = [] def input(self, feature: fmeobjects.FMEFeature): id_number = feature.getAttribute('_count_Glaz_H') if id_number is not

Hi everybody,I have a map with 'Layer A' (polygons district boundary) and 'Layer B' (lines roads).I would like to add a field on my 'Layer B' table with the name of every district crossed by each road.In this example, I would like my Road 1 attribute to tell me it crosses 'City A', 'City B', 'City C', and 'City D'. And my road 2 attribute to tell me it crosses ‘City A’.Could you please show me how to make it? Thank you  

In an sql_executer I run an sql-statement that updates a table, but does not output any features. If there is an error in this update, an error message appears in the log file, but the translation as a whole is successful. How can I intercept this error so that the translation aborts if there is an error? 

Is there a way to specify removal of “white collar” areas in Adobe Geospatial PDF outputs? I don’t see any options in the Page Size parameters to restrict the output to be just the extents of the Reader-specified image source.

The completions API models were deprecated at the beginning of 2024. The current version of the transformer does not have model options like gpt-3.5-turbo. Will there be more options for models in the near future from FME's side?   

Just curious. Currently it takes about five clicks using the AttributeManager to get to AI Assist. Any shorter way?

Hello,I created bounding box in FME and I need to get from this polygon WKT file. How can I reach this in FME please?Thank You so much!

I was installing a Python module and pipeline (spaCy and en_core_web_sm.whl) into FME2023.2.4.  spaCy installed fine, but pip would not install the pipeline and I got this message: Since then, my FME 2023.2.4 will not work, at all.  No translations will work.  I made a blank Workspace with just a Creator and still immediately got:  “Error running translation”.What’s going on?  Did I break it?  Do I need to reinstall? My FME2023.2 works fine with the same Workspace.Any help is appreciated.

Hello,I’m trying to read specific feature classes from an SDE database using a user parameter within a feature reader.I’ve not had a problem with this previously so not sure if it’s a bug (I’m using FME 2023.1.2.0 (20231110 - Build 23641 - WIN64) The issue I’m having is:When selecting feature classes manually in the ‘Feature types to read’ section of the Feature Reader window I can select as many as I want and they’ll all read fine.When using the user parameter (please see settings in screenshot below):Selecting one dataset reads fineSelecting 2 or more feature classes I get the error “Error creating feature dataset 'feature class a feature class b'. The table name or field names may be too long or invalid for the server” Thanks for you time 

I am trying to join a SharePoint table with no geometry to a set of polygons (about 2000 rows). The table has unique project titles for for each polygon that I want to use as a join field; but the polygons themselves are stored as fgdb files deeper within the SharePoint file structure and they are a non-standardized legacy dataset that I am trying to aggregate (hence why I am transferring them all over to SharePoint as the first step).  When writing the fgdb’s I am also exposing the file path as the fme dataset field, so the unique project id’s in the table are a part of that file path. I am trying to use the string replacer to replace all the characters leading up to, and after, the project title with nothing so that only the project title is exposed. Sadly I can’t just count the characters as there are different folders within the file path with different names and character lengths so now I am trying to come up with a more complicated regex expression that will trim the start and th

Hi.I’m using the snipper transformer to extract portions of a line at specific values from the attribute table.I set these parameters for the transformer. I set these parameters for the transformer.The problem that I noticed is that the program considers the first vertex of the line as 0 and the last one as the maximum, and the snipper will split between these two values.Is there a method to define the start value using another value, not 0? I would like to start from 4.21 km.Thanks.