FME Form

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 --targ

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.

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)

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

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\\".

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

Hello,I have a set of .csv files that contains values for each hour of the year, ie 8760 values. How can I split this into 365 days (24 value packages)? The filename is the identifier of the "curve". FME seems to have issues with so much columns because it crashes when I try to see the data in AttributeManager. Example file is attached.  Workaround is of course to transpose these in Excel and use Excel files instead but it requires manual work since there are quite many files

Wanted to estimate population yearly using fme transformer with existing population data in .csv format

Hello everyone, here is your weekly FME newsletter. User Conference DetailsThe FME User Conference is coming up quickly (August 24-26 in Vancouver) and most of my work now is preparing for the event. We recently published the full agenda so you can see all of the sessions taking place, including user presentations:  I have to say that the presentation lineup reads like a Who's Who of FME experts. There is an impressive range of talks by a host of top speakers, and I think we're all going to learn a lot during the week. In particular interest, we hav