FME Form

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!

Hi @daveatsafe​! I am trying to use the Maximo object updater but I am missing the existing object url. Per the documentation I can use the Object Querier the problem is that I cant seem to figure out which attribute to use as there are several url lake attributes. Any thoughts/ guidance that you can provide would be amazing. Thanks so much in advanced. G

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.

Hey everyone. I have 3 road datasets I am working with. One point, one line and one polygon. I need to join these three datasets. The point data is set so that each point is about 100m from one another. I can manage to merge all the data but now I need to create a perpendicular line through my points to create segments of my road data.

I have some data in text files that may contain both points and lines. Each line contains a code and either a sub-code or a coordinate set: 05 1 2302 6826513.392 548235.740 257.374 05 31 2302 6826704.339 548284.671 275.511 09 91 05 1 2302 6826513.392 548235.740 257.374 05 2 2302 6826518.762 548233.548 257.950 05 3 2302 6826525.326 548234.694 258.184 05 4 2302 6826532.691 548235.254 258.606 09 99 The first column is the first code, '05' is always followed by a coordinate, '09' is always followed by a sub-code: '09 91' defines start of a line, '09 99' defines end of a line. So the short example above contains two points and a polyline with four vertices. Any suggestions on how I can turn this text file into two points and a polyline? I have a python script that can handle the parsing, but I was wondering if there is a better way to do this in FME rather than plug the script into the pythoncaller.

I am trying to add the following WMS in FME Desktop: http://gis.rijeka.hr/geoserver/At/wms?service=WMS&version=1.1.0&request=%20GetCapabilities&srs=EPSG:3765&format=image%2Fpng I have no problems loading this map service in ArcGIS Pro but can't seem to get it to load in FME Workbench or Data Inspector. The WMS contains two layers, I have tried adding them individually as well. Not sure what I am doing wrong. Any assistance here would be great.

Good morning! I need to call a stored procedure of DB2 from FME. If I use the IBM Data Studio this script works fine: CALL TESTING.TEST_PROCEDURE('input1','input2',?,?,?,?,?); It has 2 input parameters and 5 output parameters. But when I use the same script in the SQLCreator of FME i always get this error: Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text {my_script}. ERRORCODE=-4463, SQLSTATE=42601 Does anyone have any experience calling DB2 stored procedures in FME? Any help would be appreciated. I'm using FME 2021.1.

I want to read from a csv file and put the contents in an SQL database table. The issue is that there are duplicate lines in the CSV file, so I want to select distinct into the SQL table to remove duplicate rows. Is there a slick way to do this, or do I need to read the csv into a temporary SQL Table holding the duplicates, and re-read the data out of that table using perform sql executor transform into its final destination? .

FINAL UPDATE Turns out the problem was that the hatch fill in my block is incompatible with colors for some reason. Having a standalone circle for a block was ok. What I ended up doing was typing • via Text and then saving that as a block and now my CAD looks like a proper point layer. 2nd Update I added my template file to my writer parameters and I am now able to generate blocks for my individual points, but I can't seem to get the colors from my attributes to stick to my blocks. UPDATE This is my current workflow, but it still doesn't seem to produce a cad file with data inside all. **Original Post below** I have a point layer in an Esri GDB file I'm using workbench to convert to DWG AutoCAD data while maintaining color data. I have no issues with lines and polygonal layers but my understanding is that CAD uses blocks while Esri uses points. I tried a direct conversion where I just had a reader with my GDB and a writer with my DWG and the end result was a file with the points as ver

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!

I'm reading a feature layer from ArcGIS Online containing about 20 layers into FME, each one with proper domains and field aliases. Unfortunately, it is not possible to: first, resolve domains without including only code output attributes, and second, there is no option to "resolve" Attribute names using aliases. I'm then trying to find a time-efficient way to solve this by using AttributeRenamer. I'm currently importing an Excel schema that contains only two columns for Input and Output Attribute and the list of attributes I want to keep from the reader output. In the Import Wizard, I deselect "Sorted" (img 1) to keep the original order of attributes and then I set the "If Input Attribute Is Missing" to "Remove Output Attribute" (img 2). What I'm experiencing is that imported attributes from the schema are still alphabetically sorted despite the "Sorted" box being deselected (img 4) and second, when I run the transformer, I can see that all attributes that were not in the Excel schema

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!

Helllo everyone, I´m quite struggling about loading files to MS Sharepoint on-premise. I´ve found some tutorials, but just for Sharepoint Online. Any ideas please? Lubo

Hi, I'm basically trying to create a dashboard summary of my data but in the statistics stage, want to clarify I'm heading in the right direction as my knowledge of transformers is still young. I'm aggregating information based on a string searcher and want to collect all the object errors from the files and output them with the code name. Hopefully this makes sense with the assistance of the below images (spreadsheet snip is a distilled version of what is in my attribute manager), in short aiming to get utilities - 10 duplicates, 5 outliers, Road - 20 duplicates, 10 outliers etc. Thank you.

I have a workspace that inputs property polygons and bounding boxes from an oracle database and it feeds into a WMS feature reader to obtain a raster image. It then overlays property boundary as a redline on top of the image. How do I maintain constant height and width of the image without stretching it? The WMS I am reading from does not have scale hint, nor does it have scale denominator in its implementation.

Why are inputs or parameters the "\\" is getting changed to "backslash" when using FME Form 2023.1.0.0? Seeing it happen on Workspace Runner for log file as well as database name on database joiner. How wide spread is this issue? Previous version was 2021.2.0.1

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.

Hi I have a LAS dataset that contain small pointcloud one for each signpost along a street. Mi goal is to extract the 3d coordinates of the controid of each small pointcloud. I tried with 3dbuffer but no results thx Francesco

Hi I have a GDB file with feature layers from ArcGIS Pro in it that I would like to use workbench to convert to CAD while maintaining the symbology colors. I have extracted the colors of the symbology in hex code format *(E.g. #ffffff) into the attribute tables of the layers. I added my GDB in as a Reader, added in an AttributeFilter, link the field that my symbology is dependent on back in ArcGIS, then added in a DWGStyler to every single possible option in that field in AttributeFilter. I set the color of DWGStyler to be the field containing the hexcode, and then added in my output vis writer and connected everything. But no matter what I try, the CAD file doesn't register any of that at all. As you can see, none of the hex colors seemed to have gotten into my CAD file.

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 data Required Data

Hello, I am exporting data to kml and in the placemarks list, an html table is included. I would like to have only the placemarks listed without the html table preview. Here is an example: What I would like to get is this: Would anybody have experienced this and know how to sort it out and make it look like the second one ? Thanks, Best regards, Thomas

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.