General

Hi,i'm wondering if someone knows which mix of transformers i can use to 'align' (extend or trim) polygons along lines? I have polygons of road area and i have a line which is the separation between the road and the sidewalk . the point is that the polygon edge of the sidewalk is not align along the line and i'm looking for a way to do this for thousands of them. In Arcmap, the tool 'Align to shape' is the key to that but definitely not an option for thousands of areas...  thank you for reading this. Hope that someone will help me! Max

I have a transformer that Lists a set of companies in a database schema and then fires off a set of workflows. These end in 5 SQLExecutors which migrate the data into another database. I want to be able to run a final tidy up process after these are all finished. The input must come from the List_Company_Schema process, not the SQLExectors but it must wait for them to finish. How do I do this?

Hello to all. Help me example shema FME or give way the question regarding CityGML RasterRelief. I need to create a raster relief for the city, but at there is very little information that I can understand. I have raster GEOTIFF and how it transform to CityGML ?

How do I add alias names to a table. I have a lookup csv file and a table with over 180 columns so don't want to add them in manually. I just don't know how to get the alias names into my table

Hi I am trying to find the features that has attachments.So far I tried Tester and ListSearcher but I couldn't get any results.Tester Parameters:Left Value: arcgisonline_attachment{0}.content_typeOperator: Attribute Has a Value ListSearcher Parameters:List Attribute: arcgisonline_attachment{}.dataSearch Type: First to contain regular expressionSearch For: .(also tried ^$)

Running the contour generator on a USGS LAS dataset, I filter for ground points, then generate contours. Once this is done along the edge of the las file the contours draw to each other, like there is a straight vertical wall along the edge. Please see red circle attached. Also does not matter if I change my tolerance on the contour generator. Tried at 1 and 100. Same resultMy transformerslas--> point cloud filter-->contour generator--> line combiner 

I have a spreadsheet derived from a pdf report containing dates/times tickets were purchased in a number of car parks. Unfortunately, the car park name is not a separate column, but instead it appears as a heading before the data. Is there a way to split the data at the end of each section? Eventually I would like the car park name as a separate column, but I guess to start with I need to split the data into different sections? Any ideas how this could be done? Many thanks

I have a problem to calculate value when use field name has a published parametes. All values are <missing> This is my parameter I check i with AttributeManager and attributeCreator and I have same result. I have set Attribute value with that : @Value($(Table_A_AttributeName))  

Hi I am writing millions of line features to an various feature classes in an ESRI SDE Geodatabase 10.0. Are there any best practices for improving the performance in writing.I am writing to a non versioned db, which is being used constantly.I have increased the transaction to 10000. And Set Transaction type to null. Is there a way to set the writer in load-only mode for the GEODATABASE_SDE?

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