- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,810 Posts
25,084 Replies

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

6810 Posts

How can autocad_anno_handle be created and associated between mtext and leader

I am trying to create mtext leaders and I am trying to follow the documentation which has these attributes and I have tried to create text adder at last point on leader line and then write a unique annotation handle to autocad on both leader line and text but the entities are not associated when I open in autocad.Can I not create text in a leader?

400

4 years ago

nicholasContributor

asked in Data

Output shapefiles have null geometry

I have a contour dataset, which I want to clip into tiles. The contours and tiles are both in shapefile format, GDA2020 datum (Zone 55)Half of the output shapefiles are okay, but half have no geometry.

How to fix 403 'SSL Required' Error while using ESRI ArcGIS Online Feature Service Reader ?

I'm wondering how I can make a request with SSL using the ArcGIS Online Feature Service reader. No matter what I do, FME continnue sto try to access via HTTP instead of HTTPS. I'm reading a features service hosted in ArcGIS Online into FME Workbench 2020 64 bit. Last week I was able to connect to a service using the Feature Service reader without issue. But our admin team converted the ESRI organization to require HTTPS only, which seems to coincide with the 403 error I'm receiving. I've remade the web connections, tried to reconfigure the feature service URL to use HTTPS, with no luck. I receive this error This may be a temporary server issue, or insufficient permissions. The error code from the server was '403' and the message was: 'SSL Required'Failed to obtain any schemas from reader 'ARCGISONLINEFEATURES' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. S

Recurring data load with Different files

Hi Team,I need assistance in optimizing the FME package. I am new to FME. I have a workbench with reader as OGC Geopackage and writers as csv,shp, json (same data but created different output). I have 5 geopackages . I need to update the reader everytime in order to create the output files. I cannot join or merge these files. Is there any way, after one reader reads 1.gpkg and completed the flow, it pick 2.gpkg and continue execution till last available package. Also I want to update the writer dynamically based on the input files. In SSIS, we have a for each loop container. Is there any way to loop through the files and creates output files. Currently, I am changing the readers and writer to execute one gpkg. So if I have 5 inputs, I am changing reader and writer everytime. This is manual process and high chances of human error.

370

4 years ago

r_hueskenContributor

asked in Data

Error reading geopackage

Hi, I have troubles opening the attached geopackage, and I can't figure out what is wrong with it. It opens nicely in QGIS (where it displays the rasters) and with a SQLite client I'm able to access the tables. The error is : "OGCGEOPACKAGE reader: `IHC Krimpen online - Progress - GRD - Version 1_20200409 204806.gpkg' exists but could not be opened. File contents may be invalid, or the file format may not be supported"Using FME 2020.1

1910

4 years ago

sameerContributor

asked in Data

Reader detects ESRI Zipped files as EDIGeo format

FME(R) 2020.2.0.0 (20201027 - Build 20787 - WIN64) Hello Whilst troubleshooting an automated workflow, I realised that FME was actually reading the Zipped file using the wrong format.It happens when I drag and drop the zip file. (I, unfortunately, cannot share the files.) I tried a different approach, which was to unzip the files then re-compress them again in case it was a "corrupt" archive, but same result. ThanksSameer

4 years ago

mixedbredie

asked in Data

Lowercase PostGIS table names

Hello FME'ers I am using FME 2013 SP2 to bulk load data into PostGIS 9.2 from Oracle 10 using a very simple workbench. I can set the attribute names to lower case in the PostGIS writer (as well as create the GIST index, sequence and primary key) but I also need to set the table names / feature type name to lowercase. I have several hundred tables to copy over and it would be nice to change case automagically rather than manually editing the workbench. Any suggestions? Thanks Ross

10914

4 years ago

redgeographicsCelebrity

asked in Data

Set character encoding on Oracle writer

Asking on behalf of a client: they're writing to Oracle and getting an error regarding an UTF-8 string that can't be converted to Windows-1252. I can't seem to find a way to set the encoding on the Oracle writer, is this handled in the database definition itself (i.e. outside of FME)?

DWGstyler giving different colors to different blocks. But in CAD all the blocks have the same color in red.

Hi, I have a problem where I use DWGstyler to assign different colors to different blocks, but when I open the file in CAD, all these blocks have the same color in red. I am new to FME and hope someone can help me with this problem. Thanks in advance!

Preserve Global ID Error

HiI am importing Points along with their attachments from ArcGIS Online. I am using sde writer with the new option of preserving GlobalIDs. the issue is it runs smoothly on feature class but with table initially it runs fine and stores the data but at the end it gives me this error.

Output to csv with 2 header rows

I am running FME Desktop 2019.1 and am trying to output the results of a Feature Merger to a csv file but I want to add an additional row in the csv file before I have the column headersieI want the output to look like this:but I can only get this:in excel it would look like this: FORMAT ASSET DETAILS , STANDARD 1.0 REGNAMEASSETNBRTMPLASSNBRDESCRLONGDESCRSHORTDESCRASSETTYPEASSETSTATFLEET1000000090000000Sj300 2019 White Ls Colorado 4 X 4 DieseSj300 2019 White Ls Colorado 4 X 4 Diesel (Ranger 4) SJ300Sj300 2019 White Ls SN Is there a way to do this?Preferred output is csv but if i its do-able to excel that will suffice.Thanks in advance

I'm looking to summarize similar feature classes contained in an ESRI File Geodatabase. I am simply looking to write out counts of features appearing to excel and possibly summarize these. I have tried using the attribute pivoter with no luck.

In FME, I have a File Geodatabase Reader (merged feature type). I would like FME to group features by fme_feature_type and output each feature type to a port. I have gotten close with the attribute pivoter, but haven't had any luck writing counts. Does anyone have any suggestions? What I'd Like to accomplish: Almost got it with attribute pivoter:My settings for attribute pivoter: Thank You

4 years ago

sigtillContributor

asked in Data

IFC - missing geometry from IfcReinforcingBars

I try to read an IFC with IfcReinforcingBars. All attributes etc gets read in FME correctly, however there is no visible geometry. I can not share the data, but wonder if there are certain elements/geometrire FME does not read from IFC? I tried the 3 different IFC-readers, and also different settings on the reader with no luck. Examining the features in FME Data inspector shows no geometry. But it seems to be aggregates and Geometry Instances. I also tried the GeometryInstantiator to see if I could get the geometry. https://www.safe.com/transformers/geometry-instantiator/ An image of IfcReinforcingBars can be found on this page for instance: https://github.com/xBimTeam/XbimGeometry/issues/74

Issue connecting to ArcSDE (ArcMap 10.5) using connection file

Hi There,As per the title, I am having trouble connecting to an ArcSDE geodatabase using a connection file. I can confirm that I am able to connect to the database in ArcMap/ArcCatalog so my feeling is that there is nothing wrong with the connection file, but possibly some other issue that I am having trouble trying to resolve.I am running FME 2018.1 32-bit and have also tested this in FME 2017.1 32-bit to no avail. I can also confirm that I also have the 32-bit Oracle Instant Client (12.2) installed and configured correctly. I am currently running Windows 7, but I have also tested on a colleagues computer (32bit FME 2018.1 and 32 bit Instant Client) who is running Windows 10, and we both receive exactly the same error.The error that I am receiving is the following:---------------------------Fetching Feature Types Error---------------------------<b>Failed to retrieve feature types.</b><p>Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '

536

4 years ago

bubblebebContributor

asked in Data

Elastic Reader Issues

I am having issues connecting to one of our elastic databases. The error I am getting is Failed to obtain any schemas from reader 'ELASTICSEARCH' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. Any ideas what how to fix.

460

4 years ago

richardtContributor

asked in Data

What versions of PostgreSQL/PostGIS do different versions of FME support?

I'm specifically trying to find out what versions of PostgreSQL & PostGIS(non-raster) are supported by FME "Desktop professional" version 2020.1.2. More generally it would be good to know if there is a place we can find this information for ongoing versions of various FME platforms. I have tried looking in these places... https://docs.safe.com/fme/2020.1/html/FME_Desktop_Documentation/FME_ReadersWriters/postgis/postgis.htmhttps://downloads.safe.com/fme/2020/whatsnew_2020_1_3.txthttps://downloads.safe.com/fme/2020/whatsnew_2020_0_3.txtbut could only find (in the last link) that some fixes were done to support PostgreSQL 12+

390

4 years ago

sigtillContributor

asked in Data

Share to Elevation layer on ArcGIS Online

Is it possible to publish an elevation raster as an Elevation layer / Web Layer in FME? Similar to this screen in Arcgis Pro: By using a regular writer or AGOLConnector?By pythonscript? Described here: https://pro.arcgis.com/en/pro-app/help/sharing/overview/web-elevation-layer.htm

300

4 years ago

oscardInfluencer

asked in Data

Is it possible to tell FME which DB2 driver to use?

I'm currently putting together a FME workspace that reads data from a DB2 database. As I didn't have any driver installed, I followed this guide to install them in my computer. I'm using the db2jcc4.jar driver, Everything works fine. I sent the same workspace to a client. They had installed the DB2 dirvers, so I told them to copy the db2jcc4.jar one to the plugins folder of the FME installation. When they run the worskpace, the db2jcc4.jar is ignored and FME uses the db2jcc.jar that is found in their IBM products installation, instead of the driver in the plugin folder. Is there a way of forcing FME to use the db2jcc4.jar driver? With the other one, FME reads the alias of the fields instead of the names, which provokes several errors. We are using a FME Desktop 2018.1 in a Windows machine. Thanks for any help provided!

4 years ago

samuel.wsp

asked in Data

DGN levels not the same as in Microstation Connect.

Hello, I have a few DGN files where I want to separate the data depending on what layer they belong to. In Microstation I can see that the objects in the file is on a level, ex "Växel spårspärr bef V". But when I check the data in FME inspector all igds_level_names and fme_feature_type are set to "ECT_DGRM_RFPT_MARK". Anyone know why they are different and how to solve this?

How to combine feature layers into existing dataset

I have several point-based datasets that I need to consolidate into an existing point dataset while maintaining all the attributes for each layer. How can I do this? Thank you

310

4 years ago

joe.fmeContributor

asked in Data

WMS URL with a Drive Letter in

Hi all, I've been asked to read a WMS which starts with a regular looking URL, which then forwards to a URL which is proving difficult. The URL looks as follows -http://<url>.co.uk/WMS/MS/7.2.1/mapserv.exe?map=D:\\Websites\\<service>\\Services\\WMSSHARE\\map\\Layers.map&SERVICE=WMS&VERSION=1.1.1 The part that's giving me trouble is where the D:\\ is. I've tried enclosing the URL in speechmarks and using a pythonCaller to workaround this, but so far I've had no luck. I managed to get the URL changed once, but it just forwards to this one, which is causing issues. Has anyone else experienced something like this?

4 years ago

miquelrsContributor

asked in Data

Hello Community, Addressing to all FME users for United Kingdom, just wanted to know if someone is using FME for managing Gazetteer data, specially with BS7666 databases, which is the British Standard for Gazetteer data management.

In our Local Authority, we're considering using FME for automating certain actions that are recurrent and would make Gazetteer maintenance more bearable. We already use a Gazetteer software, but we believe that there are actions that could be more automated, and our software doesn't do.We'd like to hear stories and experiences form users that have attempted similar things using FME, or even other ETL solutions such as Python.

4 years ago

jportemer

asked in Data

Can GeoJSON format handle M-values?

Hi,I need a text based format that can handle measures values for futher treatment in QGIS. Can GeoJSON suitable for this? I currently does not manage to keep the M-values using GeoJSON as Output port and I currently can't determine if I miss some configuration option or if the format does not handle M-values at all.If GeoJSON is not the answer, what file format could I use? I need to handle custom CRS as well (EPSG:2154).Thanks for your help!

I need to control the projection associed to a dwg in fme 2018.

Hello,I need to control the projection associed to a dwg in fme 2018. I have tried to read the autocad_entity : autocad_info in the autocad layer 0 of a Autodesk AutoCAD DWG/DXF reader with the [read drawing system variable to read] checked but it seems to have nothing provide in any of de field.Is anyone know how to get this information?Thanks by advance

600

4 years ago

antoineContributor

asked in Data

Is it possible to append to a json file saved as an Azure blob? AzureBlobStorageConnector overwrites.

800

4 years ago

Page 58 / 273

Badge winners

rrastoghi9has earned the badge Expert (Grey)
rrastoghi9has earned the badge Teacher (Grey)
rrastoghi9has earned the badge Student (Grey)
raoodh12has earned the badge Teacher (Grey)
raoodh12has earned the badge Student (Grey)

Show all badges

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