Best Answers

Hi there,I've seen some similar questions already asked about this, but none of them were quite the same as what I'm trying to do. That or I simply misunderstood.Essentially, my data looks like this:WeekCountLength150350027040003653800 And what I need to get to is something like this: Week_1Week_2Week_3(Count)507065(Length)350040003800 Now if it where only these 3 cases above, I could quite easily take a more manual, individual approach, but in my actual data there are a lot of "weeks" so I need to have it pretty dynamic.Any suggestions? Best regards,

I am very new to use this tool and thought some of expert from this forum might help meI have oracle11 database and migrated to MS SQL server 2014I would like to compare data between oracle11->database1->table1 with mssqlserver2014->database1->table1I would like to compare data between each table with cross databasesPlease, let me know steps to do this

Hi, As a non-expert in remote sensing, I would like to calculate the NDVI index from a CIR aerial photograph.I came across this promising custom transformer on the hub ( NDVICalculator - @dmitribagh ) , but I always get this error message:_RasterExpressionEvaluator_4 (RasterEvaluationFactory): Input 'B' is referenced in the expression list, but no 'B' feature was providedI (think I) have an infrared and red band entering the transformer, and I also get a preview of the output of the transformer, but I can't write the result as the translation stops with the fatal error above ... What could I do wrong (as a FME newbie...)? My workbench with a sample of the aerial photograph attached Any help much appreciated!  

Hi, I have a Aggregator feeding into two MSWordStyler's (header and footer). I have another MSWordStyler with content type table which is fed by same input source as the aggregator. All three MSWordstylers feed into MSwordWriter. I'm using a fanout expression. All of these are giving me one word document per customer with the correct header and correct footer and a table with transactions for that customer. Which is great.Even the Document name has the supplier number in it.HOWEVER, the table is at the top of the word document then the header and footer. How can I get these to feed into the word writer in correct order.From forum posts, they recommend creating stylers in correct order in the first place but this did not work for me. They also recommend using the WordGenerator but I can only get one single word document from that and all transactions for every customer are included in the same table i.e. it does differentiate between customers within the word document or allow

I have two features source and MasterData i need to select in MasterData only 10 meters radius data from source. Based on Geometry and exclude attributes condition.  

I was wondering if anyone might be able to help me out? I'm writing tabular data to a SQLite database and I'd like to run the VACUUM command after it's been written. I thought it might exist in the SQLITE3 writer parameters but no luck. I'm using FME 2019 desktop

I'm getting the error message then converting SID file to GeoTIFF raster:MRSID reader: MrSIDRasterBand::IRasterIO(): Failed to load image. mg2d internal error [8021]MRSID reader: Failed to retrieve data from the source datasetAny ideas how to solve this?

I have a workbench which builds FME date time attributes and writes them to ESRI FGDB Classes. So, for 20191009115225 I get 09/10/2019 11:52:25 however if the time is midnight the fme date is 20191009000000 and the FGDB field contains 09/10/2019. How do I get this field to retain the 00:00:00 values?

There seems to be a trend moving away from the CS-Map projection library and I'd like to know where FME is going with it as well!

I want to read a GEOTFF, add an alpha channel and then write a png with a pgw rasterfile.My Workbench works but only creates wld-files with png.How can I create pgw-files? 

Hi, I have: 1. A .dwg file of a single 1 ground surface model that i read in.2. I use GeometryPartExtractor to extract IFMEMesh and IFMEFaces so I get a trianglor network of the model.3. I then I use GeometryCoherer to get FME_polygon How do I get the slope (and possibly aspect) for each individual face? I tried SurfaceModeller and it is not working for me since it is creating extra triangles that I do not want. I have created a custom tool that calulates FME color based on all incoming attributes, ex a test where I add a step 4 where I use surfaceModeller to create the surface again just to get the slope value then I use a DWGStyler to set the surface color to my calculated color and that works fine. My problem is that I do not like the surface modeller since I already have my model and the extracted version as it is, and NOW I want to get the slope for each individual Face or Mesh, set the color for each triangle and possible use the aggregator and write to a dwg file again. I have n

Hi has anyone been able to read an SDE Terrain dataset.I would like to read this so I can obtain the z values, for specified x,y coordinates. 

I'm using the HTTPCaller to upload (POST) a file as well as some additional data. This is relatively simple when the file to be uploaded is sitting on the file system somewhere. Simply set the HTTPCaller Upload Data type to "Multipart / Form Data" and set the multi-part content for the file portion to point to the file on the file system.However, my file content (not the path to a file) is already in an attribute on the feature. Does anyone know if I can get the HTTPCaller to upload a file in this way?Nic

Can you connect to ADFS (Active Directory Federation Services (ADFS) is a(SSO) solution created by Microsoft ) and handle login on FMECloud through this? Similar to connecting to AD on FME Server

Hello, I have a workbench I'm having a difficult time with. As you can see in the image below, I have a shapefile being joined with a table from another database. I have confirmed with data inspector that before the join it has 524 Features, but after the join, even when I do a full join (the one pictured is an inner join). it only returns around half of the geographic features. I was wondering if anyone had any tips, or if I'm missing a Transformer I should be using? 

HiI am trying to connect to an open data API which contains geoJSON using the HTTPCaller. However I am getting the following error message: SSL peer certificate or SSH remote key was not OKII was able to get the geoJSON when I copied the API URL directly into the IE browser. Does anyone know what settings I need to set on the HTTPCaller to be able to access the geoJSON through FME?I am using FME2019.1 DesktopThanks,

Hi there,I'd like to know how I can detect scenarios where polyline features cross each other without the presence of any vertices. See my awful paint work as example:So in this scenario, both the red and blue line has no vertices where they cross. These kinds of situations, as well as one where just one or the other has no vertex, is what I'm trying to identify. Meaning, in all cases in my data, both edges need to each have a vertex wherever lines cross. Thank you in advance!

Hello,I could use some help with accessing custom IFC properties (and their values) in the FME workbench (version 2018.1.0.0). I am working on a transformation from an IFC file to PostGIS. The IFC file contains custom properties for some classes (e.g. IfcBuilding and IfcSpace). I can see those custom properties and their values when I inspect the IFC file with an IFC viewer. I can also see the values of the custom properties when I open the IFC file in the FME Data Inspector when I set the "Data Model" parameter of the reader to "Hierarchical". Only in that case I can't tell which IFC class instance the value belongs to.  From reading related question and answers I have understood that in order to expose custom IFC properties I would need to add a Attribute Exposer transformer. I tried several settings for the IFC reader parameters, and I have tried specifying additional attributes in the AttributesExposer, in the format <name of the IFC property set>.&lt

I want to categorize all properties across BC based on the federal electoral districts. I have the Esri Geodatabase file format for the federal electoral districts and have all the properties with their latitude and longitude information stored in a table. what will be the best approach to resolve this ?

Hi, I am trying to pull some content from XML and making a mess of it.I use the XMLFragmenter extract from this:<?xml version="1.0" encoding="UTF-8"?><wfs:FeatureCollection xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:wfs="http://www.opengis.net/wfs" xmlns:gml="http://www.opengis.net/gml" xmlns:workspace_wfs="workspace_wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" numberOfFeatures="5" timeStamp="2019-10-11T13:52:44.446Z" xsi:schemaLocation="http://www.opengis.net/wfs https://geoserver.xxx.com/geoserver-cluster/schemas/wfs/1.1.0/wfs.xsd workspace_wfs https://geoserver.xxx.com/geoserver-cluster/wfs?service=WFS&version=1.1.0&request=DescribeFeatureType&typeName=workspace_wfs%3Abasin_models"><gml:featureMembers><workspace_wfs:basin_models gml:id="basin_models.48"><workspace_wfs:changedetect_date>2019-09-11T09:33:46Z</workspace_wfs:changedetect_date><workspace_wfs:changedetect_uuid>46af9f38-5edd-4b33-8f15-6c

I'm migrating a project from FME Server 2018 to FME Server 2019.0.0.1 (build 19246) and am seeing this error when running a workspace on server 2019 that used to work on server 2018.50InlineQuerier (InlineQueryFactory): An error occurred while creating the table 'features'51InlineQuerier (InlineQueryFactory): Database was unable to define table 'features'.52A fatal error has occurred. Check the logfile above for details When I run the workspace locally in FME Desktop 2019.0.0.1, I don't get the error. Here's a mini workspace that has the same issue: What can I do to get my workspace running on server 2019? 

Hi all, I am trying to calculate the surface area of different LULC classes. I have to do this for very many different polygon areas, using the Rastertopolygoncoercer takes too much time, so I do this by counting the pixels of specific values, and then calculating the surface area based on the pixel size of my raster. Ordinarily I would do this with the ArcGIS Zonal Statistics function for rasters with the "count" functionality and be done with it. This does not seem to exist in FME, the RasterStatisticsCalculator misses this feature (and only that feature, strangely). So what I do instead is per class, replacing the cell values with 1 (and all others 0), and then calculating the "SUM" with FME's RasterStatisticsCalculator. It gives me the result I want (in a cumbersome roundabout way) but then, I want to save the attribute table separately from the raster. Because when I do a rasterstatistics of the individual rasters (which are clipped with the polygons, and t

Hello everybody,I just have one tricky issue - how can FME detect attribute value, which is composed strictly by white spaces, e.g. ? Its not empty value in DB view, but it is hardly detected. Any idea please?It doesnt matter on count of white spaces.Thank You so much!Lubo

Hello FME community,I have points CSV file (POI). Each point includes Category, Name and Homepage attributes as shown in following screenshot: The problem is that, for each Category of points within specific distance I need to create one point in center (center of group) and append the information of original points. The result should be similar to the following screenshot to display it on a website: My idea is to Buffer the points with required distance, followed by Dissolver (Group By: Category) and CenterPointReplacer.I am stuck on exactly how I would append all information of original points to the new created point to achieve the desired result. For Example the 3 museums should be presented by one point that includes the information of 3 museums.I attached the workbench for more clarification.Does anyone have any ideas or other potential solutions to perform that with FME Desktop? Regards,Afia.@mark2atsafe @egomm @david_r @jlutherthomas @jdh @takashi @redgeographics @danilo_fme

Hi All,It seemed a bit easy but i am stuck with it now. Can someone please help?My input is somewhat like this: and my desired output is like this:The 6 values (Acquisition date, Analysis Date, System, Method, Sample ID and Data filename) are repeating three times in first column and have different values. I have attached the excel file for your reference.