FME Form

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. Program TerminatingBut the system is licensed. 

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.  It seems to work when I run it and examine the SHP in the FGDB that I have created, but many warnings appear once the scripts are loaded up onto FME Server.Any tips would be appreciated - thank you!

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  Thank you for any suggestions!!

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. 

I am trying to use FeatureWriter to create tables in various different PostGIS databases. I am specifying the Database Connection (host, port, database) using attributes from the schema feature but I'm getting the following error:FeatureWriter (WriterFactory): MULTI_WRITER: No dataset was specified for MULTI_WRITER_DATASET or FeatureWriter_0_DATASET or POSTGIS_DATASETMULTI_WRITER: No dataset was specified for MULTI_WRITER_DATASET or FeatureWriter_0_DATASET or POSTGIS_DATASETIf I hardcode the database connection parameter the FeatureWriter works as expected, even with host and port still using attribute values. I have used the database attribute successfully on a FeatureReader in the same workspace so can't understand why it's not working here.Any suggestions on why this might not be working or how I could get around the problem would be much appreciated.  ThanksTom

Lines/polygons contain ordered data of every vertice that they are made up of. Is there an easy way to extract ALL these positions as points? (preferably while retaining attributes) 

I’ve read this article : https://support.safe.com/s/article/autocad-to-ifc-conversion-example that converts a DWG plan consisting of a 3 storey layer , and all the object have a HEIGHT attribute that is used to extrude the 3D geometry from the 2D input , then the ifc file is created with all the infos in a single ifcSpace . But my need is different ,in the input , my autocad file has attributes of HEIGHT , as well as TYPE ,which would contain the type of each object (WALL , DOOR , WINDOW , Stairs , etc ).and so i want the output ifc file to be a rich file with multiple types of objects : ifcDoor , ifcWindow , ifcWall ,.. . instead of just a 3D model in an ifcSpace .