FME Form

Using PointOnAreaOverlayer, I would like to know how to extract polygon IDs and assign them to corresponding points that are within each polygon.

I have comprehensive worskpace to write many tables in PostGIS, where all the target attributes are in lower case. Now I need to migrate this workspace to work also on MS SQL. I was able to change the writer and bulk update feature types table qualifier. The schemas are just similar to Postgres DB, but I'm getting errors because of the lower case of the attributes while writing to MS SQL.Importing new feature types from schemas is not a way because I need to maintain the attribute mappings on every feature type. For example, the table name in lower case is not an issue but column names are. I would need that the writer forces UPPER CASE on writing to DB or bulk change all the attribute names in all writer feature type to UPPER CASE. I´m not feeling to do all the mappings again from the scratch, if the schemas are the same.On the attached picture you can see the attributes from changed writer feature type (PostgreSQL->MSSQL, left) and new imported feature type (right). There is j

Sorry if the question does not express what I want to achieve, but of the top of my head I did not know how to ask differently.The issue I have is, that features provided by the very left reader are used to identify raster files they intersect with, which afterwards are mosaicked and processed. There are a lot of raster files and a lot of features coming from the reader, and I would like to run this entire process rather feature by feature, instead of feeding all the features into the process.What is the best way to achieve that? 

Happy New Year all. Can anyone please how can I change a date column (dd/mm/yyyy) from string to date time format within a workbench. The column is originally coming from a CSV file but after reading in FME, its getting converted into string. I want to apply test filter to get values within a certain date period but because the date is in string, I cannot do it. Do you have any idea how to resolve the issue? Thanks in advance.

Hi, I wounder how I could manage to install the Rhino module for python (external package)? I have tried to look up info from:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/Installing-Python-Packages.htmand:https://community.safe.com/s/question/0D54Q000080haVOSAY/how-to-install-external-python-packages. What I seem to manage to do is to install the module with the following command:fme.exe python -m pip install rhino --target C:\\Users\\*\\*\\Documents\\FME\\Plugins\\Python\\python37 The module seem to be installed at the directory, but when I try to import it (import Rhino) using python caller I get the error msg:|Python Exception <ModuleNotFoundError>: No module named 'Rhino'.The Rhino module is a non-universal package and I have tried to verify python interpreter to both 3.7+ and 3.9+ when running pyhton caller. I am using FME v2022.1.2.0 64-bit. When I used to command line it prints; "INFORM: Using python interpreter **\\python39.d

I must use the http caller transformer to obtain the token value from the rest end point.However, I am unable to connect via FME. postman returns valid output. I get a notice that reads "invalid clientid or secret," but when I use the identical parameters, Postman returns the response body. Why is FME unable to make it happen?I made numerous adjustments but in vain. kindly assist

Hi,  I am looking for a solution to read the correct text height of a dimension from the Model Space. If the dimension is not-annotative, you can simply use the fme_text_size attribute. When a dimension is set to Annotative, the fme_text_size is rescaled.In AutoCAD:While in FME:--> Scaling factor = 10However, I noticed that most of the time in the autocad_extended_data_list{} , you can select the last "real:" value in the list to find the actual text height.So far so good, but now I have a new input file, where I cannot find a correct real value in this list. I have attached this DWG.--> scaling factor = 5 I have disabled the "Explode Dimensions" in the reader parameters, butI have checked an this has no effect.  For dimensions I can't find some kind of annotative scaling factor to multiply the fme_text_size. Any ideas? Jasper

Morning, I'm trying to extract logger data from an api returning XML. I can use the XMLFlattener to match my message element and return the pt element as an xml fragment. However I need to then expose all the key value pairs in the <pt></pt> element into attributes and if I try to use the AttributeExposer there's a huge list, which will change when i run the api with different data ranges (ie more key value pairs to manually expose).Is there any way I can automatically expose all of the elements within the <pt></pt> xml element one column each of time, value, ch, chtype etc to insert into a db table? Cheers!  

I have a linear asset, such as a road, that needs work done to it. The work group can only travel 5 miles per day and can only do a maximum of 5 jobs per day. I am trying to group the locations using these constraints. Some groups may be 5 miles with 5 work locations, some may be 5 miles with fewer than 5 work locations, and some may be less than 5 miles with 5 work locations. I have both the linear asset and the work locations as spatial data with all the appropriate attributes (road name, mile points, etc). The linear asset has measure values that correspond to mile points. What is the best way to dynamically group the work location data based upon the above mentioned constraints? 

Hi all, I have doubt or I wish to know that, can we control the sequence of translation of each layers one by one (here I used .dwg file) like conditions in normal programming languages .suppose if FAT boundary layer complete, then I want to start manhole next to it.is there any options for that ? Regards,saravanakumar

I have a very large (~90 gigapixel) single band geotiff file and a vector layer of ~16m polygons. For each polygon I would like to calculate the 10th percentile of the band of the raster within it and output to a table (e.g. csv). I've set up a Clipper which seems to successfully cut the raster for each polygon and I was hoping to use the RasterStatisticsCalculator to get the 10th percentile. However, percentiles do not appear to be an option. Can anyone suggest how this might be possible please?

Hi, I would like to change the coordinate system in Lambert 93 EPSG: 2154 for shapefiles.  But i can't find the good one in the coordinate system Gallery. (i have a tamplate to compare(PRJ file))  do you know if i can add this .PRJ to reprojector maybe ? because i need to change a lots of files Thanks,  Charles.

Hello there we have the geo-location of the car and we do have multiple users we need to create a notification based on the geofence value set by each user, The car location is streamed in reel time, we don't know in advance the number of users is there any way we could create a dynamic filter that will notify the users based on their setting to be more specific user 1: notified when the car is within 500 m user 2: notified when the car is within 1km....the only problem we have is we don't know in advance the user and the value of the geofencecould we send those values to the filter as for example JSON ??Thanks

Hello, Is it possible to install FME Server on a linux distribution Rocky 9? For the moment, i found only a version on rocky8. I have a error when i tried to install the version 2022-2.2 on a linux rocky 9.1. Thanks! Yann

I have power lines for a utility that I want to merge into our esri gis system. For any given feature class there are some field that will map straight across without modification. But there are many cases (many fields) where they have, what I think of as an esri domain (a code - integer linked to a description- string). Then on our side, we have a normal arcgis domain. So, for example, they may have an attribute value of 2 that I need to change to a 4 when it is loaded into our gis. At first, I used the attribute value mapper. This worked great. But it does not appear to work well for many fields. So, now I am trying to do it with schema mapper. I did the tutorials but still having a hard time getting it to work.So, questions are:1) Is schema right tool for this problem?2) If so... what is wrong with my workflow:Lookup table test (only one field so far)ActionsWhat I am trying to say is:if ID_PHASE = 1 then PHASEDESIGNATION = 99 Thanks for the help! 

What language does the text editor in the AttributeManager Transformer use? is it SQL, Python, both, or ?

The field i would like to convert looks like this:Looking at the same data via the Sharepoint GUI, the visible date is 04.08.2021.How can i convert from the date above to the data in the GUI. I have been told, that the sharepoint date is GMT +00, while the GUI date ist GMT +01I have already tried various datetime functions, but so far without success. Thank you for your ideas!

I have been tweaking workspace briefly described in this question for better performance and encountered weird behaviour on setting up worskpace runner parameters. The workspace is loading XML data, parsing and fetching results to PostGIS database. When I setup the workspace runner to 4 concurrent processes and 4 workspace runs per process I end up with some features not being written. On contrary running directly the child workspace or setting up the workspace runner to just 1 concurrent proccess, all features are being written.On the comparison you can see limited features written (left, import_RUIAN_c4_w4.log) and all features (right, import_runner_c1_w1.log) from the same XML:Looks like some translations fails in concurrent processes trying to delete some file:ERROR |AttributeKeeper_6 (AttributeKeeperFactory): Failed to delete the following files: 'D:\Zakazky\APHA\FME\per_partes\import_RUIAN_1b_zapis_log.ffs'.  Please ensure that the files are not in use and that you have sufficien

Hi,I'm trying to extract XML from the attached file. I'm using an XMLFormatter before hand which extracts the loggerId I need to match to a database table.I can extract the XML using the fragmenter, but unless I use the 'Merge Attributes from Input Feature' the loggerID is not carried through. If I do this. FME managed to burn through 700GB of my hard drive and then fails due to lack of memory.Any idea how I can carry through my original XML attributes through to the fragments without having to do this? 

Hi everyone,  I am creating a model to make it quicker to convert DWG files to SHP. They have the same format but there are several hundred files in various folders. The DWG files get updated from time to time, so the tool will be used often which is why I would like to set it so I only have to input the DWG file and the rest is automated.  For example:  C:\\CAD\\A\\1\\points.dwgC:\\CAD\\A\\2\\points.dwgC:\\CAD\\A\\3\\points.dwgC:\\CAD\\B\\1\\points.dwgC:\\CAD\\B\\2\\points.dwgEtc.... I need to write it to the GIS folders which are very similarC:\\GIS\\A\\1\\points.shpC:\\GIS\\A\\2\\points.shpC:\\GIS\\A\\3\\points.shpC:\\GIS\\B\\1\\points.shpC:\\GIS\\B\\2\\points.shpEtc.... I have used FilenamePartExtractor to get the filepath of the DWG and then used StringReplacer to replace "C:\\CAD\\A\\1\\" with "C:\\GIS\\A\\1\\". Is there a way I can use this value to specify the output location?  It has worked to specify a filename, but no luck with filepath so far.  Thanks in

Hi all, How to join the line geometries to make area in below scenario? I tried with area builder transformer it could able to convert few lines only !Is there any other ways?my input data is dwg file. Thanks in advance!saravanakumar

I got this message when laoding data to a ArcGis Online Feature Layer: Python Exception <HTTPError>: 413 Client Error: Request Entity Too Large for urlThe workspace use FeatureWriter to load lines in to a AGOL Feature Layer. It has worked well for a long time, but suddenly it stops with this error. What does this error mean?

I feed a table to a pdfpageformatter. The table varies in height.I would like to create an object in the pdfpageformatter that is very large, but for the layout to make any sense the input-table needs to be aligned to the upper-left corner.It seems that the default behavior is to mid-align the input. 

have 353 asc files but only need 137 (BatesmanBay example) as identified in polygon file, name field to filter files