Transformers

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?

Please explain what are the tools need to use & rectify this ?

I'm having an issue with unexpected results in the dissolverThe geometry is validated prior to dissolving but there's a reasonable likelihood of a duff input polygon possibly arc(the shape not the program) related. If i put polygon with count 13 only through an ArcStroker and then dissolve with the rest the output is as expected. But i've not found a way to highlight that this polygon is the problem. I've attached a template file if anyone wants to take a look, I'm still using 2018 so perhaps this doesn't occur in 2019...

Hello,I'm new in practicing FME and didn't find any answer to my question.I'm using FME version 2017.1 and I want to make a FULL JOIN between 2 tables resulting of the transformation of PostgreSQL (Postgis) database tables.FeatureJoiner transformer would be the one I need but only avalaible since version 2018. I heard about others transformers but joining only from common columns (inner join,....).Any idea ? Thank you !

Hi I have a workspace which does a bunch of queries and inserts and updates an SDE polygon feature class. The workspace is run every 2 minutes.I have written a shutdown script to rebuilt the indexes using arcpy.RebuildIndexes_managementThis command however takes over 2 minutes to run, hence I would like to only run it once a month, say one the first of the month between 12 and 12:30 am.Any suggestions ?

Hi, I am using TextEncoder transformer to transform string into URL coded text. String is UTF-8 and have some Balkan letters (?, ž, ?, š) and this is where problems start. For example word Kolašin TextEncoder translates into Kola%C3%85%C2%A1in but right way is Kola%C5%A1in. Is this some bug in TextEncoder or I am doing something wrong?  TextEncoder is set to encoding type URL(Percent encoding). Maybe TextEncoder is not what I need at all so any suggest would be appreciated.      

I have a workbench that creates a html-file with a table. In one field, there's a hyperlink. I write the file with a feature-writer and copy it to our webserver with a filecopy-writer.To make the link clickable, I also use a StringPairReplacer, replacing this: < < > >This works fine, as long as I run the workbench in FME-Desktop.When I put the workbench on FME-Server and run it, the line with the link in the html looks like this:<td><a href="https://www.xy.com">Text</a></td> instead of<td><a href="https://www.xy.com">Text</a></td> in the browser, the address of the hyperlink is:(value of filecopy_dest_filename)https://www.xy.com, so the user gets an error... How can I get FME-Server to write the link correctly? It would be great, if the same syntax would be valid for desktop and FME-Server...Thanks, Vera

Hi,I have some data in the following format:Job Raised Closed 1 20190715 20190825 2 20190611 20190825 3 20190614 20190825  I want to get a summary table, about for each month, how many jobs I had open. So for the above data it would be: Month Raised Closed Open June 2019 2 0 2 July 2019 1 0 3 August 2019 0 3 0  I can do the raised and closed, but am struggling with the open. I tried using a testfilter, with a lot of if statements, which works, but then I not sure how to export that into a format that i can use the data.  Help :)  

I would like to read a dwg layout and print it to dwf. Does somebody has an example how to fix that? :-)Thanks!

In Civil 3D I can add properties to objects by add Property sets. After that i can see this information in the Extended data tab. In the data inspector I can read those properties.I tried something with autocad_extended_data_list{}, but I can't read those properties from the dwg.Who can help me? :-)(How can I read the Pino.Pino-value "hallo hallo"?)