FME Form

I am using the vertexcreator transformer to convert the Lat/long field values into points but the output puts the points in the wrong location. I noticed if I change the data within the spreadsheet so that the longitudinal values are negative (I live in Canada) then the same script works fine. Since I am getting this spreadsheet from a downloaded location I would preferred to have the FME script make the longitude field negative values for me instead of me fixing the spreadsheet before it is consumed into the FME script.  

Hi All,We've been considering using FME Desktop to convert FBX files to Cesium 3D tiles. In general the process works, but there seems to be an issue with using textures. When opening the FBX, the reader says for each component:"FBX_2: Part of mesh in node 'XXXXXX' references material #1 but node only has 0 material(s):The FBX opens just fine in Blender. If we try to export it again, we get a different error which is now:"FBX_1: A texture used by mesh in node 'XXXXXX' references a UV set named 'default', which doesn't exist" Any idea on how resolve these texture issues? The current result (using either case) makes Cesium crash with a rendering error... 

I want to convert a dgn file to a gdb. The information of the cell color and the line width and the style are lost in the process. For example the colur of the cells are suddenly white and the line style is different. Can I put a dgn seed file and a dgn cell library on the reader to keep the information?

 in a normal database environment I would use an innerjoin. What tool or combination of tools can I use in FME to achieve this" 

My data has a 'label' attribute, example - TCY/D/N3000000. I split this to just get the 'TCY' and created a list, then an attribute (DA_abrv) based on that list value. Now I need to count how many features are within my dataset containing 'TCY' in the label and another attribute value, example: (status = 6 and DA_abrv = 'TCY'). Consented is 'status = 6', Engaged is 'status = 2' My output needs to look like this: DA Consented EngagedTCY 5 1BGS 10 12LAY 30 8 I have tried setting a conditional value in the writer to return this but it's not working. Any help would be greatly appreciated.  

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 no problem. It's only an issue when I select View Source Data. Anyone else seeing this? Regards,

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 20 (4*5) string attributes for output? That i

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 GeometryValidator for this kind of problem? Thank you in advance for your answers.

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.