A read-only category for lost FME Form topics. We hope to move them shortly.
Recently active
Hi I'm trying to create a workspace that takes in multiple Esri GDB files from a specified folder. For some reason though, only the original GDB file I started with seems to be able to pass (MyProject1.gdb). Any other GDB when passed through my FeatureReader is automatically rejected, but the log file doesn't say anything useful beyond that I need to save my GDB files correctly, even though the process has been identical for the various files. For some reason, if I were to copy my original gdb and put it in the same location as the original file, the workspace seems able to process the original file, but not the identical copy of it at all. There might be a chance that MyProject3.gdb is corrupted but that's highly unlikely since I did it in the exact same way as MyProject1, but I can't understand why the exact duplicate of MyProject1.gdb cannot be read and gets rejected.
Hi, I know this has been asked a few years ago but is there a straight forward way to extract attachments from an ArcGIS online feature service?Thanks
I am following the Trailmix for FME Certified Professional (we don't have server yet and need to complete the first one). Before scheduling the exam there is the module on FME Server Authoring. Should this come after the FME Certified Professional exam has been passed? I don't want to do 7 hours of training if I can't do the exercises and it's not covered in the first exam. I am just querying the order of the modules here, not the content.
Q1. I need help adding 15mins to the this datetime: 5/10/2023 06:45 PM Q2. I also want to be able to pick two datetime points to calculate the duration in hours. Eg. (a) 5/10/2023 07:00 PM (b) 5/10/2023 12:00 AM Tried several options but can't get it to work. Thanks!
I have created a parameter that allows the user to extract records between 2 chosen dates.The problem is that if the user forgets when they last ran the FME, the next time it is run, they may get some duplicate records if the "From Date" chosen is a date earlier than the last time FME was run. As usually the "To date" is always the day the FME is run, ideally I would like FME to take the date and time from the log file. That way the user will always get the latest data since FME was last run.But I do not know to get FME to read the logfile and set this up.
Hi, I have been trying to look into options/ possibilities for setting a format attribute in a Sketchup file. In more detail I'd like to set and write a [FME_JOB_ID] as a format attribute for some tracking and verifying purposes later on. I have used "GeometryPropertySetter" to set Traits and GeometryName with attribute value, but as the geometry could be deleted in the Skp file by user, attribute information could be lost.Therefor I tried to look into the SketchupParameters and the Schema Attributes section for writing format attributes instead of exposing. I also had a look into SketchUpFeature. Does anyone know more about the section "Attribute Dictionaries" and how it works, or any idea on how to track a Sketchup file by setting a custom ID? Thanks!
Relative beginner here! I'm trying to set up a workbench so it can take features, assign them groups and then assign sequential values per feature in a group. The Counter transformer does the first part but I need help with the second part. I've used the StatisticsCalculator transformer which adds sequential numbers but is there a way to add letters (e.g. a, b, c... and so on)? Or is there a way to do this in the text editor? Thanks for any help!
I have a network of lines, and I need to identify the genuine odd one out.In the diagram below, the red lines represent "Active" lines and the pink lines are "Inactive" lines.Those lines that branch off from the network to a dead-end are genuine, the "Inactive" lines that have an "Active" line either side have been incorrectly attributed, and theses are the ones I need to identify. I am new to FME, so a nice step by step guide would be appreciated please.
This seems easy but I'm not sure how to go about it. I want to do an initial match on ID1 and then detect if ID2 has different values. So A has different values in ID2, and B does not. Initial dataRequired Data
I'm trying out FME Flow 2023.1 and need to run my workspace with breakpoints. When I reach a breakpoint, the Feature Inspector pops up, as expected, but I'm unable to inspect the attribute values. A new column containing the Data Type of an attribute has been added and the Value column has dissapeared. The only thing I can adjust is to show the Data Type column or not. This makes the usage of breakpoints and feature inspection almost useless. I'm interrested in viewing the values for each attribute, the data type is rather irrelevant.
Hi,I have a workbench that is using an azure blob storage connector. It runs fine on form but when I try to run it on flow I get the following error: I've tried to manually upload the ABSC.fmx file to flow, and to the workspace file repository but nothing seems to get me past this error. I can see the .fpkg file in the resources>engine. I've looked through documentation but can't find where I should placing this package. Any help would be much appreciated. Many thanks, Sam
We have a lot of CustomTransformers which we use across projects and we also use git. I recently posted another question about the Workspace Compare tool supporting CustomTransfomers (.fmx files) but the answer is that it's not currently supported but it might be coming (https://community.safe.com/s/question/0D5Dm00000c770oKAA/any-plans-to-include-formats-and-custom-transformers-in-the-compare-application) I know that I can compare the transformers if they're embedded in a workspace, however, initially I thought this wasn't very helpful as the product is the CustomTrasnformer. I did some experimenting and digging and discovered that there is a way to "Export" a CustomTransfomer from a workspace via the command-line. It's very hacky and not really at all designed to be used in this way but I thought it was a nice finding and I'm going to try and see if I can use this approach to help compare changes across various projects. I was wondering if anyone has pl
I have for example 10 excel files in the sourcefolder that all be read from FME but only 8 files have the right basenames to go through the first tester and the rest of the workflow.......i want at the end move the excel sheets from the source folder in a destiantion folder....all that works already.....but now the filecopywrter move all files from the source folder......how and where i can put a condition that FME should only move the excel files which have the right basenames? Cheers and greetzFranco
Hi, I have 2 attributes that are text from a pair of text files, i want to combine them into a single attribute. I'm using an attribute text file readers to pick out the text, then creating an attribute for each of the text_line_data ouputs and naming them initial (first file contents): First string contents:****************************************************************************** THE FIRE TROUBLE CIRCUIT IS REPORTING A MALFUNCTION! ****************************************************************************** 3 and extended (second file contents - second file's filename is contained inside the first file, hence the extra processing):Second file contents: THIS INDICATES A MALFUNCTION OF THE FIRE SYSTEM MONDAY THRU FRIDAY, 8:00 TO 4:30 PM, PLEASE NOTIFY Bob MAINTENANCE DISPATCH AT XXX-XXXX ALL OTHER TIMES, NOTIFY THE TELEPHONE OPERATOR. i'm then using stringconcatenator to combine the two file's contents with a new line between: My expected result here would be
Hello everyone and thanks in advance. I have a geojson of polygons with the fields 'name' and 'area'. I want to know which polygons touch each other but have different area. I have reached the spatial relator with the predicate 'requestor touches supplier'. This generates an output with the 'related_suppliers' field, which indicates the number of polygons that touch the feature. It also generates a list, which I think is where the solution lies. I've come this far but I don't know how to continue. As a final result, I would like a simple table where each record is a neighborhood relationship between polygons. Thank you so much, Pol
A colleague recently installed Desktop 2018.0 and later on 2018.1. Workspace seems to run correctly but when the inspector pops up it logs the following error:Failed to create the reader in the worker process for 2D rendering We can see the tabular data but the geometry won't show up. He does have a 2017 version of desktop installed, this installation seems unaffected by this problem. Any ideas where to look / what to do with these symptoms / logs?
Hello Forum, I have several workspaces where I take a series of csv exports from our other applications and convert to useable GIS files such as tab, shp or gpkg. This example is where I am consuming a csv export from our GMS and publishing as .tab to location A and geopackage to location B. The problem I’m seeing is about the size of the output files. For instance, take this part… The orange circled writer creates this tab… Which has a combined files size of 56.9mb… The blue circled writer creates this gpkg, which is 1.3gb in size!… I know gpkg adds a populated 'id' field, where tab doesn’t. But surely that alone can’t explain the vast difference between the two outputs (tab: 56mb, gpkg: 1.3gb). This issue is replicated across the other parts of the workspace's outputs, and in other workspaces where I publish to gpkg. In addition, I think it may have something to do with indexing. So, I tried to set the FeatureWriter to not create the index. But this made no diffe
I have a csv file where the geometry is in LL-WGS84, but displayed into a single field like this: (lat, lon). I am very new to FME, but I think I have managed to first use a attribute trimmer to get the parentheses out. I then do a Attribute splitter, which sends the data into a _list. I send list{0} and _list{1} into a newly made latitude and longitude field for the geodb writer, but I get a lot of warnings saying "FileGDB Writer: The `Longitude' attribute could not be written. The containing feature has been dropped"So latitude gets written, but not longitude, and I dont know whyAnyone know what I am doin wrong?
I would like to know how to build the JSON body for an HTTP POST request to pass in Published Workspace Parameters, opt_requesteremail (who to send an email to), and nm_jobsuccess_topic (which topic to notify on success) for the Data Download Service. The goal is to interface with another web application where a user can to submit an asynchronous "report request," that emails a download link when their report has finished processing. I am specifically looking at the POST to avoid any potential issues with large/complex geometries being passed in as a parameter and being too long for the URL. I had started looking into the FME REST API, and figured out how to define the parameters in a JSON body, but eventually ran into an article that states "A Web Service URL looks similar to the REST API Request URL; however, it exists outside of the REST API. A Web Service URL should be used instead of a REST call if you are intending on using the Data Streaming or Data Download Service. A job sub
Should it be possible to determine the details of the user or machine that "called" a workspace app shared by a URL link? Currently I'm seeing the name of the "owner" under the "RAN BY" column, but I'm interested in learning more details about the user or machine that made the call.
About the projectWe have individuals checking traps and bait stations (points) located on different properties (polygons). Every time someone goes to visit a property they create a point record so we know who has been there and when. Output requirementsWe need to fill out a word document (template given to us by the client) for each property we visit. What I thought I could do to automate this process currently being filled out manually by the team lead:Set up an FME process using the property parcels (polygons) and trap and bait station records (points). Use a PointOnAreaOverlayer and add the important point data onto to the property addresses. Each property has one form (filled out with a list of visit dates and who was there). I watched this really useful webinar. It's gotten me far considering I've never worked with word in FME before, but I still have some questions.https://www.youtube.com/watch?v=5H1BsmXCTrY QuestionSometimes there are multiple point records if multiple
If this is a bug in 2022, then I can think of upgrading my FME version to 2023. Please confirm.
I'm sure other people must have workspaces running this, but so far the only transformer I found was the emailer and no Email writer. At the end of the workspace I want to send an email to one of our staff summarizing what happened in the last week (how many traps were visited, names of the land owners and their contact details). This data is of course all in the workspace already. How do I set this up so it goes in one email with ideally a table of the above? Not individual emails per property. When I go into the Body of the Emailer transformer I see there are values I could add in (that looks like lists. They have {}), but when I actually run the process these values are empty in the email. None of them appear. I am not far enough along in my FME journey to understand how lists work yet... I think I might need to use a counter or aggregator so only one feature hits the Emailer transformer, but that feature would need to contain all the data I want in the body of the email. I also
I have a csv with numerous fields that have ( 323244,232324245) and would like to know how i can get rid of the brackets and keep the data
Hello fellow FME’ers! I have a case where I need my on prem FME Flow to listen to certain messages from my FME Flow hosted instance. I want job a job to trigger automatically when a FME Flow hosted job has run. It looks like this is not an out of the box thing. Or is it? for the record: I don’t want to solve this with a schedule task!How would you trigger your FME instance A to run after job on FME instance B has run? A can communcate with B, but B can not send messages to A.