Transformers

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_client Sign 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 Summary Line Descriptor: = Total, Include Grand Total Columns: = Yes, 3.) Attr

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 = completed if no features have a status=completed then returned max(date) from the other features 1 20230330 completed 2 20230329 completed 3 20230331 running 4 20230329 waiting would returned max(date) from feature 1 : 20230330 1 20230330 waiting 2 20230329 running 3 20230331 running 4 20230331 waiting would 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/DXF I 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 regards Fred

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 morning I 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' attribute I 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 get this

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).

Hello everyone, I need help with the graphs below. I need to maintain the original structure for the graphs. Using the line builder changed the output structure, as you see below. I have an extensive dataset, some lines are correct, but some created their structure and direction. IMG 1.0 and IMG 2.0 are the original graphs. Some lines have around 500 vertices each, but I used a generalizer and changed from 500 to 2 vertices per line. I don't want them to reduce that much. I am looking at around 200 vertices maximum for each without changing the original graph formats. Which transformer can solve this? Thank you so much.

I have encountered a problem when formating a datetime. A log is raising a warning when the value is null. In order to avoid warnings in log I try to setup a condition in AttributeManager. I would like to reuse (copy/paste) the condition definition so I try to use "@CurrentAttribute". It's working as expected in Attribute Value part, but not in the test condition (see attached image). If I use @CurrentAttribute() ATTRIBUTE_HAS_A_VALUE I get <null> results despite the attribute has a value. Any suggestion how to set up the condition for current attribute correctly?

Hi community! I would like update a column in my table with a variable. For that, I put in a VariableSetter my value that I retrieve after a Tester and with a VariableRetriver I recall my variable, and I want to insert this value of this variable in all the lines of my Code_Comma column. But it's doesn't work. Someone can help me please ? Thanks

I am using the FeatureReader to connect to an ESRI SDE. I have specified the features to read, and selected Output Ports: One per feature, BUT out put ports are not being created for the features I specified. In only the default ports are available. I am having a similar issue with another FeatureReader that is pointed to a FGDB. I had to change the directory path for the FGDB and now all of the output ports are gone. I reset all of the "Features to Read" but like the above, I am not getting out put ports for the features I have specified. In the above there are no Output ports for the features specified. in the above only some of the Output ports for the features specified are available.

Hi All, I'm very new to FME so excuse my noobiness. I'm bring in a roughly 20 shapefiles and running them through a attribute filter to pull out the ones with a matching project number, from there i'm exporting them out as a .csv. As it currently stands all results are put into one spreadsheet. not ideal. i would like them all in one spreadsheet but as separate tabs for each individual layer. As a work around i've made each layer its own attribute filter running to its own .csv writer, then i'm copying them into a single spreedsheet.

Is there a way to create a raster of polylines, showing the counts rather than density per area magnitude? I have 17,000 lines and I'm trying to recreate the below graphic/visualization:

We have a workspace on a FME Server that creates PDF files using Adobe Geospatial PDF Writer in FeautreWriter. The files are transported into another system via PDF.js. Apparently PDF.js can't transport tagged PDF-files (?). Can I somehow make the FeatureWriter creater non-tagged PDF-files? Or is there other ways to get around this issue?

I have a json-file (see attachment) that contains the coördinates of a circular route. It looks like this: { "segments": [{ "geometry": { "type": "LineString", "coordinates": [ [50.814103, 4.521174], [50.81309, 4.521811], [50.80626, 4.536902], [50.80482, 4.538866], [50.80573, 4.541452], [50.80621, 4.543173], [50.80705, 4.545501], [50.80755, 4.546541], [50.80777, 4.546841], [50.80919, 4.547739], [50.8096, 4.548199], [50.81052, 4.550243], [50.810663, 4.551096] ] }, { "geometry": { "type": "LineString", "coordinates": [ [50.810663, 4.551096], [50.81065, 4.555264], [50.81071, 4.555622] ] }, ... I want to convert it to an ESRI line feature class, but I'm stuck. The geojsonreader gives no error, but also no result as reader. Json-fragmenter gives me the list of vertices in an attribute, but I can't fix it to convert these points to vertices/line. Someone who can help me out?

How do I Copy SHAPE column from an ESRI GDB feature class to a non spatial Postgres database?

Dear FME Community, I am currently working on a project that involves a vector point file containing electricity power plants. As part of my quality control process, I need to check if there are any power plants that overlap with the point file. I am wondering if there is an automatic way to check for this overlap, as there would be two situations, one where point file is overlapping with power plant in satellite imagery, or else it is not. I want to ensure the accuracy of the data and identify any potential errors. We can hover to locations and find it, but can there be something more in an automated way? I would greatly appreciate any advice or suggestions from the FME community on how to best approach this quality control challenge. Thank you in advance for your help!