General

Hi Guys...a simple one for you i think i have a Folder A with multiple .gdb files and a Folder B with multiple .gdb filesNo I want update every gdb which is in Folder A and in Folder BAND: write gdbs which are only in Folder A into the Folder B  have i use a loop? (because the Folder A is Always filled with different Counts or names of gdbs)?or dynamic path etc....?? thx for helpFranco

Hi FME'ers,Here are the answers and results to Monday's quiz:Answers1) FME is a Data Integration platform, one aspect of which is Spatial ETL. What does ETL stand for?Extract Tool for Location DataExpedited Transformation LifecycleEnterprise Tools for Local GovernmentExtract, Transform, LoadEat, Transform, LoveIt means Extract, Transform, and Load. It does not mean any of the others, nor does it mean Express Toll Lane or Extra-Terrestrial Lifeform. At least, not in the FME sense.And, although I'm sure a book called Eat, Transform, Love would be great - life changing, in fact - it's not the correct answer here.Incidentally, although FME is often called a Spatial ETL tool - we used to call it that as well - ETL is just one method by which FME can achieve data integration. FME Server and Cloud (for example) go way beyond simple ETL. Find out more at

Hi FME'ers,Here's your Monday quiz. The URL is the usual:https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizQuestion 6 is an "impossible question" again. Where did @daleatsafe go on vacation in 1995?!I honestly think it's a little easier this week and we'll get a few 6/6 responses. I'm counting on you not to prove me wrong!I got a bit tied up last week, by the way, so I haven't got a results/top scores workspace yet. I'm working on it!CheersMark

Hi In previous version of FME Desktop, we could install packages, but after updating to 2019.1.3 and 2019.2, it seems to fail. I am not sure if any new updates to OS or security hardening could have an impactI am logged in as an adminstratorFailed to install web service 'C:\\Users\\adm-rudvog\\AppData\\Roaming\\Safe Software\\FME\\Packages\\19801-win64\\PackageFiles\\safe.socrata\\web_services\\Socrata.xml'. Reason: SQL Query BEGIN IMMEDIATE failed. Error: attempt to write a readonly database

Hi FME'ers,Today's Question-of-the-Week queries a log message about memory usage. The concern is what the message means and what can be done about it. Question of the WeekQ) This warning is appearing my log files:Failed to free sufficient memory to reach the process usage limitWhat do I need to do about it? What is the potential impact if nothing is done? As far as I can tell there is nothing wrong with the output files the script is creating.Asked here by @maphewA) In short, this message tells you that FME is becoming short of memory. If you don't do anything about it then - as long as the process finishes - you are correct that the output will be fine. But let's dive a bit deeper into why this message occurs...Memory ManagementSo, FME has built into it, tools for what

Hi,Can anyone explain to me how variable setter & receiver work and provide me some examples of how these transformers can be used to solve problems?Thanks in advance.

Hi FME'ers,Here are the answers and results to Monday's quiz:Answers1) Which of these is NOT a real format in FME?Dynamic (Any Schema)FME Workspace (FMW)Generic (Any Format)Schema (Any Format)Schema (From Table)The answer here is "Dynamic (Any Schema)". Any existing format can be made dynamic, by simply ticking this box in the feature type parameters:  But dynamic is not a specific format. All of the others are. To list them:FME Workspace (FMW): Reads a list of formats, datasets, transformers (and so much more) from an existing workspace file. Great for analyzing and cataloging your workspaces.Generic (Any Format): Let's you read a dataset regardless of format (FME will even try and guess the format if you wish). Also a writer which is great f

Hi FME'ers,Here's your Monday quiz. The URL is the usual:https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizQuestion 6 is an "impossible question" again. Do you know what subject my colleague Ryan was interviewed about? It wasn't FME. Currently you get to see the top-ten results when you answer the quiz. I'll be working on a workspace to let you check out the results at other times too. I'll let you know how it goes.CheersMark

Hi all, I have a problem with extracting attributes list ordered previously with Attribute Manager.I do it via Python Caller and exploding list which contains attributes names. It works OK but the order of these is sorted alphabetically and I need original pre-set by me order. def get_att_list(feature):       n1 = feature.getAllAttributeNames()    x=0        for n in n1:            print (x,n)        feature.setAttribute('Attr_name{%d}' % x, n)        x+=1 Generally speaking, I need to get numbers of columns in specific order to use it next in Excel vlookup formula. That is why the order is so important. Maybe there is a better way of doing it? 

Hi FME'ers,Not so much a single Question-of-the-Week, so much as a common theme related to handling a schema that is unknown or needs to be constructed dynamically.Question of the WeekQ) How to set the attribute name to published/private parameter value in FME 2019.1 ? Is it possible to do ? Asked here. Similar issues asked here (compare two schemas for duplicate fields) and here (dynamically create columns from attribute values)A) All of these questions deal with the concept of schema. Mostly we start out with a

Since installing FME 2019 64 bit, Photoshop CS4 64 bit has stopped working - (32bit CS4 still works). Also, a proprietary 64 bit image processing program has stopped working.I'm on Windows 7 Professional 64 bit, service pack 1. NVIDIA Quadro K5000 graphics card.The error when trying to start photoshop is:"The application has failed to start because its side-by-side configuration is incorrect."(I don't get an error report from the proprietary software, it just doesn't run.)Do you think this could be connected to the FME upgrade? - it's the only thing I've changed in the last couple of weeks (I'm not connected to the internet so I'm pretty sure about this). EDIT - I have reverted to FME 2018.1.1.1 and everything works again.Notes:With 2019 installed, Windows Event Viewer didn't work either - with 2018 it is working again. The error in Event Viewer was:MMC C

Hi FME'ers,Here are the answers and results to Monday's quiz:Answers1) An fmw file stores what?A WorkbenchA WorkflowA WorkmateA WorkshopA WorkspaceIt's a WORKSPACE! Now, I know lots of folk say workbench, as in "I'm creating a workbench to..." - and we've even considered changing it because of this - but the actual terminology is a "workspace". Sometimes we use the term "workflow" but that's meant in general term, such as "my workflow involves using Workbench to create a workspace".And if you picked either of the other two answers, then I really don't know what software you are using!2) An fds file stores what?A Custom Coordinate SystemA Custom TransformerA Custom FormatA Custom DatasetA Custom SuitWell here's a blast-from-the-past. It's rare to see a cu

Hi FME'ers,It's going to be a quiet day from Safe today, since it's a public holiday here (and may be where you are too). So I'll open the quiz today but leave it open for an extra day.This quiz is a new style. I hope it looks/works good for you. The URL is the usual:https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizI made it a little easier overall this week, but I'm starting to throw in an "impossible question" - just so that you need to be *really* good to get 6/6! Hey, it's only meant to be a little fun! See if you know (or can guess) the answer to question 6 this week...CheersMark

Hi FME'ers,This is going to be a short-ish Question-of-the-Week, because I'm working on revamping the weekly quiz for next week. Fortunately it can be a quick post because both the question poster and myself were using the same transformer - the HTMLReportGenerator - for our respective tasks.Question of the WeekQ) I'm using an HTMLReportGenerator to create a table that should have 10 rows. However, I get the 10 expected rows, plus many more that simply say "None."Asked here.A) Well, my job here is made easier by the fact that the user (@rwardrup) answered their own question. But it was an understandable issue since the HTMLReportGenerator can be a bit unintuitive. Let's take a quick look at what it does and how it works.The HTMLReportGeneratorSo the HTMLReportGenerator... well it generates a page

I'm having trouble with the migration of one of my workflows to the FME server. The goal is to create a legend out of attribute_1 (images) and attribute_2 (text). The end result is this:How it works: My program (outside the FME workflow) prepares a table (MySQL) with the text and the image (SVG tag). When the table is finished I use FME to save these SVG tags to an text file with .svg extension on my hard disk and then convert them into raster using the MapnikRasterizer and store them again as PNG files on my hard disk using FeatureWriter (PNG).Running this with FME desktop is no problem (hence the above result) and so far so good.But, I’m having trouble getting this to work with FME server parameters. For example when one of the attributes has the following value.2296    Attribute(string) : `row1'

I made SDE connection through Arc Catalog to connect to geodatabase and when I used the reader ESRi geodatabase (Arc SDE), I chosed the created connection file of SDE.When I tried to select the tables, I got the error as in the below image.My Arc desktop is initialzed and the license server running.I installed also oracle client to make the connection file because DB in Oracle.

Hi there,I'm trying to get grid locations from a polygon fgdb feature class attribute for the the start and end of a fgdb line feature class. The attribute I need to put into the line data is a GRID ID. I thought about using a spatial relator or a lineonareaoverlayer, but I cannot figure out how to use either transformer and how to transfer the attribute over. I'm especially having problems with exposing elements and dealing with list attributes. I can add photos or attach the workspace if needed

Hi FME'ers,Here are the answers and results to yesterday's quiz. I heard that it was quite a hard one this week. Not my intention, but it's good to have a tough one now and then! It would be boring if we all got 6/6 every time.Answers1) A new transformer coming out in FME2019.2 will be the...RasterSharpenerLineSegmenterPointCloudColorSetterMinecraftServerConnectorRangeExploderIt's the RasterSharpener. FME2019.2 will be coming out VERY soon (either today or tomorrow) and will include not just this transformer, but also a RasterSegmenter and RasterRegisterer. So if you are into raster data, 2019.2 is worth looking out for.I also have a post tomorrow about a new parameter in the Tester (and some other) transformers, so watch out for that.As for the others:LineSegmenter: I made that one up, so who knows what it is supposed to be or might do!PointCloudColorSetter:

Hi FME'ers,Here's the FME Monday Quiz for this week. It covers new transformers, schedules, Twitter accounts, and sports. Give it a try and see how you do.https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizRemember, I'm going to call a winner after this week, and start the league table afresh next week. So it's your chance to top the table when it really matters!Mark

Hello FME'ers and Happy November!There's a saying that "things always come in threes" and here's proof. This Question of the Week is not so much one question, as three instances of the same requirement: to put a datetime in a file name.Question of the WeekQ) I have a workspace that downloads files, renames them and stores them in a ZIP file. Said ZIP should contain the current date in its filename. Can this be done somehow?Asked in various forms, here, here, and here!A) Basically the user wants to add the current datetime to an output filename. The obvious use is to stop multiple runs overwri

I have CSV that contains Lat/long. i need to convert this into points using spatial reference WGS 1984. then i have to compare this point data with my building point layer. i need to calculate distance between the points in CSV and the building layer. Building layer has already this CSV data but the locations in CSV has been changed. I need to find the distance in feet.

Error came when i am using textpromp extractor(geometry error) of one feature. Because of this i cant be able to proceed further.

If I create a new column in a feature class and want to write data to it, is is "Insert and Create as Needed" in the General Table Operations?

Have few queries before migrating FME Desktop and Server version 2015.1 to 20191. Whether OS Windows 2012 R2 will support FME Desktop and Server 2019?2. Does FME workbench older version 2015.1 will work on version 2019?3. Is ESRI ArcSDE 10.1 (.sde) file will connect through Direct Connection on FME Version 2019?4. Is it possible to save or connect ESRI ArcGIS 10.1 FGDB file through FME version 2019?Thanks in advance.

Unable to flush the cursor for the feature class 'M_SDAT' because the spatial index is too small. Increase the spatial index on 'M_SDAT' and retry I have an old complicated workbench. It translates all of the NOAA Electronic Navigational Charts S-57 .000 files into Oracle for internal users and external arcgis server rest services. It's been running every Saturday on a schedule for years. lately it's been throwing the above error. I'm able to get past it and run the translation by disable that particular feature class. But every week it's breaking on a different one, so I need to find a real answer. FME Server 2019.0.0.1 Build 19246 - win64Oracle 12.1.0.2