Transformers

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

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?