Best Answers

I am trying to install FME Flow 20.23.1 on a local MS Windows 2022 Server. I am using / trying to use the silent installer. The command that runs successfully is shown below. The install.logs shows no errors and end with message: "Installation completed successfully" I have an external Tomcat instance btw. I can successfully start the FME Server by using the bat file startCore.bat. After I use this bat file, I can go to http://localhost:8080/fmeserver/ and I can login with admin / admin. Everything looks fine. When I try to start FME Server using the MS Window service created by the installer, it fails with message Error 126: The specified module could not be found I think the service fails fairly quickly in the sense that no real FME processes are started and there is nothing in the log files.  It this is a known issue with running FME Flow on MS Windows 2022 server? I checked the documentation but there doesn't seem to be specific requirements mentioned for running FM

If a user follows a direct link to a workspace app or an app gallery, and there is authentication required, a login screen appears.  If using 'normal' login with username / password, after login the user gets redirected to the URL in the workspace link., which is correct. However, if I use a Microsoft Azure AD login ('log in with microsoft'), the user always gets redirected to de base URL of FME server and not to the app. Is there somewhere a setting we should set to redirect to the url of the app instead of the base url ?

Since it almost exactly matches what I’m trying to do, I started with the workspace posted by @trantatsafe here https://community.safe.com/s/question/0D54Q000080hPh1SAE/agol-attachments-what-are-you-doing-with-the-attachments-after-youve-read-them Problem 1)There are 3693 attachments in the dataset.  When attempting to put them through this workspace, only a suspiciously even 2000 come out of the ListExploder. The others fail with the message MISSING_PARAMETER_LIST. Since they exist (visible from Esri), they must have attributes, don't they? Or am I missing something here? I hate to muddy the waters but there is also second issue: Problem 2)The 2000 records that do pass through do not link back to the points. I initially thought this was due to the reader bug https://community.safe.com/s/question/0D54Q00009PK7llSAD/read-arcgis-online-attachments-and-maintain-globalids-for-both-features-and-attachments?t=1703270433321 but I applied the GUID Generator solution without any success.

Hello,I have lines (linestring) that intersect forming Multilinestring. I would like to know if it possible to "force" them to keep the Linestring format? Example: here is a network with a loop (in red)On FME, I tried a deagregator which gives me 3 polylines , 3 linestring. Ok it's good! But I want juste one line and impossible for me to find how to merge these 3 lines without convert all in Multilinestring. I tried the LineCombiner but nothing happens, I still had my 3 lines.Any help would be appreciated :)Thanks you

I have a DGN with linked word/excel/pdf documents and I am wanting to extract the filenames and connect to the relevant geometry within GIS. When I open the DGN in MicroStation I can see the linked documents but when I open in FME Inspector, they disappear. See attached image of links in MicroStation. I thought they may be pulled through into a 'linkage' field but they don't look to be.

I have a workspace that reads other workspaces, to do an inventory. I have looked for the Startup Python Script but I can't find it, does the FeatureReader not read that information?

I just started using FME and my first goal is to compare values from DWG attributes and Excel rows. Each Excel row corresponds to a DWG file, I use AttributeKeeper to filter out the same number of columns in each transformer and would like to test each column in the DWG file to the Excel file to see if they match. If they don't I want to add that row, where one of the columns is filename, to a new Excel file and output it.  I've searched this forum extensively but can't find a topic that matches my specific question. Some help on how to continue would be appreciated.  This is an example of my input from both Excel and DWG. I want to know if "Value1" in File1 of the Excel file is the same as "Value1" in "File1" of the DWG file, and so on. The filenames are always the same but the column names differs. 

I am working on an AutoCAD to AutoCAD conversion where I am changing the text of text and Mtext objects and writing out the changes. The AutoCAD writer uses the input file as a template as the only parts I want to change are the text elements (whether text/mtext/attributes in a block). I am having a problem where Text entities (autocad_entity = autocad_text) are being written as MText entities in the output which is effecting the positioning of the text. This is happening for all text entities (autocad_text), where I have and haven't made changes Is there any reason why text entities would be written as Mtext, when they are clearly defined as text entities in FME? I have posted some images of before and after below for reference:Text Settings in FME just before writingAutoCAD file read into FMEAutoCAD file written from FME

Is this a bug in FME Flow 2023.1 Build 23619 - win64?

Hello, is there a way to test an integer's length within the TestFilter transformer? I have an integer column that can be freely populated with values, but I need to flag rows that are not 6 characters long. Is there some operation in the Test Clauses window that I can use to test for this?

I ve got some problems with expandig of an Zipfile. With HTTPCaller i download the (free available) file "https://service.geo.llv.li/download//gwr/gwr_li.zip". after then i try it to expand with ZipExtractor. As a result it rejects it always with the error_message: "Unexpected error: File name in directory 'gwrli_Spaltenerklärung.pdf' and header b'gwrli_Spaltenerkl\\xe4rung.pdf' differ." How can i resolve this?

I am creating a flow that runs a number of tests on an Excel spreadsheet and spits out the results into another Excel spreadsheet. The incoming spreadsheets will almost always be in different folders (same parent directory, but each project has its own folder within that), and I would like the outgoing spreadsheets to go to the same folder as input, and have the same filename but with the suffix of 'FME Test Results'. I am currently managing this manually, and wondered if there is a way to do it using FME.I have found several answers that seem to get partway to my goal, but don't seem to fully get there.Thanks,

Hello there, I looked into FME system parameters and Python APIs to find a programmable way to identify release info, such as 2023.2.1, etc., in an FME Form session, to no avail. I would appreciate you sharing your approaches. Bo

Thus, the work of each work area is reported dynamically with each work time. For example, work was done on the plots layer on 1000 plots, 800 were updated and 200 were deleted in Excel form.

The data I am working is real time vehicle AVL GPS data that is dumped into a Feature Class using ArcGIS GeoEvent Server. The Point Feature Class has 104 records.  My objective is to have my workspace act as a "listener" and send me an email every day M-F @ 10a letting me know that GeoEvent Server is reading these records.  Of the 104 records (more records are added each month, so 104 is not static), there are 17 that are not the current date so they are routed to Failed in the Tester. There will always be records in this data that are not the current date.  My question relates to the Tester, the way I have my workspace set up now, is if there are no records in Passed and all 104 records are routed to Failed, I will not get an email. Is there another transformer that needs to be added or maybe a parameter change in one of the existing transformers in my workspace? I want to also get an email if no records are routed to Passed, is this possible?

We used an XMLTemplater (2022.2) to generate an xml message using Excel file input with some optional columns.The XML template contains some if structures like this :            {            if (fme:has-attribute("STATUS")) then <Info> <keyName>STATUS</keyName> <value>{fme:get-attribute("STATUS")}</value> </Info>            else()            }The output xml is correct, but contains empty lines for every missing column, which we want to avoid.Leaving out the else() clause is not allowed as it results in a parsing error.How can we avoid those empty lines in the output xml ?

Is there a way to remove an existing Workspace Parameter from the FME Server Job Submitter? 

Hi,I'm trying to ingest log files into Azure monitor so I can send out organisation wide notifications but i've run into an issue. When I look into the machine that flow is installed on, I can see that it is storing logs in folders in batches of 1000 and it will create new folder each time it hits a multiple of 1000. I can process files into Azure, but this doesn't seem to work with a wildcard in the /current/ folder - it needs a folder that already exists. Is there a way to write these logs all to the same folder? The file pattern/query i'm using: C:\\ProgramData......logs\\engine\\current\\jobs\\*\\job_*.txtMany thanks, Sam

Hi, I have compress a text with AttributeCompressor and stored it in an XML file. The text should be a password, so I don't want to store it as plain text. Then, I read the XML file and try to decompress the password with AttrributeDecompressor. But I only get this:2023-12-15 14:31:40|   0.6|  0.0|ERROR |@CompressAttributes: The 'Compressed-table.Compressed.password' attribute could not be decompressedBy the moment, I'm only compressing, not enconding. But I cannot make it work.I'm using FME Desktop 2022. I'm attaching both workbenches, (compress and decompress), the xml written by the first and readed by the second, and the logs of my execution.Thank you for your help.Best regards.

Hi all, I need to extract the Hex Code Point of multiple letters using TextEncoder.However, the transformer fails to encode Roman numbers and some special characters. You can see in the below screenshot that it successfully encodes Bengali letters and some special characters, but not the others. Anyone has an idea how to solve it or any workarounds? Thanks! 

Hi guys,im using a csv file (with sde feature class names and etc.) as initiator to read various feature classes from a Esri sde database.however i also need to setup a spatial filter on this feature reader to limit the number of record being read. is there a way I can get this setup? I tried add another initiator into same feature reader transformer but seems this is not working.. Thanks guys!

I am trying to generate a point coordinate at the midpoint of Arcs. These Arcs have a very large radius and a tiny sweep, so they look like lines, but they are parts of a larger Arc. Whether I try the arc.GetMidPoint() method, or use Intersector with a crossing line, the point is always off. When I run the features through the SpatialRelator, it returns 0 _related_suppliers. It looks fine at first glance, but zooming in reveals that the intersection point really is NOT intersecting. My hunch is that this is due to the Point being calculated as a float. When using the Intersector or PointOnLineOverlayer, it actually changes the shape of the Arc! Here are some pics to illustrate:Midpoint of Arc at a distance Intersection point at a distance."Intersected" Point from Intersector lines (purple), with actual Arc (grey) close up. It intersects with the Intersector-created Arc, but not with the input Arc:Here is what I am running the features through to verify. Note: If I

I have a linear network that I have processed with the TopologyBuilder. I have a second linear network that I defines the from-to lines for the ShortestPathFinder. My concern is that the polylines in the two linear networks are segmented differently, for example, the Topology Edges are segmented at intersections and the From-To lines are segmented at mile markers.  Is it necessary that the segmentation of the two networks aligns or just that the From-To vertices correspond to points on the Topology_Edges?

QUESTION: Is there anyway to adjust the login timeout for MS SQL connections? Periodically, I've been logging an error from the SQLExecutor transformer which appears to be related to timeout issues when connecting to a MS SQL database. The error below seems to occur at random and is hard to replicate on demand.  'Provider error (-247467259) Unable to complete login process due to delay in opening server connection' I suspect that the connection, periodically, is talking longer then the timeout configured in FME. I know of the 'Command Timeout' parameter but as I understand it this is only applicable to the query length timeout, not the login connection timeout

Hi all,Please help!  From January to April 2023 I worked through most of the FME Desktop/Form Advanced and Server/Flow advanced course. Now, December 2023, it seems my account and the progress is lost. All the badges I gained etc. In addition, some of the trailmixes I followed seem to not exist anymore. Anyone had a similar experience? Or know how this could be solved. Kind regards,Peter Goedbloed