Data

Hi I'm wondering if anyone has encountered this - I'm looking to read some data held in views in an Oracle workspace. The views are generated by Oracle Workspace Manager (viewname_CONF for conflicts seems the naming convention). I can read user-generated views using the Oracle Spatial Reader, but I cannot seem to read the workspacemanager-generated views using the Reader. I can access the data in the workspacemanager-generated views using SQLCreator transformer, but then I have the overhead of exposing all the attributes (which I can probably automate). So FME can access the data as the user I'm connecting as, but seems to ignore these views. Has anyone else encountered this? Is there a way to access them via Reader? some setting I'm missing?? Thanks Mary

I'm creating a SQLite Tilecache via the WebMapTiler, with PNG blobs, and would like to use PNG Optimization. This seems to be available in the PNGRaster writer, but I'm not using the PNGraster writer, I'm using the SQLite writer. So, is there any way I can pull that piece of code or is there another transformer I could use to do the same job of PNG Optimization?

Hello, is there a way to access a value of GML xlink:role property? I can access other xlink properties such as href and title but not this one. Thanks for suggestions.

When using the geodatabase SDE reader (ESRI) or shapefile reader, the geometry of the polygon feature class does not appear correctly. Recent edits to the SDE data (v10.3.1) are not reflected . In ArcCatalog and ArcGIS on the same machine the data appears correctly however the data is not displayed the same in FME Desktop or Data Inspector. (Note: SDE geodatabase is compressed nightly). I am running FME v2017.1.

Is it possible to write annotation features to an ArcGIS SDE annotation feature class without a spatial index being created in FME? I am writing annotation features to ArcGIS SDE on SQL Server using the GEODATABASE_SDE writer. I delete the spatial index on the target annotation feature class before running FME. I do not want a spatial index created on the feature class, but FME appears to always be creating one. Referencing this article I have tried the below FME and SDE settings, but the result is always the same. Environment: FME 2018.0.1.0 (20180518 - Build 18310 - WIN32) ArcGIS Desktop 10.2.1 ArcSDE 10.2.1 SQL Server 2014 Feature Type Grid 1 Value SDE LOAD_ONLY Mode Spatial Index Createdunset/blankYesYes0Yes Yes-1Yes Yes unset/blankNoYes 0 No Yes -1 No Yes

I currently struggling to get the wanted attribute output in my Writer(FGDB). This is a brief of the current work-space. Reader (Excel Spreadsheet with file-paths) into a Feature Reader (using User Parameters created from the Excel) -Then into A Feature Writer (FGDB using user parameters from the Excel). This currently runs and works however the features created only contains the data/attributes from excel file, I want only the attributes from the feature-class. When Inspecting the Feature reader there is the attributes from the loaded features but I cant interact with them using any known transformers atm.Any suggestions?

BADNEWS: TEST clause must be specified for factory TestFactory (fcttest.cpp:298)

Hi, i'm new to FME. When I add a reader (Oracle Spatial Object), fill in the right parameters and click OK the translation log says: Error running translation (immediately). I do this in Citrix. When I do this in FME on a Windows 2012 Server de translation works fine. What could be the problem? Thanx, Erwin

I've got in the log the message about a Corrupt Shape file either because the geometry is badly created or because the shapefile don't have any features in, its empty. What should be the best way to put a value into an attribute when this kind of issue occurs?

I have added the _alias suffix to my field (HS2_SuitabilityCode) that i want to change the alias of to (HS2 Suitability Code) but when i write out to GDB the alias does not update.

I have setup the diminfo coordinates, i have created a spatial index and still I am unable to view the oracle table in arcgis. The table is in oracle with geometry and correct diminfo, why can't i see the table in arcgis.

I am reading a google sheet and using emailer transformer to send email, everything work good on the desktop, but when published on the server it giving this error Google Sheets: A refresh token is required in order to access this service I did get the Client ID and the secret key from google consol, but still giving me the same error any Idea ?

I have a csv separated by semicolon. Some lines have too many semicolons (bad data). To clean up the data I have read the csv with a Text File Reader to read line-by-line and used an AttributeCreator to create an attribute for the number of semicolons in each line. Then I followed that up with a Tester to retrieve the lines with the correct number of semicolons (clean data). Now I have this text line data and need to write back to a csv. I cannot figure out how to write to a csv from the text line data.

Howdy, This question pertains to working with file name/feature class name & name alias for shape files & file geodatabase feature classes. My Question is: Where in FME can I modify the Name alias when writing to a shape file or file geodatabase feature class? I am not seeing this in the parameters or the Format Attributes. Note: This is not a question about a geodatabase field name alias, help on that can be found here: https://knowledge.safe.com/content/kbentry/22423/working-with-geodatabase-field-aliases.html How this became an issue for me: Working with FME 2018.1 I noticed that when working in a workbench I noticed that an issue pops up when I get lazy and instead of adding a new writer feature type I do a quick copy and paste to create a new writer feature type that I then rename (Parameters > General > Feature Class or Table Name). When that pasted/renamed feature class is output the name from the parent/copied writer feature type is written to the name alias. An example use cas

Hi all, this may be quite similar to this Previous Question but I am just seeing if there is any update. The problem is trying to use the MongoDB reader to access a Replica set held in AWS. Outside of FME you would connect to the database using the following address (with username and password removed and some *): mongodb://user:pass@pro**-shard-00-00-lw***.mongodb.net:27017,pro**-shard-00-01-lw***.mongodb.net:27017,pro**-shard-00-02-lw***.mongodb.net:27017/admin?readPreference=primary&ssl;=true&replicaSet;=PROD0-shard-0 FME seems happy to connect to a similar arrangement if the Replica Set is held in a MongoDB on an internal server. But not so happy on an external encrypted server. Does anybody know whether it is possible? Thanks Matt

Hi everyone, I'm currently doing my master thesis and transforming some data into IFC file... does anyone know how to apply the color parameters to an object ? when I use the appearanceSetter, everything goes well and the result is ok in the inspector... but it seems that the Ifc Writer doesn't know how to deal with this information because in the BIM Vision viewer the colors doesn't appears and if I check my IFC file, there is no line with "IFCSURFACESTYLERENDERING" which should exist to apply a color to an object

I am wondering if there is any way to overcome the 7 concurrent FME process limitation of WorkspaceRunner? I am processing 2800 LAS files into DEM's (using a slightly modified version of the excellent example here) using a WorkspaceRunner being fed by a Directory and File Pathnames reader). Our processing workstation has 16 cores and 64 gigs of ram... 7 concurrent instances of this workbench is only utilizing about 35-40% of my system resources, and it takes almost a day to get through all my files. Is there any way (excluding upgrading to FME server for something that really doesn't need Server's capabilites) to get this running on more cores (or can someone help me figure out how to run it in a highly parallel fashion)?Thanks!

I am am trying to convert a IFC-file into a CityGML-file. For inspiration I am relying heavily on the intermediate guide for BIM to gis. Now when I am trying to convert the IFCDoors entities into CityGML doors i get the following error: CityGML Writer: The 'IFMEMultiCurve' geometry is invalid for the 'lod4MultiSurface' citygml_lod_name, valid geometries for 'lod4MultiSurface' are: {IFMEMultiSurface}, convertible geometries are {IFMETriangleFan, IFMEAggregate, IFMECompositeSurface, IFMEFace, IFMEMesh, IFMEDonut, IFMETriangleStrip, IFMERectangleFace, IFMEBox, IFMEBRepSolid, IFMEExtrusion, IFMEMultiSolid, IFMEMultiArea, IFMEEllipse, IFMEPolygon}.Storing feature(s) to FME feature store file `U:\Exjobb\FME BIMtoGIS my own\NyvångToCityGMLintermediat_log.ffs'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Door'Attribute(encoded: utf-8) : `GlobalId' has value `02R5wDVnfBGx4r_HlUhMUt'Attribute(encoded: utf-8) : `Name' has value `Door Opening SE:1010x210

Hi, I need to generate a single TIF file from multiple DTM files. Any advise please. Thank you

Hi all, This works in SQL Developer. Why does this not work in a SQL Executor/Creator? select to_date(736845 + to_char(to_date ('02-01-0001'),'J'),'J') t1,to_char(to_date ('02-01-0001'),'J') t0from dualoutput:T1 T031-05-18 1721425 Fme executor insists `ORA-01843: not a valid month' which is totaly not true! It appears that the 'J', julian format is not recognised. Is this a error or am i missing something? Don't suggest out of sql solutions, i wan't it to be done in the executor. Be aware i will issue demerits !! ;) SQL answers required. Greets an txia for your answers.

Hello everybody, I have met troubles with values in igds_snappable attribute of cells. In my source datafile (v7), insert point of cell is snappable, but elements of cell are not. When I open datafile in FME Data Inspector, it shows me that insert point and all elements are not snappable. If I change value of igds_snappable in Microstation for just 2 elements of cell, the insert point in FME Data Inspector is snappable, interesting... Is it bug or not? Have You ever met the same problem? I´m using FME Desktop 2017.1.2.1 Thank You so much! Lubo

Hi, I'm after creating a series of profiles / cross-sections using a mapinfo table containing the lines to be driven through a DEM of the LAS point cloud. The output txt file should contain x, y, z, and chainage (from the zero point of the profile, (which should increase at 0.5m spacing)), and profile_ID (derived from the mapinfo table). Any guidance on how to achieve this would be much apprieciated.

Hello beautifull people, i have to make onversion from buildings from CityGML lod2 to IFC . but i get a the end of conversion in the Data inspector NO Geometry !!! i need your help how can i do it and why does not go ? Thank you

In the doc: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/citygml/citygml.htm?Highlight=citygml The part where the limitations are listed: The CityGML reader reads all parts of the Thematic and Appearance CityGML models with the exception of the Digital Terrain Models (DTMs) ImplicitGeometry and xlink:href resolution. is not really clear. Is there a comma after '(DTMs)'? Or do ImplicitGeometry are not read? (They are, I just tested!). Same for XLinks, they seem to be resolved (at least those internal to the file). So I'd like to know the limitations, if any.

Hello I am Looking to export the Geodatabase schema ( manay tables) without the data to an excel sheet column 1: table name Column2: attribute name Column 3: attribute type Column 4:width