Transformers

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

Hey guys, I did not use FME for 2 days. (Nothing has been changed) I cannot open anything about FME right now. I tried to open FME licensing assistant, inspector, even help. Then I tried to repair it by using the setup file. It is not responding. In Task Manager, I checked the CPU usage for FME, it is always "0". I did reboot my computer twice, still same. What should I do? (Both win64 and 32 are not working)

Hi, Currently having issues with a Microsoft SQL Server source table writing to an Oracle12c destination. The package appears to run smoothly without errors, however when checking the destination every field is null. It has the correct number of rows at any rate, but absolutely no data. Bit more in depth...I have an Oracle Data source that writes to my Oracle destination DB correctly, so I believe the writer is configured correctly. I have tried removing the Oracle destination and simply having the MS data source write to a CSV, which also works. When I try to use the CSV as a data source and copy it to Oracle, I once again receive all nulls. Was wondering if anyone has seen this before and if they have a working solution. I'm aware Oracle likes Uppercase and Microsoft seems to enjoy lower case and I'm investigating that route now. Any help much appreciated.Thanks

We need to retrieve OData from a JBoss-based webserver. The webserver only supports Forms Based Authentication. The authentication in JBoss is set to SPNEGO. Basic authentication does not work. How can we authenticate from FME through OData reader to get data ?

hello everybody,i have a stream of features which i would like to filter by an attribute value. i used the attributefilter for it and it works if i preset it to the attribute values i want to filter by. it doesnt totally work though if i create a user-parameter instead of a preset value. it doesnt show me an output for the user-parameter. I attached some screenshots of my problem.Is it essentially possible to do that or should i try another approach?thanks,andi

i am using attributejsonpacker to pack some attributes and getting the packed attributes in writer but if i am using attribute keeper for some other attributes then i am not able to write packed attributes.How can i add "_packed" attribute in attribute keeper also?

I have made a .tiff from a .shp using the NumericRasterizer and the .tiff works nice in arcmap but when I try to open it in Autodesk I get "Type: unsupported", does anyone recognise the problem?

Hi,Not understanding why StringReplacer in attached is not working?Regards,Richard

I am actually trying to split a big shapefile into several kml files according to an attribute variable. I would like one kml file per value of that variable, which makes about 600 kml files. Is it possible to do that with FME?

How can I give objects a color based on attribute value in an HTML-page generated with the HTML report generator. So I want an object to be 'red' when value is '1' and to be 'yellow' when the value is '2'.I tried using the FeatureColorSetter, but this does not seem to work. There is an ArcGIS Feature Layer available. I can add this to the Map (ESRI Leafet) option. However the colors are not visible in the map, because they are 'overlayed' by the layer color set in the HTML Report GeneratorIs there a way to not set the layer color; this option is obliged. I do not know how to avoid this.

trim the cs line based on hs lines i attached screens for reference thanks in advance.in screen before means my output and after means i need that output