Transformers

When copy/pasting SQL code into the SQLCreator SQL statement editor (2018.1) specific characters are replaced by others, e.g. '}' becomes '%7D'. This doesn't happen using the 2017.0 version.How can I make it work in the 2018.1 version?

Hi All, I'm trying to select parallel lines from a shapefile using FuzzyParallelLineFinder. The output gives line_ID of the fuzzy parallel line for each feature with a given STDV value. What I need is how to select the features that are expected to be parallel from this output.Any ideas?

Hi there,I want to create two columns: One column generates the dates between two given dates and second column contains the half an hourly time stamp of each date. For example:Column AColumn B1/1/202000:001/1/202000:301/1/202001:001/1/202001:301/1/202002:00............................................1/1/202023:302/1/202000:00 So that means each date of column A would have 48 values (half an hour slot) of column B. Could you some one tell me how to do that in FME?

Just wanted to know on JSONFragmenter between 2017 (17259) Vs 2019.2 (19817): What i have noticed is, JSON fragmenter never returned anything when the fragmented value was 'null' in 2017, while i have just noticed that for the same JSON text input, JSON fragmenter on 2019.2 is sending the attribute with 'null' value that we wanted to fragment through 'Rejected Port', is this intended on 2019.2? Any answer would be appreciative as we have lots of workbenches that we need to go through and fix it if that's the case?

I have a lot of shapefiles that I want to clip with different areas which I read from MSAcces and I want to select the area that I need for the certain shapfile and clip the shape-file. I use SQL Executor connected to a MS Access database to select the area that I want to use but I don't get the area. Do anyone have any solution?

I hope someone can help me further here.I have a simple json file. I'm using FME Quick translator to transform Json into access.mdb format. The translation goes fine, no errors come during the transformation. But data is missing from the result file. Any help will be received with great thanks! _____________________________________________________________________________________________1. The parameters _____________________________________________________________________________________________2. The process of translationFME API version of module 'MDB_ADO' matches current internal version (3.8 20190621)Microsoft Access Writer: Opening `C:\\Users\\SBP\\Desktop\\privat\\1085805.accdb' for write operationMicrosoft Access Writer: Read 2 DEF line(s). Found 36 attribute(s)Emptying factory pipelineMicrosoft Access Writer: Closing `C:\\Users\\SBP\\Desktop\\privat\\1085805.accdb' . Write operation complete __________________________________________________________________

i want to convert from date format 01.12.2000 to 2000 in one attribute  some times it is working great with my input excel files and some files show me this msg . The below feature caused the translation to be terminatedDateTimeConverter_2_<Rejected>(TeeFactory): DateTimeConverter_2_<Rejected> what is important for me to read the last 4 digit  Could someone provide me solution for this issue .Thanks for help

how to extract coordinate from the geo tagged photos 

Hello,I would like to round numbers to the nearest 0.05. Like this:-2.33 > -2.35-2.32 > -2.30Is this possible within the AttributeRounder? Or how can I get this result? Thanks in advance,Eva

Hello Team,Can we place workspaces directly into the repository directory instead of publishing to server? I tried doing this but workbenches were not reflecting in the server. Can somebody clarify whether the process i followed was correct? If yes then why newly placed workbeches are not reflecting in the server? Thanks in advance...

Hi, is there a more comprehensive way to get a summary of rasper properties akin to gdalinfo - stats from FME - I looked at RasterPropertyExtractor but it doesnt appear to cover things like compression, no data value etcMany thanks for your help in advance,Oliver

I am attempting to clip a .dwg file by a shapefile with 121 features and would like an output .dwg file for each of the 121 features. I am attempting to set up a fan out but am a bit rusty. I feel like there is something simple that I am missing.

Hi, I'm trying to practice with spatial thinking, and I have a set of lines that I want to merge to a single point in the middle (see attached). The way I want to these lines merge into the point, is to use the nearest point of the line to the point in the middle of all the lines, and making the lines longer than they were previously, not just snapping them and moving them.

HelloI try to recopy a block of data several times in a writer according to the value of a counter, for example an integer read in a file. What transformer or workflow can I use ? How to realize this operation in a simple way ?Thanks

Hi!  I've been converting point clouds to mesh recently with the PointCloudSurfaceBuilder. Now Im facing a dilemma that my resulting mesh consists of way to many triangles for me to work with later. I've been mixing the triangulation parametres up trying to get as smooth but then as big triangles as I can. I can reach a somewhat smooth result that defines, but the amount of triangles is absurd.My latest aproaches has been writing a mesh with "small" triangulation parameters and then trying to "fill" the gaps in between.  Do you guys have any suggestions on how to decrease the amount of the triangles? or piece together a situation like in the sparse mesh at the bottom? Many Thanks.Erdem 

I have an AutoCAD drawing in ground coordinates and need to get this into a usable projection to use in ArcGIS Pro. Is FME able to do this? I have the math that is typically used to do such a conversion (below), but I am not quite clear how to implement this in an FME workspace:  To Transform Ground to UTM CoordinatesExample: Point100 (Ground) 13262.582 m N, 4380.119 m E1. Shift back to the original scaled coordinate value:13262.582 m + 6,000,000 m = 6013262.582 m N 4380.119 m + 410,000m = 414380.119 m E2. Scale Point 100 from the Ground down to the Grid using the CSF:6013262.582 m * 0.9996899303 = 6011398.051 m 414380.119 m * 0.9996899303 = 414251.632 m Suggestions?Thank you.

Hello, I am using the bufferer tool to flow through as the filter to a Spatial filter transformer. The candidate layer is a point feature dataset.I am running into a problem when the buffered areas are overlapping (see screenshot) I need the point layer features to populate in each different buffered area. The output I am using is a fan out to CSV based on the ident of the created buffer and need the point layer to be included in each of the buffers.Currently the points are only appearing in one of the overlapping areas and being left out of the remaining overlapping areasTo summarise, if 1 point feature is contained in many buffer areas I need this point feature be outputted to all buffer areas in the FAN out CSV file.Screen shot – green points are the centre of the buffer (filter) red points are the points the candidate is usingThanks David

ArcGIS has a tool called Central Feature, which extracts the centre point from a cluster using a weighted value and case field. Anything similar in FME?

I've got two dataset, one is original and the other is revised, they have same attribute schema and a unique FEATUREID attribute to pair them. I want to detect which attributes are changed and write them into a new attribute with a separator like "/". Neither ChangeDetector nor Matcher will work, they can only detect which two are different but not the attribute in them. I'm thinking about creating a list with different attributes, then use ListConcatenator to write the new attribute. So my question is how can I create that list? @takashi @Mark2AtSafe

I have one large elevation model and numerous smaller elevation models (same resolution) which are within the area of the larger elevation model. The areas of the smaller elevation models are generated from a point cloud and clipped out according to a polygon (bridge). Now I want to merge the smaller elevation model areas into the larger DEM (wherever the smaller elevation models have a value, this should be used and if they have no value, the large elevation model should be used. My attempts with the RasterMosaicer unfortunately fail, because I cannot influence which elevation model is the "last" one. Is there another possibility to combine the different elevation models?

Hi, We are looking at taking a simple list and creating an XML from it. --- The list contain the following components VEG-Vegetation/PlantPVP-PV PanelsCWL-Curtain Walling+ Another 1000 lists The XML looks like this and is attached. The item in bold is what we want to replace. <?xml version="1.0" encoding="UTF-8"?> <exchange xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://download.autodesk.com/us/navisworks/schemas/nw-exchange-12.0.xsd" units="ft" filename="CP-WEL-ZZ-LL-MR-N-GZ000_NWD_200213.nwd" filepath="G:\\Construction\\BIM & Tech\\A_Projects\\01_Cherry Park\\01_BIM\\03_Federated Model">  <selectionsets>  <selectionset name="VEG-Vegetation/Plant" guid="7754b400-3fd8-465b-9ec4-31327713c289">  <findspec mode="all" disjoint="0">  <conditions>  <condition test="contains&quot

Hi Guys ,Iam so confused about something and i hope if someone give me a good solution i have different names but i want to force the attribute to change different names even repeated or not for the name that repeated too much .as example TOM is repeated around 5 times so i want the whole attribute name change to TOM with the same idi tried some condition in attribute manager with static calculators but it seems does not work to me . my target ,it should looks like it Hint not all the time the id will looks like counter ,it almost random Thanks in advance  

Hello  I need a global counter in my workbench, but I need a hexadecimal counter. Is it there a simple way to implement such a counter?  Best regards, Hartmut

Is it possible to colour 3D shapes in the data inspector based on an attribute? I have 3D features that stack on top of each other and seeing all shapes in one shade of grey makes them hard to tell apart and check.

Hi there,I am running a Python script which calculates the new attribute using Python caller. When I display/exposed the new attribute to output, I found that all values of the new attribute shown in each column of the newly added attribute. It should display a single value to each column of the newly added attribute. I have attached the snapshot of the newly added attribute and also the snapshot of the code that calculates the attribute. Waiting for your suggestion to fix the issue? Output:Code: