FME Form

Hi, I am new to FME so might be making a rookie mistake. But I am trying to update AGOL from a GDB shapefile but it won’t update in AGOL. I have managed to get everything to work and it shows the updates but its not sending the data to AGOL. What am i missing here?   

I have a fairly simple problem but can't seem to figure it out. I need to copy one excel file to another folder and rename the copied file. I've tried using the PATH reader and the File Copy Writer but nothing seems to get copied. Any ideas?

Hi everybody,My client has a spreadsheet that contains a list of Google Map urls embedded in text, inside cells in a Google Sheet. Using the Google Sheet  V4 reader, I am unable to read the url of the embedded text into the workspace. For example, I cannot read the url for the Google Map url for Safe’s location in this spreadsheet.  I’m really hoping to mine the lat/long coordinates from these urls. I use FME Desktop V2021.2.2.0 in production, but have Form V 2023.2.1.0 available, if needed.Thanks!

HiCurrently I am converting a DWG file to GDB (file) / SHP,The DWG file itself has line and polygon and they have color based on their different layer name.Once I read the file, it showed only FME feature name, I used AttributeExposer to add autocad color column and a few more useful information, then I used DWGStyler and FeatureColorSetter but once I write the file to GDB or SHP and bring the data to ArcGISPro, the layer has only one single color. (Please see the attachments) Can someone give me a clue how to solve it? 

I have a .csv file with x, y, z coordinates. From these points, I want to create a 3D line. Currently, I have the issue that the z coordinates are not being transferred onto the line when I create a line from the points. Does anyone have an idea of how I can proceed?

I had a FME scenario running to read the feature service and related tables and write to an excel file. I have the excel writer setup to “Fanout” the dataset which used to drop each table from the feature service into its own sheet within excel. I went back to run the FME scenario and when I check the excel outputs some of the tables are missing. Prior to running the scenario I check to make sure all the tables are checked and that the reader is seeing all of the tables, which it is. I check “select all” and run the scenario but when I check excel I get 6 of 9 tables. I have double check every setting and even started a new FME template and recreated the reader/writer but I still don’t get all the tables in the excel output.Can anyone help me out? Thank you

Hi Everyone..I was able to find a workspace from community this template attached and did few changes to it and it is working as expected with sample template provided in workspace to create a GDB with domains , fieldnames and field alias.      1) This workspace consider single default words in domainlist provided in excel  only like Domain1 -      Attached Sample_1_Workspace template - works with 2023 version.This workspace consider single altered words domainlist like alphabets(A,B,C….) in Attached Sample_2_Workspace_template - works with 2023 version  This workspace consider 2 words in domain list like FME form in attached sample_3workspace_template -doesnt work and workspace fails.. If there are any special characters or space it doesnt work like : FME Form or FME_Form. I have attached error log and all sample data files with with each workspace.. Any Experts Kindly support : How can i resolve this with text as FME Form or FME_Form (with a space or special characters. Thanks

Greetings, I’m trying to use an ETL to convert RVT files (2023) into File Geodatabase multi patch, however, the following model produces the right objects, but in the wrong location, even though when reading the RVT file directly in ArcGIS Pro, the building falls in the right place. Any clue? 

I have been trying to set up a batch process to create dwg files, adding a template based on the respective input file.  I have tried to follow the advice from the links below, but am missing something or what I am doing isn’t quite the same.  At any rate, my workspace fails after trying numerous different configurations.  Published ParametersBatch processing I have attached the two Workspaces.  The goal is to apply a CAD template to it’s respective output file, with the inputs controlled by the WorkspaceRunner parameters. The Workspace that outputs dwgs takes inputs from three sources:  Two different folders of CAD files (one of which also happens to be same as the template but used for a different purpose), and a spreadsheet .  Any insight is appreciated. Thanks.

My dataset contains some river basins polygons, with 1 forestry polygon falling into each one. Each river basin also contains multiple habitat polygons. I am trying to measure the distance (edge to edge) between the forestry polygon and each of the habitat polygons falling within the same river basin. I’ve done some spatial joins to associate each forestry polygon and each habitat polygon to it’s respective river basin, but I’m unsure how to measure the distances between them, while grouping by river_basin_id. Any help would be greatly appreciated.

Hi All,I’m trying to improve the performance of my workbench by reducing the number of transformers. I was able to use AttributeManager to calculate the length of lines with the expression @Length() but I can’t work out how to round up the value up to 3 decimal places,Is that doable using the arithmetic expression instead of AttributeRounder transformer? 

Hello,I am trying to convert data from shapefile to DWG.To do that, I am using the DWGStyler to assign the correct setting to each object.Reading the post in the community, I am able to use the DWGStyler using a template and the right color is assigned to each object in CAD so, I see the match between the color in the canvas and the color in the Layer’s list. But, in some cases, I don’t have the template and when I open the file in autocad I can see the right color in the canvas assigned by the DWGStyler but in the Autocad list layer I see all layers in “red”, I attached an example. How can I resolve this situation to have the perfect match for the layer’s colors to avoid a manual rework without using the template? Thanks Max  

I have a Flow App, which performs a relatively long process, which at the end directs the user to a certain url following the success or failure of the process.The url reference is made by a single HTML writer at the end of the process.My problem is that this process can take some time,And in terms of the user experience, the customers are not aware that the process is running behind the scenes.I want to make a reference to some kind of loading GIF that will at least show them that something is really moving behind the scenes..And this is where I need your help.Because if I write to two HTML writers, it simply downloads the two HTML files for me,It does not direct me HTML line after HTML, but simply disrupts the process.Does anyone have a solution?It doesn't even have to be a reference to the HTML of the loading GIF, just an indication in terms of the user experience that will tell the customer: "Don't worry, a few seconds and you move to the next screen"Thank you!Dor

I’m working on an upload process via REST call and I want to use FME to do the upload.For the API I need to provide a list of file names in advance. I want this to just work and I want to be able to use FME’s multiple file picker to allow the user to pick folders, multipler files or just a single file. etc.Does anyone have a good/robust method for getting a full list of the files (and filenames) that this input could be.My initial plan is to split up the input parameter into a list and then figure out what are folders and what are files and for folders I would use a PATH reader to get the files.I guess I need a “MultiFilePathResolver” kind of thing. 

Problem in short:I have a lot of points which some has identical coordinates. PointOnPointOverlayer does this for me and store the “twins” in a list name. Now I want to use a Pythoncaller to loop through the list of each feature and figure out if some or none of the twin attributes has a value that should update the the major feature. The problem is that I cant seem to reach the list variable created in PointOnPointOverlayer from the Pythoncaller. It seems to be exposed when running with feature cache and checking output from PointOnPointOverlayer. What’s the magic for reading the list, looping throug it and check the attribute values? Tried this example code from the PythonCaller just to see if I could reach the list but can’t see anything:  

Hi everybody!I have a point layer and a line layer. The line layer consists of connected lines, and at the lines endpoints there is a point from the point layer in the exact same location. I moved the points in the z-direction because their height had to be corrected (new z-values were derieved from a point cloud). Now i also want to move the corresponding line endpoints in z-direction as well so that they again match the points in x, y and z. I guess the AnchoredSnapper with Group Processing could do the job but don’t know how to prepare the data for that. Can anyone help me with this? red: original position of points and lines; green: points moved in z-direction due to height correctionQuestion: How can I make the lines follow the points in z-direction? I am grateful for any advice!

Hey! I have an 50 diffrent  MXD and I need to retive the map extent from start  in every mxd. There is an option to igonore map extents.But is there an an way to extract the start extent? 

Good morning,I would like to use FME processing to "periodically" update the values ​​of certain Utility Network attributes.This concerns the updating of data which potentially can be versioned, but I am only considering here the updating of "descriptive" (simple) attributes which are not involved in asset group assettype distribution rules and which have no impact on connectivity rulesDo you have experience of the best methodology to use and perhaps illustrate this with an example Workbench?THANKS 

I have two polygon datastets and i send them to the Topology Builder so that they will get break at the intersection. However it does not give the result I expected. My expectation would be a similar result to thearea on area overlay  my output looks. The overlapping area are not broken. Any idea what i may have been doing wrong 

Hi Community,I need to extract a CSV Style content from a SQL field of an SQL table.It is stored into a single field.The content looks like this:Classification,Fonction03-1,30003-2,301AA-10,C-1000AA-12,C-1000AA-15,C-1000AA-17,C-1000AA-20,C-1000AA-22,C-1000AA-25,C-1000AA-27,C-1000AA-30,C-1000As you can see, the first line gives me the Attributes names and the following lines gives me the valuesWhat would be the best way to turn this into multiple features using the first line as the Attributes names ?Thank you

Hello forum, I am working on a new API integration. I’ll be using HTTPCaller. The provider has said that their authentication method is ‘bearer token’ However the options in HTTPCaller are Basic, Digest, NTLM, Web Connection, Single Sign-On. Is one of the those options equivalent to bearer token? Thanks,Stuart

Shall we consider installing a Graphic card while preparing a machine for FME Form installation. How a Graphic Card impacts on the performance of 3D / 2D data processing.

Trying to find a  way to find the maximum amount (highest density) of polygons with the rulethe polygons must be non-neighbouring. Essentially selecting a polygon and jump to the next polygon which is not neighbouring and so fort and so on until you encounter a neighbouring one.See attached picture which I hand-picked.

Hello fellow FME-ers. I'm looking for a transformer to compare two GIS datasets and what has changed compared to each other. Actually, the Symmetrical Difference tool that is present in ArcGISPro. This transformer must be there in FME. Can anyone help me with this? Thanks in advance.

I have a test looking for many possible cases. one of the cases I want to find is Any folder inside of any folder that has some specific names. (BTW I am using directory and File Pathname reader to create a list) and then a tester to get all of the special cases.)I have a test line like path_directory_windows CONTAINS *\project_data\working\**\*I don’t get any errors with this syntax but it does not find the folders. Basically i am only wanting to find folders within any project_data\working folder that contain any files.If it doesn’t contain a file I am not concerned with it.Any help with a correct regex statement that would work, or the proper syntax for the contains statement are what i am needing.I have tried this regex unssuccessfullyproject_data\/working\/[^\/]+\/[^\/]+TIA