Using readers and writers to extract and load data.
Recently active
I am trying to use DatabaseUpdater but it appears not to work with a versioned SDE Table. Is there a work-a-round?
How can I convert raster boundary to polygon? Raster Domain is equivalent tool in ArcGIS / Pro.
Can FME desktop call Open API data after receiving coordinate information from a file? Basically the client will supply a lat/long from CSV file and then we want use those coordinates to get data from our API source. Request format: https://<apiURL>/data/lat={lat}&lon={lon}&exclude={part}&appid=[API KEY]
Attached my ifc file. I changed the ending from ifc to txt.
I have CAD file with nomber of layers, each layer represent landuse, i want to knew what transformer i should use to convert the CAD file into GIS personal database , the output to be one feature class and landuse use to be saved in one field.
Hi,Just wondering if it is possible to transfer photos from one AGOL feature layer to another using a unique ID - maybe via a join or something similar?I can read features and their attachments using the AGOL Feature Service Reader, join them up with the destination dataset, but I cannot write the photo attachments using the AGOL Feature Service Writer.The geometry and attributes are written but not the photos.Thanks,
Hello,I have about 5000 DWG files that have a lot of excess layers that have no element. I would like to use FME to delete or clean up the layers that have no element. I would be grateful if you could help me, which transformations can help me with this.thank you in advance
HiI've set up a Workspace that does the following; Dissolves a MapInfo Polygon layer, adds a Counter and Attribute Creator then produces a 2d Oriented Bounding Box (and saves a MapInfo table) Chops the Bounding Box including the Longest and Shortest values (and saves a MapInfo table as well), adds aother Counter then a Sorter & Sampler and then saves the result as a MapInfo table with the longest line from the Chopped table In total there are 197 polygons in the source table which becomes 13 Groups when dissolved. However, the final Table containing the Longest line for each Group is incorrect as some of the lines are the shortest ones. There are the correct number of lines though (13). I've attached the FME workspace and a zip file with the source MapInfo table. If anyone would be interested to run the Workspace and see where i've gone wrong. I've tried using other columns within the Sorter and Sampler transformers but still get the same result. It may be the Sorte
I want to write a DWG containing a mesh (it is one feature in FME), but it always gets split up into strips with a specific number of vertices like there is a limit (see image). Is there anything I can do about it or is it just a restriction by the DWG format? I'm not very familiar with the DWG datatype, so maybe there is another autocad entity that is better suited?
Hi, I have a jp2000 file and a j2w file with the georeferencing, but I would like to have the georeferencing at the jp2000 header. Is there any way to do that? Thanks!
I'm copying PDF files from a source folder to a destination folder. The destination folder is named with today's date (.../outgoing/October-11-2021/).I used the AttributeCreator to create and format the date attribute called "Date_today" and set filecopy_dest_dataset to "Date_today".This all works well, the PDF's are copied into the date folder, however, I also get another empty date folder created in the folder that the workbench is in.Fanout is off. Any ideas how I can stop this extra folder being created?
Need to understand how to avoid error "Table is already locked" while doing transforming data into ArcGIS enterprise nonversioned geodatabase on SDE.DEFAULT version when someone is connected through either ArcGIS Pro or feature services. When close the ArcGIS Pro session, FME transformation works fine. When schedule the FME transformation using FME Server, users must not to be disconnected before transferring the scheduled workbench. Please advise.
Hi,I want to read with FME the data from a database oracle.I can connect FME to the database but I am not able to read the linear objects. I use the ORACLE_SPATIAL reader. I have the following message : “Error - Cannot have NULL value for 'z coordinate'” Do I have to parametrize FME to be able to read the null value of Z ?Find attached the text.log oracle_spatial.zipThanks,
I have converted a large geoJson into cesium 3d tiles -- wonderful... but not when enabling terrain -- tiles are partially visible obviously due to elevation. Is there something available in FME to consider the terrain?
I have received an 3D PDF and would like to extract attribute information. It is an export from Synchro PRO 4D. If there is an other possibility to exchange information from Synchro PRO 4D that would also be an option.
I have successfully written the data to an OGC GeoPackage (over 7.6GB) I dont believe any of the shapefiles would have exceeded 2GB Largest shapefiles wrote perfectly 174,649KBJust to add, I have in testing it cached the workbench and all translators have data passing through, with even the Log, logging the number of features written, only the outputs are blank
I have path_windows for all dwgs in a folder. I could get AutoCAD file OR Civil3D files, I won't know that. How would I get results which I canIs it Civil3D or AutocadGet version for Civil3D. With the top autocad feature reader I figured out how to get the autocad version already, even when I have 2 files with a civil 3d features(these are now included in my tests but should be excluded from my result). I want to only get one result per file, autocad or civil AND the version per type. I tried many things but I cannot find a way to get "there are ciivl these are autocad" not all Civil has pipes network for example so the sum of civil types isnt a guarnateed solution.Current results: Top Feature Reader is AutoCADthe Bottom is Civil3D results I want my current AutoCAD version results(the 2 marked read have pipe network so they should be marked as missing)
I am using the ACAD writer to convert GeoJSON to a CAD file. The issue I'm having is the ACAD Writer seems to be creating a bunch of empty layers named d_y_00, d_y_01, d_y_02 etc. that aren't in the GeoJSON I'm passing. The layers that are in the GeoJSON are written to the CAD file and work perfectly. The issues is I can't seem to figure out where these layers are coming from or how to remove them.
Hi, is it possible that FME does not honour geography types for SnowFlake? SnowFlake should be able to store geometry as WKT / WKB / EWKT / EWKB or GeoJSON. Currently (FME(R) 2020.2.3.0 (20210129 - Build 20820 - WIN64) only GeoJSON seems to be supported. When I try to specify a different format, FME keeps on writing GeoJSON format geometry.I tried specify it in the JDBC connection parameter GEOGRAPHY_OUTPUT_FORMATI tried specify it in a pre-write SQL statement ALTER SESSION SET GEOGRAPHY_OUTPUT_FORMAT='WKT'Any ideas? Or file a support case? Love, Helmoet.
In writing DXF when lines are output I use autocad_width and autocad_linetype in combination with a DXF Template file in order to get the desired output styling for 2D lines. For 3D lines this doesn't work and 3D lines are output in some default manner. As I am not an expert with DXF/DWG and only create such files with FME could somebody help me out with the following questions:Is it possible to style 3D lines in any way ? Thickness, dashed, etc.If NOT: what do people usually do if 2D and 3D lines are coexistent and should be combined in the same output file, while the 2D visual appearance matters and should be used also for 3D lines? At the moment the only way to cope with 3D styling deficiencies seems to be double 3D line layers, in order to have a 2D and seperate 3D copy force one layer to 2D and style it as usualoutput the redundant 3D layer as is in order to keep the 3D information Thanks for any helpMichael
FME is writing a the geometry column as:GEOMETRYCOLLECTION (GEOMETRYCOLLECTION EMPTY, POINT (Y X)) When it should be outputting as POINT (Y X) Is there a way to correct this?
I get this error while creating PostGIS reader in both 2015 and 2017.1 FME versions.Please advise for the below error.ERROR |Error executing SQL command ('select version(), postgis_version()'): 'ERROR: function postgis_version() does not existLINE 1: select version(), postgis_version() ^HINT: No function matches the given name and argument types. You might need t...'2018-06-04 20:46:28| 2.4| 0.0|WARN |Error retrieving version for PostgreSQL database2018-06-04 20:46:28| 2.4| 0.0|INFORM|Successfully closed POSTGIS database reader2018-06-04 20:46:28| 2.4| 0.0|ERROR |Reader failed in open() callTagging in @takashi, @erik_jan, @TiaAtSafe, @Mark2AtSafe, @RylanAtSafe, @jlutherthomas
To all Autodesk'ler,I have a DWT-file, which is noch an ordinary Autodesk template file, but an application module. I can open and read it with the Autodesk's 'Infractruscture Admin'. Editing it possible with 'Map3D', where you can see the representation definitions. Usually you are hosting your data in an oracle database and holding the representation in LAYER-files. With a DWT you now have everything in one file.I already tried to open this file with the inspector - no success.Does anyone has experience with this? Cheers,Maria
When using the POD writer I get a warning message "POD writer: Compression tolerance '0.001' is too small for the point cloud coordinates and may produce poor results. Adjusting compression tolerance to '1'
I am reading in a complex CAD file from our engineering team. The DGN has multiple reference files, but the only information I need is the annotation layer. Specifically, the callout boxes and the leading arrows. When I read in the DGN as a Microstation v8 file in FME Data Inspector, the callout boxes are shifted in the wrong spot and the arrows are missing. Any ideas of what could be wrong and how to fix it?