Data

When use generic reader on dataset on local disk works fine but when hit through URL and workbench gives back this "Generic Reader: No valid reader name specified, guessing reader name from dataset" and failed to load dataset

My goal is to provide a live updating KML file to be displayed in Google Earth for Chrome. My process is to create a KML file and then upload to Google Drive. The problem is that the new upload becomes a new file with a new location, so Google Earth doesn't know where the latest KML file is. Instead, I just want to update the existing file. Maybe GoogleDriveConnector doesn't have that functionality?One option would be to create a Google Drive API Python Script, but that doesn't seem very FME-ey. Thank you for your assistance.

My FME Server Dashboard is showing 3 months of logs, is there a way of only showing the last 2 months of logs?

I am trying to add an ArcGIS Server Feature Service reader to my workspace but get the following error when I click to get the Layer List: Python Exception <HTTPError>:401 Client Error: Unauthorized. I suspect the issue is a dash in the URL, which goes something like https://server-new/arcgis/rest/services/MyMapService/MapServer. I can't add any of the map services from this ArcGIS Server. However, we have several other ArcGIS Server environments and I don't get the error with any of them (and none have dashes in their names). Could the dash be the issue? (FME Desktop 2016.1 - build 16492)Thanks,Aaron

Hi All,I am comparing pdf's and getting the changes (Added/Deleted). It works fine. Only one scenario I was facing the issue with different scale pdf. (one is 640km scale and another one is 360km scale) this case I am not able to find the changes. Could anyone can help with this?

Hi,I´m using FeatureWriter to save my DWG file, but after executed my workspace, the DWG file show me all features duplicate. If I use the writer REALDWG work good, but I need to use FeatureWriter because it´s possible use autocad_source_filename for Template File.Why all features are duplicated in FeatureWriter? Thank´s

Hello.I'm trying to convert Land XML to 3D Tiles and running into some problems. I've tried both Cesium ION Connector and Cesium 3D tile writer, and an EsriReprojector to convert state plane coordinates to WGS 84 .Both complete the conversion without errors in FME. However, each method has some additional issues. Using the 3D Tile writer, I use a Land XML Reader, to EsriReprojector, and directly to 3D Tile writer (do not use ION connector). I cannot see the3D Tiles in Cesium. I do not get any errors in Cesium and Cesium viewer is successfully loading the tiles.I've also tried LandXML, to CityGML, to 3D Tile Writer, but that does not create a data Directry. Creates the tileset.json file though. Using the Cesium ION Connector, I followed this example:https://knowledge.safe.com/articles/81161/uploading-assets-to-cesium-ion.htmlI converted the Land XML to CityGML, then push that to the Cesium ION connector. When I go to the Cesium ION account assets, an error is displayed about

Hi all,  After some investigation I found out my Excel reader file contains "line breaks" causing FME to write the content of a single Excel cell to multiple lines.  Is there a way in FME to clean line breaks?  Thanks, Ed

Generate Unique id in ArcGIS for Sql database.

Hi, I have a problem with writing components to a pointcloud (.csv) file. I made a workbench that merge 2 pointclouds using the pointcloudmerger. The pointclouds contains depth information of a river and represent 2 different periods. There is partly geographic overlap of the information so a made a merge that results in 3 outputs (merged based on X and Y, not merged and unreferenced), with a pointcloudCombiner the 3 outputs will be combined to 1 pointcloud and a pointcloud writer write the new created pointcloud (.csv). The problem is that in the new pointcloud only a few components (x, y, z and z_last) were stored. The original pointclouds contains a lot more components (depths from every measuring period and more) and I see these components in the data inspector but not in the new created pointcloud, is there a possibility to store the original components also in the new created pointcloud? The attached picture shows the output of the new created pointcloud and the data as shown in

i need export alias from a empty gdb. How i can not read any feature. how can i do to export it... thanks

I have exported some buidlings in format CityGML from a different software. The format contains no semantics or attributes and I therefore want to continue to work with the file in FME.When I view the file in Data Inspector I can see the buildings in 3D and I see that it is a IFMEBRepSolid. However when I try to work with the file in Workbench (e.g. transforming CityGML -> CityGML or try to run through GeometryValidator) I get message "There is no geometry in this view".And clues to what can be wrong? I have attached a sample of the 3D-buildings. I am using FME version 2016.1. Thank you!

Hi,I need to georeference a tiff image of a town in Illinois in WGS 1984 Web Mercator (auxillary sphere). The county's data is in NAD 1983 StatePlane Illinois East FIPS 1201 Feet. ArcMap's georeferencing tool is not able to accurately make the tiff image into a map and I think the difference in projection is the reason. So I have downloaded the map of the town from OpenStreetMap. I did a conversion in FME of the attributes I thought would be relevant: Here's the output for the highways attribute in Inspector with Inspector's Background Map:Here are the format attributes I am exposing:The geometry for every attribute is point. I do not understand why a boundary, highway or a route would be represented by a point. Highway has the most features and the other attributes' features all occupy the same spot as a highway feature. My goal is to get a map that in web mercator spheroid projection that I can use to georeference the tiff image. Is this possible? Thank you..

Hello.I'd like to convert LandXML to CityGML. I've tried a direct conversion, but the CityGML Feature Writer is writing geometries that are unsupported by Cesium.How can I extract the coordinates out of the LandXML and write a CityGML line string?

Hi.My model is complicated and I need to simplify it.If FME can do the job, I will be grateful.Thanks a lot.

Hi,Just wondering if anyone had any success reading data from the ArcGIS Online Living Atlas? Thanks

Dear FME community.I try to integrate data into ORACLE but FME say me : error was `ORA-29875: failed in the execution of the ODCIINDEXINSERT routineDo you know what does that mean ?Thanks

I have a table with three attributes: NAME, LOCATION, and AREA. I want to get the row with the largest area, for each name. In Oracle, I can do so with this query: select    name,    location,    areafrom (    select        name,        location,        area,        max(area) over (partition by name) as max_area    from mytable)where area = max_area I could put this into a SQLExecutor, but I'd like to be able to do this even if my data source isn't Oracle.  Can I accomplish this using FME transformers instead?

Has anyone got a workaround for updating a hosted feature layer without effecting the edit date? I have had multiple editors updating many hosted layers for over a year. I now need to change some attributes on a large scale (+30k records).  Ive been able to create a simple workbench using the feature merger to achieve my update. The issue now is loosing the historic, editor and edit date attribute. Many ThanksMick 

Using the said reader I configure my parameters as shown, FME returns with the folder list from Box below When I run my workspace I get this error If I use the BoxConnector transformer it can only read one folder URL at a time but using the same web connection works. All I want to do right now is build a folder list that reads the sub folder recursively. Later I'd like to use the exifreader to get metadata of the pictures stored in Box.

I have some XML data in the structure<a> <b>  <e>data1</e>  <e>data2</e> </b> <c>  <e>data3</e>   <e>data4</e> </c>  <d>  <e>data5</e> </d></a>I would like one feature for every 'e' element, which is simple enough using Feature Paths by setting the elements to match parameter to e on the XML Reader.  What I haven't been able to figure out is how to indicate which parent it belongs to.  (data1, data2 is b, data3,data4 is c,  data5 is d).  Adding Ancestor Elements (Parent) in the XML Flatten Options doesn't help because there are no attributes associated with b,d,e.  Even if if set the elements to match to a/b/e a/c/e a/d/e explicitly rather than just e, the xml_matched_element is still just e. I can't guarantee the order of the parent nodes, so using the xml_id is not an option either. 

Hi,I'm trying to fetch data from the following WFS with a WFS-reader:http://geodata.nationaalgeoregister.nl/bag/wfs?service=wfs&request=GetFeature&typeName=bag:pand&cql_filter=bag:identificatie LIKE '%25158110%25'When I browse it in IE it works fine, but FME throws me the next error:<WFS> An Exception Report was produced performing a `GetCapabilities' request<ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows/1.1" version="2.0.0" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/ows/1.1 http://geodata.nationaalgeoregister.nl/schemas/ows/1.1.0/owsAll.xsd">  <ows:Exception exceptionCode="NoApplicableCode">  Â  <ows:ExceptionText>Could not parse CQL filter list.Lexical error at line 1, column 18. Â Encountered: "%" (37), after : "" Parsing : bag:identificatie%20LIKE%20'%158110%'

Good morning!I am using FME 2018 for the process indicated below:Does Safe support or plan to support AFS or Two Factor Authentication for the SharePoint Reader?I have a process where I need to read and manipulate files hosted on SharePoint and move them to another SharePoint site. SO far I am not able to even read the data because of the authentication. Any tips?

Hi, I'm new to pulling data from an API and looking for some advice.  So far I have been able to get part of the JSON data I need from an API using the HTTPcaller and using the JSONFragmentor. I have a header and an API key to access the data.  My data now looks like this.I now need to grab each location id (location id field is "lid") and pass that value into another URL using the HTTPcaller to extract more detailed data for each location.My end goal is to have the all the data in the above screen cap joined to the additional detailed data that I get from passing the "lid" into the url. Then I can have a point feature for each location "lid" with a complete set of attributes. Any advice would be appreciated. I am just not sure how to pass the "lid" into the URL for each record, then move or loop onto the next record in the dataset.ThanksSherriff

Hi.I'm wondering whether it's safe to set the MS/SQL database that FME works with to single-user while processing it ?I.e., sets the DB to "single-user" before pushing data into it, and to "multi-user" after FME's done.Are there any serious caveats that I should be aware of ?Cheers.