General

Hi all, Hoping you can help! I have a dataset of assets and associated values, by date and I would like to sum each value column and add the results as a "Sum" row per date, as the image below. I am using the StatisticCalculator to generate the Sum values. Can anyone suggest how I can take the output of the StatisticsCalculator and write the results as a row/feature? Thanks in advance,Mark

FME Desktop 2020: How to display the result of workbench (graphic and table) stored in esri file geodatabase in the “visual preview”? I couldn’t figure out how to display the result of workbench (map and table) stored in esri file geodatabase in the “visual preview”. This is already doable for tools.   

Good morning everyone,I can say "Good Morning" because the quiz is on time this week! It's 11:40am where I am, so success!Anyway, today's contestant from Safe is Jovita Chan.Jovita is another colleague from the technical experts team. She even works for Nampreet (who took the quiz last week). I don't know a whole lot about Jovita, because she's relatively new and I haven't been to the office in so long, but I know from the pets channel in Slack that she has a pet cat called Gnocchi!As always, the URL for the quiz is:https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizOh, and here's a picture of Gnocchi:

Hi All I have a workspace which I have shared in FME Server 2019. I would like to use this as a basic data entry form for end users, so have created published parameters for the attributes which need to be completed.What I would like to do is pass through some attributes from another system (PowerBI), which I can use to dynamically set the URL for accessing the workspace.In JobSubmitter mode this is fine, I can set the published parameters in the URL. But this doesn't fulfil the use case, because I want the user to add some additional detail to what is available to pass through from PowerBI. Hence I'd need to use an FME Server App.My question is: can set the published parameter values on the App using query strings in the URL, like I can with JobSubmitter? If so, what is the correct syntax?  Thanks in advance...Riley

Hello FME'ers,This week I asked my colleagues Nampreet and Jovita if one of them would take the FME quiz. They played rock-paper-scissors and Nampreet lost won and took part.How did he do? How did you do? Let's see the answers and results below...Answers1) What are the three tools in FME Workbench for sending workspaces to, or receiving workspaces from, FME Server?Upload to FME Server, Reupload to FME Server, Unpublish from FME ServerUpload to FME Server, Reupload to FME Server, Download from FME ServerPublish to FME Server, Republish to FME Server, Download from FME ServerPublish to FME Server, Republish to FME Server, Unpublish from FME ServerPost to FME Server, Post again to FME Server, Post it one more time to FME ServerIt's Publish, Republish, and Download:Nearly all of you got that one! Well done.Nampreet's Answer: Publish, Republish, Download (Correct)2) What technical difficulty did Safer Mark Stoakes encounter while presenting on the Virtual World Tour recently

Hello everyone.Many apologies for the lateness of the quiz this week. However, better late than never, so here we are and I'll leave it open a bit longer too.Your challenge today is to defeat my colleague from the Tech Experts team, Nampreet Singh.Our Tech Experts (support teams) are split into two Desktop teams and two Server teams. You've already competed against one Desktop team lead (Andrea) - now you can take on the other, Nampreet.The location, as always, is: https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizNote: In case you can't see the image properly, at the top of that page, here it is:The question is... what year is that World Tour t-shirt from? Do you know?

Ziparchiver fails to read the target folder; Hi All,I tried to use ziparchiver transformer to zip a folder that contain shapefile but It seams that it is not working as I expected For example, I have a workbench that convert a dwg file to shapefile and I want to zip the folder that contain that shapefile with all component but ziparchiver fails to take the target folder What might be the issue here?Any advice please   Best,Lubna

Dear all,I'm hoping some of you in confinement have time to help me out in my battle with a major COVID-19 project involving most of our organisation and representations abroad. This was set to be revolutionary for a world where hundreds of emails and a parallel universe of excel files are as "digital" as many feel at home with. Unfortunately, despite moving heaven and earth in a very short time, it looks like failing at the very last step as the standard reporting tool used in our institution seems to have some kind of bug and can't take the heat. Of course this whole issue surfaced at 4.50pm on a Friday...I know FME Server can do the job, I just don't have all the knowledge (or time to hunt for clues) required. So as was suggested on the Safe Live Chat yesterday, I want to see if anyone out there is prepared to help me with various bits.Software: FME Desktop + Server 2019.2.2.0 (Build 19817)Background:Data entered by our offices abroad in SharePointJSON export f

I have area value for a list of circles and want to find out the radius for each of them.

Hi FME Community,I am moving some FME workbenches from a 2012 microsoft server to a 2019 microsoft server and am finding some issues with running a few of them. The person who originally set up the workbench I am trying to get to run is no longer with the company and I arrived after they left.I am trying to read in table features on a MSSQL_ADO reader and keep running into this error: Provider error `(-2147467259) Encryption not supported on the client.' Failed to open reader I am thinking it has to do with the new server or some configuration that needs to be done somewhere. I have found a few leadshttps://knowledge.safe.com/questions/93143/fme-server-2018-microsoft-sql-server-provider-erro.html This one was answered by the questioner but they did not say how they fixed the error besides it being a configuration issueIn the admin guide https://docs.safe.com/fme/pdf/FME_Desktop_Admin_Guide.pdf I have found at the bottom of page 37/beginning of page 38 something more promisingI am

Hello FME'ers,Because Friday is a holiday this week, you get the question-of-the-week post a little early. Hurrah for long weekends that start on the Friday. So much better than ending on a Monday, I think.Question of the WeekThis question from @rmm7 came up yesterday and relates to testing and filtering data:Q) I'm trying to match values between two attributes on the same feature.  I have an electric transformer with a phase value, and it's connected electric cable, also with a phase value. The phase values can be any combination of A,B, or C. For example, the electric transformer might have a value of AC, and the cable it's joined to has a value of ABC.  I'm trying to find a way to test if the phase values of the transformer are contained within the phase values of the cable.  A) This question got a number of answers, and I think the user has a way forward. But in working out my particular answer, I came up with an idea and thought I'd share it here, to see if it would be useful.If y

Hello everyone, and happy Monday!I realize that Easter Monday is a holiday for some of you, so I'll be leaving the quiz open for an extra day this week. That gives you more time to match your FME knowledge against Senior Technical Writer, David Barber.David works for the Technical Publications team (aka Documentation). According to the staff slides from the 2017 user conference, he's from Pennsylvania, USA and his favourite ways to spend time are eating chocolate and cycling the Vancouver seawall.If you think you can ourscore him in the weekly quiz, then by all means give it a try. The location, as always, is: https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizIf you think you can out-do him in the area of eating chocolate, then I'm afraid I don't have an app for that. You'll just have to issue a challenge another way.

Is there a way to give the end user more than one option for the fme app uploaded data;Hi All,Is there a way to give the end user more than one option of the data he wants to attach in the fme server app?For example, I want to have 2 options (Feature class, and shape file) as the input of my buffer app, How I can do that at the level of workbench and to be reflected to the appIn other words, can I have a multiple format reader in the workbench to be published into fme server?  Thanks in advanceLubna

Hello folks,Well, did you notice the crossover between the FME World Tour and this quiz? Yes, the virtual events are posing a set of polls made up of questions mostly from this quiz.I did notice a different answer in one of the questions yesterday. Don't hold it against me though!What you didn't see there were any questions from this week's quiz! That's for obvious reasons. But did you still manage to get the correct answers and beat Roger? It was a close one. But let's see the answers first (don't scroll down and look at the result yet!)Answers1) Which of these is NOT an ending to an FME transformer name?FinderFlipperSwapperComposerForcerWe always start with an easy question, and this week was no exception. The only transformer we don't have is a Flipper. All of the rest are valid transformer names, like:NeighborFinderCoordinateSwapperGMLFeatureComposer2DForcerBut no Flipper. Obviously we try to suit the action to the word, and the word to the action (as Hamlet put it) so I guess ther

I need to set attributes based on whether the workspace is running on FME Server or Workbench. I could do a published parameter to manually toggle a value etc. but I would like it to be more automatic. The idea is that when building and testing on Workbench, I get specific behavior related to that environment; if run on FME Server, this behavior adapts as well. Is there a way to determine from within a workspace where it is being run from? Thanks in advance.

Hello FME'ers,Because Friday is a holiday this week, you get the question-of-the-week post a little early.Question of the WeekThis question from @rmm7 came up yesterday and relates to testing and filtering data:Q) I'm trying to match values between two attributes on the same feature.  I have an electric transformer with a phase value, and it's connected electric cable, also with a phase value. The phase values can be any combination of A,B, or C. For example, the electric transformer might have a value of AC, and the cable it's joined to has a value of ABC.  I'm trying to find a way to test if the phase values of the transformer are contained within the phase values of the cable.  A) This question got a number of answers. But in working out my version I came up with an idea and thought I'd share it.If you don't want to go through the whole thought process, then just skip to the Summary section.Otherwise, let's start by looking at what exactly we're trying to do... Question Requirements

Hello users,As you know, the FME user conference is postponed until next year, and we're all in quarantine for the foreseeable future; but that doesn't mean we have to go without any fun and interaction.Firstly the FME World Tour virtual roadshow starts next Monday. Make sure you don't miss it!But secondly, we were planning a hackathon at the user conference, and if there's enough demand I figure we could still go ahead and do this online.I'm hoping we'd be able to have a few prizes available, maybe suggest some bigger projects, maybe work in online teams? Just like we would for the in-person event, but online (and spread over a longer length of time).Is anyone interested at all? Let me know with an answer below, whether it's yes, no, or "you must be joking, this is not a good time". Also say if you'd be OK with a team format, when we should start, any project ideas, etc, etc, etc. Maybe I can get different Safe experts to act as team leaders a

Hi all,In the current context of the COVID-19 pandemic that we are currently experiencing on a global scale, the existence of data provided by national and international health organizations around the world offers the possibility to the GIS community and Geospatial specialists the challenge of supporting their community in the fight against the spread of the virus.Like the initiative to implement a dashboard made by the John-Hopkins Center for Systems Science and Engineering (CSSE) to monitor in real time the spread of the virus, my question is as follows:What will be the different stages of a workflow to organize and prepare the data necessary to carry out such a project with FME Desktop and Server to publish an ESRI Operations Dashboard.I would like to have the opinion of experts on this specific case which has been in the news lately. At the same time, I challenge all participants in this World Tour to share a FME Workflows to create a dashboard like that of the John-Hopkins Univer

Hello FME'ers,The quiz is a little early this week, because my intended Safer is going to be busy on Monday. So I've switched the quiz with the question-of-the-week. I won't close it until Tuesday again, so no worries there.Anyway, your challenge this week is to beat Roger Aikema. Roger is our Digital Marketing Lead, so he'll be responsible for a lot of the content you see on our web site (which I have to say, looks better and better each time I visit). So he must know a fair amount about FME, right?As a special bonus, this week the quiz is...THE TRANSFORMER SPECIAL! Yes, all of the questions are about transformers. So if you like transformers, today is your day. I'm not sure how knowledgeable Roger is about transformers in particular... I guess we're going to find out!As always, you can find the quiz here: https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizGood luck, and I apologize in advance for question 2. At least you have the whole weekend!

Hi, I would know if exist a transformer that verify if file header is correct. Thanks

I've just run into an issue with FME Desktop crashing on startup with the system error logs mentioning winspool.drv. I'm pretty sure it is to do with a recent Windows update KB4541329 so I'm trying to uninstall that. I'll update this post once that is done but in the mean time you might want to avoid that update. Update: Uninstalling that Windows update worked and FME Desktop runs now.

A failure message appears in the buffer app if the input geodatabase has a feature class which has a different name of the one used in the buffer workbench.Hi All,I Couldn’t figure out if I can edit the reader on buffer workbench to make the buffer app take any geodatabase that contain any feature class regardless its name,My app fails to run and return a failure message if the feature class name is not the same one I used in the workbench Best,Lubna

Hello,  I wanted to know if you could help me on these different points, perhaps some of these questions have already been asked and I apologize in advance. If it is the case I want the URL link in question.  Carry out a workbench on FME 2018 which will correct the inconsistencies of the dwg files for for example: 1) Match the layer numbers of old dwg files to the requirements of a new dwg layer template. I had thought about listBasedFeatureMerger, what do you think?  2) Shift the points of a dwg file having a positioning error caused by the drawing (add a tolerance of 1 millimeter), that is to say move the points which must be located near a polyline towards a point of the polyline without touching the layer of the dwg file: I use the Snapper transformer, do you have a better idea?  3) Gather the linear array of a dwg file so that there is no more space between the segments, that is to say, hang the points between them and fill in the gaps to form a sort of polyline. I had thought of

Hello, I wanted to know if you have already managed to convert a JPEG image to a SHAPE point with the GPS coordinates (latitude and longitude) of the EXIF data on FME 2018. Knowing that I don't have the EXIFGeometryCreator transformer which is on FME 2020. For the moment I am using the AttributeManager transformer to remove the parentheses contained in the jpeg_exif_gpsdestlatitude and jpeg_exif_gpsdestlongitude data. Example: I use this StringFunctions @Trim (@Value (jpeg_exif_gpslongitude), ()) for the longitude which is worth: jpeg_exif_gpsdestlongitude = (0) (33) (0) And for the latitude I have: jpeg_exif_gpsdestlatitude = (44) (28) (4) However the StringFunctions that I use only deletes me the parentheses at the beginning and end of expression as below: 0) (33) (0 and 44) (28) (4 Do you have a solution to remove all the parentheses? For the rest I use the transformer VertexCreator, to use these coordinates (altitude and longitude) to be able to obtain a point having as attribu

Apologies for the late results. I was a bit busy yesterday helping out with the upcoming World Tour Virtual Roadshow. You are signed up for the roadshow, right? If not, go click that link. You'd budgeted a day to attend the world tour in person, so you'll have time in the bank to watch these webinars.And there may be some crossover with this quiz... just saying.Anyway, did you best Iris in this week's quiz? I suspect you probably did. But let's see the answers and who got the best scores overall...Answers1) What does the Ctrl+K shortcut do in FME Workbench?Sets the Connection ColorAdds a BookmarkAdds a BreakpointAdds an AnnotationControls the amount of Vitamin K used by a workspaceYes, this is fairly straightforward for if no other reason than you have FME Workbench at hand to try it out. The answer is that Ctrl+K adds an annotation:If you have an object selected, like a transformer, then the new annotation will be connected to that object. If you don't have an obje