Transformers

I would like to use JSONTemplater to build nested text structers making use of the ROOT and SUB TEMPLATES but this are not valid JSON ... its  a Groovy syntax ... Beacause is not a valid JSON format the JSONTemplater gets offended and stops the translation. i cant find a way to skip the JSON validationsI tried disabling validation ,,, but nothing ... any alternatives ?   2020-02-21 17:22:01|   2.1|  0.0|WARN  |JSONTemplater(XMLTemplaterFactory): The following error occurred near line 1, column 11 of the query:2020-02-21 17:22:01|   2.1|  0.0|WARN  |JSONTemplater(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)2020-02-21 17:22:01|   2.1|  0.0|ERROR |JSONTemplater(XMLTemplaterFactory): An error occurred while parsing the ROOT template2020-02-21 17:22:01|   2.1|  0.0|ERROR |JSONTemplater(XMLTemplaterFactory): A fatal error has occurred. Check the logfile above for details  Thanks

I have a point vector shape file that consists of the vertices of a number of lines. The data looks kind of like this: (extremely simplified values, but the same format)Feature NumberVertex NumberxyzLayer00101315Main Cable01121420Main Cable 10345Secondary Cable11478Secondary Cable125710Secondary Cable What I want is to create lines that consist of x, y and z values using the feature number as the grouping attribute, ie. All points that have a matching feature number would create a single line, with the vertices starting from lowest to highest. I have tried using CAD, FME and Excel but have had no success.  Thanks in advance!

Difficult to word this one.  I need to generate a table where attributes are generated dynamically e.g.NameFeb-20Mar-20Apr-20      Where the attributes reflect every month from "now" for a set period e.g. a year. I have created a workbench which generates the month-year as attribute values dynamically and then creating Attribute names from these values. However, I can't seem to find a way of exposing these attributes dynamically so that I can then assign values to them. (Currently I have to export them and then reimport them within the attribute exposer). Is there anyway of doing this in a more streamlined fashion?

 i have many lines with diferent id and also Lines with many segments connected together between two area and i have 5 area with different id and different lines intersected with the same area and another lines intersected with another area and so on .some and i have the coordinate of points x,y that refer to the location of point intersected lines with in area ,i want to get the name of area that intersected with diff. lines ,and which lines intersected with this area and and i want to get also when line intersected not only with one ,may be 2 area so i want to know the id of this line and the name of two area that it intersected with . FME 2018 Does spatial relator the transformer that i want or which transformers should i use,i am new in map and iam new in work on map and i am still reading and learning about transformers

I have a shapefile with an attribute ID that contains 23 objects (polygons).I want to use this shapefile to clip the las files and combine them based on the objects.So I want 23 point clouds. I have an idea on how it works, but want to be sure as this is going to run for a long time. My bench looks like this:In clipper I would turn on group by "ID" and merge the attribute just to name the Las file by the value in ID. In pointcloudcombiner I would turn on group by "ID" will this give me the result I want?                 

Hi,I'm new to the FME family and have this question. I have a Civil 3D dwg that we want to transfer to a geodatabase. Transforing the geometry is no problem, but the dwg has extended entity data that I want as attribute fields in the geodatabase.But, at this time, I can't even find my extended data when inserting the dwg as a reader. I searched this community but so far no luck. I tried the 'AttributeExposer' or ListExploder' transformers, but still didn't get result.Can someone tell me how to set the parameters so I can read the extended data and will be able to transfer them as attributes in a geodatabase?Thanks,Davy

Hello, I'm using attributevalidator to make multiple check on attributes. There is one check I don't know how to implement. I would like to hightlight the attributes finishing with newline. I used this regex : [^(\\n)]$ . It is working when I use external tools (for example (https://regexr.com/ ), but not in FME. I didn't find any other regex to do that (I'm a beginner in regex).In case, there is one other solution : using tester/attributecreator, but if possible, I would like to gather all the tests in the same transformer to make the workflow as simple as possible (the workflow contains a lot of attribute / spatial tests) Thank you  

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?