FME Flow

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

I have a FME Server (2018.1.01) set up with two local engines and one remote engine. This remote engine periodically shuts down and requires restarting. I haven't found a pattern of anything causing it to shut down. Is this a known issue? I also cannot manage the number of engines for this host, it isn't listed as a host on the engines page in the web interface.

We are getting this |ERROR |ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '504' and the message was: 'Your request has timed out.The scheduled benches run most of the time, but occasionally they fail with this error. We have tried reducing the number of items sent from 1000 to 200, but still get this error when truncating and updating data to AGOL sometimes... The size of the data being updated remains the same and the update works most of the time. 

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 on this computer" So I'm at a total l

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?

Please fix this...

We use Cityworks and ESRI softwares for asset management. I am trying to update a date field in the cityworks table using a value from the ESRI SDE table. I get this error: Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `azteca.WORKORDERENTITY' to the database. Provider error `(-2147217873) Violation of PRIMARY KEY constraint 'CW_PKEY_521'. Cannot insert duplicate key in object 'azteca.WORKORDERENTITY'. The duplicate key value is (510833).'. SQL Command `UPDATE azteca.[WORKORDERENTITY] SET [ENTITYUID]=?, [OBJECTID]=?, [WARRANTYDATE]=? WHERE [ENTITYUID]=?'This is my workspace:Sorter sorts FacilityID descending. Attribute renamer renames warrantydate to newdate. FeatureMerger joins on entityuid and facilityid. This worked in older versions of FME, Cityworks and SQL. I'm not sure what changed. I've tried different things and continue to get basically the same error stating that it cannot insert a duplicate record. I tr

Hi there,we want to update our FME Server 2016.1 to 2018.1 in the next few weeks. Because of this, the server might be down for a couple of days. Is there a way of informing the users who are logged in to the server? I'm imaging a message of the kind "Due to maintenance work, the server will be down from X to Y"Many thanks in advance and kind regardsThomas

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

Howdy,In FME Server I have a Notification Subscription that send an email on job failure, I am wondering if there is a simple way to have the emial include the following:Insert text with the name of the schedule that initiated the jobAttach the translation log to the email notification or even better would be to just insert the text of any error messages.From searching the resources I found good info on the Email Subscriber and email keywords but nothing specifically addressing my questions.I did find a solution attaching a log file with a datadownload job but no info related to subscription email.Thank you for the assistance!Currently my email message template looks like this: FME transformation job {id} failed.Workspace: {workspace}Repository: {repository} Request Keyword: {requestKeyword}Time Requested: {timeRequested}Time Started: {timeStarted}Time Finished: {timeFinished} Click here for more details: http://fme:8080/fmeserver/#/job/{id}/summary Log URL: {logUrl}Log Full Path: {log

I know this question has a lot of subjectivity to it, but we are currently working on an enterprise event bus/integration architecture plan and considering FME as a central point in this new architecture. We were wondering if there might be any benchmarks around the throughput capabilities of FME Server/Engines before trying to design and run our own tests.  Obviously, there is a lot of "it depends" in this question, as the complexity of a workspace has a great deal of impact, but any starting points or information would be helpful.Thanks!

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 message about this on my unsafe error screenshot.How can I fix this?I am using FMEServer 2019.0 (19212) Beta and Google ChromeThank you for your help in advance. 

Hi FME's World! I'm trying to read emails from Outlook or GMail with my FME Desktop. I found out that it would be possible in Python, would you sugegest to use the PythonCaller or PythonCreator?I found some Python code but FME runs indefinitly at "Emptying factory pipeline".  import email, getpass, imaplib, os detach_dir = '.' # directory where to save attachments (default: current) user = raw_input("email") pwd = getpass.getpass("pwd") # connecting to the gmail imap server m = imaplib.IMAP4_SSL("imap.gmail.com") m.login(user,pwd) m.select("[Gmail]/All Mail") # here you a can choose a mail box like INBOX instead # use m.list() to get all the mailboxes resp, items = m.search(None, "ALL") # you could filter using the IMAP rules here (check http://www.example-code.com/csharp/imap-search-critera.asp) items = items[0].split() # getting the mails id for emailid in items:     resp, data = m.fetch(emailid, "(RFC822)") # fetching the mail, "`(RFC822)`" means "get the whole stuff", but you can a

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

I have a schedule that runs fine using a wildcard to find the source files. Rather than running the workspace every 10 minutes I would like to set up a directory watch (or similar) to trigger the workspace to run.  When creating the subscription I get this error: Unexpected value "$(a)/ServiceOrders/FME/NotificationDefectsExport*.csv" for parameter "value," expected list The issue appears to be using a wildcard in the source file of a subscription.I have tried with both UNC source path and by setting up a resource in FME Server. Permissions are not an issue as the workspace runs fine on a schedule.  

Hello,I'm using FME Server to write data to Smallworld. This works very fine but I encounter a problem.The alternative I'm writing to gets locked by the FME Server user (in the screenshot this user is ). Once the data is written, the alternative can't be accessed in write modus by other users. Therefore posting the loaded data to the upper alternatives isn't possible anymore.Any idea what's the cause of this behaviour? Am I overlooking something when configuring FME Server?Thanks!Luc

Hi,I have a workspace that performs a few tasks and then sends myself an email reporting the results. One email goes to my internal (corporate) email and it's cc'd to an external one (garbage yahoo account) I use for testing.I recently added another stream to the workspace and also want an email report for that one. However, I can't get it to send the external message. The second Emailer is duplicated from the original with only a change to the body text. Emailer 1 still sends both. Emailer 2 sends the internal version but not the external. How can it work in one case and not the other from the same workspace?Thanks Notes: I have also tried using a non duplicated Emailer and swapping the To: with the CC.

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  

Hi there!When I update a Destination File Copy Folder from a Workbench and I publish it to FME Server, the changes aren't made into the Notifications/Subscriptions. (green arrow)Is it normal? Is it just me? In any case, it's anoying, I've got to do it manually.I have FME Server 2017.1Thanks

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?