General

I have one column with this values. I would like to filter only words that contais ABC letters. But can´t be JACABC or RDABC. Sometimes the ABC is stay in second or third word after the comma, like image below:  Thank´s

For more information visit us:AutoCAD Classes in PuneAutoCAD Course in PuneAutoCAD Training in Pune

Hi, I'm trying to insert a decimal into a string of numbers, so 123456 becomes 1234.56  Thanks!

Hey there, So I recently set up a Data Distribution service on FME Server using this tutorial https://community.safe.com/s/article/data-distribution-fme-server-app . Everything works fine and I can use the area of interest box to draw an area and download all the relevant layers. I am trying to add a second option in the User Parameters to allow the user to either draw a selection or choose a layer to clip by.In user parameters I added a 'Choice' option and added a layer as an option to clip by my thought was I could add a second geometryreplacer, set the encoding to OGC well known text and the source as $(LAYERCLIP) by when I run it and select the City Boundary to clip but FME gives me the error INVALID_PARAMETER_GEOMETRY_SOURCE. Is it because FME doesn't know what GISOWNER.city_boundary is? Its a layer in our enterprise SDE. I tried adding in a featurereader to read the layer before it goes to the replacer and had no luck. Thanks!

I am wondering about how it works if you want to have mulitpled editons of FME Desktop using the same Lic seerver, so floating lic. So say if we had 10 floating lic, and had 8 ESRI Editions, and 2 professional Editions how does that work on a Lic server, can users pick an edition when they start FME Desktop ?, or do you have to set up user groups for specific edtions, or would you need 2 lic servers, one for each edition ? Just trying to understand how this would work and what the options are for users to be able to choose an edition.

My organization is upgrading to FME Server 2021 (from 2018), and we'd also like to update our authentication method from Windows Directory to Azure.  I restored the backup configuration from our FME Server 2018, so all our user profiles are coming from the Windows Directory. I have successfully set up a connection to Azure and can import new users (the user says Type = Azure AD), but is there a way to migrate my existing users from Type = Directory Server to Type = Azure AD? Alternatively, I could re-import all my users from Azure AD and re-assign roles, but I was hoping there would be a way to switch the authentication.  Thanks

Hello FME friends, Server Apps TroubleshootingAs I mentioned previously, I'm getting a weekly report of new and updated knowledgebase articles, and the one that stood out this week is FME Server Troubleshooting: Server Apps. Besides simple troubleshooting steps, there are a number of FAQ-type issues, such as "Why don't users have the ability to upload files to my app?" Solution: Ensure the "User Can Upload" setting is enabled.  Also, there's an interesting issue where the OK button doesn't work (answer: there's a user parameter that's hidden, but is required and has no default value). I think that's definitely worth knowing about. Also on my list this week:Known issue launching FME Server 2022 on a Cloud Starter instance (new)How to make a Minecraft world with FME (updated) Server Automations DemoSomething I tried for the first time last week was FME Server Automations. I only made a simple two-workspace chain, started by a schedule, but

Hi! I just want to know if this is possible before I start to dwell deeper into it.  What I have is a web-application created in ArcGis Portal. I can select points within the app using a polygon. What I need is to be able to send only the selected points to an FME-script that should run and do an analysis on the points, all from within the web-app. The point layer is published to ArcGis portal and its stored inside a PostGis database. Is this possible at all?  

I need to use a unified database connection string which contains primary and secondary/DR database. Secondary /DR database is an exact replica of primary database. When the primary database is down , it should automatically connect to secondary database. All my existing workspaces are configured considering a single database connection . With the change to include primary and secondary db connection, can you please suggest how I configure this FME with least number of changes since it has an impact on all the existing workspaces.

I have Workspace where shapefile has polygons they overlap so i want they should be no overlapping . lowest values are normally on outside so I start clip with the next highest values then you move from low to high 

The error in log isERROR |GEOJSON writer: Transcoding the binary string '\\xFF\\xFF\\xF9\\xFF\\x02\\x00@5^:\\xBF$)A`;\\xDF\\x0F\\xCE/)A(1\\x08,\\xC1$)A`B>\\x88\\xCE/)A\\x16\\x00\\x00\\x00E\\x00x\\x00p\\x00A\\x006\\....0' to another encoding can not be doneWhat's this mean?

I have a dataset of parallel lines that I have buffered (150ft) and dissolved into one polygon. My question is, is there a way I can preserve the actual flow (direction) of the main buffer, and split out where the buffer separates from the main path? I want to keep the main segment as one feature, and where it splits as a separate feature. In the image below kind of explains what I am attempting to do. Segment 1 would be one solid feature, while segment 2 would be another solid feature.    

Hello FMEers,Welcome to What's Up Wednesday. Academy UpdateThis week, the FME Server Authoring Trail has been updated on the FME Academy. As you might know, a "Trail" is an extensive course composed of multiple modules, so this is a comprehensive update.  In fact, you can see it's 7 hours of content, worth 4,000+ points, and even consists of multiple smaller trails: Publish Workflows to the Web trailWhat is FME Server?Publish Workflows to the WebCreate Data Integration Apps trailBuild Basic Self-Serve WorkflowsManage FME Server Data and ConnectionsBuild Versatile Self-Serve WorkflowsAutomate Data Integration Tasks trailBuild Basic AutomationsBuild Versatile AutomationsCreate No-Code Web AppsConnect Automations with Job Orchestration I think there's something there for all FME Server users and - as always - this content is free to access on the FME Academy. Esri ArcGIS Online Hub TransformersI may have mentioned these already, but, just in case you weren't awar

Hello There we have a set of point features we want to filter the point that has the same distance +- 5m to each other as You can see in the picture we should keep 1 ,3.5, and 7 since there are at +- 5m distance and should delete 2 ,4 and 6 If we go with a neighborhood finder with a max length 5m will work but point 2 and 4 are also located at a 5m distance, the goal is to keep only one set of points the green or the blue  

We have two formats to connect with SQL Server : Microsoft SQL Server Non-Spatial Microsoft SQL Server Non-Spatial (JDBC) What is the difference between them? 

Does anyone know what causes the error?

Hi, I have multiple strings that are in this format 560_20170619_0900, I would like to remove all before and after the '_', leaving me with just 20170619. Is this possible using the attribute trimmer and regex?ThanksB

This error occurs once and and while and the issue resolves itself on it's own, sometimes the next day or sometimes it persists for several days. The issue seems to be with any transformer/reader that reads in oracle non-spatial tables.

I am doing the FME Server Authoring 2021.1 trainig and I see video day 3 is completely irrelevant to the FME server training modules. Now I started day 4 it seems few modules skipped as day 3 was not the correct video.Is there any other source to the trainig video that match with course modules?

Hi all, I am new to FME and am struggling with how to clip a raster and keep the z values. The raster is an ESRI ASCII file and contains flood depths around buildings. I want to keep the raster cells within x meters of he buildings and then calculate statistics based on the kept cells only (z_max etc). Any ideas on how to achieve this? Thanks in advance!

I've recently been getting an SFTP login failure when running my FME workspace. This was working back in July, but is now throwing the following errors:FTP info:  Trying 'SFTP IP ADDRESS'...FTP info: Connected to SERVERNAME ('SFTP IP ADDRESS') port 22 (#0)FTP info: SSH MD5 fingerprint: 'FINGERPRINT'FTP info: SSH authentication methods available: publickey,gssapi-with-mic,keyboard-interactive,passwordFTP info: Failure requesting identities to agentFTP info: Authentication failureFTP info: Closing connection 0FTP/FTPS/SFTP transfer error: Login denied Now, this I can still connect via my same SSH key using an FTP tool such as WinSCP no problem. I'm loading the private key via a SystemCaller and the following command beforehand:Start cmd /c "C:/Program Files/PuTTY/pageant.exe" C:\\PrivateKeys\\PrivateKey.ppk

Hello, I have build a simple Workspace App that copies folders for my users. Currently I provide the users with the network path to the Excel template in the Description section. Example: \\\\my_network\\Excel_template Ideally I'd prefer to house the Excel template in my resources folder on fme server and provide a link for them to download it from there eliminating any issues if a user didn't have access to the network path and thus couldn't download the template.  Is this possible without creating a custom html document?

Hi,I would like to sent a shapefile that is created with the workbench. When i use it without attachment the mail is sent. An mail with the attachment is rejected. What goes wrong? I tried with authentication but no succes.Who can help me?

Hi, I have two files one containing the solid of the building top and another has the solid of Building foot prints. I would like to subtract the top view solid from building foot print solid.  Can any one please help.

 Hello Community I’ve made effective use of HTTPCaller to connect to an external secure FTP. I then download that data to process downstream in the workspace. But can I use FME Desktop to upload to a secure FTP, or perhaps to an external API? Thanks,