FME Form

Hello, I am struggling with transforming a dataset that I have to the desired format. I have a table that looks (for example) like this:ID;16;50;60;75X1;10;25;80;95X2;30;30;90;X3;25;;80;100 The first issue is that I need to use the column headers to get classes:0-16, 16-50, 50-60, 60-75But for ID X3 the value in column 50 is missing and therefore I need to get the class 16-60 (instead of 16-50 as is the case for ID X1 and X2). I don't know how to create this in FME.  Secondly, I need to calculate the value for each class by substracting the values from each other. So for ID X1 I need the following result:Class 0-16 = 10Class 16-50 = 15Class 50-60 = 55Class 60-75 = 15Class >75 = 5 Besides, I want the classes as an upper- and lower limit column.So the final result that I need for the three ID's is:ID;UPPER_LIMIT;LOW

I am creating a mosaic from a bunch of tiff files into an ecw. The shape of all the tiffs together is irregular so there is empty space. It is defaulting to black, I would like it to be white. This seems like it should be an easy fix but I can't figure it out.

From the first image, you can see the selected object has 6 chairs, which is decided by the number of the visibility. But after translated it into MapInfo, all the options of the visibility (3,4,5,6,7,8) have been translated and overlapped each other. I want the number of chair on each object displayed on MapInfo are the same as displayed on CAD file. Anywhere I can adjust apart from Explode Blocks on FME? Help please! Thank you!!

Every time a workspace file is opened changed and then save a whole lot of lines in the .fmw file are changed. This makes it (almost) impossible to work with git. Does Safe Software have any plans to change this going forward to reduce the number of line changes? It would make development with workspaces much more streamlined. I presume if was doable it would have been done a long time ago, however, it would be a great improvement. I know this has been asked a few times but perhaps there is an update?

Suppose you have some kind of JSON as follows:{   "students" : [      {         "id" : "01",         "name" : "Tom",         "lastname" : "Price",         "hobbys" : [ "football", "hockey" ]      },      {         "id" : "02",         "name" : "Nick",         "lastname" : "Thameson",         "hobbys" : [ "reading", "gardening", "painting" ]      }   ]}and I would like to create a list attribute for only some specific content of the JSON. For example, lets say your only interested in only the name and lastname of the students. Then I would like to achieve a result like:students{0}.name = Tomstudents{0}.lastname = Pricestudents{1}.name = Nickstudents{1}.lastname = ThamesonIs there some easy way to achieve that?I am aware of the following transformers that can extract JSON data:JSONExtr

The mouseover popup labels (is that what they're called??) on answered topics on the forum are showing a wrong text, see the illustration below. Nothing disruptive, just strange. 

Hello,  I have an FTP Caller which works fine to upload a file to an SFTP connection using FME Desktop (on version 2019.2). However, on FME server (version 2019.2) it fails with this error:With guidance from this post: https://community.safe.com/s/question/0D54Q00008B1IFh/problem-with-ftpcaller-and-sftp I also tried publishing the workspace in a newer version (2020.1) and running in on FME Server (2019.1 and 2021.1) but without success.  Any help?

Greetings,I have a MS Excel Spreadsheet hosted in MS OneDive. Upon opening the spreadsheet, a MicroStrategy report runs via an Excel Plugin (it takes abut 5 minutes to finish) and refreshes the content of the spreadsheet. Once the spreadsheet's contents are refreshed, I would like to save the changes and close the spreadsheet.I do not think the Excel feature reader will work, as the act of opening the spreadsheet its self is what triggers the report. We cannot use the SystemCaller transformer to call the cmd prompt start function, as the file resides OneDrive. Even if we could get that to work, we would still have to save and close the spreadsheet.Ultimately, I would like to upload this workspace to FME server and have it run every morning.Any help would be appreciated.

Hi there, I'm struggling to build a proper GeoJSON file. Attached please find the source XML file which I'm trying to convert. These are all points and I would like to have the different fields as properties. I tried to aggregate the separate "latitude" and "longitude" attributes into a single "Coordinates" attribute by means of the AttributeManager but that didn't do the job. My "Coordinates" are always read as a feature property and not as a feature geometry. GeoJSON has a specific format ( see https://geojson.org/ ) and I don't know how to construct it with FME.  Of course, I'm using the XML Reader (Parameter set to: modu/moduEntity) and GeoJSON Writer. Any help would be much appreciated.Thanks in advance already.

Is there going to be recorded/uploaded again any "FME Desktop Advanced Training" for recent FME versions ? I checked up all the older versions and I learned so much from them and I really hope there is going to be another one for most recent version. Anyone knows something about it ?

I have a number of GPS tracking records that contain straight line segments i.e. noise arisen from loss of signal. I would like to remove lines > 1 km to improve visualising the data. The workbench would need to:Find straight line segments within each dataset > 1kmBreak/Split the line on the vertexDelete the line > 1kmThe lines that have been split at either end can remain as they are i.e. do not need to be merged or joined Please can someone briefly describe the workflow that I would need to create to achieve this?

How can I connect to an MS Access database on a separate box using FME Server running as service account? I have granted access to the to the folder to the Service Account but FME doesn't seem to like the UNC path.

I have a workspace that extracts users and attributes from Active Directory, at the OU level. I want to take this workspace and create a custom transformer as part of a larger workflow. Last time I copied these LDAP readers it completely broke everything and I had to fix them one-by-one. Is there any way to import a workspace as a custom transformer? This is just reading a bunch of LDAP data and spitting out a CSV. *Edited to reflect I'm trying to export/reuse connections, rather than transformers.

I see there are C++ and Java versions of the reproject plugin in the plugin builder samples collection, but not a Python version. Is there something about that plugin that makes it hard to build in Python? In particular I am interested in the OffsetProject sample.

I have been using a url like the one below to monitor my FME Server 2017. http:///fmerest/engines.xml?token= Since upgrading to FME Server 2020, this fails. Is there a similar API call I can make to get the same result?

우리는 소프트웨어 리셀러이다. 대한민국에는 파트너가 없다. 1. 대한민국 공공기관에서 FME 소프트웨어 견적 문의가 들어와서 홈페이지로 대행 결제를 해도 라이선스 저작권에 문제 없는지 확인요청드립니다. 2. 구매하면 라이선스 구매확인서가 기관명으로 나오는지?? 3. 구매하게 되면 아래 홈페이지 URL을 통하여 대행 구매해도 문제없는지 확인 요청 https://www.safe.com/pricing/fme-des

I'm making a custom transformer and the users will select multiple choices from a published parameter list that contains a value with text that includes a parsable field name with other info. I've been working to parse that out into a comma delimited attribute, which I now have. In my reading of other questions surrounding this, it seems like this is not possible with truly dynamic transformers/workspaces, but in my case I have a known list of the names. What is the best way to expose attributes that are known in this way in a custom transformer or in general?Thanks!

Hello all. I'm trying to determine the best way to read the schema of an SDE geodatabase. My end goal is to read each table/feature class' attributes and properties (name, data type, length/precision) from a File Geodatabase and compare them to tables/feature classes from an SDE geodatabase. Most are the same but can differ slightly for a quarterly data load of 300+ tables/feature classes. I've managed to use the Schema (Any Format) Reader for the File Geodatabase, but if I use the same reader on the SDE geodatabase, it gives me an error: "An error occurred while attempting to retrieve the connection parameters from the connection file ''". It sort of looks like it can't find the connection file, even though a working .sde connection file is in the "Source Dataset" parameter, and there aren't many other parameter options available. Does anyone have thoughts on how to configure the Schema (Any Format) Reader

I have an idea of how I would write this in Python but being new to FME not quiet sure where I start here with the transformations.. For example: the Column will have an A, B, or C. If the column for any row has a "C" I want to to delete this full row. While it seems simple enough Python I'm not quite sure where to start with FME. Any help or helpful tips to point me in the right direction that would be great.

HiI have a large csv file which has a column with multiple references in, this is 1 of the records;2810X000000466,,APQ4LA805C34REUGJU,2845AP;2810X000000467,,4985,2845ER;2810X000000468,,361301760100,2845CT;2810X000000469,,DV361301760100,2845NC;2810X000000470,,APQ4LA805C34REUGJU,2845NA;2810X000189003,,BC,2845PS;2810X000267245,,E00137336,2845OA;2810X000267246,,E01027004,2845LS;2810X000267247,,E02005628,2845MS;2810X000331704,,C,284599;2810X000384460,,01/04/1993,284591 Each reference is prefixed with a comma, then the reference, comma then a colon. For example;,361301760100,2845CT; I am specifically looking to extract only the 'CT' cross reference. Can someone give me some advice on how to write a regualr expression to extract this reference using the StringSearcher in FME. please?thanks Simon Hume 

I have create web connection for ESRI AGOL, when i try to authorize i receive error "We're sorry, the page you're looking for can't be found."

I am implementing a custom reprojector plugin which needs to access a parameter or attribute that an earlier transformer has created.  I am writing the plugin using the C++ SDK, but am having difficulty seeing how to access this information from the ReprojectEngineManager class to use it. Any tips to how to do this are appreciated!

Hi, I have a CSV file with 20 spatial points & I was able to convert the points into a line (using LineBuilder) but the line which is created is having a single feature to it. I have used Chopper Transformer to cut the line. It does the job for cutting the lines but all features get same as the first one feature.How I can separate the feature as well with the lines Please Help ..!

I'm having trouble trying to push the contents of a CSV file stored in an AzureBlobStorage enviornment into a SQL DB Table. I can download the CSV file directly using the AzureBlobStorageConnector, but I'd like to be able to d it all without creating the temporary file that would normally result. I'm trying to download as an attribute which seems to work, but I can't get the data out of the resulting list as it ends up with a single column from listExploder with all the contents and the index for each element from the file in their own rows.e.g._list _element_indexcol1_name 0col2_name 1col3_name 2col1_value1 3col2_value1 4col3_value1 5col1_value2 6col2_value2 7col3_value2

Hi,I've got a text file that has dates as parameters for a data pull that I would like to add to the actual data that was pulled after it has been manipulated to have only the items we are interested in.In this case, start and end dates for the ranges. I want to add those to two columns in the data that is being updated/appended to in an EGDB.I thought maybe global variables, but they can be SO finicky. Is there another way to attach these dates to each row in the table as it is being updated/appended?Thanks,Lorinda