FME Form

When I am using a regex in a string searcher, the output is as expected. When I am using the same regex as @FindRegularExpression in the Attribute Manager, my script always fails. What do I need to modify in the Attribute Manager regex? Thanks

I have a workbench that goes as follows:Read in attributes from a CSV. The attributes are locations, and Join those records with a buffer and spatial relator to find potential conflicts near the input locationWrite out the records to a PPT fileThe input table would look something like this  Location 1 | Table Text 1 | Table Text 2Location 2 | Table Text 1 | Table Text 2Location 3 | Table Text 1 | Table Text 2 And ideally, the final PPT file would look like this:Title Slide: Location 1Table Slide: Table Text 1Table Slide: Table Text 2Title Slide: Location 2Table Slide: Table Text 1Table Slide: Table Text 2Title Slide: Location 3Table Slide: Table Text 1Table Slide: Table Text 2and so on It's in step 3 that I run into issues. I can't find a way to dynamically filter attributes so that I can write to separate slides like I see in the tutorial. The attribute names aren't fixed, so the Attribute Filter doesn't work, at least not that I can see so far. https://community.safe.

Hi everyone!I'm new to FME and I have a question on how to group entries of a table based on two columns. This is the table:Now I want a new column with the group ID. It should look like this:Explanation:If the fruit is the same, they should belong to the same group --> Apples are in group 1.If the Buyer of group 1 also buys other fruits, then these fruits should also belong to group 1. -->Anna also buys Bananas, therefore Bananas belong to group 1 I tried different transformers, but did not find a solution. Can someone help?

Hello , i have many lines and many points .i have used anchored snapper then topology builder then edge output as in input network for shortest pathfinder and I used every point connector transformer for points to get lines to use it as input for from to shortest path finder . my question : i need to find all routes that possible .shortest path finder has found many paths but there are still too many no paths .How could I find all routes between points ?then extract ids from each route .i hope there is a good idea let me know .i have spent much time but no success .fme 2021

In Portal for ArcGIS 10.6.1 in the backups folder there is a walarchive folder. The files in this folder accumulate daily. Annually 14,000 files are created. Each year these 14,000 files together equal approximately 143GB. There is no setting to change this in 10.6.1.   Every January, for example, in order maintain a reasonable amount of disk space, I manually delete the 14,000 files from the prior year. It is a fairly straightforward task to delete these files, but I am starting to wonder if I could create a workbench and let FME do this.   The file names are random digits and sometimes a letter is included in the name. There does not seem to be a pattern to the file names. I cannot reference the file names in a workbench because of this.   The only way to identify which files to delete is by the Data Modified column in Windows File Explorer, example, delete all files between 1/1/2022 and 12/31/2022 would be a single year.   Here is what I would like to do in FME:  1) Select all files

I have the following problem: I have multiple csv files with multiple columns. I want to dynamically change which columns to read.I have a user parameter to define which columns to read.  Even though the " Attributes to Expose" Parameter of my FeatureReader gets updated correctly the Reader dosn't read the correct columns.Only after opening the properties of the Reader and closing it again by clicking "Ok" the Read reads the correct columns.  I'm using FME Desktop 2020.2.3.0 on Windows 10 Maybe someone can tell me if this is a bug or if I'm just overlooking something. Many thanks in advance !

Hii all,How can I optimize the performance of my FME workflows when dealing with large datasets? Any best practices or recommended settings to consider?Thanks in adavnce.

I'm working in FME2023 build 23283 using an Intergraph SQL Warehouse reader. I have a rather lengthy process that deals with comparing a single 'target' feature class against multiple other 'candidate' feature classes (defined by published parameter via Features Types to Read on the reader. This process needs to be reiterated for several 'target' feature classes. So instead of trying to implement Group By throughout the workspace, I've decided to use a WorkspaceRunner to run the workspace separately for each 'target' feature class.  The issue I'm running into is passing the Features Types to Read parameter from the parent workspace to the child. I have simply copied all the published parameters from the child to the parent workspace. This is the command line being passed (non-pertinent info redacted): This is the warning/error I'm getting. It seems as though the WorkspaceRunner is not respecting the space-delimited format of the Features

I am using a featurewriter to update 3 three fields. For this update, I am only exposing the fields that need to be updated, because I have found that works best.However, I need the rest of the fields in the dataset downstream.I ran an attributeexposer to reveal the other fields, but they all come in with null values. These fields do exist in the dataset, and they do have values. How do I access the fields in such a way that I can see the values in them?Thank you,Randy McGregor

Hi everybody, I was wondering if anyone can help me with clamping 3D Building Tiles to the Cesium World Terrain. We are developing a 3D web application with Cesium JS and we need to have our 3D buildings sit flush with the Cesium World Terrain. Our input into the application are 3DTiles. I know you can clamp citygml files to the terrain with the in-built clamp to ground tool in Cesium ion but is there any way to get 3DTiles clamped to the ground in cesium JS or with the help of FME?We use FME to create our 3D Tiles but we have not found a way to get the buildings to line up with the terrain. Is anyone here aware of anything I can do in FME to get my 3D Tiles output lined up with the Cesium Terrain?  I would really appreciate some help on this! Thank you,Jan

Dear Sir/Madam, I would like to export fbx to cesium tiles.  My FBX model structures are follow11-NE-12A\\BXXXXXX11-NE-17A\\BXXXXXX I would like to export at the same folder structure in Cesium tiles.It gives me an error when I use the fanout expression. And now, I only able to create the following folder structure. 11-NE-12A\\BXXXXXX\\BXXXXXX11-NE-17A\\BXXXXXX\\BXXXXXXMay I know how to fix it? I have attached my sample data and fmw in this email. And I hope some experts can give me a hand. Thank you

Hello ,  i got 6 lines at rejected port from network topology calculator transformer .the reason is invalid line geometry .How could I fix it ? What does the reason and what should I check ?FME 2021 thanks in advance .

Hi.  I'm having trouble seeing views in a REVIT file with the FME Form reader. I can't see the views of the Area Plans as per the Project Browser (see the attached image) but I can see the Floor Plans and 3D views. I've set the Read Geometry As: parameter to Floor Plans and then specified a view to read. The ones that I need aren't visible though. How do I expose these? via attribute or a different method? Many thanks,Michael

I have 64-bit FME Desktop installed (version 2017.1.1.1)I also have ArcGIS Pro installed (version 2.0.1)When trying to add readers requiring esri licensing, for example Esri Geodatabase (File Geodb) or Esri Geodatabase (ArcSDE Geodb). I am getting the following error message…Unable to perform any licensing related tasks. This 64-bit version of FME requires 64-bit Background Geoprocessing, ArcGIS Pro or ArcGIS Server. Refer to this this article http://fme.ly/qua for more detailsI have added the path to the ArcGIS Pro executable to the system PATH environment variable. FME still does not seem to see that ArcGIS Pro is installed. What do I have to do to get FME desktop to recognize the installed ArcGIS Pro?

Hello.I have some data like this:123 m32 m56 m...and I want to keep the numeric part and ommit the unit (m). Which way is the best?

I was able to create a Portal Web Connection from the Template but after I 'Authenticate' nothing happens--the window does not close and I can not proceed to the 'OK' stage and move forward. What is the problem?... this process works fine when creating an ArcGIS Online connection because the Authentication window closes automatically and you can finish the process, but with Portal it just stays open and shows my portal and there is no way to finish the process. Any help would be much appreciated! !

I have self interaction in line .line has id but it make circle and intersect itself .how could I remove the intersection point at same line ? my problem : after using intersection lines ,I found this line divide to 3 lines ,because it intersect itself in point .will be possible to let intersector Transformator to create find intersection lines but between different id and ignore the intersection lines for line that has specific id .Could I specific it in parameter ,to find intersection lines only for different id ?

Hiwhich is the correct css to extratc only the first div  this not work #tabella > tbody > tr:nth-child(-n+30) > td.text-left > div:first-child thxFrancesco

Hello, I imported a point GIS dataset into FME to export it with datasmith into unreal engine. The dataset is point based (I used vertex creator). When exporting to unreal, the scene is empty. Essentially, I need to convert each point into a 3d object (like identical cubes) which will be read as a static mesh with UE. I am banging my head against the wall trying to figure out how to do that.... I tried to play around with 2dboxreplacer and 3dforcer but they don't give me any results.Any help or tips will be very much appreciated. Thank you so much!!!  

Is there a way to dynamically set the "Attributes to Expose" option in the Feature Reader Parameters dialog box.  I've set a variable equal to the attributes I want, and I've created a user parameter pointing to a .csv file containing the attributes (one on each line), figuring I could update the .csv each time through a loop with the attributes I want from the next file.... but neither of these worked (at least in the form I tried them): I apologize for asking so many questions. I promise to answer some when I get better at this.

I'm using the CSV Reader to import a file that contains all of our AD users information so that they can be imported into other systems.  I've noticed a strange thing on the nightly Job I set up on the FME server with my workflow, that the output file doesn't have newly added rows from the day before (new employees). Though running the workflow manually seems to pick up the users, hence some of the confusion. I've refreshed the reader with a new one, that sets the datasource as a parameter and have tried tweaking some of the advance setting with issues still continuing.  I did try the AD Reader, but it was extremely cumbersome with my lack of knowledge of AD structure and required me to map multitudes of OU's to just get the users, and even then I was still missing some. Thoughts on how to get this thing to "re-read the file for each job run on the FME server?

Have anyone managed to correctly set up FME Desktop (not FME Server - this is OK) to use Azure AD when logging in to an FME Server with Azure AD? I have changed the template and the TENANT_ID and OAUTH_SCOPE and set the redirect url to http://localhost . However I get an error. Not sure where to go from here The scope set is: scope=openid+profile+offline_access

I made a workbench which takes a .zip folder as a source, which contains .csv files, and sometimes an 'attachment' folder which contains images or videos. The output is an xlsx file, a dxf file and if there is an 'attachment' folder, this 'attachment' folder. This workbench will be used through a workbench app in FME Server, the xlsx and th dxf data can be retrieved from the 2 featurewriters via the data downlaod service, but I have no idea of how to read and write a folder with file extensions I can't know. The only solution I see is to move the folder. So I made a python script which unzip the entry file, check if there is a 'attachment' folder, and if so, move it to 'FME_SERVER_DEST_DIR', so it can be downloaded from the url with the xlsx and the dxf. Here's my problem. With a .zip file with only .csv file and no 'attachments' folder, there is no problem, I get my url to download the data and I get the xlsx and the dxf. But if

"extent" field stores information like '0103000020430D000001000000050000009C43A5BC013D5EC15.............'