- - Community Resources
Ideas
Product Updates
Events
Groups
Support
Knowledge

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,042 Posts
13,932 Replies

When you subscribe we will email you when there is a new topic in this category

4042 Posts

tim_woodContributor

ExcelStyler adds 2 hours to run time and 30 Mb to output! What am I doing wrong?!

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

5 years ago

martyn27

asked in General

Error running translation when writing to a database

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

U-turns in ShortestPathFinder

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.

260

5 years ago

raaaju1990Contributor

asked in General

FMEException :896902 while initializing fmeobjects.FMEWorkspaceRunner() using ArcGIS 10.7 64 bit python.

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.

360

5 years ago

dustinInfluencer

asked in General

Running workspace from python

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?

360

5 years ago

yoannParticipant

asked in General

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

5 years ago

asked in General

Are there any drawbacks to updating Python Packages in FME?

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

384

5 years ago

btlContributor

asked in General

How to fill a hole in a raster DEM

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

2500

5 years ago

mark2atsafeSafer

asked in General

Question of the Week: Rotating Rasters

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

2020

5 years ago

mark2atsafeSafer

asked in General

Question of the Week: Clipping Raster Borders, Nodata, and Transparency

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

4580

5 years ago

lennertpronkContributor

asked in General

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?

1112

5 years ago

oliver.morrisContributor

asked in General

I would like to use @ReplaceRegEx where i find the string and just remove it completely, so in essence replace with nothing. e.g. @ReplaceRegEx(@Value(new_name),([A-Z][A-Z_][0-9][0-9][0-9][A-Z][_]),) how can I do this.

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

682

5 years ago

robertoContributor

asked in General

Licensing assistant - Issue with ports

1670

5 years ago

mark2atsafeSafer

asked in General

What's Up Wednesday: News for the week ending 7-Aug-2020

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

5 years ago

johnkContributor

asked in General

Transforming Excel survey data into multiple forms based on template

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

5 years ago

andre7

asked in General

User parameter as Input Coordinate

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?

480

5 years ago

virtualcitymattCelebrity

asked in General

GeometryValidator Invalid Solid Boundaries: Not Enough Faces vs Surface Not Closed

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?

input values from different cells in excel in each loops

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?

140

5 years ago

dms2Contributor

asked in General

CoordSys fuction and CoordinateSystemExtractor transformer

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!

5 years ago

markcoopersdcContributor

asked in General

Merge Daily csvs into one file

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

650

5 years ago

umapper1Contributor

asked in General

Featuretypefilter not recognising feature types

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.

Multiple points in one area to create as many areas as points

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!!!

470

5 years ago

mark2atsafeSafer

asked in General

FME Weekly Quiz: Can you outscore EVERYONE at Safe? (July 2020-4)

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

5 years ago

mark2atsafeSafer

asked in General

FME Weekly Quiz Results: Everyone at Safe (July 2020-4)

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

I have a pipe-network with an inside and outside diameter how can I create those pipes?

I have a pipe-network with an inside and outside diameter (they are empty inside) how can I create those pipes. Bufferer only gives me solid pipes. The data are 3d shapefile lines.

480

5 years ago

Page 144 / 162

Badge Winners

tullushas earned the badge Student (Grey)
mike_greshhas earned the badge English Speaker
johnny_fivehas earned the badge Welcome Back
maxime.carrierhas earned the badge FME Certified Professional
francisco_1988has earned the badge Student (Bronze)

Show all badges

Community Stats

31,773: Posts
120,715: Replies
39,396: Members

Latest FME

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.