FME Form

I have pull and transformed a series of table from a MS SQL Database. I am now trying to using FME to enter them into a specific sheet starting as a specified cell.  I feel like this should incredible simple, but I struggling to get it to do what I need.

Hi There, so our IT Department is now implementing a 'no password' policy with using our organization's (s)ftp sites. WinSCP does provide a method to use the key file generated by OpenSSH (please see attached screengrab)...but I can not see a method for leveraging this file in FME's FTPCaller...is this true? (so no way to do this in FME?). Thanks for any thoughts here.

If I have addresses in an address field formatted for example:1234 Elm St ...and I want to remove all spaces to change the field value to look like this:1234ElmSt What Transformer and Parameter would I use?

Hi There, So I am using the: safe.microsoft-sharepoint.SharePointOnlineConnector to download and create .xlsx files in my organization's SharePoint site-- and this transformer is awesome save for one fatal problem...the problem is that the connector only appears to be able to Download or Upload/Overwrite files--but it can not Update existing documents at SharePoint. And the problem is that if a user has the .xlsx document open (in a browser session) the Upload will terminate / fail until all users have closed out of their browser sessions viewing the document. My question: is there a way to Update documents at SharePoint that are being viewed, or is Overwriting the only option. And if the latter is the case, is there a way to terminate all open user sessions of the document at Sharepoint so that the new version can overwrite the old version...Otherwise this transformer, great as it is, is somewhat useless. Any thoughts on this issue, or is it just another "Curse

 how can I separate the data into separate columns? E.gDate                         Information           result 2023-02-20 07:24:00         inform             Current FME version: FME 2022.2.0.0 (2022110) 

I am trying to automate creation of highway markers along a highway line feature class. I have been able to create the points along the highways at the correct interval (Using the DistanceMarker transformer) but I can't figure out how to apply the correct distance along that line (in Kms) to the newly created points. Ie. 2km, 4km, 6km, etc. in an attribute for the new point features.

Hello,i would like to transform a .csv list which contains adresses with a given latitude and longitude to dxf/dwg file into my local coordinate system (AUT-GK31-5). The exported dxf/dwg should contain a point with the transformed coordinates. thank you for your help - i am working on FME workbench 2019.0 input: (wish) .csv or excel lat: xxxlong: xxx(text: xxx) output:dxf/dwgpoint: (correct transformed coordinates - AUT-GK31-5)(point-text:xxx)  Christoph

I have one feature, which has two geometry points with text location. I only need one of them. Is there a possibility in FME to delete every geometry, except one?

Hello,As the question group suggest I am new to FME. ATM am doing some test with a .LAZ dataset (825 tiles about 60km X 60km)1-What I want to do is read in the folder were the LAZ files are and read in a shape file (the 60x60km box). 2-clipper, to only use the LAZ tiles that are within my polygon.3-RasterDemGenerator to create the raster in this case a DSM because there is no filter).4-write to .TIFThe main problem here is processing time. I am new but I feel I need to do something about the processing time so I looked up what I can do about it.1 Tiling. If I understand correctly, I can create 7 workers from a main project. So, in my case dividing this project in 2x2 or 4x4 (3x3 would already take 2 runs so logically 4x4 would be my next choice).2 parallel processing. I tested https:/

Dear Altruists, I am trying to convert NetCDF evaporation data to further processing, e.g. aggregate by month or calculating average value etc. However, I am struggling in the basic steps to unfold the multidimensional variables. When I am reading the data in NetCDF reader, it returned some attributes where I cannot see the lat/long or date file. But after using AttributeExposer to get the netcdf_subdataset_name; there I see lat, long and evaporation (apet) name but not sure how to get the values of these variables. I am given a python code in which the developer wrote a function to process the .nc data. Can anyone kindly tell me what FME transformers I need to use the replicate the python process as below: def funt_1(fileName, points, var):  nc_fid = netCDF4.Dataset(fileName, 'r')  prbc = nc_fid.variables[var]  lats, lons = nc_fid.variables['lat'], nc_fid.variables['lon']  time = nc_fid.variables['time'][:]

Writing to an Esri Geodatabase (File Geodb Open API) fails with this error: ‘Geodatabase Error (-2147219115): The row contains a bad value. There's an empty table created instead of a point layer.The error suggests that something's wrong with the schema, but I can't find the cause. The issue stays even with only one feature and limited number of attributes.Writing the result to a shapefile or to SQL works fine. FME version is 2022.1  Anybody had similar issues with the Esri Geodatabase (File Geodb Open API) writer and knows how to solve this? Thanks, Ruth  

Hi all, I have an "issue" that is frustrating me to no end (probably because the answer is more simple than I'm making it), so I thought I'd run it by the community. I have a workbench where I am taking AGOL features and converting them to a dwg. The AGOL geometry that is giving me issues are the AGOL polygons after they are sent through a CLIPPER:  I understand why the 'RESULT' is passed through the CLIPPER and spit out as polygons still. And I have them also going through a GEOMETRY COERCER (to fme_line) and even a LINE ON LINE OVERLAYER -- all good to this point.  What I cannot figure out is how to remove the unwanted lines to obtain the "DESIRED RESULT", which would just be lines once they get into AutoCAD. There doesn't seem to be an attribute that I can use to

When publishing a workbench to FME Server under my username and configuring it as an automation or schedule, what is the best practice as every time my username requires a password change the automations/schedules fail. Then one has to go in and modify the connections to update them so it will accept the new password. We are using AzureAD.

I have a StatisticsCalculator that determines the min and max time values in a data set. If I feed the time.min and time.max into a TestFilter to filter out values from another table which are outside of the time.min and time.max range, the filter doesn't filter properly but if I use the actual time value is does. What do I need to do to get the TestFilter to work with the FeatureAttribute?

I'm trying to open my workbench, the .fmw, but when it opens it shows an empty canvas. The workbench (.fmw) is 3.5 mb, the recovery file is empty. It was made with FME Workbench 2019.2.  I've been working days and weeks on the workbench, and foolish enough, my last 'handmade' backup is a week old.....  Is there a way to recover the .fmw file?  

Hello, I am currently trying to process an output from the JSONformatter that has the below structure: name_1:"value_1",name_2:"value_2",name_3:"value_3", etc. The output I want to achieve is a feature set as per the below: name_1 name_2 (as columns)value_1 value_2 (as values) I am able to achieve it to an extent using the JSONFragmenter, but this seems to work only for 1 feature (i.e. name_1). I have tried to use the "+" as explained in the documentation but this instead produces a second row, rather than a 2nd column. May I ask for your advice please? Thank you, George 

From Attribute Manager I have about 150 columns on which I have to run a series of condtitional query's to populate them. So far the only way I have found to do this is to open each "else if" option individually and adapt the text contained. The change could be easily done whith a simple "search/replace" process within a text editor such as Notepad++. The attached image shows the text circled in red that needs to be replaced with a another constant value.  Unfortunately I can't find any way to make those changes within FME's "text editor" in the Attribute Manager". 

Running the attached translator : Test_Pole_geodatabase_file2geojson.fmw, returns the attached Test_Pole.json, but I need the attributes: MEASURE, ACCURACY, VISIBILITY to be nested under a new "QUALITY" attribute. The translator returns this: { "type" : "FeatureCollection", "name" : "Test_Pole", "features" : [ { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ 5.0735809934, 60.6100338064, 36.882 ] }, "properties" : { "OBJECTID" : 1, "HREF" : "foot", "STATE" : "existing", "MEASURE" : 99, "ACCURACY" : 500, "VISIBILITY" : 40, "MATERIAL" : "metall", "TYPE" : "high voltage", "INFORMATION" : "Example of high voltage" }My goal is to achieve this:{ "type" : "FeatureCollection", "name" : "Test_Pole", "features" : [ { "type" : "Feat

Hello,  I regularly save a file in a GDB (GDB-Name\\Topic_<date>) and want to display the differences a week later. Manually - I enter the file names myself - this works wonderfully, but it always requires a manual intervention to enter the correct names. Now I would like to automate this work. For this purpose, I calculate a variable using the transformer "DateTimeCalculator", which calculates the date of the last execution of the script (-5days). Afterwards I want to read the last table (GDB-Name\\Topic_<date - 5days>) from the GDB using the FeatureReader. My problem now is that I do not manage to specify the correct table within the GDB, or the correct number of features is output at the Generic Port, but without geometry and attributes. So my question is, where can I specifiy the correct tablename? Could someone please help me to solve this problem? 

Hi there,  I am trying to publish from an Enterprise geodatabase layer into an existing AGOL feature service however get the following error.  I have tried setting the projection, used the Reprojector and Esri Reprojector but cannot seem to get past this issue.  Any pointers? Thanks!

I have a shapefile with parcels. With the transformator "MapTextLabeller" I am able to add the correct numbers to every parcel, and orient them correctly with the rule. How can I save the text labels in a shapefile or another data source in a way that preserves the labels created by the "MapTextLabeller" transformer, as seen in the FME Data Inspector? While the final result is visible in the data inspector, writing the labels again in a shapefile does not produce the same text labels. What steps can be taken to properly save the text labels, and ensure that they are encoded and stored correctly in a field of the output file? 

Hi, I run a workspace in FME Workbench 2021 that outputs text files to D drive of the Computer. How do a enable FME to output text files to a server (file director) location?

HiJust looking at the AR objects, there doesn't seem to be label/text. Would you need to do this via images?I want to have labels in a street as you pan around.thanks

I'm getting errors while I extracting data from FME API The Error is "A JSON syntax error was found at line 21, column 1691Unexpected non-whitespace characters were found after the JSON textUniversalReader -- readSchema resulted in 0 schema features being returned" API Link is 40.76.139.235/fmerest/v3/transformations/jobs/id/238492/log?fmetoken=776f34b59676c6271de9b4735a0d13a8ac2acb0a 

I am working on a national dataset for Australia. The initial dataset had points that are converted to polygons based on the parcels they overlap using the Spatial filter transformer. For the points that do not overlap with any parcel, a buffer of 20m is created. Both the parcels and buffers are combined and exported as a dataset. I'm trying to filter those polygons created with buffer of 20m. Logically all the circles should have the same area and length but it is not the same. I wonder if it is because the dataset was in the Geographic Coordinate system when the buffer was created. However the formula works, is there any way we can filter all the polygons in the shape of circles? It is not working with filtering by area since I have to add a range and it is filtering other parcels which are not circles.  I appreciate your response in advance. My boss thinks it's very simple/logical but I can't seem to find a way to filter these circles :(