FME Form

Hi,I need to set log file path as a parameter. So I ‘ve added User parameter LogFile and linked it to log file inNavigator-Workspace Parameters-LoggingI’m running my workflow as follows:"C:\Program Files\FME2\fme.exe" C:\FME\mz\WybranaSiecPomDgn2k.fmw --LogFile "c:\Folder1\File.log"The problem is, that “c:\Folder1” folder does not exists, and the following error appears:“Unable to open log file `c:\Folder\File.log'. The preceding error has occurred during FME logfile setupProgram Terminating”I was trying to create “c:\Folder1” folder using Scripting-Startup Python Script, but it doesn’t help, probably because FME tries to create log file before Python script execution.

I have a user parameter that I use when writing out the file in Form ("$(ProjectID) Report.xlsx"). This works as I want when running in Form, but not when I publish it to Flow. The parameter doesn’t get set a part of the filename (_Report.xlsx).Any ideas what I need to do differently to get the same filename in Flow that I get in Form?

Hi team,I’ve noticed a bug within FME 2024.2.1 (Build 24801)… When I’m building out a workspace and reference a Password Deployment Parameter in a reader. If I edit that or any other Reader or Writer under the Navigator (i.e. Right Click, Update Reader, make changes and click OK), it will drop the Password Deployment Parameter, anywhere they are referenced.Text based Deployment parameters remain, but it just drops the Password based Deployment Parameters. Has anyone else seen this issue? Once they’re all set and we publish, it seems to retain them, but it’s only after we update the Reader and Feature Types.

Does anyone leverage FME with Agile Assets? Curious how you connect to it and what you do with it. Thanks!

Excuse me, I am a master student. During one of my curriculum module, I used the Cesium 3D Tiles Writer in my project. And the result is not good: As we can see, some of the lines of point cloud is missing.And during the procedure of translation, I ahve warnings like this:What’s more, is that the result put all points inside the same pnts file:

Hi @Safe !I have a probleme with Geoparquet reader on FME Form 2024. It does’t work with the file in attachment but work fine with Apache parquet on FME Form 2023. The error is :Thanks for your help.Loïc

Version: 2024.0.1.0 I am trying to write a new dataset to ArcGIS online, keeps getting this error code: Message Type: fme::internal::_v0::py::ExceptionPython Exception <AttributeError>: 'NoneType' object has no attribute 'get'ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for details 

I am writing AutoCAD DWG with changing areas/extents. My template file defines the styling. When opening the file in CAD it zooms to a blank area (possibly from the extents of the template file) and I need to zoom to extents to find my current area. Is it possible to either remove any extent information from the template file, or force the output DWG file to zoom in on the current area extents?

I have a closed polygon dataset that I need to add angle labels to the internal angle.I just wanted to see if anyone has done a similar thing or has some advice on the best way.I am using the “VertexAngleCalculator” transformer which gives me the results for the actual angles but need to figure out the before and after lines to the calculate the position and angle of the label so it is just offset from the vertex and angled midway between the before and after lines towards the interior of the polygon. 

The documentation is not entirely clear here for how to upload files to a ACC store using the AutodeskDocsConnector.I seem to be able to upload folders..However when i try to upload files i get an FME rejection message that says. Any ideas?'NoneType' object has no attribute 'status'AutodeskDocsConnector  

I am trying to find shortest distance from all points to all other points in my dataset.the data set contains network lines and points The points feature has only types (A,B).100+ points of typeA and 500+ points of type B.Is it possible in FME  to have the short path finder to search the short path always starts from point A to pint B.Then write the output to writer. 

I updated FME Flow from 2024.1.1.1 to 2024.2.1. After the update Version Control isn't working anymore.The Fetch From Remote-button works fine, but when I click the Push to Remote-button I get this error:Could not push to remote repository. Cannot invoke "org.eclipse.jgit.transport.RemoteRefUpdate.getStatus()" because "refUpdate" is nullDoes anyone have an idea what the problem could be?(I already created a support ticket with my local reseller, but they haven't seen this issue before)

I need to generate a list between two numbers and repeat a value the number of times between the two numbers. The values need to generate the number of rows between the higher ranked value and the lower ranked value. Below is the data I have now, and the second screenshot is what I need generated. Thank you for the help.What I have now:What I need: 

Hello,I'm having issues trying to connect to the my Portal that is using OKTA - Auth2 to login.I've seen a fee threads on here regarding this issue but does not really explain clearly oon what to do.  I get this error "OAuth2 Approval Please copy this code, switch to your application and paste it there: " I followed the steps to register FME in Portal. Filled in all the correct info in the Manage Web Services. I put in my crednitals and get that error. I don't even know if it;s an error. I just dont know what to do at this point ? OAuth2 Approval Please copy this code, switch to your application and paste it there: "  I've seen a couple threads, but didn't really give an answer just said to submit a ticket.

Hello,I can Successfully connect SharePoint list in workflow , can perform Insert operation with no issues, as soon as Change Detector finds the record updated from Original Key field with Revised Key field values with update transform in SharePoint list, i am getting error for FMEException -  where last part the PRIMARYFIELDError:Python Exception <FMEException>: FMEException: 929309: Microsoft SharePoint List Writer: Client-side error: '400 Client Error: Bad Request for url: https://cambridgeca0.sharepoint.com/sites/DesignDeliveryDigital/_api/web/Lists(guid'0c80c870-8721-4543-9550-0fedbed2eeec')/Items(PPM01256)' returned from SharePoint. Error message was: 'The expression "web/Lists(guid'0c80c870-8721-4543-9550-0fedbed2eeec')/Items(PPM01256)" is not valid.'  

Hello everyone, I've recently been doing some work using HTTPCallers to connect and authenticate to an API. The basic flow is that the first HTTPCaller hits the login endpoint. The credentials (username & password) are passed as application/x-www-form-urlencoded values. An XML response is sent which contains a Session ID. This is then passed through to all subsequent HTTPCallers via the header as Cookie - ASessionID=<Our session ID>. This all works very well, but I've been asked if I could move the whole authentication part into a nice secure easy to use Web Connection. I've done similar before, so thought this would be a fairly easy task, but alas, I've hit a bit of a wall when it comes to the Access Token Response. Unfortunately, the login call to this particular API only returns XML and will not return a lovely JSON response for FME to parse and handle. I was under the impression that FME should be able to look at a JSON or an X

Does anyone have (or know where I can find) the workspace and sample data for the Travelling Salesman blog post from 2016 (or later)?https://fme.safe.com/blog/2016/11/fmeevangelist158/ ThanksDavid

Hello, I’m struggling with the logic/approach on this one. I have a spreadsheet of fuel filters. So in the spreadsheet, it looks kind of like this: Unit#/Fuel 1/Fuel2/Air 1/Air212/abc123/abc223/airf123/airf12413/abc123/abc212/airf123/airf124 I want to create output data that looks something like this: Unit/Filter Class/Filter Number12/Fuel Filter/abc12312/Fuel Filter/abc22312/Air Filter/airf12313/Fuel Filter/abc12313/Fuel Filter/abc212 Hopefully this makes sense.Any thoughts on an approach, or some transformers I should work with? Cheers!​​​​​

Hello,  Using a SQl executersyntax: update <table name>  set date_start= to_char(sysdate -1,'dd/mm/yyyy')        where  DATE_START is nullcommitNo updates of the tables.Does FME have a problem with using Oracle “to_char(sysdate -1,'dd/mm/yyyy')”?Because the syntax works under ORACLE SQLPLUS  

Hi,I have two Oracle tables: POINTS_TABLE and LINES_TABLE. I’m trying to export both tables to DGN.  I’m using “Bentley MicroStation Desing (V8)” writer. In writer parameters, I filled out “Cell library file”, and now I’m trying to do something to fill “CellName”. How should I do it, to have different “CellName” value for POINTS_TABLE and for LINES_TABLE in my output dgn file?

I am struggling to save text as a hyperlink in Excel. I tried using this formula:=HYPERLINK("http://www.1spatial.com/fme","http://www.1spatial.com/fme")However, the outcome in Excel didn’t work as expected.  Does anyone have any idea why it behaves this way?

Using an Esri ArcGIS Portal Feature Service Reader to read attachments, RasterReplacer fails on the attachment blob with INVALID_FEATURE_CANNOT_READ_BLOB. Enable Attachments='Y' on the reader, the arcgisonline_attachment{} list is exposed, and arcgisonline_attachment{}.data contains data. I am able to manually download jpg attachments from Portal successfully. I've tried all the image formats in RasterReplacer against the jpg in Portal. Any help would be much appreciated. Thanks! FME 2019.2.1.0, Portal 10.6.1

HiI am having an excel sheet like below. I need to group them in Field name route and assign a value for route field .let's say (routeNo)  or any other unique value.the grouping is based on finding a value that is considerable above of other previous records below is 48. which is very big than other previous ones.Any help is highly considered. Route 1Route 2 

Overwritting .shp files gives mixed results so my workaround is to delete the .shp file(s) first and then create the new version.  But I can not figure out how to do that --I read somewhere that writers have a ‘delete’ setting for the ‘fme_db_operation’ parameter but I can not locate that anywhere.  Can anybody tell me if FME has the ability to delete the .shp files in a folder?  Thanks!  Lewis

Hi all I am trying to compare two databases which contain similar and different geometry files. I am trying to figure out which geometry's are the same and which are unique to each database.   A few big issues I have is the complex of the geometry and even the SAME geometry's has been captured slightly differently; even thou it's of the same area.I also have no data to help identify which geometry's are the same.Example of 2 similar complex geometry's - zoom in to show compilation differencesI am currently struggling to figure the best solution to my problem, the geometry can be complex with donuts and multiple areas representing the “same” geometry. I can't find the sweat when I simplify the data enough to get a match and not corrupt the data too much that everything m