- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,779 Posts
24,931 Replies

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

6779 Posts

Recently active

Most replies Most views Newest first

andylicht

asked in Data

Missing *.so files in the plugins folder

Hi,i have installed the FME Server Version 2021.0.3 with Docker. I´ve imported my Workspace successfully , but it runs into lot of warnings and it failed. These warnings are consisting of a lot of files, which could not be found. Why these files are missing and how could i fix these warnings. best regardstim

112

3 years ago

francis_mContributor

asked in Data

Read esri Shapefile from FTP

Hi FME users! I have to read some ShapeFile from FTP. I use a FTPCaller to get all the files that I need, and then user a FeatureReader to read ShapeFile directly from FTP. I can get the geometry, but not the attributes...Do you know why if I read from FTP, no attributes are read but only geometry ?Thank you for your help!Francis M.

294

3 years ago

matthew_banyardContributor

asked in Data

Writing File Geodatabase with existing domains - Zipped

Wondering if anyone can help - I've got a file geodatabase with coded-domain values, which is being updated by my writer with additional values and coded domains, following the instructions here: https://community.safe.com/s/article/working-with-geodatabase-domainsScenario 2: Writing to a new table using an existing domain This works absolutely fine with a geodatabase, however if I try to create a zipped version of it I hit the following error. 2021-06-28 11:24:49| 8.5| 0.3|INFORM|Created and connected to the ArcGIS 10.0 File Geodatabase at 'C:\\Users\\*\\AppData\\Local\\Temp\\wbrun_******\\fmetmp_8\\_auto_zip_dataset_******\\geodatabasename.gdb'2021-06-28 11:24:49| 8.5| 0.0|INFORM|Fast deletes enabled2021-06-28 11:24:49| 8.5| 0.0|ERROR |The attribute definition used is invalid for the non-existent domain 'Suitability'. For a coded value domain the proper syntax is 'coded_domain(domain_name:field_type:name_1:value_1: ... name_n:value_n)'. For a range domain

Is it possible to convert .obj files to .dwg files?

Dear FME community,I would like to know, if it is possible to convert a simple .obj-file into a .dwg-file. dwg is the standard for Autodesk AutoCAD. AutoCAD is not able to open .obj files. Originally I had gml/ cityGML and .xyz-files which I converted to . obj-files. If there is no way to convert .obj directly into .dwg, maybe it is possible to convert gml/ cityGML and xyz-files into .dwg-files. I would be very happy if you could give me any hints.Thank you very much in advance! Christian

"Error running translation". Where to start looking?

Fresh install of FME 2019.2. Installed ArcGIS Pro 2.8 in order to get the 64-bit geoprocessing for our .gdb files. Previous versions were 32-bit. Also have ArcGIS Desktop 10.8 installed (might be of importance). I get this far: Reading table/feature class 'RecreationArea_A'FME Configuration: Source coordinate system for reader GEODATABASE_FILE_1[GEODATABASE_FILE] set to `_LL-WGS84_0' as read from input dataCoordinate System `_LL-WGS84_0' parameters: CS_NAME=`_LL-WGS84_0' DESC_NM=`WGS84 Lat/Longs' DT_NAME=`WGS84' ESRI_WKT=`GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]' GROUP=`LL' MAP_SCL=`1' PROJ=`LL' QUAD=`1' SCL_RED=`1' UNIT=`DEGREE'Storing feature(s) to FME feature store file `C:\\temp\\wb-cache-!cip30_fgdb_new-WcyZHM\\Main_RecreationArea_A -1 403 -1 0 0e6998bf75e4d1127f4e8c9607ad

Write to fixed width text file

I use FME to get data from a database and have to write it to a text file with a fixed width. For example:Streetname (24 characters) number (5 characters) City (24 characters) postal code (6 characters)(+ like 25 more) StreetA 00011 CITYAA 1111ABStreetB 00021 CITYBA 1234AB I have tried to use the format fuction in the attribute manager but only got the format back like : 10s24s5s6sInput: @Format(24s,@Value(lokatie_straat))@Format(5s,@Value(lokatie_huisnummer))@Format(7s,@Value(lokatie_huisnummer_toevoeging))@Format(24s,@Value(lokatie_woonplaats))@Format(6s,@Value(lokatie_postcode)) How can I make a file with the above format? (I have no influence on the format used.)

How to expose source length unit from IFC file?

I've got a scaler in my workbench, however I would like to use a tester transformer, and branch based on source IFC file units which are either millimeter or meter. Currently I cannot batch input as we are relying on the reader and the unit expression feedback from visual preview. If the visual preview can work this out - surely there is an attribute we can expose? Any help appreciated. Many thanks

1074

3 years ago

lifalin2016Contributor

asked in Data

FFS files versioning and compatability ?

Hi group.A workspace that worked previously is suddenly failing on certain data since the last run half a year ago.I'm running it in 2018.1, but originally it ran in 2016.1, so I tried to backport the workspace to 2017.1 and 2016.1 to see if that made any difference.I'm utilizing a small dataset of buffered counties, and stored the buffered and thinned and otherwise manipulated dataset in an FFS file for convinience and performance. This file works nicely in 2018.1 and 2017.1, but 2016.1 claims that it has a wrong header or something ??This error persisted even when I used 2016.1 to create a clone FFS from the original non-FFS dataset ?Can anyone shed any light on the pitfalls of using FFS as intermediate storage ?Cheers.

424

3 years ago

sigtillContributor

asked in Data

Downgrade or choose version of FFS?

I am often using a new version of FME (FME2013 Beta) and stores intermediate files as FFS. The problem is that I can not store in an older version FFS which I can open in FME2012, or even FME2011. So I have to save to shape or some other non-SAFE format. Any workaround?

Projectwise IMS Connectivity

Hello,I am looking to connect to the on-premises Projectwise.I have been able to identify the base URL in the form: https//myhost.com/I type the URL on the browser and asks for my credentials, as well for the project I want to log in.Now one of the tricks is, we are using Bentley IMS services, so I do not have a password, it recognises instantly my email address.So, my first superficial question is, are there any ideas on how to handle this? I do not need to specify a psw within Bentley, so how is this translated in the FME world to establish a connection? Thank you, George

Excel Reader - Doesn't Update Named Ranges

I have an excel file that has named ranges. These named ranges do not seem to update when I change the data in the named ranges. Is there a way to solve this?

DEM elevations be 0.5m accurate instead of 1m

Hello,I'm generating a DEM file with the writer U.S. Geological Survey Digital Elevation Model (USGSDEM)However, whenever I click somewhere on the DEM raster that is generated, I obtain a round up value to 1 meter.Just before going into the writer, I have an inspector on my data and I do have floating point value for the elevation.Is there a way to force this writer to not do the round up and keep the value in floating point? Thanks

300

3 years ago

rahulsharmaSafer

asked in Data

Where to store root certificate for SSL enable Postgres/Postgis database (to enable/verify SSL for Database connections)

With FME Desktop 2019 and newer, Postgres and Postgis support SSL, this mode has different options as shown below in the screenshot. By default: Value is set to Disable For Verify-CA and Verify-Full, options the root certificate needs to be stored when connecting to RDS instances.

1572

3 years ago

paulotContributor

asked in Data

Performance disparity of Oracle Non-Spatial Reader on high-latency network

New to FME and befuddled by the performance disparity of Oracle Non-Spatial reader over high-latency network links. Needless to say, I understand the benefits of having FME close to the data, but… I compared the performance of the Oracle Non-Spatial reader against a CSV export from Oracle SQL Developer of the same database view on various machines in various locations on our network. The size of the fetch was 46394 database rows with just 8 columns. From a desktop machine in the data centre close to the source Geodatabase:SQL Developer CSV Export: 8m16sFME Desktop Reader: 10m11s From a remote desktop machine on VPN:SQL Developer CSV Export: 8m50sFME Desktop Reader: 72m Remote FME Server:FME Server Reader: 32m9s The most interesting fact is that the SQL Developer export suffered almost no performance impact even when it was executed over a high latency network link whereas the FME reader was de

394

3 years ago

townestContributor

asked in Data

Expose JSON Attributes

Hi All,I'm a bit behind the curve with JSON. Could somebody help describe the process to expose the three attributes in my simple file sample following: {'items': [{'att1': 'abc', 'att2': 'xyz', 'att3': 123}, {'att1': 'cde', 'att2': 'tuv', 'att3': 456}]} Notice that 'items' holds all the attributes. I have successfully setup a reader to intake the JSON, but now need to expose the attributes att1, att2, and att3. I looked at several transformers, but the parameters are somewhat foreign to me. A detailed workflow would be much appreciated, since some of the JSON lingo is foreign to me. Thank you, TylerFME Workbench 2021.0

Writing transparent layers in PDF

Hi,I read several WMS layers (from the same source) and each layer is written to a single layer in a pdf. For example, I read a WMS background map and write it as one layer, then I read a WMS line network and write it as one layer and this is where I have problems. In my line network layer, I want everything to be transparent, except of course the network itself. Can I create pdf with layers that are transparent for some values (white, no data...) by using a WMS source ? If not, is this a limitation of FME pdf writer or the pdf format itself ?I can't use the workaround by "pre-generating" the layers before writing them since the pdf would be huge.By the way, I am using FME 2013...Many thanksRickard

how can I import IFCPROPERTYSINGLEVALUE ( set into an IFC file) to a geodatabase ?

Hello, I would like to convert an IFC file to a geodatabase, with all properties. The transformer "Geometryfilter" is really good to convert the model to multipatch, but I can find how to get data set in the "IFCPROPERTYSINGLEVALUE" to my geodatabe, consequently the values present in this field are missing in the exported geodatabase.Thanks for your help!

3 years ago

kosatka

asked in Data

Uncontrolled igds_font alteration in DGNv8 writer

I need to write anotations to a DGN file (v8). To generate the labels (anotations), I'm using LabelPointReplacer, followed by AttributeCreator, where I add specific igds attributes manually. Everything goes well with a single exception that I'm unable to resolve: I set up igds_font attribute on each feature manually. If the input string is composed of basic alphanumeric characters, all goes as expected and correct font is used to write the feature. If non-standard diacritics (Czech) goes in, the igds_font is forced/overwritten to 1025 (Arial) in the writer. I was trying to add/alter multiple igds attributes, to specify Resource Font File, to play around with encoding of the incoming String and eventually went out of ideas what else to try. I'll appreciate any ideas. Thx.

3 years ago

goatboybozContributor

asked in Data

Add basemap to pdf output from ESRI service

Hi All, im trying to put a basemap under some vector linework output as a pdf.... Currently i use a http fetcher to get an esri basemap jpg, georeference image then use pdf formatter to try and combine the vector and raster. it all works perfectly when sent to an inspector but when send to pdf i get nothing.... is there a simple workflow im missing somewhere ? similar to this https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_DataInspector/DataInspector/Background_Map.htm with the data inspectors basemap under my data. I just want a raster basemap underneath my outputs. I have read lots of posts around this but not found a solution that works for me.

How to transform Ifc to shapefile?

I have an Ifc Model that I read in as multiple features using the IFCreader. Aftwerwards I am using the Esri Shapefile writer to output a single feature e.g. "IfcWall" to a shapefile.The translation is shown as successfull, however there is no file being written in the output directory...Could someone point me in the right direction of what I may be doing wrong?Are there transformations necessary between the reader and the writer?

Has anyone heard of the format with the qda extension.

It is supposed to be QuadrupleD, a DirectX library for Delphi and the suggestion is to use Direct Draw with Delphi to open???

3 years ago

rppenley

asked in Data

STEP ISO10303 AP 242 and ISO 14306 JT file formats for semantically rich CAD models

Is there a plan to support ETL for semantically rich CAD models using the STEP ISO10303 AP 242 or the ISO 14306 JT file formats? For our facilities, we develop BIMs and use IFC to extract, transform, and load geometry with associated metadata. However, we develop product models using CATIA and NX and are in need of extracting geometry and the metadata associated to that geometry. What methods do you recommend for extracting, transforming and loading these semantically rich CAD models?

How convert to .KML from .DWG ? how to know which transforms to use ?

Hi everyone, i hope you re doing well .i need to convert some dwg files to kml , my internship boss told me to use FME .i am new to FME , i am asking which transformers i need and how configure them ? i will attach one of my dwg files. please see it and tell me how to proceed.thank you so much.

144

3 years ago

jelleContributor

asked in Data

camelCase in SpatiaLite

Hi, when adding attributes to the SpatiaLite Writer, FME converts them to lowercase. However, my output needs to be in camelCase. Any ideas how to solve this? Should I raise an Idea in the Community, or is it just me? I found this track on underscores: https://community.safe.com/s/question/0D54Q000080hThDSAU/-in-fieldname-change-to-underscore-how-to-solve SQLite and GeoPackage (which is in fact a SQLite implementation) do not have this behaviour in FME.

Microsoft SQL server Spatial reader failing

Microsoft SQL Server Spatial Reader now fails to connect post upgrade to 2020.1. It worked with 2020.0. We are getting this error: Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. - is there something we need to install?

4616

3 years ago

Page 50 / 272

Badge winners

allasimonhas earned the badge Student (Grey)
allasimonhas earned the badge Teacher (Grey)
allasimonhas earned the badge Welcome Back
rspears90has earned the badge Webinar Watcher (Bronze)
lachlan.thas earned the badge Welcome Back

Show all badges

30,122: 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.