Authoring

 Which rights/configurations that a simple user (not administrator) needs to be able to Extend/Rovert FME Extension for ArcGIS on FME Integrator console ?

Hi I have a point (10 million rec) and polygon feature (9000 rec) class in SDE SQL Server 2012. I am using a FeatureReader to read the point fc, following which I need to get count of points within each polygon. This is what I get when I run workspace output doesn't seem correct:Reader format `GEODATABASE_SDE' does not support querying by spatial predicate, but supports envelope queries. FME will create equivalent results by performing spatial predicate calculations locally. Performance should not be affected.Any idea?

I am attempted to add the FMEServerEmailGenerator to a workbench on build number 17291, however I receive an error stating that I must upgrade to 177725 to use the transformer. I know this sounds pretty obvious, but another workbench on the same build number (17291) does not prompt me to upgrade.What might be causing this conflict?

I download the example from the article "Batch Processing Using the WorkspaceRunner"When i run it an the fme2018 and don't change anything it works well. When i update the workspace runner to fme2018 ,it can not work any more. I don't know why. It troubles me a lot.This is the ordinary one?Then i update the workspacerunner

Dear FME community.I've Shapefiles in GDrive with folders and subfolders. This is the workflow :1/ I read them with GoogleDriveConnector, this is the result :2/ After I use a Tester for keep the *.shp files3/ I use a FeatureReader for read the files but that doesn't works.This is the complete workflow :Do you know how can I do that ?Thank you.

I have a Workspace that I need in output create a folder and a subfolder, and in this subfolder the file needs to be saved. And after the file has been saved, I need the folder to open automatically, it can be done by the FME? Thank´s

Is there an ability to secure the database connections that are for public use so users may access them, but not have the option to change the password? We are in the process of securing all access points in our environment. I would like to have the ability to allow users to use the connections, be able to read and write to the database, but they would not be able to have access to the credentials of the database.

I'm using a web connection to an FME Server instance to call an FMEServerJobSubmitter. I would like to trigger a topic to notify an external application that the job was submitted and I would like to include the FME Server hostname in my notification. The FME Server instance that the job was submitted to is not necessarily the same as the instance that the calling job is running on, so I can't rely on the built-in FME Server Parameters.Is there any way that the hostname can be somehow extracted from an FME web connection? Happy to resort to Python or other methods if necessary. I'd like this to be a dynamic solution rather than manually defining the hostname somewhere in my workspace.

I'm used to setting my table qualifier parameter through a published parameter. This worked very well in 2016, but in 2017 it breaks as the table qualifier is automatically populated in the table name field. What can I do?

I just upgraded form Oracle 2017.1 to Oracle 2018 and now I'm having issues with Oracle database connections.I get this 'ORA-12638: Credential retrieval failed' error which is solved by changing SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (NONE) in /oracle home/network/admin/sqlnet.ora.The thing is that after applying that solution when I execute my workspace there's this Warning line in the log:Unable to determine version of Oracle database. (serverType=`ORACLE8I', serverName=`myServerName', userName=`myUserNAme', password=`***', dbname=`').It's confusing because warnings are important in our workflow.Is there anything I can do to make FME know our database version?

I have a text list of Rasters which have to be processed. How do I iterate through each row in the list and use that value as the input for my transformer?

Hi,I was wondering what happens when you upload a workspace into FME Server, is the caching disabled automatically? or is it being cached on the FME Server machine?Thanks,Itay

I am having an issue getting attributes from a custom transformer output exposed in the main workspace.The output in question was added after the custom transformer was created, but appears to me to be all in order. The Population_Base output exposes it's attributes correctly while the Meshblock_Base output doesn't. Here is an image of the Meshblock_Base properties.And finally what it looks like on the Main workspace.I can't figure out why these 2 attributes are not being exposed.Am I missing something obvious, or is there something fishy going on?I am using FME 2018.0 32 bit.

Hi - I am having an issue with FME.exe. I have two FME workbench files - one uses a workbench runner to access the other one. I have run the models successfully in the past, however, this time, the translation log hangs when the model is running. When I check the log file for workbench 1 (that is accessed by the Workbench runner - it confirms that the model is running), however the translation log is different to previous successful translations. When I delete both FME workbenches, the model still continues running using FME.exe. Does anyone have any tips on how to shut FME.exe down to stop it running? I can't access it through Task Manager.Should, in the Workspace Runner, the field 'Wait for Job to Complete' be No or Yes and does that affect FME.exe? Additionally, this model behaves differently on the computer I'm using compared to the computer a colleague uses. It works how it is supposed to on my colleague's computer, vs, the computer I am using. Does anyone have

I am trying to read in the SchemaMapper from a Microsoft SQL Server Non-Spatial table based on a where clause. The value in the where clause depends on the value from another table. So I first read that other table and create an attribute with that value. In the SchemaMapper the configuration is as follows:You can already notice that there are no options to assign an attribute value or open a text editor for the WHERE Clause field.When I run the workspace I get the following error:Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT * FROM DataOwner.[RAC_SCHEMA_DEFINITION] WHERE MAPPING_ID = '@Value(MAPPING_ID)''. Provider error `(-2147217900) Conversion failed when converting from a character string to uniqueidentifier.' A fatal error has occurred. Check the logfile above for details SchemaMapper_Mapper(SchemaMappingFactory): Could not read feature: A fatal error has occurred. Check the logfile above for deta

So I have replaced my FileGDB reader with 2 FeatureReaders (one for spatial, one for non-spatial data)What I miss now is the "Feature Read Summary" I was used to get from the "real" reader.Any way to get this summary ?

I want to "deliver" an executable form of a workspace. but not the workspace itself to a third party

I am inserting entries in two Oracle tables. I want to relate the two tables based on primary key (ID). This ID is generated as a sequence in the writer. Is there a way I can get the expected "netxval" ID, so I can set the relation ID-attribute before insertion? Or can I do this in another way?

Has anyone successfully executed an insert\\delete SQL statement to a SQL database via Python in the Shutdown Script?

Hello There we are looking to sync MSSQL DB with PostGIS DB , we used the dynamic workflow in this article https://knowledge.safe.com/articles/1050/dynamic-workflow-tutorial-introduction.html?smartspace=dynamic-workspaceshttps://knowledge.safe.com/questions/55645/dynamic-output-to-sql-server-no-table-qualifierdat.html?%CF%87ldToView=71254#answer-71254we want to do is each time we run this workspace it will update the existing table and create a new table if needed, we configure the writer as shown, the problem how we should know match column parameter in order to execute the update,

Hi there,  I've developed a FME-workspace with user-parameters. One of the Parameters is a defined "Choice-Parameter". On Desktop it works fine, the same on FME-Server.  I'm also using the Url for the workspace to submit the request in a Browser. Now it's possible to alter the Choice-Parameter with some fantastic values (Example: Choice-Parameter: "Numbers: 1|2| 3"; in URL written Value: "Numbers: 4"). The result I receive is empty, as expected. But the Workflow "completed successfully" too.  My question: Is there a possibility to force the FME-Server in a "Failed", when the defined Parameter got a wrong value?  Thanks for your help,  Greetings,  André

Hi,I'm investigating the impact that the move to remove https support for TLS1.1 and below may have on my processes running in fme desktop and server.Does anyone know what http clients the httpcaller uses?I assumed it was the client installed on the OS, but i'm running fmeserver/desktop on a windows2008R2 server with IE8 installed. If i look at a TLS1.2 only site using IE8 on this server it complains like mad because i'm trying to use TLS1.0, but if i use the httpcaller from inside fmedesktop and server it connects just fine using TLS1.2. Leading me to deduce FME installs and uses it's own client. I would like to know what it is. (libcurl_fme.dll probably has something to do with it? i also noticed an ssl certificate in the install dir.)It must pick up internet proxy details from the default browser though right?regards,Nick(specifically i'm currently running FME 2015.0, but i'm looking to upgrade to 2018.1)

Hello There we are looking to update a table with the new attribute called layer the value will be populated by searching a keyword into the attribute ( Type ) that should contain the keyword in the lookup table there is w way to do it by using the conditional value on the attribute value and writing all the key word there, but this will be a long task and not simple to maintain. since data is so bigwe are looking to use the existing excel to maintain the lockup and then search only the keyword into the value of the attribute Any suggestions?Table Dig_lcn Type Status 125 Electric network open 126 New Phone line open 127 sewer conduite intalation closed 128 Mv electric ntework closed 129 sewer renwell conduct openif the attribute value containe the keyword in the lockup table Lockup ID layer 1 Electric 2 Phone 3 sewerthen we get this Final result Dig_lcn Type Status ID L

i am having trouble "reading" the grb2 files from the workspace runner. i can run the FME script that reads and processes the grb2 files with no issue, but when i try to call that FME script from the workspace runner FME script, nothing happens. any assistance would be helpful!i can zip up and provide the workspaces and underlying data if needed.thank you

Hey guys,I have a dynamic feature reader that reads and SDE database, one of the fields is a date time field called UFI_CREATEDWhen i use a standard SDE reader this works fine on the dynamic writer. But when I use the feature reader, it appears that its sending the full attribute into UFI_CREATED.full and date attribute called UFI_CREATED. When I try and write this I get an error saying thatA feature, of feature type 'PROPERTY', had an invalid time component for its time/datetime attribute 'UFI_CREATED'.This is because its expecting the .full attribute but dynamically its getting the shortened one.I could change all the attributes that I think might be affected manually back to non full, but this defeats the purpose.Why is it mapping it like this? And is there any way I can prevent this from happening.Regards,James