Using transformers to modify data.
Recently active
Hi, I have created some JSON in FME but would like to remove the first couple of levels.At the moment I have:[ { "output" : { "status" : "200", "body" : [ { "well_id" : 25325, "well_name" : "MYALL_CREEK_3", "latitude" : -27.046011, "longitude" : 149.236806 }, {etcideally I would like to remove the "output" level[ { "status" : "200", "body" : [ { "well_id" : 25325, "well_name" : "MYALL_CREEK_3", "latitude" : -27.046011, "longitude" : 149.236806 }, {Could you please tell me how to achieve this.For reference my workbench looks like: Many Thanks,Oliver
Hi, Im using an XML templates with a geometry template.I have a for loop and I have my positions in a list attribute.Whenever I use the variable for the indices fme:get-attribute("_Positions{$i}.y") I get no results but if I use the same value that is in $i it works, I don't understand why I'm getting no results.Here's the GEOM template with some extra rows added for testing that value 0 exists.for $i in (0 to (xs:integer({fme:get-attribute("_element_count")})-1)) return { <LineCoordinate> <Seq_No>{$i+1}</Seq_No> <latitude_position>{fme:get-attribute("_Positions{$i}.y")}</latitude_position> <longitude_position>{fme:get-attribute("_Positions{$i}.x")}</longitude_position> <latitude_position>{fme:get-attribute("_Positions{0}.x")}</latitude_position> <longitude_position>{fme:get-attribute("_Positions{0}.x")}</longitude_position> </LineC
I need to Dynamically change the Port Number in Workbench from Command Line before starting the FME workbench based on the Smallworld session
Hello, I am trying to run a simple FTP Upload operation by calling coreFTP using SystemCaller. This is the command I am using: "C:\\Program Files\\CoreFTP\\Coreftp.exe" -s ftp://TESTUSER:TEST_PASS44@pvftp.ftpsite.ca -u 'C:\\Users\\User1\\Desktop\\testupload.txt' -log C:\\Users\\User1\\Desktop\\temp.logThis works fine in command prompt but I can't run the same code using systemCaller. I keep getting an error that says that the file is not found. What am I doing wrong here? Any help will be appreciated. Thanks!Edit: I did a few tests and found out that if I take the single or double quotes off the name of the upload file, it works in SystemCaller. But that fails for file paths that have spaces in them. Trying to put % instead of spaces (I found that as a suggestion) does not resolve the issue. Any thoughts? Thanks
I am trying to extract the KML tags for the KML below (structure) using the XQueryxtractor transformer declare default element namespace "http://www.w3.org/1999/xhtml"; for $x in /html/body/table/tr/tdreturn fme:set-attribute($x/td[1]/text(),$x/td[2]/text()) the result is coming out empty. Any suggestions ?kml_description (encoded: UTF-16LE): <html xmlns:fo="http://www.w3.org/1999/XSL/Format"> <body> <table border="0" width="370" cellpadding="0" cellspacing="0"> <tr bgcolor="ffffff"> <th width="370" align="left"></th> <th width="370" align="left"></th> </tr> <tr> <td bgcolor="#ffffff">Manhole ID</td> <td>50283792</td> </tr> <tr> <td bgcolor="#ffffff">Life Cycle</td> <td>In-Service</td> </tr> <tr> <td bgcolor=
I'm using FME Workbench 2017.1.I have a reader connection with multiple features (tables) being read from it. One of the features (let's call it Users for example) uses a SELECT STATEMENT option to get additional information (I can run and test the select, it's valid and it works). Right before FME uses that select statement to "obtain features for feature type", I'll get a bunch of warning messages in the log output like this:WARN | Oracle Reader: Column 'ID' specified on Feature Type but does not exist in table 'SCHEMA_NAME.USERS' and will be ignoredThis will happen for all columns of Users. I can verify that the columns exist in my source table.Even with these warnings, the records of Users will be read and written to their new destination. However, every other feature type that needs to be read/written after Users (say Logins, Favourites, Friends, whatever) will give me the same warning message for each of their columns and will not write a
This is error message on the FME server.Microsoft SQL Server Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=gis02;Initial Catalog=nlpglive;Integrated Security=SSPI'. Provider error `(-2147467259) Cannot open database "nlpglive" requested by the login. The login failed.However, on the desktop I almost the same error when I try to list the tables in the above databaseServer 2012 Native Client...Microsoft SQL Server Non-Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=gis02\\sqlexpress;User ID=;Password=********'. Provider error `(-2147217843) Invalid authorization specification'However, when I test the connection it is OK and successfulIf I use a reader or writer I can see all the tables !Any ideas? I have tried SQL Authentication for various local and domain accounts still the same issue.
Since I installed the new version of fme (build 18284 WIN64), I can not get results anymore. missing value
Hi all,I have used Matcher to find duplicates. It works very well. I create "_match_id" attribute to create "small groups".The problem is there, I need now to sort into these "small groups" using an other attribute called "Hierarchy" (numeric attribute). The feature with bigger Hierarchy's attribute value into this small group (based on _match_id value) will have a red color, the other will have a blue color.So, I have to compare each value into this small group, keep the highest value and assign to this feature red color.I have to do this for every small groups.Any ideas ?Thanks
I have a network of sidewalk lines and multiple points of community centers. I want to select all those sidewalk lines that are within a certain distance along the network from all of the points. Select both entire lines and clip the lines at the specified distance.
Hey AllI have been googling this and trying to sort it out for a couple days now and cant seem to get it to work.I have a table with attributes for starting and ending Chainage (10+050 / 10+100). I want to map these as linear features on an alignment. The alignment is in as a measure and I'm trying to use the Snipper:Every feature is rejected by the Snipper. If I manually input the same attributes in the Snipper Starting and Ending Locations, it works fine for that one location.Also - it appears as though the Snipper keeps the attributes for the Measure, but not the ones from the input table, which would be needed.Any help would be great - is there a better way to map chainage/station for linear and point features along an alignment?Mike
Hello,please, I try to compress more conditions into XML Templater in Root template, but unfortunately desktop refuses to run up translation repeatedly, because he misses comma between conditions. But, as You can see below, comma is there?Log is below:Does anybody know please, how to correct the statement?Thank You so much!Lubo
The MongoDB Writer for fme currently does not support writing to the MongoDB array data type. I am trying to develop a workflow in fme that can write to a JSON array data type in MongoDB when the number of objects in a json array are not fixed, for example (see "alternateNames array"):{ "geonameId" : 3, "name" : Toronto, "alternateNames" : [ { "alternateName" : "Toronto", "isoLanguage" : "af" }, { "alternateName" : "Toronto", "isoLanguage" : "fa" } ]} in another record from the source, this "alternateNames" array might be contain more objects:{ "geonameId" : 1859924, "name" : Kashiwa, "alternateNames" : [ { "alternateName" : "Kashiwa", "isoLanguage" : "eng" }, { "alternateName" : "Ka?iva", "isoLanguage" : "eng" }, { "alternateName" : ??????, "isoLanguage" : "ar" } ]} If there is only one object in
I have various data source with various attributes. I want update all data's just like that no empty attibutes are writing. For example: Shapefile (name "blabla.shp) in directory should be read in, automatically remove all empty attributes (column) and writing a new shapefile (blabla_del.shp) in same directory.The Python Script in other posts not works. Example in zip.
I am pivoting a table based on an ID field so that all diagnosis codes are pivoted and grouped based on the ID. Here is an example of source and final tables I am trying to acheive. What transformers will be appropriate to get this done?
This is the template expression I'm using in XMLTemplater based on what I've learned from other questions/answers on this forum (like this one):The problem is that it throws error 'invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?) near line 14, column 18 of the query' and I don't know why.It works if I omit the <gmd:desc> block though.What am I doing wrong?
Hello thereI work with polylines in an ESRI Personal Geodatabase and want to shorten every polyline by distance using the Snipper. But for certain features there are more than one remnant. I guess, the reason is because features consist of Paths. Do I have to split Paths first and then use the Snipper for Lines and Arcs separately? Thank you for every hint.
We are trying to build a workbench which can work offline if it needs to, but can't find a way to supply it with the .xsd schema files at run-time.We already have the .xsd files (the data is from the Ordnance Survey, and they gave us the files) but haven't been able to find a good way to provide them to the workbench - It looks like the only way is to open the workbench file in a text editor and edit the XSD_DOC and SKIP_SCHEMA_LOCATION_IN_DATASET values.Is there a way to tell the workbench to (optionally) look in a specified location for the schema?
Hello,I am digitalizing an AutoCAD drawing and making polygons. Those polygons should have an area and I have succeeded in extracting these informations using AreaCalculator and LineCloser, AreaBuilder. After I extracted the area, I get some double cells. Some parcels have objects on them and I don't want to have their area in two cells. I am attaching a screenshot to show you all what is my problem. How can I keep only these rows that have both informations? There are some parcels where only one cell is filled because they don't have an object on them.I have tried with Matcher but it is not working with all the settings that I have tried.
I am interested in generalize a polygon following these criteria: max area (areaforcer), max number of vertex and max width allowed (for example a river with maximum width of 3 m and 200 vertex). How could I create this?
The Dashboard data is great for seeing patterns over a period of 30 days but if the period were extended it could provide other information too. For example, "how long has it been since a certain workspace has been used?" That would identify FME scripts that are no longer being used.It would be easy to build something that would store the daily data better than the current CSV files, for example, a SQLite database, and then build reports off of it. However, I'm wonder if Safe has something like this in the works already?
Hi,I created a red colored box with PDFStyler and PDFPageFormatter.Now I would like to center a text in front of this box.Any idea ? How FME computes text position ?
Hi,I am doing a analyse to find most low z-values in a buffer of 50 meter from a point. I started with this steps:- buffer points, - Clip raster file on buffer area's- Use RasterCellCoercer to extract point value's only in this buffered area for efficiency- PointonAreaoverlayer, use buffers and points to merge attributes.But now I get stuck, these buffers have an overlap with each other. So some points only get the ID from one bufferid, not from both buffers with an intersect.(Arcgis 'Intersect' does it the way I like to see with all points tested on all intersecting buffers) Goal: I want to find the 10 lowest Z-values in each area(buffers from a point with main ID) Who can help me to achieve this goal?Thanks a lot!
Found no transformer or question on the Knowledge center so here is my simple question: Is there a possibility to realize something like a SolidOnSolidOverlayer that does an intersection of incoming solids and just outputs the intersecting parts of the solids? Just tried to do that with the CSGBuilder but I think this transformer just outputs the solid features which are completely within another solid.Also visualized my expected result in 2D (the red solid is the intersected solid I wanto to get):
I'm using the FTTPCaller to get a list of files from a sftp site. The attribute that gets returned has an inconsistent timestamp. Is there a way to return the full timestamp like Mar 09 2018 17:35:00 In the _file_contents attribute there is a list of files but the time stamps are not consistent eg. Mar 02 17:36 that has time but no year and Jan 26 2018 which has year but not time.-rwxr-xrwx 1 ftpadmin ftpadmin 74240 Mar 02 17:36 9192815.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 65024 Mar 02 17:35 9192816.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 294400 Jan 26 2018 9192817.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 311296 Jan 15 2018 9192818.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 359936 Dec 18 2017 9192819.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 54272 Sep 18 2017 9192820.dgnThe parameters in the caller
