General

Hi, I have an issue with a workspace that reads from AGOL and, among other things, writes to an SDE. The workspace completes successfully, but then returns an error – as below: Translation was SUCCESSFULError running translation. This isn’t so much of an issue on desktop – as the features are written correctly, but on Server (it’s destined to be a nightly scheduled task) that final error is enough to restart the workspace – ad infinitum. I have narrowed the issue down to the SDE Writer and have tried many ‘solutions’, without success. These include:Replacing the SDE Writer with a Feature WriterConverting the SDE Feature Class to non-relationalCommitting transactions at the end of writeVarious transaction typesAudit logging (no additional details on the final error)etc Currently running FME Desktop 2018.1.2.1 (32bit) on Windows 7. Any help and advice would be welcome. Thanks,Mark

Hi!I have a collection of feature classes and I want to put them together in a single feature class. I was wondering if anyone is familiar with this scenario, or if anyone knows the transformer they would have to use to carry out this process?Or it is necessary to use a transformer or simplement I can connect the features classes in "reader" and the feature classe created in "writer"Thanks a lot

I'm sure this is an easy fix, but I have a workspace that is being run by WorkspaceRunner. A different shapefile is reading in from the runner each time using the Path Reader. When I run the WorkspaceRunner the child workspace is not running. I have used this setup before and it's worked perfectly. I can't figure out why it's not on this occasion. I've attached both workspaces. Thanks for any help. B

Dear FME community. I try to merge multiple lines attributes for use an Emailer at the end (like an object) like that :I tried aggregator, HTMLextractor, AttributeCreator but the result is not good.Have you got any idea ?Thanks.

here i need to separate QD and after values into another field. How to separate themvenkat QD 33245saleem QD 360sreelatha QD 420sai QD 123  above table converted into below table NameBlockvenkatQD 33245saleemQD 360sreelathaQD 420saiQD 123 

review above attached pic the unlimited numbers converted into the Portuguese language how to possible

HiIm unable to convert Obj to gltf in the latest update.I have downloaded some sample obj files from this site.Im always getting this warning Geometries which cannot be converted to a triangulated mesh will not be written.How to avoid this and achieve the conversion.In the previous versions of fme im able to convert these obj files but now its not working. What is the reason.Some sample file https://free3d.com/3d-model/alien-ship-from-battleship-37326.html which i used.Most of the obj im converting getting this error.Previous version this issue was not there.FME version : FME(R) 2019.1.0.0 (20190710 - Build 19608 - WIN64 ).OS : windows 10.

For some reason my "Translation log" view is floating instead of fixed. Don't know how to "fix" it again (FME2018).

Hi FME'ers,It's that time of year for a hackathon! Yay! But first be aware...NoteWe are scaling back a little this time. I gave the marketing team permission to use the "12 Days of FME" title for something else, we'll have a bit less fanfare (no blog posts), and prizes will be restricted to what I can steal from the swag cupboard the next time I'm in Safe's head office (which might be nothing if I'm spotted).So no fame or fortune, and not much glory: but hopefully a lot of fun and satisfaction in doing cool things with FME.Theme and RulesRather than restrict us to a theme, I thought we'd go with an open competition. So, as in the past, you can submit any sort of project you like.It can be a workspace, a custom transformer, a web service, or anything as long as FME is used in part of it.It can be Christmas-related, or related to any other holiday you can think of; or neither.You can treat it as a "hackathon for good" where you try to solve

Seasons greetings, FMEers.Our main question this week comes from our support queue and relates to published parameters used programmatically.Note: I have an up-to-date list of previous Question of the Week topics in case it's of interest to you.Question of the WeekQ) The behavior of choice with alias parameters on FME Server does not seem to be working as expected when called programmatically. Values are taken literally and not converted. Can you please confirm how it should work?A) Of course. It might seem odd, but I believe this is actually working as designed. The difference is in running a workspace through FME (Desktop or Server) and running it programmatically. Let's see why...Choice with Alias ParametersHere's a quick refresher on user parameters in general and the Choice with Alias type in particular.A User Parameter is a way to get input from a user when they run a workspace. They are sometimes also called Published Parameters, since you publish them to get user input, or keep

We are trying to install FME 2019 server. After the installation was completed, we tried to trigger one job from the samples repository. However it is giving the following error:There was an error submitting the job. COM.safe.fmeserver.api.FMEServerException: java.sql.SQLException: Key not found in configuration table: pause_queue_incoming. Please help.

Hi,  The AreaAmalgamator does not seem to work in FME2019, when I use the same data and workspace in FME2017 it works fine. Even when there is no data passing the AreaAmalgamator it makes the workspace crash, when I use a dummy polygon input to the AreaAmalgamator in the same workspace it works. I have this problem on Workbench and Server 2019.  Thanks for any help:)  Best/ Johan  

OK folks. This will likely be the last quiz of the year (I'll be on vacation for a while), so do your best to beat the Safer I have lined up today: Craig Vernon.If you don't know Craig, he's in charge of Safe's sales group and is also the ultimate head person for our support teams. Basically he's responsible for customer satisfaction, so I hope his score today isn't too dissatisfying for you! His isn't a technical role, so you may have some advantage over him there!As always, the URL is: https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizHave fun, and don't forget to also take part in the FME Holiday Hackathon if you get the chance.Mark

Hi FME'ers,This question was asked about Excel data, but it often applies to any text-based format where a set of records is subdivided by a separate header record. In this scenario, the header record gets read as a standard feature by FME. It needs not just to be filtered out, but its contents added to adjacent records.Question of the WeekQ) I am trying to use FME to get some excel data formatted. The problem is there are headers which I need to populate as a column. I tried using the VariableSetter but it gives me the same header all the way through for all the lines. https://knowledge.safe.com/questions/104160/variable-setter.htmlA) Workflows - or the flow of features through a workspace - is an aspect of FME that is important for keen workspace authors to be aware of. In fact I recently wrote a post on feature order for 2019.2. Why does this apply here? It's because the user wants to pass information from one feature to another, not using a common attribute value, but on the basis 

Hi FME'ers,Well, here are the quiz answers for this week. I think Don posed more of a challenge than Dale did last week. You would have needed a perfect score to beat him. Did you do that?First, the answers...Answers1) What is the name of the site for publishing and sharing FME functionality such as templates, transformers, and web services?FME User CentralFME OnlineThe FME StoreThe FME HubFMEpediaIt's the FME Hub:At one time it did used to be called The FME Store, and this community itself has been called FMEpedia and FME User Central at one time (in fact fmeusercentral.com and fmepedia.com will both lead you to this site).FME Online sounds like fun, but has never been a thing, as far as I'm aware.Don's Answer: The FME Hub (Correct) 2) Which of these actors is the odd one out?Eric BanaArnold SchwarzeneggerPeter O'TooleTim RobbinsAnne HathawayDon's Answer: Anne Hathaway (Correct) I know Don is a bit of a movie buff, but I think this one was a pure guess on his p

Hi FME'ers,The FME Weekly Quiz is now open (sorry for the delay).This week is the same as last: your goal is to beat just one person. Last week you beat co-founder Dale Lutz. This week you're trying to beat Safe's president and other co-founder, Don Murray!I thought the questions were still hard, but Don managed a pretty good score, even without Googling the answers. I think you'll have to all work pretty hard to beat him, both individually and as a group!https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizSo give it a go and see if you can beat Don!

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