Using readers and writers to extract and load data.
Recently active
I am unable to read a netcdf4 file into fme (2015, 16 or 17).I get the following error:NETCDF reader: `C:/Users/phtr/Desktop/TCI_ref_to_month_europe_2000_v1.nc' not recognized as a supported file format.NETCDF reader: Failed to open the dataset 'C:/Users/phtr/Desktop/TCI_ref_to_month_europe_2000_v1.nc'. Please ensure source data is valid and correct reader is selectedA fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'NETCDF' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationIf I convert the input to netcdf 3, FME can read it OK.Is anyone else having this issue? Is it a know limitation of FME?Many thanks
Hi,I am trying to translate features from an ESRI File Geodatabase (using the File Geodb reader) to an SAP HANA database using the SAP HANA Spatial Writer.With the default configuration of the writer, I can access the database and write features which I can properly display in FME Data Inspector. In contrast to that, I cannot display the data in ArcGIS Pro. The following error message appears: "Failed to add data."In addition, the query layer seems to miss a reference to the table data in ArcCatalog. If I access the DB with a DB visualization tool, the data looks fine. Every feature has a Shape and a GEOM attribute, e.g.Does somebody have any experiences with this bug/behavior and can provide help so I can display my data in ArcGIS Pro? I am using the following set-up:FME Desktop 2018.0 Oracle Edition Build 18312 - WIN64 ArcGIS Pro 2.1.3 I set up the connection to HANA according to this article:https://knowledge.safe.com/questions/72129/connecting-to-a-hana-geodatabase.htmlT
Hello All,I have a group of many TIF tiles with associated TABs which I open via a seamless table in MapInfo. I can open the TIFs directly in QGIS and they are correctly registered. However, I want to be able to create the equivalent of a MapInfo seamless table that can be used in QGIS. Would this be a Virtual Raster Catalog? And do you know how to create this in FME? I've tried the RasterMosaicker to produce an ECW but I get a warning (and this just creates a whole new (big) file anyway so not ideal):TIFF reader: TIFFFetchNormalTag:ASCII value for tag "ImageDescription" contains null byte in value; value incorrectly truncated during reading due to implementation limitationsAnd error:ECW writer: This format cannot support palettes. Consider removing or resolving palettes that are attached to the rasterWhen I try to build a Virtual Raster Catalog in QGIS I get the following error for each tile:Warning 1: TIFFFetchNormalTag:ASCII value for tag "ImageDescription&qu
Hello,I'm using featureReader and then i write results to GML format using dynamic writer. When I read from dataset which contains around 20 mln of rows after ~30 min I get (in job logs):Internal Error: [READERR] Read errorQuestions:1. Where can I find more detailed description of that error?2. Maybe it is DB timeout? If so is there any workaround for that? I don't think that it will be possible to change connection timeout on DB server to higher value.Thanks for help :)EDIT:Also when I run it locally I have other exception after ~3hrs: InsufficientMemoryAvailable:/
Hi, I was trying to write in a layer on ArcGIS Online from this same layer. However, I get the error python error: must be char not unicode. Someone could help me. The script worked before. Thank you!
Hi there,Does anyone know of a way to read multiple layers from an ArcGIS Open Data Site but in a single reader?I need to process many layers from a single ArcGIS Open Data Site and I can do this with individual readers for each layer URL but to make it cleaner I was hoping a single reader could be used to get all the layers I need.
When attempting to connect to MSSQL Non-Spatial schema with Windows Authentication, I receive the following error: "Microsoft SQL Server <Non->Spatial Reader: Connection Failed. Connection string 'Provider=SQLNCLI11;DataTypeCompatibility=80;DataSource=<server>\\<iinstance>;User ID=;Password=*********',Provider error '(2147467259) Named Pipes Provider: Could not open a connection to SQL Server [2].' Due to database security policy I need to use Windows and not SQL Server Authentication. I am able to access the database with SQL Server Management Studio using Windows Authentication, and have checked server and db name are correct. In the error message, the Windows 'UserID' value appears to be empty, does this mean I need to configure the AD user with FME? If so could someone explain how or refer me to instructions? Thank you.
Hi to all, I didn't find any information about requirements for ArcGIS Server and Portal installation for possibility to publish ArcGIS Feature Service. I mean Hosting, Data Store instalation and so on. Documentation? Thanks.
I'm trying to translate from text features (which translate with their "Text Location As Point") into feature-linked annotation in a GEODATABASE_SDE format. I have the feature class and the feature annotation class and the relationship between them set up in the geodatabase. When I only had the feature class created in the geodatabase I was able to run a translation and populate the feature class. But since creating the feature-linked annotation class in the geodatabase, I am unable to complete a translation. Note that I made sure the feature class (map_element) and the feature linked annotation (map_element_anno) class had zero records before running the translation. Also, note that there are many other feature classes and tables in the geodatabase. So if I were to use the workspace template method for the writer, the schema would contain much more than the features I'm trying to work with.Here's the error message I get when I run the translation:An error occurr
After converting .las to .pnts(3D tileset) ,we are able to retrieve RGB and x,y,z but we're unable to retrieve attributes like intensity,classification,no.of returns etc.,
I'm attempting to write linear features to predefined levels with established byLevel characteristics such as line weight, line color, etc. Specific levels are being defined per feature via the igds_level_name attribute when writing to the DGN writer. The configuration of these levels is not established in the SEED file being referenced, but they are configured in a .dgnlib file. Does FME support the use of .dgnlib files?
Hi,I'm trying to write data into a PostGIS database. However, I get the following error:Bulk copy failed on table 'schemaname.dataset' * using delimiter ':'. Error was 'ERROR: value too long for type character varying(3)CONTEXT: COPY dataset, line linenumber, column columnname : "attributevalue"A fatal error has occurred. Check the logfile above for detailsBulk copy failed on table 'schemaname.dataset' using delimiter ':'. Error was 'no COPY in progressThe type character of the column is not set to have a width of only 3. But I keep getting this (or other similar errors).I have tried multiple things:- Using CSV instead of Excel as a datasource- Increasing the width of the attributes- Changing the type of the attributes ( text or string instead of varchar) of both the reader (input) and output (writer)With the Excel file I would get a similar error, but on a different column and line. with the CSV it gets stuck.I have to note that
Hello allHoping someone can help, i have a minecraft world created with FME, this world contains the Ground mesh.i now have the 3d geometry for the trees and buildings, i want to add this geometry into the exisiting minecraft world.Any ideas. Thank you
I installed AutoCAD 3D Map 2019 and FME Desktop 2018 Win 64 for a user this morning. He also uses Smallworld.He's getting this error message: "This FME edition does not recognize the `SWORLDSWAF' writer. Please ensure that the current platform supports this writer, the writer name is spelled correctly, and that you have installed all required plug-ins."Honestly, I know nothing about FME. I never even heard of it until this morning, so I'm reaching out for help. Is it possible that the server software (which I don't have access to) needs upgrading? Smallworld runs on Java, so could an old version of Java be the problem? I doubt he had a very old version though. The PC is running Windows 7 Pro 64 bit. Thank you.
Hi there.I was trying a simple task to download a csv file from S3 and convert to a shapefile. I could download files with S3 Downloader and narrowed down to my target CSV file with StringSearcher. Then, I used FeatureReader to read the target CSV but I couldn't bring any attributes in the CSV file with this process. I am hoping I expose all attributes including latitude and longitude. Then I want to generate geometries from those lat & long with all attributes.When I run the above workspace, then I got no attribute like below. The process itself was successful though.Here is my original CSV table I was working on.When I create a Creator---FeatureReader workflow with a local csv file, I didn't have any problem to include (expose) all attributes. Why I am missing all attributes when I download a csv file from S3 but didn't happen with a local csv file? What I am missing here??Please give me some advice!Thank you.@hirooimaki
FME Database EditionBuild: 18295OS:Microsoft Windows Server 2012 R2 StandardI am unable to connect to an instance of Microsoft SQL Server.Steps to reproduce:Tools> FME Options > Database Connections>click '+' buttonentered in all connection info for Microsoft SQL Serverusing windows authenticationWhen using Windows Authentication I receive the following error:Microsoft SQL Server Non-Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=155.80.100.24 ;User ID=;Password=********'. Provider error `(-2147217843) Invalid authorization specification'On the same machine I am able to connect through ArcGIS Desktop using the same connection settings
I have city models in those formats, how to translate them to other format and to each other?And why on earth should FME leave some formats that can only be read or write, not both way?
I have Feature Reader that pulls tiff files, these are then passed on to the Geotiff writer. I now want the writer to write the tiffs, with the world files. I have selected within the writer to include world files but it is not working. I've uploaded the workspace. Thanks for any help.Bjudes
I am attempting to convert a DWG file to an ESRI Shapefile for use in Arcmap and ArcGIS online. The placement of the shapefiles seems to come out ok, however some of the geometry is missing. Just pieces of layers. An inspector was added to the workbench and the geometry looked just fine in it. This has been attempted in both 32 bit and 64 bit versions of workbench. Any suggestions would be much appreciated!!
Please help to visualize data from excel in ArcGIS shape files.(excel to polygon shapefile)Please see attachments.
Hi,I am not sure whether this is an FME issue or an ArcGIS Online one. But when writing to a ArcGIS Online Feature Service, writing fails if overwriting / updating a layer which has 'Time Enabled' within ArcGIS Online.If only the single time field is selected, it appears to work ok. If a start and end time are chosen, it doesn't. Citing the error:'addResults' error for a feature in 'Events'. The error code from the server was '1000' and the message was: 'The given key was not present in the dictionary.'It goes away if time is disabled again within the Service an AGOL.Any ideas would be greatly appreciated.Matt
What is, or is there, compatibility for FME Desktop and AutoCAD 2019 yet?
We currently have a single workbench stored in a central location being accessed and ran by various users, at various times. I would like to be able to incorporate the individuals system username into the log file name, as well as the date/time when they ran it. Is this possible?
Hi, I'm trying to write a landXML file for import in Civil3D. I have used the template from an old article that writes the metadata. I can get out a file that contains the geometry and the metadata but it won't load in Civil 3D. I have no idea how to get it to work and I have never found anyone that got it to work either in real life or on the internet. Why is documentation so scarce? It seems most people even from Safe only provides half answers on any of the prior threads on this issue. Thanks! /Jacob
Trying to convert the data from Access DB to Oracle non spatial tables. Column is number at writer but the values shows as double with precision values so data format voilation after conversion, Am i mssing any configurations? shows problem in detail.