Data

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

I am new to FME and this is my first post. I am trying to create a workbench that will search through hundreds of windows folders and convert pdf to tiff images. I have tried the ImageRasterizer with no luck. Is this even possible? Thank You

Dear All,  I am trying to write some features in a versioned featureclass. Instead of writing it directly to the SDE.Default,I have created version in ArcGIS and I have set the FME output to write to that version and I have made sure you have Versioning set as your Transaction Type under Advanced settings.I have Run the FME workspace and it has come up with below error message.  I am not sure why this has come up. Please let me know if you are aware of this.  Error message:   An error occurred while attempting to store a row into the table 'ARCFM.Lamp_LV'. The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {}  The Zone of the assembly that failed was: MyComputer log4net:ERROR XmlHierarchyConfigurator: Appender named [MinerEventLogAppender] not found. log4net:ERROR XmlHierarchyConfigurator: Could not create Appender [Log4NetEventLogAppender] of type [log4net.Appender.EventLogAppender]. Reported error follows. System.Security.Securit

Is there a way (or a script) that can turn off AUs when writing to SDE tables? I have tried the solutions from the below question and they didnt work for me:https://knowledge.safe.com/questions/95896/how-to-turn-off-arcfm-auto-updaters-using-pythonca.htmlI am looking to do this because I get an error when writing to the table from FME server but I dont get an error when running from FME Desktop. I am just trying to try any solution I can at this point.Thanks.

I'm really struggling with the string functions in FME at the moment. I have a workbench reading JSON features from an API and I have one attribute where the results are in a list. The JSON extractor results the attributes like this:  ["Medium"] Or if there are multiple values, like so:["Easy","Advanced"] I want the results to be: MediumIntermediate,Easy I want to remove the brackets and quotes using a single transformer and can't figure out the formatting for my life! Currently I have 3 separate "string replacers", each one removing a single character, but there must be a better way...I don't mind using a REGEX expression if someone can figure it out. I'm also open to using a different type of JSON query to extract these values? If there's a way to get the attributes without the brackets and quotes? I also tried using the string pair replacer but I constantly get an error, and I can't seem to format it properly. I wish yo