Authoring

I want to display a list of tables/views that a specific ROLE has access to. I can do this in SQL with the command SHOW GRANTS TO ROLE TESTROLE. However, putting this SHOW command directly into a Snowflake Reader WHERE Clause generates an error (syntax error line 1 at position 270 unexpected 'GRANTS'.) and returns nothing in a SQL Executor transformer.  Is anyone please able to advise either what the correct syntax is or if there is another approach/transformer that should be used? Thanks. 

Hi All,Novice, here.   I am trying to work with two different layers where I want one set of data to overlie another set of data.  I don’t know how to move the lines, adjusting them so they will match the sister layer.  I have tried Neighborfinder, anchored snapper, was looking at affiner, orientator and geometry coercer, and any other transformer I thought might work.  I suspect there are many steps involved in this process, but I really don’t know where to begin.    Below is an example of my data set.  I would like the black lines to match the red lines.  Is this doable in FME? Please let me know if more information needs to be provided.   Thanks for any help.  It is greatly appreciated! Version: ME(R) 2023.1.0.0 (20230825 - Build 23619 - WIN64)   

Path issues while attempting load Python module. FME Pip installed Pypdf. It got installed to: C:\Users\james.hawks\Documents\FME\Plugins\Python\python39\pypdf But workbench cant see that for unknown reasons.  Python Exception <ModuleNotFoundError>: No module named 'PyPDF'

Hi,I have a FME workbench and in the Fanout Expression, i have to manually amend the date (YYYY-MM) in the file name each month from 2024-06 to 2024-07 when running at the start of the month for the previous months data.E.g. the fanout expression will look like this:R@Value(ba_id)-2024-06-filename.xlsx So at the 01st August I would amend the above filename date to 2024-07. Is there a way to automate or code the date so I don’t have to manually change from 2024-06 to 2024-07 etc.

I have a LOD 0(BUILDING FOOTPRINT) file and a LOD 3 Building 3d model file. Lod 0 is in shapefile format and Lod 3 is in gdb format. The gdb file have no attribute value and lod 0 have. so i want to add its attribute to gdb. How to do it?

How can be determined (estimation is all right) if a polygon feature (A) fits within another polygon feature (B) and count how many.  thnks

Hello!I'm trying to create a tool in Data interoperability (FME for ArcGIS) that gives the User a list of attributes to choose from based on the read source. I'll make things more clear.Let's say i have X.X= People infoI'm reading X and filtering out with a tester based on a criteria and it returns me 3 entries. Next i want the user to see those 3 entries and have the possibility to choose which ones continue along the process of the tool.I can't make the user choose the parameter beforehand because he does not know what the first tester will end up with.Is it possible to accomplish this in FME? If so how would you recommend to do?

Hello, I am struggling with the INSPIRE GML writer and the new version 5 of the ProtectedSites xsd schema.Earlier this year, the XSD schema was adjusted, among other things for the following:Correction of spelling error in inspireID Converting enumeration to code lists Adding attribute "thematicIdentifier" Datatype of legalFoundationDate to 'Date' Changing multiplicity of the elements legalFoundationDate and legalFoundationDocumentSee https://github.com/INSPIRE-MIF/application-schemas/releases/tag/2024.1 and underlying links.When I retrieve the attributes of the old version 4 schema, I get the list from appendix 1, which includes:inspireID.Identifier.localId inspireID.Identifier.namespace legalFoundationDate legalFoundationDocument siteDesignation{}.nilReason siteDesignation{}.xsi_nilThis worked well for my application.However, when I now retrieve the attributes of the new version 5 schema, I get the list from appendix 2. In it:I do see the corrected inspireId attributes. I also see th

I am trying to finish my workspace. I have gotten as far as the Attribute Manager which has Lat and Lon fields in it. Currently the data being fed into Attribute Manager_10 (screenshot below) is Lines. I want to use the Lat Lon fields in the AttributeManager_10 to create Points and not use Lines. Any ideas on what Transformer(s) I need to add after AttributeManger_10? Seems like VertexCreator would be the most appropriate Transformer to use in this situation, correct? 

What is the best way to convert Lines to Points? I would like the points that are created to fall in the middle of the line and include all non-geometry attributes of each line. I am hoping there a LinetoPoint Transformer out there somewhere. 

Hi,I have a workspace that executes a piece of python in a PythonCaller which uses ArcPy. However it crashes the ArcGIS application that is running the ArcPy(Not FME Form), giving the following popup   The log doesn't have any errors and only two warnings: Python: There is a known Windows bug that may cause instability when using Python in the current locale. Please update to Windows 10 version 2004 and greater, or to Windows Server 2022. See http://fme.ly/nw5 for more details I have seen this warning a few times and in articles. So far this is the first time it gives me a crash. Articles say you need to update your windows version. At the moment I have Windows Server 2019 Datacenter, Version 1809.So there is an update possible here. Another warning is: PythonFactory script changed the current FME process locale from 'Dutch_Netherlands.utf8' to 'Dutch_Netherlands.1252' and FME has restored it back to 'Dutch_Netherlands.utf8'. It is undefined behavior to change locale and doing so may c

Why does the FeatureReader transformer using OData operated differently (slower or not at all) with the same parameters used with the “regular” Reader, which performs as expected https://data.environment.alberta.ca/Services/EDW/waterwellsdatamart/odata/filterCreateTimestamp%20gt%202024-08-04T00:00:00-06:00 Table/FeatureWells  Thanks.

Hi All -I have been trying to convert a GeoTiff (also converted to ESRI Raster to try it too) and write to ESRI polygon feature class. I have used the steps below….. However, the translation fails and I get the following error:“Cannot write a non-point feature to a point feature class”There are no point features at play in any steps. RasterCellCoercer output cell geometry is set to ‘polygon’ and writer is set to polygon too. Does anyone know what is wrong here? Is another step in terms of geometry replacement or definition needed? Steps: Reader to read the GeoTiff (or Raster). RasterCellCoercer to convert the rastercells to polygons. AttributeCreator to convert the raster cell value to attribute. In this case _band{0}.value. Relevant writer to write the result to polygon FC.Thanks in advance! 

I have a Simple  PythonCaller code to delete all .gdb files is a directory import osimport time# Define the directory and the age limitdirectory = r"../../../10_9_1"age_limit_days = 1current_time = time.time()# Calculate the age limit in secondsage_limit_seconds = age_limit_days * 24 * 60 * 60# Iterate through the files in the directoryfor filename in os.listdir(directory): if filename.endswith('.gdb'): file_path = os.path.join(directory, filename) file_age = current_time - os.path.getmtime(file_path) # Check if the file is older than the age limit if file_age > age_limit_seconds: try: os.remove(file_path) # Delete the file print(f"Deleted: {filename}") except Exception as e: print(f"Error deleting {filename}: {e}")Now using FME Flow(Server) I want to send an email based the Result of this code If there was a .gdb file to be deleted! then I need to get and expose the name of the  delet

We have been running FME Desktop 2022.2 on Windows Server 2019 machines for over a year, but found out last week any function calls to datetime or datetime reformating fails with this error “Failed to load timezone data. current_zone() failed: A mapping from the Windows Time Zone id "" was not found in the time zone mapping database”. For example, in the AttributeCreator, an attribute creation with the value being @DateTimeNow() got the above error. Anybody experienced this before and knew of a fix? Unfortunately I don’t have the option to reinstall FME on those machines.

I have a dataset that contains the “_related_suppliers” field that contains either 1 or 0; I would like to add a counter that will increment, whenever the _related_suppliers field changes;  Is this possible?

Hi allFirst time poster, long time reader of all the great advice on this forum.using FME 2021.2.6 (work limitation)I am currently having issues regrinding my CSAR (Raster and Pointcloud) files while keeping the lowest value in its original XY position in the regirded area. Example of regirded squares with the smallest values being picked.Note: the gridded squares are just a visual example, I have potential looked at applying a Buffer to the soundings based on the (SCALE) area they fall into but have had no success yet. I also have an Area file (Shapefile1) that contains the regrid values (SCALE) I would like the effected CSAR file to be regirded too.Example: Of the desired regrid areas (Shapefile1) overlaying the CSAR file. I really have 2 issues currently affecting me that I need help with. 1)      I need to be able to regrid my CSAR files (RASTER or POINTCLOUD) by keeping the lowest values in the regrided area.2)      I have a Area file (Shapefile1) that contains the regrid values I

Hello, Here is what I need to do: I have a workspace that includes the Emailer Transformer. When a file is placed in a folder and email is sent to the recipients notifying them that there is a file in the folder. The workspace works great. But, if one of the email recipients changes or needs to be removed for whatever reason, I am contacted and must go into the Emailer Transformer and manually delete the recipient. I would like to allow a user to open a spreadsheet of the email addresses and alter/delete them there rather than having to contact me. I need some help in getting started: If I have a list of email addresses in a spreadsheet, how do I include it or reference it with the Emailer Transformer? For example, if an email address is deleted or added to the spreadsheet, when the Emailer is going to send an email it will send the email to the list of recipients in the spreadsheet. Looking for some ideas on what transformer(s) I would need to use before the Emailer.

Hi!I would like to create a workbench with a lot of flexibility for the users. I use a FeatureReader with a spatial filter. I create a user parameter to chose the system of coordinates. So I would like to use it on the Featurereader but there are no option. Do you know a way to indicate to this transformer the system of coordinates? I suppose the spatial filter will work if the datas are in the same system but I would prefered to force it.Thanks !

What I try to do is to download a raster from a WMTS to use it as a background image for a report. I do not want to download the entire service, only a part to use as background. The result I get is only working on very zoomed out tile matrices, like 04, where the resolution is not useful: On deeper levels the FeatureReader is downloading a lot of tiles, which takes a very long time.The WMTS I use is a Dutch one, in epsg:28992. I wonder if I am doing something wrong, or this is never developed / tested for this coordinate system?The point is on 147513.92, 523126.09.The WMTS is https://service.pdok.nl/hwh/luchtfotorgb/wmts/v1_0?The Layer is Actueel_orthoHRAttached the 2023 workspace. 

Hi,I would like to merge polygons based on area up to a certain point. For example if I had 1000 polygons I would like to reduce that number to 100 keeping them as close as possible in size to one another. Does anyone know if this is possible in FME?Thanks for any help!B

Hello, I need to switch to a new machine. I save my workspace files under a designated directory, which has been transferred to the new machine. I am wondering if there is any important configuration file would need to copy over (e.g. some database connection, web connections, where those info stored?) and where usually to find the file?I am using FME workbanch 2023.2.3.Thanks. 

Hello Safe Software Community,I work for Riteway Towing INC, a leading towing company in Queens, NY. We're exploring ways to enhance our operations, particularly in managing our fleet of tow trucks and providing timely roadside assistance. Given the complexity of NYC's traffic and the high demand for 24 hour towing, we need a robust solution for real-time data integration and route optimization.Can FME help us integrate various data sources (like traffic updates, GPS data, and service requests) to streamline our dispatch processes and improve response times? Additionally, has anyone implemented FME for similar logistics and fleet management tasks? Your insights and experiences would be greatly appreciated!Thank you!Olivia Marie - Manager at Riteway Towing NYC

Is it better practice to use  import fmeparam = fme.macroValues[‘parameterName’]orimport fmeobjectsparam = FME_MacroValues[‘parameterName’]in Python scripted parameters and why?

Hi,I’m attempting to create attributes from an unstructured html table.Looks like this… The table is originally a Word .doc, that I saved as a .html file so I could read it in FME. For example, I’d like to create an attribute (AttributeCreator) that selects based on row number … eg “Survey Authority” = Col1 row4or“End Date” = Col2 row8This there a way I can do this ?thanks