- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,807 Posts
25,078 Replies

When you subscribe we will email you when there is a new topic in this category

6807 Posts

Write attributes / properties in DWG that are readable by Microstation (Microstation V8i)

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

610

2 years ago

sigtillContributor

asked in Data

FBX with Mesh and ortophoto in Navisworks

After a week+ of trial and error I wonder. Have anyone managed to create an FBX-file with FME that contains terrainmodel + ortophoto draped on top. That can be opened WITH materials/texture directly in Navisworks? I have tried all settings - but can not make it work. The files open correctly in FME Data Inspector, Autodesk FBX Reviewe, 3dsmax, Lumion and even Infraworks. And also the export from Infraworks to Navisworks work OK! However I cant seem to be able to open the FBX-file directly in Navisworks - it only shows the terrain with no texture/material. Even when it shows the texture in the "materials" pane. Material is added on a Mesh-group and displays nicely before writing and as mentioned in the other software above.Some stuff I have tried:- All settings on the FBX-writer- Manually changing the scaleuints on the ASCII- file from 1 to 100 to scale to meters instead of default cm. It seems that there is some scaling issues between geometry / material or bug related to mat

dgn readers fail to read features correctly

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 sys

2 years ago

renaud_nm

asked in Data

Error was 'ERROR: value too long for type character varying(50)

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.

How to convert a poincloud (CSAR PC) to a raster with pixel values being the original z-values ?

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.

130

2 years ago

nicholasContributor

asked in Data

How to read a value from an ECW file?

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

413

2 years ago

nicholasContributor

asked in Data

Python script to modify output file (ECW image file)

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?

1820

2 years ago

aharportContributor

asked in 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.

2 years ago

tfcwParticipant

asked in Data

Moving Geomedia Text Features from one Oracle table to another

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

2 years ago

arthyContributor

asked in Data

Remove empty fields

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

36110

2 years ago

freddy17Contributor

asked in Data

Dynamic IFC propertyset

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

IFC to CityGML (LOD3). How to visualize .gml geometries?

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.

Background map on a pdf

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?

1310

2 years ago

aegmanContributor

asked in Data

Parquet - Writing custom key-value metadata

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

600

2 years ago

lfergContributor

asked in Data

I have an excel file of pipe CCTV record pdfs hyperlinks. The pdfs are stored in Google Drive and I want to be able to download these in bulk to a local folder.

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.

Error: "AutoCAD Writer: Shape file 'ltypeshp.shx' not found"

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?

5120

2 years ago

dustinInfluencer

asked in Data

Select Distinct values Oracle Reader

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?

252

2 years ago

gisbradoklaEnthusiast

asked in Data

domain values from empty template

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?

230

2 years ago

mhabContributor

asked in Data

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

How to extract point cloud information from a ZFS file?

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

720

2 years ago

philippebEnthusiast

asked in Data

Directory Watch - Retrieve file name into an email

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.

2 years ago

manca_ent

asked in Data

Is there a transformer/function in FME that allows me to read attachments from an ARCGIS Online feature layer and append them to another ARCGIS Online feature layer?

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?

1400

2 years ago

rudy_vContributor

asked in Data

Database Connection - Config for Secondary - Readonly Database - SQL SERVER

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

360

2 years ago

Page 38 / 273

Badge winners

emiliodepalmahas earned the badge Student (Grey)
emiliodepalmahas earned the badge Teacher (Grey)
emiliodepalmahas earned the badge Welcome Back
poncetahas earned the badge Student (Bronze)
poncetahas earned the badge Student (Grey)

Show all badges

30,352: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.