FME Form

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?

I am trying to combine symbols consisting of donuts and polygons into a DWG block. The problem is that the areas are displayed incorrectly in the DWG. With the option "Prefer writing donuts as hatches" set in the DWG Writer ( even in the RealDWG Writer) the symbols are displayed as follows. The donut polygons are displayed correctly, the simple polygons only as a line. If I deactivate the option, all polygons are displayed as a line. The creation of the block is controlled by the attribute autocad_block_name.  Can someone help me? Thanks a lot Edit: I also tried to generate the DWG from an Aggregrate

The Python package <numpy> in FME is using version 1.15.1 and I want to switch to version 1.16.1. Already tried to force reinstall:fme.exe python -m pip install --upgrade --force-reinstall numpy==1.16.1 --target C:\Users\301650\Documents\FME\Plugins\Python\python37It does install numpy 1.16.1. However FME Desktop is still using numpy 1.15.1. Is it possible to uninstall Python package in fme.exe python? It would be nice if command below does work, but currently it does not: fme.exe python -m pip uninstall numpy --------------------------------------------------------------------------------------------------------------------fme.exe python -m pip uninstall numpy Python version 3.7 loaded successfully Usage:  C:\Program Files\FME\fmepython37\python.exe -m pip uninstall [options] <package> ...  C:\Program Files\FME\fmepython37\python.exe -m pip uninstall [options] -r <requirements file> ... no such option: --target Error in running the Python command 'python %0'Program T

I note that ArcStroker will stroke CircularStrings but my testing indicates it won't stroke CurvePolygons and CompoundCurves. What transformer will allow me to so stroke those geometries?Simon

A quick question on “LineonAreaOverlayer” Transformer in FME. I am using this transformer to connect WW pipe data from a council (in line format) with some environmental data (in area format in GIS layer) to analyse integrated data. However, when I am connecting this two layers in FME…I have originally 14, 000 WW pipesBut, when I am connecting this pipe layer with the environmental data layer using above transformer in FME… the number of pipes get almost 50% more say about 21,000 pipe recordsThis makes sense to me as per the description of this transformer which says: “The LineOnAreaOverlayer compares lines and polygons, splitting the lines where they intersect with a polygon boundary. Each resulting piece receives the attributes of the area(s) it is contained in, and each containing area receives the attributes of the line(s) that either fall within or intersect it (a spatial join). Features also receive a count of the number of overlaps encountered”But still wanted to double check wi

We have a custom application that calls and polls telephone numbers using an analog modem on COM1 port. I would like to port this application to FME and I have been unable to find any native transfomers/readers/writer that can communicate with COM Port1. Question:Can FME natively communicate with COM Ports ?If so, how is this done.If not, any suggestions on how to make with work

Hello , i have around 10 GB DGN files and it takes time to load in FME and and it seems slowly to work with them .i would like to know , if there is best method to work with DGN files ? Or should I convert them to other format ,if it will be besser then I work with them in new format ?FME 2021 Thanks in Advance

I have a time series with ambiguous dates due to the daylight savings time change that I would like to convert to unique datetimes with time zone information: 2021-10-31 02:00 > 2021-10-31 02:00:00+02:002021-10-31 02:15 > 2021-10-31 02:15:00+02:002021-10-31 02:30 > 2021-10-31 02:30:00+02:002021-10-31 02:45 > 2021-10-31 02:45:00+02:002021-10-31 02:00 > 2021-10-31 02:00:00+01:002021-10-31 02:15 > 2021-10-31 02:15:00+01:002021-10-31 02:30 > 2021-10-31 02:30:00+01:002021-10-31 02:45 > 2021-10-31 02:45:00+01:00I tried to do this in FME with the "TimeZoneSet"-function as described in https://community.safe.com/s/article/converting-time-and-date-fields-to-local-timezones. This works for all datetimes except the ambigous ones above (I get null values). In Python this can easily be done by using pandas and the option "ambigous='infer'":import pandas as pddf = pd.read_csv(file, sep=';', parse_dates=['dt'])df['dt'] = df['dt'].dt.tz_localize('CET', ambiguous='infer')For thi

I am trying to automate some quality tests & I need to calculate the distance between the points in a consecutive manner. So, each point needs to be  '50-100 feet' apart from its previous point. I am unsure which transformer(s) would be the most efficient & haven't had much luck looking online. Thanks!

Hi FME Users, I have a list of points with coordinates and a lot of attributes. Based on this dataset I need to create (different size) polygon clusters, which depend on the criteria - such as distance from competition points, cluster density, number of POI in this cluster, and others.  Firstly I filtered data based on some criteria (eg. types of points, etc). Then I used NeighborFinder to find and filter these points which are too close to competition points (distance is defined by users as a parameter). But I am not sure how to create the polygon clusters.  I thought about using HexagonSample (custom transformer), NeighborhoodAggregator, or H3HexagonalIndexer. But unfortunately without any successful results. Maybe, someone from you had a similar task and could suggest how to approach this problem? Any tips or ideas from all of you will be very helpful! I am working on FME 2022.0, so it seems to me that I cannot use PointClusterer from FME Hub (the wrong Python version). Thanks in ad

I'm beta testing the new FGDB 'preserve GlobalID' parameter in 2023 build 23215. It does not seem to be preserving the values. In the test dataset I've attached, the GlobalIDs are used for relating the attachments table to the feature. Is there something else that needs to be done to ensure the values are preserved, besides setting the parameter to Yes?

I have 3 datasets that are fme_time schema type and I want to use the AttributeManager Conditional Value to set if/else statements depending on which time values are missing. When I do this, the resulting attribute type is fme_varchar and not fme_time. If I create a new attribute and point to just any one of these attributes, the new resulting attribute is still fme_time. So it appears the conditional value setting is changing it and I can't figure out how to change it back to a time. I have tried parsing, formatting, casting and nothing changes the varchar back to time. Are there any ideas to fix this?    

This week my AutodeskBIM360DocsConnector stopped working and I am no longer able to read data or browse through the hub. It still works fine to authenticate in the web connection. Is there a way to troubleshoot the connection in the transformer? Seems like nothing is logging in the log window cheers

I'm creating a dynamic workspace which reads Excel sheet as a configuration and extracts data from a Feature Service. Configuration file looks like this:FME workspace looks like this:Feature reader reads every row in configuration file and extracts data for the listed Feature services. It outputs everything through the generic port.  In the configuration file I have field mapping information where attribute fields in a feature services are mapped with the output fields I need: FME evaluates and extracts attributes using such logic: It works well and I'm getting what I need: But I have a question what to do when I have some more specific logic. For example, I have cases when I need to concatenate the fields into one field. How to pass this to FME to evaluate such expression?