Data

I want to change the text alignment of the texts in a dgn with an attribute manager before further editing. Does anyone know the attribute that is responsible for this? Thanks.

I'm doing a basic transfer of Geomedia Text Features from one table to another. In the past I've always done this by exposing the oracle_element{} attribute and exploding the list. This is always worked fine but I'm running into problems with certain features that don't contain the oracle_element{} attribute. An example of what I'm talking about:create table source (id int, geometry mdsys.sdo_geometry);create table destination (id int, geometry mdsys.sdo_geometry);insert into mdsys.user_sdo_geom_metadatavalues(    'SOURCE',    'GEOMETRY',    mdsys.sdo_dim_array(        mdsys.sdo_dim_element('X', 610000, 660000, 0.0005),        mdsys.sdo_dim_element('Y', 5500000, 5550000, 0.0005)    ),    82232);insert into mdsys.user_sdo_geom_metadatavalues(    'DESTINATION',    'GEOMETRY',    mdsys.sdo_dim_array(        mdsys.sdo_dim_element('X', 610000, 66000

Is there a way to extract only the non-empty fields of an oracle table?Let's say I have a table like this one,    col_a    col_b    col_c    col_d   col_e    NULL     NULL     NULL     NULL    5    NULL     NULL     NULL     8       6    0        NULL     NULL     NULL    3    NULL     NULL     NULL     0       1and the subtable that I would like to extract should be    col_a    col_d   col_e    NULL     NULL    5    NULL     8       6    0        NULL    3    NULL     0       1Thanks

Hi Everyone, My Question:I am trying to read the Pset of an ifc dynamically. I have looked at a few sources in the forum but have not been able to manage. I would love some help on this topic. I have read a few articles on Dynamic Schemas and Updating Ifcs etc:https://knowledge.safe.com/articles/594/updating-ifc-example.html https://knowledge.safe.com/articles/1136/schemamapper-transformer-tutorial.html https://knowledge.safe.com/questions/32777/how-to-expose-all-attributes-in-generic-way-any-ma.html  My aim is to expose part of a custom ifcpropertyset that are cre

Hi,I'm trying to convert an IFC file (exported with Revit) into a .gml one. I tried to recreate the workspace suggested here: https://knowledge.safe.com/articles/1025/bim-to-gis-intermediate-ifc-lod-300-to-lod-4-cityg.html , but I could not be able to visualize the output file (.gml) in QGIS software. Using the available data at the above link, I can see them. Why? I'm using FME Workbench 2019.

In this webinar (https://www.safe.com/webinars/best-in-show-fme-tips-tricks-for-productivity/) was a section titled 'How to get a background map on a PDF'. This is exactly what I want to do however my organization is only at FME 2020.2. So the Reader format of OGC WMTS is not available to me. Any suggestions on how to do this in FME 2020?

Is there a way to write custom key-value metadata to the output parquet files?

I have tried using the excel reader to get my file in, then httpcaller with the URL as my column of google drive shared hyperlinks. Renaming the output to a column which identifies the name that I want. I'm obviously not getting the settings right in the httpcaller or missing something entirely. New to using this and really no idea what I should be doing. For now I have only focussed on trying to download the Report but ultimately there is also a video avi to be downloaded. My input excel file looks like the following: Newname for the report and then the report google drive hyperlink.

I'm making an ETL to convert some features from an geodatabase SDE to Autocad DWG-files. It is working well, but i'm getting an error.AutoCAD Writer: Shape file 'ltypeshp.shx' or 'ltypeshp.shx' not found when trying to resolve shape ''It has no consequences for the output, but it is bottering me. Any idea what the problem could be. Am i missing some parameter?

I have an Oracle database with about 500,000 entries. I want to read in 1 feature for each unique value of 'DEVICE_TYPE'. Is there a select or where clause I can use to do this?

If i have an esri fgdb that has no features in it. To be used for a template.I want to validate data coming from the field against these coded domains values in the template. But i can't see how to get the domain values. I have the "resolve domain" checked on. I can see that probably having the single merged feature as features will not work as you get literally NOTHING.i have also tried individual feature types as both features, and metadata.As features I get no features (of course), as metadata I get 1 feature for each featuretype (and have enabled ALL format attributes for each featuretype). But, there is no "ATTRIB_resolved" attribute. So using the FME Hub "Read_ESRI_GDB_Domain_Data" custom transformer doesn't even work. It seems the only interface that will allow this is through the esri "KLUNK KLUNK" domains/subtypes "clickamilliontimes" interface with no output.anybody e

How about ArcGIS 10.8.2 Support ? It is around since 2021 and nothing is mentioned on the FME Esri compatibility page.

Hey I have a dataset from a Z+F scanner in ZFS format. The thing is, the data is coming from an MLS system, not from a TLS system, which means that the point cloud is generated by the movement of the car, not because of the rotation of the scanner. This will result that, the whole cloud being exported to a single plain, as one data record. The original idea is, that if the points can be extracted, the points can be synchronized via the trajectory time stamp, but I was not able to extract the points properly.  Please advise, on how to figure this one out, to be able to create a proper MLS cloud. If you do not have the exact answer, but you might have some clue, that would be also helpful. Thank you for your help!Bálint

Hello!Is it possible to get the new file name created (or modified or deleted) by the directory watch and send it into an email via subscriptions?If not, how can I send the new file name detected?Thanks.

Surveyors are collecting data on-site and taking photos as attachments unto an ARCGIS Feature Layer. Depending on the infrastructure category, I need to display these survey results across multiple ARCGIS Feature Layers. Is this possible without saving the attachments locally first?

We are using SQL Server 2014 deployed as 3 node cluster with 1 primary and 2 secondary. We need to connect to the READONLY secondary. To do that you the set the Application Intent=readonlyBut i cannot find the parameter setting in the database connection for SQL Server.

Hi,I have an ifc file and there are attributes like volume, width, height etc . I can't see them in fme. I even tried to expand the format attributes. Does this mean that reading IFC files is limited to a certain number of attributes? How can I turn on the visibility of these attributes? Is it possible? I've attached a screenshot. The attributes I want to process are in a red box. Regards,Aneta

How do you design a simple architecture on Revit and import the IFC file to FME and then convert it to citygml format. Thank you so much.

Hi everyone,I try to put the "responsibleOrganisation" and " annotation" in my AIXM 5 writer. My workbench seems to have an issue but i didn't find where is the problem.I tried with an older version of FME (2017) and everything is good. I put here the 2 versions of the workbench. ( 2017 and 2022). With the written files output. If someone could help. Something seems to ne wrong with the "geometryPropertySetter", with the "XMLTemplater", and probably with the writer AIXM5. 

Hello!  I am trying to write to an MS SQL DB and some of the feature classes have a primary key where the column name is longer than 30 characters.  On the writer feature types, I can set the default primary index colum to a length longer than 30 characters, but when I look under the user attributes, the column name gets truncated to 30 characters.  When I try to write the features to the DB, it fails because the field names are no the same.  Does anyone know if there is a work around for this, or how I can get a column name longer than 30 characters to be recognized under the features user attributes?  Thanks! Tristan

Hey guys, is it possible to perform an INSERT/UPDATE/DELETE operation (fme_db_operation) on GeoPackage using an UUID which isn't an integer?The UUID was created by UUIDGenerator. If I execute the following workspace, I'll get this error message:e.g.OGCGEOPACKAGE writer: Cannot perform Delete on feature type 'original' by matching attribute 'UUID' since value '{48fb8445-ca8d-4f74-94ed-b0ce6c89ffdc}' is not an integer. Skipping feature. Workspace:Writer-Settings (unfortunately in german language) Thank you very much!

I'm trying to import different IFC modells via IFC Reader and for some it happens that the walls do not contain the respective openings where the windows are (see Screenshots of BIM Viewer and FME Inspector. I tried different import settings, and thought especially "Subtract Opening Geometries" should solve the problem but it still didn't work. I'm having a hard time finding a solution as I'm not entirely sure how FME cuts out these openings.  Any suggestions what might casue the problem?

I've been trying to convert them to PNGs and TFWs but with everything I've tried so far, Cesium tells me "Missing or invalid spatial reference system".

I have many files in this ascii format. The RRC has MAGNETIC TAPE USER GUIDE with field descriptions that contain beginning and ending positions. I have attempted to use the schema mapper with csv file that describes this but have yet to figure out how to make that work.please help,Files are located here. The file looks like this...The format description is like total bytes per record 308 bytes. MASTER FILE TAPE RECORD SEGMENT KEY NAME DESCRIPTION 01 DAROOT

I am writing to a Dynamic GDB writer using an existing GDB with Domains as the Schema Source. I am resolving the domains otherwise just the values come across, but it is also creating a new attribute called "attribute_resolved" which is then being written into the feature class in the GDB. I have tried to use an attribute remover and an attribute manager to remove these attributes prior to writing, but they still get written. Strangely these attributes don't exist in the Attributes To Remove dropdown list in the Writer. Any help would be greatly appreciated.