General

Hi All,i am working with json feature extraction not really good with working on this format.I am kind of stuck at point wherein json file information is in the form of array . i am trying to extract information from featurepropertiesEntries which has information about uuid of the feature and other attribute information associated to feature in sub- array form (featureid this the main uuid ,attributevalueid id of the that attrbute ,propertyname like height info,frc ). from this array i want to extract information for specific attributes only like frc,positional accuracy etc i have tires few things with json fragmenter and extractor but not getting desired outputs. can someone suggest good option to do thisthank you in advance. 

Hi @takashii am totally confused how to calculate the distance between the points of stationsi have tried the neighbor finder but didnt got the result what i am lookingcan anyone tell me or help me to finish my task1- side of the point2- distance between the points (based on the roads line) FILES

Hi FME'ers,Well, here are the quiz answers for this week. I hope you found it fun to go up against Dale, and try to prove the theory of Wisdom of the Crowd. I did make the questions a little harder, to give you a chance, and judging by the results, you took that opportunity.But first, the answers...Answers1) So here's an easy one for you. What is the shortcut to run a workspace?F3F5F5.6F11F#OK, let's say really easy. The only difficultly might be that you've used F5 so much you've worn the symbol off your keyboard. It also has a bunch of variations:F6 also runs a workspace in various combinations, but F5 is the main one; especially since (in 2019 or newer) it now only runs uncached portions. Shift+F5 reruns the entire workspace.Incidentally, F3 is a shortcut key to the workspace search dialog (who knew?) and F11 is the shortcut to expand the canvas to the whole screen. Try F11. I find it useful quite often.Besides that, F5.6 is a photography F-stop and not a shortcu

Hi FME'ers,The FME Weekly Quiz is now open.This week there is a difference. Instead of battling for the top score, your goal is to beat just one person: Safe's co-founder and VP, Dale Lutz!The questions are a little harder - a bit of guesswork or research might be needed - but I wanted to make sure @daleatsafe didn't blow you all away with 6/6.https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizSo give it a go and see if you can beat Dale!

 HiI'm trying to tranform a shape file to 3d tiles and adding a offsetter in between to adjust the zmin of the shapefile data.It was working fine and i saved the workspace .But when I'm using the same workspace to convert other shape file data,I'm getting the output but the attributes of the data are from the old data only.I'm not getting the attributes of the new file ,the old file attributes are only present which are coming as null. The old attributes are not replaced by the attributes of the new file.How to achieve the transformation of different files with their respective attributes with the same workspace with the offsetter.I have attached a screenshot of data and the workspace.

Sorry folks, I'm having a couple of technical issues today, so I need to postpone the quiz until later, probably tomorrow.Many apologies.

Hi FME'er,At this time of year - American Thanksgiving to be precise - the support team at Safe takes a couple of days on something we call "Demo Daze". It's like a mini-hackathon for us. Because of that, this question of the week is going to be a little shorter, and in fact, the question is really one I am asking you: Have you upgraded all your v2.7 Python scripts to v3 yet?Let's see why...Question of the WeekActually, I was inspired to ask by a couple of questions on Python this week:Python Version Error: What are my options? (@bo)Python Startup Script: Why does it work on FME Desktop, but not Server? (@billybob)As it turned out, neither issue was really related to Python, but what if they were? It got me wondering about Python versions.Python 2.7If you weren't aware, Python v2 is being deprecated in favour of v3. In fact it's only 1 month, 2 days, 14 hours and 30 minutes away (and counting down...)Why? Because it's older technology now, and contains

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 What is Data Integation?2) In Workbench there are five basic actions you can perform on a *writer* feature type. Which of tho

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 is called Memory Management. In other words, we don't just start transforming data without considering the state of the computer. We try to calculate how many resources we can use for optimum FME performance, without be

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 for self-serve data download systems.Schema (Any Format): Let's you read the schema of a dataset, rather than its contents. See last week's QOTW for more info.Schema (From Table): Let's you read a schema that has b

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 fixed schema: we know the source data structure and we know the required destination structure.But sometimes we don't know what the incoming schema will be, which leads to problems. We can't predefine handling it in the workspace, and we don't know how to define the destination structure.So let's take a look at schemas and see how to solve some of these issues.Where Does the Output Schema Come From?First, here's the theory part. The schema for a writer comes from one of four p

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 Could not create the snap-in. The snap-in might not have been installed correctly. Name: Eve

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 custom format and yet... I just used one the other week. For those not in the know, a custom format is like a custom transformer that includes a reader. Then you

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 of reports in HTML format. It can create plain text, or lists, or tables, or pretty much most HTML type objects. There are even options to create maps. It looks like

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' has value `$(FME_SHAREDRESOURCE_TEMP)/Temp/242/2.svg'It ends with this error: So i tried to fix it and using string replacer on row1 and pointing to the file directly: 2005    Attribute(stri

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: Another one I made up. There's already a PCColorScaler, which is pretty much what a ColorSetter would do any