Best Answers

Hi all.I'm using a dynamic writer to output a series of features as tables in an SQL Server database, adding a fixed schema name in the "Table Qualifier" parameter.However, FME completely ignores this setting, and outputs all features to the default "dbo" schema.I've then tried to add it to the "Table Name" parameter (with "fme_feature_type_name" in "Schema Definition Name"), but then it just errs because the data features "fme_feature_type" now contains my added schema.Is this really WAD ?Why doesn't the dynamic writer accept and use the setting in "Table Qualifier" ?? 

Dear community, I found this video (https://www.youtube.com/watch?v=-dbRKOj-1zw) and this forum (https://community.safe.com/s/question/0D54Q000080h9MY/drafting-of-gmails-automatically) about the possibility to create Gmail drafts. However, I am not sure if this is still possible? Please let me know how I could achieve this.Thank you!

Is it possible to extract the following information about a workbench being run through an automation (all automations will be triggered by schedule): Workbench NameAll READER dataset namesscheduled run time & periodAll WRITER dataset type, and output filename/location I am interested in writing a workbench which will use an HTTPCaller to read all automations tagged with a specific tag, and then take each of those automations and extract those specific attributes above into a csv. 

Is it possible to read all layer names from a DWG source file? By all I also mean the layers which do not have any features on them. For example, if I have a DWG file with the following layers and numbers of features on them:L_01 (with 10 features)L_02 (without any feature)L_03 (with 1 feature)L_04 (without any feature)I want to somehow get access to all the layer names, i.e. L_01, L_02, L_03, and L_04 in FME, even though L_02 and L_04 do not have any features. Alternatively, is there a way to convert a DWG file to a DXF file such that all layers are preserved (i.e. , again, also those that do not have any features on them)?

I have a template dwg with a property set attached to lines and polylines. When I write a dwg and use that template is it then possible to fille the property set from FME?

hello all,I am trying to get FME workbench to output into excel file this part of the log file.any suggestions very much appreciated.thank you!

I want to calculate a buffer around a point using the geometry picker in fme server. Can I use the geometry picker to select/draw a point instead of a polygon or rectangle? :)

I have been trying to get wehook trigger output keys to work, but haven't had any luck. I have an automation with  a webhook trigger, and an output key configured:The JSON I am posting to the webhook is:{    "email":"user@example.com",    "data":"this is a test"}The Log action is set to log:{webhook.email}{message}The automation log is as follows:1 2023-01-09T19:32:45Z | 410115 : (Automations) Assembling automation "test"...2 2023-01-09T19:32:45Z | 410156 : (Automations) Creating webhook trigger...3 2023-01-09T19:32:45Z | 410109 : (Automations) Creating link from trigger...4 2023-01-09T19:32:45Z | 410136 : (Automations) Updating event keys for component...5 2023-01-09T19:32:45Z | 410150 : (Automations) Logging events for component...6 2023-01-09T19:32:45Z | 410105 : (Automations) Creating project "test"...7 2023-01-09T19:32:45Z | 410116 : (Automations) Finished assembling automation "test"8 2023-01-09T19:32:48Z | 410160 : (Automations) Automation successfully triggered9 2023-01-09T19:3

When running FME Desktop and set the Scripting to Esri Python 3.6+ or other Esri Python version and adding an PythonCaller or PythonCreator the workbench fails and gives an error. This bug seems to be related with Windows removing all Icons form the Start Menu. Reinstalling ArcGIS Pro seems to fix the problem.    

I'm encountering an issue reading NetCDF files I got from here:https://dap.ceda.ac.uk/badc/cmip6/data/CMIP6/CMIP/AS-RCEC/TaiESM1/historical/r1i1p1f1/day/pr/gn/latest/ When attempting to use a ListSearcher to search the "netcdf_coordinate_variable" list for an element with axis = T, I get no matches, even though its the first element.I also get no results using a ListExploder and a Tester to test the axis attribute.In fact the only attribute from the list that will match is "name". Looking at the list there are 2 elements, and the second element only has a "name" attribute and no others.I could see why this might trip up the ListSearcher, but I don't understand why the ListExploder + Tester method also fails to match? This is with FME 2022.1.2 on MacOS. I've attached a workspace (data linked above) and a screen shot showing the list has an element with an axis value of "T".

Hello , i have attribute contains may values as streetname (park: mo (beside))street name (park: far away )How could I use test filter at first to find which value contains parentheses inside it ,I mean as (beside) which value has no parentheses inside it then the values that include parentheses after string as ( park: mo (beside))i would like to extract only the word beside at new attribute .all values include parentheses ( at the beginning but I am interested in the second parentheses ,how could I get the all values that contain two parentheses then extract the string inside the parentheses as beside word .thanks for help FME 2021

Hello , I am not sure how to use Regex expression First example :street name 34 (56)street name 56 ( 44 )street name 55(70) or street name 55( 70 )I would like to extract the number between parentheses and add - before the number so it should be street name 34 - 56 second example : street name 56 (text)street name 40 ( text )street name 10(text)street name 40( text )i would like to extract the text between parentheses and create it in new column  third example :street name 20 ( GdR 20 ) street name 22 (23-50)I would like to extract it and add - before the value in parentheses So it should be street name 20 - GdR 20thanks in advance FME 2021

Hello, I have a feature class from an geodatabase that contains larger and smaller features that overlap one another. I sort these features to have the larger features come before the smaller features. The attributes of the feature class are: Id and date The goal is to union the smaller and larger overlapping features, but only keep the attributes of the larger overlapping features. Since there is one feature class the overlapping areas share the same attribute names.  Therefore, I use the AreaOnAreaOverlayer transformer, with accumulation mode set to Use Attributes From One Feature.  However, I am unsure of the behavior of Use Attributes From One Feature accumulation mode. Which attributes are copied over to the resultant feature when the overlapping features are unioned? The document mentions the following for the Use Attributes From One Feature accumulation mode: "Takes all attributes from one representative feature" How does the AreaOnAreaOverlayer determine which of the

Hi,I want to find local low point in the point cloud. It is to bring out possible locations for water accumulation. Does anyone know a solution to this problem?

In a file geodatabase (GDB) to GDB translation, I am writing dynamically to a blank (unpopulated) template GBD that has relationship classes. From a source GDB I am reading features both from feature classes that participate in relationships and from the relationship feature classes themselves. I get the usual geodb_feature_has_relationships and geodb_oid format attributes on the participant features, and I get the usual geodb_type (= geodb_relationship in this case), geodb_rel_origin_oid, and geodb_rel_destination_oid format attributes on the relationship features; however, to keep the workspace generically dynamic and reusable, I need to determine--during translation--the names of the origin and destination feature classes for the relationship classes being read. Of course, I know what those feature classes are before runtime, but the dynamic, i.e., non-prescient, workspace does not. Is runtime determination of the origin and destination feature class names of an existing relatio

Line:01020000A0E610000005000000E040A17B843554C0C987F51E7593414000000000000000006CDB4900853554C0AFD3A0F17893414000000000000000002D2683FB813554C0D677B1BD8E93414000000000000000005A484B8E7F3554C025457646AB9341400000000000000000C4B449797B3554C01A0A32C8AC9341400000000000000000 Using SQL the wkt converts to these 5 points:  -80.83621111628918 35.15201174725332 0,-80.83624274456605 35.15212841370464 0,-80.83605850036174 35.1527936092895 0,-80.83591039039439 35.15366440558345 0,-80.83566124151099 35.15371038859685 0 Lat and long are also reversed in the output. I would like to do this conversion in FME for spatial analysis of the full data base. Thank you,Matt 

I have this equation in Excel:=A2-($A$2-$G$2)*B4/SUM($B$4:$F$4)this A2 and B4 has to change every row. so that the value I just got from the current row calculation needs to be used in the next step.9.83,8.82,7.56,6.41,5.41,5minus0,1.01,1.26,1.14,0.99,0.4it starts with 9.83-0, then 9.83-1.01, then the result which is 8.81-1.26 and so on.how can I write this equation? or how can I get the result of previous row calculation in the current row?

Hi community, A client I am working for recently upgraded their FME Desktop/Server installation from version 2018.1 (20180717 - Build 18520) to 2021.1 (20210730 - Build 21619). I upgraded the workspaces and I am currently in the process of testing. I noticed that a workspace ("gdb2gml.fmw", attached to this thread) behaves differently in FME Desktop 2021.1. The purpose of this workspace is to read a File Geodatabase, map the attributes to a specific format and write to a GML. The output file (GML) is validated against an XSD file (XSD-file and input GDB also attached to this thread).  The validation in the GML writer should fail. The File Geodatabase contains an illegal feature (a multipart polygon) which is not allowed as a geometry for this feature class. In the GML writer, the setting 'validate output file' is set to Yes. In FME Desktop 2018, this multipart feature is detected by the validation and the workspace fails. This is the expected behaviour. In FME Deskt

Greetings,What is the best way to duplicate a writer? Using copy/paste only duplicates the annotation. Thank you. TylerFME 2022.1

Hey everybody,I have a huge csv file with the attribute field "modify_date" and the date is in "Timestamp" - format (so for example 746841600000).I would like to have it in ISO Date format (1993-09-01 02:00:00).Is there any transformer which can do that? The Date/Time Converter is not able to do that... Thanks in advance.Cheers,Fabian

I have troubles in using the LineCombiner, with 2 different datasources as input. The first is fme_line from Postgis (MultiLineString, but deaggregated) and the second is fme_line from Shapefile. Both have the same projection system, are in 2D, and have the same attribute schema: only "troncon_id" as string which should be used as merging attribute. I would like to join common line between the two datasources and produce a unique dataset. Hower, the resulting data a correctly merged when coming from the same datasource, but not merged for lines with the same troncon_id and common point (Qgis snapping option). They do not overlap or intersect.Here are the parameters used:An example of not combined lines :

How do I convert .osm data into shapefile using FME?

Converted ArcGIS Pro Annotation (geodb_pro_annotation) to Standard Annotation (geodb_annotation) with the help of Dynamic File Geodatabase reader and Dynamic File Geodatabase writer. Enclosed the developed FME workspace template for your reference. However, when opened the generated output Standard Annotation (geodb_annotation) feature class in ArcMap (version 10.8.1), getting an error saying "One or more layers failed to draw". Please refer to enclosed screenshot from ArcMap and help to advice how to handle this situation.  Found no issues with the output when used Static File Geodatabase reader. However in our case, need to use the Dynamic File Geodatabase reader only. Thank you..! Note: Enclosed FME workspace created using FME(R) 2022.1.0.0 (20220704 - Build 22618 - WIN64)

We've been using automations to run jobs, and then report the status back to Teams using an HTTP Request to call a Teams webhook. This was working fine in 2021.1, but since upgrading to 2022.2 the teams message now shows the job variable names, and not the values. The issue seems to occur somewhere within the Adaptive Card format - as I can use a very simple JSON object in the HTTP body of the HTTP Caller (eg. { "text": "{job.id}" } )- but it seems as soon as the variable call is enclosed in square brackets - it won't populate the value. Am I making some silly reference mistake?(Attached HTTP Caller body.)