FME Form

HelloI have 8 building surfaces with z-value. I also have a ground model. I wonder how to get the building surface to go down to the ground model so that there are sides, 4 sides that go down to the ground model. Now the building surface floats above the ground model in arcgis pro. I want to take the result into arcgis pro.What transformers do I need to process my 8 building surfaces so that they become blocks that correspond to a building.Now it looks like this in arcgis pro:  

I'm trying to overwrite a date/time field with two columns from an excel file. I'd like to use attribute manager to concatenate the two columns into (Date) MM/dd/yyyy and (Time) HH:mm:ss AM/PM however I'm getting null values. The datetimeconverter led to an error saying my format wasn't FME standard. Any help is appreciated, thank you.

Hallo. i am trying to create connection between FME desktop and azure adi have client id an client secret and tennant id but I am not sure ,what is [OAUTH Scope] ?Where should I get it from ?i have written https://Storage.azure.com instead of Oauth scope because it is the resource.then i clicked test but It shows me a window to log in with Microsoft online .could someone advice me ,what should I do ? thanks is in advance fme 2021

Just started my new job and the work environments are very similar (ArcInfo / Advanced License; new office FME Professional edition - old office FME oracle edition) and all I can see is the Open FileGDB reader writer. Wondering if safe discontinued the ESRI File GDB reader and writers?ArcPro 3.3.2 - advancedArcMap 10.8.2 - infoFME 2023.1 - Professional

Hello,  Im searching for a solution to give records a group value based on multiple values statements. Data needs to be grouped on a Vehicle in time asc.So far this is not the problem.The grouping also needs to Start with a value Status = "Start”and all the other records after Start.The grouping needs to be closed after Status End comes as a record.It looks like a range or a ranking. If someone has some idea thanks. Kind regards, Nick 

Hello!I am importing data from Aerodrome data (gdb) to AMDB. Aerodrome has reflectors on the edges of taxyway. What should these reflectors be stored as in the AMDB?Maybe AerodromeSurfaceLighting or some kind of Marking or AerodromeSign or something else? The Reflectors 

Is it possible to retrieve automation tasks/items using the FME Server REST API? Specifically, I’m trying to find all workspaces that are run by automations and I’d also need to determine the published parameters passed to each workspace.The Schedules and Notifications (Subscriptions) REST API methods allow all “items” to be retrieved, which provides access to the workspace details but this does not seem to be exposed in the REST API for Automations…I’m using FME Server 2019.2.2 Build 19817 - win64.

Hi all.I’ve tried to setup a connection to a list of files on a (customer) Sharepoint service without much success.I’ve read multiple other questions about it here, and some provided useful help (prompt=login), but most does not address my issues.The customer has created the site, and provided me with tenant and client IDs, and client secret. And he has created an “app” with an approval of my client (FME Form).First I tried to create a web service, but never got the “Test...” to work. First it erred insisting on getting an approval, but “prompt=login” solved that, but not it errs with a “refresh token” error.The same happens when I try to create a new web connection using the web service in a SharepointOnlineConnector.I then saw that there was an alternative use, using FeatureReader with “Microsoft Sharepoint List”, and here I was able to create a web connection using the previous web service unaltered. Sofar it can only access root douments

Hi, I'm using the latest FME desktop workbench version FME(R) 2022.2.0.0 (20221103 - Build 22765 - WIN64)) to convert IFC to GIS. For some IFCs files the workbench failed at the last step to write to the geodatabase, then the workbench gets terminated. The error is Internal error running translation Postcondition: Expression: FME_SUCCESS == badLuckI'm wondering what it means? thank you. Full error log attached below:Feature output statistics for `GEODATABASE_FILE' writer using keyword `IFC_Process::IFC_Process_FeatureWriter_0': =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-                 Features Written =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- DP_320ELGE00__GCLR_DC_320BDAR02_MD3_0001                  13 =========================================================================

Hi, Ive noted that CouchDB has been deprecated. Of course, this is the exact thing I need right now :( Is there any alternative way to access this database using the latest (2024) version of FME? 

I’m using the ESRI ArcGIS Online Feature Service Writer to update a layer in AGOL.  I have it configured as per the screenshot below.After it runs, the layer in AGOL is visible when zoomed all the way out!So, I then republish the layer in ArcGIS Pro and it fixes the layer so that it now disappears when zoomed out (I could also do this directly in AGOL).I then change the FME writer to ‘Use Existing’ (and not ‘Truncate Existing’) and re-run the translation.This time it works without affecting the AGOL layer visibility.So I change the FME writer back to ‘Truncate Existing’ (and not ‘Use Existing’) and re-run the translation.It breaks the AGOL layer visibility again!I plan to use something like this to update many layers, and I cannot have them all visible when zoomed out.  It would be a complete mess.Am I doing something wrong? How can I update the data (including deleting features) without affecting the AGOL layer’s visibility?

Hello,Is it possible to write new fields in ArcGIS Portal Feature Service with a writer ?I’m getting that message : ArcGIS Portal Feature Service Writer: Attribute 'NAME' on feature type 'Roads' does not match any field on the corresponding layer/table. The attribute will be ignored I can’t believe I have to create those fields with ArcGIS Pro, publish the layer and than run my workbench. Update:OK I just found out that I need my fields to be in lowercase to make it work.But for some reasons some field type are not working.Is there any existing list of all the constraints we need to follow for the fields in Portal? That would save me time! Thanks!

I have a script that pulls numerous datasets together, formats them into a consistent set of attributes and then writes them to .TAB files.I’m having difficulty with date field (STARTD) in the final output because although appearing to be correct in the .TAB files, ArcPy is not able to detect the dates in the .TAB files and instead shows the data as odd characters. Please see the image below for more information. Has anyone seen this before or aware of how to fix the issue? I’m not sure if there is a setting in my FME script that may need to be amended. 

Hi I am trying to use the XMLTemplater with a SUB template. The start of the ROOT expression looks like this (from an existing xml file that it valid)When I run the workspace I get this message. Does anyone know what the syntax error is and how to correct it?

Hello,i need to process excel files, currently by means of FME Form 2023.1, perspectively using FME Flow. These files, however, can differ in columns available. See attachments. The files are processed individually, only one file at a time.If i run the process with file “tk_template_v0.0.xlsx” I want the featurereader to display only the columns, containing in this file. If I run “tk_template_v0.1.xlsx”, which has got 3 more columns, i want these columns to be available in the process as well.I would like to run the script with these files without clicking on the “Feature Types to Read” button any time I process a new file! The sheet name always have the name “Tabelle1”.Unfortunately  I do not find a set of parameter that results in the desired output.The existing posts have not yet enlighten me! Any ideas?    

Hello Forum, I’m attempting a fanout on a geojson file based on specifying an attribute. This is a simple task which I’ve carried out dozens of times before with success on other datasets. However, for some unknown reason it’s failing to fanout on a particular dataset. I’ve read in the geojson with FeatureReader. This is connected to a to a FeatureWriter. In the FeatureWriter I have… Selected format: Geojson (Geographic JavaScript Object Notation)Browsed to a destination UNC path and ensured the .geojson extension is shown. Note that the geojson writer it defaults to .json extension, so you have to change it to .geojson manually.In Parameters changed ‘Reproject to WGS84’ to NoIn General>Feature Type Name selected ‘open text editor ‘ and then selected Primary_Function from the FME Feature Attributes list. Note that Primary_Function is the attribute I wish to fanout on. The attribute exists in the source d

We have a reader plugin (c++) that should be able to set aggregated/ multiple geometry to an IFMEFeature.For example:We have only several IFMEGeometry objects. These IFMEGeometry objects should be set to an IFMEFeature. So that we have finally an IFMEFeature that consists of several different geometry objects/ parts.                                                         IFMEFeatureIFMEGeometry_Part_1    IFMEGeometry_Part_2    ….      IFMEGeometry_Part_nfme_type = fme_areafme_geometry = fme_aggregatefme_feature_type = DepthArea How can we solve this? 

I am trying to compare the total of features from my original data source to the number of features  ultimately written to a dataset.   I thought I’d create a variable from Statistics Calculator result to refer to in my Tester.    Is there a way to reference the global variable I have set within the Tester phrase ?If not, is there an efficient way of comparing the stats between the beginning and the end ? 

Hi,I’ve tried a few times to do this over the years but I haven’t been successful. What I want to do is convert a set of cubemap images into on equirectangular panorama. Kind of like this:I know there are a lot of free python solutions of Github, but I haven’t been able to get any of them to successfully work. I’m not particularly good a python and I don’t want to install any script packages. I’d prefer to do this entirely within FME as I am already loading in the images.Would anyone know a solution?

Hello FME community,I'm trying to create polygons from Polylines. With Aerabuilder I could create 95 percent of Polgons. As you can see in the picture, in some cases no polygons were created.Polygon creation failed (yellow frames) 

Hi,I have thousand of Excel files I need to read but all of them have different starting attributes line. Sometimes line 15 or 16 or 17.(not me who developed that method of working….)The attributes are all the same for all the files.Any idea how I could have the Excel Reader to detect the starting line?Thanks !

Hello ,I am running workbench with caches .to check the result of each transformer . I have main custom transformer includes many custom transformers .when I make any changes inside the custom transformer  so I have to run the main custom transformer to see the results of changes for the inside custom  transformers .but it takes long time and I have each time to wait when I make small changes inside it .Could I run the transformers or custom transformers inside the main custom transformer  without running the main custom transformer for each time ? if possible ,How  ? thanks in advance Fme 2021

Hi folks, how can I resolve the error below;2024-09-06 07:06:19|   1.5|  0.0|ERROR |BADNEWS: No MULTI_WRITER dataset name was specified (couldn't find a value for `PRIMARY_DEST_DATASET' or `MULTI_WRITER_DATASET')2024-09-06 07:06:19|   1.5|  0.0|ERROR |(D:\code\fme\source\engine\core\engine\writrimp.cpp:672) class StatusInfo __cdecl STFWriterImp::getDataset(class stk::ex::UString<0> &) const 

I'm attempting to read in address points from a shapefile and filter them by the "County" attribute field. I'm using the AttributeFilter and trying to import all the values to route the points to their respective ports. When I try to import the values in the transformer, the only value showing up is that of the first feature. Not all of them. When I attach a second attribute filter, all the values show up. I guess I can go about the workflow doing it this way, but it seems like all the values should be showing up in the first attribute filter. Any suggestions?

I have been given a .JSON file to try and convert into an output Esri File Geodatabase format. I have managed to flatten the nested JSON values into attributes, and can view these ok. However, I am having a real issue trying to get my workbench to read the coordinate values that make up the polygon geometry objects. If someone could assist that would be much appreciated. I have attached a file, but stripped it back just to include the line containing the coordinate information for one polygon. Thanks, R