FME Form

HiI am passing a polygon dataset to the area on area overlayer and some of the features seem to be ignored completely and do not pass through the transformer. Surely all polygons sohould pass through with a count of 1 (or more if they intersect other features in the dataset)? Also is there a way to tell the transformer only to intersect with a second dataset and not itself?

I am trying to use the HTTP caller to post the zip file via FME server Rest API. If someone has any starting tips, I would appreciate it. Thanks

Hi,I have an Oracle Non-Spatial reader in Desktop 22.1.2 and when I select "View Source Data"  I get the following error message in the Data Inspector 11 "Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`C:/Windows/System32/CMPROD', userName=`', password=`***', dbname=`')"12 "Error connecting to Oracle database: message was `%5'. (serverType=`%0', serverName=`%1', userName=`%2', password=`***', dbname=`%4')"13 "Failed to specify the feature index as constraints on the reader."The DB connection is OK because I can run just the reader and inspect the cached features in the Data Inspector

Hello, I have two floating licenses on the server, i habe been using in diferent computers but with two in specific it always get the license stuck on the server. I connecetd to both computers and there is no service or application of FME running but when i retrieve the status of the licenses in the server it always appears both of them. I know i can fix by stopping and restarting the service, i would like to know if there is another solution so idont have to go each day to the server and free the licenses.  Best Regards. 

Hello We just updated FME from 2020.0 to 2022.1. I wanted to use a workspace with a file copy writer in it. It still works and copies files. I wanted to change something, but in the file copy writer- dialog there's one tab missing and I cannot fill in anything.That's how it looked in FME 2020.0That's how it looks now in FME 2022.1Is this a bug or how can I change the parameters? Thanks in advanceVera

Hello, fellow FME-ers!  I have a question for you. When I use the HTTPCaller I want to send a request and then control the time out length before I receive an answer. From what my college and I can read in the documentation there is no way to do this?

I'm using a DatabaseJoiner to look up rows in an Excel file. This Excel file has about 6,000 rows and about 20 columns. I have an integer FME attribute that finds a matching field in a row in Excel. About 5 'Fields to Add' are concatenated into a new FME attribute. This works great!  I have 4 more FME attributes that contain 1 to 5 comma separated lookup values. One sample value looks like this: 13045,52136,38010. I need to look up a row in the Excel file (for each of the 3 values in this example), then cancatentate the 'Fields to Add' then cancatentate the three final strings into one big string. Do I have to expand "13045,52136,38010" into three new attributes then use each of them in the DatabaseJoiner and create a string attribute for each of them?  Since I have 4 FME attributes that contain 1 to 5 comma separated lookup values, this means that I'll need to add 20 (4*5) integer attributes for lookup and

Hi everyone, I want to search for all Feature Classes in our SDE and list out only the ones that have a field name 'SDE_UPDATE' (date field) with a criteria that queries the ones that have been updated in past 10 days. Any example workbench to share?

I am trying to filter features in a large Revit model by Category, Family, and then Family Type. Each Category has many Families which have many Family types. Using the Attribute Filter import feature on the first level (Category) is fine, but if you want to chain subsequent filters (Family and Family Type), the import brings in ALL attributes for the entire file, not just what is coming out of the respective Category filter outputs. Is there a workaround for this? It would be so helpful to have a “local” setting where only feature attributes coming in to the secondary filter were selected.  Just to be clear, the import feature first gives me a choice to select from a list of feature types, but it still brings in more attributes than what actually is coming into the transformer. The resulting list turns the Attribute Filter into a massive object in the workspace.

Howdy Y'all, I am trying to extract wells data from Enverus (www.enverus.com) but their API has a limit of 100000 records. Can anyone share examples for pagination as well as how to keep the Token active all the time (instead of manually updating it)

We have done:Register an app and make sure the FME has permission to use the app.Make sure the user is allowed to access the data. 

The file gdb is a handy conversion template that avoids a lot of painful domain reformatting.

Hey, I love FME so no product bashing here.... but is there a bug in FME Server 2020.2? I have a schedule that's set to "Occur Only Once" and that I enable to run on a certain/time when I need it. In the past, this has worked great. I'd move up the date to whatever needed, enable it and hit "Okay". Since upgrading to 2020.2 last year, I've noticed that when I do this, the new date I select in the calendar will not take...... and when clicking 'Okay" in haste or out of habit, it will save schedule with the old date from the past and - now enabled - start running immediately. Bug, user error?Plan to upgrade to 2022 when it comes out. So if I don't get any nibbles here, I'll see if that resolves it.

It is to identify the sum of which group. Otherwise, the result is a list of values (for sum) but not possible to identified which value is for each group of features.

Is it possible to generate a horizontal bar chart with the HTMLReportGenerator?

During one of my projects I noticed in my counts that I am missing records.  As you can see 16k entries enter the requester eand only 13k exit via either port. This is connected to missing keys entering into the requestor I know that I can solve this using a nullattributemapper to change missing into null, or by setting reject null and missing keys to 'Yes' (non-default setting). However the fact that this is largely invisible has me worried.  I have also concluded that this behaviour is not consistent. The below workspace has a test setup testing for the behaviour with simple input data. All 4 cases behave as expected. Unless I missed something, I believe this is a bug. If you can confirm, deny or reproduce, it would be highly appreciated :).  

Hi, I'm curious if anyone has found an efficient way to calculate the X nearest neighbors in a pointcloud or a set of 3D points from a single 3D point.  My current method is mathematically calculating the distance from point 1 to every point in my pointcloud with the following formula and then sorting by distance. d (P1, P2)= ((x2 - x1)^2 + (y2 - y1)^2 + (z2 - z1)^2)^1/2   It works but it's not efficient at all. I'm curious if anybody has a more efficient idea. Thanks,Mark   

Hello to all, I'm stuck since yesterday on a problem I can't solve.I want to transfer the attributes of a 2D representation of the roofs of the buildings of a city to their 3D version.I have my 2D data in .gpkg and my 3D buildings in .dwg.According to my geometryfilter, the roofs are surfaces and the 2D data are areas.Everything seems to work on the first objects, my attribute replicates correctly on the concerned roofs, but I still get an error, when processing the 1145th object in my clipper. The error is "Attempted to access the value of an uninitialized optional object".I guess some of the geometries may have a problem, but even with GeometryValidators to filter my 2 data sources, nothing changes.What method would you recommend to fix this problem? Are there better ways than G

I am new to Json queries. I am trying to extract the details from a arcgis feature service as a spreadsheet for the ESRI living atlas requirements. I have gotten really close but I want my features and tables to be in their own column (second screenshot is what I want). What I am getting is the feature layer AFTER its attributes, and in the same column. I am hoping the resulting table can go into the corresponding feature layers metadata page, as they are manually updated at the moment. There is probably a way to do this using substring extractor, but I was hoping I could do it using json as I have to replicate this for 10 more data products.  

Hello FME friends, Server Apps and AutomationsFME 2022.2 is coming out shortly (my estimate is about 4-5 weeks), and one of the new features is called "Automation Apps":  Automations can be started on a set schedule or by a certain event, but can also be started by a manual trigger. An Automation App is how you can set off that trigger through an app or webpage. As I understand it, it's like a workspace app, but the end user supplies information through keys, instead of parameters:  We're already working on articles and videos to go with the launch. But if you've already tried this functionality in the beta version, we'd

Occasionally the Folder (existing) parameter will change a backslash in the folder path to a forward slash when the feature is is shown in the table. This creates a major problem for reading, writing and comparing to this folder. Is there anyway to make sure this doesnt happen?

I am looking for suggestions for a user friendly database editing tool. A client of ours has a deliverable in Excel format. We feed data to it via FME from a SQL Server/SDE database. However the client does edits in the excel file and the edits never make it back to the database. I know, we can load the edited data back to the DB via FME again, but preferably, the users will edit the data directly in the database. The client is used to the editing functions in Excel so we need to offer them something very similar/easy to use. The data to be edited is a non-spatial table but related to a parent spatial object.The tool must have:Allow for bulk editing (replace drag functions in excel). Must be user friendly/no code. We have tried MS Access but it is too complex. From the user perspective they just need to:access and filter a subset of the data eyeball the values and add comments in one column.Good

Dear readers, A strange thing occurs today. In an an AttributeManager, I changed the value of an output attribute, from a fixed string to using a user parameter, partly.The original string was: mkdir "Y:\\Basis\\Kunstwerken\\@Value(KWK)\\@Value(KW_CODE)" I substituted the part in bold with a user parameter (in bold, too): mkdir "$(Kunstwerkmappen)\\@Value(KWK)\\@Value(KW_CODE)" Now, here's the funny thing. If I provide the user parameter with the original string, the result is (one record as an example):copy "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Pictures_LM249DrempelsZestienhoven\\061720122651.jpg" "Y:\\Basis\\Kunstwerken\\Gemalen\\KGM-231\\061720122651.jpg" All seems fine. But the idea is to be able to change the value of the user parameter. So I tried filling in "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Kunstwerken

for examole,I have some 3d point,how I can get near point for one point,thanks