Transformers

Hi guys,I have two feature classes here one is points and another is polygon. The rule i want to apply is to only let them join by attribute when the point intersects with polygons.Both feature classes are land ownership data hence both of them would have features with same geometry but different attribute (lot number, unit number and etcs)I am thinking to use database joiner to join the table but does anyone knows how i can apply the rule to only let intersected feataures to be joined?Thanks!

Is there any transformer equivalent to COUNTIF or COUNTIFS excel functions in FME.I have a very large csv file that is not openable in excel that i need to perform a count on certain attributes that have numerical values. e.g Count the total number of values between 1-10 etcI am currently using expressionevaluator transformer where it sets an attribute to 1 if condition is met otherwise 0. then i use statistics calculator to sum up the total.wondering if there is any quick and simple way to do that.I have two attributes that i need to check with 5 different conditions

Hello, I am having difficulty finding something similar to this in the Knowledge Center so I thought I would ask. I have an attribute whose value looks like this (it is a full line from a badly formatted text file). Ticket No: 4653 Nearest Intersection: Chinton Street Seq No: 34 I need them split to an attribute list and subsequent value listEg:Attribute_1 = Ticket NoValue_1 = 4653Attribute_2: Nearest IntersectionValue_2: Chinton StreetAttribute_3: Seq NoValue_3: 34It doesn't have to be a "list" as long as I can separate those part of the texts. I am guessing there should be a RegEx way of doing this. The attribute names "Ticket No", "Nearest Intersection" and "Seq No" will always remain the same with their values changing. I am trying to build a script to always separate them. Any suggestions? Thank you!Addition: For the first one, if there was a way to extract between 'Ticket No:' and 'Nearest' that would be fine. I can work

I am converting data from SQL spatial to FGDB. After I run the translation, it failed because of geometry. The data is polygon. I used geometryFilter for troobleshooting to see the different types. There are 6 features which have Collection type. How can I convert them to polygon?

Hello, I have two Postgis databases that contain several schemas. Each schema of a database also contains many tables. How I can do to create a workspace that allows you to copy all the tables of a schema from one database to another. The schema name containing the tables to be copied must be a published parameter. The user must just enter the schema name in order to copy its tables into the other database. I work with the FME 2017 version but what bothers me is that every time I have to list the schema and choose the feature types to read to use. To summarize I want to do a dump and restore tables of a schema database Postgis. Thank you for your help.

I have an Oracle table with rows organized in groups, each group with an unique attribute name, WELL_NAME, and sorted by an attribute, DEPTH. I want to add an attribute called SURVEY_NO that auto generates a sequential number for each row within each group, starting with 1, then 2, .. and end with the last row in that sorted group. So it will look like:WELL_NAME DEPTH SURVEY_NOname1 10 1name1 20 2name1 30 3name2 10 1name2 20 2name3 30 3

Hello,I'm trying to run the equivalent of an excel 'index match' formula, trying to return the 'Category Code' from a secondary table, that looks like this:Table A:AreaLine RefYards FromYards ToCatagory CodeAAA1A00210002150019AAA1A00215002200088AAA1A00220002250035AAA1B00210002150045AAA1B00215002200087AAA1B00220002250057BBB1A00210002150064BBB1A00215002200013BBB1A00220002250001BBB1B00210002150098BBB1B00215002200020BBB1B00220002250030From table B I am trying to return the relevant category that matches the following record:AreaLine RefYards FromYards ToCategory CodeBBB1A002189921899Within the range above, I would want to return category code '13'.Having looked around on the forums, I think I need to use an 'InlineQuerier'; I wouldn't know how to produce the SQL for what I need though. Any help would be massively appreciated!

FME 2017.1.1.0I manually defined in the shape writer a field type of short, when the data is generated, In ArcMap, the field type shown as Long. Is this a bug?By the way, I define a type of number, width of 4,the fractional part width of 0?in ArcMap shows the field type is Short.It seems that FME 2016 has the same problem, but it seems still not being resolved.https://knowledge.safe.com/questions/32929/short-datatypes-understood-as-long-with-new-shapef.html

I am using the AttributeManager to rename the field NAME_BODY to NAME. At the same time, I'm using the Conditional Value to input a new Attribute Value for the field NAME. What I'm trying to say is... if NAME_SUFFIX_CODE is 'HWY' and my NAME_BODY is 'Trans-Canada', the output value should be 'Trans-Canada Hwy'. This is what it looks like....The Output Value that I've stated in the above image is definitely wrong and I'm having no luck researching the proper way to put this together (I can't even get @value(NAME_BODY) + ' Hwy' to work). What is the correct way of writing it so that I get the value of NAME_BODY with the string ' Hwy' at the end of it?The ElseIF statement that I have for the Parameter Condition Definition, as shown in the image below, is basically doing the same thing as the one above. I am discluding all the values that I already took care of in the If statement by saying NAME_SUFFIX_CODE cannot be 'HWY

Hi! My final objective is to select only magenta lines (see the picture).I have plan to build area from white and red lines and then, using line on area, select only magenta lines. Main problem of my idea is that i am unable to build area as i planed because white line is only touching red line (red line is not broken on intersection - i suppose this is why area builder is unable to form area). Any idea how to form area from white and red lines? Or suggestion how to select magenta lines on some different way? Thanks in advance.

Running a process (*.fmw) on windows scheduler. Getting the following error: "Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2012 Native Client... 2017-10-13 11:51:03| 2.7| 0.1|ERROR |Microsoft SQL Server Non-Spatial Reader: Failed to connect using SQL Server 2012 Native Client. Provider error '(-2147217843) Invalid authorization specification'. Connection string 'Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=;Initial Catalog=RPT;User ID=;Password=********' 2017-10-13 11:51:03| 2.7| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2008 Native Client... 2017-10-13 11:51:03| 2.7| 0.0|ERROR |Microsoft SQL Server Non-Spatial Reader: Failed to connect using SQL Server 2008 Native Client. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. Connection string 'Provider=SQLNCLI10;DataTypeCompatibility=80;Data Source=;Initial Catalog=RPT;User

I have a LAS file of vegetation (trees) and a DEM(terrainmodel). I want to create a raster file of the LAS file and use rastercalculator to get tree height above ground and zero values where trees a abscent.The result would be a raster with z height in cells(2m*2m) and null values where trees are abscent.The raster calculation would be: vegetation raster(z, above sea level) - dem terrain model = tree height (z, real tree height) in 2m*2m cellsI don´t want to make a DEM of the LAS file since DEM is a interpolation. I just want to make a rasterI can´t use the raster calculator since my raster from LAS(tree files) have null values.I have been using a lot of transformers without sucessWhy is that?

Where is the demo workspace mentioned in the FMEHub page for the UAVMissionPlanner Transformer?

Hello I need to place an icon in all intersections that occur. The data of the lines is spatial. Please any help is appreciated Thanx

Would it be possible to add an image to a table with the HTML Report Generator. I have an url with an image. When I add this to the table-option it show the url instead of the image. Which makes sense but that is not my goal.I tried using the custom html option but then only one row is used. I used the following code.     <table> <thead>         <tr>            <th>Name</th>            <th>Image</th>        </tr> </thead> </tbody>        <tr>            <td>@Value(Name)</td>            <td><img src="@Value(Image)" alt="" border=3 height=100 width=100></img></td>        </tr></tbody>    </table>

I want to extract the geometry and attributes from AutoCAD blocks in a .DWG file. This seems to be problematic as the information extracted by the Reader doesn't appear the information in the block.So, how can I get this information?

Dear Safe support,I'm working with General Electric on the Smallworld product in the Netherlands. One of our customers is getting the follwoing FME warning when using FME:WARN |Sector type not fully implemented : CPArc: 3085They wonder where this message originates. As I haven't been able to reproduce this I hope you could shed some light on this.Please let me know if you require further information on the version of FME as I don't have this available yet.Kind Regards,Marc BrutsaertCustomer Support Engineer GE Digital The Netherlands

I am wondering if someone can share your experience of pulling certain fme server logs into an elasticsearch database and using Kibana to monitor / analyse the activities in the logs.

Hi,I have 2 lines and I need draw some kind of mark between them when that lines are 100 meters or less close to each other Any help?

HelloI reopen a new question about a big problemI have an AIXM 4.5 file and i have to translate that file in the AIXM 5.1 schema. I have already made some good translations but i have a problem with the FME type XML_GeometryHere are some pictures to explain my problemI have first a sample file found on the web in the AIXM5.1 format. It concern the RunwayCentreLinePoint feature and it contains a XML structure beginning by "associatedDeclaredDistance":This structure "associatedDeclaredDistance" can be repeated in the same element "RunwayCentreLinePointTimeSlice" as many time you have an information about a characteristics associated with a runway, called a distance. This structure is defined in the AIXM 5.1 schema (FME) as a list containing a XML_Geometry structure (FME type):The third file .png shows how a feature looks like when you have the inspector:For the XML Structure "associatedDeclaredDistance" i see it's made with an aggregate of mul

Hello,I have a lot of rasters to clip with a single polygon shapefile. As always, I use the 'clipper' function in FME in a simple workspace. But I am unable to clip the data, FME gives me the following error message: MaskCombiner(RasterEvaluationFactory): Failed to parse the EXPRESSION_LIST clause. The provided value was 'if(B[0]==255,A[0],nan);if(B[0]==255,A[1],nan);if(B[0]==255,A[2],nan);if(B[0]==255,A[3],nan)'. Please ensure that your syntax is correctI am guessing that something is wrong with the nodata value in my tiff files? How do I fix this issue in FME?Thanks!

Hello,I'm looking the better way and automatic to do this.I have two Databases ( Oracle and Microsoft SQL Server Spatial ) and need to compare the datas between the two tables:The tables has 80 attributes in common ( with the same name ) and need to merger, i think to use the transformer FeatureMerger.My question is: Need i to select manually in FeatureMerger the attributes Requestor and Supplier to 80 attributes?*Example with just 3 attributes add manually  Thanks,Danilo

I have opended a text file and have an array to pass to SQLExecutor or SQLcreator. They only appear to work on tables not an input string. Keep getting error reading table - It is a list not a table!!I need to loop through the array and run a procedure against each value.I tried to open PLSQL+ using a .bat file, this throws an error SystemCaller_2: Executing `cd c:\\windows\\system32 && run "cmd.exe"'The syntax of the command is incorrect.SystemCaller_2: Failed to Execute `cd c:\\windows\\system32 && run "cmd.exe"'I aimed to open SQLPlus to read the array in order to run a procedure.The problems:I cannot get SQLExecutor or SQLcreator to read a string/list (???).Is it possible to pass the array to loop through and run the procedure??Any help appreciated.regards,Clive