Transformers

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

Hi all,I am reading sentinel data from sentinel 2 aws, getting null values in only B4 band, blank image when visualizing in inspector. When i am reading B8 the image is visualized correctly. shown in below image (B4).Below is B8

Since updating to FME Server 2019 a number of workspaces reading or writing via the web seem to be problematic.In this particular instance, I have a workspace that writes to CKAN at data.gov.au. Desktop works fine, but since updating our server it no longer works.My workspace is modeled on this one (with a few minor changes to reflect some updates to the api) :https://github.com/datagovau/ckan-api-examples/blob/master/FME/CKANUpdate.fmw The first issue is that my HTTP Caller in desktop has the response body encoding set to 'auto-detect'. I found that Server fails with this, and after trial and error found it works when set to unicode 8-bit.However the more serious problem is that I can't get it to transfer my file. The error looks like this:63HTTPCaller_2__3 (HTTPFactory): HTTP/FTP transfer error: 'Failed sending data to the peer'64HTTPCaller_2__3 (HTTPFactory): Please ensure that your network connection is properly set up65HTTPCaller_2__3 (HTTPFactory): Please ensu

Hi, I have this small workspace that reads a textfile with MSSQL Spatial Queries that are posted to a database. All area features are, next to being written as area, diverted to an InsidePointreplacer to generate a label. After this, all features are remapped to their target feature types in a set of shapefiles. Here's what drives me crazy... If there is an Inspector connected to the Schemamapper Unmapped port, it runs fine (even there are no features passed to the Unmapped port). If I disable the Inspector and run the workspace, it fatals and gives me the required column error message. Huh?? I'm using FME Workbench FME(R) 2015.1.3.1 (20151117 - Build 15573 - WIN32). I attached the workspace and resources.

Hello,I would like to use this wms (in QGIS I can see the raster): https://geoservices.wallonie.be/arcgis/services/RELIEF/WALLONIE_MNT_2013_2014/MapServer/WMSServer?request=GetCapabilities&service=WMS What url should I use to access this wms via FME. Thanks a lot.

Hello,I am trying to build a workspace where PNG-images are processed into webmaptiles and then written to multiple sub-folders based on their zoom-level. However, I want the output result as a zip file which contains the folder-structure and can be written to a postgresql database. Does anyone know if there is a reader which does that? I don't seem to manage to keep the folder-structure when writing to a zip file using the PNG reader.  This job will anyway be published to a FME Server, so I have tried to upload it and run from there (with a PNG reader). I then get the correct sub-folder system from the data download url in a zip file, so that might be the way to go. I thought then of creating a second script that can call the result from the first script, but I am still very new to FME so not sure how that is done. Is there a reader which can call a result (url maybe?) from another fme server job?  Regards,Anne

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?

Hi Community Champions! As you may have heard, Natalie has departed Safe but rest assured that you are in good hands. I will be the main point of contact for the community going forward and with me are a strong team of familiar faces. You'll notice the entirety of the technical support team is active on the forums and @mark2atsafe is working hard to try new ways to increase engagement. It's an exciting time!Within the next year, we have some big plans to improve the community including looking at some new tools to host it. Overall the vision is to keep the technical questions rolling (that component of the community is working really well) but add some new areas to increase overall discussion. I like to think of it as bringing the experience of the FME User Conference online :)  I do want to take this opportunity to thank you for all of your amazing work within these forums over the last few years!! Going forward, I plan to look for new ways to recognize all of the incredible w

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!

Hello,Can someone please explain the "behaviour" of an upgradeable transformer (Desktop 2019) in relation to FME Server 2019 when the workspace gets submitted? So let's say you have 2 TestFilters, same version.You upgrade one but the other still remains on the current version within the Workspace. How is that possible? Are each transformers considered as "isolated entities"?What happens then when the workspace is published to FME Server? Are the transformers automatically upgraded or do I end up with different versions of the same? (I won't be able to upgrade anything at that point unless I download it and re-publish it again)That leads me to my final question:If a transformer version becomes deprecated how would FME Server behave then? Will it carry on and ignore or return an error? Many thanks Sameer

Hello! Is there a simple way to get an elevation model from a set om points that I have measured with GNSS? It seems like a simple thing to connect the z-values of my points with 3D-lines that builds triangles and then color them in a visually good way, but I just cant find out how to do it? Thanks

This expression (@Value(part_count)==0 && @Value(OBJECTID)==1)?1: (@Value(part_count)==0 && @Value(OBJECTID)!=1)?@Value(feature[-1].Dag_GB)+1:@Value(feature[-1].Dag_GB) It is a working partitioniser.It works by first using a counter (counter4 in picture) in group by mode on wathever you want to partitionise. Data must be sorted first (mandatory).Then it runs the expression on the resulting counter attribute. This is way faster then aggregating(listbuilding) by group, counting and then deaggregating(exploding).  It is faster because it does not block. It streams nicely. But the wheels stays red! (attributecreator4)  This is annoying.A known bug? (using 2018 B18301)

Using the transformer "ExifReader" I read out various data of all images of a flight mission (e.g. name, file size, image dimension, GPS position). These files are stored in different directories. The goal is, if all captured images meet the requirements. This works fine for the individual images, but I'm not able to check if the correct number of images are taken for each point. In the case of a common recording point (simultaneous triggering of several cameras at the same recording point) the GPS position is identical, but the names are different (different cameras). Now I'm looking for a way to check if there are enough photos at the same point.

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. 

Hello, I have multiple exifs which I have extracted information from. Then I have performed calculations based on pixels and orientation which has produced 4 new points with coordinates for each exif raster extraction. I have from this extracted X and Y coordinates as attributes for each point in a total of 8 attributes.I now want to georefence these images which I read in as Tiffs by these coordinates for each raster.I then seem to have stumbled upon two problems:1. I can't seem to get the raster georefencer to fetch information from attributes which I feed in at the different spots. It works fine if I physically write the postions on each slot, however as soon as I allocate the attributes it fails to retrieve the coordinates. I know that the coordinates work, they georefence one image if I take the coordinates from the attributes and write them in.2. I can't seem to feed the raster georefencer from two different paths, it just takes the raster and stops the process with an er

I am trying to extract features based on near-infrared light reflectance

Dear FME Forum,I am relatively new to the Software, and just wondered if it is possible to count "Null" or "Missing" values with the Statistical Calculator? With the statistical calculator it is possible to count the Total amount of Values for an attribute but not how many that are empty. The Null Mapper or Tester is great, but I am looking for a Transformer for the whole range of attributes. Should I use a Python Caller for this or is there an existing transformer? My Question stems from PowerQueryIn Microsoft`s PowerQuery it is possible to get an overview of how complete your data is, I am looking for the same result (please see Screenshot below) Here is a link to the PowerQuery Table Profile:https://docs.microsoft.com/en-us/powerquery-m/table-profile  Thanks in advance Fred

Hi, I am new to FME. I plan to get a FME Desktop license but I want to know if any users can share their experiences of the following: 1. Can FME command line tool create vector data to Esri Shapefile, Bentley v8 and AutoCAD dxf file? What is the quality of the output files?2. Can FME command line utility produce good quality PDF file from Esri shapefile, Bentley v8 file and AutoCAD file?

Hi, I have imported an Excel spreadsheet into FME, one of the columns contains data similar to the below, I am looking to filter the records between the PTO On and PTO Off values, anything else I wish to remove.Is there a way to do this using FME transformers? Many thanks for any help in advance. Ignition OnJourney StartIdle StartGPS PeriodicGPS PeriodicGPS PeriodicDigital Input 0 HighPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicDigital input 0 LowPTO OffGPS PeriodicGPS PeriodicIdle EndGPS PeriodicGPS PeriodicDigital Input 0 HighGPS PeriodicPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicIdle StartGPS PeriodicDigital input 0 LowPTO Off Thanks,Charlie

I use the ZipExtractor and ZipArchiver custom transformers by @takashi from the Hub on FME Server 2016 for multiple processes. Now we are migrating to FME Server 2019 and these are not sustainable because of Python incompatibility. I found the FileCopyWriter can work as an alternative for the ZipArchiver. Does an alternative for the ZipExtractor exist?The alternative is I try to upgrade the ZipExtractor to Python to 3.x but as my Python-fu is not amazing... I know Readers can read directly from Zip but my current proces unzips the entire Zipfile and then processes the different unzipped files.

Intersecting some points with polygon features, there are multiple points per polygon. The trouble I'm having is I'd like to have a delimiter separated summary of an attribute from the joined points. As an example, three points might intersect one polygon (they have ID values 1,2 and 3). The desired output would be polygon geometry with a field called Summary ID and a value of "1;2;3" for that polygon. Does anyone know of a transformer that might handle this attribute merge?  

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!