General

When I have created a CityGML writer and add another one with the same specs except for the file name, running the process ends in an error. Both writers are separate. So it's not one CityGML writer writing two Feature Types (that won't work).  Those are the warnings and the only error I get:2020-08-10 10:38:15|  13.3|  0.0|WARN  |Duplicate XML Schema attribute declaration found -  QName: 'xml:lang', schema URL: 'file:///C:/Program Files/FME2020/xml/schemas/CityGML/CityGML/2.0/3.1.1/smil/xml-mod.xsd'2020-08-10 10:38:15|  13.3|  0.0|WARN  |Duplicate XML Schema attribute declaration found -  QName: 'xml:space', schema URL: 'file:///C:/Program Files/FME2020/xml/schemas/CityGML/CityGML/2.0/3.1.1/smil/xml-mod.xsd'2020-08-10 10:38:15|  13.3|  0.0|WARN  |Duplicate XML Schema attribute group definition found -  QName: 'xml:specialAttrs', schema URL: 'file:///C:/Program Files/FME2020/xml/schemas/CityGML/CityGML/2.0/3.1.1/smil/xml-mod.xsd'2020-08-10 10:38:15|  14.1|  0.0|WARN  |Duplicate XML Sch

FME Desktop 2019 2.3.3 (64-bit).I'm making my first foray into using FME to format an Excel spreadsheet I'm writing. The output is the results of address matching. I want to highlight cells based on how good the match was. My first attempt was to assign a hex colour value e.g. #ffff00 to fme_fill_color then expose it as a format attribute in the Writer. This did nothing so I researched it and found the ExcelStyler.Implementing this has slowed my Workspace down from 4 minutes to nearly 2.5 hours, and when I try to open the output XLSX, it says it's corrupt. Also, the XLSX jumps from 5Mb to 37Mb in size. I presume I'm doing something wrong. Can anyone help?The first thing I do is set a colour value based on the match status/score: Then I set that as the background colour in the ExcelStyler (red in this screenshot because I've disconnected it): Even after reading the documentation, I'm confused about Background Color and Pattern Color. Should I set one or the other

I am converting over 1.5 million links and writing them to a database. This workbench has worked for me previously with roughly the same amount of data. Since updating to FME 2019 I am now getting an "Error running translation" with nothing to really go on. I enabled full logging and these are the last few lines:2019-08-20 09:49:51|5835.7|  0.0|WARN  |ResourceManager: Failed to free sufficient memory to reach the upper memory limit: Physical 1.85 GB over 917.49 MB Virtual 7.34 GB over 16777216.00 TB2019-08-20 09:49:51|5835.8|  0.2|WARN  |ResourceManager: Freeing! Over private memory limit: 1.85 GB > 917.49 MB2019-08-20 09:49:51|5835.8|  0.0|INFORM|ResourceManager: Optimizing Memory Usage.  Please wait...2019-08-20 09:49:51|5835.9|  0.0|WARN  |ResourceManager: Freed 906451 bytes of vector data (memory decreased by 196608 bytes)2019-08-20 09:49:51|5835.9|  0.0|WARN  |ResourceManager: Failed to free sufficient memory to reach the upper memory limit: Physical 1.85 GB over 917.49 MB Virt

Is it possible, using the ShortestPathFinder transformer, to only allow U-turns at dead-ends /cul-de-sacs only and NOT in the middle of a road segment? When testing out a workspace I have, I am seeing several U-turns in the resulting shortest path that occur in the middle of a road segment - which I want to avoid. I want to only allow U-turns at dead-ends / cul-de-sacs.

I have ArcGIS 10.7 64 bit Python, FME 2019 and using FME Python27 fmeobjects. I have added fmeobjects.pyd under Arcgis Python 64 bit->Lib->sitepackages. Also, in the script i'm appending the fmeobjects path like below,sys.path.append(r"D:\\ProgramFiles\\FME\\Desktop\\fmeobjects\\python27") and then using import fmeobjects. But, when I try to initialize runner = fmeobjects.FMEWorkspaceRunner() I get FMEException:896902. Not sure what the mistake is. Please give suggestions.

I'm attempting to run a workbench from a python script:import syssys.path.append(r'C:\Program Files (x86)\FME_2019.1.1\fmeobjects\python27') import fmeobjectsrunner = fmeobjects.FMEWorkspaceRunner() workspace = r'E:\TFS\GeospatialA\Maritime\Misc_Tools\ESRI_INIT\fmw\gdb_notes_extract.fmw' runner.promptRun(workspace)I do get the prompts to input paramaters as expected. After clicking OK to run the workbench, I immediately get the error as seen in the attachment. I can't seem to find any details about what might be causing this. The workbench simply reads in a file geodatabase, does some relations, and output a new geodatabase. Any ideas?

Hi, can we add a user to a floating licence which is not longer under AMC ? Thanks

Hello Everyone, I am currently trying to upload files to an scp environment using the pythoncaller in FME with the paramiko and scp package.It all works well when I run it in a seperate Python environment. In FME however I get the error 'AttributeError: Raw' which, according to Google and stackoverflow, is related to the fact that I need to upgrade the cryptography package. Based on the FME documentation I should be able to do this using the following cmd: fme.exe python -m pip install <package_name> --upgrade--target <package_destination_folder> I am however wondering if I 'should' do this. Are there any FME dependencies/related tasks that might be impacted? Does anyone have previous experience with upgrading python packages in FME? All help is greatly appreciated, Kris 

I'm trying to replace part of a raster DEM so I cut a hole in it and created a few points in a shapefile to define new heights in the hole - I want to interpolate across the hole to these new heights keeping everything else the same. I'm using RasterDEMGenerator but the hole is filled with elevation=0 except for tiny spikes where my control points are

Hi FME'ers,This question came through our support queue, I believe, and is related to raster datasets. In particular it helps to explain the behaviour of processing raster data, and how spatial components are stored in a raster file.Question of the WeekQ) A source raster dataset appears flipped vertically, but even after using the Affiner transformer to fix it, the GeoTIFF output is still written out flipped. Inspecting the output with FME it looks correct, but the actual GeoTIFF file still looks incorrect. Has anyone come across this before? A) Using the Affiner has fixed the spatial components of the data, but some applications (for example, Windows Photo Viewer) will ignore the location information and still display the original data. Let's see why this is...Raster Datasets and Location DataA raster dataset is usually a single file, but it often contains two components: the actual raster grid of data, and a set of information about the location of the dataset. This screensho

Hello FME'ersI'm writing this question-of-the-week for a number of reasons. It's something that is regularly asked (because perhaps it's not totally understood), it came up in a support question this week, and I've actually been working on a similar task myself this week.The question is all about creating a transparent area around clipped raster data.Question of the WeekThis week's question came from a case in our support queue:Q) After clipping a raster feature to an ellipse shape, the surrounding cells have a value of 140. Why is that and how can I remove this?A) A raster feature (file) can only be rectangular, so when you clip it to a non-rectangular shape, then the "outside" area must be represented in some way. This is done by "nodata" and so you can control what you see by controlling the raster nodata value. But in some cases, a transparency (alpha band) is better. Let's see why...My Profile Picture ScenarioAs I mentioned, I was wo

I use SQL creator to import a view from SQL server. It represents lines but comes in as multipoint geometry. The linebuilder to create lines from multipoints doesn't work. Any ideas instead of de-aggregating to individual points?

if I just leave it blank it fails.Thank you for your help.

Hello,while moving the license server to another node, we got an error that seemed to be solved couple of weeks ago. FME version 2017.1The safe.lic file in the server is:SERVER XYZYPPSIXX6WPRO 001012b01ab2VENDOR safe PORT=27000USE_SERVERFEATURE FME safe 1.0 permanent 3 F7B5DEC63BD2 BORROW=720FEATURE FME_GUI safe 1.0 permanent 3 42090CC82133 BORROW=720FEATURE national safe 1.0 permanent 3 87C291B33CFC BORROW=720FEATURE basic_raster safe 1.0 permanent 3 EEEA5B38F186 BORROW=720FEATURE segy_reading safe 1.0 permanent 3 5DA1830C610F BORROW=720FEATURE segy_writing safe 1.0 permanent 3 1240EA22A78D BORROW=720FEATURE database safe 1.0 permanent 3 AA5C10C9845D BORROW=720FEATURE fmeobjects_reproject safe 1.0 permanent 3 E66ED683EA87 BORROW=720FEATURE spatialbiz safe 1.0 permanent 3 58E842DD2613 BORROW=720 # Serial Number(s): ABCD-EFGH-12AB Client side in the licensing assistant I put the address below: 11.201.30.41:27000With the 27000 port like the one specified in the vendor parameter.Trying to

Hello everyone,Here's the first "What's Up Wednesday", which I hope will take off into a regular series of midweek FME tips and news. This first time round, I'm just posting a few news items that came up this week... New FME BuildYesterday (4-Aug-2020) we published a new FME build, FME 2020.1.1 (b20608) with some minor fixes for 2020.1 The key updates (to me) are:Fixed the Tester where a cached value is the same as an existing attribute nameFixed partial runs from feature types with spaces in their namesFixed a crash during an FME Server core-only installation As always you can find this new build on our downloads page. New Hub ItemsIn case you weren't aware, there is a monthly digest of all of the functionality added to the FME Hub. For July 2020 the standout highlight is a new Google Sheets reader/writer that supports v4 of their API. But there are other new tools too, such as:A Quad-Tree generatorShopify transformers (go to the hub and search for Shopify)An

Hi, I have a large amount of structured survey data in the form of an Excel sheet (one row per survey, columns serve as the attribute values) which i need to transform into multiple Excel sheets (one per survey) based on a provided template. The location for each value in the template, will depend on what the attribute value is in the source data table. I'm not quite sure where to start although i'm pretty sure i'll have to master the art of using xlsx_row_id... Any help would be hugely appreciated! Thanks

  Hi im new to Fme. Im trying to build a script where I have coordinates as an input(longitude and latitude) and then find the closest substation to those coordinates. I have managed to get the coordinates for the substations but I don’t now how to make my input to coordinates. Im thinking of using NeighborFinder after to find the closest substation.  I would be grateful if anyone have any tips to solve this?

Hi all, I've been working with validating Solid geometries in FME. I'm tying to understand the different scenarios and how they translate to the errors FME takes note of. I'm specifically interested in knowing how to cause the issue of "Not Enough Faces" which is documented as an issue in the invalid solid boundaries here: http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/geometryvalidator.htm#InvalidSolidBoundaries I performed a simple test where I simply just removed one of the surfaces in the solid, it was just a rectangular prism but now with only 5 surfaces (instead of 6). The resulting error message was "Surface Not Closed". Anyone know where I might expect to see the "Not Enough Faces" pop up? 

In my Workflow Model, the daily soil temperature is decided by itself and other parameters one day before.For example, I created column A (the present soil temperature Ts1), column B(air temperature Ta1), and column C(the soil temperature next day Ts2) in Excel and I had the soil temperature from day 1 and daily measure data of air temperature for 3 days.   I have created a looper in FME, i wanna input Cell A2, B2 to calculate and output the value in C2 at the first looping.At the second looping the value in C2 would automatically return as input value A3. With the measure value B3, the value C3 would be calculated, until we have all the soil temperature for 3 days.How can i use the reader, writer, and looper in FME to achieve this?

I vaguely recall having some issue in the past getting features' coordinate system using CoordSys function and CoordinateSystemExtractor transformer. If my memory serves me right one of them was not reflecting the actual coordinate system of each feature. Has anyone come across such a problem? May I rely on that CoordSys function and CoordinateSystemExtractor transformer will always return the same information? Thanks!

HiWe are recieving a daily csv from a supplier and I would like to merge them all into one file (ideally write to a sql server database but could just be a csv). I have enabled the reader to read everything in the folder, which works fine. However, if I run this every day, it will become increasing inefficient to truncate the table being written and update it. Is there a way that I can check if a file has already been written and then just append ones that haven't?  ThanksMark

Hi community,I've gone back in to an old workspace and updated a feature reader transformer. It's then supposed to route into a Featuretypefilter to get a list of the feature types. Doesn't appear to be getting any results when I press 'update' in the Featuretypefilter transformer. Is this a bug or am I missing something here? See screenshots below. Am using ver 2020.1.

Hi everyone! I'm trying to make a PointOnAreaOverlay crossing a points database with a polygons database. The problem is that more than one point it's inside of a some polygons, and I wanna create one polygon for each point... even it that create duplicate polygons. When I use the tool PointOnAreaOverlay, it's creating just one polygon and taking the data from the first point. How can I create a separate polygon for each point? Thank you very much!!!

Hello FME'ersToday it's quiz day and your challenger today is... everyone at Safe!Let me explain. With the FME Hackathon about to start, I'm going to take a break from the quiz, and perhaps come back with a new format in a few weeks. So just in case this is the last User vs Safer contest, I thought I'd let everyone at Safe take part.In short, I made the questions public to all Safers in the form of a poll, and am taking the most popular answer as the Safe choice. I think you call it "wisdom of the crowds".The Safer score is good... but it's beatable.So have a go at the quiz here: https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizAnd good luck!PS: This is also likely the last time the quiz will be posted on this community setup. We'll probably start migrating everything to the new system later today, so even these quiz answers will be posted to the new system. I can't wait for that to happen! So if we suddenly go read-only, then I'l

Hello everyone,Welcome to the first quiz results on the new-style FME Community. This week you were up against the entire staff of Safe Software - where the answers were chosen as the most common choice.  Quick NoteWe've done 30 User vs Safer quizzes now, and with the change in community and ongoing hackathon, I'll think we'll take a short break in the quiz, and restart in September.Maybe I'll change the format, but either way, I think it's a good time to reset the scores. So the scores at the foot of this page are final!So let's see how you all did... Answers1) How do you collapse a bookmark on the FME Workbench canvas?Set it in the bookmark properties dialogUsing the shortcut Ctrl+Shift+CClick the drop-down arrow on the bookmark headerThe Collapse Bookmark toolbar buttonAll of the aboveThe only correct answer is that you click the drop-down button on the bookmark header: I don't usually do "All of the Above" questions, so you can pretty much tell