Using readers and writers to extract and load data.
Recently active
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?
I'm probably wrong somewhere
I have a task where I need to extract data from a database and save it as a csv in SharePoint I had hoped to b able to specified the path to the SharePoint folder in the csv writer, but this does not seem to work. The error I get is CSV writer: Failed to open file 'HTTP:\\\\projectzone.tnad.tasnetworks.com.au\\business-projects\\iap\\TE\\HVDC Cable Specifications\\SATVUE_99021037_2021_08.csv' for writing. Please ensure that you have sufficient privileges to write this file. If the file already exists, please ensure it is not open in another application I am using FME Server and the FME Server service account has permission to write to this location.
HiI generated a CityGML model in LOD 4 with its respective appearance using AppearanceSetter. I am trying to load the model to Cesium Ion but it loads without appearance. Can anyone help me with some idea to solve this issue.
I have a dwg-file with multiple linetypes (dashed, dash-dot, solid).The Option in PDFStyler allows me to define only one "array" or use a parameter.Is it possible to write multiple "Line Dash Arrays", or ca i put only one in a pdf?Who can help me?
Is there any way to read the smallworld internal features in EDO in GESW 4. X.
It seems straightforward enough using the PointOnRasterValueExtractor. The problem is it is only grabbing one value and putting that in all the points. I am guessing that the secondary files with the tiff may hold that 'value,' but I am unsure. The last screenshot shows the data doing it the slow way through ESRI's geoprocessing tools. Any help would be appreciated.
Dear FME community, Within a workspace that uses a specific view for reading a revit file, we have found that not all feature types that are present within the specified view are read by FME server. On desktop (using the same version and same workspace) it does automatically read all feature types. At first we tried leaving the 'feature types to read' option empty, which made this difference visible within the log and output files. Secondly we tried adding all possible feature types to read to the reader, however this also did not fix the issue. Does anyone else have a similar problem and a possible solution? Maybe the cache is used differently on desktop vs server? Added some log images of the feature types read by desktop (6 feature types read) and server (stops at 3th feature type read). server: desktop: Edit: After adding a featureholder after the readers, all feature types are read by both desktop and server.
I'm having a hard time using the WFS XML filter. I surely built a working workbench before so I am sure this worked. The only thing I want is adding a boundingbox in the WFS (2.0.0) request. I open the XML Filter setting and entered: bbox=48187,407743,148934,408593 The workbench fails. Log: <ows:ExceptionReport version="2.0.0" xsi:schemaLocation="http://www.opengis.net/ows/1.1 http://geodata.nationaalgeoregister.nl/schemas/ows/1.1.0/owsAll.xsd"><ows:Exception exceptionCode="XML getFeature request SAX parsing error" locator="org.vfny.geoserver.util.requests.readers.XmlRequestReader"><ows:ExceptionText>org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog. Content is not allowed in prolog.</ows:ExceptionText></ows:Exception></ows:ExceptionReport> I look up the URL in the log and there it is: FME prefixed my filter with "FILTER=" FILTER=bbox=48187,407743,148934,408593 When I copy paste the url from the log to