Authoring

Just using AttributeCreator to set the fme_db_operation value and noticed "put" in the drop down list of possible values along with the usual "insert", "update", and "delete". What does "put" do? Is it specific to certain writers?

Hi,  I am having a bit of a problem with the WHERE clause in the FeatureReader transformer. I have a project boundary as the INITIATOR and I am reading an Integraph Acess database that contains a feature class named ROAD. Now this feature class has an attribute called SURFACE. There are multiple text values for this attribute and they are 'A', 'G', 'U', and 'C'. My WHERE clause statement is SURFACE = 'A'.  Now the results coming out of the FeatureReader transformer are not being filtered by the WHERE clause. I am getting all of the ROAD features, regardless of the value of the SURFACE attribute.  I have double checked my WHERE clause by reading the ROAD feature directly and inserting the statement under the Format Parameters. This correctly filters my features.  I am not sure why the FeatureReader WHERE clause is not working. Does anyone have any ideas?  Thanks,  Krist

Need help getting the where clause to work in the FeatureReader. The where clause is a select on SYS.USER_PRIVILEGES table to limit the number of tables accessed. SELECT OWNER, TABLE_NAME FROM SYS.table_privileges WHERE GRANTEE='GIS_VIEWER'

Good morning everyone,I am relatively new user of Fme Server with a background of GIS deployment related to ArcGIS Server. I have one question. Is it possible in Fme Server to stop one published Workspace and restart the workspace.  I have one deployment and our project is going live. During this phase we do not want that two of our services published on Fme Server connect with database. But we cannot stop our Fme Server as there are other workspaces which we cannot stop. So I am looking for start and start servie feature like ArcGIS Server manager. Is it possible with Fme Server 2014 ? Thanks for your helpAyyaz

Hi,Got this error when trying to extend FME exporter in build 16716 in Windows 10."Failed to extend FME Exporter for Autodesk Revit 2016 (Microsoft .NET 4.5 is not installed, however the FME Exporter for Autodesk Revit requires it. It is available on Microsoft's website)".We are using net framework 4.6.2 and we tried the workaround for Revit 2016 (change the registry version of net framework to 4.5) but it can't be detected.Anyone met this trouble? 

How can I merge multiple Suppliers to the Requestor in the Feature Merger?I've set the option Process Duplicate Suppliers to 'yes' and add two Suppliers to the Requestor, who has the same ID as both suppliers. But nothing is merged. Both Suppliers are so called 'Unreferenced'.Who can help me?Best,Harmen

New year - new problems.I have an excel file with fieldnames Layer 1, Layer 1, Layer 2, Layer 2. My second and third row of data consists of defining parameters per column that I need to decide how to route the actual data. These parameters can vary from sheet to sheet, and I need to handle multiple sheets with the same routine. And then I have my actual data values on row 4 and forth.Example:Layer 1, Layer 1, Layer 2, Layer 2Stone, Stone, Clay, ClayTime, Depth, Time, Depth1, 0.5, 0.2, 0.30.4, 5, 0.2, 0.3To be able to handle route the data correctly I need to create attribute names and then have these names apply to the actual data. Any ideas on how to solve this?

Hi,I would like to write a python function to extract the value a list attribute knowing its e.g. Working with a dgn file for instance, I would like to extract the value igds_linkage{ind_entity}.key where ind_entity is a know index.I already wrote a script to do that but it requires 3 transformers and I want to optimize my workspace.Thanks

I have 2 spatial datasets - FAUNA_MASTER and FAUNA_SAMPLE. Both datasets contain points (many thousand) representing the locations of a variety of animal species (Species A, Species B, Species C, ... Species Z). I want to create an FME script that identifies all records, for each species in FAUNA_SAMPLE that occur within 10 kilometers of all records, for the same corrosponding species in FAUNA_MASTER.The transformers to use I think are straight forward, I use Bufferer to create a 10km buffer around points in FAUNA_MASTER, then use PointOnAreaOverlayer and a Tester transformer to identify which points in FAUNA_SAMPLE points occur within that buffer. What I don't know how to do is iterate or loop the records for each species through those transformers.I'm relatively new to FME. I've tried my best to understand the documentation to create a looping custom transformer and apply it to my situation, but without success. If someone could walk me through it please (with baby step

Hello everyone!Long time user of FME and a big lurker here!I am currently designing a FME Server Workbench where I expect a user to upload spreadsheets that does not have any sort of schema requirements aside from Lat/Long and a prefix of 'h_' for any hyperlinks in their spreadsheet.I currently have two branches in my workbenchBRANCH 1With Dynamic Reader and Writers the process is relatively simple, but my issue is with the hyperlinks. My hyperlink URLs need to be wrapped with <a href> </a> tags in order to work on web app builder mapping services. This branch creates the points out of the provided Lat/Long and accepts schemas for an increase in character width for larger hyperlinksBRANCH 2In order to test attribute names that contain 'h_', I used an attributeexploder and was able to determine which fields have a h_ thus needing the <a href> tags. Once I have the <a href> tag in place I want to transpose it again to return it to the original stat

In my startup script I use an "import ArcPy" in order to create a new version of my ArcSDE database. I changed the Python interpreter to C:\Windows\SysWOW64\python27.dll.My code (some "private parts" disguised with <XXXXXX>import sysimport datetimeimport arcpyimport fmeinWorkspace = r'<XXXXXX>BUDATA/ArcSDE Connecties/GABUAPP_AREAALDATA.sde'parentVersion = 'sde.DEFAULT'versionName =  'GISIBsync_' + datetime.datetime.now().strftime('%Y%m%d_%H%M%S')arcpy.CreateVersion_management(inWorkspace,parentVersion,versionName,"PUBLIC")To my surprise during runtime it seems as if the startup script is trying to create an Autodesk 3Ds reader (in bold in the output beneath), which is strange since my FME-workspace only contains Oracle Spatial and ArcSDE readers. It also seems that this reader is trying to read the ArcGIS toolboxes (!).Even stranger: after this unsuccesful creation of a reader, the startup script continues, and finally creates the ArcSDE database version. Starting translati

I'm currently reading from and writing to the same GDB. What I would like to do is rename the filename after the workspace is complete with certain attribute values that I had set from within the workspace. The only way I came across was using a Python shutdown script and I'm still very new to Python and I'm having some trouble in getting started.I have 5 attribute values all set within the workspace which I would need to use for the final file naming convention. SR, AFE, PNUM, DATE The final naming convention would be: DB_TGS_SR_AFE_AP_PNUM_00_DATE.gdbAny help with this would be greatly appreciated. Thanks! 

How can one expose table name parameter at a Postgis reader so that workspace runner can make use of ?Thanks.Jorge

If I formulate an attribute value with new line character, it appears in Data inspector as I expected. But when I write it out to KML, and open in Google Earth, there is no new line. How can I write multiple lines of attributes in KML description balloon?

Has anyone done any work using the Workspace Reader to compare two versions of a Workspace to identify differences? Ideas, sugegstions, comments (Workspaces!) all welcome before I try myself.Thanks!

I have a XML that i want to take out 2 values, name and title. i have done it here;Now I have these attributes but now i dont know how i do to match layer title and layer name. I would just want 2 attributes one for name and one for titleI have worked on this for a while and Icant get any closer to the result i want.Attach the workspace.

A few days ago we cleaned our FME_TEMP env variable directory as we had ~80GB files sitting there. I am now unable to use the Batch Deploy option and get the following in the log;Starting translation...couldn't open "{E:/Local Processing/FME_Temp/FME_1480515564385_17256}": no such file or directory    while executingopen $superBatchFileName "w"    invoked from withinset superBatchFile [open $superBatchFileName "w"]    (file "C:/Users/william.allen/AppData/Local/Temp/5/fme-batch-deploy-f14892.tcl" line 14)Purging temporary files does not make a difference - nor does creating a blank file/folder.Do I have to change the Temp directory? Any idea how to avoid this - and keep the Temp folder size down?

I have a lake dataset which I have aggregated and dissolved which has almost given me the right results. However as you will see from the results I have Lake Okataina and Lake Okataina/Te Moana i kataina a Te Rangitakaroro. Lake Okataina is larger than Lake Okataina/Te Moana ... however once I aggregated and dissolved I get Lake Okataina. How do I merge the LakeName so that I keep the whole name and not just Lake Okataina. I've tried tweaking a few of the dissolver parameters but this doesn't seem to have given me the result I want.Cheers,Sarah

Hi there,I'm using FME Desktop & Server 2016.1 with Esri ArcDesktop 10.3.1. The workbench is reading oracle spatial data and writing it into Esri File geodatabases.In the Shutdown Python Script, I would like to find all the objects in the workbench to determine which are Feature Types, get there Feature Class/Table name and associated writer's destination path & file name.Once I have this information, I can use Esri's arcpy module (I have already worked out how to import this) to create indexes, etc. on the feature classes.Thanks

Hello,I have hundreds of excel books to read one sheet of (they each have only one sheet) then write the data to a database table. I thought this would be simple using batch deploy, I then realized the excel sheet names are different and in the basic way I set up my batch deploy it expects a specific excel sheet name. Is there any way for FME to simply read any excel sheet in an excel book at run time? All the excel sheets have the same column structure.To be clear:Excel book= A xlsx fileExcel Sheet= A tab of a excel file Thanks

I am trying to see where there might be a log of what occurred in a sub workspace called by workspaceRunner.I have FME server running workspace (A) and as part of that process workspace (B) is called.The only detail I can see is that workspace (B) was called successfully, however I would like to see the type of detail showing in the job log for workspace (A)The Log simply says90 INFORM 0.0 0.4 Today at 12:27:00 WorkspaceRunner_2: {C:/Program Files/FMEServer/Server/fme/fme} {//Workspace/datagovau - AFS_LIC_.fmw} 2>@1 91 INFORM 0.0 0.4 Today at 13:24:46 WorkspaceRunner_2: Successfully ran workspace \\\\Workspace\\datagovau - AFS_LIC_.fmw

I've got a shape file and a GDB feature class derived from that. 2 featureReaders with the same settings pointing at the 2 datasets, the shape file reader outputs a schema feature the GDB reader does not.Anyone know what's going on here? FME Desktop 2016.0

I have run the below query successfully on a spatial database in a standalone workspace:st_intersects(st_setsrid(st_geomfromtext('$(poly)'), 27700), geom)The poly parameter brings in the relevant wkt.When I run this query with the paramater passed through a master workspace it treats '$poly' as a string rather than a parameter. If i remove the single quotes the wkt comes through as expected, however the single quotes are part of the spatial query so the sql fails.Has anyone got any advice on how to get around this problem?Many Thanks,