Transformers

Is it possible to BEGIN a transaction when an SQLExectur gets run, and keep the transaction untill all writers have successfully committed? I know it is possible to set on the reader - however I am not sure if you can set the whole workspace as a transaction

I'm using the attribute creator to create a new attribute from the value of an existing and setting the value to another attribute. 19 features go in, but only 18 come out!This is in 2019.1.0.0 (Build 19608 WIN32) - same process works fine in 2018.1

Hello FME Community, I am currently translating IFC to CityGML using one of the tutorial workbenches (https://knowledge.safe.com/articles/1025/bim-to-gis-intermediate-ifc-lod-300-to-lod-4-cityg.html). This is working mostly fine.I want to import the model in 3D CityDB using the Importer/Exporter tool. It needs to be georeferenced, so I can later export it to KML and COLLADA. My question is: How can i add the correct coordinates and coordinate system (UTM32) to the resulting CityGML model) Thanks in advance and best regardsTobias

I am dealing with Assessment Fabric parcel Data and I am trying to write it as Microsoft SQL Server Non Spatial File Format. I want to add the Logitech and latitude information for the parcel as well in the file i am writing to but for some reason neither the new string field i have created nor the coordinate information. I am not sure where i am going wrong. Any help will be much appreciated. 

I created a Custom Transformer and submitted to hub.safe.com - to try the functionality. It is really easy to upload custom transformer and I recommend you to do it. However I wonder what happens when someone gives a comment on a transformer. Do you get notified by e-mail? Can someone test it and add a comment to : https://hub.safe.com/publishers/sigtill/transformers/looper - so I can check if I get an e-mail ? Thanks.

Hi community,I have some problems using the XMLAppender, to define the correct append path in the main xml document.The main xml document looks something like this:<DATA>  <NAME>Features</NAME>    <CHILDREN>     <Type>      <NAME>Boulder</NAME>      <CHILDREN>        <Type>          <NAME>Bouldertype1</NAME> </Type>  <Type>          <NAME>Bouldertype2</NAME>  </Type>      </CHILDREN>    </Type>     <Type>      <NAME>Debris</NAME>      <CHILDREN>        <Type>          <NAME>Debris1</NAME>  </Type>  <Type>          <NAME>Debris2</NAME>  </Type>      </CHILDREN>    </Type>    </CHILDREN></DATA> The xml_fragments have an attribute that define if they are to be appended to Boulder/Bouldertype1 or Debris/Debris1 etc.. and the xml_fragment's looks something like:<Type> <NAME>Boul

Picture a very curvy stream polygon. I would like to quickly calculate the shortest width and the longest width. Bounding boxes would not be applicable.Thanks,Pete

Hi community,We are trying to retrieve the output of a FME Server hosted 'child' workspace using HTTPCaller (GET) transformer on the main 'parent' workspace.This seems to work perfectly when running the 'parent' workspace on local machine with HTTPCaller getting the output of the 'child' workspace which is hosted on FME Server.The problem:When we upload this 'parent' workspace to FME Server, the HTTPCaller seems to fail. Log as below: HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'Timeout was reached'HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set up HTTPCaller (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered  Is there anything we need to change so that the HTTPCaller works when published on Server too? We are using FME Cloud, so proxies should not be a problem and currently have 2 engines

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,

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!  

Guys!I was under the impression multiple string functions can be performed on an attribute within the one attribute manager, is this not the case? For example, Pad Left string function followed by the Left string function. Anyone know how to write it? I'm trying to cut down on transformers. My particular scenario below in case there's another way around this.Sample data format: (regex: \\d?\\d\\.\\d{2}\\\\ )Pad Left to add any missing leading zeros such as the bottom line.Left to then strip the bracket off the end.Results in bottom line changing to 03.98, the rest simply lose the bracket.

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.