FME Form

Hello FME'ers,Welcome to What's Up Wednesday.  If you're a sports fan like myself, you'll have a lot of Olympic activity to follow already - not least the upcoming women's football/soccer final between Canada and Sweden. So good luck to our Swedish users... but not too much!If you can tear yourself away from watching those events, here are the events taking part in the world of FME. FME Hub UploadsAs always, the start of the month brings a recap of the previous month's activity on the FME Hub. The Hub itself seems to produce a great monthly digest page automatically, but I did want to highlight what looks like a very interesting addition: a

Hello everyone!I create an app for field reports, not something very complicated.I want to produce the reports in PDF format.I used this guide:https://community.safe.com/s/article/creating-pdf-cartographic-outputMy question is for writing in Hebrew.For some reason, I can not write the text in Hebrew in PDF.This is what it looks like in workbench, the caption I want to appear as a title:And this is the output in PDF:I tried to manipulate the PDFStyler, including setting up the writing system: HebrewAnd nothing helped. 

Hi everyone. I'm using the FGDB Open API writer in 64-bit FME 2020.1 (build 20624) to write an FGDB table (no geom). I have 2 "double" type fields in the FGDB table which are set to allow NULL values (I've checked in ArcCatalog). When I run my Workspace, FME refuses to write features to the FGDB table which have NULL values for the "double" fields. I have tried ensuring the values are NULL using a NullAttributeMapper before the Writer, but it hasn't made any difference. I have also tried using the other FGDB Writer - the one that uses ArcGIS Desktop, which seems better - I just need to fix some features which have "null" instead of NULL to complete the testing. Has anyone else experienced this difference between the FGDB writers?

Is it possible to create one dynamic reader for DGN files, which will use different schemasfrom input DGN files? I do not want to lost any kind of data from next readen DGN file schemas using this reader. As usual I read DGN files and sometimes this reader can not load some data from them. I only change the path of the next DGN file to process. 

Hi, I have a workspace that downloads two different files (1 geopackage, 1 textfile), renames them and stores them in a ZIP file. Said ZIP should contain the current date in its filename. Normally I use the date/time functions in the filepath paramters to create the current date on the fly but the options in "Destination Fanout Directory" do not offer these functions. As a workaround a created a Text Parameter where the user enters the current date manually but if possible I would like to do this automatically. Can this be done somehow?

I am trying to automate a process that I currently accomplish using Autocad Map 3D, manually. That is to say create a dwg that referenced a raster and when added to Autocad will pull in the raster in the correct location. At the moment I insert a raster into Map 3D , zoom to extents and save as a dwg. This produces a dwg with the same name as the raster. I have not been able to find out what is in the dwg, so I don’t know how to do this in FME.I am presuming there would be a reference to the raster, it’s extents, scale …Does someone know what FME. Autocad attributes I would need to write ? I am also assuming there would be no geometry in the dwg, but again I don’t know. thanks for any assistance,Ian 

Hello, I'm looking for a method that will allow me to extract a summary from a JSON, but due to the size of each JSON, fragmenting the data first would be extremely time consuming.  For a bit of background, I want to extract daily data from the WebTRIS traffic counter API, with the aim of creating a summary of average traffic speed for the sites in question. The API allows for the download of multiple report styles, however only the daily report allows for the extraction of average speed. The report provides data at 15 minute intervals for each counter for the periods of time that the counter is active. If I wanted to extract the average traffic speed over a year, assuming the counter was active for the whole year, this might mean summarising 35,040 records, per site.  I've looked at using the JSON fragmentor, but due to the potential size of the data that would require summarising, this would create an excessive number of records pe

I have a detailed mesh that is concave in parts so there are multiple surfaces for a given x,y coordinate. What is the best way to filter the mesh so that there is only the lowest surface at any given point. 

Hello, I want to develop FME page to check the CAD layer names if it's match the layer standard name! and then give a result "approved" or "Reject"If "Approved" then convert CAD to GIS and add the data automatically to the GDB. IF "Reject" shows the layer names that should be fixed.How we can do this in FME? Thanks,

Is there a trick on how to read and count points with a classification flag? This link (http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_ReadersWriters/las/quick_facts_las.htm) seem to indicate that there is but I can't find any transformer that does. Classification_flag is not part of the different field available in PointCloudPropertyExtractor. Writing "classification_flags" manually does seem to output a few things, but it only seems to be a 0 (there's no flags) or 1 (there's flags) kind of thing. ==1, ==2. ==3 doesn't output anything. How to co

I am currently working with a number of 3D models that I need converting from CityGMLs to SLPKs (ESRI Scene layer packages) to be brought into ArcPro. I have found two ways to do this:1) firstly I can write to a File Geodatabase in FME before importing the file into ArcPro and performing the conversion to an SLPK there using the 'Create 3D Object Scene Layer Package' tool.or2) I can write directly to an SPLK in FME using the 'Esri Indexed 3D Scene Layer' writer. Ideally I would like to use the latter of the methods as it removes a step from the process however I have noticed that there are differences between the datasets being produced from each method.  When both files are loaded into ArcPro, the SLPK created in ArcPro renders very nicely with all elements being displayed, while the SLPK created in FME sees alot fo the elements appear and re-appear at diferent zoom levels - I am just wondering why this

I am writing to an ArcGIS Pro annotation feature class in a file geodatabase defined where the text symbol is not required to be selected from the symbol table. My intent is to change the size of the text and have the symbol stored inline, but have been unsuccessful in my attempts. The font size always ends up as 10. This doesn’t seem to be related to the definition of the annotation class symbol, as I have created annotation classes with different size symbols and the resulting size is always 10. I am setting the following attributes in the workbench and exposing these on the writer:geodb_text_size: 72geodb_symbol_id: -1geodb_anno_class_id: -1geodb_allow_symbol_overrides: TRUEgeodb_font_point_size: 72  In my testing I have been able to change these properties

Hi all, I try to extract the center point of lines by snipper. I get it, but values are visible in row only by FeatureInformationWindow. I can't extract this values by any ListBuilder, ListExploder etcIn Documentation I find only below information:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!FME_Geometry/Points.htm?Highlight=IFMEPoint Input file: Lines.gpkg Expected output: CSV with coordinates for center point (or middle point located on line) those Lines.  Can anyone help with this sim

Hello,I am trying to do some cleanup work of some Polyline Features where densified curves have been created due to loading the data into a Shapefile at some point in the past. I want the densified or stroked curves to be turned into true curves. I know there is the Curve Fitter transformer but I want to limit the amount of linework that the Curve fitter is run on to help eliminate unnecessary manipulation of the data. I have some approximate curve selection parameters in a Python Caller Transformer to help select the appropriate lines to select the lines I want the Curve Fitter to run on. The issue is I need to know which lines are connected together in sequence to allow the Curve lien selection algorithm to work. The lines have OID fields that are randomly generated based on the copy and past functionality of ArcGIS Pro. So far I have tried the Attribute Manager Adjacent Features but that appears to work off of table rows which is OID based(I think) not spati

Currently I have few attributes that are saving row by row but raster images are saving one on another. Is there any way to save image into same rows like attributes?

Welcome to What’s Up Wednesday, your weekly source of FME and Safe Software news! Today it's Mark taking over from Liz, who's away this week. FME ReleasesA new FME hotfix build was released last week (version 2021.1.0.1/build 21614). I'm told key bug fixes are to the AttributeManager, AttributeFilter, and FeatureJoiner. All look like very specific issues that probably won't affect you (they haven't affected me), but you may still want to check.Alternatively, you could wait until next week when a scheduled release (version 2021.1.1.0) is likely to be made available on Tuesday. Upcoming WebinarsA series of new webinars have been added to the upcoming list. They are:August 19: Data Integration Basics: Merging & Joining Data (Replay)Sept 9: Managing Changing Data (Replay)Sept 16: 5 Ways to Improve Your LiDAR WorkflowsSept 23: Metadata Matters! What it is a

From the Postgresql Writer, when a table is truncated and then inserted with new data is it possible to reset the Primary Key sequence to '1'? It currently restarts at the last PK value (+1) from previous entry.

Hi,  I am trying to work out the best way to send an email if a workbench fails. I have searched through the forum and found someone asking something similar, and they seemed to achieve this by using WorkspaceRunner and Emailer: Send email if translation fail (safe.com).  However I can't seem to get this working. I know my emailer settings are right, as I just tried it within a different workbench and got the email notifications, so I think the problem is with WorkspaceRunner.  It is the first time I have used this. Initially I tried creating a new workspace, adding WorkpaceRunner, configuring it to look at my main workbench, then attached the succeeded and failed outputs to Emailer. So all I had in the workbench was the Workspa

I would like to transpose the attached data structure. I have tried using the attribute transposer without luck. The attached excel has the input structure and the desired output. Many Thanks, Andrew

I have an input "A" and an input "B" I would like to join. I want to join them based on two columns from input "A" and three columns from input "B". Column Aa matches up to column Ba while column Ab will fall between Bb and Bc. So, say Aa=6.5. I need to find the correct match Ba based on the the value in Ab that falls between Bb and Bc.

Hi, I have converted 70 + GeoTiffs that have world files in same directory to ECW format, but the writer does not write and twf files alongside the new ECWs. Am I missing a step or do ECWs embed this information in the ECW file??

With this Expression I get the max-value of the 5 first List-values.@max(@Value(FID{0}.FID),@Value(FID{1}.FID),@Value(FID{2}.FID),@Value(FID{3}.FID),@Value(FID{4}.FID)) But the features have different List-Numbers. Some of them 5, some of them more than 5. Is there a way to express not hard-coded? Where the Number of List-entries can be dynamic? My solution to get the maximum value was the Listsorter. But I wonder, if there is a way with the ExpressionEvaluator. An expression which is not hard-coded seems to be very powerfull.Thanks for help!

HI, I've not used the HTTPCaller using a POST request and body attribution.The API call constructed by the developer has been provided like this:var client = new RestClient("

Hi there, I'm having some trouble with the transformers counter. I don't know why, but the digits seem to be in another font or something like that, still I can't fix it. I've already tried to reinstall the sofware, clean the memory of my GPU. Has anybody experienced anything like this before?... I would appreciate any help.  

I am using a few check boxes at the Run window to let the user choose a few different things. I'd like different action to result from whether a tick box is checked or not. I can do that ok using a Tester and checking if the user Parameter is YES or NO, and the test works well, but this gets ignored by a FeatureMerger a bit later. The workbench somewhat carries on no matter what the test result is.  The end goal is to only create attributes if the user tick a box or not. Are there examples of that?   No features should go to the bookmark in yellow, but it does anyway despite failing the test. And the FeatureMerger returns empty values of course. I'd like to get rid of the Attribute with empty values before they get exported. What's the best way to do that? Let it merge then remove