FME Form

Is there anyway to read in attachments while using the FeatureReader transformer. I know there is an option with the ArcGIS Online Reader but I don't know my Where Clause until after certain point in my workflow. Feature Reader was working perfect until I realized I couldn't read in attachments. Any help would be great!

Hi, My workspace has an AGOL reader (reads attachments too). Features are compared to existing SDE records and new features are then processed into the SDE (photos go to our DMS). Unfortunately, all AGOL records and attachments have to be read before comparison - even with our fast internet, it still takes 5 seconds per feature (6 photo attachments). Our test dataset has 1500 records (9k photos) and the production dataset has 100k records.My idea was to read the AGOL dataset WITHOUT attachments and then use an AGOL FeatureReader to just read the new features WITH attachments, but... FeatureReader is (or at least was) unable to work with attachments.The rest of the workspace is fairly involved, so I don't believe this is a case for a WS Runner. Ideas will be much appreciated.Cheers,Mark

 Hi, I have a table with many points, with an ID and two attributs, like this :I need to “dissolve” the points and get just one point by ID and in attributes get “Yes” if at least one of the original points had “Yes” as value, like this: Is that possible with some transformer? Thanks

I wanted to run a single sql query but with multiple variable value depending on my user input (to a parameter).For Example :When I type in VEGETABLE in my user parameter I want to run “SELECT * FROM <vegetable_name>”, where I have a bunch of different values for my <vegetable_name> variable, additionally I want to join all the data procured from running the query for all vegetable_names.

I use the “Esri ArcGIS Layer” reader to read an .lpkx file that contains 2 different feature layers, with different geometry (lines and points) but the reader fails to read both layers. It reads only one of the layers. Anybody with the same issue?FME Desktop ESRI Edition 2022.2.2.0ArcGIS Pro 3.2.0 64bitThanks! 

I am reading two AutoCAD files and sending them through a ChangeDetector to identify the differences between files.  For my updated features, I am trying to write out the attributes to my blocks to displayy the following attributes as extended entity data:Id, Update_1,Update_2, Update_3 (all the way through Update_10)Writer Feature Type Showing all the attributes.​​​​However, when I open the drawing, the Extended Entity Data is being written as such:Block Extended Entity Data is repeated, missed, and “garbled”.Can someone give me some advice as to why this may be happening?

Hi, Is there a way to change the color of the font for the part of the text that matches regex? In the scenario below I would like to put in red only the double spaces in Excell At the moment is highlighting the whole text in excel 

Hi, I would like to create a FME app that will allow users to check the gdb for wrong attributes. Each time the attributes in the gdb will change hence I need to find out how to do it automatically/dynamically.   

 Hello,I have installed a fresh install of FME Form 2023.2.2 on a Ubuntu VM with Azure. When running workspaces on FME Form 2023.2.2 with workbench, everything runs smooth. I have imported a manual license to the licensing assistant.However, I am trying to also install some python packages on this Linux VM. So we can transfer this to our Kubernetes Environment which also runs on Linux. We cannot install these packages on a Windows Machine cause they won't work on the Linux.Script: sudo /opt/fme-form-2023/fme fme -m pip install pandas --system --target /home/adminnordend/.fme/Plugins/Python/python310 After running this command we get the following Error: FME license system failure: FME is not licensed for this machine. Please launch FME Licensing Assistant to install a license. If you require more assistance, please send the following information to your local Safe Software Partner or codes@safe.com. Your registration key is 3-246-191-769. P

I’m dealing with a rather large JSON file. The issue I have is that some element values contain literal quotes and double quotes, and these are causing Rejections in the JSONExtractor. The quotes/double quotes are not escaped in the original source. Is there a way to escape these automatically with other FME JSON transformers?My efforts to fix thus far using the StringReplacers have resulted in errors throughout the entire JSON string, since quotes/double quotes are native to JSON formatting.

Is it possible to clip a Civil 3D surface using FME and then export it as a Civil 3D surface DWG file?

When I write to AGOL I get the following error message:|ERROR |Attribute(64 bit real)             : `Company_Material_Unknown' has value `1312'I’ve tried various data type for both the writer and the attribute manager before the writer.  Nothing works.  I have another AGOL writer in another place in the FMW (different data stream) and it works fine.

I am calculating measure values on a polyline from mile post signs, but we’ve found a problem with the input data.  There are a number of streets that are circles.   The street name is the same all the way around this loop, and the mileage increases clockwise around the loop, but when it gets back to the intersection, there are a few incorrectly placed mileposts.   How would I go about throwing out mileposts that change direction, such as going from increasing to decreasing, while on the same street? 

Hello everyone!New to FME here. I have a question regarding merging different geometry types into a single SHP. For example, for my scripts, I am converting over many features from a source DWG into a SHP. It seems to work correctly within FME Workbench where all features seem to be passed through into the SHP, but when I uploaded it onto FME Server to run on a nightly basis to update the resulting SHP, it states: Is there an alternate workflow/transformer to implement that would ensure that different geometry types would be merged into the SHP? For example, I would want line, area and arc geometries to be merged into the final LANE WIDENING SHP. 

Hello, We have been troubleshooting this FME translation for a while and can’t figure out a solution.  The Inserted, Deleted features of the ChangeDetector write reasonably quickly but the Update features are writing so slow it will be unusable, GIF for reference.  Things we’ve tried without any differences:Indexing all fields in ArcCatalogIndexing Just the Match Column fields (3 Fields to make a Unique ID)Indexing and using a CRCCalculator field for the Match ColumnsAdding a FeatureHolder after the ChangeDetectorAdding a AttributeManager after the ChangeDetector removing unused fieldsWriting to a File Geodatabase (SDE is ultimately the goal and being used in the gif below)Not Checking the Geometry in the ChangeDetectorChanging Transaction types in the WriterChanging and testing various other settings in the transformers and writers  

Hi, all, as the title suggests, we bought FME Server on the back of this information on the FME Website which reads "Esri’s I3S format is perfect for streaming large, heterogeneous 3D data across internet platforms. Create FME workflows to bring your 3D objects, meshes and point clouds together as a scene layer package (SLPK). This format is easy to handle and is ready to use in the cloud, on the web, or on your mobile device." Of course, we have learnt that point clouds is not yet supported. Can we get an update on what date the point clouds will be supported? Also, in the meantime, I think the FME website should be updated to more accurately reflect capability.

Hi there,I have following input:a list with unknown/varying keys and valuesWhat I need:the name of the keys as attribute valuesExamplesWhat I already tried:ListHistogrammer This has no effect. Is it because it’s a “nested list”? Cheers,Maria

Parcels are created, removed or changed in GIS,  but we also have a CAD Map3d basemap that we also maintain.  One of these basemaps contains a text layer that has the address number for each parcel, what I am trying to do is compare the parcel address number from the GIS against the cad basemap find out which ones have changed, removed or inserted then make the changes to the cad file.I have already setup readers for the GIS and CAD parcel polygons and using a change detector I know what is different compared to the polygon basemap, but now I need to take that result and check it against the text in the cad basemap and update it. for some reason the number of changes don’t seem to match when I compre the text.  how would you suggest I attempt to do this, is there something I am missing.

Hi, I am using FME to write tables into SQL Server, is there any setting for collation i can add Latin1_General_CI_AI Any suggestion is greatly appreciated. Thanks,Jay 

I have a problem writing a date field in a Filegeodatabase (open API Fgdb Writer)As soon as I enter these date fields manually, nothing is put in the Fgdb.In the attribute creator I enter @DateTimeFormat(20240101,%d-%m-%Y) so this should work.What can I do to make this work?

HiI collected some data with mobile mapping system and I classified the point cloud now I would like to extract the upper profile of the facades (red line in the picture) I tried to extract the maximun z but I doesn’t workcan you help please ?thx Francesco

Is there a way to setup a trigger in FME to send an email anytime a new record is added to the Feature Layer. I have an AGOL hosted Public Facing Application where the residents can add points and fill out some information. I would like to get an email every time a new record is added by the user. 

hola necesito encontrar en mi base de datos si tengo alguna geometría duplicada.Alguien sabe de algún transformador? 

Hello there,i have a big Problem. My FME-Desktop-Application crashes while loading the main window. If i start FME the littel loading window appears. But when the main window is loading the launcher crashes without any errormessage.Reinstalling the software didnt solve the problem.Have anyone a idea what i can do? Thanks 🙂

Hi guys, I would like to run a network analysis. I red some articles about this using FME but I got stuck. Hopefully you can help me out. Input data:Polygons representing buildings Polygons representing parks. Line road networkFor each building I want to compute whether its possible to reach a park within 300m distance using the provided network. Could you give me support in the right direction?I tried to use the MeasureExtractor and NetworkCostCalculator but did not manage until now.This image shows the general idea, walking from a building via the red line to a park in green.