FME Form

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 use a colleague's web connection to truncate/load several SDE feature classes to AGOL using parameters for the feature classes and connection files. (Ultimately, I want to create a workspace for specific users to access to update any desired feature service)Everything works fine in FME Desktop. However, after publishing to FME Server, the web connection disappears. Once I reset the parameters the connection shows up but does not persist. How do I resolve this issue?Exhibits: 1a - published2a - after Reset

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

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

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.