Authoring

Hi,I’m trying to apply a schema from excel to 2D utility lines so that it applies the schema to the lines and creates 3D pipes of the same size, also adding the metadata.I have an idea of how to put this together, however am struggling to select the right information from the excel and make it dynamic.Example: If find ‘water’ in dwg, then apply a 200mm pipe to the center and add ‘water’, metadata1, metadata2 as attributes to the line. Thanks in advance!

There was a discussion from a year ago that suggested that the Esri Portal Feature Service Reader was updated in FME 2023 build 23210 to resolve domain values when the domain is applied at the subtype level of the featureclass, as it is in the Esri Utility Network.Esri Utility network reader subtype layer | Community (safe.com)I am still having trouble getting a domain resolved that is at the subtype level. Maybe I’m doing something wrong?   FME2023.1 (build 23619)Using the Feature Reader transformer: Portal Feature Service of my UN data, layer is PipelineLineLooking at the attribute material:In the schema result from the reader I see attribute name: materialattribute name: material_resolved 

Hi,I am a very basic Flow/Server user, but handy enough at Form/Desktop. My company recently upgraded from 2022 to 2023. I have noticed after the change a few of my workspaces no longer have their description appearing online and I can’t work out why this wouldn’t.For example, in the workspace description I would usually put a basic description or some instructions. I then publish it to Flow, and it used to be that the description would be in the online interface. Does anyone know what’s going on and how I can make this reappear?It used to appear here:The workspace does have a description:  

Hello everyone,Is it possible to extrude a surface through its normal instead of the vertical?Thank you:) 

This may end up as an Idea, but wanted to ask the community first: I have been trying to find some way to generate pdfs of floor plans that will contain annotation objects at specific coordinates, labeling things in the floor plan where the annotation can then be edited/appended.  Also, I want to ‘embed’ a GUID in each annotation that can be used to link back to other systems.    Use Case:Taking a pdf of floor plans onto a construction site, making comments on the provided annotations that can later be loaded into a Revit model by leveraging the GUIDs that came from Revit objects.  The pdf could be generated directly from a Revit model, or coordinate and GUID data could be extracted separately and added as a layer. You can imagine most buildings contain hundreds if not thousands of components that need to be maintained and tracked.   This is a universal problem for building owners and maintenance personnel.    As far as I can tell, there is n

I am running a workbench that uses dates as parameters. If I run the command in a windows cmd window without admin privilege's, the date parameters are not passed into the workbench. When I run the cmd window with admin privilege's it work as expected.  I am fairly new to FME and I am not sure what I am missing. Any insights are appreciated.  string passed to the cmd window:"C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\fme.exe" \\myserver\myworkbench.fmw --SourceDataset" --SourceDataset" --SourceDataset" --DestDataset_CSV2" \\myserver\myfolder\mycsv" --odbc2_where_clause "(reptd >= '2024-2-1 00:00:00' AND reptd < '2024-3-1 00:00:00 00:00:00')"  --FME_LAUNCH_VIEWER_APP" YES" 

Is there a setting to disable the translation log window from automatically popping up when running a workspace? I’ve disabled all logging and hidden the window, but it pops up as soon as I run. I’m trying to record the execution of the workspace for a presentation, and the window keeps getting in the way.

When using the Transaction Type: Versioned Edit session in an ArcSDE geodatabase writer, all edits will be rolled back in the event of a translation failure. The geodatabase writer is set to Insert records in my workspace and I noticed numerous duplicate records after the translation failed due to conflicts identified during reconciliation. Do we need to modify anything in the writer? Thank you!

I’m a newbie using FME although I have also experience with SQL and GIS. I recently started working on a transformer using the AttributeManager. This contains ~ 40 attributes and the goal is to convert part of those attributes based on different conditions, and others attributes based on a same expression: @double(@CurrentAttribute())I was wondering if there was a method to apply the same attribute expression on several input attributes at once while keeping everything in one transformer.Thank you in advance!

I have a column of data with a 10-digit alphanumeric value.  I need to keep those values and in a new column return just the last 5 characters of that columnI thought it would be as simple as creating a new column in the attribute manager and then in the attribute column I put in the string function @Right(NODE_NUM, 5)I have tried at least 4 or 5 different formatting methods, using quotes “ “ or extra parentheses while writing out the string function, but I am lost.  I use this exact same string function in MapInfo all the time and it works like a charm.  But when I put in these values in just inserts “e_num” into each row as e_num are the last from characters of NODE_NUM.What am I doing wrong?results in

Hi Community, I am working on developing a workbench which is basically reading Data from ESRI Enterprise Database and Writing to another DB. I am using ArcGIS Pro Version 3, FME Desktop Version 2022 and FME Flow Version 2023. I am able to connect and read data using FME Desktop But the published workspace while reading the data it is showing error “779 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 780 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 781 2024-3-19 11:07:16 | Performing query against GEODATABASE_SDE dataset `' 782 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 783 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 784 2024-3-19

Hi I’m using FME Workbench 2019.2 to read a DGN-file and then transform that to an SVG-file.This is working quite fine but we have seen that the texts are slightly offset. I did some investigations and figured out that if I could move the text-features to the coordinate value that their attribute igds_insertion_x and igds_insertion_y pointed to then was the text more accurate placed in the SVG-file.So I used an Affiner to move the text features to coordinate (igds_insertion_x,igds_insertion_y). But the strange thing is that after the Affiner is executed then is the values fme_text_size, igsd_text_size, fme_rotation,igds_rotation changed. The inspector  below shows the same text before and after the Affiner. 

Hi, I have this problem on FME qnd I don’t know how to fix it : Microsoft Excel Reader: Connection failed. Connection string `Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DictionnaireVariables_ITV.xls;Extended Properties="Excel 8.0;IMEX=1;HDR=YES"'. Provider error `(-2147467259) Erreur non sp\xE9cifi\xE9e'Can you help me please ?

FME friends,As you know, the Transformer Gallery in FME Workbench is the window that exists in the lower left hand corner of Workbench, and gives you access to transformers.However, now that most people are using Quick Add instead, we are considering removing the Transformer Gallery from Workbench completely.Obviously, with a big change like this, we want to first get your feedback on how this might affect you.So please:Visit this page to find out more information and to cast a vote in our poll of users. Add your comments to the thread below (but do check out the other page first).I closed the poll. The results are 66% to remove the gallery, 33% to keep it. I’ll let you know what the product managers decide and wil

Is there a way in Form to find out the active FME Flow Connection when running a workspace?I thought it might be a (hidden) parameter somewhere, but I can’t find it immediately, and it doesn’t seem to appear in the logs either.I was wondering if I could use it to determine which environment I’m working in, setting up a development parameter is an easy workaround but might be useful one day to know/log the active flow connection anyways

Running into issues while running a workspacef_85 (HTTPFactory): [4]: HTTP transfer error: SSL connect errorf_85 (HTTPFactory): [4]: Please ensure that your network connection is properly set upf_85 (HTTPFactory): [4]: No proxy settings have been entered.  If you require a proxy to access external URLs, please ensure the appropriate information has been enteredf_85 (HTTPFactory): An error occurred while accessing the URL 'https://static.inaturalist.org/photos/355260564/medium.jpg'The below feature caused the translation to be terminated 

Hi how can create a perpendicular line that connect point to line, I mean I need to connect red points to blue line with a perpendicluar line  thxFrancesco  

Hello FME community, I have a workspace which I always run with quick translator. Since my user parameters are never going to be changed, is there a way that I can simply double-click on this file and it runs with quick translator without the need to click OK or press Enter to confirm the user parameters? 

I’m on 2022.2 and using a StatisticsCalculator with a Group By (based on the name of a CSV) to get statistics (min, max, mean) on a handful of attributes.  It works great for all but 1 attribute (Specific_Gravity) and I can’t figure out why.  The attribute type (64 bit real) is the same between Specific_Gravity and Temperature_F so I’m not sure why one works and the other doesn’t.  The kicker is that I can get Mean values for Specific_Gravity but not Min or Max.Do I have the transformer configured incorrectly, is it a data type issue, or something else??Screenshot of transformer with results: 

I have a dataset of features that I'm trying to insert in a Postgres (pg14) database. That data has a number of text columns that together make up a "report name" plus a timestamp. The name and timestamp together make up the primary key of that dataset. There are also some more columns that contain the actual data. The table I'm inserting this in currently has 800 million rows, and I'm inserting in batches of around 50k rows about a hundred times a day, so keeping indexes small is important. Given the above situation, the text columns from the "report name" have been put into a separate "dataset_reports" table" (~60k rows); with the timestamp and actual data being stored separately (with a foreign index) in their own heavily partitionned "dataset_reports_data" (~800M rows) table. In order to insert data in that table, I need to upsert dataset_reports with all the unique report names in my feature set in a first pass, then get the FK value for all these reports and t

We have FME 2022 with floating lic, with 2 editions, Database, and ESRI.   Would like to install FME Form 2024.0 along side FME 2022.  I know at some point Safe did away with Lic Editions, any idea if we can use the same  FME 2022 lic file and make it also work for FME Form 2024 ?  .

I have a workspace in FME Form 2021. It includes an Automation Writer. This writer writes keys from FME Form to my Automation in FME Flow 2021,  Given this is the 1st time I have pushed FME Attributes into an Automation as Keys, just being curious, I clicked on the “View Written Data” icon in the Automation Writer. It gave some errors and a new windows opened with red in the parameter boxes. It would seem wise to disable this icon when a Automation Writer is chosen. Are there any plans to do this? This does not impact my workspace or Automation. It just seems a bit annoying, unless I am missing something? See my screenshots for a better illustration of what I see happening: 

Hi when I try to setup the coordinate system for my reader to EPSG7792 the Arcgis data interoperability doesn’t have  Can you support please ? thx Francesco  

Our company has a new credit card. So, I have to change it in the billing in FME Hosted. But there no place to do this. As far as I know i'm the admin, so should have all the rights.Does someone have an idea?

Is it possible to read field aliases from an ArcGIS Feature Layer? I see there is a way to do this if connected to an Esri File Geodatabase, but the data I am working with is service based. I am currently using a FeatureReader connected to ArcGIS Enterprise.Thanks in advance!Sasha