Best Answers

Hi, I'm trying to access the property sets within the Extended data from dwg file, the property sets are attached to block reference objects, quite similar to the case of this post. Attached below are two snapshots from how the property sets look like in Autocad and FME workbench featuring the two attributes that I was trying to expose with no success can someone guide me through the detailed workflow, please? I'm using FME workbench 2024.2 Thanks,

Dear FME Community, I need to calculate measure PK from an object, modify them and apply to another object for cut it to elements. I try to explain all steps with this schema : I’m at the STEP 4 but I’m blocked when I want to apply my Measure PK to another objet. For that I’ve a FMWT in ZIP join to this subject. Thank you for your attention and your help. Geo-x

Anyone come across .nt files (N-Triples) files? Their doesnt seem to be a native FME reader for it.

How can i extract data from this line? {"sl:stand": {"sl-bag-extract:bagObject": {"Objecten:Pand": {"Objecten:status": "Pand in gebruik", "Objecten:geometrie": {"gml:Polygon": {"@srsName": "urn:ogc:def:crs:EPSG::28992", "gml:exterior": {"gml:LinearRing": {"gml:posList": {"#text": "114062.419 542728.035 0.0 114067.343 542726.792 0.0 114067.637 542728.082 0.0 114068.445 542728.468 0.0 114069.011 542730.438 0.0 114068.36 542731.246 0.0 114068.639 542732.471 0.0 114063.762 542733.793 0.0 114064.204 542735.512 0.0 114057.619 542737.161 0.0 114055.721 542729.372 0.0 114055.572 542729.428 0.0 114053.081 542719.589 0.0 114059.937 542717.727 0.0 114062.353 542727.763 0.0 114062.419 542728.035 0.0", "@count": "16"}}}, "@srsDimension": "3"}}, "Objecten:voorkomen": {"Historie:Voorkomen": {"Historie:BeschikbaarLV": {"Historie:tijdstipRegistratieLV": "2010-11-26T12:31:16.436", "Historie:tijdstipEindRegistratieLV": "2014-10-27T12:32:20.904"}, "Historie:eindGeldigheid": "2014-09-25", "Historie:beginGe

I have a job running that takes 10 minutes and generates 19.000 rows in the log. The runtime is not the issue here, I'm just curious to out some numbers on time-spent. What’s the best way to find out where the time is spent? I suspect a few specific transformers, but since this is probably a common question I wonder what other people are doing.

Hi. I'm reading dwg files with the civil 3D reader. I need to use the attributes in the propertysets. this works perfectly with exposing 'autocad_xrecord_datalist' in the reader for all geometry types, but not for the blocks. the property set attributes from the block don't seem to be present on the 'autocad_insert'. I tried exposing fme_attrib_info but they are also not there. any ideas? or is this just not possible on blocks ? i added a screenshot of the pset in the dwg

I have a workbench which is calling data back for 8 reports via 8 different httpcallers. I can add a date parameter to the URL to call back one date at a time. I have 60 dates I need to individually grab the data for. How can I get it too complete the workbench, move on a day and run it again, and again...and so forth, through a list of dates?

Hi, I would like to ask if there is a way to share webconnections to group of users with partial permission (ie only access permission) not full permission. the issue with full permission that the shared users can be able to delete web connections I shared. I have to tried to take off their manager and create permission but still wont be able to let them do not remove the share connection. We are looking for a way can do partial permission setting up. Thank you very much. 😁

Hello everyone, I encounter a similar problem to the following post from 4 years ago.I am able to write several output files (2 .dgn files) in FME Form. However when I publish the script to FME Flow and run the script in the form of a workspace I only get one output result back. I already looked into the Data Download Service Properties when I publish the script to FME Flow and both writers are already included in the Writers in Download attribute. So I am not sure why I don't get both files in the zip file. The files don't have the same name. The weird thing is also that the dgn file I get back from FME Flow has the same name as the zip file, while in FME Form they get the name I have defined in the writers (Bomen.dgn and Kabels_Met_Buffers.dgn). Another finding is when I look into the translation log on FME Flow, it looks all features are written (23000 features). I know that 18000 features are in one file and 5000 features in the other file. So it looks like all feature are written,

Has anyone run into an using the OGC WFS Reader for a WFS hosted by QGIS Server where the coords are swapped? Before I go back to the provider with the observation “hey I think there’s a bug in how your service is being delivered” I’d like to check that it’s not a known issue etc. To use the service I had to do the following: Thanks for any ideas!

Hello, This should be a very simple thing, but I just can't figure out how to do it! I want to append two tables together (Tables 1 & 2), both with very similar attributes, but I want to use the ID from Table 1 as the official Primary Key, and then get the highest number from that PK and increment upwards to create new PK values for the Table 2 appended values. I can get the maximum value from Table 1 using StatisticsCalculator, but I can't for the life of me work out how to use that value in the creation of the new Primary Key. I've been trying to do a conditional value calculation in Attribute Manager, something like, if Table 1 ID has a value, then PK = Table 1 ID, else use MaxValue from StatisticsCalculator and sum it with @sum(@double(@Count()),1.0) to increment up. But it's not working. Any ideas greatly appreciated! Thank you! Katrina

Hello, How do I add a datestamp to a file name in the Excel Writer? I tried adding @Value(_timestamp) to the Writer output and all I get is the file name Bldg_Pts_@Value(_timestamp) as the file name. No date.

Hi there, I am working on a data clean up model. Many thin areas and remnants have been cleaned up but I can't figure out how to this last thing. There are some thin areas that connect on both sides to a large and very complex polygon. (See image) Does anyone have a suggestion for how to remove these type of areas? So only the thin parts have to be removed.

Hi everyone,I need help, when i upload my shape file in fme which is in gaus kruger coordinate systemI want to change coordinate system into epsg 32634, and when i use coordinate system setter, it changes, but its not exactly how i need it to beSo i need to do something called transformation, and i need help with how to do that, if its posible to do transformation in FME?

Hi, I was wondering if there are some best practices and or style guides / examples on for workspaces. Some questions that I have about this (besides the obvious: avoid crossing as much as possible, annotation, clear transformer names etc) Like is there an agreed style for public and private parameters (casing, under scores, ...) Is there an advise on how many transformers can be put in the main part and how many in a custom transformer? How many custom transformers can be nested into each other or is it advised to not do this to deep (performance impact) Any other good to implement styles?

Hello, I have a question regarding the implementation of dynamic attributes. I created a flow to turn a single attribute into text for the actual values of the column and row of an attribute; Following the pattern below: Original Attribute Goal After achieving this, the biggest problem is that these 'dynamic' name attributes come as unexposed attributes. Unexposed Attributes I could simply place an AttributeExposer and resolve this case, but the problem is that the flow will run in several different scenarios, and the values (A, B, C, F) will never be the same; they can vary to anything (G, H, T, Z, B, A, or K, LL, BN, XS, D). Therefore, I need the exposer to work automatically as well, but I couldn't make it receive @value(list_name); it literally exposes the value '@value(list_name)' as if it were an attribute with the name of the code. Thank you for your assistance! Best regards,

Workspace I’m uploading from FME Form (2024.0.1.0) returns this error. Failed to update definition of database type 'Microsoft SQL Server (JDBC)' - FME Flow encountered an error and reported the following message.Database type Microsoft SQL Server (JDBC) cannot be edited.Request to http://XXXXXXXXX/fmeapiv4/databasetypes/Microsoft SQL Server (JDBC) returned status code 422. Is a workspace that has SQL Executors pointing to a SQL Server database and outputs results to a XLSX file on my laptop. Any help would be appreciated.

This job works fine in FME Workbench 2024.2. But in FME flow, when I try to run the workspace, it’s trying to create a folder instead of a .xml file. See screenshots

We have an FME Flow Hosted instance running and I need to connect to an MS SQL Server. I have seen from the Reader/Writer documentation that MS SQL is not supported from FME Flow Hosted. Does anyone have a suggestion how we could still connect to MS SQL? The question is very relevant to us, since we plan to migrate to an FME Flow that will also run from an Linux-instance, which seems to be the cause why it isn’t possible to connect to MS SQL. N.B. Our current FME version is 2024.0.3.

Hello everyone, At our organization we work on a virtual machine. When you log on into a virtual machine, you share the virtual machine with other users. Since a few weeks we encounter sometimes black screens when trying to use FME form 2023 or FME form 2024. I googled and the problem is quite similar to Known Issue: FME Workbench 2023 Opens as a Blank Window on a Virtual Machine – FME Support Center, instead it's a black screen. The article mentions about OpenGL versions, however the specs for all our virtual machines should be the same, so I think the cause is different. When you encounter the black screen, you can only hover over the black screen and can't do much else. When you close FME Form and try to open a new FME Form sesssion, you still get a black screen. The only workaround is to log off and log into a new virtual machine where this problem doesn't occur. We already did some troubleshooting and we know one thing for sure It's possible that fme form 2023/2024 initially worke

Hi, I am using the attribute creator to populate a new field. I want to fill in the blank rows with the previous master property number from the master prop no field. I have enabled the adjacent features but no matter what I try it still only populates just the 1 record after a value and not all the blanks. I thought I would only need 1 based on what I’ve found on the forums. What am I doing wrong here? I also tried to do that same thing via the attribute manager but get the same result. The end result would also have row 3 (FME row id not the xlsx one) with ‘932590’ and row 6 with ‘933123’ and rows 9-11 with ‘933796’ etc with the number of blank rows varying from 1 to potentially hundreds. The settings I have for the transformers are below. I am using FME 2022.2. Thank you! Belinda

I am trying to fill in the rows of my table with the previous values. I saw this thread and I am following the instructions but for some reason I am only getting the first empty row to be filled but not any subsequent rows. I tried to change the Subsequent Features to another value other than 0 and even tried to change the number of Prior Features but I always get the same results. I am on FME Form 2024.2.0.0 if that helps. Any suggestions as to what I am doing wrong?

Hello, so we have now switched from Server to Flow and all is good and great except from one bit, and that is there have been made some changes between these versions that have made my emailer workarounds from Server useless. So what we did before is that we just set up the Emailer in the workspaces and sent automatic answers in the ‘Body’ section of the Emailer such as: p>Hello Colleague</p> <p>Here is your GeoJson to DWG/Shapefile datapackage:<a href="$(FME_SERVER_DEST_DIR)">Click me to download</a></p> Where the ‘$(FME_SERVER_DEST_DIR)’ was the download link for the result and it worked very well. But now on Flow it doesnt work, the email sends and all but there is no value being fed into the ‘a href’ so now download hyperlink for the message. What has changed here, is it only the value for the URL and if so what value should I be referring to now to get the result data on flow downloadable? If this has now been made very different then what should I be doing differently? To be clea

I have a 2023.2.1 workbench that reads in a JSON file using the TextLine reader, does some FME magic and the outputs the results for FME Server (Flow) to use. 2023.2.1 workbench to process JSON The reader parameters are set to read the whole file at once The workbench is published to FME Flow 2023.2.1 and is used in an Automation that gets an AWS SNS message with the JSON info in the message of the SNS. The SNS is received as expected but the message appears to be reading each line as a separate source and as such it never processes the file as expected. Any advice as to what I am doing wrong in the process?

Hi All, How can I add a conditional parameter (visibility) in FME 2022? I know it’s possible for 2023 but can’t find it for 2022. I have created a workflow that allows the user to export data into different formats (E57, CAD, LAS, XYZ) and I want to offer the option to export the data as DWG or DXF if the user picks CAD, some images below: ...then the user only has the ‘Choose the output CAD format’ enable if CAD was chosen in the first parameter. I’m on FME(R) 2022.2.5.0 (20230329 - Build 22795 - WIN64)