FME Form

My user on the production MS SQL database has an ampersand (&) in their password and FME can't login with it.Is there any workaround for this without having to change the password ?This happens in both FME Desktop and Server.Edit @TiaAtSafe:The password also contains this special characters $&@=Versions:FME Server 2017.1.1.1FME Desktop 2017.0.1.1 (20170512 Build 17291 WIN64)

Hi! I have tried searching for an answer to this problem with no luck, so i thought i’d try making my first post in this forum!I am working with a polygon layer containing cities. I want to dissolve all overlappning cities by removing common boundaries and thus create fewer but bigger areas. The issue i have is that i want to sort this dissolving/mergeing by the population-attributute of the cities. In some cases there are  20+  polygons dissolved into one, and i want to make sure that the output polygon inherits the attribute information from the city with the largest population. I’ve tried using list-arrays of both population and city-names on the dissolved areas with little success, so i am very unsure of how to proceed.  Does anyone have any tips how to solve this?Many thanks!//Andréa  

Hello everyone,I am trying to run the Feature Outline Masks tool from ArcGIS Pro in FME using the PythonCaller transformer. I am new to Python and would greatly appreciate your assistance. I copied the script from the ArcGIS Pro tools website (as shown below) and made modifications to fit my data:# Import system modulesimport arcpy # Set environment settingsarcpy.env.workspace = "C:/data" # Set local variablesinput_layer = "roads.lyrx"output_fc = "cartography.gdb/transportation/roads_fom_polys"reference_scale = "25000"spatial_reference = arcpy.SpatialReference(4326)margin = "5 meters"method = "EXACT_SIMPLIFIED"mask_for_non_placed_anno = "ONLY_PLACED"attributes = "ALL" # Execute Feature Outline Masksarcpy.FeatureOutlineMasks_cartography(input_layer,output_fc,reference_scale,spatial_reference,margin, method,mask_for_non_placed_anno,attributes)Source: https://pro.arcgis.com/en/pro-app/3.3/tool-reference/cartography/feature-outline-masks.htmI modified the script in PythonCaller to fit my d

I have MSSQL ESRI Entrerprise Geodatabases that are non-versioned but have archiving enabled. As far as I have figured out, there are no ESRI tools that easily copy data with the full archive of the feature class.If it was versioned I could use the ESRI tools for replication…What is the current best methods for an operation like this?

I am using FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) - FME Forms.When running a workflow with the Data Inspector, from a file geodatabase with the SpatialRelator, the workbench appears to change coordinates on the fly. The dataset is in British National Grid (EPSG27700) with an expected data format of XXXXXX.XXX YYYYYY.YYY (depending on decimal places specified, ESRI being 3 decimal places resolution in metres).  An example is 283400.7988999998 377644.82890000001.However, inspecting the output, within the inspector attribute table and the feature information windows, this is replaced by an arbitrary grid XX.XXX, YY.YYY. An example is 66.069000000013411 97.342000000017881.  (These examples are different points). This doesn’t appear to be any projection or coordinate system with which I am familiar in this area and seems to be an arbitrary grid. Finally, when I click a point in the Inspector visual preview window, the coordinate system restores itself back to EPSG27700. This sol

FME Flow 2024.1 Is it actually possible to terminate a workspace that contains a JMSReceiver? I have a workflow set up and a terminator is triggered if certain conditions are met. This results in a Program Terminated and Translation Failed message in the log file but the workspace is not actually aborted and has to be manually stopped

I have a workbench file that generates the raster created by the QRCodeGenerator. So I have two output streams, the raster itself from the data stream and the PNG created by the PNG Format writer. Each QR code has URL data with dynamic parameters that can open an AGOL feature using the Camera app (Ios) or Google Lens app (Android OS). I’d like to extend this use case futher to include generating an email using the QR Code as a clickable image that opens the URL data of the QR Code.  The way to accomplish this is make the email in HTML with an HREF link to the QR Code PNG sent from that email. My challenge is how to create this email with Custom HTML that will make this picture an inline image on the email and not as an attachment or a reference to a picture stored from another server. Hope I can hear out out some suggestions or snippets of Custom HTML that will create this HTML email with the HTMLReportGenerator transformer. I do not have FME Server so I’ll have to use Form Emailer tra

Hello! I am currently trying to convert the CityGML models into FBX format using the workflow below.However, it was found that the absolute position of the FBX generated would be 100 times less than the original model. Therefore, I added a Scalar transformer in my workflow. There isn’t any problem in display but the relative dimension value would be multiply by 100 as well. The enlarged dimension could not be visually observed even being compared with other normal objects but the dimension value would be 100 times larger. (Not sure if I am describing the issue clear enough)Moreover, I also found that the Aggregator transformer at the end was not actually grouping the surfaces as one surface. They were just grouped under an object where this object was not a geometry. I tried the Surface Dissolver to merge the surfaces but in vain. If I don’t group the surfaces together, they will be exported as a series of Surface Member which would be difficult to manage during viewing.Therefore, I at

Hello, I have a geodatabase file to update with FME : some features must be updated, et some new features must be inserted in that geodatabase file. Those features are polygons with several attributes. First in my script, I read the geodatabase file. Then I change some values and create new ones.  Finally, I use a "Esri Geodatabase (File Geodb)" writer to update former data and insert new data at the same time. I chose feature opeartion "upsert" and table handling "create if needed". When I open the resulting "updated" gdb file in Arcgis Pro, I can see the updated data and... only part of the new features. There are several of them missing ! But why ? Here is what I should have : And here is what I get : Am I doing something wrong ? Is there a way to correct this ?   

I have set up an automation process that retrieves information from an API to generate a report. However, this task has become complicated because an essential piece of information we need to include in the report is located in a different API, which requires an ID to access the relevant data.I am considering generating the report first, which will consist of the necessary IDs. Then, I plan to make a second API call to retrieve the information from the second API, one ID at a time. I have successfully completed the first part, but I am now stuck on the second part and unsure whether this can be achieved using FME or if a Python script is the only solution.

Is there any example how to use fmeobjects.FMERasterTools.resampleBySpacing.When I run this code:        raster_g1 = feature.getGeometry()        raster_g2 = fmeobjects.FMERasterTools.resampleBySpacing(5.0, 5.0, fmeobjects.FME_INTERPOLATION_BICUBIC, raster_g1, {}) I get error message:Python Exception <TypeError>: descriptor 'resampleBySpacing' for 'fmeobjects.FMERasterTools' objects doesn't apply to a 'float' object

Hi AllI would like to extract the information of each folder and sub folder in different field with the folder and sub folder names as snapshot attached.I have 4 Main folder and  sub folders for each.  In a new column lets called : folderdetails - Active camera traps , Removed camera traps etc this has to be taken.Similarly for sub folders alsoAny guidanxce and support , I have tried doing but im not getting the way i should i needed  

I have built a custom transformer. Now I am looking for a way to share it with my colleagues, without having to actually sending them te file. Ideally, I’d have them show up like all other HUB-transformers like this:However, as the trasformer contains private information, I connot actually upload it to the hub. Is there a solution, for example through FME Server, where I can get my custom transformer show in this list, only for my colleagues?

I tried with google fusion Table, but the service is down. if anyone has alternative to mymaps for creating an editable map on field, i am all ears

Hi,  I am using the Change Detector transformer and had planned on using the Match all Except Selected Attributes parameter for the Attribute Matching Strategy since my list of excluded fields is shorter than the list of included fields.  I'm wondering if this parameter is working as it should?  Everything appears to have changed when I used this parameter (which is not correct).  However, when I reverse it and use the Match Selected Attributes (and select all the appropriate fields), it works as expected.  I can use the transformer the way that I have it working but I was wondering if I am missing something?  Thanks, fiona  P.S. I'm using FME 2013 Build 13264 WIN 32 with SDE 10.1 data (from SQL Server).

I think what I’m trying to do should be pretty straightforward and that I’m just missing something obvious, so I apologize if this question is not great …I have a workbench that uses sqlcreator to connect to some data in my db. I do a few transformations and then finish everything up with an excel writer. I’m having an issue configuring the excel writer correctly. 1.New records are being added to the db, and I occasionally need to rerun the workbench. I want the new records to be appended to original excel output. 2.Also in between runs, I am writing notes and other relevant information in the excel sheet on empty columns I created in the workbench. I want to keep the text I’ve written.The first time I ran the workbench I had the writer configured to INSERT. No problem. I thought I simply needed to change it to UPDATE and it would start to append new features to rows below the original, but instead I get an error because I don’t have a field to put in the Row Number Attribute field. I

Hi, I have a sample R script. While the output is correct, FME is logging incorrect information. The Code: library(sf)shp_path <- Output$shapefile_pathif (is.null(shp_path) || shp_path == "") {  stop("location empty or no exists.")}shp_path <- normalizePath(shp_path, winslash = "/")if (!file.exists(shp_path)) {  stop("location not found: ", shp_path)}print(paste("read shapefile:", shp_path))shape_data <- st_read(shp_path)if (is.null(shape_data)) {  stop("Error in shapefile:", shp_path)}shape_data$ano <- 2025output_path <- shp_pathprint(paste("Writing:", output_path))st_write(shape_data, output_path, delete_layer = TRUE)print("Success.") Log below: Error in utils::read.table(value, sep = sep, header = header, skip = skip,  :   no lines available in inputCalls: dbWriteTable -> dbWriteTable -> .local -> <Anonymous>In addition: Warning message:In file(file, "rt") :  file("") only supports open = "w+" and open = "w+b": using the formerExecution haltedFailed to

My goal is to read a directory of SDE connection files and then list out the database name and all the feature class names, tables, geometry types, etc. associated with each connection file. I've reviewed the articles below and can't figure out how to set the Feature Types to Read parameter since it only shows tables/feature classes from the one Reader as a Resource SDE connection. This isn't an issue if there is only one database but when there are multiple (like what I'm trying to do), it doesn't seem to work. Is this possible or is there another way to get this info? Here are the articles I've been using:https://community.safe.com/s/article/how-to-read-all-feature-classes-from-multiple-esri https://community.safe.com/s/question/0D54Q000080hHCASA2/read-multiple-sde-connect-file https://community.safe.com/s/question/0D54Q00008qzlJhSAI/how-to-dynamically-read-entire-schema-of-sde-geodatabase   

Hello there how could we find the closest road facing  the Building  from the North, south, Est and West the ides is to take each side of the building  check its facing what direction and then towered that direct we should check the closest road we can see from that building side  we are expected to get this result  each color represent the relation​​​​​​​I am attaching this sample data for referenceThanks​​​​​​​

Hi there, I keep getting this error message: ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '405' and the message was: 'This SqlTransaction has completed; it is no longer usable.'. Details: 'Unable to apply edits. Please check your parameters.'  Any ideas? It’s attempting a truncate. I have purged temporary files and tried to replace all the connections and make a copy of the workbench but still no dice. Thanks,Joe

I have an exsiting MS Access database. I would like to insert some updated rows to the existing table named tbl_STATIONS, so that the existing rows will be updated. However, it fails with the following error.Microsoft Access Writer: Failed to write attribute `Id_station' of feature type `tbl_STATIONS'. Provider Error `(-2146825023) Impossible de trouver l'objet dans la collection correspondant au nom ou à la référence ordinale demandé.'What is the issue here?

How can I use the Python caller transformer to call Arcpy and run the ArcGIS Repair Geometry tool? I have polygons from a file geodatabase that I'm importing into our Postgres SDE. After loading them, many of the records won't display due to geometry violations. I tried using the FME Geometry Validator transformer in my workspace, but it didn't seem to resolve the issue. Alternatively, is there a way to configure the Geometry Validator (or combine it with other transformers) to repair the data?

The Extension Dictionary information is written using C#, as shown in the picture below: 

I have installed Smallworld version 5.3.2 with FME 2022. Currently, there is an issue when trying to view the tables after adding a reader or writer:In the Smallworld Explorer application, I added collection X in the Exporter section and collection Y in the Importer section.When I insert an FME Reader or FME Writer, in FME, when I request to display the collections, FME always shows the collections added in the Exporter section for both the reader and writer.Is this a bug, or is there something else I need to configure?

Any idea how I could cut my 3D surfaces pipes where the 3D surface wall stands ?Thanks