Transformers

https://knowledge.safe.com/questions/56497/show-metadata-on-autocadcivil-blocks.html

The cityGML results keep all data except geometry data, then this error alert. What's the matter?Have you ever meet this problem?

I'm doing this via PostGres table, but attached is a small example of some of my data in excel. Also attached are my transformers. I'm trying this via AttributeManager using an expression. Not sure if my syntax is just wrong or if my approach needs work also. Question: When I encounter a null value I want to use the value from the previous row. I want to accomplish this for all rows until I hit a new value. Then when I hit that new value I want to use that new value in the null rows underneath it. I want to do this until the end of file. I have several thousand records like this. Reference the well_location column to see what I'm describing. Thanks for any help!

Hello, Below is a Concatenation of Schema from two shape file that have similar schema now put together. I send it in as SCHEMA{}.schema to the writer. Since this is basically a csv and the Writer see it in Dynamic mode i would think it would set the schema, but does not. any suggestions please?  AREA_MI fme_decimal(15,3),CENT_LAT fme_decimal(9,6),CENT_LONG fme_decimal(11,6),CFCC fme_varchar(3),COUNTY1 fme_varchar(100),COUNTY2 fme_varchar(100),COUNTY3 fme_varchar(100),CTY1FIPS fme_varchar(3),CTY2FIPS fme_varchar(3),CTY3FIPS fme_varchar(3),CTY_FIPS fme_int32,ENC_ZIP fme_varchar(5),ID fme_decimal(15,0),NAME fme_varchar(130),NAME1 fme_varchar(100),NAME2 fme_varchar(100),NAME3 fme_varchar(100),NAME4 fme_varchar(100),NAME5 fme_varchar(100),NAMETYPE fme_varchar(30),NAME_TYPE1 fme_varchar(30),NAME_TYPE2 fme_varchar(30),NAME_TYPE3 fme_varchar(30),NAME_TYPE4 fme_varchar(30),NAME_TYPE5 fme_varchar(30),PO_NAME fme_varchar(100),PT_LOC fme_varchar(1),RPO_FLAG fme_varchar(1),STATE fme_varchar(2)

Hi,  I am trying to create drivetime isochrones from multiple nodes with a routable road network. What I am trying to achieve is a visualisation that looks something like this.  This was created with Qgis + python - Source (http://planet.qgis.org/planet/tag/drive%20time%20isochrones/)   I have managed to work out the drive time isochrone from one node using this example using the network cost calculator (Thanks to the Calculating the emergency response travel time example (https://knowledge.safe.com/articles/Samples_and_Demos/Calculating-emergency-response-travel-times))     However I am not sure sure how to progress from here as the network cost calculator does not work with multiple source input.   I would appreciate if anyone can shed any light on this problem.  Regards,  Matt 

(not sure how to cast that _year attribute to an integer)Hi,I need to only filter records from a date field that are in the current financial year.e.g. if month(current_date) => Julystart_date = 1st July getYear()end_date = 30 June getYear(+1)elsestart_date = 1st July getYear() -1end_date = 30 June getYear()

Folks,I have a CAD output from a Mapinfo source. One of the challenges I'm facing is overlapping labels and blocks.Some blocks are symbols representing co-located features.My goal is to try and detect the duplicate label\\block placement points and perform some kind of offset to separate the objects.In most(all) cases I'm using the CenterPointReplacer or LabelPointReplacer to determine the label\\block insertion point.In some cases an ideal placement methode would be to detect the duplication and then alter the placement with a polar offset.For example 4 co-located symbols would be placed as 0, 90,180,270 1m radius.Are there any suggestions how I might be able to firstly detect the duplicates and work on the "duplicate sets" to calculate new polar coordinates?

I'm moving a workspace to a new PC and I have about 40 DWGStylers inserting blocks. Is there a quick way to update the source dwg for the block inserts? I'm hoping not to have to right click on each one and browse a new location for the DWG.

Hello,I am exporting data from SDE to PDF and would like url's associated with each grid to open a file.I have created the path for each url within an attribute creator and associated it with the PDFSTYLER.Here is the "corrupt" url when you click it in the PDF:Here is the Tooltip showing the proper data for URL (same is used for the URL):Here is the details within the PDF of the URL box showing it carried over correct:If you change it opening weblink or opening a file etc etc doesnt change the way it adds all those random symbols in the link when you actually link it.I will also attach the actual workbench.This is the version of FME I am using:Edition: FME Desktop Smallworld Edition (floating) Version: FME(R) 2016.1.0.1 (20160516 - Build 16494 - WIN32) Here is the workbench:Id appreciate ANY help with this.Thank you! Savas

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.