Transformers

Hi,I am picking up some JSON from a feature reader and outputting to Excel. It works fine but I would like to order the Excel output so that some header fields are always returned first, e,g, ID, Name, CountryThe trouble is that this JSON is dynamic and sometimes doesnt include the attribute 'Country' if it hasn't been populated. This means when the JSON gets brought in and the first record doesnt contain country then it would look structure like so:ID, NAME, FieldA, CountryIs there any way I can partially define the schema whilst leaving the rest dynamic?Thank youOliver

Hello,I have to export a bunch of point and line feature classes with their feature-linked annotation from SDE to a file geodatabase and then also zip the file geodatabase.The annotation bit is taking a long time and log file reports a large number of warnings. Any ideas what's the most efficient way to do this?

I have an UpdateDetector, but instead of hard-coding the "attributes to match" via the GUI, I would like to pass them in via a user parameter, which is ultimately populated from a spreadsheet via Python. (In fact, because I am using generic outputs for the FeatureReaders, I don't get the GUI option to add attributes.)Unfortunately, it appears I can only pass in a single value this way. If I pass in any more, as a space-delimited list for example, the UpdateDetector appears to just ignore the values passed in and reports all rows as Unchanged.Is there any way of supplying multiple attributes to match using the approach I'm using?I have attached a screenshot of my workspace, which uploads a file gdb data source, saves it to a table and then just compares that table with an existing table.

I am needing to set up a user parameter that will list text values. For Example, PR01 EZ01 BR01The Idea here is to be able to use this list with an SQL Creator as such:In FME -- Select * from <table> where Sys_Code IN ($(sys_code))Or Oracle SQL -- Select * from <table> where Sys_Code IN ('PR01','EZ01','BR01')Any help is appriciated.

Hi,I have this data below which I would like to transform into a single record per row.key. How do I do it?Ideal output would be 2 records with field.name converted to columns.Cheers

I found some help in an earlier post in regards to this (https://knowledge.safe.com/questions/46672/change-degree-minute-seconds-hemisphere-to-decimal.html), but the format of my DMS lat longs is different (I have spaces between the DMS values and my lat/long DMS values are separated). I tried to edit the regex from that post to no avail while trying to extrapolate my latitude DMS values...(\\d+\\.?\\d*)|([NSEW])(\\d+\\.? \\d*)|([NSEW])(\\d+\\.? \\d*)|([NS])However, my matched parts comes through with just the degrees value and are missing the minutes & seconds values. I will admit that I don't know enough regex!Here's the details... I have latitude and longitude values stored in separate columns in DMS format (e.g., 27° 54' 32.32124" N or 38° 24' 16" N), and I need to convert them to decimal degrees. The seconds values may have a precision of anywhere from 2-7 with a scale of 0-5. I know I could probably handle this in a more cumbersome way with testers/t

I have a point (base) and a list of lines (candidates). a nearest line is found using NeighborFinder. it seems that the result from "matched" port does not have geometry of matched lines (the candidates). Any suggestions?

I have the following data; a road network for a city, a number for routes through the city and a point file for each junction where a manoeuvre is required. What I want to identify are the start and end road segments for each manoeuvre along the routes and in the direction the route is.For example, if the route makes a "right turn" I want to identify the road element before the turn and the road element after the turn is made. This order should be in the digitisation direction of the route. I then want to use the information to tag the road elements as "from" and "to" and grouped by the junction ID.At the moment I have been able to select the road elements that make up the manoeuvre but I am struggling to sort them into the correct order of sequence (i.e. in the direction of the route). Any ideas on how I can achieve my desired results?

Hello, i use and like the new ExcelStyler Transformer. Is it possible to define the cell size/wide? When I generate a table all cells have the same size an it looks like this, cause the text seems to be cut:I dont want that the text fit in the cell but that the cell grows with the text. Please can you give me a tip how this problem can be solved? Thanks, David

Hi All,Workbench, Inspector etc. do not open after I entered the R path in the path location option.It did work neatly (the path and all are valid, though not using the default plug-in path), until I shut down the application. When trying to (re)start it gets as far as the splash screen for loading GUI. Then it just pops away.Event Viewer says:Faulting application name: fmeworkbench.exe, version: 2018.7.34.18301, time stamp: 0x5ad2626aFaulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000Exception code: 0xc0000005Fault offset: 0x0000000000000000Faulting process id: 0xce0Faulting application path: D:\\PROG\\FME\\fmeworkbench.exeFaulting module path: unknownFaulting package full name: Faulting package-relative application ID: Does anyone know how to solve this? Can I somehow reset the location (mind you I can't open the workbench, using certain user profiles)Can I access the settings file to do so?

I know a way in arcmap using toolbox Conversion Tool under that i am using "feature class to geodatabase" to remove those values by unchecking the m and z values. But, for larger data set, arc map is crashing. Is their any transformer in FME, where we can remove those values in shape files?

Hi, hopefully a quick one but it isn't clear to me. I have mapped an S3 bucked to a resources folder in FME Cloud - https://xxxxxx.fmecloud.com/fmeserver/#/resources/browse/rastersHow do I reference to this folder in a workspace, I cannot use FME_SHAREDRESOURCE_TEMP or FME_SHAREDRESOURCE_DATA What FME Server Parameter should I use?Many ThanksOliver

Test to see if "viewable by original poster" means viewable by poster of the parent question, or poster of of the answer/comment we are replying to.

I'm looking to extract text from a specific area of a PDF. The box contains IDs and I would like those written to a simple Excel file. My source data is a PDF with roughly 100 pages, and the area I want scanned is in the same location on each page. I believe the best tool to use for this would be the new Adobe Geospatial PDF reader but I am unsure how to proceed from there.

I have a workflow where I am trying to write out a MapInfo file dynamically. When using a normal Writer the file writes out correctly as per the schema I have told the writer to reference. The attributes are written out in the order as prescribed in the schema. Within the Writer, in the "User Attributes" tab the Dynamic option is selected and there are no attributes listed here (as they are supplied from the schema of the Workspace Resource I have added). This works and makes sense:However, I would like to use a FeatureWriter instead of the standard Writer as I need the translation to continue on, as I use the Emailer to confirm that the workspace has completed successfully. In the FeatureWriter I have the same options as I would use in the Writer selected, and the FeatureWriter is referencing the same Schema Source::In the "User Attributes" tab the Dynamic option is selected but the Attributes still appear and the attributes write out in the order they go into

Hello all,I have a large number of points (over 15,000) in the same geographical (x,y) location that I need to filter out. I cannot do this spatially and there is no coordinate data in the points. There is only one attribute within the data I can use to filter on (Address).I have a spreadsheet that has a "Town" column that has over 3500 rows.Is there anyway of bulk testing the Address attribute against the Town column from the spreadsheet to filter down the data? I don't want to copy and paste 3500 Town names into a Tester if I can avoid it!Thanks,Jeff.

I'm running 2018.1 Desktop on a Mac (OSX). I decided to test the Word writer so I created a Word Writer, an MSWordStyler to create some content (a simple text string), and a creator to kick the thing off. When I run it I get 6 errors which begin with 2018-07-19 08:08:49| 0.3| 0.0|ERROR |Python Exception <ImportError>: No module named FMERasterSaver 2018-07-19 08:08:49| 0.3| 0.0|ERROR |Could not create Python Writer `MSWORD' 2018-07-19 08:08:49| 0.3| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details I can't find any reference to "FMERasterSaver" using Google or Safe's knowledge center. Any ideas what is wrong? I'm guessing this bit never got installed.

hello there we are using the dynamic workflow by reading form geodb and writing to MS SQL Server DBbut each fme_ feature_type will be written to a different schema in the databasehow can configure the writer to do so Thanks

HiI need to reformat some csv file (so rename use conditional value ecc ecc) but at the end I want also to remove the fields that are empty (I mean every fields without any value inside)thxFrancesco

I have a workbench where features are updated in my postgresql database using the SQLexecuter. I am wondering if it is possible to view weather the update was successful or not? When SQLexecuter runs into an error I get the error message in the log but what I am looking for is more of what you see when you run a query in PGadmin "query executed successfully 250 features updated". what I really am interested in for QC purposes is "query executed successfully 0 features updated"

My features have an attribute containing an XML document and a list attribute. As an example, imagine the XML attribute containing this document:<?xml version="1.0" encoding="UTF-8"?><root>  <foo bar="aaa"/>  <baz>    <foo bar="bbb"/>    <foo bar="ccc"/>  </baz></root>And the list attributes containing these values:list{0}.ident = "aaa"list{0}.value = "xxx"list{1}.ident = "bbb"list{1}.value = "yyy"list{2}.ident = "ccc"list{2}.value = "zzz"What I want to achieve is to update the XML attribute so that it contains this modified XML document:<?xml version="1.0" encoding="UTF-8"?><root>  <foo bar="xxx"/>  <baz>    <foo bar="yyy"/>    <foo bar="zzz"/>  </baz></root>I think this should be easily doable using the XMLXQueryUpdater in conjunction with the FME XQuery functions, but I just don't get it right...Thanks for your help,David

Hello, I have a problem with the calcul of a sum (expression evaluator, statistic calculator..). The result is not correct. I make this calcul : 10000+10000+1+100+0.1+0.01 and the result is 20101.109999999997 . I have this problem in fme 2018 and 2017 but in 2015 the result is correct . Have you got any idea to solve my problem? Thanks a lot.

Hello! I'm a first time poster and newbie FME user and hoping someone might have some ideas to help me solve what it a fairly simple task but incredibly time intensive without coding or the use of FME.  I need to download and then process just over 150 shapefiles that are posted on an open website. The state of Massachusetts posts building footprints on their website for download. I need to download each file and combine them into one large geodatabase. I have some additional processing and attribute changes I need to do in the middle but have a good handle on that stuff.  What I'm thinking is: - Store the URL strings for each of the file downloads in a CSV file - Somehow leverage the HTTP caller to iterate through each of the URLs in the CSV and pull the shapefiles into my workspace.  - From there feed each file into a shapefile reader and then move forward with my processing and writing to geodatabase.  Here is the website where the data are housed - http://goo.gl/Jzo0QK  Any

Hello everybody,Im trying to solve problem with analysis. I need to proceed analysis only in situation when features came from both inputs. If features will come only from one input, analysis will not be processed.E.g. attached pic belowI want to process PointonPointoverlayer analysis only in situation when features will come from Creator and Creator_2. In situation when Creator or Creator_2 output no features, overlay analysis will not be processed.Do You have any idea how to solve this issue please?Thank You so much!Lubo

Hello, any idea on how to read/write from/to Jira Atlassian data using FME desktop ?