Data

Hello everyone, I noticed that FME does not read the AutoCAD 3D element types- mass element - mass group (which is composed from mass elements)at all. On the other hand, 3d solids are read in. Below is an example of this.  Is there any way to read in mass elements from AutoCAD files with FME (e.g. by suitable parameter settings on the reader)? Alternatively, is there any way that with FME, I can detect if there are mass elements in an AutoCAD file (a simple yes/no would be sufficient for me)? Here is the example: I have some DWG file containing four 3D objects, one mass element, one mass group and two 3D solids, one of which is the mass group converted to a 3D solid: When I now read this DWG file into FME (Autodesk AutoCAD DWG/DXF reader with standard parameters), only the two 3D solids are available to me as FME features, but neither mass group nor mass element: I attached the DWG file to this post.

Hi all.I'm trying to consume a WFS service (Geoserver), which for some reason only works as version 1.0.0. This even though that the capabilities document clearly says 2.0, and accepts all versions.In versions 1.0.0 (and 1.1.0?) the parameter "typeName" is used to specify the layer (feature type), but this is later renamed to "typeNames" (with an S).I get an HTTP error 401 from the service when attempting to fetch data in version 1.0.0, but the very same URL works if I just add an "s" to "typeName".Can FME be tricked into instead using or adding the "typeNames" parameter?Actually, URLs may contain both "typeName" and "typeNames" parameters with the same value, which would make the requests robust against version problems. Can this be achieved?Cheers.

I'm trying to convert datetime values in ISO format to FME, because PostgreSQL database refuses to write that value as "timestampz". I have tried to both autodect and %Y-%m-%dT%H:%M:%S$The preview show correctly the conversion:But the ouptup stays the same:Any hints? Thanks

Hi Safe team, Do we have an idea on which formats support mesh vertex colors? I can't see Information in the quick facts area for formats (e.g., OBJ) about vertex color support. It seems like it's becoming more an more common to see mesh objects with vertex colors instead of a texture. I'm just wondering what formats FME can read and write to where vertex colors are supported. So far form testing I can see OBJ supports reading them? A follow up question, is there anyway to convert these to regular appearances or a texture atlas for formats where the vertex colors aren't supported? Perhaps @daveatsafe​  has an idea? 

Hello all,I come from the BIM (Building Information Modeling) world and I have been looking for solutions to extract data from 3D models for a long time now. Recently this implied I had to try extracting data from 210 Revit models with an average file size of 200Mb. After different tries, I'm now on the FME desktop path, to which I'm fairly new to..., for testing with IFC (open source) files extracted from Revit models.Essentially there are a few key parameter in Revit Basic sample project in IFC from Revit (I think you guys call them attributes) that I would like to extract. Unfortunately, I see those parameters in different "viewers" (Navisworks, Solibri) from the same files I'm using for FME Desktop but I have no luck with the latter. I can expose those attributes but never get any values for them when exported to excel, SQL or event the FME data inspector (although I can see their columns). For now, the attributes in questions are "Assembly Code" and

How can I extract MI_STYLE and MI_PRINX from the mapinfo tab to the writer? I am trying to write mapinfo tab files to SQL Server but it doesn't extracting these two columns. In past we used to use mapinfo easyloader. Can anyone help me? Thanks Mona

File Encoding is Unicode 8-bit.Tried changing the Write Byte Order Mark for Unicode to 'NO'. Still facing the same issue.Cannot make any changes to the receiver of this file. Can you please suggest how to get rid of these characters? Thankssresree

Hi, I have looked into several posts here but not really found similar results. I tried to write my DWG into a Map 3D dwg to for example write attributes like creation instance into my DWG which worked really well: Writing attributes to AutoCAD User Properties (safe.com) However, I want to be able to add / edit attributes for my features that are readable by Bentley Microstation . Every result I found is DGN but the format must be DWG. Is there any way to write attributes to a DWG which is readable in microstation? Result above has no attributes or properties so doesn't work. Originally the results I don't want in block but that rule can be bent so every single features can be a block if that is the only way. When I inspect my DWG in Microstation it doesnt have my written attributes, I can only see them in AutoCAD. I want similar like example: In my results with id and count doesnt exist in microstation and only geometry information can be found in properties. Lets say i have 3

hi fellas,I'm trying to translate a dgn file, but it fails to load correctly. when i open the file with Bentley Microstation Connect edition I can see the design, but when i try to open it with fme data inspector it fails to load the design (it loads all the features but they are not shown graphically).attached are pictures to illustrate what I get when trying to open the design with Bentley Connect, and with FME Data Inspector (using v7, v8 and xfm v8 readers).can you help me with the issue? best regards,Sharbel

In the conversion process of using the same educational model note that using the system Epsg4326 The examination is correct When adding the converter as it is in the lesson, converting from the canvas and using the reader and writer’s coordinate syste

Good morning,I’m trying to transfer data from ESRI to PostGis.Unfortunately, I encounter the following error:Error was 'ERROR: value too long for type character varying(50)I understand that the created field is too short but I can’t change it...Thank you for your help.

I have tried the RasterDEMgenerator and the ImageRasterizer but both give errors regarding the input features or geometry. I have tried different feature settings but to no avail.

I want to use the PythonCaller to read a value from the header of an ECW file. The value I am looking for is four characters long, starting at the position of 37. I want to then print the value. This is the code I have so far; import fme import fmeobjects # Template Function interface: # When using this function, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter def processFeature(feature):  pass   # Template Class Interface: # When using this class, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter class FeatureProcessor(object):  def __init__(self):   pass  def input(self,feature):   print ('start')   n = feature.getAttribute('fme_dataset')   print (n)   f = open(n,'rb')   f.seek(37,0)   print(f.read(4))   f.close()   self.pyoutput(feature)   print ('finish')  def close(self):   pass   But it does not return the value

How would I build a workspace with an ECW Writer transformer, followed by a Python script that modifies the ECW image file after it has been written?

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, 660000, 0.0005),        mdsys.sdo_dim_element('Y', 5500000, 5550000, 0.0005)    ),    82232);-- row that translates correctly, sdo_gtype = 2001insert

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 created by an external user. I will know the naming convention, but I want to be able to use Regex or some sort of fuzzy match to catch the Pset incase there has been a mistake in the creation of these Propertysets.  For example if the Custom Pset is called "Pset_Project", I would like to expose it and all its Traits.But I want to make sure that if someone writes "Pset_prject" or "Pset_project1", th

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 else experience this?