FME Form

Hello, I have a response from one of the APIs I'm using that is formatted as the following example:{ "measurements": { "timestamps": [ 1504377563, 1504378166, 1504378372 ], "waterGround_mm": [ -5032, -5030, -5031 ], "waterNAP_mm": [ -7532, -7530, -7531 ], "validity": [ null, null, 1 ] }}Now, I can flatten this using FME to the following lists:_timestamps{0}: 1504377563_timestamps{1}: 1504378166_timestamps{2}: 1504378372_waterGround_mm{0}: -5032_waterGround_mm{1}: -5030_waterGround_mm{2}: -5031_waterNAP_mm{0}: -7532_waterNAP_mm{1}: -7530_waterNAP_mm{2}: -7531_validity{0}: <null>_validity{1}: <null>_validity{2}: 1Now my idea would be to rename these lists somehow to _list{}.measurement, _list{}.wat

Is it possible to set the Cache-Control header using the S3Connector? When I set Cache-Control in the Metadata it changes it to x-amz-meta-cache-control, which supposedly doesn't influence cache control on client requests. My Content-Type metadata changes are working. Is that a bug or expected behaviour? Via Cloudberry   

I current have a workspace reader that reads all of fmw files in a selected folder and use the WriterFeatureTypes to find all names writers in each fmw file being read.But when I run it, it produces errors and warning messages that aren't relevant to the writer (screenshot below).Since I only wish to know the names of the layers that the writers in each fmw file writes to, is there a way to avoid reading other information about the file such as the transformers to remove getting these errors/warnings and improve the runtime?

Hello everybody, i have a question regarding lines: i have a network of lines in 2D. The information of the z value is stored in 2 different attributes: height1 and height2. I would like to add the height1 to the coordinate0, and would like to add the height2 to the coordinate1 of the line. So far i tried some ways but could not figure out how to overwrite the coordinates of the line.  any help would be very appreciated. thanks a lot rené

I have a network that is just input lines from shapefiles.All line ends are snapped together correctly. The network has an origin point that is a point feature shapefile.I want to be able to run the TopologyBuilder and assign that origin point as node 1. From there, each subsequent intersection of the lines where a new node is created should be incremental from the origin Node 1. In my attached picture you can see the top part of the image is what I want.The bottom section of the image is what comes out. In the TopologyBuilder I am using end nodes only, so there is no overlapping intersections creating false nodes. I have tried to plug the network into the NetworkFlowOrientor and it does not do anything if I then rebuild the topology after it. Does anyone have any ideas as to what could be

Hello Forum, What is the best part of the community for raising potential bugs / unusually behaviour in FME Form 2023? I've looked around but couldn't see anything obvious. I'm happy to post it in here, but if there is a more appropriate location then that would be ideal. Thanks,Stuart

The data lod-2 is available for public download from the servers of the bavarian Opengeodata platform at: <https://geodaten.bayern.de/opengeodata/OpenDataDetail.html?pn=lod2> here is the direct link to a 2x2 km square that is downloaded as citygml: <https://download1.bayernwolke.de/a/lod2/citygml/704_5322.gml> I have a whole workflow for processing that data, which stopped working without any changes to the workspace. Then i realized that i can not even read the data into a brand new workspace with the same basic error message being shown:'http://repository.gdi-de.org/schemas/adv/citygml/1.0/cityGMLBaseLoD2.xsd'

Could someone please provide a dead simple "Hello World!" example of using the FILECOPY writer? Try as I might I can't figure out how to get this to work. Thanks. This is what I've done so far:FME Workbench >> File new >> Blank workspaceWriters >> Add >> FILECOPYDataset: \\\\server\\share\\source folder >> OKOpen "user attributes" and set:filecopy_source_dataset = "\\\\server\\share\\source folder\\filename.ext"filecopy_dest_dataset = d:\\tempfilecopy_dest_filename = xx-my-filename.ext At this point "Run Workspace" doesn't work. "Run to this" does work, but aside from filling the log window nothing appears to happen.Workspace and log are attached.  

Hello FME Community, I am using a 'StringConcatenator' and a 'Text Writer' to create a text file. I intend to add two separate texts as the header and footer.  Is there a way to add these texts without duplication? 

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.  

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 99The 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

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 UPDATETurns 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 UpdateI 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 T

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

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). 

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