Transformers

I have two string fields (TimeStartedCTZone, TimeEndedCTZone) formatted as shown below. How can I calculate the difference in Hours despite having strings as inputs instead of datetime data types?

In 2016.1.1, when trying to add 10 hours to a DateTimeCalculator I receive the following error:DateTimeCalculator_DateFormatter: @Tcl2 -- failed to evaluate expression `DateTimeCalculator_DateFormatter_formatter {FME_NULL_VALUE}' -- wrong # args: should be "string range string first last"  What am I doing wrong?Screenshot seemed to fail upload.Attribute(encoded: utf-8) : `Last_edited_date' has value `20180601010111'

I have a script which is fetching multiple images with an imageFetcher. Sometimes the external services stops responding and the script never stop running. See pic attached showing the last rows from the log.To avoid building a never ending queue I would like to limit this specific script to 15 minutes but I don't find any built feature. I have tried some python callers like timer and time.sleep but nothing really matches the requirement.Any suggestions?

Hi, I've been racking my brains trying to think of a solution to this problem for a few days and no inspiration is coming my way! I have a series of polygons containing populations. The goal is to create bigger polygons from these until they are all within a certain range of population (e.g, between 2000 and 10000). It does not matter if these become multipart polygons.I have used Dissolvers and Aggregators to combine where polygons are touching, however sometimes the populations in the resulting polygons are either: too big (where there is a large cluster of intersecting polygons) or, too small still (because they are not intersecting any other polygons).I have thought about using some form of looping transformation where there are iterations of joining polygons together until the population range is met, then filtering those out and performing the loop again with the remaining polygons.Sorry, it's a bit of a specific question - but if anyone has any ideas around this I will b

Hello Everyone, I have a network of local roads and I need to find the intersecting "from" and "to" streets for select road segments. For example, in the following image, for the circled segment of Hendon Ave, I need to be able to identify that the segment goes from "Grantbrook St" to "Carney Rd". Order doesn't matter. It could be from Carney Rd to Grantbrook St. My network is fully segmented at each intersection. Each segment has the attributes "from_node" and "to_node". The image below shows a typical segment within the network.I am having a hard time identifying the "from" and "to" streets. I tried using spatial relator, which successfully gives me the related candidates. But in a case like this, I will get 4 related candidates. I considered using linejoiners to join Street B and Street A, but I will lose the from_node and to_node information. That information is useful when I have more than 4 relate

This is more to document the trials and issues I encountered writing from a file geodatabase of polygons to an SDE instance with polygons. While one would think that polygons stored in one ESRI format would be fine when written to another and not need validation, that is not the case. Here are the issues i encountered when I switched to FME to find and bypass a bad feature that killed my dataload because of a tiny nearly collinear triangle with area of 1x10^-20...First I tried to just insert straight from GDB to SDE. This gave me the error:An error occurred while attempting to insert a row into the table 'PARCEL_DATA' using a cursor. The error number from ArcObjects is: '-2147215968'. The error message from ArcObjects is: {Linestring or poly boundary is self-intersecting}Then I tried to run geometryvalidator, with these settings, sending both passing and repaired polygons to sde. This gave me the error : Cannot write a non-area feature to an area feature classFurther in

I'm using SQLExecutor to fire queries like this at an SQL Server Spatial point layer (Geometry data type), except the polygon geometries are much more complex:SELECT Count(MyField) AS CountMyField FROM [db].[owner].[table] WHERE WKB_Geometry.STWithin(geometry::STGeomFromText('MULTIPOLYGON (((527049.5 137150.4,527056.6 137139.7,527063.3 137134.4,527049.5 137150.4)))', 27700)) = 1However, after about 2400 features have entered the Initiator port, I get this error and the translation fails:"The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found."Ultimately I will be processing hundreds of thousands of features so I need a solution that will work with that volume of data, not just a few thousand input features.I know I can read the point layer in to my Workspace, but SQLExecutor is SO much faster.Any suggestions?

Hello, Internal auditors are asking me whether any data that is read into FME via a reader is ever detailed in any log files. Does anyone know whether this ever happens? I'm assuming not, but thought it best to check.This is not referring to statistical data that Safe may collect, but data sets we read into FME. Thank you,Daniel

Hido you know if it's possible to replicate the action Collapse Dual Lines To Centerline in Arcgis also in FME.  I tried the centerline repacer but it works with polygons but I have lines not poly (and I don't want to convert lines to polygons).  Can you help me ?  thx  Francesco

Hey,i like to transform NAS Files ((German AAA GML Exchange Format(NAS) OpenData like fachinformation_11001_dba.xml) in a shapefile that can i open with a GIS program.In total, i have 65 NAS Files, the problem i got is, i need for every file a new reader and writer, is it posiible to transform the data with one reader and one writer ? The filename can be the same, like this...fachinformation_11001.xml ----> fachinformation_11001.shx (simplified)Regards Kai 

Hi all,I want to replace not equal to "0" to "1" and if any value missing replace to "0" OriginalAttribute1Attribute2Attribute3Attribute4Attribute5Attribute6Attribute7Attribute8231212301235650 231230231000031240000370232102312234340000320001220023232123120127700   Expected result Attribute1Attribute2Attribute3Attribute4Attribute5Attribute6Attribute7Attribute8110110010100001000011010111000010001001110110000 Please advise

I have a date field called 'Date Started' and a text field called 'Time Started' in military format.Based on those two, I'd like to create a new column called 'Date Time Combo' (shown above) in the following format: mm/dd/yyy hh:mm AM/PM.What's the best method to achieve this?

I have created a sample table below of a much larger dataset.I want to be able to group each ID and then be able to compare the New and Old Values to see if they are the same, in some cases the order is wrong, or there is a semi colon and space or there are duplicates. How do I clean all this out, so that I can make a more accurate comparison of the two columns?

Is there a way to detect parallel lines in a road network and simplify the parallel segments to one main line as shown in this picture? I've tried this with the FuzzyParallelLineFinder but it didn't work and the performance was very low. Thanks in advance. Steven Loosman

Hi, I´m currently struggling with retrieving a Published Parameter via a FMEServerJobSubmitter. The Published Parameter is a Attribute Value, which I have run through a StringConcatentor. Either the parameter can´t be found, or I end up with the Parameter Name as textstring. In short, what I´m trying to achive is to fetch the File-Name of each .txt I produce in one of my Workbenches. This is to allow my next workbench(Via a second FMEServerJobSubmitter) to find the files under the temp Folder. Everything is handled in one "Control"-Workbench. I have also tried to fetch the file Name(path_rootname) via a Feature Reader, without any luck.  Overview of the "Control Workspace" The first FMEServerJobSubmitter and Example issues with Published Parameters According to the log in FME-Server, the File Name can´t be found. Please also see log-File(). I just can´t get my head around what to do. I´m sure some of you smart people have some super intelligent advice to share.

Hey there,I'm stuck! I need to export an Oracle database to a SQLite file. Even empty tables must be in the file. I already tried to understand the suggestions in the articles "dynamic writer to write empty feature classes", "When data is missing, I want to output an empty feature class anyway" and "Copy only Schema to an other database", but none of these helped me. The stumbling block might be the fact that I never know which table with which schema is empty. The NoFeaturesTester might not help here.This is what my workspace looks like so far:To trigger the FeatureReader I read several XML-files to get a list of the desired tables (attribute "FeatureName"). This list is then used as the Reader's parameter "Feature Types to Read". With the output UnusedSuppliers I try to go to the writer directly or with adding a simple point.These are the empty tables (from the output UnusedSuppliers)The SQLite does not contain these empty tab

Hi, I read images from a directory and save them in SQL Server as <image>.I use the AttributeFileReader to create a binary representation of the image which then just gets written into the database (works fine).I also need to create a thumbnail for each image and save it as blob as well. And here my problem starts - I don't know which transformers I need to use:My process looks like that:AttributeFileReader -->RasterReplacer (I need to create an image)-->RasterResampler (I create a thumbnail)-->RasterExtractor (I create binary representation of the image)the result gets written as <image> into a SQL DB table.But when I extract the image from SQL Server (with an different application than FME) the thumbnail is no valid image file (whereas the main image is).For simplicity I uses JPG files only right now.Any idea what might be wrong with my choice of transformers or their order? Many thanks, Rob

HI!I have a published parameter with mulitple choices.When I publish my workbench on FME Server for my web page, it looks like that.I can choose the four options if I want.My choices are sent into an email to some users.The (little) problem is that their aren't any comma between each values. It looks like that : N1 N2 N3 N4Would that be possible to add comma or something else? If I had bigger value's name (like roads name per example), it would be a bigger problem.Thanks. 

Is there any way to assign or place an icon to a coordinate instead of the default "bullet" ? I have the icon, I have the coordinate.I'm aware of the KMLStyler capabilities (in fact, this is pretty much what I need), the trick is I create the output from a generic writer, so we have the ability to create other geo\\cad format then KML. I would like to have my own .jpg icon linked to the coordinate itself, so I expect it to be "see able" whatever the output I've made available.Does it make sense ? Any hint in order to get it done ?Thanks much, regards.

I want to set some system environment variables on my FME Server and I want to do it via a workspace so people aren't attempting to log onto the server machine to do it.I'm using systemCaller and sending this command:setx /m @Value(EVN_NAME) @Value(EVN_VALUE) (the attributes are from a database table)If I'm remoting into the box, I launch the command prompt and runs the command. It's using the fire call account, but the command prompt is being run as administrator.I added the service account that runs FME Server software to the admin group.I can't log onto that box with the service account because it does not have logon privileges so I can't test whether or not that account can even run the command. I know it doesn't run when I run the workspace on FME Server. Error message is: SystemCaller: Failed to Execute `setx /M KMOCShape \\\\hougisproj1\\cmproj\\gis_solutions\\projects\\KMOC\\newfolder'Any ideas what I'm doing wrong? Thanks so much!

The NeighborFinder has been updated at 2018 to return measures with the near values. But does it?It would be great if it worked as documented, and I vaguely remember using it in the Beta. I don't see any new output attributes null or otherwise. I see a lot of hacks in FME Hub for LRS_* operations, (none of them very appealing). I did find a workaround using PointOnLineOverlayer. I assume the extra parameters on NeighborFinder were meant to do the same without an overlay.Is there a way of getting a measure on a Route without chopping up the line?

When trying to merge different WMS layers together to reduce a PDF file size i'm loosing too much image quality. An alternative option that i build is to just add them as extra layers but the file size is sometimes too big for normal use. So my question is: How can i improve my image quality?The ideal option is to get the same quality as you would normally see when all rasters are send to the the data inspector. Like this:But with with nearest neighbour it looks like this:If i use bi-linear it looks a bit better:and bi-cubic looks even better:But it still loses a lot of detail and line quality in the parts that the lines are semitransparent. Is there a option for merging this the same way as the result shown in the data inspector (see the first image) without all the abundance of data that you cannot see? In the end i would like my PDF with rasters merged to be/look the same as the PDF with the rasters as separate layers. I have taken the necessary transformers from my flow into t

Dear community,I would like to create a halton sequence meaning systematic random distributed points. I found the appended python code. To call it: halton_sequence(10, 3) Now, how can I adapt the code so I can use it in the PythonCreator? I would need a list of coordinates to create the points.Thank you for your help! 

Hello everybody,  I try to solve problem withACAD block. I just wanna add attribute definition into block. This block has not any attribute definition, so it is completely without user attributes. If block definition has one or more attribute defition, there is not problem to add new one via FME. But in case of block without attribute, I cant solve, how to add attribute definition.Could anybody help me please?Thank You so much!Lubo

Dear community,I need to calculate the weighted distance from many points to all the others within a radius of 2000m. For this task I combined the NeigborFinder with a ListExploder and a ExpressionEvaluator to calculate the weighted distance per point.Now, the ListExploder produces a huge amount of elements which causes memory issues, although I'm using a 64-Bit machine with 65 GByte of RAM. Is there another way of solving this task e.g. without ListExploder? I think I need the ListExploder to be able to calculate the weighted distance for every point in the ExpressionEvaluator...Thank you for your help,Vincent