FME Form

We have to update email address and phone number employee information in a REST available application from LDAP/AD and want to use FME. With the LDAP reader being in Technology Preview stage we are a little concerned about moving down this path and may have to use a .net application instead. Is there a timeline for when the LDAP/AD reader will be ready? Thanks, Simon

I want to split my shape file to 6 parts. The count is aprox 600000. How to do this using if condition. Pls guide me

Using FME 2021.1.0.1 When trying to use an FME Server Parameter in a Scripted Parameter, I get this error: ----------------------------------------------------------------------- Starting translation...INFORM: Using Python interpreter from `C:\\Program Files\\FME2021\\fmepython38\\python38.dll' with PYTHONHOME `C:\\Program Files\\FME2021\\fmepython38'INFORM: Python version 3.8 loaded successfullyERROR : Python Exception <KeyError>: 'FME_DATA_REPOSITORY'INCLUDE -- failed to evaluate Python script `def ParamFunc(): import fme repo = fme.macroValues['BOB'] repo = fme.macroValues['FME_DATA_REPOSITORY'] if repo == "Example Name - DEV": env = "DEV" return envvalue = ParamFunc()macroName = 'ENV'if value == None: return { macroName : u'' }else: import six try: value = six.text_type(value) except UnicodeDecodeError: value = six.text_type(value, 'utf-8') return { macroName : value }'Program TerminatingTranslati

I tried creating a spatial relator, but then I'm not sure how to take the results and combine the geometries to an area

I have a layer representing building polygons and another layer showing garden polygons; what I need is to create one merged polygon representing a building and a garden. This is based upon whether the building polygon touches/abuts (borders) a garden polygon, however this must be a 1:1 relationship so if there is more than one garden that the building abuts, then it must choose the garden polygon it has the longest edge with. I have tried to use the NeighborFinder and Dissolver, but it does not seem to work between the two polygon layers. Any ideas are welcome. Thank you.

i have my JSON data at postman and I would like to connect it with FME? how could I achieve it ? another question , could I post the data to FME desktop or should I connect it with FME server ?i am totally new to work with REST API and I would like to know ,where should I start ? FME 2018 .Thanks in advance .

Hi, all.I'm trying to pull a couple of dozen JSON files into FME with an API through flightaware.com, so that I can build flight tracks, based on the unique flight_id of each flight.I built a python script today that accomplishes the objective and saves all of the separate JSONs into one JSON, locally. With some help, I figured out how to pull that JSON into a couple of fragmenters and have been going from there. So, ultimately, I have the option of continuing to run the script separately from the FME session, but I was curious if anyone knows how to integrate an independent Python script into the workflow. Python caller hasn't worked for me, I assume because it's designed to process features not save files locally. Also, I didn't use the http caller because the URL request was done per flight id, so I decided I'd need 20 callers running simultaneously. Is that a correct assumption, or is there way of iterating through a list to fill in the URL request multiple time

Why this is not working? 😕 I am using:2020.2.0.0 (20201027 - Build 20787 - WIN32)REALDWG reader/writerDWGStylerI want to: read DWG file with som "autocad_text" entities,change size of these entities,write it to new DWG file.My approach:I use REALDWG reader to read my dwg:I then use DWG styler to manipulate text sizeI then use REALDWG writer to generate new DWG fileResult:Inspecting generated file with AutoCad shows that size in not changed!Workspace and test file in attachment 

 I have a workbench that has two ESRI Geodatabase (ArcSDE GeoDB) readers. The first (TableA) is a table containing updates that have been made, there could be up to 500 rows found. The other (TableB) is the table that needs to be manipulated based on the updates found in TableA, this table has 500,000 rows.  For efficiency sake, I am hoping to only read the TableB if there are rows returned from TableA. Can we tell the workbench to run the TableA reader first, IF rows found in TableA, then read TableB and continue through workbench processes, ELSE end workbench. Any thoughts on if this is a possibility?

We use the ProjReprojector to reproject data (FME 2020.1.0.1), using a wkt string. For the UK, a special datum shift grid is specified in the wkt2 string, yet the resulting raster is not located correctly when reprojecting to EPSG:3857. I'm wondering if this issue is related to FME, parameters in the wkt2 string or my (limited) knowledge in this area.  When reading the raster, FME reports a crs of _FME_0. I can manually set this to "OSGB-GPS-2015-OSTN15" using a coordinate system setter, yet I prefer to perform the reprojection based on the wkt2 string. Can somebody please assist in how to do this with FME? Attached zip file contains the raster data, the wkt string, a document with the current (and expected) location.

Hi, I have two shape files. One containing roads and one containing the grade of the condition of the road based of an inspection. The shape files share two attributes, starting point of the road and ending point of the road. I would like to add an attribute in the road shape file, which is the grade from the other shape file. Not every road has been graded, but I would like to add the grade as a new attribute for those that have a grade. So, if there is a matching starting and ending point in both shape files, which means that it is the same road, the grade should be printed as a new attribute in the road shape file. I hope this makes sense. Thanks a lot in advance! :)  

Here are the BADNEWS errors, these I haven't seen before. Could someone help me out in the right direction where they are coming from or does someone know a solution? 2021-12-09 14:46:38|  4.0| 0.0|ERROR |BADNEWS: An error occurred while fetching from query `SELECT OWNER, TABLE_NAME FROM ALL_OBJECT_TABLES WHERE OWNER IN ('GBIBASIS','PUBLIC') AND TABLE_NAME = 'GB_MECH_LEIDING'' : OCI_NO_DATA2021-12-09 14:46:38|  4.0| 0.0|WARN |(C:\\code\\fme\\foundation\\framework\\util\\dbwrap\\ocistmt.cpp:663) class StatusInfo *__cdecl STFDB_OCIStatement::fetch(unsigned long,unsigned long &)2021-12-09 14:46:38|  4.0| 0.0|WARN |Exception Name: stk::ex::Throwable -------------------------- 2021-12-09 14:46:40|  6.0| 0.0|ERROR |BADNEWS: Cannot convert null string into an integer2021-12-09 14:46:40|  6.0| 0.0|WARN |(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:348) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned long

Hi,I have FME(R) 2021.1.2.0 (20210903 - Build 21627 - WIN64).With this version, appears the Parameter Manager.And I have big problem with it.I often use a type "Choice" or "Choice Multiple" with a list of around 2000 or 3000 values. And sometimes more.With FME 2019 I had no problem to configure it.But with FME 2021, it takes several minutes to open the Parameter Manager, any modification takes a long time and sometimes, it's so long that FME crash.It's very annoying because it worked great and I can't do without these lists.Have you got a solution or a patch for this ?Thank You

Hi All, I have a customer who is scheduling fme.exe from within Microsoft SSMS - because it has good logging functionality. The fme.exe command is taken from a desktop log file on the server machine. If they run the command in a shell it works, and scheduling with Task Scheduler works, but from inside SSMS as the sql_agent account they get 'FME license system failure: License dependency check failed. This FME suite license is dependent on another license which is not available. Program terminating. Transaction failed. Process exit code 2. The step failed. '. Does anyone have an idea what is the issue? SSMS scheduler has only the one user account available to run jobs, but I assume that could be changed. Thanks.

Hi all, I'm trying to map fields to match a SQL table where some need to be Null and others are Not Null. As far as I can see, I've done this correctly in the 2 NullAttributeMapper Transformers (attached screenshots). Basically I need some to be Null, and others to be Not Null. These have been separated in the screenshots below by 2 NullAttributeMappers. I've attached the error as well, as this is proving to be quite tricky. Any help is appreciated.

I'm trying to get my head around this: I've been given a png image in a polar stereographic projection, a set of coordinates of its extents in LL84 and this PROJ4 string:+proj=stere +lat_0=90 +lat_ts=60 +lon_0=10 +a=6370040 +b=6370040+no_defs +y_0=3609144.7242655749 +x_0=542962.16692185635And the challenge to georeference the image. Problem is I can't use the RasterGeoreferencer with the extents because in LL84 they don't form a rectangle. Any other pure-FME solutions I can try?  

Hello, I have an electronic circuit that accepts 4 hex numbers and output 4 decoded hex numbers. Knowing that I have thousands of inputs and decoded outputs, I would like to know if there is a way to figure mathematically the operation done by this device

Wsdl End point that is inside http caller like post request is running Http caller is rejected fme server but is running in fme desktop     

What are FeatureReader/Writer vs Reader/Writer advantages/disadvantages

Hi,I very new to FME and I am trying to get a hold of things. Right now, I just need to make sure I can simply distinguish elements added to the workbench. However, I can't seem to be able to rename everything. This PATH reader for example, properties are greyed out. There is only one for now but I am planning to add many more and I will need to differentiate them. How can I rename them and that is shows up in the workbench? Kind regards,Anne-Marie

Here is another simple-yet-not question: I am working with a large pdf and want to populate pdf_document_info_metadata attribute values for every feature.  I have tried: FeatureMerger, Joiner, Aggregator, AttributeValueMapper, NullAttributeMapper, AttributeManager (trying to use Adjacent Feature) etc. This should not be that hard, but I'm at a loss. Any ideas? Thanks,@lorenrouth​ 

I've got a dynamic workspace I've set up, where a user can specify a SQL query that will be read from an Oracle database, and depending on user-specified input, generate either a shapefile, file geodatabase, or geopackage. I'm testing defining the schema based on a Lookup Table as outlined in this tutorial: https://community.safe.com/s/article/dynamic-workflow-tutorial-destination-schema-is-de-1 In my initial test, everything worked perfectly fine for shapefiles and fgdb's. However, some of the records in my database hold empty values in certain date fields that have been defined as 'fme_date" in the Lookup Table. In the .shp and .fgdb feature classes, these values are simply displayed as <null>. When writing the geopackage though, I get the following warning: GEOPACKAGE writer: Encountered date with empty or invalid 'yyyy' value. Expected format is 'yyyyMMdd', but got '' When attempting to open the geopackage in ArcPro, the geomet

FME Desktop 2020: How to filter all features that “don’t contain” a particular value? For example, in the screenshot below, I wanted to select all records that their “concatenation” field doesn’t contain the value 10  

Hi folks, I'm trying to read a GPKG Layer from a rather extensive Geopackage which I use as an offline data exchange container. Said layer has a total of 228 objects, of which 47 have multipolygon geometry and the rest are tabular data.  The problem: While FME Data Inspector on its own reads the data correctly, the FME Workbench GPKG reader reads all features as type "geopackage_none" and omits geometries completely. I have not found any reader options to resolve this. What can be done do force FME to read all "geopackage_multipolygon" objects correctly? Splitting the data into separate tables is not an option, since I have to use a given data model. Thanks for any helpful advice!

Hi, I'm still fairly new to this tooling ecosystem. I have "inherited" a workbench and have made some changes to it. At some point, one AttributeManager started to appear in the "Incomplete Transformers" section of the Navigator. It's missing the attribute called "subcontractista": What I don't understand is, this attribute is being consumed in the preceding custom transformer as well as in the other branch that leads from it. I mean, in the following image, the green transformer is parametrized by this attribute and in the Tester that is hooked to the output, this attribute is visible under the FME Feature Attributes tab.There is no other AtrributeRemover or AttributeManager that might affect the presence of the attribute "subcontractista". In fact, I'm quite positive that I haven't changed that part.