Using readers and writers to extract and load data.
Recently active
Hi,I am trying to use a static map fetcher for OSM. There are a number of these on Github but they all focus on using a center point and zoom level where the output is always provided as an unreferenced PNG. I'm basically looking for a bounding box OSM StaticMapFetcher rather than a center point one. This is proving tricky based on angle and scaling issues.Because I know the center point coordinates and OSM provides the scaling values with the angle offset, it should be relatively straightforward to create the top left coordinate pair and then use the RasterGeoreferencer from there. However I am have trouble with the scaling and there's also some angle warping on the raster which makes the labels illegible. Is there a model that can be used within FME to fix scaling issues like these for OSM? I am guessing this is something to do with distance from the equator as Ireland is ~52degs where this sample is based and this would differ with examples closer to the equator, and so on.
Hi,How can I know what is the object type for an Ifc class instance.For example :Is this instance of IfcFlowTerminal is type of IfcOutletType or IfcAirTerminalType?Thank you
Hello,I am experiencing the problem during exporting to cesium 3d tiles format. On input I have OBJ meshed model, which I want to tile and then store as a Cesium 3D Tile b3dm.After my conversion I have tileset.json and only 1 data0.b3dm file. Cesium does not load it.
I think no but just to be sure: Is it possible to use a select statement on a geodatabase using the File Geodb Open API reader? I know the tooltip, just double checking with the community before going another route...
Hi,I have a CityGML file where a building has an outerBuildingInstallation. When I read the file with FME Reader the outerBuildingInstallation does not get the gml_parent_id but a generic one from the FME Reader. Without having the gml_parent_id (that is the ID of the building) I cannot merge the building with the outerBuilingInstallation.Why is that? Do I make mistake? I cant figure out why the gml_parent_id has got a value I cant use.Here is part of the CityGML file:<cityObjectMember> <bldg:Building gml:id="_22631"> <gen:stringAttribute name="citygrid_UnitID"> <gen:value>22631</gen:value> </gen:stringAttribute> <bldg:outerBuildingInstallation> <bldg:BuildingInstallation> <bldg:boundedBy> <bldg:RoofSurface> <gen:doubleAttribute name="Flaeche"> <gen:value>9.403696</gen:value> </gen:doubleAttribute> <gen:doubleAttribute name="Neigung"> <gen
Is it possible to write to MongoDB as an array datatype, either from an FME list or otherwise? Thanks!
I need to convert a large set of ESRI personal gdb (mdb) to file gdb. I can transform all feature dataset except some. I attach a sample with a feature dataset of this kind. My source personal gdb is data.mdb and DATA.XML is a workspace template exported from ArcMap 10.2 Desktop. I get and ArcObjects error number -2147216894.Is there a way to rewrite the grid size definition used in the template file? It seems that ArcMap always includes a gridsize tag in XML.Thanks in advance.
I know that there is currently a Bentley ProjectWise reader/writer in the works. Is there any plan to create a BlueCielo Meridian reader/writer as well? May be a difficult task, as many instances of Meridian are built on a proprietary object orient database called Hypertrieve. Maybe some clever user can come up with some custom transformers to access the Meridian api...
hi, I'm attempting to set up this example using my fme cloud instance (to later modify) https://knowledge.safe.com/articles/1117/data-distribution-with-web-maps.html. I'm stuck at the part where it talks about the token. dataDist.init({ server: "http://fmeserverurl", token: "a1b2c3d4e5f6a1b2c3d4e5f6" }); How do I generate the token in FME cloud?
Hi,My customer asked me about the difference between Esri Legacy SDE and Esri Geodb ArcSDE, when he wants to Reader SDE. Thanks,Danilo
Hello: Is there any way to take the results of a writer and use them within a second reader (within the same workbench) ? I have this scenario: Reader_1 - Transformers - Writer_1 Reader_2 - Transformers - Writer_2 Is there any way that Reader_2 can read the results produced by Writer_1 within the same workbench? Thanks,
Hello FME Users,Someone did make any Workspace that use the transformer GCMMessenger? If yes, it was easy to configuration on Google Cloud Message?Thanks in Advance,
Is there any chance to convert STL format(3d printing) from SHP file or DWG file
Hi all,Would anyone be able to suggest a workflow of exporting non-spatial records from wfs service to csv format? It is a big file with property title information (2+ million records), so I was thinking about narrowing the search by specifying Land District (GetFeature?). I did not work much with wfs services so simplified explanation would be great.Maybe someone from New Zealand with data.linz experience, especially their wfs services?Regards,Maksym
Hi,I am using HTTPCaller to read the content of this webpage https://ir.euroinvestor.com/Solutions/Shell/2088/miniquote2.aspx and try to retrieve the price but seem that HTTPCaller cannot retrieve it. It only able to retrieve <div class="price"> </div>and no price. Anyone know how to get the value if the webpage is dynamic?Thank you.
Hello, i try to create dynamic Excel data i a german environment and have a problem with the datatype.As you see fme detects the same value as utf-8 and 64 bit real. Real values generate correct output in excel as number but utf is put out as string with dot as decimal limitter.Is there any way to force the datatype to real?Hendrik
Hi allFME Information Edition: FME Database Edition Version: FME(R) 2017.0.0.1 (20170316 - Build 17271 - WIN64) I have a 3D buildings dataset in different formats .shp and .dgn. Buildings are built from individual shapes (walls, roof parts etc.) Normals are not consistent, some being LHR (left hand rule) and some RHR (right hand rule). Based on manual check I know which normals are LHR and which are RHR in a sample data (attached ).I also have a version of data in .sqlite format where all normals are RHR.I need to identify direction of each normal with FME, but OrientationExtractor doesn't provide consistent and correct results, comparing to the results of manual check. FME recognizes some LHR as RHR and opposite, fx, indicating that some of the shapes in .sqlite data are LHR.I also tried using Orienter to ensure that all Shapes are oriented one way, and then using Orientation Extractor again, but it provides wrong results again. Data -> OrientationExtractor (LHR, RHR) ->
Hi, I am getting a fatal error while translating a DGN file to DWG format.Object Data Writer: Failed to create object data table named 'XXX' in datasetA fatal error has occurred. Check the logfile above for detailsKindly help me to translate a DGN file to DWG along with symbology like Colors, line styles, Cells (in DGN) = block (In CAD).Thanks in advance.
Hi,I have a MapInfo file which I am trying to convert to an ESRI Shapefile. I can open the file using the MAPINFO reader in FME Data Inspector but when using the same reader in FME this returns the below error: Failed to open native MapInfo file 'Biological_Heritage_Sites_Distribution_2012.tab' could not be opened as a MapInfo dataset.<br>I have tried using both the 32-bit and 64-bit versions of FME but receive the same error in both. The TAB file has all file elements within the same folder (.TAB, .ID, .DBF, .MAP) I have also tried both the TAB and MITAB readers. Is there anything else you can advise to try? Thanks in advance for your help with this.Thanks, Charlie
I am trying to set a published workspace parameter(s) to automate an ETL routine that reads multiple tables from one PostGIS DB to incrementally update another single table in a separate PostGIS database. The simple workflow is something like this: a) Multiple tables from a PostGIS database are read and concatenated in another separate PostGIS database table representing a single canonical theme of these records. These themes classify certain field collection survey records into a meaningful, single common theme. b) The second database does have a function which writes the id, feature_type and a run_date to an etl_log table each time the routine processes. I'd like to use this automated output as an input value each time an update routine is called on the server. I've tried to work in a SQL SELECT statement that filters only those records that have a created_at or updated_at attribute greater than (or after) the run_date and label those as "good", passing through to t
Hi,I have a IFC file that I want to use for a transformation. It has correct latitude and longitude values, but missing elevation values. I wanted to update the elevation value by using the AttributeValueMapper on the IFCSite class and giving it a fixed value for the RefElevation attribute. But strangely, after the transformation, not only the value for RefElevation is missing, but the values for latitude and longitude are gone, too. What am I doing wrong? I would be grateful for any help you are able to provide.
Hi, I tranform some rasters from a certain source format into GeoTIFF files with a jpeg compression (75). But by doing this, the background values are not anymore 0,0,0. Resulting in a series of (almost) black pixels at the border of the image. When writing to a GeoTIFF without any compression the 0,0,0 value of the complete border area is maintained and the background can be made transparant. Is there a way to use the compression and to keep the complete border area black (0,0,0)? Secondly, why is it not possible to use jpeg compression and the BigTIFF option at the same time in the writer? thx
Good morning!Today my FME Desktop 2017.0 has given me the following error while running a Workspace:It doesn't start at all. Not even the log is written.This is a workflow to update several metadata XML files. For the ID of those metadata I have used "fme_(type_of_metadata)". For the ATOM service and the Dataset metadata is working fine, but with the view service metadata always gives me the error from the pic.If I change the metadata ID to something else, the workspace runs without issue. So it seems I have hit some restricted words for the "metadat_id" variable value.Is there any place in the documentation where I could check which words we are forbidden to use?Thanks!