Transformers

According to the transformer documentation:I am using FME Server 2017.0.0.2I have a workspace using 1 FMEServerJobSubmitter (with wait set to Yes).Why do I see the child job as a separate job (with its own job ID)?This is resulting in two separate log files (and I would like just 1 log file).Has this changed in the newer versions?

hey all,I'm using HDFS as my file system.There are FME solutions for reading and writing to Hadoop?Or there is any other practice to use FME in HADOOP context? Thank you for your time.

I am looking on how to convert DMS attached to this question to something like 11.00999945. Any help will be appreciated.Thanks

I have a date field in my excel document which I am reading into FME that contains a mixture of dd/mm/yyyy and dd/mm/yy. Unfortunately, some of the fields just have the year, e.g. 1951. with no date or month.What I'm trying to figure out is how to find just those features that have a year in the date field and then return only those to the inspector.I looked at AttributeValidator but I see it does not have Date as a Rule configuration under Type.

Hey guys, I am trying to build a model which will give me the "null" and "0" count for a number of attributes from my shp. I have built a model using the attribute validator with the Validation Rule "Not Null" to obtain all Null values coming out from the failed output into a statistics calculator transformer where I have "_count" for Total Count Attribute: under Calculate Attributes. To obtain the "0" values for my other attributes I input my attributes in Attribute Validator and used the validation rule "Contains Regex" with the [0] rule configuration. However this is not the correct was a it will also include subsequent zeros e.g.. "10, 100, 1000 etc." My questions are; is the above method the correct and most effective way to obtain Null values and how can I use the regex function in the Attribute Validator or any other transformer to obtain "0" values?Thanks in advance:)!

I was thinking in something similar to feature[+1].Is this possible?

I'm a little confused and hope someone can help me understand why the Feature Information window in the FME Data Inspector shows a value in an attribute, yet the same feature attribute in the Table View shows as <missing>I noticed this because I have a tester that is comparing the nominal focal length fields (one is from a spreadsheet the other is from the database), and this feature is failing at the tester. I knew it had a value in the spreadsheet and database so I used the Inspector to check it.I was stumped because in the Feature Info window, 'NOMINAL FOCAL LENGTH' and 'nominal_focal_length' show the same value, so the Tester should have passed the feature. I then checked the Table View and it shows that 'NOMINAL FOCAL LENGTH' attribute has '<missing>', which must be why my tester is failing this feature.So I'm a tad stumped.

I have a list of attributes that have starting and completion dates listed for different teams. After sorting the starting date column I'm trying to use the first attributes completion date to find the next attribute in the list that has the next closest starting date, then calculate the difference in days. Below is a sample of my dataset. So far I've been unable to find a way to automate this process in my workflow. Any suggestions are much appreciated.

In the drawing screenshot below , lines represent drill holes. Geometry of these polyline features have been correctly drafted based on surveyed co-ordinates. Unfortunately key research data for HoleID , date of drilling and length of hole has only been placed as point text string on the drawing, the drill holes are not attributed.The alignment (rotation) of the text string is generally within +/- 5 degrees of the alignment (angle) of the polyline , and it is also generally placed within 5m of the line. Due to the drilling pattern , using simply a neighbour finder produces inconsistent results , mainly because there may be more than 1 candidate text point within the finders' proximity. In some locations , drill holes are in such close proximity to each other, that the finder returns duplicate matches or matches the holes at right angles.Ideally , the desired outcome would be each line matches one unique text string, taking advantage of the rotation of the text and the line angle to

I'd like my regex to replace the middle underscores with a space. I cannot seem to escape the underscore character to use with curly brackets for repetitions.I have strings with multiple underscores and spaces as word separators. I'd like my result to look like below: word1_worda wordb wordc wordd_word3Sample strings look like: sample1: Autobooster 1_Autobooster Unit_Unit_Autobooster Unit  sample2:Anchor_FIELD_VERIFIED_DATE_NonDisplay With my format these samples should result to: sample1: Autobooster 1_Autobooster Unit Unit_Autobooster Unit  sample2:Anchor_FIELD VERIFIED DATE_NonDisplay I used Lookahead and lookbehind and what I'm getting is the middle string with the underscores between word 1 and word 2 and word 2 and word 3 before and after the result. Regex below\\w(?<=_).*_?\\w(?<=_)Test string looks like belowIf I were to finish my translation I have to use StringReplacer, StringConcatenator, and then merge them back again.

Hi,I have a csv data set that contains addresses and some of them contain funny characters e.g ^ and I am not sure how to find and remove them all easily? I've been using the Tester saying attribute contains ^ but this seems to be a really long process, especially with a large data set. Also, some of the addresses contain brackets at the beginning e.g (house) 1 valley road, which I also want to remove. However, I want to keep the brackets at the end e.g Pyramids (swimming pool) as these contain useful information. The tester isn't working to narrow down how many contain brackets at the beginning and how to remove them? Which transformer shall I use to find and remove funny characters and brackets at the beginning of text please? Apologies if this doesn't make much sense, I am very new to FME. Kind Regards,Jess

Hi FMEler,I got stuck with my FME workspace in the FME Cloud. Maybe @david_r can help me :-)Starting position: We got a Worskpace developed in 2014, upgraded to version 2016. Source is an INTERLIS1 file with a CSV file and some text parameters. The workspace is calculating, sorting, blending areas and so on. The ouput is an INTERLIS2 file (*.xtf) and a text file with some logs. Within the desktop environment everything is working fine.Stopover: We published this workspace to an FME Server instance which we host together with another company. Here, everything is working fine as well. The results are the same.Breakpoint: Now I want to try out the FME Cloud. I launched an instance with a 2016 version, published and ran the workspace. The results are different. The amount of objects are the same. But there are at least some coordinates and TIDs (a primary key for INTERLIS files) missing. I didn't check the log files in detail yet, but I guess it's a reader/writer-problem.My questio

Hi I'm using FME WorkBench 2017 and I want to use the pythoncaller to replace the cell values of multiple raster features with list values of an equivalent size.  The input raster features are:  1. different-sized clips of a larger raster  2. in ASCII format,  3. and have a background value of zero. For each raster, I want to replace raster cell values greater than zero with values from an associated list, where this list is the same size as all the non-zero values of each raster.    I'm new to FME and the python caller, but I would use the following code in a regular python console to perform the task:my_raster[numpy.nonzero(my_raster)] = my_list My confusion lies in correctly using the Template Function and Class Interface so I call the input raster features into the pythoncaller and manipulate them. I am always receiving errors saying that 'my_raster' is being recognised as a string, causing me to think i am not calling it correctly.  Is there also an FME function that has the same 

I'm finally posting here after much experimenting with various raster transformers and not really getting anywhere. There are too many permutations of things I've tried to list here, so I'll just outline my requirements.I have a set of scanned images of map sheets comprised of JPEGs which are 3 band RED8, GREEN8, BLUE8, no palette and TIFFs which are UINT8, 1 palette. I also have a CSV file with georeferencing and clipping data. I can successfully apply the georeferencing data and clip the images.I want to output the results in 2 ways. Firstly, a set of full colour (3 band RED8, GREEN8, BLUE8 in FME parlance?) TIFFs with TFW world files. Secondly, as a mosaicked image in ESRI format - File Geodatabase Raster and/or ArcSDE raster.When I load the output TIFFs that came from JPEG source images into FGDB rasters and display them in ArcGIS, dark pixels (they aren't pure black i.e. no NoData values so they should display) are shown white. If I convert the JPEG to a TIFF

I'm trying to use the FindRegEx Feature Function within the Expression Evaluator Transformer.Does anybody know the correct syntax to use ?Documentation on this seemed a little thin on the ground / no specific examples...........................I'm trying to do a search in the field: [Category]using the RegEx expression: 0[0-1][0-9]I tried the following - but no luck:@FindRegEx (@Value (Category), 0[0-1][0-9])............................Any ideas - most welcome.............................RegardsHoward L'

In a situation where multiple FME servers are spun up and run standardized workbenches, what's the recommendation for managing helper scripts? We have a set of Python scripts that aid the startup/shutdown of these workbenches. But having multiple servers, it is difficult to ensure the versions of these scripts are the same across the board. Anyone have any recommendations for a code repository? We do have a subscription to Visual Studio Team Service. If anyone has used VSTS with FME server, I am interested to hear about your experenice in that as well.

We are risk averse here at Lizard Inc. and we utilize a a three stage dev/test/prod environment to ensure that no bad code or configurations get into our production system. Production must work!!How can we move a working solution from an FME Server development installation to a testing/staging installation and ultimately to our production install?

I have two datasets that I am currently working on:1) DBF12) DBF2I need to lookup for Description (in DBF1) in DB2 within the columns I1 to I8 and >> to return the corresponding DMA to Inflow field if a match is found OR>> to display a space if no match foundThe result would look as follows:Currently, I am using the InlineQuerier with IN statement, but it truncates the result when there is no match. The NOT IN command displayed irrelevant results as well.Please suggest a solution which may be SQL or Non SQL based.

I have two datasets to compare: an original table and a revised table. I want to pass them through the UpdateDetector to track Updates, Inserts, and Deletes. The two tables are linked by a shared primary key attribute, and I want to track changes that may exist in another attribute; however, the original table has an extra attribute, ExtraID, which does not exist in the revised table. For features that exit the Updated port, this ExtraID loses its value. How do I retain the values in ExtraID and prevent them from exiting the UpdateDetector as NULL?

I have a Culvert table with 90K rows. Each culvert belongs to one of 7 size categories. Each category uses a different formula to calculate a culvert's replacement cost. I'm currently using TestFilter to define the size categories. I then route each output to its own ExpressionEvaluator. Is there a way to use a single transformer with a CASE statement to accomplish the same thing?

I have some DTED2 files that I am using to retrieve elevation values from WGS84 coordinates. I would like to modify certain elevation values in the DTED2 file for certain WGS84 coordinates, becuause I have surveyed them with highly accurate GPS equipment and have found certain values to be incorrect. Is this something that FME Desktop is capable of doing.

Hi FME Team  I have a MicroStation dgn-File with sewer-manhole drawn by two circles and I would like to first combine these two circles to an block. This works perfectly with the aggregator function in FME. Afterwards I would like to add some attributes to this block (eg. the dimension of the sewer-manhole).  I tried the "attribute creator". This works fine within FME - but when I export the block to AutoCAD I have lost the attributes.   It would bi great if someone has an idea how to fix the problem.   ... and if someone knows a way to change the name of the block (created with the aggregator function) you made my day :-)  Kind regards Dominik

I have a polygon feature of almost 700k records with a lot of vertices for each polygon (a lot of coastlines etc) and I need to create a csv with a record for each polygon including a list of coordinate pairs for the vertices of the polygon in the format y1 x1, y2 x2, y3 x3... I was doing this by extracting the coordinates into a list and then creating an attribute of coordinate pairs and aggregating all of those pairs into another attribute by UUID. However, I was only able to do this by generalizing the polygons in order to get this workspace to actually run. If I remove the generalization (preferred), then when the polygons are exploded into lists of vertices the workspace runs out of memory before it can aggregate all back together to get the attribute of coordinate pairs. I think I need to do this without creating a list. I've tried using a geometry extractor instead of the coordinate extractor and creating an XML attribute, but I still cannot figure out how to get the format

Hi,I need to download the build 16177 64bit windows version of FME. I can however not find it on the "Past FME Downloads" page (https://www.safe.com/support/support-resources/fme-downloads/archived/). Where would I be able to find the install file for this?PS: The reason I need this specific version is because the client is using this build for his FME Server and I need to modify their models.