General

I trying to insert the record on the Exiting table but it's giving me null values with successfully

I have a folder with multiple text files.I need every file to be read and parsed, then I need them to be put into an excel file. for every file there needs to be a sheet. Noteworthy is that I need to be able to do this in different folders. I don't always know how many files there is but it can be everything from 1-1000 (very unlikely that it is 1000 though).  I can't seem to find a good way to do this. I think its best if I just show you an example of the text file, images below. FME might not be well suited for this, I know I can do this in VBA in Excel, But I really want to do this in FME because it is way easier to share it with colleagues and more reusable.  This is what I have, this is how one text file looks like:1: I need the file name to be the sheet name.2: This is meta data, I need this to also be in th

I am working with 2 point datasets. My objective is to add two extra fields to the attribute table of the first set of points (red), containing the angle in degrees between this point and both it's two neighboring points (green). Each set of red and green points within the white constrainment share a unique Object-code so it is possible to use "group by". I have tried LineBuilder but I haven't succeeded in drawing 2 seperate lines from each red point to both green points. I have only been able to draw a line that starts at the red point and travels through green point 1, and the green point 2. I have tried Neigborfinder but i can't seem to get the correct information about the angle of the neighbors in relation to the base point. Regards Kilian

I am trying to implement some python code that uses geopandas library, which I have installed in a local python environment on anaconda. I have made a few attempts to run it directly from PythonCaller transformer with no sucess: On fme desktop tools, I configured the fme python interpreter to get the .dll from the environment.I also set the PYTHONHOME to the folder of the environment.However, those configuration didn't work and I kept getting the error: No module named: "geopandas". So, I also included this lines at the beginning of the code in PythonCaller:import syssys.path.append(r"C:\Users\[username]\anaconda3\envs\[environment-name]\Lib\site-packages")After that, I get a new error:Python Exception <ModuleNotFoundError>: No module named 'pyproj._network' I check on the "site-packages" folder and I have the pyproj package installed, so I don't know what could be causing

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... 

 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.  

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. 

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)

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.

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 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

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

I'm looking for some ideas on the best way to update an existing SDE feature class that I'm using as a reader in my workspace. Let's call it FC 1. It's a compilation of active and inactive parcels. I'm using FC 2 as a reader as well and I need to compare the two feature classes. If parcels have been removed from FC 2, then I need to update a field called "Inactive" in FC 1 to "YES". So as I'm writing it out, how do I get that end result to also be the reader for the beginning of the process? This is something that will run nightly. Thanks in advance for your ideas!

How to read a csv file that is inside the Tableaut panel on this website below: https://www.saopaulo.sp.gov.br/coronavirus/isolamento/

According to the current political situation here in Europe, we want to work out a plan B if gas supply will end, and for that case, how to get our gas network back working.  For that task, we would like to analyse our gas network (trace?) in dividing the network in zones/branches. The idea behind that is to use major valves as "stop-object" for the network trace, because you need to get back the gas network in little branches. (vent these parts, before going back on pressure) Our Gas network is topologically correct, and I would use the specific stop-objects (disconnect slides/valves) to divide theses network parts/areas. Is there any way I could use FME transformers to get these resulting network-parts? thx in advance, Christian  

Hi Everyone, I'm looking to read a password protected Excel file and copy specific data to another Excel file. Is this possible?  

Hello! I have a basic scenario where I need to batch move point features, while also dragging line features snapped those original points. The model is a network of split lines with a "station" at every line endpoint. We can assume every endpoint or intersection has a singular station. The sequence of lines and stations make up the backbone of the model. Maintaining that consistency is critical.  Now let's say I've received GPS data which places these points more accurately. A subset of stations now have fields for "Current XY" and "New XY". I need to physically push the points to the new location and this part is simple. Looks like I can use VertexCreator to reset their geometry. But I also need the line endpoints to automatically move with the station. Any thoughts on making this happen? Note that the stations and line endpoints generally have the same XY coordinates, but we assume a tiny spatial buffer is needed t

I am trying to understand differences between FME and smallWorld and what can one do with them. It's the first time I have touch with smallworld and I am especially interested in analysis of the distribution grid. To be more specific, I am interested if and how would be following possible: 1) Distribution grid operator exports part of it's grid to some file2) This file is provided to me3) I can open this file to access distribution grid details What I need for this, is it possible to do it with FME?

I'm using FME Desktop version 2022.1. I'm not sure what the "request denied due to lack of license" is referring to. The workbench is writing to a hosted feature service. The writer is configured to truncate the existing data and insert new features. The web service and connection have been verified as well. Thanks,Frank