Data

Hi,I am trying to build a KMLtour in FME so I can use it in Google earth. However, it is not working as I wish it did. First of all, from 3rd perspective it moves with a blink of an eye to the start position. I would like it to smoothly move to the start position. And secondly, it is "jumping" up and down, back and forth throughout the whole tour. What I really would like the KMLtourbuilder to create is to run it smoothly from start position to end position.Can someone please help me with this task? I will attach all my work in a zipfile and also the kml tour builder that may be open through google earth.

This is what I get when I write to a Spatialite database...: I don't know what's going on.Well it says there is no geometry mapping, but how is that? No geometry mapping entry found for 'fme_varchar(200)' in metafile 'C:\\Program Files\\FME2019\\metafile\\SPATIALITE.fmf'. Please visit http://www.safe.com/supportWorker 11036 > No geometry mapping entry found for 'fme_varchar(200)' in metafile 'C:\\Program Files\\FME2019\\metafile\\SPATIALITE.fmf'. Please visit http://www.safe.com/support

I have a obj file (200MB) and want to convert to cesium 3D tile. The FME converter is just change the format but i would like to apply LOD for the final 3D tile. is there any options in FME to provide tis function?

Howdy,Working with the Excel Writer, I am wondering if there is a way to have a sheet name of 31 characters and a named range of an additional 10-20 characters? A combined 31 characters does not permit very descriptive naming of sheet names/named ranges, if I'm completely missing something or someone has a suggestion for a work around I'd love to hear it. Background The writer’s General Parameters Sheet Name text box is limited to 31 characters, which makes sense since this is the designed maximum length for a sheet name. Reading the FME tutorial "Using a Template File when Writing Excel Data" there is no mention of character limitations.FME's character limitation becomes an issue when writing to a named range, both the sheet name and named range are entered into the the same text box separated by a "/". Due to this, where the combined total characters exceed 31 the extra is trimmed off (e.g. sheet name & named range of "DataSummary_FMEoutput/

Like a poster who previously posted a similar question moving from 2015 -> 2016My WFS reader has suddenly stopped working in 2019 moving from 2016.I get the following error message Sending HTTP 'GET' request to 'http://spatial.bom.gov.au:80/cgi-bin/mapserver/users/bomw0296/wxs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=IDQ65470_wtr_lvl&NAMESPACE=xmlns%28%3Dhttp%3A%2F%2Fwww.opengis.net%2Fwfs%29&MAXFEATURES=1000', waiting for response ...Parsing XML document 'http://spatial.bom.gov.au:80/cgi-bin/mapserver/users/bomw0296/wxs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=IDQ65470_wtr_lvl&NAMESPACE=xmlns%28%3Dhttp%3A%2F%2Fwww.opengis.net%2Fwfs%29&MAXFEATURES=1000'HTTP transfer error: 'Couldn't connect to server'XML Parser error: 'Error in input dataset:'http://spatial.bom.gov.au:80/cgi-bin/mapserver/users/bomw0296/wxs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=IDQ65470_wtr_lvl&NAMESPACE=xmlns%28%3Dhttp%

Hi All,I have installed FME 2017 64 bit and ArcGIS 10.5 64bit geoprocessing tools. I am converting SDO geometry to ST_Geometry. While writing the features I am getting Unable to convert value taken from Z_ORIGIN keyword to a float data type issue. I tried all the possible ways, still no luck. Could any one help on this??

Hello, I'm working with a Excel file from an institution in México. It is a list of people, there is 22 registers.It is like this:#NOMBRE1SANCHEZ HERNANDEZ Pedro Antonio In México, people's name is composed of three parts: Fiirst Name + Father's Last Name (FLN)+Mother's Last Name (MLN). Usually the register in an Excel Spreadsheet is: a column "Nombre" (NAME) then we can read in a row, for instance: "Pedro Antonio SANCHEZ HERNANDEZ". It is not useful for filtering using for instance Last Name.So, I want to split this column and creating two news attributes: Apellido and Nombre. where Apellido will contain the Last Name and Nombre will contain First Name. In the spreadsheet, the string begins with the Last Name = The FLN + MLN, then it comes the First Name, usually is a combination of two first names, eg: Pedro Antonio (Peter Anthony). There is a blank space between all the names.  

Want to find an equivilent to autocad_layer_plottable attribute for DGN files to check if a level has plot turned on.

Hello,I am new to JSON formatted strings and have spent a few hours trying to split out some content with JSON Extractors and Fragmenters with no luck. I have an array of 10 "items" which I need splitting into separate features. What I need to pull from each item is the publishedParameters list (as a split list) and WorkspacePath. So they resulting objects should be formatted as such:Item# ¦ WorkspacePath ¦ publishedParameters0 ¦ "APIrepository_prod....." ¦ "name": "user_email", raw: "Glenn.sayers@halliburton.com"0 ¦ "APIrepository_prod....." ¦ "name": "cell_size", raw: ""0 etc.1 ¦ "APIrepository_prod....." ¦ "name": "_layers_other", raw: ""1 ¦ "APIrepository_prod....." ¦ "name": "_layers_gde", raw: "present_nonclipp

Hi everyone, I'm new on FME Desktop.I need to create a kml from excel, with some specific format (see screenshot below)I haven't been able to put the balloon code into KML PropertyFormatter transformation tool. Any help would be appreciated!Please find the example kml file attached.Thanks a lot!

Hi,I have a model where the readers change a lot so I have to update regularly but I have noticed that it does not work through the update reader.The only thing that works is save the fme model, close it and open it again.Am I the only one who bothers that?I'm working with FME(R) 2019.0.0.0 (20190328 - Build 19238 - WIN64)

I need to read secured map services (not feature services) from ArcGIS portal into my workspace. Before upgrading to portal, I was able to use the HTTP caller to access the REST services. Now I'm trying to use the Esri ArcGIS Portal Feature Service reader, which obviously isn't working because they are not feature services. Any ideas on how I might access the secured services? I don't think I can still use the HTTP caller because our access is windows authenticated (NTLM), therefore getting tokens is not an option.

When I'm using the Adobe Geospatial PDF reader it seems to me that the Raster Size parameters are always greyed out and can't be altered. Am I maybe overlooking something, or is this a bug?The following screenshots illustrate the issue. When the parameter 'Read Rasterized Pages' is set to 'No', the Raster Size parameters are greyed out (and also the 'Raster Size' 'group name' is greyed out.)However, when the parameter 'Read Rasterized Pages' is set to 'Yes', the Raster Size parameters are still greyed out (wheras only the 'Raster Size' 'group name' changes to an 'exposed state'.).I'm using FME Desktop Oracle Edition, FME(R) 2019.0.1.0 (20190506 - Build 19253 - WIN32).  

 Hi allI have a simple IFC file which has just 8 IFCWalls and 2 IFCSpaces. When I run a simple query for retrieving all records for IFCSpace elements ( select * from "public"."IfcSpace"; ) , SQLExecutor duplicates all records. For instance, I have 2 records for IFCSpace but after running the query, I'll get 4 records. How can I avoid duplication? (I use PostGIS)

We're frequently being asked to use authentication providers other than Active Directory for securing and providing access to FME Server, eg. Cognito, Azure AD. Has anyone attempted to use nginx to reverse proxy to FME Server and handle the authentication via SAML? Is there a way to get around the double login (e,g, login to nginx, and then login to FME Server)? Could you create a role that has very limited access (or use a FME Server app with a long expiry token) to get around the double login and provide basic access?User -> nginx reverse proxy (authenticated) -> FME ServerSome more context provided here: https://github.com/safesoftware/fmeserver-nginx @pallegama

When writing to a geopackage, is there a method to add metadata?

Hi, I've set up a workspace that utilizes a SKP feature writer and reader before writing to FBX using a reguler writer. This works perfectly well on desktop, but I'm having trouble adapting it for Server. The workspace stops all features at the feature writer with the log message "Features not written - verify feature type fanout/dynamic settings - (Check that fanout/dynamic feature type attribute exists and has a value)". I've tried many different settings in the writer, also using dynamic schema but nothing seems to work.I've been searching for examples of use of feature writer on FME Server on this forum but have been unable to find any. I would really appreciate some tips, in the meantime I guess I have to split up the workspace into several workspaces and run them with a workspacerunner...

Hello You,Do you think it would be possible to add text on a curved line or a circle?Just like this.

Hi all,  I'm using a feature reader to query a feature class stored in portal using a where clause, however i want to capture and handle the event if no records are returned. Currently fme will just stop and no longer progress if nothing is returned. Any ideas on how to resolve this?  Cheers

I'm reading a DWG file with the above reader and I'm finding that some features have different values for fme_feature_type and autocad_layer. Example: fme_feature_type = RR ALIGNautocad_layer = 0 From reading the reader description here I assumed that fme_feature_type is created from the AutoCAD layer name which is held in autocad_layer:"In AutoCAD, the layers are used to store collections of logically related entities, attributes, or symbology. In FME, the AutoCAD layer and the type of the feature are treated synonymously, since there is a one-to-one correspondence between FME feature type and AutoCAD layer." Is there a reason why sometimes these two attributes do not correspond or is there a bug? Thanks!(FME Desktop 2019.1.3.1 19643 WIN64)

Encountering issues while reading FGDB from .zip files stored under resource folder:-"Unable to connect to File geodatabase. Please make sure the correct file name was specified..."

Hi, I have a lot of DXF files and want only specific layers from this data. Additionally I have an excel file with all layers I want to filter in one column.How can I use the excel file as kind of a filter for the DXF files? The names of the DXF layer are pretty long and it would take to much time to write them all in a testfilter. Thanks and best regards 

In Oracle, i have a column called GEOM of SDO_GEOMETRY type. After running FME, GEOM column containing NULL values it is not getting populated.Could you please help me?

Hello,Trying to create a web connection for Google Sheets in FME desktop 2019.1. The email I'm using for authentication is a shared email address. Getting incorrect password alert returned. I know the password is correct.Is it possible to use a group inbox to create a web connection to Google Sheets? Or does the account need to belong to an individual?Thanks

Bonjour,Dans mon workbench, j'ai plusieurs sortie (Writer) qui doivent toutes s'enregistrer dans le même dossier : j'ai 4 sorties CSV qui fonctionnent sans probléme.Mais j'ai 2 sorties qui ne veulent pas s'écrire, j'ai le message d'erreur suivant :"TEXTLINE Writer: Cannot create dataset: 'C:\\Users\\B09278\\Documents\\2_Projet\\6_DATAPOSTE\\2_Moulinette_integration\\Fichier_integration' of type Directory, expected a dataset of type Regular file"J'ai essayé plusieurs formats de sortie sans succés (CSV, XLS, Txt). Je n'arrive pas à comprendre pourquoi ces fichiers ne s'écrivent pas.Pouvez-vous m'aider?Merci d'avance, ~~~~~~~~~~~~~~~~~~~~~~~~~~Translated: Hello, In my workbench, I have several output (Writer) that must all register in the same folder: I have 4 CSV outputs that work without problem. But I have 2 outputs that do not want to write, I have the following error message: "TEXTLINE Writer: Can not create datas