Transformers

Hi, I need to validate if the TFW file content corresponds to the associated TIF file.Therefore, I'm reading the TIF properties (with RasterPropertyExtractor) and I'm reconstructing the 6 TFW-paramaters, to compare them with the content of the TFW file.But... the problem is that the Reader reads the TIF file with the parameters coming form the TFW file. Hence, if the TFW is wrong, then the TIF properties extracted with RasterPropertyExtractor are also wrong.Is there a way to force FME to ignore the TFW file when reading a TIF ?Thank you for your help.

I need to filter by date. Its a CSV: that I need to filter by both Open and Closed status. But I need to find the Closed work orders that have been closed in the last 60 days. I am using TESTER to do the filter.

I'd like to divide my 3D polylines by 3.28084 (feet to meters) - I think I'm close with 3D Forcer, using Arithmetic Editor but it's not quite working... @ZValue()/3.28084

Is it possible to write an AutoCAD Map 3D dwg with an attached FDO connection?I have a library of predefined .layer files containing the connection prepared.

I need a polygon or closed polyline of the extents of this data; using max and min (x,y) gives a bounding box which means further down my pipeline, data is being written to areas that should take "No Data". How can I grab extents from the point cloud to use it as a breakline? Pictured; point cloud, and point cloud overlaid raster output, showing data written outside the point cloud extents

Hi, We have tables of values with colors in Excel that we would want to integrate in a mxd.I though to export them automatically in jpeg files. It would be easier after to integrate images in mxd.How could I do that with FME? Thanks !

i want to merge multiple pdfs in order sequence and in one booklet how i can do please help me

Hi. I"ve a XLSX files. The XLSX files contain 2 sheets. Each sheets have common field (sample_ID). The first sheet is a description of the sampler, like the report name. In the second sheet it's the result of station. For each station it'S have many result ( 1 to M relation). I want to update a field in the second sheets with the value of the first sheet. But i have a error message (check the Capture files). Thank for help :)

Hello,I am creating a josn using the json Templater. In my setting i have a subtemplate that must to be an "object" and contain a lot off nested attributes that are "list".In the situation where only 1 attribute is populated, the final result is good (Topology1record.jpg screenshot) but when I have more attributes populated the result is an array and not an object (Topology2records.jpg screenshot). I also attached the templater to show what I did.My final result should be: {  "type" : "FeatureCollection",  "features" : [     {         "id" : "rfs:7BBE13D625241D58",        "properties" : {            "topologyCharacteristics" : {                  "isPaved" : [                    {                       "range" : {                          "endOffset" : 1,                          "startOffset" : 0                       },                       "value&

This seems as though it ought to be really simple but I can't figure out how to do it.I have a number of text files which each define a polygon by listing the coordinates of its vertices. I'd like to build polygons from the coordinate lists.Usually I'd use the VertexCreator to build points/polygons but I can't figure out how to get it to iterate through a list of variable length.Some of the lists are also quite long (20+ coordinates) and it seems there should be an easier way than adding 20+ VertexCreators in series!

I have been trying to implement a similar solution to that posted by SAFE around HTML reporting and the java accordion feature as referenced in https://community.safe.com/s/article/how-to-customize-html-reports The different is that I am using the group by function in the HTML Report Generator The accordion is appearing as expected  but only ever second category is able to expand  I know this is not truly an FME issue but more likely a HTML formatting issue but just wondering if anyone has had success with using the accordion functionality with the group by option in the transformer. The transformer is set up as follows:and the results of each HTML report seem correct Any insights would be greatly appreciated. Thanks Dean

After LineJoiner some lines are joining in the way of making self closing line geometry with start and the end point in the same spot.Is there the way to identify and repair such lines or maybe there is option in LineJoiner to avoid such situations?

Is there a way to read in the data and keep the address field in one column? Any help appreciated.

Hi I have installed GoogleCloudPubSubConnector from the hub but I am unable to use it since it keeps failing the test for web service authentication.https://hub.safe.com/publishers/safe/packages/google-cloud-pubsub I can't proceed further, I always receive this error message:Error 401: disabled_clientSign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In.  Does anybody encounter this before? Thank you 

Hi there, I'm running into an issue where an attribute that was initially numeric ('counts') is being converted to a character type after I sum 'counts' for each 'tree_type' per 'area_unit' using AttributePivoter (example left to right in image below). Note: These attributes/data are just an example. This is a problem as I'm trying to write the results as a shapefile, which won't work properly for analysis in ArcGIS Pro as it recognises these fields as text rather than integer. Here are more details about my process for summing counts of tree types by area unit.  Input = CSV and 'counts' is read in as UInt32. 1.) I used an AttributeExploder with exploding type set to List, Keep Attributes = Yes, and Keep Geometry = No (Geometry is added later).2.) AttributePivoter, Group Rows By: = 'area_unit', Group Columns By: = 'tree_type', Attributes To Analyze: = 'counts', Pivot Summary Statistic Types: = Sum, Row Group Su

I can't find a way to do what I want.I got a certain number of features. I want to find the max(date) on attribute date for those features, but I want the max(date) to be in relation to a condition on a value from an another attribute status.  So I want the max(date) to be calculated and returned first from feature where status = completedif no features have a status=completed then returned max(date) from the other features 1 20230330 completed2 20230329 completed3 20230331 running4 20230329 waitingwould returned max(date) from feature 1 : 20230330 1 20230330 waiting2 20230329 running3 20230331 running4 20230331 waitingwould returned max(date) from feature 3 or 4 since no value set to completed :20230331  

I am a newbee, I have a spreadsheet that I need to have the data sorted by closed status and date column based on a particular date. Thanks for any help to where I can start.

I have a database table with about 5 million objects. Each object has positions (lat, long in two fields). I want to read only the objects that lie within polygons (features read from a spatial source). Is it possible without reading all objects?

I'd like to buffer only one side of a line. According to the FMEpedia articles below, in FME 2012 and later the Bufferer transformer should have this as an option. I'm using FME 2013 sp4 (13547) and the transformer doesn't have it as an option. Am I missing something?  http://fmepedia.safe.com/articles/Samples_and_Demos/Buffer-On-Left-or-Right-Side-Only http://fmepedia.safe.com/articles/FAQ/Whats-Great-2012  I did find the MultiBufferer from the FME Store but I can't get it to output a polygon, just a line that is offset the distance I wish the buffer to be.  Michael

Hi Everyone I am slightly bamboozled and wanted to know if someone knows where I am going wrong or if this is a potential bug.I have had used the FME Cloud and FME Server for loads of FME Server Apps, and havent come across this issue so far. I get the following warning after running a fme server app I am converting a .dwg file to an excel file.  If I use a feature_reader set for readings dwg:Autodesk AutoCAD DWG/DXFI get the warning, that the no output can be generated. But if I read an ifc and convert it to excel, all is well.  Is there maybe a problem reading dwgs? Why is there no output generated? The FME Server Jobs show that the job is completed without any errors. I have uploaded a .dwg and .ifc and the workspace regardsFred 

Is there a transformer that will convert a multilinestring to a linestring object? I'm trying to load road centrelines in an oracle spatial database, but the road centreline table in oracle uses GTYPE 2002 (line). Multilinestring is 2006, so I can't apply a spatial index. Any suggestions please?

Hello, I am writing to an excel sheet with an existing template. Before the writer, I am using a counter (starting at 0) and attribute creator to then use "Use attribute names as column positions" and "Row number attribute". My attributes are B, C and D which are various strings and B_row_number (@Evaluate(16*@Value(_count)+10)) and CD_row_number (@Evaluate(16*@Value(_count)+16)). I would like the output sheet to look like the image below:Unfortunately, I can't assign different "Row Number Attributes" to arrange it this way (B using B_row_number, and C,D usin CD_row_number). I get the feeling there is a simple workaround I'm not seeing. Any help is appreciated! Thank you.

Good morningI want to generate a json file that accompanies a photograph and I want the name of the json file to be the name of the photo which is contained in a 'Photo' attributeI also want as many json files named with the name of the photo as there are photos in my source directory.I tested in the json output to put the Photo attribute in the entity name but it doesn't work.Thanks

So the result should be a point cloud that has points in a grid of 1m x 1m. Personally I would make a DEM with cell size 1m, but that's not what they want. So I have a boundary of the project area. I make a 2dgrid with cell size 1 meter. I clip the grid, because it's made on the hull of the project area and not the project area itself. Then I use the grid to make points in the center of each cell and also use the grid to clip my point cloud. I use the pointcloudstatisticscalculator to get the mean of the z values within one cell of the grid. So I can use the X en Y from the center point and have to add the Z from the statisticscalculator. I merge the data together based on the counter I added. Then I use the vertexcreator to make points with the correct X, Y en Z. If I inspect these, everything looks good. In the data inspector we see that the points have the correct X, Y en Z.The problem is that I can not write the data as point cloud. Not as xyz file and not as las file. I

There are many FME transformers that allow you to select one or more attributes for analysis. In this case, I have about 350 attributes in a CRCCalculator and I would like to select about half of them. It would be much easier if could select them in a group rather than individually. Is this possible? I've tried using the standard shift-click - clicking the first checkbox and then doing a shift-click somewhere down the list on another checkbox to grab everything in between - but no luck. Is it done another way? I'm using FME 2020.1.2.1 (Build 20624).