Architecture

I have several excel sheets that have same/similar structures, although some are missing their header names. I can migrate them to SQL Server one-by-one using FME. But I want to loop over the contents of my folder (i.e the excel files) and migrate them all in one go. How do I loop over them? I want to use the same header names for the files missing them as the ones that have them - the header names.

Hello everybody,please, Im trying to solve problem with FME license server. As I checked, there is possibility to restrict one floating license for specific usergroup (check there https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop_Admin_Guide/FMEInstallation/Restricting_Licenses_to_Users_or_Groups.htm). But, and its my question, is there any possibility to set exact usage time for specific usergroup?E.g. Just imagine FME License server with 2 floating licenses. I just wanna to restrict one license for usergroup called "GIS" only for daytime from 6PM till 6AM. From 6AM till 6PM, both licenses should be available for all users (doesnt matter of what usergroup). Is there any tool how to set it up please? Thank You so much for all ideas!Lubo

Hello, So I have an issue. I'm trying to run a workspace at work but there ar no standard arcgis licences avialable. So fme tries to use the arcpro licence. It gives this error: Unable to load a library in the folder: C:\\Program Files\\ArcGIS\\Pro\\bin. The error number returned from GetLastError is: 127Arcpro is set to work offline and there are plenty licences available. Anyone has an idea of what might be the issue. Also, arcgis 10.6.1 is installed with the right version of background geoprocessing and the version of arcpro is 2.3.0. Thanks,Simon

Was previously running Windows 10 Pro build version 1803, until yesterday when Windows decided to update me from build version 1803 to build version 1809. This update seemingly has deleted FME Desktop application, though the other FME application such as Data Inspector and Quick Translator are still present.I launched FME Licensing Assistant 2018.1 and tried to enter in my Home Use License serial number into the Single-Fixed-License field. But it returned this error.""Invalid trial activation codeThis trial activation code has already been used to generate a license. If you wish to obtain a new trial activation code, please visit www.safe.com/trial.""  The license if valid for one year from 09/07/2018. So my license isn't expired either. I also tried pointing the FME Licensing Assistant 2018.1 to C:\\ProgramData\\Safe Software\\FME\\Licenses since the license file still exists. That returned "License not valid o

Hi, I have a oracle database connection on the FME Server, the fme script runs fine from FME server if the connection is used for reading but when I try to write to it, it does not work. From SQL plus on FME server do not have any problem reading or writing. See the error log below: What could be the problem here?Thanks,VijayUsing Oracle Writer to write tables to database `', server type `ORACLE8I', server name `TAMSPROD.WORLD', user name `GEOMEDIA', password `***'Oracle Writer: Starting at transaction 0 with a transaction interval of 1000Loaded module 'OCI' from file 'OCI.dll'Unable to connect to Oracle database, because the database environment could not be initialized.Unable to connect to Oracle database, because the database environment could not be initialized.Destination Feature Type Routing Correlator(RoutingFactory): Unable to connect to Oracle database, because the database environment could not be initialized.=-=

We have a single instance of FME Server shared across multiple utilities (i.e, separate finances). We recently purchased an additional engine for one of our utilities, who has been consistently using the engine owned and paid for by another. Even though they now have their own, this utility's users continue to use the engine owned by the other utility, which hoses up that utility's jobs. Is there any way to limit engine access by user so that each utility's users can only see the engine specifically for them?

Hi!I'm in a university environment and we've installed FME in two computer labs. Since there are many computers that needs to be licensed through the licensing assistant (we're using floating licenses) I wonder if there is a way to do this process on several computers simultaneously instead of doing it one by one.Thanks in advance!/Henrik

Hello.I have a hard time with SLL configuration.I was following this Configuring for HTTPS I finish all steps without any error messages, however, when I try to open FMEServer by using HTTPS I receiving an unsafe window errorI have also edited all files as it was shown in the above-mentioned guidelines. Certificated also were added in the windows trusted certificates list. I am non-SSL guy but can the problem be that the installed certificate cipher suite "AES_128_CBC " is an old version and must be replaced with new "AES-GCM" cipher suite? I have marked the m

I cannot find what my current license serial number is to input into the upgraded 2018 FME Server license area. the temporary works for 7 days but want to use the license i had for 2015 server on 2018 server, 

Does anyone know if a "how to" article exists to instruct users how to setup and apply an FME Desktop FME ArcGIS Data Interop Edition licence? A description of how to add the licence to FME and then how to enable the licence over in ArcGIS as well as the requirements to ensure the ESRI Data Interoperability extension is licenced? It feels like something that 'should' exist but I can't find it. I've had a client ask for a reference document and I wanted to forward a link... It appears this might be an oversight from the docs and the KC. In Robyn's 2nd paragraph here she references it https://knowledge.safe.com/questions/21547/arcgis-data-interop-vs-fme-ext-for-arcgis.html.Thanks in advance, Dave

Need to get job run time.

HI,I use a FME Server 2016 to run different workbenches. For the update on FME Server 2018 I have to upgrade these workbenches, too.Therefore I upgrade all transformers, which are upgradable. With the dissolver I get some problemes:old workbench:new workbenchIn the new workbench I get less objects then in the old workbench, but the result must be the same.The new dissolver has the addional parameters: Connect Z Mode, Tolerance and Aggregate Handeling.Which are the correct configurations the get the same output like in the old workbench?  Thanks and best regards  

I have a workspace that runs on FME server and uses a HTTPCaller to call other workspaces. I haven't used FMEServerJobSubmitter because FMEServerJobSubmitter needs to be set to just one workspace which fixes the set of parameters and I have lots of options for which workspace actually needs to be ran depending on earlier results/settings . I'm using a JSONTemplater to put together instructions for the HTTPCaller to run whichever workspace is needed. The problem is that this uses two engines: the HTTPCaller starts another engine while the original workspace waits for it to complete. Is there any way to have the option of many child workspaces to run and only use one engine like FMEServerJobSubmitter does when there is only one possible child workspace?

I'm having some weird behaviour with my FME server in the Cloud that I could not explain.We are using a server that has three active engines and the following Queue-system:This morning we had a workflow in our production sync queue that took way to many resources and time to process and was aborted. Somehow the server had some problems after (or during/before?) this because all new jobs where not properly handled and all got queued in line. Only engine 2 took was able to start new jobs even tho the other two engines where free and not running. With a unstable and high load as result (20000ms response time and server load of 100) and two engines IDLE. To compare it: Normally our response time is 5ms with an average load of between 0.10 and 0.50.A reboot was needed for the server to stop the load en activate the other 2 engines.

Hello FME community,I’m developing a FME service that needs to process a JSON object, uses this JSON as upload body in a HTTPCaller that returns a ZIP file and emails the user a download link to the returned ZIP file.What is working is a POST to datadownload service with a JSON upload body and the email as request parameter:https://<fmeserver>/fmedatadownload/Samples/WritingZip.fmw?SourceDataset=&DestDataset=DownloadZip&opt_showresult=false&opt_servicemode=async&opt_requesteremail=test@test.comWith a subscription at the DATADOWNLOAD_ASYNC_JOB_SUCCESS topic I retrieve the desired mail with the download location using this template:https://<fmeserver>/fmedatadownload/results/{@getFileName(OutputLocati

Hi dear Is ist possible to get a list of used values in an Attribute?I have data in the inspector (100000 an more) and i will know which values are in one Attribute used.thanks for an answer. 

Hi all,after upgrading to FME 2018.1 we are not able to connect to MS SQL Server anymore. This seems to be due to an invalid connection parameter:Using Java Reader Interface Version 2.0 (Oct 31, 2000) with module MSSQL_JDBC_SPATIAL to read dataMS SQL Server Spatial (JDBC) Reader: Preloading JDBC Driver Class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'MS SQL Server Spatial (JDBC) Reader: Creating connection using connection string 'jdbc:sqlserver://************' and properties '{statementPoolingCacheSize=10, disableStatementPooling=false, integratedSecurity=false, user=************, encrypt=false, multiSubnetFailover=false, trustServerCertificate=true, applicationName=Safe Software FME, database=************, password=************}'com.microsoft.sqlserver.jdbc.SQLServerException: The disableStatementPooling value false is not valid.However, I don't see an option to control statement pooling on the connection or reader level.

Hi,Currently we are using FME on Win 2008 R2 server, we are planning to move to WIN 2012 R2 server. Please let us know if we can use the same FME license on WIN 2012 R2 server and if not please provide the contact from where we can get the updated license file.

Why do i have to specify the source en result data in the Jobsubmitter while that`s already in the workspace

Hi,I have 5 fixed licenses of FME Desktop Smallworld Edition.Is it possible to install FME on to 5 virtual instances, that any user within my team can remote in to and use? I understand this would be limited to one user per instance. Therefore meaning the license is on the node, not on a named user?In an ideal world, we would have floating licenses, but this is not possible. Thanks,Steve

Have ArcGIS Pro 2.2.4 installed on an AWS box with the "Data Interoperability" license but on the Analysis ribbon, the Workbench icon is grayed out and says "This command is currently disabled. Authorize and enable the Data Interoperability Extension to access this functionality." Been on the phone with Esri and they want me to switch from a Named User to a concurrent license but that is not an option right now for me. They are thinking the remote desktop is blocking the license somehow and to try using Process Monitor to find the issue...not much fun! Anyone else have this issue? I know this is more an Esri issue but not making much progress on that end. Side note - I have ArcGIS Pro installed locally as well and do NOT have this issue. Trying the leverage the super duper Graphics Bundle we ha

Hi,On the FME Server trial download page, if I choose the win-64 option, my browser starts downloading FME Server 2017.1.2.1-b17725. But reading the Licensing Walk-Through, I get the impression that I can request a trial license for any version of FME Server starting from main version 2016 and later versions.Question; Will I be able to download and install FME Server 2018.1 from the customer download page, and request a 60-day trial license for my FME Server 2018.1 installation by following the steps in the Licensing Walk-Through? Or are 60-day trials only available for FME Server 2017.1.2.1-b17725 specifically? 

How to check validity end date of FME license?

The FME Knowledge Center will be undergoing an upgrade on Tuesday, Oct 30 at 4:00 PM Pacific Time. This will involve a site outage of about 30-60 minutes. Apologies for any inconvenience this may cause.

I am using FME Server 2018 and FME Desktop2018. My goal is to get informed and run a workspace, if a change was made in a specific directory. The FME Server has no internet connection, so I need another solution than the email-notification. My plan ist to run a directory watch by the FME Server and trigger a workspace to start running on my FME Desktop, which opens a command line window with a message inside.The other workspace contains a geocoder transformer, so an internet connection is needed. As I mentioned the server has no connection to the internet, so it definitely has to be executed on the FME Desktop.Is it possible to run a workspace with FME Desktop, initiated by the FME Server? I thought I could add a network-based resource to get access to the .fmw, but in the subscription options I am only able to add workspaces stored in the repositories.Any ideas?