Transformers

Hello,I'm trying to figure out if I can do this in FME:I have to produce an axonometric 2D vector drawing (SVG) from a Revit file (3D room geometry), something like this:We do this for PowerBi dashboards, so people can filter data using the actual rooms, it helps them to undestand the building a bit better...At this moment I have to rely on Rhino and their "make2D" command: http://docs.mcneel.com/rhino/5/help/en-us/commands/make2d.htm It works, but too much work...So, I'm wondering, is there a chance to automate this using FME?

Hi, I’m processing CAD-files in a script and my mission is to repair them to some limit. In one section I’m using the AnchoredSnapper to snap one type of lines to another type of line. Using the AnchoredSnapper bc I need the first set of lines to not move. Worked fine with the first file I ran, but the second time I ran the script with another CAD file, which didn't contain the type I set as anchors, the AnchoredSnapper processed the lines as I was using the Snapper instead, ie snapping the candidates to eachother. My expectation was that every input would pass out through the untouched port since there were no anchors to snap to.Is there a reason for this? How can i solve it? Best Regards, Anna

Hello,I am trying to use AttributeValueMapper to Map values that contain a certain string as "Pending" to an existing field. I am not sure if this is the right approach or If I have to add another transformer, or if I am just using the wrong Wildcards. I have and AttributeRangeMapper that is working perfectly before it. I need to take those values and add a new category "PENDING" to the same field for the strings that contain "PPA", that's why I have those values as default. It is showing the default values but not any "Pending"  

Hi everyone,I'd like to create an arbitrary subset of features and can't find a suiteable way to do this. My features have a unique ID and I'd like to select a sample of n-features of it. How can I get n-individual random numbers to test these numbers against my ID and filter the features this way? Or how can I fetch n indices from a list that might be created from the features?Here is some sample data:

I use the below items* Use an attributeFileWriter* Use a dynamic string built up eg -----------------------------------2019-08-14 15:18->Roads in gdb:37574----------------------------------------------------------------------2019-08-14 15:18->Roads in gdb with duplicate removed:37572----------------------------------------------------------------------2019-08-14 15:18->Roads in SDE::37474----------------------------------------------------------------------2019-08-14 15:18->Roads in SDE with duplicate removed:37454-----------------------------------* I log into a txt file* After every ----------------------------------- I have a new line inserted Problem-* When I open the text file, why don't I see the line feeds as I inserted them Cofusion-* when I copy/paste the contend into a rich editor eg browser, Word I can see the line feeds

Hello,I am having trouble reading a dimension feature class (ArcFM Feature - Polygon) using the ArcSDE Geodb,. FME 2018.1 Build 18567 Win 32 provides an error ... both in Desktop and Inspector"Unable to convert row to 'DimensionFeature'A fatal error has occurred. Check the logfile above for detailsFailed to specify the feature index as constraints on the reader"The older reader (SDE30) reads fine, as does the other (ArcSDE Geodb) for all feature type except the 2 dimension classes.Can anyone suggest what I am doing wrong or it this a bug?CheersMatt

Hi everybody !!! I´m having a problem with a Feature Joiner in my project that is losing the fme_text_string value after the processing of 100 rows.To garantee that the problem was not with de data, I already tryed to use diferent sort critereas in my data, but the problem always occurs after the flow process 100 rows, no matter what data is in the 101th row. To no submit all the project I simulate the problem in a smaller scenario for your avaliation. Thank´s a lot in advance.

Hi, I am having an issue with the CommonSegmentFinder transformer. I create polygons from the lines with the AreaBuilder. Then I try to identify the lines that where used to create some of the polygons with the CommonSegmentFinder. It mostly work, but a few lines are not identified. How is it possible when the lines were used to create the polygons in the first place?Thanks!  

Hi all,I would like to add a field to my vector data assigning a sequential ID to duplicate values. However I would like to ignore unique values leaving them with a COUNT of 0.This table can hopefully explain what I would like to achieve better than me attempting to write it!VALUECOUNT103051525354607172 I started off with a Statistics Calculator grouping by my VALUE using the Total Count Attribute and the Cumulative output port. This counts each unique value sequentially but it also assigns a COUNT of 1 to unique values.Is there another way of finding duplicates apart from the Duplicate Filter first? The Duplicate Filter doesn't appear to filter the truly unique values from duplicates. As in a the first VALUE of 7 and 5 would go through the unique port then the further 7 and 5 values would pass through the duplicate port.I hope this makes sense to someone! FME version 2019.1.0.0

Hi, I have a set of data, with dates ranging from 2005 to 2019. I use the interval feature in the Date Time Calculator, and am able to calculate the interval between the two dates (14 years). In another table, I have a number of jobs grouped, and I want to use the 14 years calculation to determine the number of jobs per year. (silly example given below) Fruit Total Fruit Fruit per year (ie, total / 14) Apples 20 1.43  Bananas 30 2.14  Cherries 40 2.85   So I want to get the "Total Fruit" and divide it by my _results_interval. But it wont work. I try to use Attribute Manager, and then bring in the _results_interval, but it displays it as a new row. And wont let me bring it into the arithmetic calculator either. 

I am having issues where some polygons are not being written to my PostGIS schema when running a workspace.Attached are two screenshots, one from directly before the PostGIS feature writer and one of the same features being read back in from PostGIS. I've checked the geometries are valid, are not too complex and have also written it out to a FGDB where all polygons are written fine. Has anyone experienced this or have any potential solutions/suggestions?      

Hi,I would like to fill those Property Sets / Extended Data fields and write it to dwg.I can fill the values, but I can't write it to dwg including those fields.Who can help me? :-) Thanks! 

Hi all,I have just been clipping some datasets in FME and I have noticed that it has left some sliver bridges connecting polygons. Is there a way to remove them?I tried using a snapper with various tolerances and using the sliver remover.Attached is a polygon with one of the bridgesThanksFME 2019.1.0.0 

Every time I need to run my transalation I have to open the SQL transformer make an edit (i.e. put in a space , delete it ) to get the transformer to run successfully. It is only the first transformer in the workspace that this occurs on the other sql transformers run as expectedThis is the same whether I use SqlCreator or SqlExecutor.  Could it be the Sql statement I am using begins with Declare statement?

Hi , I am getting this error message from my SQl Executor in FME. The Sql runs fine in MS studio Manager(-2147467259) Unknown token received from SQL Server' I am using a StringConcatenator for the script which passes the result to SQLExecutor

I have a scenario where I can only make 100 http requests per hour. If I cross 100 requests I get http error 403. Is there way I can pause the workspace from running or any better way to implement a solution for this. 

I'd like to get the points and create the polygons and have the attributes from the CGXML file.

Hi all,So I do have a solution which I'm including in this post, but I just don't think it's elegant enough. It seems to me that it can/should be done with less transformers. Python can probably help solve this, but I just don't have the chops, at least as of now :) And I still would like to do it all with transformers if possible.The problem I'm trying to solve is as follows: I have string data (multi-line text) that sometimes starts with a dash character used as a bullet. I need to have these dashes replaced by sequential numbers, mostly because an import into a database system fails with dashes. Here's a before:and after:The StringReplacer trasformer comes very close (see the top part of ""). The nice thing about this transformer is that it allows the user to pick multiple attributes, which is a requirement for me as there are multiple attributes I need to fix for each feature. However the Replacement Text setting is limiting in my case (cannot do s

I seem not able to enter a newline at the end of a string whilst using attributefilwriter in append mode. I use a attributecreator, i can even pick the newline symbol, but still everything is one long string without newlines. (2013 sp2) Windows preview shows it correct but when i open it its not.  Is it even possible the way im using the filewriter? ( entering \\ln or LN does not work either)   ...aaah if i write it to .csv rather then .txt it works...   tx for reading... ;) 

I would like to join features from two data sources based on a datetime attribute. However I would like to apply a tolerance as the rounding varies ever so slightly in the two datasets. So for example a feature in one dataset has a datetime of 20140922150020.782, while in the other dataset it is 20140922150020.783. These are essentially one and the same, however there is no "tolerance" setting in FeatureMerger for something like this: it is a very "black & white" transformer :) Are there any other workarounds or techniques for this sort of problem? I could truncate the above to 2 decimal places, but that is a bit risky for this application. A tolerance of +/-0.001 for example would do the trick. Thanks.

I have a maximum number in an attribute (attached) from this I would like to generate the minimum number, in the attached "ExampleMin" is what I want to achieve, how can I automatically generate this in FME? I have tried using the AttributeRangeMapper transformer, however this requires manual entry of the range. 

As I am using a union query I need to convert text fields to nvarchr (Max) The statement works well in Studio manager but in FME the attributes are <missing> despite using AttributeExposer.Without union clause the text fields display as expected using AttributeExposer so i feel certain it is the cast as Nvarchar(max) that is causing the problem. How do I resolve this ?

Hi, I have a linenetwork that consists, of numerous connected and none- connected linesegments. I want to connect all the lines that belong to the same network, and then split them again on locations where they intersect with points from a different dataset.It's the first part, connecting/combining the lines that belong to the same network, where there are problems. I still get individual/not connected linesegments where I would have expected just one whole connected line. This is what (part of) the workbench looks like. I've also implemented the steps given in this post, https://knowledge.safe.com/questions/57491/joining-of-two-lines-where-more-than-two-intersect-1.htmlhowever no luck. I did with both a max modulo count of 2 and 1.

HI, I would like to eliminate several fetures comming into process, based on another table.  the reference tale is big, so tester is not an option. Thanks in advance for any ideas. LP, Miha

I have a complex polygon like the on in the image below (it depicts roads). I would like to split it up in simpler shapes, so that each road is a separate polygon. Then I could calculate the center line of each polygon in a meaningful way.How could I split this up?