Data

Is there a way to read SAS tables without the Stat/Transfer application?

I have two arcgis online feature layers (jobsites and trees) that are in a 1:M relationship. On the trees reader, I've set where clause as "EditDate" >= CURRENT_TIMESTAMP() - 7. The resulting features in this reader have the globalid attribute found in the jobsites layer. I would like to read just jobsites with globalids found in the trees reader. How do I create a dynamic where clause for the jobsites useing a unique list of globalids from the trees layer? So far I've used Listbuilder, DuplicateFilter, ListConcatenator, and StringReplacer to get a list of unique globalid's - '{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}' The first issue is how do I make the string say the following:GlobalID IN ('{28F268A5-7390-4FF

I am tyring to insert into a PostgreSQL table where i have a primary key defined as serial (auto increment).   I want the database to increment this field and not have to supply the value from FME.  FME keeps failing due to the Null constraint on the field.   I have tried suppling 'DEFAULT' and 'NEXTVALUE('Seq_name'") as a string to attempt to fake it however both complain that an integer is expected and not text.    I am using FME 2011.  Any suggestions?

I have a jp2 and jpw file. Reading the jp2 results in the data inspector showing the resulting data in the wrong location. How can I fix the location? I've tried setting the coordinate system on the reader but that doesn't fix it. I know the j2w file holds information about the location of the jp2 but I don't know how to read it along with the jp2. I know I'm likely missing something simple so I appreciate the help.

I've created a workflow to update, delete, and insert new records to an hosted feature service. The delete and update have been throwing log errors like:ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in 'Job_Line'. The error code from the server was '1019' and the message was: 'The specified feature could not be updated or does not exist.' In the reader, I'm making sure to include arcgisonline_globalid and arcgisonline_objectid in the format attributes window. These appear in the Joined output for the FeatureJoiner (for updates) and the the Deleted output of ChangeDetector (for deletes). I'm really scratching my head as to how to the OBJECTID's can be incorrect in the writer when the reader is the same online source. The parameters for the Writer have Use GlobalID = No and Preserve GlobalIDs=No.For the layer, parameters are set to Writer Mode = Update (dont think this matters with fme_db_operations) and Trunca

FME Desktop 2020: How to concatenate based on a particular field when working with “AreaOnAreaOvelay” tool? When performing the “AreaOnAreaOvelay” tool, I wanted to create a field at which the values of the “autocad_color” field are concatenated as per the screenshot below. How this can be accomplished?           

Hi. I need to convert V7 dgn file to work in V8 Microstation. I don't know how to do it. Im new to the FME. If someone could give me instructions on what buttons to push? :D

I receive an empty shapefile from our client and if I don't add any features, have to rename it.Since FME is feature based it won't write to a new shapefile if empty. The shapefile can also not contain a null feature so the NoFeatureTester or a null Creator is not an option.I'm currently on FME version 2019.2.1 How can I write empty shapefiles?

Hi! I'm trying to get the effing per-cell formatting to work in Excel but I'm not succeeding. My excel output doesn't come out with a yellow background. Please check my screen dumps and help me figure out why!

I am setting up a brand new installation of FME Server 2021.2.0.1 and I can't authorize any ArcGIS Online connections. It gives FME Server OAuth Service Failed. It doesn't matter which user I try to authenticate. This works in my other 2019.1 server, so I know these connections should work.

Hi everyone,  I have a workbench that downloads a extent from a bigger database by Esri (by using a Esri feature server reader) and writes it to a file Geodatabase that we host on a server. Our arcGIS users use a layerfile in ArcGIS pro that uses the file GDB as source.  I use windows task scheduler to run a batch script that starts the FME workbench every month (at mightnight, when no users are logged in).  For some reason the file geodb still has locks active during that time, which cause the overwrite database function in the FME writer to fail.  Is there a way to update the file GDB while the locks are active, or a other way this problem can be solved?

Hi, does anyone have any experience with the following error: - "Unable to connect to the File Geodatabase at '------'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147220893'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for details" We have recently just started receiving the error on all workbenches that are reading feature classes from a .fgdb. The error is inconsistent between what database it happens on and when (i.e. re-running workbench multiple times in a row, it may read a few times without issue). We have alot of automated processes that should run in the background that are now failing.We are using FME 2018.1 via ArcGIS Pro Data Interoperability and have recently had a company wide roll out of windows 10 laptops.I believe the issue is somehow related to the

Hi, newish user here trying to figure out dwg to shp conversions. I've got the attached DWG file that has 31 feature types that I need to convert to SHP. But when I run the attached workbench it's projected to 0,0 what am I doing wrong? Thanks

FME 2020: How to label the output in the graphic part based on particular field? For example, in the screenshot below, I wanted to label the polygon based on the “parcelnumber” field but couldn’t figure out how to perform this  

I want to create dwg's with object data with FME. The problem I run into is that the names for the layers and the object data table end up being the same, which makes the data hard to use in Autocad Map 3D. I have attached an example workspace to illustrate my problem. What I would like to achieve in this setup would be for the output file to be identical to the input. For this example I start with a dwg with one object data table Vegetation and two layers, Bos_groen and Ruw gras_groen. I read this, do nothing else, and write it to a new dwg. My end result has both polygons in the right respective layer, but their attributes in two different object data tables, with the names from the layer.  My problem is illustrated in two screenshots. In my sourcefile Object data table and and layer are distinct values, Vegetation and Ruw gras_groen respectively.In my output the layer and the names of the object data table are both Ruw gras_groen, the other polygon has Bos_groen for both, nothin

FME 2020: How to filter dwg file based on hatches and Areas (polylines)? I couldn’t figure out how to filter dwg file based on hatches and Areas (polylines).   

FME 2020: How to filter dwg file based on lines and polylines? I couldn’t figure out how to filter dwg file based on lines and polylines 

12d has the ability to close polygon without making the last vertex sit on top of the first vertex. ( ie a square\\rectangular polygon has 4 vertices and 3 segments)When the last segment of this closed polygon has a radius, a 12dxml file when viewed in data inspector or workbench, does not show the last segment as curved. When compared against a polygon that the last vertex sits on the first vertex (ie 5 vertices, 4 segment polygon) then FME displays correctly. When I look at the properties of both strings in inspector, the two different properties are No. of vertices which is 5 and the field under IFME Polygon called Linear Boundary is yes for the scenario of not displaying the curve on the last segment. For the polygon that does display correctly, these two fields are 10 and No. Would appreciate anyone with any 12d knowledge to assist or what the linear Boundary field meansNote uploader wont accept 12dxml file format so you will need to rename the attached to polygons.12dxml to vie

Hello,I'm attempting to write a dataset to AGOL. This dataset comes from another system with ~25,000 records. So far I've been reading this dataset and processing it with my workbench without error for a some time now. Last week it began to fail with the error:"ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: ''. Details: 'Field WORKDESC has invalid html content.'"The datset has a field WORKDESC that contains freeform text entry where staff describe the details of a building permit. I suspect from my troubleshooting that somewhere along the line a strange character has been entered that the AGOL writer is interpretting as html content.I'm looking for some tips/suggestions as to however to 'clean' this field so that this error doesn't hurl my workbench. However, I don't really want to manually dig through the dataset to find the specific chara

I have created a "i3s_terrain_mesh" out of a DEM. Following the description on this page, the terrain mesh would replace the existing terrain in the scene viewer. In case we talk about the ESRI ArcGIS Portal/Online Web Scene Viewer, how would that work?  As far as I understood, only elevation layers can take over this job when being added to the scene. Even turning an input into an "i3s_terrain_mesh", we deal with an SLPK, that has to be shared and published on the Portal.In a web scene, such an added SLPK is not interpreted as a layer that can be added to the "Ground" - replacing the default terrain 3d elevation coming from ESRI. Have you any experiences with this?

I am trying to get the location curve property for walls using FME and Revit Reader.  To be clear, this is not the geometry of the wall, but the line Revit uses to create the wall.  From what I can tell, the property is not in the actual file itself, but the result of a Revit API method:  wall.Location as LocationCurve I use Python scripts in Dynamo, but this is unknown territory for me.  Is it possible to install Revit API modules and do something like this?import fmeimport fmeobjectsfrom Autodesk.Revit.DB import *  def locLine(feature):            line = feature.Location.Curve    if isinstance(line, fmeobjects.FMELine):        cLine = line.getAsLine()Any insight is appreciated.  For now, I will get the lines in Dynamo, export to Excel, and then merge in FME.  Not very elegant! Thanks,@lorenrouth

I have a Salesforce custom object with 2 master-detail fields that both have read/write permissions. When I attempt to write to this object, I receive the "REQUIRED_FIELD_MISSING:Required fields are missing:" error. The two fields referenced are the 2 master-detail fields. The fields and the data are present when the write occurs but for some reason I receive this error. Any ideas?

I Have a building with itiff textured polygons. I want to convert that file in to citygml lod 2 format. Anyone please guide me. I am new to this FME.

I am receiving a vaige AreObjects error '-2147216072'. That said, it appears to be different than the other questions posted here (such as this, this, and this). The actual error I'm receiving is "An error occurred while flushing the cursor for the table/feature class 'my_table_here'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 5 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.]}"The workflow does write some data, up to 32,000 records into an SDE table using the ArcSDE Geodb writer (there should be 33,001). It will also run without error if I remove a portion of