Authoring

I  have an “Extras” attribute that is XML-like with different number of attributes in different order within the attribute value.. When I use the , XMLXQueryExtractor* and configure a  query, it only returns rows that has one tag only called <PAGE_TITLE>, like below.  The query returns this query result in the list attribute. THe resr of the rows are rejected as invalid XML Queries.For the other failed queries, they have multiple tags, as shown below.What I’d like to do is aplit the tags into field::values regardless of number. This attribute value:<PAGE_LINKS>https://p3tips.com/community/</PAGE_LINKS><PAGE_PRECISEPUBTIMESTAMP>20240905151800</PAGE_PRECISEPUBTIMESTAMP><PAGE_TITLE>Lynchburg Police searching for suspect after armed robbery at Family Dollar</PAGE_TITLE> Woud look like below with all the attributes in the Extras value split into however many tagged attributes.PAGE_LINKS PAGE_PRECISEPUBTIMESTAMP PAGE_TITLE https://p3tips.com/com

Hi, I’m finding XMLFragmenter removes geometry, is this expected?Data Interoperability in Pro 3.3, so FME 2024.0.1.0 build 24202.Thanks.

Hello, anyone knows how to split a DWG into tiles? i can make it happen with tiler however i cannot split it or simply chhose the tile i want to export  

Hi everyone,I have a workflow that exports data from Oracle to another formats, like Shp, GML... using dynamic readers and writers. This workflow recive some parameters, like table name, that is used to read de Oracle table and to write the file name. The question is about GML file and date values. When the Oracle table has datetime attribute, FME exports as text, by default. I've achived that FME exports GML with attribute as date type, but this attribute has null value, beacause the format of date is wrong. That is, the exported date value is "19630904000000" but it shoud be "1963-09-04".As I said, I use dynamic readers and writers, beacuse I don't know what table will be exported and I can’t see the table structure, neither, when data goes out by Generic port of Reader. So I can't use StringReplacer and DateTimeConverter, because I would need to know the name of attibute. Anyone has any idea how to modify the format of the date?

Hi,I have the values of an attribute which corresponds to the names of sheets of an excel file. In other words, the attribute of interest has the values attrib1, attrib2, ..., attribn that also corresponds to the sheet tab names of another excel file.What I would like to do is to be able to dynamically read the sheet tab names of the excel file based on the values attrib1, attrib2, ... attribn that varies per feature. Those values are unique per feature so I won't need to read the same excel sheet twice.Any ideas?Thanks

we are having a DEM of cartosat satellite but we can't convert it to footprint as it only contains terrain data. but a problem statement given by isro in SIH they mentioned to create a LOD1 model using cartosat1 or cartosat2/3 data

Hi,I have a deployment parameter (Text) that is pointing to an SDE file on FME flow in my shared resources. When I try to set a local value in form, it ignores this value and throws an error saying it can’t access the share resources file path. I’ve tried creating a deployment parameter that is  type: database connection, but this doesn’t work either. Here’s the error:This was working a week ago and now it refuses to acknowledge the local value. Many thanks, Sam

Hello, any help would be greatly appreciated with this idea I have: I am trying to figure out the least convoluted way to take my current data and get it into the format ArcPro likes it to be in to take full advantage of the Time Slider. My ultimate goal is to use the time slider in arcpro and the user can slide the time to show how a floor was occupied throughout time.So, I have a large amount of motion detectors. The data is fed to me like so:SensorName Timestamp SensorStatus 1 12:00 1/1/2024 On 2 12:05 1/1/2024 On 1 12:06 1/1/2024 Off 2 12:10 1/1/2024 Off Then Sensor 1 could be triggered again and so forth Arc seems to want the start and end times in the same row. like so:SensorName Start End 1 12:00 1/1/2024 12:06 1/1/2024 2 12:05 1/1/2024 12:10 1/1/2024  It needs to organize 100s of results from numerous sensors and get the start/stop times on the same row, for the correct sensor, for the correct period of time. 

Y’all.I’m trying to create a connection to a customer Sharepoint for the first time. And I’m confused.I got something to work in 2020.2, but would rather it ran in 2022.2 (same as our servers). But I’ve also tried it in 2024.1There seems to be two web service templates, (Template) and (safe.microsoft-sharepoint).According to this article they are each designated for use with Sharepoint List r/w and SharepointOnlineConnector respectively.But apparently I can’t create a new web service based on the latter in 2022.2, and the latter isn’t even available in 2020.2So when did this change, i.e. in which FME version ?CheersLars I.

I am attempting to write out data using a schema scanner and dynamic featurewriter.It is simply not working. I always get "Unknown feature type 'BOUNDS' passed to the JSON writer.It doesn't matter what I do, always the same.BOUNDS is my fme_feature_type and fme_feature_type_name.I will eventually use group by attribute but it doesn't even work with just one typeI believe I am following the standard practice but I have always been stumped when trying to write dynamically.  Please could someone outline the boiler plate method (with the steps ordered) to use a SchemaScanner and Dynamic FeatureWriter in the scenario where one would need to create or overwrite fme_feature_type and fme_feature_type_name or use a custom names for these. As I understand it, I should only need to make sure I have an attribute on the data with the same name as the Schema Definition Name.THANKS! NOTE below, feature_type_name is not available to choose, in this iteration  

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.