Best Answers

In the same workspace, I have 2 "lines" of attributes.I have to test an attribute value in line 1 to pass an attribute value of the line 2.I tried with an Aggregator, but all the attribute values are gone just after the Aggregator.Maybe it's just for geographical data.Is there another way?Or is it just my parameters in the Aggregator not right?

When I populate a FeatureReader with dynamically generated values containing the options I want, it works but not completely. It reads the parcel data I want, but returns no schema/attribute data:  If I manually fill in the values in the exact same reader. It produces the output I do want (I.E. the parcels and their data). This is super inconvenient since our process is based on the assumption that we will not have to populate workspace objects manually each time we run them. I feel like I am missing something fundamental here that will great enhance my understanding of FME. Please help me to understand why this behavior is happening. Any help pointing me to how I might get the automated values to generate the output I want would be greatly appreciated. Thank you for your time. Kim

I'm using FME Workbench 2022.2.24. In the window title and startup screen, it shows Workbench 2022.2, not the full version 2022.2.24. (I also have Workbench 2022.2 installed so this is confusing.) I would prefer seeing the full version number in both of these places. I haven't starting using FME Form 2023.x yet. Does anyone know if the behavior is the same?Should I post this as an Idea? It seems like a vey minor issue.

I tried to keep the same credentials to S3, but in the server side, the error points to the process doesn't have permissions to access the file. Does the server's user have to ask for reading privileges in the bucket?

Hi, I am trying to reduce texture resolution on a .obj model. This is what i have currently:The output at AppearanceSetter does not have any textures applied to it. I have tried connected AppearanceStyler to AppearanceSetter directly and it also does not work. So I am assuming that perhaps the way that I am setting the appearance is wrong. Images attached below shows before and afterI have attached the .fme workspace. The .obj can be found here: (due to size limit here) https://drive.google.com/file/d/1Cg6wNNzllzl0M7O6ifciswnPfC_0z57s/view?usp=sharing 

I have a database table that contains many attributes, one of which is controlled by a domain of acceptable values. I have a list containing a unique list of these valueI want to step through this list and each time through the loop select just the records from the table that would be selected if the unique value were inserted into in query:SELECT * FROM Table WHERE AttribInQuestion = WhateverColorFor instance, "Red" the first time through the loop would return:I've setup my Reader to read the SQL table I want to query, generated a List of my unique values, and created a TestFilter. The TestFilter works if I just type 'Red' into it, but I cannot figure out how to feed the filter a variable to save my life. I'm not asking about the looping (I've created a custom transformer for that), what I'm asking about is how to insert the 'Red' value into my filter using a variable? Thank you for any help you can provide. K

I have a workspace where permit data is joined to GIS data through a series of joins. That data is then written into separate feature classes. The 3 datasets in order are as follows BIN Join, BBL Join, a spatial join using the Point On Area Overlayer transformer. After all of these joins happen I'm dumping any remaining unjoined records into a point feature class called Fallout Points. However all of the records from the spatial join are ending up in the Fallout Points layer. How do I exclude them (or delete them after)?

Hello All, I have a Tester transformer that ideally produces no Failed outputs but I want to count the number of Failed outputs, even if its zero. I've tried a few things with no results. The Failed output from the tester doesn't seem to produce any data or if it does, I don't know how to access it. Thank you,Kevin

I have one dataset that has overlapping polygons. I want to advise the data owner of this and ask guidance for what to do when I come across these overlapping areas. I think the best way to do this is to show them all the overlapping areas. I was able to add on the overlap counts to each polygon (AreaOnAreaOverlayer) which is great, but what I really want is to create a new dataset with the overlapping areas. I have had a look at the AreaOnAreaOverlayer and Clipper. Is anyone able to provide further guidance or point out if I should be using a different transformer combination?

I already had a look at the following link and it helped me in the right direction, however I am still stuck. I use values from the boundingbox transformer for determining whether I need a portrait or a landscape layout. See image below how I have defined it. In case the length of the xdifference is bigger than the ydifference, then I would go for a landscape layout.Then I tried several ways to define the size:1) defining the values shown above in the attribute pdf_page_size in the attributecreator transformer. 2) Create a user parameter from above and use it in the pdf writer under parameters "Page Size (points)"3 Using a TestFilter in combination with two PDFPageFormattters don't work I get the following error  PDFPageFormatter (PDFLayoutFactory): Invalid page object '<at>Value<openparen>Grootte<closeparen><space>=<space>Portrait' parameters 'MINX;-260;MINY;1152;WIDTH;255;HEIGHT;39;FIXED_ASPECT;Yes;CLIPPING_ENABLED;No'.  All point positions must be a pos

I am trying to use the string search command to extract the file names from a text string, Path attribute. by reverse searching the path string in order to establish the location of the last sub directory i.e. \\ @FindString(@Value(Path),\\,-0,caseSensitive=TRUE) The forward search works but I can't get the reverse (right to left) to work! using a negative startIdx  

Hi there I am trying to connect a reader to sharepoint to read some information in. When I press authenticate this is the error that I get. I was wondering if anyone knew how to fix this?  All the best-Ed

Is there a method to read all workspaces on a server ex. list all workspaces that have specific transformer or list all workspaces that have specific parameter.  Also, where are workspaces on a server? Is there a Folder for workspaces? Are they ascii readable? Thanks in advance

One thing I prefer to do when building a new FME tool is to log the input parameters in a startup python script in order to facilitate debugging when things go wrong. A sample of the code I use is below.import fmeobjects fmeobjects.FMELogFile().logMessageString("Input parameter 1: ") + FME_MacroValues["parameter1"], fmeobjects.FME_INFORM)fmeobjects.FMELogFile().logMessageString("Input parameter 2: ") + FME_MacroValues["parameter2"], fmeobjects.FME_INFORM)This has worked great for a long time, however it's cumbersome because I need to manually enter the names of the parameters. I'm curious if there is a method for returning the names of parameters dynamically in the startup python script, and then loop through them to include in the log file. If this is possible, I could keep my startup script the same between all tools and simply copy it into new tools without having to modify. 

i have multi rows coming from the source and I want all that rows in one single row and layout same as I mention below Data Source coming like thisI want Output like this in one single Row and the same layout

We have photos in jpg format that were taken with a DJI drone. Usually all EXIF data are easily accessible using the JPEG reader, but not the DJI custom metadata. We need to access the data that shows up when opening the image in a text editor: I tried reading the files with a text reader, but that gives several thousand lines of text and no way of seeing which line of text is connected to which image. This should be a common problem for everyone with a DJI drone? Any suggestions for now and maybe a DJI photo reader or DJI EXIF reader in the future?

I am trying to change the authentication from local to windows authentication in Cityworks. What changes do I need in HTTP Caller parameters? Is the chosing NTLM (username, password) under "Authentication" section enough or do I need to add something under "Header" or other parameters?

I'm looking for information regarding writing features to geopackage with geometry compatible with Geomedia. I have found the article dealing with Geomedia geometry in Oracle (listed below), but nothing for geopackage. In my testing, FME successfully writes, but the tables are not visible in Geomedia. https://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/oracle_spatial/GeoMedia_Geometry_Repres.htm

I have debug logs and found that in the one that has stopped working the request is incomplete:GET /sharing/rest/portals/self?f=jsonThe request in the other add the token:GET /sharing/rest/portals/self?f=json&token=.....Trying to determine if this is a problem on the AGOL side or FME side. Any ideas would be appreciated!Also having the same issue on Desktop.

Hello friendly FME Community! I'm trying to implement a GeoFencing service which will calculate the time spent by vehicles in particular areas. In short, I have a set of points (with timestamps) and set of polygons (geofences) against which I want to calculate how long these points were inside these polygons.  I did make a workspace which does this using SpatialFilter (which identifies if points were inside polygons) StatisticsCalculator which calculates min and max timestamps and DateTimeCalculator which calculates the interval between this min and max timestamps. The problem is that vehicle can move out of all polygons and then get back which will distort the calculation as the period that vehicle was outside the polygon will be included because last timestamp will be inside the polygon. Is there any trick or technique in FME which allows to follow up these gaps and exclude them from calculation described above? Thank you in advance for any suggestions!

Hello, I asked the above question in the New To FME forum, but no takers. Lets see what happens here. My goal is to join CAD wall lines that are collinear and have a gap where the door is located (usually 36"). The LineBuilder does not have a conditional option.  Two ways I can think of pursuing are:Group collinear lines that have a gap of 36" between end-point of one line and start-point of another. Lines have all been changed to a positive vector, so end-points are followed by start-points on X or Y axis.Use the CAD Door layer to locate prospective lines. These door symbols are blocks with an insertion point at the hinge. Very standard. Here is a screenshot, attached, of a typical hallway. There are large gaps which should be ignored and others that are approx. 36". On the left, you see two door setbacks. It is not a problem to separate horiz and vert lines if needed. Any help is appreciated. Thanks,@larue

Hi, I have a workbench that processes data of X number of rows. At the conclusion I would like to send an email to summarise what was done. I would love something like: Hi Ben,  We have just updated the table with 32 new rows. Here is a summary of the data added: ASSET ID | NAME | DOB 150 | Ben | 02/02/1992 151 |Tony | 01/01/2001 .... .... 183 | Michelle | 03/03/1983I have added a statistics calculator to my workbench, this is currently able to give me the summary (total number of rows) to include in the opening sentence, but I am not sure how to add the 32 rows to the email, formatted as a table. I know this has to be such a simple task, I just cant work out how to do it! Thank you.    

I get the following error when I feed XML as an attribute from the XML updater. Reading in an XML file is no issue though.This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins 

So apparently, FME does look for fields that might be a good candidate for creating a point geometry in both Excel and CSV readers (see https://community.safe.com/s/question/0D54Q000080hfENSAY/excel-format-of-attribute). This means that if in an Excel or CSV file, there is a row with column names such as X and Y, FME will automatically try to create a point with the contents of these cells. In the top-rated answer of the above link, it is mentioned that for the CSV reader, this will only occur if the option "Scan for types" is activated. This option does seem to be missing for the Excel reader, though, or am I overlooking something? I have the problem that I am using a FeatureReader to dynamically read from an Excel file (the specific file is only known at translation time, not before) and FME unwantedly tries to create point geometries for the features. The sheet of the Excel file might contain X and Y columns, but these are usually empty and surely not any spatial data. Nev

I have an automation that is triggered when the user enters a record into a database. When that job fails, it would be helpful to have a link directly to the job details in the log file. When the job fails, it sends a failure notification email from an FME workbench that is part of the automation flow. It does this via the emailer transformer. Is it possible to add a link to the log file for the specific jobs that are triggered? Is it better to do this inside or outside of the workbenches inside the automation? Thank you