Transformers

I have a point cloud in ascii format with columns for x, y, z and classification.I want to extract the values of x and y in two new attributes (as a list) which I can use for further processing. How can I achieve this?

i have chopped up a set of lines into signal circuits which seems to be working great. Each signal circuit has two signals that define the begin and end of a circuit(with an associated attribute that should identify which circuit it belongs to). The issue I'm having is that there are two points in exactly the same location, one that has a corresponding attribute with the previous signal circuit and one that corresponds with the following signal circuit. I need to match an attribute of the circuit to the points so that i can bring some attributes from the point into the correct signal circuit.

An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147210926'. The error message from ArcObjects is: {Closed polylines not allowed with network features [class name = wLateralLine, object id = 3688]}I am having this error all the time. I checked the geometry and realized that there are some arcs.Then I used GeometryCoercer but it didnt fix the problem.

Hello,I am merging multiple rasters into a single mosaic utilizing the RasterMosaicker. My objective is to find the maximum value across all rasters for each cell and then assign the matching reader for that highest-value cell. I'm having no problem obtaining the max value, however, I'm running into issues when trying to associate that cell with it's proper reader.I've tried exposing the fme_basename and creating an attribute, but when the mosaic is created, each cell is given the attribute of the first raster (rather than the raster that the highest value is coming from)Any help would be much appreciated.Thanks.

Hi,I am getting this error message when running FME script with RCaller transformer:"RCaller(InlineQueryFactory): InlineQueryFactory failed with exit code 1 when executing R script. Output was: Error in library("sqldf") : there is no package called 'sqldf'Execution haltedInlineQueryFactory failed to execute scripted code.RCaller(InlineQueryFactory): A fatal error has occurred. Check the logfile above for details"I have the following settings in FME Options:R Interpreter Path: C:\\Program Files\\R\\R-3.2.2\\bin\\x64\\Rscript.exeShared FME Folders: H:\\My Documents\\R\\win-library\\3.2\\sqldfPlease advise whatever I'm missing here.Thanks,Wilfredo

Hi, BackgroundFME 2017.1I'm cutting impervious cover data at parcels and i'm getting an error on write. Error: The number of points is less than required for feature. Two causes are listed on ESRI's website - A polyline feature with two vertices that are both located at the same location- A polygon feature with less than three vertices.I took a closer look at the features i'm writing and counted the vertices using NumCoords() FME Feature Function - all had 3 or more verticesI also took a look at the vertex coordinates for each feature and found that they had duplicate coordinates. This seems to be the problem. Question 1Is there a good way to remove duplicate vertices?  I tried Geometry validator with the Duplicate Consecutive Points checked, but the write still failed with the same error. I've also tried Geometry Refiner with no luck.   Question 2Running the polygons through the Snapper transformer is working, but i'd like to do my best to change the data as li

Seeking to convert a large 3D AutoCAD (dwg) project into ESRI Shapefiles (points, lines, and polygons). Converting dwg to individual shp was accomplished using FME and the shapefiles are 3D so now I need to read .shp, tranform the x, y coordinates, keep the z coordinate intact, and output as a new .shp into the Greek Greed (GGRS87). However, my shapefiles have no spatial reference because the original is an older Greek system based off HATT projection and Bessel Elipsoid 1841. This system developed by the Greek military divides the country into 109 zones/mapsheets. I am using mapsheet 257 ????? ????????? and want to convert all my points, lines, and polygons from this older system to the more modern GGRS87. Outside of FME I have a formula to convert x,y but it strips out z-values. Therefore, I am asking is it possible in FME define this older spatial reference, apply a xy coordinate translation, preserve the z values, and write out in GGRS87 (which FME supports)?

Hi,I'll try to explain my problem easy as possible :)So I have table where is lots of rows but only two different attributes.. I would like to combine rows together by their attributes. For example:Start looks smthing like this. ID1ID2100101101102102103500501501502200102And I would like to combine attributes after eachother as long as there is attribute to combine with..ID1ID2ID3ID4100101102103500501502200102103For now I manage to make attributes after eachother till there is no more, but problem comes with duplicate attributes what I would like to avoid.ID1ID2ID3ID4100101102103101102103102103500501502501502200102103It seems so simple task to get rid of, but can't get my head on it what im missing.

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