Using readers and writers to extract and load data.
Recently active
@Mark2AtSafe could you share an IMDF Archive example export from FME with me?
how convert my autocad file to revit file?
It looks like there might be a limitation of only being able to use a single file upload parameter for a workspace when running the workspace through the FME Server Javascript API. Does anyone have any experience with this, or how to overcome the limitation? I'm assuming that we will need to resort to the REST API?Here's what the documentation for the Javascript API states for the FMEServer.runWorkspaceWithData( path, parameters, callback ) method:parametersObjectThe Object representing the parameters: { filename : workspace_file_parameter_name, files : files_object, params : name_value_pair_string, service : service_name }Note that there is only a single "filename" parameter. You can upload multiple files to that parameter but it's just one parameter.
I am encountering this error in FME when trying to do a POST request using the HTTPCaller when trying to reindex ArcGIS Portal using FME Desktop 2016.1. The ArcGIS Portal token was retrieved successfully before Portal reindex that means the proxy settings works fine.HTTPCaller(HTTPFactory): HTTP/FTP transfer error: 'Failure when receiving data from the peer' HTTPCaller(HTTPFactory): Please ensure that your network connection is properly set up HTTPCaller(HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered
I am using FME to update (Insert mode) an existing Google Fusion table. My FME Workspace runs successfully with no errors and shows that it writes the features. However, the Google Fusion table shows no edits or features inserted. Any ideas? My Google Fusion writer has the credentials of the owner of the Google Fusion table so permissions should not be an issue.Thanks,Sasha
Hi.I have multiple excels as input. I am carrying out the summary from StatisticCalculator and writing the output in excel itself using batch mode. The output is Output_<input file name>. The number of input files is the same as the number of the output file. Now, what I want is to get output in one single excel in multiple sheets(tabs) with sheet name as Output_<input file name>. Will the same thing work with Batch mode? What I already tried is to use the sheet name as the reader parameter but the output is not as desired. Also, I tried FileNamePartExtractor, the attributes are blank. Any solutions?
Hi,So I have an oracle database with oracle timestamps as one of the columns. How can I make it so the reader only reads records between today and 7 days ago based on that timestamp? Otherwise I'll be reading millions of useless recordsThanks so much!
Hi,I must update a Oracle table. I use this parameters on the Writer:Create Table: NoTruncate Existing Table:YesWriter Mode: INSERTBut the table is not updated. Can you help me?
hi. i have a gps file with dxf format. how can convert it to rinex format with FME.?
Hi,I am exporting a contour featureclass into AutoCAD, Geopackage, and shapefiles using the FeatureWriter transformer by exporting by contour grid. My contour featureclass is in 1km2 grids (255 grids) and is set up in the FeatureWriter to write out$(External_Location)\\Contours\\@Value(GRID)_DWG.zip where @value(grid) is the contour grid and "_DWG.zip" allows me to easily search/select from within the folder each format (the others being "_SHP.zip" and "_GEO.zip").The setting under General--> Layer Name: @value(GRID)For shapefiles the shapefile is just the grid name (ie.50-75.shp within folder 50-75_SHP.zip) but for geopackage and autocad the folder naming schema extends to the layer within despite the general layer name being set to @value(GRID) (ie. 50-75_DWG.dwg within folder 50-75_DWG.zip). Am I missing a setting?
I have a raster with z-values and would like to export it to a 3D pdf, with some specific symbology. I have already successfully created a 3D pdf with contour data (following this tutorial), transformed into a TIN and then overlaid by a raster, but the resolution is not good enough so I would like to use the original raster. Any help is highly appreciated and I hope that somebody can guide me in the right direction on which transformers to use!
Hi,I am trying to migrate data from our GeoDatabase (SQL Server), to native SQL Server Spatial but cannot get Spatial to write polygons. As you know ESRI store polygons as simple features, and cannot store it as Curved PolygonHow can you write it as a polygonSQL Server spatial store, example belowCURVEPOLYGON (COMPOUNDCURVE ((321812.2796 5810770.8994, 321768.84219999984 5810777.0451, 321768.86170000024 5810777.1837, 321775.38910000026 5810823.4657, 321767.89279999956 5810842.0508, 321778.49299999978 5810846.3264, 321779.66550000012 5810854.6341, 321779.69000000041 5810854.6436, 321812.2796 5810770.8994)))I have tried the geometryExtractor and geometryReplacer, but the final result is not 100% curved (arc), and is just a set a straight lines
Hi all,as in topic: I have problems with existing formatting of xls file where I want to write/update one sheet. Till today workbench worked as it should. No problems occurred. Today complete disaster. In whole file formatting is vanished, the table where I update data there is no formatting, so I don't do anything with FME to create it sth else connected. When I open xls file I get message that: we found problems with some content do you want to recover file if you trust the source of it? After recovery there is no formatting anymore :(EDIT:Only change is that to formula OR within xls I've add one more argument (now there are 3 of them). File is saved as xlsm (it was like this from the beginning) but issue is solved if I save file as xls. Anyway I can't use this file format, I need macro enable one.I've tried to upload reader and writer once again previously deleting old once. Issue stays :(Any ideas what I can do?
I have Multiple city member in sketchup file but when I convert it combine into one cityobjectmember?this is skp to citygml converter @daveatsafe
I have a directory of PDF files and would like to select some of them for merging.Is there a way of merging a list of PDF files to a multi-page PDF file?
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.,