Transformers

I have points with attributes and a line. I have used the point on line overlayer to break the line at each point. however there is not a point at the beginning. I assume that is why the attribute of the point is attached to the line the point is at the end of. I need to attach that attribute to the next segment of line. in other words the begin point of the broken piece would give it's attribute to the following segment. I can think of a long way around by creating a crc with the points coords, then by getting the begin point of the broken segment and creating a crc with it but if there were any round issues it would not find it's match. Any other more elegant method anyone has used?If i simply add a point to the beginning of the line will that offset them all to the beginning?

I need to merge geometries from different records - can this be done using the aggregator?i need to merge /add together67_GF_BORDER and 67_BORDER_CR geometries65_GF_BORDER and 66_BORDER_CR geometriesand40_QD_BORDER and 40_BORDER_QB geometries  thanks!

  could someone help me ,how could i isolate paths perfectly to from common node ,each line starts from this known node till end of the line ,so how could i solate although lines overlapped overlapped and has a common node .thanks in advance at the end i need to seperate each path with the own network id from the point any idea , i will be thankfuli tried the whole day to do it ,but i did not success , i hope some one can help me Thanks in advance 

Hi,I have a workspace which finds the shortest path using the shortespath finder transformer.For some reason this particular network it is not able to find path. I have network created from topology and it has end node and don't see any problem with the network and I have checked it many times but not able to understand why it is not picking up the route.It will be very helpful If you guys can spot the issue.Thanks for you help and time.ZubairSM

Hello all, I have a polyline layer within which each feature is made up of just two segments, and of course just three node points.I'm looking for a method to discover all polyline features that do not deviate beyond a set angle (let's say 20 degrees for arguments sake). In the image below, polyline A would pass this test, but the other two examples would fail. Can anyone provide some guidance? Thanks in advance,RB 

Hello everybody,   My problem : I have a "Description" attribute which contains text with length variable. The lenght is greater than 2000 characters. For each feature of the "Description" attribute, I want to replace all spaces after every 80 characters with "LF" (new line).   So I thank use StringReplacer to write a regular expression to calculate 80 characters intervals and identify the space after each 80 characters. Then I could have replace this by LF.  I helped myself with these topics on the forum: - https://knowledge.safe.com/questions/51531/how-do-i-find-the-first-space-after-the-19th-chara.html  - https://knowledge.safe.com/questions/51514/splitting-attributes-by-number-of-words.html  - https://knowledge.safe.com/questions/40715/count-the-number-of-characters-and-numbers-in-a-gi.html   But I d'ont success it. Maybe I don't really understand explanations....   Do you have any leads ?   Thank you so much !      

Hello,I'm trying to read an OCRd pdf_text attribute and get the text between 2 lines.My regexp is (?=Detail : Verbruik vaste telefonie ).*(?=Detail : Verbruik mobiele telefonie )but my result is strangeIt does not end on "Detail : Verbruik Mobiele telefonie". Is there an error in the RegExp?

I have used String Searcher to find data with the name BORDERHowever,I am struggling finding the right transformer which will combine the two records into 1 : this is based on number.ie - combine40_BORDER_QB40_QD_BORDERthen rename the record afterwardsto : ie - 40_QD_QB this will also have to be done for 65_GF_CR and 67_GF_CR   then merging with Provider data.

Hi,I have different councils Pipe material list with a specific example of say Copper – which different council has a different way to define it.. say for example one council called it “CU”, other council calls it “COP” and some other councils call it with some other name…however, the material is the same…and in general we want to define a common name for it..... say "Copper"? Can we create a data dictionary in FME?...which can identify and recognize the correct name and replace it with a generic name?  

Hey there,Building on the question in this link: https://knowledge.safe.com/questions/70747/finding-the-largest-value-through-multiple-attribu.htmlI want to find the attribute that the max value in the function @max(Value(A), Value(B), Value(C) belonged to. See image below for example:Is there any function in FME that could help me with this? As the title implies, I thought something like @argmax(...) would exist, but I have not found what I am looking for.Thanks in advance

Hi, I have two inputs to a raster mosaicker and would like them to retain the full extends of the combination of the two inputs yet is doesnt seem to: I basically want to have a nice -180,-90,180,90 geotiff. any gaps from the bottom raster input needs to be filled with no data (coming from the top input). Any idea why the RasterMosaicker isnt doing this.Thank you very much for your help in advance.Oliver 

Hi,I have birth days in this format YYYY-MM-DD.I want to calculate their ages.Per exemple, someone born 1950-03-28 would be 70 years old.Not sure how to do that. Any idea?Thanks

Hello Just need some guidance:  I'm currently using SystemCaller + AttributeFilter (0 & 1 for error logging) as a workspace to run a batch file daily which does the following:- Delete existing log files- Create WinScp log file- After setting some variables then log in to SFTP server using WinSCP commands- Upload a file, check its existence on remote server and if exist then upload the respective ".Done" empty file from local server. Exit with Code 0. If failure then abort and always exit with Code 1.- Catch error in case of failure and output it to error.txt (it will tell me which file failed)- Script repeats the same process for the remaining 4 datasets.E-mailer attached to attribute filter 1That's working. I want to:Option 1Use automation to achieve the same result albeit SFTP "External Action" fails to validate the connection and states "Invalid - Path not found". For now I've given up on trying to understand so will skip that option.Opt

hi sirgood daykindly could you confirm if you have software to transfer scanned drawing from JPG to DWG; so i can re modify the drawing. if yes, can you tell me the price of licencing.

Hi, I am trying to read point geometry from a Microsoft SQL Server database and the geometry is displaying in the 'Geometry' attribute like the following example: 'C0FFD20FBC8CCF11ABDE08003601B769D9CEF75331C9F0405EBA490C1EABE44015AE47E17A746140'.I would like this geometry to display in the inspector but am having trouble working out how to do this.I have tried using the 'GeometryExtractor' transformer, first setting the 'Geometry Encoding' to 'FME Binary'. But this results in '3160A883220000000000' being output for every single record in the _geometry attribute and no geometry in the inspector.When I tried setting 'Geometry Encoding' to 'Microsoft SQL Server Binary' I got 'FFFFFFFF' for very record in the _geometry attribute and again no geometry in the inspector.Does anyone know what else I could try? It's my first time reading from Microsoft SQL Server in this way..Thanks!

Hi! I hope you can help with this very basic problem of mine..(although too much to handle for me). So, what I want to do is load data into a sde database. It´s annotations, in coverage format. And what I have seen so far of the result when I only use a simple ”in-data to out-data”-workspace in FME is that the texts don´t end up in a correct way. There are overlaps for example. Then I thought that the only way to do it correctly is with the ”Import Coverage”-tool in ArcGIS. So I created a simple Model Builder model which I then exported to a python script. Below is a screen shot of the model and further down is the script. Script from model export:# Import arcpy moduleimport arcpy # Local variables:tx_24_annotation_tx_24 = "D:\\\\Vagkarta\\\\Shape\\\\vk_24_Sweref_99_TM_shape\\\\vagk\\\\24\\\\tx_24\\\\annotation.tx_24"tx_25_annotation_tx_25 = "D:\\\\Vagkarta\\\\Shape\\\\vk_25_Sweref_99_TM_shape\\\\vagk\\\\25\\\\tx_25\\\\annotation.tx_25"sde_gsd_GNG_vk_tx_anno_modelb

Hello!I have two tables:Table 1:NameBasevalueaaa0bbb0bbb5bbb11ccc0 Table 2:NameValuebbb3bbb8bbb10ccc8 Now I want to get for each feature from table 2 the nearest smaller 'Basevalue' from table 1 compared to the 'Value' of table 2.The Result should look like this:NameValueResultValuebbb30bbb85bbb105ccc80 Any ideas how to do so?GreetingsStefan

Hi, I have a csv file with some coordinates in the following form: Cordinaten gps longitude ; Cordinaten gps latitude 4.438.469 ; 5.186.713 How can I convert this to EPSG:28992? I've already tried the Reprojector, AttribureReprojector and CsmapAttributeReprojector but that didn't help. Thank you in advance.  Greetings, Hans

The shapefile writer (2015 vintage) used to have an option of character encoding - ANSIWhat did this actually mean, iso-8859-1?

Does FME recognise different epochs for WGS84?

Hi, I want to convert ESRI annotation (ESRI geodatabase ArcSDE) to line. (I don't mind if I get the underline insted of the centerline)I've try the EsriAnnotationRenderer transformer and even if the annotation have underline, it only return the text. I've also try the GeometryCoercer transformer but it doesn't work with text.is there a way to do this ? Thanks   

Hi,I would like to break a line into segments and then assign a sequential order attribute starting at the start of the line.For example, in my screenshot, if I break the line into 500m segments, I would like section 1 to go from the start point to 500m, section 2 to go from 500m to 1000m, and so on to the end of the line.I've tried using the iterative snipper and the chopper to break the line but the problem is that they both output the line segments in a random order.Would anyone know how I might do this?Thanks. 

I have a FME project reading information from an API and writing to an excel file. In the project i have a tester that tests if the data belongs to a certain organization. The organization list might expand, so I want the tester read this data from a (excel) file. How can I do this? Can I loop the project from the tester and write to different files?Thank you for any views on this.

 First datasetI created about 1 million lines between 1565 points. These points are locations and the lines are possible routes over a network between the locations. Many of these lines (=routes) overlap each other. This is my first dataset.Second datasetMy second dataset consist also of lines. Part of these lines have an attribute value for attribute 'VWH' = 1. The other lines have a value of 0, VWH = 0.AnalysisWhat I want to do now is to perform an intersection between the first and second dataset. For the second dataset the features are used where VWH = 1. Using the VWH =1 features I want to intersect dataset 1 and attach the VWH value to overlapping lines. See the figure below for the main idea.First I dissolved dataset 2, for VWH =1, into one multipart feature using the LineCombiner followed by the Aggregator. The length of this multipart line feature is 7684 km.Then I used a SpatialFilter to check which features of dataset 1 intersect the multipart feature.Then I tried di

I have a block of text separated by newline characters, e.g:Some TextSome More TextEven More TextPERIOD: 01/01/1990 TO 12/12/2020What I'm attempting to do using regex is grab the entire line of text preceding the row beginning with PERIOD (i.e. "Even More Text"). In an online regex editor, the following expression successfully returns just the line containing "Even More Text":^.*$(?=\\nPERIOD)However, when I attempt to do the same in FME, it returns all lines above PERIOD. It seems as though in online editors the . includes all characters except newlines, whereas in FME it includes them? Is there a way to adjust multiline regex flags (or some other workaround) in FME to get the desired output?