FME Form

I am generating a weekly Excel report and I wish to dynamically add a new column every week containing last week's data. Also, I need the column name to include today's date, for example - 'Outstanding work 04/10/22'. Is there a way to achieve this?

Hi everyone, I have a workspace where I am trying to test some element attributes to see if they match certain conditions/values. So kind of like: Location: Melbourne (fixed for all elements in file)Asset type: various (varies per element) I have around 80 of these attributes to test. The tests parameters are contained in an Excel file, i.e. I have a file that has the following columns: Attribute NameAttribute value (either has a value that I want to check against if Fixed)Attribute type (contains term 'fixed' or 'varies') Other than writing each individual rule into the Tester, is there a more efficient way to do this, particularly as the parameter spreadsheet may update and I want to avoid re-writting all the tests? Thanks in advance for your help! Amit

I have one table where id already there now what I want is when I push the new data it will generate an automatic id  for example the Table ID is 47 and when I push new data then that table insert from 48 in ID columns I use a counter to generate the ID from new data and then I use the static calculator from Table so it gives me a max number of 47 and when running that wS then it's not generate the ids

Hi! Is it possible to slice 3D objects at a specific height?  For example, I have a 3D model from a building, and I'd like to know what the exact outer bounds of the house are at +2m above ground level.  Thanks,Mark  

I want to test my GML file against a schema to make sure that it is valid. To do this, I am using an XMLValidator transformer. I am not sure how it works.When I add a reader for my GML file, it loads all the different feature types. I also selected my .xsd file containing my schema. Connecting these to the XMLValidator goes excruciatingly slowly and everything seems to fail anyway.If I select my GML file as the "XML Filename" parameter for the XMLValidator, and then my .xsd file as the Schema Location (Validation type "Syntax and Schema", and then unconnect the Feature Type readers, it seems to work, but I have inspectors connected to the "Passed" and "Failed" ports on the XMLValidator and nothing seems to go through either of them, even though the workbench runs successfully. Am I using it right? 

For example, I am splitting 'label' - TCY/D/N3000000. In this case, I only need the 'TCY' to be part of the list. I have multiple labels with different values instead of 'TCY'. I then need to display these as row names in Col A. upon writing to Excel as below: (Col B should count how many 'TCY' labels in the dataset. DA_List CountTCY 150BGS 20CUR 50

I am using Treesize to search company folders for GeoTiffs and want to add to a map to view coverage. I need to have a function to add these Geotiffs from the file path outputted by Treesize. 

Hello, I want to extract roof textures from an imagery raster. In input I have a raster and a polygon.In output I would like to have the image I could use to texture the polygon. Is there any transformer for that? Thanks!

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 the sheet, or in a separate file but with the correct file namne.3: This is the table with information that I also need. So what I need is this. A clean table, and for

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 this error,  in my anaconda environment the code runs without errors.  Do you know what could be causing it?

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?