Using readers and writers to extract and load data.
Recently active
Hi I am trying to set up the trainingdatabase and are using the correct credentials that is specified in course. host: postgis.train.safe.com, port 5432, DB fmedata User fmedata PW fmedata. When test i got no answer from server. Tested in cmd and it seems to be down?..
I'm using a geospatial pdf writer to export a map that was styled with a PDFPageFormatter. The PDF opens correctly in Adobe reader, but not in a webbrowser (Chrome/Firefox). After removing the layer by flattening the pdf (using an online tool or Ghostscript) opening the PDF in a webbrowser is possible. Is there a possibility in FME to flatten the PDF, the PDF-writer always demands a layer name... So writing without creating a layer is impossible.
Hi Community, How can I read / expose the element information from a DGN file? Need to be able to read General > Description as the following screenshot shows:I have already played around with the Reader DGN parameters (e.g. read tag attributes, Read XAttributes, etc) with no success. Any help would be much appreciated. Thank
I have data in S57 format coming from the UK Hydrographic Office (UKHO) which I need to read into FME.When I try to read them in I get the following error message: DE4OS09G.000 isn't an S-57 data file, or catalog.Failed to obtain any schemas from reader 'S57' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. I tried to read them with FME 2022.0.0.2 (20220518 - Build 22343 - WIN64), and as I point out in the question, the access to the files is restricted. There is at least an UPN (User Permit Number) needed to read the data. I do have one, but no possibility in FME to make use of it.
I've got a set of polygons from a PostGis DB and want to write them to DGN. On one level, I've got the polygons and on another level, named label, I want to put out a text string from an attribute. Some of the polygons have more than one entry here, which leads to stacked texts - I've used a centerpoint replacer, labelpointreplacer and dgnstyler. I guess when only having two or three entries, I could solve the problem by subtracting a fixed value from "igds_insertion_y", but I don't know how many entries will be there in advance and already encountered some cases where a polygon had 40 to 50 entries I have to write one below the other.
I am reading some data from a database in, using the DGNStyler I set the color type to color index, define the color index; and set the line style with weight and style.Than I am forcing all data through a 2DForcer and finally I am using a DGNV8 writer to write to disk. I guess the problem starts with me not being used to DGN and/or the viewer, but essentially I am not getting the styles I defined.As you can see, the color index is the same in both viewers, but the color shown differ from each other (The left should be a mirror of the right.). Also, the level weight should be 3, and was also as such defined in the DGNStyler.Overrides have I defined within the writer:but the overrides are entirely neglected. Finally, there is the thing with 3D vs 2D. I thought my file is generated as a 3D file because of my data and added the 2DForcer. However, that does not change anything on the output. Maybe that's just me not knowing my ways around in the viewer... However, I have to get the sty
I would like to know what datasets we use. For this I would like to read the Arcgis Pro project files (.aprx). Does anyone know what encoding is used for this file type?
when I write cesium 3dtiles ,then got a tileset.json 。The boundingVolume of the tile is smaller than the content boundingVolume 。And the geometricError of the tile almost is same 。
Hi all,We're attempting to use S3Uploader in FME 2015.1.1 and FME 2016.1 to upload data to a bucket in ap-southeast-2 (Sydney), but we're receiving an error from AWS that seems to indicate that FME is not uploading to ap-southeast-2.“The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint. (Service: Amazon S3; Status Code: 301; Error Code: PermanentRedirect;”Googling this error results in many bug reports from other software using AWS where they have forgotten to specify an AWS region, and it's defaulted to a different region than where their bucket resides.According to FME's documentation here, our AWS region should be automatically detected."As of build 2015.1.1, all AWS transformers support multiple regions. You don't have to do anything we automatically detect the region."We've been unable to find any further information about how the automatic detection works, or how
Hi All, I'm trying to create DWG leaders based on the following post: https://community.safe.com/s/question/0D54Q000080hahzSAA/how-creat-autocadleaderbut couldn't get to work. I use autocad_leader settings as the post suggestsbut the leaders aren't coming through. Could anyone point me in the right direction on how to get the autocad_entity to work? I'm attaching a few screenshots of the workflow as well as the parameters. Thanks All :)
I want to put the 3D pipe on a straight line, the PipeReplacer has thickness, I want to replace it with my own model, is there a good way, thank you,
This is the error I'm getting- ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'Tracklogs'. The error code from the server was '1000' and the message was: 'Data is Null. This method or property cannot be called on Null values.'. The data has run successfully through the workspace until I try to write into the existing feature service in ArcGIS Online. As a side note, I made sure to Import Feature Types... The table looks populated to me. There aren't any empty rows, however there are some empty fields. I didn't think this would make the workspace abort though. In the visual preview, I can see the geometry has populated too. Thank you in advance for your help.
HiI am migrating data from an Oracle Spatial database to PostGIS with FME.One table has a 3D geometry column. The features are read correctly as 3D from Oracle, in the visual preview graphics view the are shown under "3D". In the PostGIS table the features are only 2D, if I query the geometry column as text it contains only POINT(2532341.58213 1155047.32385) geometries.Is there a was to force the writer to write 3D points?Thanks,Jean-Marc
Hi, I have a shp file I convert and style to a Mapinfo Tab file. I now want to add the below metadata into the Tab file to set up a hotlink. I am not sure how I use these attributes, mapinfo_metadata{}.name and mapinfo_metadata{}.value to write to the Tab file, How do I do it? begin_metadata"\\ActiveObject" = """\\ActiveObject\\Expr" = """https://aims3d.geomatic.com.au/#/home?username=username&password=Password&PanoID=""+Pan_ID+"" """"\\ActiveObject\\Mode" = "HOTLINK_MODE_BOTH""\\ActiveObject\\Relative" = "FALSE""\\ActiveObject\\Enabled" = "TRUE""\\ActiveObject\\Alias" = """Click to view Km_Post Images"""end_metadata RegardsAndrew
I want to take Revit file to QGIS via FME converter.But the coordinate system doesn't fit.So I want to find a solution. Thank you.
Hi,I'm converting different shapefiles to 1 DWG. How can I set the draw order of the layers in Autocad automatically with FME?Thanks!Regards,Pieter
@Hans van der Maarel @david_r @chrisatsafe @safesoftware safesoftware
I have a large number of text files of traffic count locations that contain both header information with necessary attribute fields and 2 fixed width sets of data that I also need to bring in as attributes. I am looking to ultimately create a table where the info from each text file is one row/feature in the table so I can join it to an existing point feature class with the Reference Number being the join field. I could do multiple tables if I have to also. I can't seem to figure out a good way to get both the Header attributes as well as the fixed width attributes. A sample of one of the text files:They are actually .tam, .tpm and .tms files (no idea what those file formats actually are and google was not really any help) but they can be read as .txt files. I have attached one that I saved as a .txt as a sample
Supports geolocation the new application for Android?
At first you get the warning: 2022-06-08 09:00:12| 1.4| 0.0|INFORM|Creating reader for format: Oracle Spatial Object2022-06-08 09:00:12| 1.5| 0.0|INFORM|Performing query against ORACLE_SPATIAL dataset ` ----'2022-06-08 09:00:12| 1.5| 0.0|INFORM|ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `----', user name `----, password `***'2022-06-08 09:00:12| 1.5| 0.0|INFORM|ORACLE Reader: Using Rich geometry.2022-06-08 09:00:12| 1.5| 0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll'2022-06-08 09:00:12| 1.6| 0.1|INFORM|Environment variable ORACLE_HOME is not set.2022-06-08 09:00:12| 1.6| 0.0|INFORM|Connecting to ORACLE database `----' with user name of `----' and password of `***'2022-06-08 09:00:13| 1.6| 0.1|WARN |Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`----', userName=`---
Hello,I have a georeferenced dwg file with lines, polygons and text that I'd like to convert to kml for view in Google Earth complete with the AutoCAD layers. I have been successful with creating a KML file that opens in Google Earth but still some problems. when viewing in FME Inspector everything except the text shows and the layers are missing. When I open the file in Google Earth only the points show and on the Places bar each object is shown on a long list, I want to see the layers like in Autocad and do not want to see the individual objetcsLooks very promising otherwise.Thanks
I have been trying to change a file extension from .bil into .flt based off this link https://community.safe.com/s/question/0D54Q000080hEslSAE/how-to-change-filename-extension-via-fmeBut I cant get the FeatureMerged to merge what am doing wrong?There will be other files and different file types in the same Folder so not sure yet, if this process/workflow will change the other files as this would not be desired.But for now I'm just trying to get the FeatureMerger to work.
80192022-6-6 16:37:01 | Unable to flush the cursor for the feature class 'BCNCAR' because the spatial index is too small. Increase the spatial index on 'BCNCAR' and retry80202022-6-6 16:37:01 | GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details Weekly we download all .000 Electronic Charts, run them through a workbench which writes to Oracle. The workbench runs but throws this errors, so were not getting as many records as we should. Attached is the workbench. FME Server 2021.2.5Build 21816 - win64Oracle 19CArcmap 10.8.1 with 64 geoprocessing extension
Recently updated to 2022 and can no longer see a table through a portal connection.I can still see the other three feature classes but not the table. Is this a bug in the new version of SDE or did something change?
*** Will be cross-posting here and on ESRI community/geonet.*** I have an FME process that uses the SPROC's for versioned editing with the .evw views inside an FME SQL Executor...-- Change to the FME version EXEC sde.set_current_version 'myFMEversion';EXEC sde.edit_version 'myFMEversion', 1; -- DO MY THING HEREEXEC sde.edit_version 'myFMEversion', 2; This has been working great in one database and running in FME Server under a service account. Now, when I try and use it in another database, after creating a 'Public' version called 'myFMEversion', I can run it in FME Desktop successfully where I'm Admin on that DB. But when I run it in server which uses the service account, it fails with this error:360 | Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `-- Change to the FME version 361 | EXEC dbo.set_current_version 'myFMEversion''. Provider error `(-2147217900) Version myFMEversion not found.' 362 | A fatal error has occurred. C