General

Hi folks,If you lurk around FME accounts on Twitter, you may have seen a recent exchange of poetry between a few of us. I've posted them at the foot of this message.Anyway, it made me think that a good challenge for us would be to create FME-generated poetry. So here we are! I don't really think there are many rules except you must use mostly FME (I can allow a bit of Python etc, but not connecting directly to an API that generates the poem for you).In case it sounds a bit complex, here are some suggestions:Read random messages from Twitter and merge them togetherHave a dataset of poems and select random lines from eachHave a dataset of words and try to construct sentences from themUse an API that (for example) helps determine if words rhymeTake an existing poem and replace words with random attribute valuesIf you don't think your FME skills are up to it, just write us a nice poem about FME!And you will definitely get bonus points for:A workspace that generates a different poem each ti

Hi All , I am looking to make a https api call to one of our application. the application works following way and require multiple json call to the application1) https json request to login the application , below is an example of a working Curl request for the same.e.g $CURL -s -k -c $COOKIE_FILE -H "Content-Type: application/x-www-form-urlencoded" -d "op=login&username;=<username>&password;=<password>&app;=api" -o login.json -X POST https://<application_hostname>/perl-bin/auth2) https json request to perform your query for the data , below is an example of similar curl request.$CURL -s -k -b $COOKIE_FILE -H "Content-Type: application/json" -d @<json_request> -X POST https://<application_hostname>/perl-bin/reportservice3) https json request to logout , below is an example of similar curl request.$CURL -s -k -b $COOKIE_FILE -H "$FORM_HEADER" -d "op=logout&app;=api" -o https://<application

I have a workbench which calls a series of other workbenches. It works fine when running through Desktop mode but when running via Quick Translator it fails (see attached screenshot):

I have a workflow that reads a MS Access file and splits two attributes into two separate values each by means of two AttributeSplitter transformers. I then use the AttributeManager transformer to place the 4 new values into 4 new char attributes. I need to strip the leading zeros from two of these fields and was wondering if this could be done in AttributeManager? If not how could it best be done before the AttributeManager (the next step is to use AttributeManager to concatenate these values.

Hey everyone, I'm getting used to FME and needed some help with a task that I wanted to complete. I have an excel sheet that has the total produced oil, water, and gas for a month at a time per column. Each row represents one year of a well. I tried using the doing the StatisiticsCalculator and Im getting the cumulative sum but I just want one final sum for each well. I have production data going back to the 80s so the running cumulative is way to many rows. Does anyone know how I can get the total sum for each well?

Hello all,I'm converting CAD data and I'm receiving this error code: Postcondition failed at topology.cpp:1089. Expression: remainingLRP != nullptrI'm thinking that it is caused by bad CAD data. Has anyone seen this error before?Also, I'm just looking at Walls (for the moment), but when I translate the data, doors from the door layer come through. Does anyone know what may be causing this?Thanks, David

Hi everybody.I've a data structure like that :IDLENGTHDATA180MyData11120MyData1145MyData10280MyData2377MyData3and I want to aggregate them like that :IDLENGTHDATA1200MyData11120MyData1145MyData10280MyData2377MyData3and I want to aggregate them like thatHow can I do that ?

Hi FME'ers,I am working with the new WorkspaceRunner transformer in FME 2018 (Build 18284 - WIN64). I have come across an issue whereby the first FME process always stalls then crashes. For example, if I run 3 processes with 1 workspace each, the first will stall while the other two run to completion then the first will crash.I am writing to ESRI Geodatabase (ArcSDE Geodb) in transaction mode with 5000 features per transaction. Before running I truncate the tables with arcpy so they are not getting locked. Is this a bug or am I doing something wrong?Thank youDavid

After I've run a workspace with FME 2018, the inspector takes like forever to start. Anything from several minutes to forget-about-it. For compability reasons, I have multiple FME installations at my windows 7 corporate PC (which is a pretty hardcore piece of a machine (32gb ram, ssd, plenty of processing power) - if this machine can't run it, nothing can). No issues so far - except that the 2018 inspector will either give up completely or take minutes to show the data I've piped into it. FME 2017 and older seems to work fine. Unless a lot of other people are complaining, I guess there must be something fishy with my setup. Any ideas welcome.

Hello all,I think this is the right place to get answer to my question..I have a batch of Revit files converted them in to .RVZ using FME Exporter and i need to convert them in to .GDB files by using FME Desktop .I have a knowledge creating them as a single file (RVZ----GDB)But am looking for Batch process to convert .RVZ files to .GDB files.Please help me out ..Thanks in advance ...

Hello,We are planning to buy licenses for FME Desktop Database and SmallWorld editions 2018. Are the MRF2DTransformers default included in these two editions or we'll have to purchase them separatly ? Thank you in advance.

My translations won't run today! They worked fine yesterday. I was using the first release of 2018 (Build #18284). I just upgraded to the latest beta (Build #18445), but that didn't solve it. I'm aware of the issue with ESRI's Geoprocessing patch and ArcGIS Pro, but that has been installed for several months and my models have been working fine during that time. I also checked for the Windows KB patch for the Spectre virus and that has not been installed, so that shouldn't be it either. This is catastrophic for us, and I need help ASAP!

Im trying to double click and start a new FME desktop 2016.0 64 bit version.It takes too much time at a point when there is a message loading transformers. Is there any specific reason for it?How can I overcome it?Thanks

Hi All,i am using HTTP caller and getting wherein i am passing name text and checking certain parameters but getting an error message as "{"status":"ERROR","messageName":"com.tomtom.cpu.coredb.common.dto.ErrorMessage","messagePayload":{"errorCode":"APPLICATION_ERROR","errorInstanceId":"0da931e0-13b8-444f-aa78-534016b68679","errorDetailedMessage":"Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value at [Source: org.apache.catalina.connector.CoyoteInputStream@708a538f; line: 1, column: 111]"}}"Thought this is related to the extra space so i had tried to clean name sting but still it's giving me same error.Can somebody help me with this ?

Hi everyone,  I'm in the process of creating a dataset that shows the painted lines for parking spaces in a parking lot. I've been using Bounds Splitter and Geometry Coercer to generate a grid of parking spaces along two rows of parking. However, I'd like the individual parking spaces to reflect the actual painted lines on the pavement. That is, instead of having a closed rectangle correspond to a parking space, I'd like to create a polyline dataset where only the three sides of the rectangle that correspond to the actual location of the paint on the pavement appear.For example, I'm interested in removing the portion of the line that is touching the red arrow in the attached screenshot. Any ideas how to remove this portion of the line?Thanks!Jenna

I have installed FME desktop 2018. While connecting to license server, its throwing error 'FME floating license failure: Server node is down or not responding(-96). Please note my system already have FME 2017 installed and pointing to same license server.

I like to make the titles and other information (bullet points etc) in bookmarks to be bold, of varying colours etc. Is this possible in FME 2018 when creating a new bookmark? It doesn't seem to work for me. I create FME workbenches for a production team to use (many have little to no experience in FME) so I like to comment workbenches quite extensively.

Do you need to switch the rotation of your label from arithmetic to geographic or the other way around? You can use the RotationSwitcher I published on the FME Hub.

Hi Team,In my case, there are multiple geometries coordinates in one json file. I need to create multiple geometries and write to shp file. Sample json file attached.in this file there are multiple geometry blocks, I should iterate thru json and create geometris.help will be appreciated

We run the workspace using PERL. We have implemented a conditional check in the workspace for record counts BEFORE we update the table. If that TEST fails, we route to the Terminator transformer.The issue we are having is that Terminator does not set FMEException, thus PERL thinks it was successful.We need to terminate the STREAM of jobs.How do we do that? I do not see anything FME parms related to FMEException.

I can't find anything in the documentation about how FME Desktop stores published parameters that are passwords. Are these encrypted? Or does FME desktop store these parameters as clear text behind the password stars? For instance, in the workspace below, I have published parameters that are passwords (I've set the published parameters to password type) How is FME Desktop storing these?

I really like the new run control options, but feel quite strongly about them being in the reverse order. Since data flows from left to right, it feels more intuitive if the first button was "Run To This" and the last one was "Run From This" (as the data then continues to flow towards the right), with the center button remaining "Run Just This". Here's a I think the icons could also be a little clearer too. Reversing the placement will probably help as I find myself constantly hesitating and waiting for the tooltip since I keep picking the wrong option! But I think the bottom part of the green arrow graphic is the most important part and unfortunately it's the smallest and least readable. I'm attaching a of something I feel is more readable.Would love to hear your feedback if you played around with this. Thanks!

Hi all,I'm trying to send an email with an attachment. How my workflow works is it creates an excel spreadsheet for my QA-QC of the data. It then sends an email with the created excel spreadsheet. Is there any reason why the email wont send with attachments? The size is less than 25 mb.Thank you,David

I installed FME 2018 on Ubuntu 16.04 using this FME on ubuntu 16.04 install Knowledge page.Finally I managed to install FME 2018, but now it won't start.I have not so familiar with Ubuntu and therefore I need some help.

Hi all,we have really complected workspaces that have been left for support by another team and sometimes we need to find where specific attributes are used, created , read, written.It might help to see all attribute usages in workspace. Without such functionality it is really time consuming process.Thanks for any your answers.Alexander.