Transformers

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? 

Hey everyone,I have an interesting dilemma, I hope can be solved. I have an interior building spaces that have polygons for rooms. In between each room polygon is a gap that represents the wall. My objective is to somehow push the polygon edges towards one another in order to eliminate the gaps. I have tried numerous ways, including Densifier + Anchored Snapping (which works somewhat, but the polygons look funky), Generalizer + Anchored Snapping (again room polygons look funky) . Below is a screen shot of what it looks like. Any assistance/thoughts would be greatly appreciated!

Hello, I apologize for my somewhat elementary question here, but I am a relatively new user to FME software. I was wondering if someone could explain to me the difference between some of the options for running a workbench. When you right click on the work bench, and choose Run > you got a few options, (run just contained, run from contained, and run to contained).However for some of the workbenches there is only one option available, and with searching online I cannot find any helpful/simple explanations to what each do, or the right one to choose in a given scenario. We are swapping CAD base drawings, and implementing them into a GIS Database. Any help appreciated - Thank you!

Hi, Another small but annoying problem is that when I put the visual preview on a different screen and I accidentally close it with the cross, I cannot retrieve it in any way, the checkmark remains under views, windows next to it. The only way to get it back is to save and close the workspace and then reopen it . De window then appears in miniature somewhere at the top.Are there still people having this? Nathalie 

I am using Anchored Snapper to improve network quality for huge amount of objects (1,1 million). End point snapping is performed on 1 cm snapping distance and Group By option is also used.My problem is that log file of this workbench has 4 million lines and is more than 600 MB big. Since I am using this workbench in a Jenkins job, I have constant issue with memory size when displaying full log in Jenkins Pipeline. 99,9% of the log entries are of no interest for snapping processDoes anybody have a tip how I can reduce number of log entries for this transformer?