Transformers

I am interested in zoom meeting if that is possible

I have a "mapinfo" table that I'm trying to load into a oracle DB with SDO_Geometry. My license doesn't let me create a writer in FME as an Oracle Spatial table. So my workaround is to add the tables as "oracle non-spatial" tables. This works fine for address points but when I run the following SQL;This updates successfully. The issues is when I check in "Data Inspector" if its saved correctly (for this particular record which is a multipolygon). I get only one of the polygon objects returning;

Hi guys, I am trying to create " cross lines" between 2 points. I just got the lines in black that u can see in the capture. But I wan to get the red lines. Can u help out please? 

Hi,I have a block which contains (Autocad)attributes, in Autocad you can edit them by double clicking on it.I would like to insert this block in a dwg and fill in some values. When I put this block in a template and insert it with the dwgstyler than it becomes a default block, whithout the 'doubleclick' functionality.How can I insert a block with (Autocad)attributes and fill in the values? Thanks!

Hello everybody, I hope everybody is doing well! But for the question, I'm currently looking at creating 3d polylines from a rail. I have used the offsetcurvegenerator for getting an offset and then use the neigbourhoodfinder to rebuild my polyline. Now the problem is I need to get the the exact same vertices on the offset polyline as these from the original, as these are the points where the rail was measured. And I don't get this with the offsetcurvegenerator. I have seen the use of the buffer transformator but also this isn't giving me the correct results. Can somebody guide me into solving this problem. Many thanks and keep safe,Andreas

 I have a set of areas. And all neighbours should be connected with a line. If I have 10 areas they should be connected with 9 lines to connect them all. I have tried to explain in detail with the attached pdf and in annotations in my workspace. I have a solution but its not the best solution and could probably be edited to something better. For small amount of data it works. But for large its a heavy process.  The end result should look something like the images below Alla areas are connected    Alla areas are connected  And there are 1 less line then

I have a dataset with 3D buildings like this:The dataset is a gdb-file (geode-multipatch) with aggregate geometries.I need to extract the roof height for each part of the building (meaning one building gets multiple height values for each part – e.g. the second building from left in the front row in the screenshot should have a different value for its tower). The height should then be a attribute for the below mentioned polygon.And I also need to extract the footprint as polygon shape for these building parts. How could I achieve this?

I am using an XMLTemplater to output XML. In FME 2011, the XML comes out with literal less-then, greater-than tags, that is:     <StreetTree TreeID="2919"> However, in FME 2015, the XML comes out with character entity references, that is:    <StreetTree TreeID="2919">  The XML reader in FME 2015 does not understand the character entity references. Is there a way to tell FME to output the literal less-than / greater-than characters?  Thanks 

Hello,I am trying to build queries using inlineQuerier query but an error pops up, I am not sure if my input dataset is right. I have a screen capture attached. Could anyone please help me. I am absolutely a new FME learner.

My little firm use FME 2019 on workstation Intel i7 (6th generation, 8 core, 16 thread with 16 go Ram). We want to renew our computer fleet and we want to install FME on a stronger machine.What kind of configuration would be the most effective to run FME : a strongest CPU with more Core, more RAM (32 or 64 GO), both of them or another element ?We use FME to transform big raster in shapefile, perform calculation with big database...Thanks by advance for your help.

Hi,In a point cloud I have those values for RGB.@Component(color_red)@Component(color_green)@Component(color_blue)How do I convert this to a hex number or an FME_color atribute?The goal is to filter the point cloud by color, for example removing all greenery from grass.Have no inpute other than the point cloud.

Hi all,Does anyone know more about the Offsetcurvegenerator transformer? I've offset a 3D polyline using this transformer setting it to the Miter option using a large miter limit (shown below). I would have expected this to give me the same number of vertices in the offset line but it appears to have added new, somewhat random points to the offset line. Shown below in the blue highlight. Can anyone shed some light on why this is happening and how I can get around it?

I try to update FeatureClasses in an Esri FileGeoDB. I use FeatureWriter with fme_db_operation=update and dynamic schema setting. FeatureClasses have NOT NULL attribute constraints.Problem: How do I control which attributes are updated ?I have the impression, that I cannot update only some attributes without specifying all attributes of the FeatureClass/Table. If I do not supply an attribute it will be set to NULL. Is that really so ? Is there a way to leave attributes unchanged, while others are updated ?That's what I am used to from SQL ...ThanksMichael

Desired functionality scenario: criteria stating the minimal Requestor overlap percentage the Supplier needs to have. (e.g., Supplier overlaps at least 80% of Requestor, or else the record is <Rejected>). I believe that adding this property to the SpatialRelator would add a lot of value and save a lot of complexity and time.But for now, I would like to know in as much of a step-by-step fashion as possible, how to achieve this functionality, which I believe could be accomplished more elegantly with a SpatialRelator upgrade.Feel free to chime in if you also support this functionality.

i have 5 pathes of lines and they intersected in one point and each path has 4 connected lines and each lines has his own id .when i use network topology uilder by id ,i find it considers all lines in all paths as connected has the same value of network id  i want to work on each 5 paths but as not connected in one point ,how could i do that .i mean ,as first path that has 4 connected lines and each lines in this path connected till the point that intersected with another pathsi want to consider 4 lines in each path as conneced but not connects with another pathi do not want to consider every path that includes lines as connected to other paths .i want to make each path as seperated ,how could i do that.Thanks  

Hi, I am performing generalisation on multiple polygons. All of these polygons have a shared boundary. I am only interested in preserving certain boundaries. For example I would like to preserve boundaries that fall along an existing boundary such as a field boundary, but if there is a polygon boundary in the middle of this field, I don't want it preserved, I want it generalised. Is this possible in FME?  Note: I have access to a separate vector layer with all boundaries i.e. Field boundaries, buildings, water etc. Hope this makes sense and thanks for any help.  Kind regardsB

I have the following table. labelareacodecountA100114A10023A10032A10188A10291B100164B10022B10041B101268B102121C100137C10024C10042C101493C10217 I want to pivot the table. So I get the following result. RijlabelsABC1018826849310291121171001146437100232410032  1004 12 I tried the AttributePivoter (and also the AttributeTransposer) but I can't get this to work. I don't understand what I am doing wrong. Hope someone can help me with this issue!Thanks! 

I'm trying to update a large file with many attributes. The original file's attribute names followed a specific nomenclature with 4 alphanumeric chars, then an 'X', then followed by 3 digits. An example:ZA01X001The new file now has the 'X' stipped out, so the new example is:ZA01001My problem is that my workflow uses an AttributeManager to rename about 80 different attribute names from a separate lookup table that corresponds the attribute coded name to a variable name like so:ZA01001 = Total Population with Medicaid CoverageSo this new file is throwing off my AttributeManager with the 'X' now gone. My question is, how can I use the BulkAttributeRenamer or other method to easily insert an 'X' into the 4th position of all attribute names?

I have the following table:Borehole_IDFinal_Depth243446575523452.5 I need to generate incremental Start/End (start from 0) ranges table based on unique values in Borehole_ID and the end values from Final_Depth. Something similar to table as below..Borehole_IDFinal_Depth_RoundDownFinal_Depth_RoundUp243401243412243423243434657501657512657523657534657545234501234512234523 @takashi

I created a PointOnAreaOverlayer workflow that creates a grid of x-y points and a circle area. When I run the PointOnOverlayer I get the expected results plus one additional point outside the area. Why does the workflow return the additional point that is outside the area? --I can seem to attach files. I will do so after posting

Hello Team, I have workbench with python start script, It was working fine with python compatibility Python27 in desktop 2015. Now I have upgraded with desktop 2019 and python compatibility changed to Python3.7 which is throwing syntax error and it could not able to initialize the arcobjects. Could somebody help me to get out of this issue. Thank...

Lets say I have a polyline that covers a road, and on that road there are multiple stoppage points represented by another layer (point layer), how can I segment that 1 polyline to autocut to the closest point in its vicinity? (the points are not always overlayed exactly ontop of the polyline). Here is an example So for this 1 polyline I am trying to get 11 pollines where it would break at each dot.

HiI have a workbench looking at a json feed: https://niord.dma.dk/rest/public/v1/messages?lang=dk&domain=niord-nmThe feed contains attachments for some of the features, with a column specifying a link to the location of the attachment (PNG file typically):I would like to populate a field with this url, so that I can sent it to correxponding features in a SDE database. i tried to use AttributeExposer and AttributeCreator to extract the link to a new coloumn, but this seems impossible as the coloumns with the attachment information is not available in the list of attributes to expose/create (should be between areas and charts):

Hi,I've just updated to the new FME version (2019.1) and I am experimenting some stranger issues with the Sorter Transformer as you can show on the image bellow:  However, If I start the process with a SQLCreator transformer or put an AttributeKeeper before Sorter, I won't get any issue.I've never got this error on previous FME versions. Any ideas? Thanks in advance. Regards. 

I use FeatureHolder to control the dataflow between FeatureWriters in order avoid blocking situations because the FeatureWriters write to the same database. So far so good.Confusion started when the FeatureHolder seemed to let features pass unexpectedly.Turns out the reason for this were disabled connections upstream during various trials in testing phase.EDIT March 26: the italic writing was the original text but is NOT correct.Solution to get predictable behaviour was to disable transformers instead of connections.Conclusion: A disabled transformer upstream of a FeatureHolder will cause the FeatureHolder to stop everything, which is what I expected.A disabled connection upstream of a FeatureHolder (no matter how far away) will cause the FeatureHolder to let everything through, which leads to uncontrollable behaviour from the testers point of view.Any objections to these findings ? Is this intended behaviour, or is it a bug ?E