Transformers

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

Do you think I can install the latest FME Desktop version on the latest OSx (High Sierra 10.13)?

Dear All,I have 6 Polygons in one shapefile with Name Block A to Block F.Also, I have one excel file for materials location like shown below screenshot.my aim needs to create a random point within the polygon as per the values mentioned in the table.For Example:121 Sand Random points for Block A polygon6182 Sand Random points for Block B polygon1 Cement Random points for Block A polygon210 Cement Random points for Block B polygonall points if possible one single shp file.Thanks in AdvanceVenu

Hi all,I am having issues with blending captured UAV orthomosaic (.jpg) into aerial imagery (.jpg as well). I used a few approaches including creating boundary polygon to use as a clipper as well as setting alpha band to exclude black edges to mosaic with aerial imagery. As a result I get merged images with white edges instead.I looked at couple of solutions that floating around knowledge center but did not get it working. If anyone can suggest a solution that would be great.Cheers,Maksym

I would like to use FME to select cadastre polygons that are listed in excel.I have excel with column that have land parcels number(s) and column with name of cadastral plan and some more additional data in another column.Land parcels excel cells sometimes have more than one land parcels and they are delimited with comma. After selecting one I would like to add additional attribute values to polygon and export it to new shape file. All land parcels are exported to one common shape file.

Hi folks,I got the attached error, very basic process, I'm joining a table loaded from a CSV with another CSV. It should be easy and my transformers are correct.https://imgur.com/P3jkoQM

Hi all,  A very simple question(!), is it possible to scale by a known point in FME, i.e. by an x and y coordindate.  In the Scaler, Scale Origin you can only select Cente Point or Origin.  I have tried it as a parameter, e.g. 15,15 but it doesn't appear to be scaling correctly.  Thanks.

Hello,I am trying to capture features that fail the geometry validator, and the information about why. The specific bit of information i ma after is the supplementary_info.details trait/element from the issues listIt is probably very simply, but i cant figure out how.I have tried a listexploder but this part of the list does not come through, and the same with a listConcancenator.CheersJacky

MorningI am trying to calculate the difference between coordinates of 2 stations. I've attached an image to assist in explaining. If you reference the image I've attached, you will see that lines 1 & 3 are the same station, and 2 & 4 are the same station also. Eastings and Northings provided on lines 3 & 4 are the accurate coordinates. Is it possible to calculate the difference and have it outputted?I need to use this data to make an adjustment to some spatial data based off this calculation, well, to start.

I am attempting to update an xml attribute (geodb_metadata_file) for multiple features. Some features have more xml content than others. I need to figure out which nodes are missing and will add content and which nodes are there and need to update content. There are about 7 nodes that I am testing but could be more so I need a generic way to test. a "for each" loop through a list of nodes to test and pathing the result into either update or add is my pseudo solution, but I don't know how to do that in a workspace except to have multiple testers which feels wrong. Please help!

I have a excel sheet that includes a column of road numbers and a column of chainages (eg road distances) I have another spatial database called Road Segments which are lines. They contain attributes of AssetId, Road numbers and an attribute of 'StartChainage' and one of 'EndChainage' What I want to achieve is to be able to identify what Road Segment AssetId the chainage from my excel sheet falls on.

C:\\Program Files\\FME\\plugins/SPATIALBIZ.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this DLL

Hi, I'm relatively new to FME and I was wondering if there was a common workbench for converting line features into polygon. Think of a dataset with the usual problems like this:-None merged line features, which result in polygons like in the image on the right (compair red line on the left to yellow polygon on the right)- None intersecting lines which result in no polygons at all- self intersecting lines which result in "small" polygons- Or identical line features which result in identical polygonsetc. etc.Without knowing specifically which kind of errors one is to expect in their dataset, how can you clean it, in order for FME to transform the lines into polygons.I've