Authoring

Why when I copy and paste readers from two open .fmw files do those readers become misnamed and unusable?  Why does the "enable/disable readers/writers" form not have any visible effect when I uncheck/check the boxes in the form and click okay?

I have 100 tables.In each table, there will be 9 row of records stored with unique ID like { 1,2,3,4,5,6,7,8,9 }Need to log if there is any missing row in those tables with Unique ID.For eg:Below the table, there is missing row 4 and 7. need to find 4 and 7 row.Please advise how to achieve this task.Thanks in advanceVenu

HiAny idea of the best method for using the Arcpy library without changing the interpreter to ESRI?Thanks

I have multiple rasters, which I want to merge. These are scanned maps, in different pieces, georeferenced afterwards. Files are jpg, together with jgw (for georeferencing)I "simply" want to merge them into one file (again, jpg with jgw), so that I have one map, one jpg.Rastermosaicker and rasterbandcombiner are not ideal, as the maps have completely different height, width and rotation.Printscreen of the overlapping maps, after georeferencing in FME data inspector.It looks quiet easy, but I can't solve it :(Result after using the rastermosaicker in FME data inspector.Thanks for giving me some hints here!With kind regards,Ine De Cubber

Can these passwords be extracted from the workbench files? I am concerned from a security standpoint.

We're getting this error when trying to import a module:"Using user-specified Python interpreter from C:\\Windows\\System32\\python27.dllPython version 2.7 successfully loadedAdding folder `xxxxxxxxxxxxxxxx' to the python pathEmptying factory pipelinePython Exception <ImportError>: DLL load failed: The specified module could not be found.Error executing string `import fmeimport fmeobjectsimport arcpyimport lxmlimport sys#sys.path.append('C:\\Python27\\ArcGIS10.3\\Lib\\site-packages\\lxml')from lxml import etree..................."It is okay when I just have: import lxmlWe've imported lxml using a Windows exe to the version of Python in the registry which is: C:\\Python27\\ArcGIS10.3When using this version of Python outside of FME it works fine: we can do 'import lxml' and also 'from lxml import etree' I've tried adding the path to the module to the end of the PYTHONPATH environment variable.

Hi,I am quite new in FME and I have a bit of hard time with nested loop. From a Tester transformer (Tester_2), some of my data could pass my stated condition and some couldn't. In the attributes of passed and failed data, there is a field that contains different values and some of which are identical in the both output date from Tester_2. The values are integers and the name of field is vegdekke_objectid.What I want to do is to use the failed data and cross-check them, feature by feature, with the features of passed data based on the field value (vegdekke_objectid). In doing so, I was thinking to create a loop transformer by means of Custom Transformer and have a Tester transformer within the loop. The loop then would iterate and compare one feature at the time in the failed data with the features in the passed data. If no matching value is find for a feature in the failed data, then the feature is considered as the output of the loop transformer. Otherwise, the loop reads the next

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!