Transformers

I need to know how to get the degrees from 2 nearby pointsAny help?

Hi, I'm doing something with Mesh model in OSGB format. But I found that only the geometry can be read by FME. The texture is missing. Did anyone tried something like this and had a solution of this?

We have a major issue. For no apparent reason FME Server 2016 is clearing out the jobs and logs of completed and failed jobs daily. We have not changed a single setting. When we look at the set times to hold onto these items it is still set at 7 days. Again, nothing was changed. The GIS Manager also reviewed this completely and he's come to the same conclusion, something all of the sudden is going wrong.Please note we have not upgraded or done anything out of the ordinary. When midnight rolls around tonight all of the notifications about completed jobs will once again be deleted by FME Server 2016 and a new day of notifications will begin again.Has anyone seen this or dealt with this issue?

I have irregular line segments that I need to create points along using station (M) values. The actual Shape Length of the line and the station values are not the same (i.e. shape length of 50 and end M value of 75). The line feature has the M values as a property, but not as an attribute. The beginning and end M values for the line segments are known.Is there a way to reassign line length (in memory) based on the known M values so that I can place (snip) points on interpolated values along the line?Thanks in advance,Freddy

I have to create an UUID and wanted to use the UUIDGenerator. My XSD File has defined the UUID as an ID which may not start with a number. The UUIDGenerator put a number at the front though and I see no way of modifying it. Why is this? and how should I best generator an ID otherwise?

Hello,I'm not sure whether this is possible or not. I've created an SQLCreator with the following SQL, the objective is to return all records from the table 'TableA' that do not join on 'equip_no' in 'TableC' because the attribute name 'SERIALNUMBER' is not available.SELECT m.EQUIP_NO,m.EQUIP_GRP_ID,EQUIP_CLASS,PLANT_NO,a.TABLE_DESC as "ROUTE",b.TABLE_DESC as "DELIVERY UNIT",c.TABLE_DESC as "ENGINEER",d.TABLE_DESC as "SECTION MANAGER"FROM TABLEA mLEFT JOIN TABLEB a on m.EQUIP_CLASSIFX2=a.TABLE_CODE and a.TABLE_TYPE='E1'LEFT JOIN TABLEB b on m.EQUIP_CLASSIFX11=b.TABLE_CODE and b.TABLE_TYPE='E10'LEFT JOIN TABLEB c on m.EQUIP_CLASSIFX13=c.TABLE_CODE and c.TABLE_TYPE='E12'LEFT JOIN TABLEB d on m.EQUIP_CLASSIFX16=d.TABLE_CODE and d.TABLE_TYPE='E15'LEFT JOIN TABLEC e ON m.equip_no=e.equip_no and e.ATTRIBUTE_NAME='SERIALNUMBER'where(e.equip_no is null and m.EQUIP_GRP_ID='AU190RTK0001' and m.DSTRCT_CODE='RTK1')or(e.equip_no is null and m.EQUIP_GRP_ID='AU190RTK0002' and m.DSTRCT_CODE='RTK1')The

Hi, We are reinstalling/upgrading to FME server 2017.1.1.1 (64-bit version) on our linux machine (Red hat 7). But there is permissions issue related to postgres. The installation is run with root priviledges and we have fmeserver user as part of root group. We have tried to change installation directory from opt/fmeserver -> data/fme_installation.snippet of the installation process (express option):Enter the port number for the Server where the Web Application Server will be installed. [80] : 8001 ...FME has been successfully installed to /data/fme_installation...Setting up Database...bash: /data/fme_installation/resources/logs/installation/initDB.log: Permission denied cp: failed to access ‘/data/fme_installation/Utilities/pgsql/data/postgresql.conf.tmp’: Permission deniedWe have checked that there is no other postgres installation running during the installation time. -JanFollow-up: We managed to successfully install the server. The issue was the permissions on the installation f

Hi everybody,I have a single orthophoto, and several 3D objects I created from a shapefile and the Extruder transformer. Both datasets share the same coordinates system (EPSG: 2154).I am trying to texture all features using this same raster and the true coordinates which already indicates where each pixel should go. With no particular settings, each object is render with one entire copy of the raster, which is not what I want. But I can't find the way to set the texture coordinates properly.Can you help me to find the right setting and/or the right transformers for my need?For the moment, I use the ApparenceSetter transformer with these settings:_xmin, _ymin, _xmax, _ymax being the bounds of each feature and XMIN, YMIN, XMAX, YMAX being the bound of the raster used for texturing. But this result with all featured rendered in black with stripes, so this setting is not right.Thanks a lot for your help!Jean

Hi!While using the XMLTemplater, I sometimes come across this error:""XMLTemplater_2(XMLTemplaterFactory): The following error occurred near line 4, column 25 of the query:XMLTemplater_2(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)""What does this mean? The XML has been pasted from XMLSpy whom have no issues with the XML. Some while ago I managed to see what was wrong myself. But instead of writing it down I thought "I will remember". I did not.Cheers!

Hi! I'm trying to create a conditional value for a StringReplacer but I don't get it to work. Basically I have an attribute that can contain substrings starting with a space followed by a slash (e.g. "keep / remove"). In such cases I want to remove everything after "keep" exept for one special case where I want to keep the whole string (e.g. "keep / keepalso"). I tried doing so by setting up conditional values for the "text to replace" parameter with this logic: IF attribute contains "/"  AND Attribute != "keep / keepalso"  Output = regex _/.*$,  ELSE Output = <empty>  In other words the StringReplacer should either replace the regex with an empty string (exept for "keep / keepalso") or do nothing.  It seems to work for replacing all " / remove" substrings but also overwrites all other instances with empty values.   Is it even possible to do what I want to do with one StringReplacer? Thank you

I have a list as structured below._list{0}.Name = Apple_list{0}.list1{0}.code.value=1_list{0}.Name = Banana_list{0}.list1{0}.code.value=2How do I search using a list searcher so that I want only the results for code.value=2?

Hi,I am using FME Desktop 2015.1.0.2.I am trying to split lines where they intersect each other. So far so easy.Now clouds to the silver lining. However, two classes of lines exist, which flagged as SOURCE or TARGET within an attribute. I want to ONLY apply the split where SOURCE and TARGET interact and NOT where SOURCE and SOURCE or TARGET and TARGET interact; sort of an inverse group by. I was trying to complete this within the transformer processing as opposed to mass processing, creating a mess and creating, tests anf ilters to clean out and repair mCan anybody suggest if there is a way via which I can do this via some clever logic or attribute manipulation?In some transformers you can set 'attribute/s which must differ', but looking at Intersector/TopoBuilder there is no option to do this. Also please note that there are Measures associtated with the line geometries and I want to retain these split/updated values during and after the processing, therefore I had been attemp

The issue I am seeing is geometry/spatial distortion between two different formats, .shp and .tab when converting from a spatial oracle table.I am currently using FME 2015.The spatial metadata for oracle has set bounds and the same spatial extent was set for min/max x/y for the .tab writer. Below, the distortion is quite evident.Red: .tab with no spatial bounds Green: .tab with same spatial bounds as oracle spatial metadata Blue: ShapefileI have tried to restrict the spatial extent to a smaller area in the .tab format but the distortion is still evident (see below). The distortion improved but it is not consistent.Black: .tab output with original spatial extent, same as oracle spatial metadata. Blue: .tab with spatial extent changed to another smaller area. Green: Shapefile output with original spatial extent, same as oracle spatial metadata Red: .tab with spatial extent changed to the smallest area possible.Is there a way to minimise or if possible, remove the distortion?

I am sure this is a really simple action, but I don't seem to be able to sort it out. I'm needing to filter off the top result out of a sorter in an attempt to make my workbench generic. I've run the data through a sorter, and the details I need are showing in line #1.  Cheers for any assistance provided.  

Useing FME desktop Can i read and write "HKEY_CURRENT_USER" data ?I need Created the key at run time and set the value according i will read the parameter values.

I am reading from one Excel file and writing to another.I have an attribute named "timestamp2" which contains datetime-formatted values from 6/15/17 00:00 to 8/1/18 23:45 (I do realize I'm looking into the future).  They are in 15 minute intervals.FME recognizes that  this attribute is datetime and sets the reader accordingly.  However, when writing, a number of the values (about 2,300 of them) between 06/15/17 01:00 and 07/09/2017 21:45 get written with the same value.Furthermore, when I view the data in the Inspector, the FME datevalue appears incorrect.  For example, a date of "06/15/2017 02:15" is being represented as 20170615021460 instead of 20170615021500.  FME appears to be taking one minute and replacing it with 60 seconds instead.I was trying to test this further to find the source of the error and I added a DateTimeConverter.  It yielded the following error:DateTimeConverter: '60' is out of range for 'seconds'. Range of 'seconds' is from '0' to '59.999999999'DateTimeConverte

Hello kind people,    I am beginner with FME. I am working with data which were combined based on the similarity of the records. However, this matching is not perfect and manual review has to be done. I want to automate the review and I have question concerning comparing two records.I would like to ask if there is any function which is able to compare two attributes for the same record e.gNAME 1: KROGER STORE 456  NAME 2: KROGER FUEL CENTERIt would pass the test, where one word from the NAME 1 (Kroger) is dectected and included into NAME 2. Or word from NAME 2 is detected into NAME 1.It should base on extracting every single word/number from NAME 1/NAME2 and comparing with every single word/number from NAME2/NAME1. I will be grateful for help.

Hi,I'm trying to use a workflow with dynamic output schemas, and uses fme_feature_type to fan out my datasets. Embedded in this workflow is a SpatialRelator.However, it seems like this transformer propagates the feature type of the "supplier" even though the attributes are set to "merge supplier" with "use requestor" in case of conflict. Apparently the feature type is not in conflict ??Is this a known problem, or is it WAD ?I'm using a workaround to save the "requestor" feature type into a separate attribute, but it would be nice if the transformer worked better.Cheers

Ok folks this might be an interesting one.I have data that is tagged with two character ID AA with all variations through to ZZ. That's 678 combinations. I need to act on each combination individually.Initially I thought of using a attribute filter and importing the 678 combinations which worked bu the down stream handling is a killer. Not to mention making the workspace bloated.I then thought of making a first character filter an then passing that to second character filter. However that the same problem in two dimensions.1 first character filter each passing to a second filter for the second character however the net result is the same number of individual output ports.Each letter represents a coodinate in essence in a 26 x 26 grid.The final goal is to get the X and Y coordinate pair. AA = 1,1 ZZ = 26,26.These X and Y coordinates would be used as Offseter parameters for object placement.Anybody got any clever ideas how I might handle this?Thanks folks.

I would like to use either xfMap or the XMLFragmenter on the attached complex xml file. I need the attributes as columns for each "area type". So for each area type the attributes would be: "area type", "description", "forecast-periods","flood status","warning prediction", "obs_site_description",etc.. This seems to be really difficult with the XMLFragmenter and I not proficient enough with xfMap either. If anyone has some example Workspaces I could use that would be great?

Hello,I'd like to be able to change, for example a -544.43 meter Z value to 544.43. The z values were generated by a bathymetric software package, so positive Z is down. I realize this is a simple multiply by -1, but I can't get it to work on a .LAS file using the "Offsetter" or coordinate tools. I suspect this should be an easy fix, so any help would be appreciated.

I'm having some trouble assembling a record set in the way I want to assemble it. I currently have features structured like the followingAttribute AAttribute BAttribute CGroupValue1KeyValueGroupValue1Key2ValueGroupValue1Key3ValueGroupValue2KeyValueGroupValue2Key2ValueGroupValue2Key3ValueWhere each row is a feature (except the first in this case, which are attribute names). What I would like is to create a new feature grouping on Attribute A, with Attribute B holding attribute names for this new feature and Attribute C holding the value of those attributes. I've looked into attribute pivoter and aggregator to accomplish this; but I can't seem to figure out how to pull this off. Any ideas on what I'm missing? In my data, I can guarantee the uniqueness of Attribute B across unique values of Attribute A.Maybe what I'm asking for isn't possible. I'm not sure.

I have two polygon files. One is the original file and the other is an update of the original containing edits. I would like to filter out the polygons that have been updated spatially from the polygons that are unchanged. I have tried using Spatial Filter with 'Test to Perform' set to Equals but it seems not to be able to identify the matching polygons. I have tested the original against itself and the equals filter worked perfectly. Tested against the updated file (where I can see there are many unchanged polygons) and it doesn't work.

I attempted to read a Civil 3D drawing to extract the pipe network, but I get this error:  AutoCAD Reader: Entity type of 'AeccDbSurfaceTin' not supported. Perhaps try a different Civil Schema Mode. Skipping entity Error running translation.  I did try the other Civil Schema Mode and got the same error.  Can FME 2014 SP3 read these pipe networks and write out to shape file?