FME Form

I have an address field with an address value of 1244 Deep Creek RoadI want to use the AttributeSplitter to separate this value in a List so it comes out like this List{0} = 1244List{1} = Deep CreekList{2} = Road My question:What delimiter do I need to use that would split the 1244 into a separate list, but keep the "Deep Creek" together in List{1}? (Note that there are other streets with two names, I use "Deep Creek" as an example)

I can't seem to find this mentioned in the documentation or on the community posts

Hello everyone. We are experiencing some difficulties while running the workbench on the FME server. It had been working fine for a few years, but we are now experiencing these issues on a regular basis... Is it due to a memory problem? When I checked the server memory, I found that a maximum of 40% was occupied by RAM and 4% by CPU. What constitutes a problem and how to resolve it? Sometimes resubmitting the job in FME Server or restarting the FME server and running the job will produce positive results, but not always...

I have a raster DTM with some erroneous transparent areas. I would like to fill these using average vales of the surrounding pixels, to keep everything nice and smooth. GRASS has the 'fill nulls' function that does this, does FME have anything similar?

I have multiple shapefiles in a folder with subfolders. Example Folder "01" has 10 shapefiles, Folder "02" has 15 shapefiles, etc. I was able to create a gdb and load all the features into the gdb but the whole thing is too large. Is it possible to have FME create a new gdb for each subfolder name? What I would want is a new gdb named 01, for the data that was in 01. Another new gdb named 02 for the data that was in 02, etc.thanks!

Hi all,  I have an WFS from a vendor that contains several polygons and associated attribute information. When I attempt to read via the OGC WFS reader, I encounter an error: <WFS> An error occurred while reading a GetFeature response, to ignore the error and avoid losing the previously read features, set the WFS "Ignore GetFeature Error" parameter. Total features downloaded: '0'As instructed, I've attempted to modify this setting, but continue to receive this error even when I've set to ignore.  I've tried several iteration of different settings in the reader to attempt to resolve to no avail. I have noticed that if I enable the option to Disable XML Namespace Processing that I no longer receive the error, but I still do not get any returns -- perhaps there is some other setting I should investigate? I'm certain that this is specific to the reader as I am able to view returns from this WFS URL via httpCaller, Postman, and as a ArcGIS Online serv

Hi FME ninjas,I'm working on a data source that contains school names. The names in the source are too long and need to be shortened.Left is what I have, right is what I want: I know the StringReplacer can be used to correct single strings - but I fear I will need to create at least 40 of these to correct all possible strings.Is there a transformer that can replace multiple strings? Or can this be done by Regexing some transformer? If so, how?Thanks,Ed 

Using ArcGIS Data Interop extension to build workbenches. We are connecting to an external database to write to and we are experiencing intermittent connection. When testing connection, when it fails we get a timeout error. Same when when we run the workbench. But then sometimes it will connect fine and run the workbench as expected. Anyone else experience this?

I'm finding that when you write a raster image to Excel while using the ExcelStyler to stretch the row height (e.g. 100), the raster will be stretched in the y-direction by a factor of about 7. This only occurs for the first column (xlsx_col_id = 0), and writes fine to other columns. Is someone able to confirm if this occurs on their version too?  It's possible to force a fix by adjusting the xlsx_raster_height to be about 7x less than xlsx_raster_width, or write to a different column. Version: Data interop FME(R) 2021.0.0.0 (20210305 - Build 21302 - WIN64). Thanks!

The TIFF has only angle unit and does not have linear unit and the shp file only has been defined Geographic coordinate system. What can I do?, Does the TIFF file have to have Linear unit before?

Hi all, Not sure if someone could help me with this doubt.I'm trying to convert from SHP to MAPINFO a polygonal layer. I fill the Advance property from the Writer to be used the File Version = '300'. Once finished the conversion I see the file has taken '800'. Other layers maintain '300'. Not sure why some layers stick to the fixed '300' value that I give and others no.I'm using 2022.1 FME Desktop version. Thanks,J.

Hey everybody,​I would like to define the hierarchy from the first administrative level into the second administrative level, and I would like to do that with the spatial reference. So for example I have a shapefile of the first administrative level which is called "Central". The second shapefile are the districts, so the second administrative level, which are all in the Central state. Lets say we have 4 districts (south, east, west and north). The name of the Central state, so "Central" should get automatically get written in the attribute field "hierarchy" of the 4 districts. I would like to use the spatial reference as transformer. But it was not working. Has anybody an idea how to solve that problem?Thank you in advance.Cheers,Fabian 

I am not that familiar with the Emailer, but I experimented a bit with it and I find it a bit worrisome that I can send a mail from one mail adress (not necessarily mine) to another mail adress. I tested using my colleague's mail adress to send a mail to my own mail adress and I don't need to authenticate that I am the colleague.You can choose yourself to have the sender's authentication on, but I would prefer that it's always required so you will be sure that the person who sents the mail is indeed the sender and not someone else.

hi everyone,My colleague tried out the Emailer transformer and it's cool that you can sent a mail from one mail adress to another mail adress in an automated way. However the mail sent via the Emailer are not stored in the sender's sent items folder in outlook for example. Does anyone know a way in which it's possible to send a mail and the mail is stored in the "sent items" folder?I heard it's because the application server is allowed to sent mails from another mail adress to another mail address, so it's not yourself.However I would still like to know whether it's possible and maybe possibly via another method if the Emailer transformer is not suited for that.

I've made great use of the HTTPCaller to connect to an external FTP, drag down the data, transform and utilise internally. What about the other way around? Could I use FME Desktop to write to an external FTP? This assumes I have all the right permissions, firewall exceptions etc. in place Thanks

Hi, Is there a transformer within FME that could format CSV into plain text with formatting, see the attachment? The original file can also be in another format, for example excel. If someone can think of another writer that will facilitate the solution of the problem, it can be. file original - source datafile required - required data Thank you

Hi ! What I have is two colums and sometimes, I have to modify column1, but not each row. For examples : Column1 : PR1 Column2 : 0 ==> PR1+0 exists and PR1 stays as it is.Column1 : PR1 Column2 : 120Column1 : PR1 Column2 : 500Column1 : PR12 Column2 : 120 ==> there is no column2 = 0 ==> this means that PR12 doesn't exist, ==> so I need to get this another value in column1 : 'PR12+120'But I don't know how...I hope it's clear enough.Thanks for your help. Nati  

Hi, I've a workspace where I process a series of point feature classes within a single geodatabase (see pic). I'm manually adding/removing connectors to process each feature class on it's own, however, I'd like to simply run the process once and it loops through ALL of the features.I've experimented with the Directory and File Pathnames Reader, however from what I can tell it only processes multiple files within a directory NOT a a geodatabase and the features within. Any thoughts would be appreciated.

If you use the feet to meters conversion of 1 foot = 0.305m instead of the 1 foot = 0.3048m conversion, will there be a significant difference in the elevation information, and therefore, in your analysis?

Hi there, I'm having an issue with an Active Directory connection after completing an upgrade to FME 2022. In the newly upgraded version of FME, when creating a Web Connection from FME Desktop to FME Server the correct permissions are not being assigned.  Choosing 'Windows Credentials' I can make a connection successfully, however I can only see the Samples repository. I can not publish if I click through the wizard. Digging deeper, it appears as though when choosing Windows Credentials, rather than passing through my logged-in user, I am authenticating as 'guest' - the built-in user. I have tested this by disabling that user from the FME Server UI, and the connection can no longer be made. There are no issues using the Windows Credentials via the browser, and interestingly no issues when making a Web Connection from an older version of FME Desktop, so I am confident that the AD setup with FME Server is ok. Is there anything new in the latest builds of FME Desktop t

I have FBX files with various textured 3D objects.The FBX includes file names for these texture files, eg. "textures\\asphalt2.jpg" and when FME loads the FBX, those textures are created as local JPG files in a folder .fbm. Essentially I need the texture name (filename) within FME. I can pull the individual textures as rasters as per the attached, but they dont have a name, specifically the filename. The closest I can find is the ShareItemID for each texture. How can I link the SharedItemID to the texture filename? Example attached.

I'm looking for a workaround to a small bug in FME that currently exists (Safe already know about the issue).I need to write some values into a spreadsheet, from which a formula calculates a result. I then need to read back the result in another process. However, it seems that the result is only available to FME if you open the Excel sheet manually and save the spreadsheet and then close it again. If you try to write the values and then read the result straight back without opening the spreadsheet you don't get back the calculated value. This is therefore no good as it makes an automated process difficult.You can see the issue demonstrated here.Does anyone have any magic workarounds to force a commit or a save in the spreadsheet behind the scenes, without the user having to intervene?

I have a file geodatabase and a feature class called "Boundaries".I am using the Esri Geodatabase (File Geodb Open API) reader and I would like to apply this WHERE Clause, but the WHERE Clause is disabled."COUNTY" = 'Will County, IL' Is this a way to use the "SQL To Run Before Read" to achieve this? It can be found when you click on 'Parameters' and in the 'Advanced' section of the Esri Geodatabase (File Geodb Open API) reader.

Hi. Can FME workbench read a .gws file? I only found this linkhttps://community.safe.com/s/article/fme-and-intergraph-geomedia-compatibilityThanks

I get the data from two different databases, which contain a point layer, and a surface layer, I combine the two layers using a transformer called FeatureMerger, and it works fine. I write the result to a third database, where the layer is a surface layer. All the fields with data that I want are included, but when I send the data to an sde database in the writer, information is missing in two fields. In the writer, data type = char is set. The information that is missing is data type = text, the number of characters is correct when I look in the writer. What is it that is wrong? Why doesn't the information that is in the two fields come along?