Using readers and writers to extract and load data.
Recently active
Hi,I have some old mapinfo files from approximately 1996. The log says it "Failed to obtain any schemas from reader 'MITAB' from 1 datasets". The files should be OK in that they were taken directly from a CD product. The CD did require registration, but the statistics agency no longer sells the CD or issues any registration numbers, so I can't access the data through the MBX on the CD as intended by the product.Does anyone know how I can see the data? I don't need any geography, I just need the data tables.I've attached some of the files.Thank you for any assistance!
I am trying to pull in a service from our organizational AGOL site (Enterprise Login), but cannot verify the connection.Where do I get this Client ID, Client Secret, Redirect URL information? And how to I input it into the web services? I can't change what's there by default and when I click the upload button, I get a window that's for FME Server, not AGOL.
I am having issues with FME reading the Band Value incorrectly or applying a conversion.
I am trying to read some kml files that were exported from Avenza PDF maps. The KMLs contain Lines, Points, and Tracks. I am able to read the lines and points just fine but the tracks are not output from the reader. Is there some way of exposing the Tracks?
Has anybody written a workspace to grab the users, roles, access of FME Server to write out to an external location like SDE table or excel? Is it even possible?
I am trying to use the FME Cesium 3D Tiles Point Cloud / 3D Tiles writer to write a .PNTS file in a 3D Tileset for display in Cesium JS. I would just like to know, whether in FME it is possible to set per-point properties in the .PNTS file's batch table. How can I do this? I will be storing an attribute called 'importance' along with every point that is essentially just that: the importance of the point for the purposes of rendering in a browser. I want to show more important points close to the observer location when viewed in Cesium, and progressively lesser important points farther from the observer. As the batch table stored per-point metadata, I need a way to modify the information contained in the batch table of the .PNTS file. If there is also any other way of doing this without having to modify the batch table, I would appreciate if anyone can let me know. Thanks!
Hi I'm trying to use FME to create cesium 3D Tiles tileset of buildings, including attributes. In the specification of b3dm format, it's done using property named batchID, witch makes it possible to assign verticies to defined batchID and assign attributes to it. It makes it possible to have single model with many buildings to have good performance, and still have possibility to read properties of individual buildings. In my workspace i have properly defined buildings and i can see, that in the inspector thay are viewed correctly. Each building is separate from others, and has its own properties. However, after exporting to Cesium 3D Tiles, the models are combined and entire tile has properties from first object in tile. Are there any extra steps needed to make it work? Do i need to define batchID manually?
I'm trying to use an ArcGIS Server Feature Service reader to pull data from feature services on a Server running 10.3 and write to an SDE using the Esri Geodatabase ArcSDE Geodb writer. I have a workspace that was created in FME Workbench 2016, where it still runs fine. I'm trying to run it in Workbench 2018.1 and I am getting Python errors stating that one of the modules is missing an attribute:" Python Exception <AttributeError>: module 'html5lib.treebuilders' has no attribute '_base'Could not create Python Reader `ARCGISFEATURES' "I upgraded to Pro 2.2.1 and have the workspace set to use Pro 2.1/2.2 Python (3.6). I'm assuming that since I have 2018.1 and Pro 2.2.1, they should be compatible and all the Python libraries should be up to date. I've tried updating the reader, and I get the same error and it won't update. I've also tried digging into the Python files and finding that module, and it seems to have a "_ba
I want to write an ifc file where all objects get a guid from the source.In my source dataset (rooms) there is already a primary key (in guid format). I want to keep this key in the exported objects (IfcSpace). I have tried to set different attributes with this value (ifc_id, ifc_unique_id, GlobalId), but the ifc writer always generates a new guid for each object.How can I arrive to export an already existing guid for each object?
Hello All We are converting some City GML 3D models in Esri Shape format. During the process we receive an error message : DBF Writer: DBF file exceeds maximum size of 2 GBError running translation.Any solution is very much appriciated
HelloINSPIRE GML writer has a parameter to set "Maximum Decimal Places: ...." CityGML writer doesn't seem to have this setting.Is there a way to somehow limit the decimal places in the coordinates of CityGML output ?This is a requirement in Germany and I don't see how I can achieve this in an easy way ...ThanksMichael
My aim is to get a nice DEM out of my severeal xyz files. I was hoping to be able to generalize the files and save some time when running the RasterDEMgenerator . Any ideas for doing so? I have tried e.g PointCloudThinner and Generalizer but they dont seem to accept my input.
As soon as I try to fan out data to windows folders the KMLStyler no longer works. I expect the "Style" feature is no longer written to the KML file at all. I have no idea how to fix this. I have a simple example which works when I remove fan out. I fan out to a folder based on an attribute in a clipper and create a kml in that folder with the a name using fme_feature_type. Thanks in advance, Ian
I have a workflow that needs to bring data from an ESRI geodatabase, do some standard transforms, run a complex Excel model, and summarise in a final Excel output. Clearly FME will write to the model input sheet. But can I get FME to run the model as if it was a transformer, then pull the results out to the final summary? Thank you.
About possibility in FME Workbench to write in Microstation DGN XFM format, linear elements (polylines) with attributes for a dataset that have lines with elements but other format not supported by Microstation. I need to be able to see in Microstation Bentley Map the polylines and their attributes. Currently, I have the lines and their attributes in MS access format for Geomedia and ESRI and would be great to be able to export them in DGN with XFM attributes. DO you have any advise on that? Thank you! Lavinia
There is a Reader from DGN8XFM files, dgn with attributes linked to elements, but no writer to be able to obtain a DGN file with attributes to graphical elements? How to create a FME schema that writes DGN file with XFM attributes?
In the next few months we will be migrating from an FME Cloud instance (2018.1) on Linux to Windows Server 2016 and I haven't been able to locate any information on the proper way to migrate this. Trying to get a game plan together before we attempt this. We will still have the FME Cloud instance running while we perform the migration. Will the FME Cloud backups work with the FME Server on the Windows server platform? If anybody could point me in the right direction, or have any useful links, that would be much appreciated. All I can find is migrating from FME Server to FME Cloud information, so I wasn't sure what hurdles might be in the way in doing this the other way with different OS's.
I would like some features in PostGis database, there is one field called 'dt_desc' with the value (2018-09-04 19:00:20).But the WARN messege showed in my log: 'dt_desc' cannot be convert to timestamp, and none features is recorded.I tried change the format in FME writer to timestamp, varchar, date...but the problem continue againIn my PostGis database the format for this field is timestamp.Somebody can help me?Thank´s
How is the status to read/write gbxml format in FME?
Hello Everyone,I have 17,000 TIFF files(~3Mb each) that I need to merge to make just one file. While I create the workbench and read the data as Single Merged Feature Type, it takes a lot of time to read the data (feature types to read) and once I run the wb, it ends up crashing or the output(zipped) is not merged. Any solution for this?
HiI have to migrate a bunch of FME scripts from PostgreSQL/PostGIS to MS SQL Server for every Reader and Writer. The straightforward way would be to just replace any Reader and Writer with its MS SQL Server version, and to modify any SQLCreators and SQLExecutors. Many days of work... Is there a more efficient way to handle this?Regards, Tobias
HiI am trying to read a JSON file:{ "meta" : { "Version" : "1.0", "Create time" : "2018-08-30 18:40:02 UTC" }, "units" : [ { "dn" : "ou=test,ou=Org,o=xyz", "attributes" : { "countryName" : "SE", "createTimestamp" : "20180504113600Z", "creatorsName" : "cn=improxy,ou=System,o=test", "hsaCountyCode" : "14", "hsaIdentity" : [ "test" ], "hsaMunicipalityCode" : [ "1480" ], "modifiersName" : "cn=admin,ou=System,o=test", "modifyTimestamp" : "20180829082917Z", "ou" : [ "xyz" ], "vgrAo3kod" : [ "501" ], "vgrModifyTimestamp" : "20180618080954Z", "vgrModifyersName" : "cn=user,ou=Personal,o=test" } }, { "dn" : "ou=clients,ou=Org,o=test", "attributes" : { "createTimestamp" : "20180503113416Z", "creatorsName" : "cn=improxy,ou=System,o=test", "hsaIdentity" : [ "test" ], "modifiersName" : "cn=user,ou=System,o=test", "modifyTimestamp" : "20180504030003Z", "ou" : [ "clients" ] } }, {It g
HiThere is this really cool writer called Generic (Any Format). I tried to use this writer to keep my scripts independently from the DBMS I'm writing into. This would enable me to switch DBMS very fast, and just to have one lean script to work with PostgreSQL, MS SQL Server, Oracle, or Teradata.Thing is that I make use of the parameter fme_db_operation in almost all my scripts. Some features lead to an INSERT, some trigger an UPDATE, other a DELETE.I couldn't make the Generic ( Any Format) writer to accept fme_db_operation. It always leads to an INSERT operation.How do I use the Generic ( Any Format) writer with the parameter fme_db_operation?
Hi,I am new to FME. I have asset inspection data in an Excel file and I need to produce a summary report from it. Each row in the table has a unique ID representing an asset. The questions relating to the asset are answered yes & no and a comment is entered when the ansewer is no.I need to produce a summary report for each ID whereby any Question that has a No value will be an over all fail and I would like the Comment to be in the report also. ID Question A1 Comment A1 Question A2 Comment A2 Question A3 Comment A3 Question B1 Comment B1 Question B2 Comment B2 Question B3 Comment B3 1 Yes My A1 Comment No My A2 Comment Yes My A3 Comment Yes My B1 Comment Yes My B2 Comment Yes My B3 Comment 2 No My A1 Comment No My A2 Comment Yes My A3 Comment Yes My B1 Comment No My B2 Comment Yes My B3 Comment 3 Yes My A1 Comment Yes My A2 Comment Yes My A3 Comment N
Hey there! I am going to create my homestate Mazovia in Minecraft. I based on Bowen Island Raster (https://knowledge.safe.com/articles/1064/how-to-make-minecraft-worlds.html).I have everything quite similar but something doesn't work. Instead of DEM I use GeoTiff. After running programm I received a 5 warnings (below) and after translation my world doesn't have any terrain except roads and rivers.MINECRAFT writer: Converting component 'x' from type 'Real64' to 'Int32'. If this conversion is undesired, consider changing the type explicitlyMINECRAFT writer: Converting component 'y' from type 'Real64' to 'Int32'. If this conversion is undesired, consider changing the type explicitlyMINECRAFT writer: Converting component 'z' from type 'Real64' to 'UInt8'. If this conversion is undesired, consider changing the type explicitlyMINECRAFT writer: Converting component 'blockData' from type 'UInt16'