Best Answers

I am looking to adapt an existing workspace containing a feature reader that reads in an ESRI geodatabase with certain existing feature types to read and corresponding output ports for those feature types. The feature reader's source dataset path is set to a folder containing multiple geodatabases, with the particular geodatabase in that folder to be read being set dynamically depending on the fme_basename for another gdb that is read into the workspace beforehand. I'm looking to change the folder that the feature reader looks in, but keep the feature types to read and also the output ports the same - however when I try to do this and even if I specify the output ports the feature reader loses all output ports save for schema, generic and initiator. How do I avoid this?

I have an FGDB feature class which includes a "DBOperation" attribute with values of INSERT, UPDATE, or DELETE. I want to assign these to fme_db_operation but when I do this in an AttributeCreator, it gets changed to...<at>Value<openparen>DBOperation<closeparen>I've changed the AtrributeCreator to Conditional Value which seems to be happier.Has anyone else had this experience?

Hello,Is possible to inform or write jpeg_exif_xresolution and jpeg_exif_yresolution header in a jpg image created with FME Server?Thanks in advance 

Hello all FME User`s,I created a Workspace that split a attribute and create a List of attribute.My attribute: C:\\Temp_FME ENC 50124_012.zip\\50124_012.zip If take a look my Workspace the transformer ListSearch founded a wtong list attribute.My goal that i want to take: Attached my Workspace.Thanks in Advance,

I have read this: https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.htmlAnd tried to fix it with all these steps, with no luck. UPDATE: With respect to workspaces these was updated from FME Server 2015.1.3.1 - Build 15573 - win64 to FME Server 2016.1.2.1 - Build 16674 - win642017-01-24 20:12:10|   0.1|  0.0|INFORM|FME Configuration: Using Named Connection values from 'XXX' for MSSQL_ADO_12017-01-24 20:12:10|   0.1|  0.0|INFORM|Creating reader for format: Microsoft SQL Server Non-Spatial2017-01-24 20:12:10|   0.1|  0.0|INFORM|Trying to find a DYNAMIC plugin for reader named `MSSQL_ADO'2017-01-24 20:12:10|   0.1|  0.0|INFORM|FME API version of module 'MSSQL_ADO' matches current internal version (3.8 20160224)2017-01-24 20:12:10|   0.1|  0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Read 2 DEF line(s).  Found 9 attribute(s)2017-01-24 20:12:10|   0.1|  0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Opening `XXX' for read operation2017-01-

Hi I am trying to use a regular expression to split an address. It sounds relatively simple but I keep getting caught out on some of the address inputs:Here are the scenarios. So I want to split the address after the - but in these scenarios I might have a range like the second one or there might be a space after the name or there might not.On Gas Limited- 37 Hunua RoadIxom Operations Pty Limited - 135-147 Waterloo Road

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

Hello all,I have a Website that has a Links to extract XLS files:http://www.economia-sniim.gob.mx/nuevo/How can i read this Website and extract automatically theses XLS`s files?Attached my Workspace with Transformers: Creator and HTTPCaller.Thanks in Advanced,

Hi all,I am trying to write an XML with optional attributes. If the attribute is null or missing I don't want to have it in the output xml. I xml attributes, not child elements. When using the regular xml writer, all fme attributes are redirected as child elements and missing attributes are properly removed.However, when using xml attributes within a xml templater, missing attributes are still there and note removed.Any idea on how to solve this?

Hi everybody,has anyone successfully run FME with a node locked license as a MS RemoteApp? If this is possible, would it be legal?CheersGötz

Hi all, Does anybody have some experience in creating a SHA-256 hashcode via FME (desktop/server)? or in combination with third party software?

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

Hi,Does anybody know how to create a password protected (encrypted) zip file with FME?Preferably not using the systemcaller (not that protected...)Any pythonistas out there with a ready example? @takashi @david_r :)Cheers,Itay

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

I need to simply fill a hole in a polygon geometry. Is there a transformer to dissolve the geometry somehow?

Hi,I'm trying to do some reporting in Excel using FME and an Excel file as a template.The template is quite simple with some formatted fields, a logo, few combined fields.The Excel writer writes the data after the formatted rows (B12).Everything works fine, until I add a formula in the field D11 (as simple as =Sum(D12;D100)). Then, Excel throws an exception when loading the generated files and the formatted fields are no longer formatted.The exceptions I get is in french but could translated to : "Sorry... We found a problem in the file "xxxxx.xlsx" but we can try to recover data if the file is safe". After a data recovery, the data is there, the sum is calculated, but the fields are not formatted anymore (probably because of the recovery...), the logo is gone. The recovery log is stating that the is a major failure at Line 1, Col 0. Nothing more.Any ideas on what can cause this behavior ?Thanks for your help.RegardsPhilippe

Hi everybody,I am gonna use 3DForcer to reduce Z values of all points of a feature. I have a MARK_Z value attribute and need to use Arithmetic Editor so that resulting z value becomes as z - MARK_Z. (z value of every single point of a feature minus MARK_Z attribute of that feature)But I cannot get current z value in Arithmetic Editor. Any suggestion?Thanks in advance!

When I am satisified with the results shown in the data inspector, is there a way to export them rather than to start the whole model again from scratch?

Ok, so this is the situation:I have a workspace that is completely functioning in FME Desktop. In this workspace, a lot of writers are implemented, creating folders and output. Some examples:- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/Validation/Validation.html (for a html writer)- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/Delta/ (for a esri shape writer)- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/output.gdb (for a file geodatabase writer)De folder "output" already exists, but the folder "$(DateString)" not yet. The DateString is made in a small Private Parameter script.In FME Desktop, this results in all my folders being created and files being made exactly how I want it. However, when I do this using FME Server, only my geodatabase writer seems to write anything (and often not all the features that should be in it!) in my output folder. The other data is only available as a downloadlink after the run (which is not how I need it to be). Any idea h

you are integrating the download service in our app , could we we get back from the server only the URL download , without the HTML page

Hi!  In our client machine, we have upgraded ArcGIS Server to 10.5 (previously, it was 10.2.2). We also have a list of FME converters (created by ArcGIS Data Interoperability tool), FME converters are then saved as tools with ArcGIS Model Builder and a python script runs those converters every week. After the upgrade to 10.5, python script stopped working with various error messages:#! EXPLICIT_BOOKMARK_ORDER="false"#! TITIE=""#! LEGAL_TERMS_CONDITIONS=""#! MAX_LOG_FEATURES="200"There messages apper to come randomly, no logic that we could find.With the ArcGIS 10.5 version, the Data Interoperability version is also 10.5, but the FME version there is 2016.1.2 Python version is 2.7.12The thing is, that those models, if started manually inside ArcCatalog toolbox, work perfectly.As I understand, ArcGIS 10.5 needs FME 2016.1.3.Could it be a version conflict between ArcGIS 10.5 and FME version inside ArcGIS Data Interoperability 2016.1.2?Or python vers

Hi. Im new to FME and this seems like a simple one.  I have an attribute called type and within it the following values   Floor:FLR1009  Slab:SLB2435  DOR-1000  WAL-2000   I want to remove the Floor: and the Slab:  Id rather use a string renamer if possible as the Floor: and Slab: will be constant.   Thanks  Chris.