Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,685 Posts
  • 50,749 Replies
12685 Posts
L
longhornfan
asked in Transformers
FME Server deleting jobs information daily

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?

170
jfisch25
Contributor
7 years ago
fneal
Contributor
fnealContributor
asked in Transformers
Assign line length, then snip points at interpolated values.

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

80
fneal
Contributor
7 years ago
R
robertdbuckley
asked in Transformers
How to modify the UUIDGenerator so that the ID starts with a letter

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?

3736
mark2atsafe
Safer
7 years ago
C
cjones28
asked in Transformers
Writing conditional values into SQL Creator

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

50
erik_jan
Contributor
7 years ago
J
janseppanen
asked in Transformers
FME Server reinstallation (Red Hat 7) fails with permission denied for postgres

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

50
J
7 years ago
K
kumarkannan1980
asked in Transformers
Hi, I need to convert the data from Oracle spatial to Microstation v8 using .net FME library (c#.net). I am facing problem while converting point features, it is coming as line feature (zero length) even though I set "igds_cell_name" and "cell librar

140
K
7 years ago
J
jportemer
asked in Transformers
Drape several object using real coordinates

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

50
J
7 years ago
L
larrybird
asked in Transformers
XML Templater Error

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!

478
chriswilson
Contributor
7 years ago
pflegpet
Contributor
pflegpetContributor
asked in Transformers
String Replacer with Conditional Value

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

1640
pflegpet
Contributor
7 years ago
V
vemanamanu99
asked in Transformers
How do I find values in a list searcher

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?

1470
david_r
Evangelist
7 years ago
R
rob14
asked in Transformers
Split Lines Only where attribute value is Different

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

100
takashi
Contributor
7 years ago
M
matkins
asked in Transformers
Geometry distortion ESRI vs. .tab

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?

50
L
7 years ago
G
gavin_082
asked in Transformers
Filtering Top Result

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.  

700
G
7 years ago
K
kumarc
asked in Transformers
FME Can deal with registry data ? ex : HKEY_CURRENT_USER key and values data

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.

60
brianatsafe
Safer
7 years ago
M
mikeszwaya
asked in Transformers
FME Date to Excel issue

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

420
takashi
Contributor
7 years ago
V
vid
asked in Transformers
Compare every single word from one attribute with the content of second attribute.

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.

270
gio
Contributor
7 years ago
lifalin2016
Contributor
lifalin2016Contributor
asked in Transformers
SpatialRelator propagates wrong feature type ?

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

40
lifalin2016
Contributor
7 years ago
A
andyew
asked in Transformers
Alphanumeric filtering AA,AB,BA etc best approach

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.

182
A
7 years ago
J
johnm
asked in Transformers
I would like to use either xfMap or the XMLFragmenter on the attached xml file.

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?

93
J
7 years ago
J
jimmy
asked in Transformers
Convert minus z values to positive (without changing the number)

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.

1600
takashi
Contributor
7 years ago
A
aarongundel
asked in Transformers
Key Value Row Groupings

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.

50
A
7 years ago
M
mikemidd
asked in Transformers
Spatial Filter - Equals test not picking up matching polygons

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.

74
M
7 years ago
F
firsttube
asked in Transformers
Civil 3D Reader for pipe networks

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?

280
A
7 years ago
nic_ran
Contributor
nic_ranContributor
asked in Transformers
Directory and File Pathnames reader problems

I'm trying to use the Directory and File Pathnames reader. FME 2013 sp3.  I have the Source Directory parameter set to a directory name, e.g. "C:\\temp"  I have the Path Filter set to "**/*.xlsx"  In theory, this should find all xlsx files in the current directory and recurse down through sub-directories.  2 issues:  1. if I follow the Reader documentation, I should be able to use "**\\*.xlsx" but it doesn't find any files, so I need to use a forward slash "/" instead of a backslash "\\". (I'm on a Windows system, so you'd think a backslash would be better.)  2. using the above path filter it successfully recurses into sub-directories and finds xlsx files but it does not find any files in the top level directory.  Anyone have any idea why it's behaving like this?  Using the same glob pattern (either forward- or back-slash, doesn't matter) with the Excel Reader works as expected and successfully picks up all xlsx

240
D
7 years ago
jorge_rosales
Contributor
jorge_rosalesContributor
asked in Transformers
StatisticsCalculator bug?

It seems that StatisticsCalculator doesn´t work well when I group features by numeric (only numbers: [0-9]+) field keys. I attach a sample.

60
danilo_fme
Evangelist
7 years ago

Badge winners

  • FME Form Basic Training
    sguru7667has earned the badge FME Form Basic Training
  • Welcome Back
    chditthas earned the badge Welcome Back
  • Student (Grey)
    vaspelinhas earned the badge Student (Grey)
  • Teacher (Grey)
    vaspelinhas earned the badge Teacher (Grey)
  • 12 Days Participant (2024)
    kateaewhas earned the badge 12 Days Participant (2024)
Show all badges
30,187
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.