Transformers

I'm wondering what is planned for the first webcast on November 1st, 2017. Any details would be appreciated?

I was talking to a FME Server friend and they asked about how others are dealing with log monitoring, management and analysis for FME Server. They mentioned tools like Splunk, Solarwinds, Liberato. What tools are people using? What processes are in place? What gotchas are there? Best practices? Tips and Tricks? What are the main reasons for undertaking log monitoring, management and analysis?

Please, I’m having some challenge creating a user parameter (usable in the FME Quick translator) that allows the user to specify an ‘attribute’ to participate in a query that selects a list of settlements planned for visit on a particular day of a campaign so that only settlements with a Y (yes) value for e.g. day_1 (selected by the user) participate in the analysis for that day.Sample table:What I already did:Created a user parameter called ‘Day_of_Campaign’ (type: choice) where I have preloaded options day_1, day_2, day_3 etc. representing the attributes (tried using type: attribute name but this doesn’t allow you a drop down of the choices using the ‘FME Quick translator’ (I want less interaction with the actual workspace - need this run from the quick translator so the users don't mistakenly alter the workspace/transformations) ‘Set workbench to prompt…’ so that this parameter prompts the user for an input (e.g. day_1, day_2 etc) using the FME Quick Translator. But before then

HelloI have a lot of points with coordinates x,y in latitude,longitude.These points are grouped in records. Each record is identified with an unique identifier. Call it "Id". Each record can have multiple points In a record each point must be joined to the next one following it by 2 means :1- a straight line 2 - an arc of circleWhen the arc of circle is used, we need to have the center point coordinates and the radius. An attribute is used for that with the coordinates of the 2 points which have to be joined to form the arc. The end point has to be joined with the first one by a straight line. I have to draw this geometry for each record and i don't know the way of doing this. 1 - polygones 2 - polygones with arc of circles.Any help would be great

Hello.This might be a strange question since it does not take into account the Earth. Also, I am quite new to this topic but I did research. I found a lot of things but I never got the result I wanted from various calculators and doing it manually is hard since I am not that familliar with this math.I was wondering, is there some way to calculate XYZ -> degrees for other bodies with different radius?For example, this is one of solved:Planet Radius: 2094km, Earth Masses: 0.0541, X: -1786579.7, Y: 519690.56, Z: -959322.31This equals: Latitude: 9.2921 and Longitude: -153.9814. I figured that Y and Z are Lat\\Long.I have no idea how to get this result. Ive tried various calculators like: https://beta.ngs.noaa.gov/gtkweb/ but I just cannot get the correct numbers.If anyone can offer any insight into this issue I would be very grateful. Thank you. 

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?