FME Form

Question of the WeekThis question was asked in Live Chat this week, but to be fair it has come up several times from various users...Q) I've forgotten the password to the admin account on our FME Server. Is there a way to recover it? A) In short, no! But because the FME Server Support team has seen an increasing number of cases recently where a customer is unable to log in because of a forgotten password, I think it's worth outlining what the options are at this point, and how to avoid getting here in the first place!What's the Default Admin Password?Up until recent FMEs, the default administrator account used to be admin/admin. You can see why we felt that wasn't a good choice, because it's so easy to guess.So now - although the default is still admin/admin - you are forced to change it when logging in for the first time. The username remains admin, but the password becomes one of your own devising.I've Forgotten the Ad

Hi, I would like to share a solution to an issue I had, just to hear what you think about it. The challenge is: to create hyperlinks in a Word document.FME allows you, with the use of MSWordStyler transformers, to create a Word document in a very versatile and easy manner. These transformers, however, do not allow you to insert hyperlinks into the doc.Please see the attached zip file hyperlinks-to-word-python-docx.zip for a workflow where the document is created using MSWordStylers, followed by some post-processing with a PythonCaller to insert the hyperlinks: POIs with a link to Google Maps, in this case.No, I did not write all of the Python script myself, hell, no! I used some existing bits and pieces and tweaked them a little bit to get the job done.The add_hyperlink function was found on

Recently I have been playing/fooling/struggling around with the creation and modification of Word documents using a combination of MSWordStylers and the Python docx library, called from a PythonCaller. A very instructive journey :-)To make sure I don't forget immediately everything I've learned, I have decided to summarize my findings in a template. And because a lot of input has come from this community I will share the results here. Please see the zip file attached: images-to-table-python-docx.zipIt starts by reading Parcel information from a database (gpkg) and it creates a summary table in a word document, including a little image with the parcel plotted on an aerial image.Inspiration has been taken from these to discussions:

hello i’ want to assign one single elevation(Z) for all the vertices in a polygon based on the elevation point available inside the polygonplease suggest any ideas  

Hello... I’m new here, and I have a basic question. I’m trying to update a hosted feature layer in AGOL, but I have a 400 error about HTML. I check my attribute table, and I have one attribute with notes (string), and the character that I have a problem with is <, but I cannot change it because I need the information. So, I cannot use the text encoder or change the character. Can anyone give me an idea of what I can do?  

I have a project to automate creating an OWX file to import into IHS Kingdom Geoscience project. I can manually download an OWX well header file from Enverus Prism. This file is in ascii format and can be viewed in Notepad ++ . I do not see a transformer the can read or write the wellheader.asc file. My guess is I would need to create a custom transformer and then parse the data. Landmark may be the original vendor to use this OWX file format. 

Hello I would like   to move the rectangle in the direction of  right side ?fme 2021thanks in advance 

Hello everybody.I'm stuck I think over a trifle.I have a dataset with dates like "1970".I want to create a column allowing me to have date classes in it (for example [1970-1980[ ).It seems to me that I need to go through a testfilter and a creatorattribute but what I do inside doesn't work.Could someone give me a hand on the operation so that I understand how it works?Thanking you very much in advance

Hi, we had "FME Desktop Database Edition - Fixed" installed on a linux server. Somehow the application has been removed/deleted from the server and we can't launch FME app: 1- If we have to reinstall it, do we need to uninstall first? 2- How do i download "FME Desktop Database Edition - Fixed" for Red Hat linux (release 8.9 (Ootpa)) from https://engage.safe.com/support/downloads ? 

I have it reading some JSON files and some go through and others dont with an error of "INVALID_FILE_INACCESSIBLE". The file sizes range from 500Mb to 8Gb in size.

Hi,I am trying to publish a elevation mosaic dataset as a elevation layer to portal but it is rendering as imagery layer. The sd draft created in the script does not allow me to set Lerc as compression and the default is PNG8.Can anybody help with ArcPy publishing for elevation services ?

hello There we  number of hexagon feature and we want to sample them , but the sampled features should not have any spatial relation to other one , in other terms should not touch the other sampled hexagon Thanks  

Hi there,Relatively new to FME and very new to JSON and API’s. I’m working with the Smartsheet API and I’m stuck on how to the get the data set up properly, I’ve gone down many of the JSON Transformer rabbit holes and I can’t find a similar example to how this data is set up. When I use the JSON Fragmenter, I get columns and rows returned as separate arrays:  The columns are set up like this: And the rows/cells:I’ve gotten as far as exposing the attributes for each array separately, but I don’t know how to get cells back to the

My dwg writer is saving as type ‘file’ with no dwg association. How do I write as dwg and can someone explain what causes this?Thanks!

 File "C:\Program Files\FME\python\requests\adapters.py", line 348, in get_connection    raise InvalidProxyURL(requests.exceptions.InvalidProxyURL: Please check proxy URL. It is malformed and could be missing the host.2024-04-02 08:44:16|   0.1|  0.0|ERROR |Error encountered while calling method `input'2024-04-02 08:44:16|   0.1|  0.0|FATAL |SalesforceConnector_CALLER (PythonFactory): PythonFactory failed to process feature2024-04-02 08:44:16|   0.1|  0.0|WARN  |An error has occurred. Check the logfile above for details2024-04-02 08:44:16|   0.1|  0.0|INFORM|Translation FAILED with 4 error(s) and 1 warning(s) (0 feature(s) output)2024-04-02 08:44:16|   0.1|  0.0|INFORM|FME Session Duration: 4.2 seconds. (CPU: 0.0s user, 0.1s system)2024-04-02 08:44:16|   0.1|  0

I’m using a HTTPcaller connect to a swagger API that ONLY receives raw JSON data in the Upload Body or uploading a file (one block of JSON data per file). I can’t pass through any parameters from a attributemanager. When I try to pass through a parameter in the Upload body of the HTTPcaller, I get this error message:Attribute(string: UTF-8)          : `_response_body' has value `{"errors":[{"code":400,"message":"A non-empty request body is required.","title":""},{"code":400,"message":"The dto field is required.","title":"dto"}]}'When I try to pass through {“active”: true, “firstName”: “@Value(firstName)”}, I get this error: Attribute(string: UTF-8)          : `_response_body' has value `{"errors":[{"code":400,"message":"The dto field is required.","title":"dto"},{"code":400,"message":"',' is an invalid start of a value. Path: $.active | LineNumber: 1 | BytePositionInLine: 12.","title":

I have a set of line data that I wish to buffer for a client.The requirements of their GIS system are such that the shapes must not be 2D reentrant, lack donut holes, and be OGC Simple + OGC 1.2 compliant.I buffered the lines to .0003 ground units (coordinate system is in degrees)Input feature qty is 9287.The validator only passes 8175 of them.Every failure reported from the listConcatenator is “Fails OGC Compliant,Fails OGC Simple”.Is there something that I’m doing wrong?

Hi there :), I’ve been using RasterConvolver in FME Form 2023.0.1 to calculate the standard deviation with a round kernel, so some weights were equal to 0. The results were always incorrect, so to understand what’s happening I simplified the problem and used a raster with all values = 1 and one weight in kernel (3x3) = 0.From what I understand, the formulas used in RasterConvolver for calculating the weighted mean and weighted SD are a bit off. Here is what I deducted:The weighted mean is divided by a number of values (kernel cells) instead of by the sum of them. The weighted SD: in the sum equ

I’m using Pro 3.2 and Data Interop extension with a simple workspace to pull point features from a SQL server database and publish them as a layer in AGOL, all within AWS on an ec2 instance. I have this scheduled to run every 15 minutes so users get fresh data. The workspace also uses an HTTP call to make the layer editable just before overwriting it, and then a second one after writing, to disable editing, because the layer is public. Seemingly intermittently, the file geodatabase used to publish the layer will not get deleted. I have the fgdb that was originally used to publish the layer still there in the same folder as the layer, but every so often another fgdb will be created and left in that folder too, so I get duplicates. Some mornings I check and there are 3-5 or more of them. I can manually delete them, but I’m trying to determine why they’re not getting deleted in the first place. I’ve checked the logs and can’t see anything out of the ordinary. I tried addi

I have a non-spatial table with about 5 million records of XY coordinates. I need to update the table with the Lat Long values in the so-named columns.I am facing problems with writing these to the table. When I choose UPDATE/UPSERT/fme_db_operation, the writing takes a seconf for every 10 records. It’s impossibly slow.When I choose, Insert with DROP and CREATE or TRUNCATE EXISTING, the script gets stuck with following last 4 lines in the log: Writer `MSSQL_ADO_2' of type `MSSQL_ADO' using group definition keyword `MSSQL_ADO_2_DEF'Microsoft SQL Server Non-Spatial Writer: Opening `GISReporting' for write operationMicrosoft SQL Server Non-Spatial Writer: Read 1 DEF line(s).  Found 9 attribute(s)Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver 19 for SQL Server...MSSQL_ADO writer: Splitting bulk features into individual features  NOTE: I have set BULK Read and Write at

Hi everyone ,I have dynamic doors in my dwg AutoCAD file :If I click on the small arrow the door changes direction , and the big arrow changes the size of the door I want to read on fme the default position and size of the door , just like a normal static door. But here is how the DWG Reader reads it :   Any Insight is much appreciated !-Yagami

I have a DWG file with unknown CS but I know the CS it just needs to be assigned to the DWG. When I set the CS when I read the DWG then it appears in the correct location on the Earth but once I try to write it, it doesnt write the CS info and it appears again in the false location on Earth! I also tried “CoordinateSystemSetter” but with no success. On FME it appears good while transforming but not in the resulting DWG. Any Idea?

I have many workbenchs and some of them are quite complicated. I would like to write a description of all the steps. Are the workspace parameters the best place to write the description and the steps?  Thanks :)  

Hi All,Quick question in regards FME & ArcPy: I have been able to create a Python script that overwrites a ‘tree_ID’ field on AGOL based on the sum count of the three geometries (point, line and polygon). Basically the script does the following calculation and assigns the IDs, example below:Point = 3 featuresLine = 2 featuresPolygon = 2 featuresTOTAL = 7 features ID to update on AGOL 1,2,3,4,5,6 and 7The python works fine as the AGOL feature hosted layers have been updated with the new ‘tree_ID’ but the PythonCaller stops with the following error: ‘PythonFactory failed to load python symbol `FeatureProcessor'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date’ 

I’m using the JSON reader to read in a folder of JSON files. The reader is working how I want it to, however I would like to get the original file path/name as an attribute on each feature.  Is there an easy way to do this? I’m hoping that I am missing something silly.