FME Form

The first dataset has 10500 objects ( a table with x,y id, date,etc. etc.)The second dataset 7000 object s )(a table with x,y,id ,,date, adress etc.etc.)Based on the x and y we would like to get a combined file as a result.Where all 10,000 objects from the first dataset are located at the closest object to an address point.A list of these.. It seemed logical to us to use the transformer neighbor finder for this. But this doesn't work. ideas more than welcome  Johan 

I have a column that contains a lot of special characters. By using transformer 'StringReplacer', I can replace i.e. an '#' by an ' '; How can I replace a list of special characters of 10 or more characters. Do I need to use 10 StringReplacers?

I am running an FME-routine in FME Desktop (2022.2) where I want to modify data from an ESRI Geodatabase and write them back to another ESRI Geodatabase. This routine has always worked fine for months until recently, where it suddenly gets the following error messages in the log-file:2023-11-28 20:05:40|6109.0|  0.0|ERROR |An error occurred while attempting to insert a row into the table 'UPDATE_TABLE' using a cursor. The error number from ArcObjects is: '-2147155558'. The error message from ArcObjects is: {Overflow or value larger then maximum 32bit integer [UPDATE_TABLE]}2023-11-28 20:05:40|6109.0|  0.0|STATS |Storing feature(s) to FME feature store file `D:\LOGS\Matrikkeloppdatering_log.ffs'2023-11-28 20:05:40|6109.0|  0.0|ERROR Any tips on how I should resolve this issue? Is it related to version compatibility? I am currently using ArcGIS Pro 3.1.2. 

Hello!I have a newly installed PostgreSQL database with a PostGIS extension enabled. Because of licencing consideration we want to migrate our oracle database to this database. We are using database side bussiness logic in our views, so i want to write directly to the views without success.We have Postgresql 12 AND postgresql 16 for compatibility testingEvery version of FME from 2018-2023 (mainly using 2018 because we have too many scripts to migrate all) I have tried most of the version combination with the same error every time. This is what im trying:Created the table definition with FMEBased on the created definition created a simple view but the workbench keep dropping this error: Invalid PostGIS metadata detected for table 'public.generated_np_node_view'. Attempting to correct and continuePOSTGIS Writer: Table 'public.generated_np_node_view' does not exist. The inserting with pgadmin or geoserver works fine, the inserting to directly to the table works fine but t

We have a process that sends an e-mail to approximately 10,000 subscribers to inform them of crime in their area based off a buffer from the subscriber address that we are considering to replace. Is this feasible using FME Flow or FME Hosted? Or is that too many e-mails to send at once using these platforms?

I have a map that has 5 layers in it and want to have them all displayed using different symbology in the HTML Layouter but I can only define a single colour for the layer.Is it possible to generate HTML output with a little more cartographic input for each incoming layer?    

attribute only display elevation in geometry ，who can tell me why​

Hi. I have a workspace that is using the Micostation DGN (v8) reader that's reading files from a Projectwise URL collection. It's currently reading four dgn files successfully however when trying to add other I'm getting an error message. Failed to obtain any schemas from reader 'IGDS' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationWorkspace generation failed. Parameter file was C:\\Users\\{USER}\\AppData\\Local\\Temp\\FME_1701131211957_17128 I've tried opening the files in a clean workspace and even rebooted my machine to rule that out. The same message persists. Within the reader I'm "Grouping Elements By Scheme - Level Names"and selecting "Preserved Names Cell Insert Points". I also assign a coordinate system to the dataset. Are there any suggestions about how I can overcome this, or will I need to go and have a chat

Can FME be used to produce heat maps?  Kind of like this:  http://www.openheatmap.com/  I have about 20 million points and I would like to show where the hotspots are.

Hi, I know this has been partially answered here but it doesn't quite answer my exact issue.I'm trying to use FTPCaller to download a file from an SFTP site but get the error 'Failed Initialisation'. FME will create the target file fine but with no data in it, and with the above error.I have tested FTPCaller on other SFTP sites and it works fine. I can download the file using Filezilla and I can also get the file download to work using the SystemCaller transformer to run a batch file which runs PuTTY (using a PSCP comand line). All with the same credentials.All file permissions appear to be setup fine and I've tried changing every parameter in the FTPCaller with the exception of SSH-agent/Pageant authentication. Having already got it to run with PuTTY I didn't see any advantage to going down this route.I'd really like to be able to do this directly with FME and not involve a third party package such as Pageant or PuTTY. Is this possible?Thanks in advance,J

Hi everyone, I'm trying to set up a model that will allow the user to select from a list of feature services to read from. I've got a Choice user parameter set up but whenever I try to run the workspace I get this error:I'm very confused since the service connection is working just fine and the feature reader will read in normally when I directly reference a specific service. Help a noob out?Thanks, Brian

How to create an exact copy of an column in FME? Which transformer?

I am trying to do vertical transformation using EsriReprojector, I have installed additional grid files from the FME downloads sections and pasted them into the installation folder. But I am not getting the desired result. Height is unaffected. I have read some other questions but not able to understand what should I provide in vertical transformation field. Right now it's set to None.

Hello everyone, I have an Excel list with many first and last names. For the next process step I need the gender of the person. My idea here was to establish a new attribute (salutation) and fill it with the appropriate form of salutation (Sir or madam). Is this possible with FME? Thank you very much for your support.

hi guys there must be a trick I'm missing. I've set kml_id and kml_parent also set kml_name (different to the id) however the folders don't seem to get created correctly. elements get one level of folders. and the folders get the kml_id not the kml_name as their heading. I'm sure that the id's are the same as the parent but only get one level of folders. yes I've set fme_feature_type to "Folder" - Using 2022.2.4.0 Build 22792 - Win64. I've also tried many variations - setting "Create folder for Feature Type" to yes and to know... spent over a day on something that should be simple. Many thanks.Leon

Hello – I am hoping someone can help. I asked a similar question previously and got a working solution: https://community.safe.com/s/question/0D5Dm00001GWvsMKAT/calculating-total-second-from-hhmmss-field However that solutions only works for hh:mm:ss fields that are under 24 hours as soon as that field is over the 24 hours I get a blank value. @DateTimeDiff(@Value(Duration),000000,seconds) Does anyone know of an alternative solution so it would calculate the total seconds for records under and above 24 hours? Many,Thanks

Hello, I have a dwg file as attached, for some reason when import to FME form/workbench, it shows some hidden objects where I couldn't find at all in the DWG file. I also loaded the same file to ArcGIS Pro which didn't show these hidden objects and matches what the dwg looks in AutoCAD. The only way I could fix it is exploding the whole dwg file which will get rid of the mystic hidden objects from the dwg. I'm anyone has seen this before and also if FME developers could enhance the software to simply ignore these hidden objects like how it does in ArcGIS Pro. thank you.

I am trying to do a transformation basically summarizing the area of vegetation polygons within parcels of land. This involves a number of filters before the "Clipper" is used to 'cut' the vegetation polygons to the shape of the land parcels. Due to the complexity and number of polygons in each dataset this is run sheet-by-sheet. I have this working on my own PC using the WorkspaceRunner. The vegetation polygon sheets are stored as Feature Classes in an Arc Geodatabase and the WorkspaceRunner uses an Excel with a list of the vegetation polygon sheet numbers allowing them to run through the "Child" workspace one sheet at a time.The problems come when I try to replicate this with the ServerJobSubmitter. I can successfully connect to flow and have set up the workspace parameters similarly to those of the WorkspaceRunner above, however when I try to run this 'Parent' workspace I get the following error message.This error repeats for each of the individu

I read the line from a DXF reader, generate measure using the measuregenerator and then write it to a GML. The line including the curve end up perfectly in the GML, but I do not see any measure.Any suggestions?

Hello everyone, happy monday to you all, I have a dataset of points on a road network which I am trying to assign to groups of max 300 points. There are two attributes which must be the same for all the points in a certain group.  Also, to make the work of our editing team easier, the groups should be sorted by location. For this I am using the SpatialSorter (Hilbert sort in 2D). I am however getting some unexpected results. In the screenshot below I have selected all points in group 1100, also note the scale below to get a rough idea of this dataset:These points seem grouped correctly but they are not all grouped together. These are the points in group 1101:There is a large gap between these points (about 25km). Group 1102 (and a lot more groups for that matter) show the same gap:I guess there is some spatial relationship between these points, since they seem to be on roughly the same vertical axis, but it's not as accurate as I would have expected. Any explanation for this? This

Hi everyone,I'm new to Smallworld and FME working together. The only thing I'd like to achieve to update one attribute, not the geometry. I set fme_db_operation = UPDATE and I didn't give any geometry information. After running workspace i could see a few records being updated but translation failed with this message: Number of Features: 1Connecting to Smallworld on localhost:30000 using service FMENOFACTORYTable: 'gis.point_of_interest'NumberOfAttributes: 16Processing a pointError running translation. Do you have any idea why this happens? Many thanks

Here is my scenario: I need to very roughly georeference thousands of scanned air photos that are tracked in a file geodatabase. Oversimplifying things considerably, my fields look like: Filename (which contains location of the raster tif on disk)Center_X (map coordinate)Center_Y Rotation (always zero for my simple exercise)ground_resolution (in map coordinate units) I want to feed each "filename" to the rastergeoreferencer, using Center_X, Center_Y, rotation, and ground resolution. But I'm conceptually stuck... rastergeoreferencer obviously wants input from a raster reader, not a text string with the path to the raster. See the rub? Can somebody give me a push in the right direction? Thanks!!

I have been getting this error a lot: Excel Writer: Failed to open the dataset 'FILEPATH\\FILENAME.xlsx'. Error message was 'No such file or directory.'XLSXW writer: An error has occurred. Check the logfile above for detailsExcel Writer: Dataset 'FILEPATH\\FILENAME.xlsx' contains no data and is therefore not a valid Excel file. No file will be createdXLSXW writer: An error has occurred. Check the logfile above for details It will happen a few times and then the workspace will run as normal. This occurs in any Workspace I use that has an Excel Writer. In the Task Manager, if there was a process I could end, I would do that. It still happens.  Any Ideas?Thanks,-Loren