Transformers

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

Hi,My Workspace clip area but don´t preserve the attributes of the Clipee. What transformer I could use to clip area and preserve the Clippee attributes. I tried the Clipper but unsuccesfull.Thank´s

New user here - thanks in advance for the help! I'm trying to use Coordinate Extractor to populate XY from address but not having any luck. Any suggestions? Thanks in advance.

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

I have a shape file with depth readings in various lakes and am trying to find the deapest value in each lake. In order to do this I first need to group the features by vicinity, so that each group represents a lake. Then I can move on to find the highest value in each. Below is a screen dump of my data. What I esentially want to do is to group each of the clusters below by vicinity and then attach a identifying attribute to each group.I have had a look at neigbourhoodfinder, clustermodeller and a few others, but have not found a way to get any of them to do what I want. To a human eye the groups in the image below are obvious, and it is sligthy soothing that we can beat the machines now and then, but this time I need the computer to do the work.

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.

Just report a small (but annoying) issue. I noticed that the XMLXQueryExploder on the Canvas exposes incorrect attribute names, which contain a leading or trailing " (double quotation). See the screenshot below.FME 2018.1, FME 2019.0 beta b19092

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.

Hallo guys!I have again some problems which i hope anyone can help me. In the first picture i show my template where i try to get the points out of my lane. It works but i just want the points one by one (and not all as you can see on picture 2) and also that the template start new for every single point.The next problem is that i get the value "0" sometimes between my coordinates and i have no idea why. How can i change that ? (also visible on the second picture)

I have hundreds of html tables based upon a year/month selection. I have figured out out to generate the html files. The problem I am having is converting the html to a usable tabular format. Example url. http://bbnet.gein.noa.gr/alerts_manual/2006/01/manual_alerts_01_2006.htmlAny Ideas?Thanks Frank 

Hi,I'm having problems using the Clipper transformer with 19 las point clouds as the input / clipee and a MapInfo tab file as the clipper, with the output being written as LAZ files. The workspace works fine if I just run it in isolation, as shown below:However, in addition to the output from the Inside port of the "OSTile_Clipper" being written as a series of LAZ files, I also want to put this output this through a 2nd clipper (ControlSurfaceClipper) as the Clippee and have it clipped against another MapInfo tab file.On enabling the ControlSurfaceClipper tranformer and it's associated Clipper input port, all outputs from the 1st transformer are now output via the "Outside" port and no data is output, as shown below:How do I get around this, so when all transformers & writers are enabled, the data from the 1st Clipper transformer is output via the Inside port?Below are the parameters for each clipper:Thanks in advance!

Hi, I am using FME Desktop 2016.1.3 on a Windows 8 computer with 12GB RAM. One of the readers I am using is the MSACCESS_JDBC reader. While initialising that reader (it seems even before starting any reading) FME throws the error "java.lang.OutOfMemoryError: Java heap space" and cancels the translation. How can I tell FME to give more memory to Java?Many thanks!!!

Hi, I have two GDB schemas, one is the original design (empty) and the other came back from our contractor with data added in it. They sometime play with the schema to fit the data in it, for example originally Non-Nullable columns have been changed to Nullable or changed the width of the column, etc. I need to compare only the schemas of both the GDBs (original and contractor's) in such a way that FME should report the differences in Field Properties (Allow Null Values, Length etc.) and other normal comparison of number of column, their types etc. Matcher and ChangeDecector does not go that deep into the schema. Please let me know the easiest solution as I am not FME expert. Additinally, just to give another direction to thinking, I would like to say if XMLs of the GDBs of any use for this purpose. Regards AsifM

I'm using the Tiler transformer to split individual polygons by a specified number of horizontal and vertical tiles. This overall works perfectly for polygons that are generally horizontally or vertically oriented. However, this functionality is lost when attempting to tiler polygons with "irregular" orientation (see image). Any suggestions for how to account for this? It'd be great if the Tiler transformer had an option to use the the polygon's geometry and tile starting from the longest measured side?

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

Hello,I have a job that reads data from a MSSQL database. The date format comes in like this.%Y-%m-%d %H:%M:%SI am writing the data out to a csv file in this format %Y%m%dI am running workbench and server 2017The job works perfectly fine on my workbench but fails with this error when published to FME server.AP_Latest_Survey_Date_Formatter_<Rejected>(TeeFactory): AP_Latest_Survey_Date_Formatter_<Rejected>: Termination Message: 'AP_Latest_Survey_Date_Formatter output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' AP_Latest_Survey_Date_Formatter_<Rejected>: Termination Message: 'AP_Latest_Survey_Date_Formatter output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to &#3

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

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?

My aim is to update the creation date in the metadata of a feature class in ArcSDE using XMLUpdater.However, with the workspace I've build so far, the value is not changed.At first I thought I might have the XML path wrong. But I did some testing and found that when I simplify the XML (leave some nodes out that are further on in the XML file) everything works fine.So my attached workspace works fine when I use the attribute geodb_metadata_string_simplified as the XML input, but it doesn't when I use geodb_metadata_string. Do you know what might cause this problem?

The python api has a method for checking whether or not any part of a feature's geometry contains measures. http://docs.safe.com/fme/html/fmepython/api/fmeobjects/geometry/_general/fmeobjects.FMEGeometry.hasMeasures.html#fmeobjects.FMEGeometry.hasMeasuresIs there a non python transformer equivalent? I don't need to extract any measure values, just check whether or not they exist.

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