Data

Is there a way to join two tables using the between operator (SQL). I know I can use SQLCreator but I would like to do this join directly in workbench. sql example: TABLE1.*, TABLE2.* FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.NAME = TABLE2.NAME AND TABLE1.DATE BETWEEN TABLE2.FROM AND TABLE2.TO

I have a database NAME1. If I open them as Oracle Non-Spatial I can access the following tablesNAME1.AANAME1.BBNAME1.CCNAME1.DDNAME1.EE If I open them as Oracle Spatial I can access the following tablesNAME1.CCNAME1.DD The database contains more than 50 tables. They must be transferred to POSTGIS database with a different schema name: name2 I have already looked up some things in the community. But those are old posts and some transformers don't even exist. What is the best way to approach this? in short:Oracle NonSpatial tables and Spatial tables from 1 database to POSTGIS database with a different schema name. Who can help me and or has an example? Thanks in advance

Before the web presentation of Safe and FME changed to what they are now It was possible to find the zipped FMEData. Data that are pointed at in almost every exercise in the FME Academy, community postings and videos. The new FME page does not provide the “knowledge” structure anymore as before and all links in the community etc. are pointing straight into Nirvana. I can see that these resource now can be found at https://s3.amazonaws.com/FMEData, however, I cannot get a listing of the content of this bucket and I always end up with a 403. Without a listing it is impossible to guess the specific file I am interested in… Can somebody point me to an URL where I can get the latest version of the FMEData?

The IFC data was exported using ArcGIS Pro. After importing it into FME Data Inspector, the following errors occurred: ISO10303-21: Skipping instance #50: Instance is not syntactically valid An error has occurred. Check the logfile above for details Failed to specify the feature index as constraints on the reader Could anyone please help with this? Thank you!

When trying to read an IFC file, I am getting an error ISO10303-21: Skipping instance #1154: Instance is not syntactically valid. How can this be fixed?

I need to copy records from one hosted feature layer in ArcGIS Online to another hosted feature layer. Schemas are identical. Some of the records in the source data have an attachment (only 1 per feature/record so only in the 0 position in the list). No problem getting all of the records to write from the source to the destination but the attachments are not included. Anyone know how to do bring over the attachments with the rest of the data?

Though experienced with reading WFS's, I'm a little bit frustrated about reading a WFS2.0 in the FeatureReader. It seems it is not paginating. Checking the WFS GetCapabilities, 'FeaturePaging’ is not mentioned. I want to query the WFS with a polygon. So that is my initiator. But I'm not sure whether the results exceeding the 50k or 100k or even 200k. That's why I want some sort of ‘FeaturePaging’. Anyone an idea on how to solve my issue? It's probably simple, but I can't see it at the moment.

Hi, I need help. I have an attribute column X with string values ‘S001’, ‘S002’, ‘S003’, and ‘S004’, all lined up in 1 column with 4 rows corresponding to the string values. I would like the output Y should to be a single row list, having just one column and one row, containing the four values: Y = (‘S001’, ‘S002’, ‘S003’, ‘S004’) Could you please advise how this could be done in FME Form. Greatly appreciated. Thanks, Willy de Vera

Hi, got a question from a client yesterday who wants (with FME2018.1) to connect to a SQL Server 2000 database (no the question is not from a museum: ). FME returns a Fetching Feature Types Error, "... SQL Server Native Client 11.0 does not support connections to SQL Server 2000 or earlier versions". Any ideas the minimum hazzle to get around here? Just to install the SQL Server native client 9.00 and problem solved? I do not have an environment for testing this myself :/ cheers

Hi, I am trying to request information from FMEflow with an httpcaller. I have created a temporary token that allows everything. If I include the token in the URL, the request works fine. (https://<...?/v3/info?fmetoken=abcdefg...) When I put the token in the httpcaller I get a 401 warning. What goes wrong in the caller?

Hi folks! As I was using AI tools like ChatGPT and Copilot to troubleshoot, I suddenly received information from the AI about the "Generate Workspace Documentation" function. Here's what I learned: ------------------------------------------------------------------------------------------------------------------------------- Generate Workspace Documentation This feature allows you to automatically generate comprehensive documentation for your FME workspace. The output is typically an HTML file that provides detailed insights into your workspace structure, parameters, and transformations. It's incredibly useful for sharing with colleagues or for archiving your workflows. How to Use It: Usage in FME Workbench (GUI): Open the FME Workbench application. Load the workspace you want to document. From the Tools menu, select Generate Workspace Documentation. You can choose to output the documentation in an HTML format, which can be opened in any browser. Command Line Usage: This function is als

Hi, I am trying to convert raster data in the forms of .grd, tiff or GRID from ArcGIS Pro into a csv/table. If anyone can point me in the right direction, that would be greatly appreciated. GRD file loaded on ArcGIS Pro

version: 2024 I am trying to convert data from fgdb to dgn. I used AttributeSplitter and DGNStyler to reassign size and width to each text elements. Single line text is work but seem mutiplate line text attribute igds_text_width_multiplier cannot write to dgn. Is igds_text_width_multiplier in DGNStyler cannot update igds_multi_text? Remark: I tried FME 2021 is work. mutiplate line text attribute igds_text_width_multiplier can write to dgn.

Firstly I combined my building objs by Aggregator, then I separated them by Deaggregator, finally to b3dm. I have coordinates of those building objs but All building overlapped in Cesium, How can i locate the buildings according to coordinates.

Hi, I have created a gdb with 2 feature classes, strings and points. But it only works the first time. Every time I make changes to the model and run it again I get errors. I have tried changing every setting but nothing helps. The only thing I can do is create a new gdb every time but that is not the intention. I usually use the Insert and drop and create settings

Hi, I’m using FME 2024.1. I want to write xls files out where my field names appear in Column A (with their corresponding value pair in Column B) instead of in rows. Sounds simple, right?! Writing the data out with an Excel Writer produces a default output like this: Field Names in Row 1, values in the corresponding column. ...this doesn’t make for a particularly human-readable output when you have 250+ fields in the output dataset. This is the style I would like the output to be in: Field Names in Column A with matching values in Column B. I have tried using an AttributeExploder to create name:value pairs but am having trouble getting from there to anything particularly useable (I still have a lot to learn about working with lists). Oh, great hive mind, please help me out! Thanks, Casey

Hello : ) I have a Form workbench that first deletes some records from two tables in a geodatabase and then inserts new records into these tables in the geodatabase. This worked fine in FME 2021 but after upgrading to FME 2024 the delete creates a lock on the geodatabase and causes the process to fail: An error occurred while attempting to open an insert cursor on the table 'Total'. The error number from ArcObjects is: '-2147220947'. The error message from ArcObjects is: {Cannot acquire a lock.} Any advice on how to fix this problem would be great.

Hello FME Community, I am trying to convert annotations from a CAD (.DWG) file to a GIS (.GDB) file in the form of points, in such a way that each line of annotation text is a separate point with an attribute of this text. Everything seems to work fine in my workbench, however, after attaching to GIS programming and loading the resulting points, it turns out that in many cases additional points have been created in each line of text, which prevents me from using them correctly.Has anyone encountered something like this and would be able to help. I attach screenshots of sample annotations in AutoCAD and after conversion in GIS software.FME version: FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64)

I’m fairly new to FME and I’m not sure this is possible. I’m attempting to add a MS Word doc. to multiple zip folders (from a fanout) that contain shapefiles. It’s basically a data dictionary that needs to accompany the shapefiles. Is this possible?

Hello, unfortunately I have repeatedly problem with exporting to Excel in Workspace. I checked log, there is following message: 2016-11-24 10:05:57| 67.6| 0.2|ERROR |Excel Writer: Failed to save changes to the spreadsheet 'D:\\XXX\\XXX\\XXX\\new.xlsx'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.' It looks, that there is error on Excel side, right? I just want to create new Excel file...

Hi all, I've got some confusing to clear, and hope to find an answer here. I have 2, completely the same datasets, uploaded to ArcGIS Online. Now, i want to update them. To test it, i took 2 completely identical layers, read them from AGOL and now, it shows differences. Can someone explain me what the problem is? If i only check on attributes, then there is nothing wrong, but if i also check on geometry, there is somewhere a change, and the Changedetector gives updates as output, but it should be unchanged. All the data is 2D, there is no 3D. In the update detection key attributes, i selected all the attributes, but left GlobalID and OBJECTID out of it. same for check attributes. Even more confusing, if i do the same process in a new workbench, with the same sources etc, i get different results. Sometimes it igeve met 900 updated, and somethimes 1322 Thanks in advance!

Hi I am doing migration testing from 2023.1.2 and 2024.0.3. It seems to completely fails on 2024.1. I have tested it on 2023.1.2 and 2024.0.3, worked perfect - no issues. It fails on FME Flow and FME Form on the server - but works OK on my local PC on the server - oldeb 2019, clr 2019, are installed, as with .net 4.7, 4.8 and It is just a simple sql server spatial reader - and a bit of reprojection - it fails on reading the reading the data Cheers Rudy

I am trying to read an ALKIS data file coming as XML file. I have two files, the first one come with version 6.0 and FME opens this file without any problem (xmlns="http://www.adv-online.de/namespaces/adv/gid/6.0"). However, when i try to read the version 7.1 (xmlns="http://www.adv-online.de/namespaces/adv/gid/7.1") I got an error as following: XML Parser error: 'Error at file: 'K:\…….. line: 1 column: 1 message: invalid document structure' An error occurred while attempting to parse the XML Schema document 'file:///K:/Geodaten/Projekte/ALKIS/2411_ALKIS_NAS/NAS-Operationen.xsd' The XML Module halted on error, see the logfile for details A fatal error has occurred. Check the logfile above for details Failed to specify the feature index as constraints on the reader Failed to obtain any schemas from reader 'NAS' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information do you have

I am trying to use the duckdb summarize command https://duckdb.org/docs/archive/0.9/guides/meta/summarize in an in memory duckdb using the sqlexecutor: SUMMARIZE SELECT * FROM read_parquet('/Users/x/Downloads/Address.parquet'); This doesn’t return any results/attributes but ‘runs’ successfully in FME. In DBeaver it runs no issues. Any idea is there is a trick to get this working? Many ThanksQ!

I created a 2D spatial point dataset in a PostGIS database.Today I tried to load them into FME, that works perfect. I get the right locations including the according attributes. I only get this warning: Dimension metadata is ambiguous for spatial column 'geom'. Reporting 3D when 2D+measures might be present Did I forget to set some specific settings while creating this dataset? There should be no 3D data present, I only saved 2D data :)