Best Answers

I have a set of grouped features and want to identify the feature with the highest value in one of the columns, lets call it "MAX_attribute", for each group. I can find the highest value in each group by using the StatisticCalculator. But that only gives me the "MAX_attribute" for the group as an whole, I also need to identify and "tag" the actual feature that had the "MAX_attribute".To give you an example: I have depth readings for a number of lakes, and now I want to find the deapest reading for each lake.I also tried the Aggregator with the ListRangeExtractor but could not make it work as I wished.

Hi there,I'm completely baffled about how the "Apply to: Cell" function works in the ExcelStyler transformer.The explanation of how this works (at least to my untrained eye) seems pretty confusing:"Specifies which cells will be styled. This option allows selection of attributes, which correspond to columns in Excel, to style for each incoming feature, which each correspond to a row in Excel. The result is that the intersection of the columns and the rows are the cells that will be styled. Note that this can only be set when applying formatting to cells." I don't want to involve any attributes into the equation, but instead just want to always style "C7" in a specific way, for example. Is there any way I can do this? I have several cells to style individually, but how to set up these attributes to represent the rows and columns (I guess?) is blurry to me. There will be no dynamic values or anything, "C7" will be styled in one way and alway

Hi FME community.I am trying to color my 3D object based on its fme_color attribute but I don't know how to do it.Currently fme_color is set as cyan. So, if I can how this as 2D in the Inspector, it shows as cyan. However, if I switch to 3D, it becomes gray. I think this is a default color. I looked at the Front Appearance Reference and this setting is set as <inherited_or_default_appearance>.If I can set the Front Appearance Reference as same as fme_color, then this 3D object will be cyan color. I used AppearanceSetter to manually set the Front Appearance Reference but I don't know how to change it with transformers.If someone who knows how to do it, please share your knowledge.Thank you in advance.Hiroo

Hi,I am new to the appearance setter and while I having no trouble applying a colour using the appearancesetter, I am having trouble applying a texture. Can someone please me show me how?Attached is a FFS file with 9 roof geometries and 9 images, both having a _count attribute that references them to one another.Thanks is advance,Todd 

Hi,I have a workspace with an Reader (SDE Connection) writing to multiple different zipped folders before a FileCopy Writer inserts a common disclaimer into each zipped folder. I want to use the FileCopy FeatureWriter due to the output port would then allow me to connect to a S3Uploader transformer and simplify my workspace down from 2 to 1.I however receive a error of: Cannot have multiple factories with the same name. Multiple factories were assigned the name 'filecopy_FeatureWriter-FileCopy_d4291b7d_cbed_4650_990f_3e25feda4a160'Am I missing some parameter setting or is there some workaround using the FileCopy Reader that allows processing after the disclaimer insertion?

Hello, I am creating a workspace that will export photo (.jpg) and video (.mov) attachments from a FGDB. The FGDB contains a related table holding the attachments in blob format. Per the suggestion found here https://knowledge.safe.com/questions/58775/exporting-geodatabase-attachments-to-jpeg.html , I was able to use a FeatureMerger, RasterReplacer, and a JPEG Writer to successfully pull the photos out. I have isolated the "video attachment" records after merging the data with the related table via a Tester, but I am unsure how to proceed. Is it possible to write .mov or other video files from FME? I have not seen a writer for video formats (similar to the JPEG writer used to write the photos to file). Thanks!

Folks, This should be simple but I'm just not finding the answer.Using an AttributeManager I want to add a value "0.09" to all the existing values in a column of data from a Mapinfo table during translation amongst other things.The Column is "Average" and is a defined Decimal type field.The syntax I'm using is clearly wrong.@Value(Average)+0.09 returns -9999.00 for all values.What am I doing wrong?Thanks in advanceAndrew

Hello,I am new and just starting out using FME. I have several .LAZ files and I need to get the coordinates and elevation out and into a .CSV file. I have tried to use the LAS reader >>> Point Cloud Coercer >>> CSV writer. All I get is a file filled with commas. Can someone walk me through what I need to do to get the x,y, and z data?Thanks

I am trying to calculate NDVI with a RasterBandSeparator, Test Filters and NDVI Calculator. Prior to running the RasterBandSeparator I am also using the RasterMosaicker and RasterTiler since I want to remove the overlapping edge effects of the imagery. I have added an image of the workbench so you can see where the error occurs. Looks like it's occurring once data for the next tile is being passed to the NDVI calculator. Any help in debugging his would be appreciated. I could re-tile the imagery first I suppose but then I'm reading the source data multiple times. t

I have a deaggregator transformer in a custom transformer loop. When I run the workspace, the deaggregator holds on to all features until each row has gone through the loop. I am wanting one row to pass through the entire custom loop transformer, all the way, before the next row entering.

I have two files a csv file and an Excel file with 4 worksheets, I need to compare the two files to see if all records in the Excel file with all sheets are present in the csv file, there is a particular column in the Excel file, it is a string e.g. 'ff_abcd_12345', I need to get everything apart from the numbers from this and compare it to a field in the other file. There are thousands of records which need to be compared, all I need to do is check if the record exists and report it as matched or unmatched. Any ideas on how I deal with this will be much appreciated.

Hi,My Workspace run by command line...There is one Emailer transformer and other output shapefile. When I run by FME Desktop, the workspace run properly, but when I run by Task scheduler the log file show me TOTAL FEATURES WRITTEN 0, and the e-mail wasn´t sent. What I can do?Thank´s

Assume we have a well populated PostGIS database with lots of metadata about raster and feature based data. (we are using FME Server, to farm the cloud and other sources and build the PostGIS database).Now we need a friendly user interface for search and download.What open source technologies would one use to create a end-user friendly catalog search and download system (web based). Something similar to what is located at: https://catalog.data.gov/dataset (I realize they just provide pointers to the original source, we would be caching the rasters and the feature in a datalake, and using PostGIS for the catalog/index) yea, the data.gov uses ESRI, but let's take that off the table.) If I had to do it by hand, I would use Leaflet or OpenLayers, but since this is such a common need, I wonder if someone has not already put that together).

Howdy!I have a question about "Summary Annotation", when used with transformers like the AttributeManager or AttributeRenamer it does not expose all of the attributes. Example of the transformer issue: Using "Summary Annotation" with an AttributeManager transformer, the list/table of "Attribute Actions" that is shown is limited to 20 (seemingly random) attributes/rows. At the bottom of the annotation list/table it states "41 more row(s)". Is this just a default setting? Is there a way to get it to show me the other 41 rows? Compared with a Reader/Writer: However it appears that Summary Annotation exposes all of the data when used with Readers/Writers. I noticed that when I use Summary Annotation for a transformer like a SQL Writer, there seems to be no limit to how long the list/table of fields/attributes/rows that can be displayed.     Any help understanding this limitation and/or a work around is appreciated.

I have a bunch of images that I want to rotate on their self. Like this example.Do you know an API that I could use in FME or a transformer that could do the job?Thanks.

I am attempting to write from a WFS FeaturerReader directly to a FeatureWriter, using the tip outlined in this post:https://knowledge.safe.com/questions/69654/writing-table-with-featurereader-featurewriter-pro.htmlThis works for some datasets, but when I try to use a particular dataset, I get an error message:Bulk copy failed on table 'public.road_works_line_temp' using delimiter ':'. Error was 'ERROR:  extra data after last expected column CONTEXT:  COPY road_works_line_temp, line 1: "NULL:featureMembers:rwe_line.143236:143236:Sporting/social event:NULL: road closed:NULL:Pending:NULL..."'The wfs url is http://api.vicroads.vic.gov.au/vicroads/wfs?SERVICE=WFS&VERSION;=1.1.0&REQUEST;=GetCapabilities&AUTH;=eyJraWQiOiJRRFFQWDZVSDlQRExOOU9GQVowMlNFRFVYIiwic3R0IjoiYWNjZXNzIiwiYWxnIjoiSFMyNTYifQ.eyJqdGkiOiJuUzRMM0MzSURvdzRsakNNc3R2Y0IiLCJpYXQiOjE0OTE1Mzg2NDQsImlzcyI6Imh0dHBzOi8vYXBpLnN0b3JtcGF0aC5jb20vdjEvYXBwbGljYXRpb25zLzRBeTd5RjJtUUNpQlpxUHo5Q3lRVTgiLCJzdWIiOiJodHRwczovL2FwaS5z

Hi AllI have raw data like this. line_idnumberXYTypeLINE01144.0756.38anchorLINE012--interLINE01344.0956.4anchorLINE014--interLINE015--interLINE01644.0956.37anchorLINE017--interLINE018--interLINE019--interLINE011044.1256.39anchorLINE02144.2356.4anchorLINE022--interLINE02344.2456.5anchorThis is poles which form electric lines. As you can see I have only coordinates for anchor poles. The question is - how to calculate coordinates for intermediate poles? with assumptions:intermediate poles located on the line between two anchor polesdistance between poles in one span is equalThanks in advance

I have a line shapefile, can I convert this to a csv file displaying a column of well-known text?

HiI have a workspace on FME Server (Cloud) which currently uses the data download service. It requires the user to upload a .csv and a .pdf, then it runs a translation and delivers a .kmz and a folder of geoTIFFs. I'd like to run this workspace using a call to the REST API. I'm struggling to figure out how 2 files can be uploaded as part of the same SUBMIT call. Assuming I can do this, will the call still trigger a data download? Or will I need to write to a shared resource folder? Any help appreciated, thanks.

With XMLUpdater I am changing values in an XML-file. I'd like to generate the xpath dynamically based upon a column ('Attribuut') in an Excel file. However, when I select this attribute in the text editor for the XML Path, the generated code is wrong. It is://*:featureAttribute[*:name/text() = 'fme:get-attribute("Attribuut")']/*:definitionwhere it should be://*:featureAttribute[*:name/text() = '@Value(Attribuut)']/*:definitionI can change this myself and everything works fine, but I'm just curious: Is this a bug, or does FME generate the xpath as one might expect? Is it something I do wrong?

Just wondering if anyone has tried the (very) new DICOM reader in 2018.1 Desktop.I would like to process several folders of NON-MEDICAL DICOM CT images in an engineering application, using the raster (relative density) data returned in x,y by z slices to create a fully dimensioned 3D model suitable for viewing in a standard browser.Being able to project the DICOM x,y,z coordinate system into a real world coordinate system would be a distinct advantage, as would being able to contrast and window to observe specific features.Any experience people have with this greatfully appreciated.

I want to take a DEM with a 1 foot resolution (horizontal) calculate slopes and output two polygons 1 with the slopes drom 12 to 17 degrees and the other with slopes above 17 degrees. the rest can be discarded. Is there a sample workspace I can study to perform this?Thanks

Hi,I would like to know if FME provides a transformer or a logic allowing to derive the similarity between 2 shape geometries. There are concepts such as the Hausdorff distance which could probably be used to some extent for that purpose. This similarity could be for instance expressed as a ratio but I don't know exactly of what yet. Basically I would like to be able to determine if 2 overlapping shapes are similar enough and can be considered as representing the same object in reality.Thanks in advance for your hints!Olivier

Hi,  I am looking a transformer that could work like the XY to line tool in ArcGIS.  For each spot I have a beginning lat/long and an ending lat/long on the same row.  I would like to connect the lat/longs on each row as a line and then move to the next row as a new line feature.  I have tried pointconnector which works great for sequential rows but I have not been able to get it to work in this manner.  Thanks.

I've got FME workbench installed and licensed on a CentOS7 machine an Amazon EC2. I've successfully run models through command line, but I would ideally like to have the actual FME GUI. I followed these instructions to install a the gnome gui and connecting through VNC https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-vnc-remote-access-for-the-gnome-desktop-on-centos-7#step-8-%E2%80%94-securing-vnc-sessions-through-ssh-tunnelingWhen I click on the FME workbench application in the gui it crashes when it tries to load the main window.Do I just need to use something other than gnome?