Authoring

Good day.I faced the problem with running jobs on FME-Server. Periodically (not always) jobs are crashed with status message: "The Workspace requires Python version %0, but Python version %1 is already loaded". I absolutely confused, because if I start this WB again the process will be completed successful.ArcGIS and FME-Server installed on this machine together and as the custom python the Esri ArcGIS Desktop (Python 2.7) selected.Who knows how to overcome this problem?Thanks in advance.

Hi,  I would like to create 72 features with predefined ID and NAME attributes for instance:  ID    NAME 689  Kativic 711  Monts et marées 712  Charlevoix ...     ...  So far I used the creator (1 instance) followed by AttributeCreator where I added all IDs separated by a coma into 1 attribute. Then I used the AttributeSplitter to create a list on the IDs and finally the ListExploder.    The result is ok, I have one feature with the ID, but I cant find a way to have the NAME attribute also attached to those features. Instinctively, I would use a JSON key:value list, but I am not sure how and if it is the correct solution.  Thank you for your help 

I am running fme from cmd and while passing command line parameters to run workspace I use cmd.exe at the start e.g. fme.exe C:\\Maps\\OraDWG.FMW --BoundaryName PTCL526 ...and if I use a same command but without using .exe in command like -fme C:\\Maps\\OraDWG.FMW --BoundaryName PTCL526 ...It's still running the workspace.So my doubt here is that what is the difference in using .exe? Does it use extra floating license instead of using one that is dedicated for this workspace. We have few more floating licenses.

FME(R) 2019.2.1.0 (20191202 - Build 19813 - WIN64)Hi,Int the following reference - https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Running_a_Batch_Translation.htmUnder the heading - Running a batch translationThe following is stated;For example, you can apply an existing workspace transformation to a large number of input files, and produce separate outputs for each.How do you implement this, ie output to sepate output files?I have set up Batch Deploy to use a folder as its source.I have Run my workspace using the Batch Deploy method, but it continually overwrites the single file.Ben 

I'm having trouble with a relatively simple task - I want a field to be a specific data type (DOUBLE). The source for the values is a text field with a number (comma separator). However no matter what I try (e.g. creating a brand new field with @Evaluate(@double(@Value(MYTEXTFIELD))) or replacing comma with dot beforehand), it ends up as (as seen by ArcMap) text. StringFormatter didn't work either: the decimal option gives me (textual) scientific notation - yuck! Give me proper decimals or give me DEATH!

I have asked similar questions before and tried loads of different solutions. It seems like such a simple thing, but so far I have not been able to get the result I want. I thought I would try and start clean, maybe this can help me make sense of this.Imagine a dataset where some of the features are overlaying. (There are more attributes than those described, varius sources and not all features are overlaying.)In this dataset I want to identify polylines that are overlying and merge certain attributes from them. Feature Attribute A Attribute B Attribute C Attribute D1 A    2  B   3   C  4    D  The desired outcome of the four overlaying features above would be a new feature with the following attributes:newFeature A B C D  Empty cells should always be filled if possible. A kind of dissolver of attributes.How would you experts go about achieving this?

I have a Workspace running fine in command-mode, but I am not able til create a Batch Deploy. Function is dimmed...What am I doing wrong?@Anders_d

Hello,  I create a workspace with a parameter "COMMUNE". It's use with reader to select a city (Grâce-Hollogne) and also with writers Excels and DWG. The file name use this parameter  "OSP3-2020-$(COMMUNE)-Tableau ELYX_REJET_$(TIMESTAMP).XLSX""  FME Desktop 2019.1 sent me the Error Message below because the special character â is not handle.   I"Excel Writer: Failed to save changes to the spreadsheet '\\savip-fsapp02.tecteo.intra\GIS_METIER\FME_29\Output\EXPORT\EP\PROD\OSP3-2020-Gr<u00e2>ce-Hollogne-Tableau ELYX_REJET_20200122.XLSX'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Invalid argument.'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ..."  Can you help-me?  I can change the name of the city. In FME 2018.  I had this issues. It's very important in our processus. I'm from Belgium where ot this type of character is common  Best Regards

Hi,My organisation recently upgraded to FME 2019.1.1.0 (20190801 - Build 19617 - WIN64). Since the upgrade, several of my workbenches come up with the following error: When I click 'debug the program' the following message pops up:I saw a couple of post here from 2016 with the same question, but without solution. It was suggested to turn the debug logger on, which gives me the following error warning:BADNEWS: File C:\\Program Files\\FME\\metafile\\MULTI_WRITER.fmf could not be opened class StatusInfo *__cdecl TableReader::checkStatus(void) const(c:\\code\\fme\\foundation\\framework\\engine\\tabrdr.cpp:169) - class StatusInfo *__cdecl TableReader::checkStatus(void) const(c:\\code\\fme\\foundation\\framework\\engine\\tabrdr.cpp:169) Any tips or ideas on how to fix this?Thank you

Hey all,Having weird ArcGIS Online Authentication issues with 2019 b.19813. After I push up authenticated credentials to FME server for ArcGIS online, and after a random short period of time (day of, an hour later, day later, etc...)  FME Desktop becomes inoperable with ArcGIS Online. Meanwhile, the same credentials and authentication token are currently being used on our Server Machine and FME Server 19813. Python settings for desktop and server are 3.5+. I have noticed some already configured transformers double wrapping attributes with spaces in their names. I wonder if this is happening with my connection name: 'aarcra Esri ArcGIS Online 2019'... and the error occurs regardless of the '2019' in the name or not.  The error message returned from FME when trying to access AGOL schema's or data in FME desktop is:Python Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.Failed to obtain any schemas from reader 'ARCGISONLINEFEATURES' from 1 

I'm have a workspace whereby I get constantly new and updated data from the client. Based on what the data is I'd like it to fan out to it's correct GDB. The GDB's from the client come with all the data in one.E.g. ENV_BadgersENV_GCNsHIS_MonumentsPRP_LandAcessThese need to be moved into their corresponding GDB'sE.g.REF_ENVREF_HISREF_PRPMy current Method is just to move them based on GDB, and I also use the Insert, Create If Needed function, then the Insert, Truncate Existing. I've found if I used Drop and Create the workbench will break if there is new data (nothing to 'Drop'), same stands for Truncate Existing. So two problems:Fanout data into existing GDB based on name Import new and updated data without having to run twice for Create and Truncate.

Hi :)   I have a question - how do you handle errors of workspaces on FME Server (connected to data, or workspace errors not with FME Server)? My question is connected with the fact that none of the final users of scripts published on FME Server are familiar with FME, and that FME Server logfiles aren't that legible, so I would like to write my own error messages that are simple and easy to understand for final users. The perfect solution would be that author of script would be able to write conditional error messages - If this goes wrong send that to user. Is it possible? Do you know how to achieve something like this (or something similar) ?

Hallo everyone,to help my coworkers update some eodatabase, I created a FMW workflow that translates the data from an excel file and that automatically updates the datas in the geodatabase. So far all good, the workspace does his job.In the workspace I had to define two readers, reading basically the same file (excel spreadsheet) to get first some attributes in the "header part" and the rest of the attributes in the "body part". There is only one writer to the geodatabase.Now, I don't have much experience in programming but I'd like to write an small programm (C++? Python?) that allows my coworkers (who dont use FME at all) to select the Source excel file that will udate the attributes in the geodatabase (possibly using a file browser) and the directly run the fme workspace i created. So they'll only need to open the program, browse to the excel file and the fmw workspace will read it and use it to update the geodatabase.Could you please point me in the

I'm using FME to read, modify and write data to a oracle database. My queries are working fine but the following error is popping up for every SQL query .  ERROR |BADNEWS: An error occurred while fetching from query OCI_NO_DATA StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) - StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661)What is it complaining about ? instant client or oracle database ?version detailsUsing FME 2019.2.2.0 versionMac OS X VersionOracle database version is '12.1.0.2.0'instantclient_19_3 Any help on this would be appreciated.

Hi,  I have a 2 sets of features, points and lines whith a common project ID (sewerprojects). I have to perform many actions to get my result. In ideal circumstances i could do this immediately on the entire dataset but because it's a collection of data from different projects, there are no unique ID's and some lines and points are duplicates. I wanted to start with the topologybuilder to create correct small networks per project with unique ID's for the point and linesCan i run my whole dataset per project ID and write alle projects to the same writer? I have found a custom looping transformer but i can't figure out how it worksThx!Nathalie 

I am attempting to update the building object in smallworld via an .xlsx doc and am returning the following error after the workbench processes 2630 rows...  Smallworld Translator Error: Object unset does not understand message pressure There is no "pressure" attribute in either the .xlsx or the smallworld building object, so I am confused...  

I have a set of features with name and value attributes that need to be written to a file, but only if certain conditions are met. i.e. one or more of the values meet certain conditions. If one or more of the values satisfies the condition, then all the features need to be written to the file. Is there a way to set conditions on one or more feature, that if satisfied, will allow the entire set of features to be written to a file? Example below:If minimum relative humidity <= 25 or the KBDI > 600, then write all the features to a six features to a file. 

Whenever I run my child workspace by itself I get correct results on my translation written to a SQL Server table.If I run this workspace from its parent workspace I lose attributes coming from a specific output stream going into a featuremerger with multiple suppliers..Top picture is result from child workspace; bottom is if child is ran from a runner. At the bottom I lost values to HTTP response success, FeatureLayerCount and Selected Features.These 3 attributes come from junction 6d: Workflow stats. I added a Feature holder before featuremerger hoping that can solve the issue but it did not.Seeking ideas or anyone who have similar experiences with workspacerunner.Thanks! 

I'm getting this following error while connecting to oracle database and reading shape and metadata from oracle table2020-01-23 14:34:22| 2.1| 0.0|ERROR |BADNEWS: An error occurred while fetching from query `SELECT SDO_VERSION FROM DUAL' : OCI_NO_DATA StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) - StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661)For every sql query in the workspace, I get following error message ORA-01002: fetch out of sequence StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) - StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) Query runs fine and fetches result but there are a lot of errors I notice. Is this complaining about Oracle Instant Client ? Any input related on this would be appr

I've just had a support request which reminded me of an issue I had a few months ago using a looping transformer to page through HTTP requests, where I was ending up with more data than expected. The cause was the reusing a list attribute and I'd like the communities opinion on whether this behavior is a bug or just something to be aware of.You can see what is happening with a simple workspace likewhen the _list attribute is reused in the second AttributeSplitter it is not getting cleared before hand so it is retaining the 4 and 5 from the first AttributeSplitter.It's easy to correct once you know what is happening but it can cause some head scratching to debug, particularly in a looping transformer. Should anything that creates a list clear out any existing data first or are their situations were this behavior is wanted?

 Hello guys i am still new ,may be the question is basic but i need help .after i knew which is passed or failed ,i want to make condition now .if passed has output so mergd passed and failed together (i mean i want to have the original input again then connect with multipe transformers to do something but if has only failed and passed has no output , so merge also but go to another multiple transformers to do sth. else .thanks for help

Hi!I have a workspace that I want to stop with a terminator if no features leaves a transformer. I have tried to download the "NoFeaturesTester" transformer from FME Hub but nothing happens when I try bringing it into my workspace. I have downloaded plenty transformers from FME Hub earlier without any problems.

Hi, Goal of this workbench was to be able to expose the property sets attributes of a Civil dwg, without knowing the attribute names. I am only interested in the property sets starting with a fixed prefix. I have started from some python code I found here: python attribute namesTopic is related to:https://knowledge.safe.com/idea/18842/bulkattributeexposer-expose-all-possible-attribute.html https://knowledge.safe.com/questions/32777/how-to-expose-all-attributes-in-generic-way-any-ma.html  Since I don't know the attribute names beforehand, I have to use a dynamic writer. First I was trying to avoid this, since I am not familiar with the dynamic workflow, so I was writing everything to a json string, so that I was able to write all desired output. But now I am trying to use the dynamic writing functionalities.I have 2 questions:1/ the attribute names in the shapefile output are too short (have a length of only 1-3 characters). How can I fix this?2/ Is it possible to put all exposed at

Hello,I'm stuck and I hope someone can nudge/push me in the right direction :-)This is a table where I keep the "Aanschafdatum" (purchase date), "Afschrijftermijn" (depreciation period), "punten" (points), "JarenInGebruik" (Years in use).I want to set the "punten" in the columns 2019, 2020, 2021, 2022, 2023, 2024 and 2025 according to "JarenInGebruik". Here's a little example: Is that possbible? If so, what are the transformers that I can use?Was thinking about AttributeCopier but I can't get my head around the others... TIA-Jonathan

i have name with special characters so i need to select which is containing special characters.NamesÇaõeshLoõeshNaveeõSaÇdaÇNaggattuHigh way 54Local-Street  Select like yellow highlighted data only Note Exclude: Pure numericPure AlphabetsCombination of Alphabets, numeric and Spacescombination of Alphabets, numeric and hi-fen.