Transformers

Hi all, i am currently downloading a large json body via http caller and i need to split the returned json body into attributes. see below:the returned json body contains many results (one of which is shown in the below image) which i need to breakup into "clientrefid" with the related fields which then i need to get the ID attriubte returned so i can the use that in the next http caller.

HI everyone,I would like to remove last 3 numbers from a value. For example 010003000 to > 010003... or 123456789 > 123456 (not all values are ending with 0)so I do need some general formel for this.any tips?Thanks

Hallo Guys ,i have points inside polygon ,and i have coonverted points to squares by rectangleCreator then i have tried Text stroker but it rejected i think,because of square shapes ) then i tried to use CenterlabelAdder ,the problem it gives me text but it removes the same of square and i want to keep both of them the square shape and the text on it ,text depend on attributeso this label will refer to the point inside the square shape but i want to keep the shape as wellhow could i achieve that .Thanks alot

Hi, so deployment day is here and we found that ChangeDetector doesn't output through updated port.  Yay! (not really :-)) The workspace we're using is matching on one attribute and checking for changes in another, but even though there are changes ChangeDetector only outputs one insert and one delete - no update. FME 2019.0 (and 2019.2)Attaching workspace that doesnt output through updated-port, but only inserted and deleted. 

Hi,I have the following scenario:I extract a list of xlsx filenames from a database table and I want to perform a check on their schema (i.e. column names and data types). I feed the output of a database reader to a FeatureReader initiator so that for every input feature a different file is read.In the FeatureReader I only read the schema. I expected to obtain a different schema for each record of the database but in fact I only get a single schema.Is there something I am missing?

Hello everyone!Although I am new to FME, I have been working non-stop studying it for the past month and have reached a point where I cannot solve it.Some background to understand my problem.I design and build existing sewer network maps, and of course, sewer network planning as well.I pick up the map through the autocad, where alphanumeric check are done, as well as geometric check.The place I got stuck in is the geometric inspection.As we know, the sewer moves gravitationally, and in order for the map to be correct, first of all, the sewer lines must be connected snap to each other, for example:And not like this:These mistakes are due to lack of attention, etc., and in quality control I need to make sure they do

I have Parcel data and crop data (polygon geom). I am trying to calculate the crop type ratio for each parcel.My plan was:Clip the crop data based on parcelCalculate statistics based on crop type and group by ParcelIDI am not getting a sufficient result.Any help is appreciated. The workbench has been attached.

I have 2 GeoTIFF files (attached below) an RGB Ortho and a DSM of that image. I want to create a point cloud to render a 3D model in ArcGIS Pro but have no clue how to create the point cloud in FME, would appreciate a step by step instruction. Thanks in advance.

As part of a configuration validation process I need to check if the list of coordinate system options retrieved from an external list are defined in the instance of FME running the validation workbench. This validation process needs to work with both inbuilt and custom projections that have been defined. My configuration list is based on the FME name of the projection (i.e. for custom projections, matching the attribute COORDINATE_SYSTEM_DEF). Is there a way to read all currently defined coordinate systems to check if the items in the list exist?

I've tried to convert a dwg to an AR-model on world-coordinates.(based on post https://knowledge.safe.com/questions/105979/question-of-the-week-anchor-points-in-the-fme-ar-w.html )I get the AR-model, but the 'move the model to the geolocation message' won't popup in ios. So the model won't move to the right coordinates.Could someone have a look at my workspace please (if something is wrong)?I've made an translation between the RD-coordinates and the lati- and longitude coordinates. It would be great if someone could fix this! :-)Thanks!

HelloI want to create or add a unique key to a row after an transformer like a primary key in a database table just before updated my data. Did you know how to realize this operation ? thanks

I would like to have FME gather the comments from a .pdf including linework showing the area on the page the comment is referring to. FME doesn't seem to recognize the redline revision cloud. I was able to get at the comments by converting the .pdf to an .fdf and reading it into FME as textline, then regexing specific character combinations in the text attribute. Now I am after the graphics related to the comments... Has anyone had any success with this sort of thing?In .pdf... Revision request comments are tied to an area of interest shown by a red revision cloud... In FME universal viewer... cloud graphic from .pdf does not show. Any ideas and suggestions are appreciated. Thanks.

Hello, I'm having trouble to substract 2 values. The source attributes (ontwerp & rekenk, yellow) are encoded utf. I convert them to 2 new attributes such as "@real32(@Value(rekenk))". (blue) Then I want to substract those numeric real values in "TEST" but that results in a string? (red) Any ideas?

Has anyone experimented with writing a self-extracting zip file for a Server process? We ran into some limitations with zipping images and text files simultaneously, so were able to work around this with a command line script. Has anyone had any success with "self-extracting" files in the same way?

If I had the following string how would I remove a repeated word in this case the word Pensions. So I want to remove the first word that has Pensions but keep the second one.2006SourcesOfPersonalIncomeTotalResponses06OtherSuperOrAnnuitiesOtherThanNZSuperVeteransOrWarPensionsCURP15YrsAndOver2006SourcesOfPersonalIncomeTotalResponses06OtherSuperPensionsOrAnnuitiesOtherThanNZSuperVeteransOrWarPensionsCURP15YrsAndOver

As per title, Sorter does not work properly in FME2018 when fed from a FeatureJoiner that supplies Features downstream in Bulk Mode. It's similar to the bug that @takashi found when FeatureJoiner supplies Features to AttributeManager.Attached workspace to show how Sorter does not work when fed directly from FeatureJoiner, but does work if put in an AttributeKeeper to split the features out of Bulk Mode into "Normal" Mode.Workaround is to add a Transformer like AttributeKeeper (and sure there are other Transformers that may do it too).Question is, has this been resolved in latest FME or is this still an issue?

I am trying to get all of the Characters in a string that occur before the following " /" (thats a space followed by a /). Here is the catch there could be spaces and / before the occurance of the " /" and I want to keep those in the found string.I was trying to use the stringSearch and do this in one step (I was able to do this in 2 steps by first stringReplace the " /" with a character I knew would not appear and then doing a stringsearch but this should be doable in one step with the correct regEx expression)Here are examples123ABD / 99 - "123ABD" would be found123/ABD / 99 - "123/ABD" would be found123% ABD/99 / 789 - "123% ABD/99" would be found123 / 456 / 789 - "123" would be foundhopefully this makes it clearThxin advance to you RegEx wizards out there...

How to trace network from source to destiation .if i know source and destination then how to check or trace element beetween them .

I have spent hours re-engineering my data but couldn’t find a best resolve to automate data to provide statistics. Thinking, I could have saved myself a lot of trouble with a simple transformer with set logic using FME.    I have a range of attributes containing values such as "Class1, Class1a, Class3, Class4a". values are picked up from a drop down list by the surveyors, that sits in an attributed separated by comma (,).   I need to count the number of items in each attribute, assuming that they were separated by commas. So, the transformer would need to return the value 4 for my example above and for various other attributes using the same logic. I need to use the logic "If the cell is blank, value= 0, if the cell is not blank, but does not contain a comma, value=1, otherwise, value= (number of commas +1) i.e. read the string, if there are two commas in the string, then there must be three value

Hi, I'm using the Strava HTTPCaller that is posted on https://hub.safe.com/publishers/gerhardatsafe/web-connections/strava, I'm able to extract the polyline, but when it gets inputted into geometry replacer, I always get the error INVALID_PARAMETER_GEOMETRY_SOURCE. I can take the same polyline and input into the google polyline decoder https://developers.google.com/maps/documentation/utilities/polylineutility with no issues. Any ideas? Below is the encoded polylineir}gGdp`fNWfAaAbDObAY`DUfASh@]n@y@vAeA~AET@JNTtAzAfBxBhBlCjAfB~@pA~HvIxFnFJNBPANGN}CtEkBtCUX}EzHuNtT{DnGa@|@[j@wTd]yIxNwD~FgA~Au@x@GT@NJZ^f@dGtGpRfTpIhJ~^`b@bBdBp@z@bJdKTZR^p@h@pArAz@fA~KfMdJjKvJ|KlDzD|KdMfEdF~PpRdAnAt@v@l@x@`AbA|AlBPVJ\\\\H^@^Ch@CRQn@Yn@]d@YLWFu@Hm@LmARg@

I am using FME Server to move very large files into an Azure data store. The mechanism of this works fine but I would like to delete the files from FME servers temporary file store after the files are used to avoid filling up the memory of the server.I know that the temporary uploaded files end up in the following location but not how to delete them:FME_SHAREDRESOURCE_SYSTEM/filesys/temp/upload/Project1/AzureUpload.fmw/Username/*filename* Thanks!

I want to create a reference table within the workspace so I don't have to import another data source. I feel like I am missing something easy. I want to create a simple table ofRoleRateAdministrator£20Operative£30Manager£40Director£50 I can then join my data to it to get the rates.I would usually write the table in excel then read it in a featuremerger to match the rates in.I feel there must be a way to do this in FME rather than have to read the external data source. It must be more efficient. Thanks 

I have an ArcGIS Online Feature Layer with Fire Hydrant points, these hydrants have a unique ID from our asset management system. I am creating new points while carrying out inspection, using a mobile device, it creates a point within a few meters of the original hydrant. I want FME to grab this new point, move it over the original point, and insert the unique ID into a column of the new point. Is this simple to do? I have done some googling but nothing has jumped out at me. Thanks!

Hi, does anyone have any suggestions how to do this?I have a set of lines with measures and need to create points at each 1/10 measure value. A line with a measure range of 1 - 2.5 would result in points at measures 1.0,1.1,1.2,1.2....2.3,2.4,2.5The distance between the measure interval is NOT consistent, so length cannot be used.The functionality would be like the Chopper by measure interval.I'm using FME 2019.1. Thanks in advance!Kathy

Hello  I can't find a simple solution for the scenario below: if you look on the diagramm, I want to put my uuid value with fk_type=1 in the fk_parent_uuid field when fk_type=2 but I make a big package of spaghetti instead Would you have a brilliant idea ? thanks