Transformers

Does the SchemaScanner add an extra character to the fme_varchar(n) attribute?

Greetings,I have a weird issue where the ESRI FGDB writer runs with NO error messages.It writes out to an ESRI Shapefile, but the FGDB has 0 records???This is the FME output Total Features Read                                                      68587=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-                           Features Written Summary=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Hazards_3857_20230613_Geom                           11021Hazards_3857_20230613_NoGeom                         11021Hazards_3857_Geom                                    11021============================================================================Total Features Written                                                   33063   The output in the FGDB? Any assistance is appreciated, it is really frustrating. 

Hi, I am reading a bunch of asci files and use a raster mosaicker and trying to write to a raster or mosaic dataset.I have trued seting creating new attributes geodb_raster_path set to fme_dataset and geodb_raster_type to 'Raster'. or 'Raster Catalog'I am getting error message: The raster type 'Raster Catalog' for mosaic dataset 'zzDataset' is not supported by the installed ArcGIS version 

Hello. I would like to ask. I have a workspace where, see the attachment, I have set a time filter (red frames). I would like to store various dates in this format in the database, for example the date for each specific month. Each cycle, a new date from the database would be automatically replaced by this filter based on the number of validly executed workspaces. Can this be solved somehow? I would probably solve the individual cycles with some kind of "counter" transformer, it will be more complicated to insert the date. Go in the direction of some parameterization? How do I ensure that the correct date is always set on the test filter? Thank you very much

I am doing the completion date subtracted by number amount(200 days) using Subtract Interval or Interval between dates using the completion date - DateTimeNow. the FME rejection code is INVALID_INPUT. Any suggestions is greatly appreciated

Can we migrate the data directly to Esri UN model geodatabase instead of migrating to Asset Package GDB, using FME Desktop?

Hello, I have a dataset that looks similar to the image shown and I need to create the value in the attribute ROUTE shown in red. I need to create a new value for ROUTE whenever Duration>1 or Duration is Null. The data needs to be sorted firstly by Name, then by TimeStamp.Then, whenever the previously mentioned condition of (Duration>1 or Duration is Null) is met, a new value needs to be created for ROUTE. How do I create a new value (with for example a new sequential number) whenever I come across (Duration>1 or Duration is Null) in my sorted data?

I have SQL SERVER DATA where ii need to migrate views only to Snowflake is there any way to create the views in FME and migarte data SQL Views to snwflake

I have a polygon (shp or minfo format) assuming it has an area of 5 square miles. Need to reduce the area by 70% resulting to 3.5 square miles now but still keeping somewhat the outline but of a smaller size (like polygon output shrinks) due to the applied percentage. SCALER transformer is closed to what I need but it only applies the percentage to the total perimeter of the polygon and not the area. Any transformer that could do this?

Hi,I need to calculate the least-cost path from a destination point to a source. In ArcGIS I use COST PATH based on the least-cost distance raster (by Cost Distance tool in ArcGIS).is there a way to do something similar in FME? is the Network cost calculator transformer appropiate?Best regards,Felipe Verdú

But I cannot find the proper way to do it here. I am sure it shouldn't be complicated but I am new to FME with thousands of questions. This is just one of them 😅

I am working with two datasets and I am trying to use Spatial fuzzy matcher to find if there is a similar name nearby within the mentioned distance in this transformer but wherever the fuzzy ratio is 1 it is not there.EG : here I am tryimg to find if there is 'Heavy inlet' in another dataset or similar string, it has mentioned its fuzzy ratio as 1 but there is nothing similar to this near or in the entire dataset.:

Is there a way to easily pull all of the SQL statements out of all of the SQLExecutors in a workspace? I have several automations that I need to do this for and some of them have hundreds of SQLExecutors in them.

Hi FME, I have a dataset with date/time stamps where I need to retain only the first occurrence in each hour, on a given day. For example: 1/1/2000 12:05 --> Keep1/1/2000 12:10 --> Discard1/2/2000 12:05 --> Keep1/2/2000 12:15 --> Discard1/2/2000 12:59 --> Discard1/3/2000 12:00 --> Keep1/3/2000 12:12 --> Discard Thanks for taking a look!

Hi!I have an issue that I just don't understand.  Using a FeatureMerger that outputs the correct attributes från the supplier, but it's values are all wrong. First off, I have a TestFilter with output ports depending on if the attribute "Version" is 0, 1 or 2. In this case the output for Version 2 contains 4 points with relevant attributes according to the image below. They are all "Version" 2 and have missing values for "Avslut-datum".Next, I want to use a FeatureMerger to merge this with a bigger database with hundreds of points, to assign the attributes of Version 2 to those said points, if they match. I want to merge the points from the bigger database [requestor] to the output from my "Version 2" [supplier]. See the FeatureMerger parameters in the image below.However, the merged data does not contain the attributes from "Version 2". For example the attribute "Avslut-datum" should be <missing> and the "V

Hello,I'm using a customized projection system that is exported to other official projection (Lambert 93, Lambert zone 2...) and I would like to run these transformation within FME. For ex, here are the steps going from 2154 to my custo projection:Prime Meridian Paris to Greenwich then:{LambertConformalConic: a=6378249.2 f=293.4660212936269 lat0=46.799999999999955 lon0=2.337229169999998 k=0.99987742 (inv)}{GridShiftTransform(NTv2:rgf93_ntf.gsb (Inv))}{LambertConformalConic: a=6378137 f=298.257222101 lat0=46.49999999999996 lon0=2.999999999999997 k=1 }{AffineTransform2D(ScaleXY(1,1) Rotate(0) Translate(700000,6600000))}How to define this in FME?

I am trying to use the Geodatabase_SDE writer to publish some content on Workbench to our Enterprise Geodatabase environment. However, when i add the writer to my workbench and browse the list, i find that the Geodatabase_SDE writer is greyed out and there is a popup that indicates i do not have sufficient licensing. For reference i have an ArcGIS Advance License that i use on the daily, and both FME and ArcGIS are using the same License Server. The message doesn't specify if i am missing the ArcGIS or FME licensing to use this writer. Any help is appreciated so that i can move in the direction of progress. *I am not our ESRI software Admin, but want to make sure that when i reach out i don't slap myself on the forehead because it was something i missed.

Is there a way using a regular expression to split a string of text such as an address by a number of words/spaces? Or even more functional, split a line at the first space after a certain number of characters?

Hello Forum. I have two polygon datasets (see attached image). I'd like to create a third polygon dataset showing me the sections of A that do not overlap with B. So, it would create me the polygons as highlighted in C in attached image. I could do this via a few steps in a desktop GIS but I need to include it as part of a larger automated data flow in FME Desktop (Form). Thanks,

I have authored a workspace that creates bills for a lot of customers. The item price on the bill has to be returned with 2 decimals, so I take the mean of all the item prices and ceil the number to 2 decimals. Because of an occasional outlier I can't rely on normal rounding function.In the case below I have 1.173 measurements with an item price of 0,43. The min and max is 0,43 and the range is 0. But the mean value is != 0,43. And since I have to use the ceil function the price changes to 0,44. I understand this must be caused by the internal handling of 32 to 64 bit conversion, but in this case a seemingly very simple operations doesn't work. Why can't I rely on the mean calculation?What can I do to rely on it in the future? 

Hi, I'm running a simple workbench that converts a single dwg to GeoJSON. when I start the process normally in FME it works fine. But when I make a bat+tcl I see that the path to the dwg file changes and there is a "\\" missing between the folder (Linjedata) and the dwg file (T_E6SL_P00_f_C_E6-Profillinje.dwg) (AutoCAD Reader: Error opening file 'C:LinjedataT_E6SL_P00_f_C_E6-Profillinje.dwg' during version check) Is this something I can change in the tcl file? However, I got around this by putting the dwg file on C:, but then I only get a new folder with the same name as the dwg file with an empty file called "C" inside as the result, instead of a GeoJSON file. What I'm trying to achieve is just the same as when I start the workbench in FME, but run as a bat file.

Greetings, I have tried several formulae, but no convert metric to DD??Any suggestions appreciated.@Value(_inside_x)(@CoordSys(EPSG:4326)) @Value(_inside_x(@CoordSys(EPSG:4326))ThanksClive

I would like to output an excel template with one of the columns having cells containing values from a pick list.  From my understanding I don't think FME is able to output the picklist, but a possible solution is to have the pick list already defined in the excel template.  However, even if I have the cell defined, I do not know how to have it replicated for each row that is outputted from the FME template. Do I have to just fill the entire column with the picklist and than delete the extra rows after the fme template is run or is there a more elegant solution. Thanks

Dear All, I would like to read an excel ''configuration input file'' which contains the values that will be used to set the ''User parameters'' (2 columns table : first column giving the variable name, second column the value that the variable should take). Is it possible to that ? Can the ExcelReader parameter ''Read Form Control as Cell Value'' be used for this purpose ? What does this parameter ? I found no information about it in the help and tried a lot of things without success... Any help would be welcome !