Transformers

Is it possible to do a substring(0,10) with the BulkAttributeRenamer? I want to simulate truncating the columns as writing to shape does. I know I can do this with a SchemaMapper, this is my current workaround.

Hi, I can't find an explanation in the doc about what this error means so that I can avoid it. I'm using a Clipper with Clipper Type 'clippers first' for performance. I'm grouping by row and column tiler output columns which are unique although I do have multipart polygons.

Hi all,I have a check-in text data file with long/lat information, ,example as below:[user] [check-in time] [latitude] [longitude] [location id] 196514 2010-07-24T13:45:06Z 53.3648119 -2.2723465833 145064How can I convert it into point features? I tried several times but unsuccessfulThe data file looks like this:0 2010-10-19T23:55:27Z 30.2359091167 -97.7951395833 22847 0 2010-10-18T22:17:43Z 30.2691029532 -97.7493953705 420315 0 2010-10-17T23:42:03Z 30.2557309927 -97.7633857727 316637 0 2010-10-17T19:26:05Z 30.2634181234 -97.7575966669 16516 0 2010-10-16T18:50:42Z 30.2742918584 -97.7405226231 5535878 0 2010-10-12T23:58:03Z 30.261599404 -97.7585805953 15372 0 2010-10-12T22:02:11Z 30.2679095833 -97.7493124167 21714 0 2010-10-12T19:44:40Z 30.2691029532 -97.7493953705 420315 0 2010-10-12T15:57:20Z 30.2811204101 -97.7452111244 153505 0 2010-10-12T15:19:03Z 30.2691029532 -97.7493953705 420315 0 2010-10-12T00:21:28Z 40.6438845363 -

Is it automatic classification methods in FME transformer?

I am comparing two feature classes in separate GIS sdes. I made a copy of one and put it in the other sde. So they were exactly the same to start. I changed the SYNGERGEN_ID value in one field in one record to test the update detector using . I expected that the one record would be passed through the update port. However, it is going out of the inserted and deleted port instead. Thank you in advance for your responses.

As a proof of concept, I want to use FME to find lines not connected to, touching or near any other lines. The nearness would be user defined e.g. keep lines within 10 metres of another line. I can't find an existing answer so I'm posting my solutions. I was inspired by @redgeographics answer to:https://knowledge.safe.com/questions/42455/lines-connected.htmlThe first solutions has 2 options for pre-processing. Either buffer the input lines by the amount required to take care of undershoots. This will obviously create polygons. Or use the LineExtender to do a similar job. The difference with the LineExtender is the direction of the extensions at each end (see documentation).Then send the pre-processing result to both the Requestor AND Supplier ports of the SpatialRelator. Choose the Intersects and Touches tests (regardless of whether you're using buffered or extended lines). Select ObjectID (or other primary key) as the attribute that must differ. Results with _rel

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.