Data

Hi FME and ESRI users, In an SDE feature class archiving is turned on.When writing a record in update mode, an attribute is blanked out, all other attributes get values.But redirecting to the Data Inspector shows a value for the attribute. We checked the data type in SDE and FME and they match. Any idea what could be causing this issue? Your suggestions are highly appreciated. 

could i ask how to get the list of attributes from oracle non spatial.iam a little bit confused from oracle files .i added a reader for oracle non spatial but i could not check the oracle on inspector when i conenct with inspector i see nothing,is there a way to inspect it while iam working on workbench . and when if i want to extract only the attributes ,how could i do that  i want to extract the attributes in table  Thanks in advance

I am using SQL executor to perform insert command to insert table data into Oracle. I have a column with geometry and data type as SDO_Geometry in already existing oracle table. The current geometry I want to insert into oracle is in UTM format. I have converted it using geometry replacer and reprojector in my workspace.SQL Executor is throwing an error with too long string literals and can not be inserted.What is the way that I can insert geometry column with UTM coordinates into Oracle SDO_Geometry column?

Here I am trying to get the sequence before writing data into oracle. All I need to do is to start this sequence with the value of 5000000000.As we can use this in insert function - "insert into nb (XFM_ID) values(XFM_ID_SEQ.NEXTVAL + 5000000000)"But this is not working in FME. I tried all possible ways to insert sequence starting from 5000000000 like using sql creator,executor etc. Sequenced Table columns does not accept " XFM_ID:XFM_ID_SEQ.NEXTVAL+5000000000"

I am looking to insert a new feature into the output geodatabase here. The translations uses a feature reader to read a source geodatabase based on a user defined parameter which defines which feature classes the user wants to bring over. However I also need to add second feature class but instead of reading from a source I need to add a new record which i intialize from the creator. In this case though because the output writer uses a dynamic schema, I don't know how to insert this new feature or to indicate which feature class it should be written to. Any ideas?

I am trying to write data from GDB file into oracle database using SDE writer. Its giving below error Could not unregister GlobalID column 'GLOBALID' in table TABLE_NAME. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked [TABLE_NAME]}

Hello,I need to create and implement control rules which can show that my object (in GML) has dupplicate vertices.I have reader "GML file" with the element which geometry is:<bdz:geometria> <gml:Polygon gml:id="geom.9acd0ccc-6a2a-4dfa-8e70-487b08d83e7b" srsName="urn:ogc:def:crs:EPSG::2176"> <gml:exterior> <gml:LinearRing> <gml:posList>5947602.08 5474440.64 5947598.85 5474445.14 5947598.85 5474445.14 5947602.08 5474440.64 5947603.36 5474448.24 5947606.44 5474443.96 5947602.08 5474440.64</gml:posList> </gml:LinearRing> </gml:exterior> </gml:Polygon> </bdz:geometria> It contains 7 vertices (1 dupplicate vertex), but when I add inspector, FME show me that there is 6 vertices: Neither the geometry validator nor the coordinat

Hi, the result of my workflow is a raster and I would like to publish it on ArcGIS online automatically with FME. Is it possible? Thanks

HelloI am attempting to make non spatial Oracle table data spatial, I have created the FME workbench no problem but when it comes to writing the results to an Oracle table using Oracle Spatial table no points are displayed just the data.Basically I am missing the accompanying spatial data to the points. I am sorry if my post makes no sense and please ask any further questions. Many thanksSy  

We are running FME Workbench 2019.1 and FME Server 2019.1.2 on Windows Server 2016 Standard. On the same server, we have ArcGIS Desktop 10.6.1 and ArcGIS Server 10.6.1. The Desktop license is running off a concurrent License Manager on another server. We have the ArcGIS Desktop license set to Advanced on ArcGIS Administrator.This setup has worked fine until about 4 days ago. Now many of our FME services are failing. The workbenches run fine. An excerpt from the log on one FME service is shown below. I have already exhausted my search for solutions. I am considering trying to install ArcGIS Pro on the server, though I would prefer not to. Any suggestions would be appreciated. Thanks!145The Esri Product license used by this machine does not include licenses for the 'ArcServer' licensing level146The ArcObjects license 'Advanced' is being selected from the Windows registry147The Esri Product license used by this machine does not include licenses for the 'Advanced' l

Hallo guys!I want to transform/convert an OSM file to an OpenDRIVE file. So my question is if anyone have some informations for me how that's possible and which steps are needed for. I also tried it with "GIP" data. My main problem is i have no idea how to add attributes or to get an OSM data into a structured OpenDRIVE file. Thats my first time with FME so i have no Idea how that should work.

Hi, I have a DGN file that have links attached to elements.However, I cannot see the links exposed/supported in FME.Please see a screen grab showing the link attached to element in Bentley Microstation.I cannot get to this object in FME.Please can you help?Many thanks, Magda

I am attempting to convert from Oracle to a shapefile and getting the following error consistently. look like it is failing on the .dbf file. Any suggestions?

Hi All,  I am having quite the time getting some nested JSON out of an attribute. My current workflow flattens out the original JSON, then fragments out the nested meetings. I then flatten it out again to expose each attribute for each meeting. I get to a point where I now have an attribute "agendaitems" that can have different amounts of items for each meeting. This is where I am having trouble flattening it out from here. The attribute is filled as <missing> but when inspected has the items listed in the attributes as: agendaitems{0}.billagendaitems{0}.descriptionagendaitems{0}.item and so on for however many items are associated to it. Is there anyway to get these to all flatten out?

Using reader MITAB on a file written in 2006 and getting the error "Failed reading coordinate data at offset 0".Sometimes, the error doesn't stop further actions, sometimes it does.Can anyone point out the likely issue?Cheers!

Hi folkswhen i try a translation from DWG to a GIS format, i encounter that message : FATAL |Incompatible visitor version 1 in FMEOrientedArc::acceptGeometryVisitorConst. This release of FME is compatible with versions 6 to 6 I tried many ways to solve it, GeometryValidator, Orientor, but the message still remainsthe DXF file is hudge, so i can't attach to the message ...regards

Hi all I have a workspace that is managing a dynamic migration from one Oracle 11g database to Oracle 12c. The process is quite mature and has mainly be used to truncate and insert new data. We now have to extend this process to create tables if required. The writer connection is a different user (USER1) to then one where the table is being created into (USER2). USER1 has heightened privileges and is used for all maintenance tasks. Grants include 'create any table', among others. We have started to encountered exceptions when attempting to drop/create a table into the destination instance.  Using Feature Writer or a writer/Feature Type, when we try to 'drop/create' or 'Create if needed', we get the following exception raised: "Cannot create table 'TABLE_FROM_FW' within schema 'USER2', when logged in user is 'USER1' ".Full log with debug here:  I have tested with Oracle Spatial Object and Oracle Non-Spatial writers both withe sam

Hello everyone,I am attempting to copy a select number of files from a given directory and came across the FileCopy writer. After experimenting with it, it appears that it is copying all the files specified in the source directory whereas I would like to specify which ones it copies instead. Can anyone confirm this limitation in the writer? And of course, I would be very happy to hear any ideas and workarounds for this. I am considering using PythonCaller to accomplish this but I would like to avoid this if at all possible.

i have read lots of article about Feature Writer , but i could not get the point ,how can i get my attributes and connect it to excel writer without effect on my output ,it does not matter to show this attributes in excel file output but i want to keep it in excel writer to use it lateri have at the beginning excel file then i converted it to csv then i apply the output on excel file but i missed some attributes that i need to usemost of attribute are missing ,onle my result what i can get ,could i ask,how can i find the rest of Attributes  exactly my target ,i want to name excel writer as the field name included attribute but i could not find most of attributes after Featurewriter.FME version 2018.1

I am trying to find a method for reader to link between many sources to one source but i could not find . i have many readers come from the same source when i run my workbench with quick translator ,as result it gives me around 10 sources to select but 8 of them from one source , bcs i have chosen from the beginning individual Feature typesis there a method to refer only to one source files instead of 8 sources . because all of them from the same file  

Hi FME gurus,For an engineer I would like to parse OSM XML data with line and polygon features. Although point features are no problem to parse, the geometry from the line and polygon features is not coming correctly along by the OSM XML reader.I can parse the OSM XML by a combination of FME transformers:However this transformation is rather slow due to the number of vertices that have to be parsed.Attached therefore an example of an OSM XML with highways. Is someone able to use the OSM XML reader with some settings, whereby the geometries of the line and polygon features are correctly parsed?

I am using Esri ArcGIS Online(AGOL) feature service to write data from a database. A flag column is to be maintained in database to check whether a feature is successfully written or not, based on that flag column we are further processing those records by another software. How do I get the OBJECTID and GLOBALID of features which are successfully written to AGOL so that I can update the flag ?

Hello Friends,I need an urgent help. Can anyone please help?I am having something like this:and i want to fill down the values something like this in excel:its like a fill down option for sample id and ID till the time it finds a new sample line in text_line data or till the time it finds a blank value in its own column and stop when next row has a value.Also attaching the excel file for your reference.Thanks

While i am trying to extract feature classes from postgres database to esri file geodatabse, i am not able to get the geometries, if i use postgres in the Format dropdown of Reader. After enabling PostGIS on the database i am not able to see any spatial objects in the tables list.. What is the correct process to read postgis enabled postgres database?

Is there any documentation on the best way to install and set-up FME in an AWS Cloud Environment?How is the licence set-up on a dynamic environment?