Creating and organizing workspaces. How to use Workbench.
Recently active
Hi, I have a IIS web server on the same machine that FME Desktop is installed. On the web server a php script calls a FME workbench using "shell_exec(same_as_batch_text)", and the workbench executes. The problem is that FME can't connect to the database when the command is being sent through IIS and php. I have followed the information on https://knowledge.safe.com/questions/61651/fme-failing-to-run-from-a-batch-file.html without getting any further. This means: - My database is made public. - The default paths are moved to a location with common access.Any suggestions? The log:2020-03-25 16:21:58| 0.7| 0.1|ERROR |Internal Error: Unable to access connection database
I have a folder containing 77 Esri Layer Files. I would like to consume each of these 77 layer files and then write them into SDE. I have a dynamic reader/writer workflow setup. Dynamic Reader is set to read the folder with the features in question, then a Feature Reader, then the Dynamic Writer into SDE. Currently the workbench is attempting to merge features together. I want the workbench to read one feature, dynamically write the feature/schema into SDE, then write the next one, etc. I have tried the WorkspaceRunner without success. Maybe this is an option and I have it misconfigured?
Greetings, I’m needing to loop through a list of zones and run a series of calculations and spatial intersections that require a rather lengthy model. The trick is I need the model to still grab the next value in the list and run all the calculations accordingly. The only way I know to do this is to use a workspacerunner and call a separate workspace containing the list each time I need the next value. This seems highly inefficient so is there not a better way to setup a single workspace and have it loop through the list at the beginning, run all calculations, and proceed to next value in the list?
We recently installed FME 2020 we get the following error message when running workspaces with a Python Startup ScriptPython Exception <ImportError>: No module named fmeobjectsFailed to import `fmesite' System setup:Microsoft Windows Server 2016 StandardFME Desktop 2020.0 64-bitArcGIS Desktop 10.6.1ArcGIS Desktop Background Geoprocessing 10.6.1 (64-bit) + ArcGIS Desktop Background Geoprocessing patch for Oracle 19COracle Client 19cOracle instant client 19.5 64-bitWorkspace settings:Preferred Python Interpreter: Esri ArcGIS Python 2.7Python Compatibility: Esri ArcGIS Python 2.7 The problem doesn't occur in our previous version (FME 2019.2.2) with the other settings the same, so it seems it only occurs with FME 2020.Any idea how to fix this?
Somewhat simple question that I have not been able to find much info about: is there any possible way to set the max number of features per feature type in a FeatureReader? Or, is there any sort of workaround to have the same effect?
Hello Everyone!I have an issue with connection to OneDrive account via OneDriveConnector (Graph). During configuration of parameters this transformer I set new connection to OneDrive. But when I tried to open this account and choose file or folder, which are in my account I get an error: And FME FME cannot see any contents that are in this account: And in log I have:Python Exception <ModuleNotFoundError>: No module named 'webserviceconnector.webserviceconnector'; 'webserviceconnector' is not a packageThe python function `fmemodules.lastError' was not found. Check your python path & module importsI tried:to choose other action (Upload, Download, List) to connect with other OneDrive Accountto use other version of FMEAnd every time I get the same error. Did anyone has a similar problem and could help me? Thanks in advance!
Hello Team, I have installed new FME Server 2019.2 and published my existing workbench.When I ran this workbench from server I am getting following error, Could somebody help me to get out of this error, I have a start end shutdown python scripts embedded with the workspace. 2020-03-23 08:42:19| 21.5| 2.8|ERROR |Python Exception <ImportError>: No module named win32com.client 2020-03-23 08:42:19| 21.5| 0.0|ERROR |Error executing string `import arcpy, fmeobjectsclass mmLicenseStatus: mmLicenseAlreadyInitialized =0x32 # from enum mmLicenseStatus mmLicenseAvailable =0xa # from enum mmLicenseStatus Present I am using deprecated version of python27, If I want map with latest version of the FME then what could be the process for it. Thanks in advance.
I am new to FME ...simple question. I have a Feature Writer, which I would like to name with the value from the attribute (@Value(myattribute)_example.dwg) that I can see is there from the logger, but the writer fails to find the value of the attribute, it only creates an empty file with "_example.dwg" with the geo features and an empty file with foo_example.dwg ... I am able to use the reader with file name from @Value(attrr) (I am using the latest version FME desktop trial 2019.2.3.1) I would appreciate any tips ...thanks
Not sure if this is a bug or I'm just doing it wrong.I've got a FeatureWriter that does an Update on a SQLite Table, and then follows this by doing an Insert on the same SQLite Table.It doesn't work. The Update operation runs, but the Insert doesn't. If I split the FeatureWriter into 2 separate FeatureWriters, one for Update and one for Insert, then it works.Is this just a limitation, a bug, or I've set this up wrong?
Hello FME community, I have never used FME to scrape web pages but I am looking to do so but I don't know where to start. The web source I am looking at provides country-specific COVID information.What I would like to do is scrape each of the country links provided on the site and pull data into a tabular format. Eventually, I would like to join this data to global admin boundaries.Would this be possible using FME? Does anyone know where I could start? Thanks, FME Family!
Hi, Anyone knows how to pass a different file path (parameter) in Batch File?I am calling my fmw in a batch file however I cannot change my source and destination path.
So we have FME Desktop installed in Citrix, so a multi-user environment. We have the named connections store file located on the file system with a lot of pre-defined connections in it, mostly database connections. So we give users read access to the folder the named connections store file located in, so users can use the named connections we have set up. Some of our users have AGOL connections they want to set up, these are private to themselves, but they want to use these in conjunction with our other pre-defined connections, so they all need to be in the same named connections store file as far as I knowSo the issue is, since we have only given most folks Read only access to the folder (we like security), they cannot themselves create their own private AGOL connection in the named connections store file. Temporarily giving the user read write on the folder where the connection file is, so they can create their AGOL conn would probably be the logical solution, but the way we manag
We are suddenly having issues with FME.exe that are not terminating.It does not happen every time either, about twice a day (runs every 15 mins for 20 hrs a day) Log shows everything is Successful, but FME.exe is still running.The workspaces we are having issues with are all using S3 transformers. The upload or downloads are working correctly, but the EXE is not ending. We are running FME(R) 2018.0.0.3 (20180430 - Build 18305 - WIN64). We have not upgraded to 2019 due to an issue we had while testing large file sets. 2020 is in the future, but we need a solution sooner due to a business critical dependency.
I have 150+ word files which have the same layout. I want to add a section in all of these files. Is it possible with FME? Similar to the XMLReplace in XML-files?
Hello everybody,I found out that FME includes machine learning in the 2019 version so I start exploring and I found a few great examples.I read this article and it was great. I have one task and if anybody has some ideas, some tips, some suggestions, I would be grateful.The task is: I have 2 satellite images (panchromatic has 0,46 m spatial resolution ) and ( multispectral image has 1,84 m spatial resolution ). I want with machine learning methods classified roofs on the image ( i want to figure out roof orientation, roof area and roof slope ).
Hello, I am working in a workbench for exporting layer from Oracle Spatial to a FileFeoDb, taking the layers to export of a configuration excel. I've already done it, but now I need to configure the alias of every feature class I manage in the process I have searching for a solution but I cannot find anything. My expertise un FMW is not very high, so I need some advise on this...I'm thinking in aggregate aliases in the same way I did with layer names, but I'm not really sure where to configure the attribute generated contained all aliases aggregated. thanks!
With the rise and spread of the novel coronavirus (COVID-19) over the last few months, there have been many changes around the world and adjustments we’ve had to make in our local communities.COVID-19 is affecting us all, and we don’t want software licensing to prevent solutions from being found or communities from being protected.In an effort to help with the current state of affairs, Safe Software is offering FME for free until at least September 30, 2020 for those trying to investigate COVID-19 and learn how to better support their communities.We will also be offering extensive, free support to help you with your COVID-19 research and projects. With more Safers available due to the cancellation of many World Tour stops and tradeshows, we will be devoting our time and knowledge to aiding in your COVID-19 efforts by prioritizing these support cases and questions.For more information, please check our website here: https://www.safe.com/covid-19/
Reader: MSSQL_ADOWriter: Esri File GDB Feature classTransformer: AttributeManager I am trying to see if I can first set a Where Clause to check if two fields (one from the SQL table and one field from Feature class) match each other. Once this is checked I want to update three other fields in the feature class using the information in the SQL Table
Somehow I have lost my ribbon in FME. How can I turn this back on?
Himy question is if one can use a template file in feature writer with excel as output format/F
i have two excel writer but i want to have one excel output has both of them as seperated sheet so i used fme_feature typebut it still give me output as two excel file , i do not know why i used attribute creator then attribute filter to get two seperated sheet but it does not work with me i used sheet name @Value(fme_feature_type)and also edit parameter fan out and overwriting yes First excel writer : because i have many seperated tables so i used output field name NOUSE ATTRIBUTES NAMES AS COLUMN POSITION YES i have A B C D AND SO ON NAME OF COLUMNS so my question should i used attribute creator for fme_feature_type before connects to excel writer direct and so excel writer will recognize fme_feature_type or should i enter it in each table that i divided i tried both of this metthod but i did not get my expected output second excel file utput field names yes and use attribute names as column position no whatever i did not have many tables in this excel sheet so i do not want
I am sure this is probably covered in another post but can't seem to find the right solution :)I have a list that I have exploded into its elements. I have polygon layer that I need to add each of the names as a column in the polygon table so that I can put a value against each polygon for each column. i.e.PolygonID, Advertising Near Signalised Intersections, Affordable Housing, ...., etc
I am doing my first experiments with ArcGIS Portal Feature Service Reader.I run into some strange behaviour in Workbench with editing its parameters and wonder what I am missing out on, or if we have some problem here ... I add a reader (old style) and try to publish settings I want to keep variable. This works well for all settings except for the "Feature Service:" setting. There is no way to edit this in Workbench Navigator, and it is not editable in the Reader settings once it is created. I try the same with a Feature Reader (new style) and voila I can publish "Feature Service:" as a parameter. Small trap here: I can only set it to a predefined parameter and the option to create one is missing in the dialog ;-( Problem with this variant: I can't set Search Envelope coordinates as I can do with the old style reader. Seems like there is no way to have all parameters published I want and I need to choose which variant from above comes closer to what I need ? T
Hi partners,Here's a round-up of some of the March updates so far: Two new subscription pages have been launched on safe.com. As mentioned in our February bulletin, we are now offering Education and Small Utilities Subscriptions. We're keeping an open dialogue with our partner community about these offerings and would like to hear any input or feedback you may have. Please get in touch with your Channel Account Manager at any time. FME 2020.0 is set to release today at approximately 2:00pm PST. Keep an eye out for resources appearing on safe.com throughout various channels including demo webinars scheduled for March 17 and March 19, a blog post, updates to the customer engagement slide deck, and Knowledge Centre articles. For our localizers: All of the FME 2020 resources (splash screens, Transformer Guides, etc.) can be found on the Marketing Collateral Resources in the Localization corner. If you don't have access to this page, please get in touch with or the
I have a workbench where I have used Spatial Relator and List Exploder to make a list of polygon IDs and Neighbor_IDs of those polygons touching it. I want to count the number of touching polygons, and if they are greater than 3, find which are the same land cover type.Something like: for every unique ID with more than three touching polygons of the same land cover type, with a combined area of less than 200,000m^2 -> dissolve.I have a tester set up to test LC_type ID= LC_type Neighbor_ID, which passes to a counter measuring ID >=3But I don't know how to give dissolver the condition not to dissolve if the resulting polygon is > 200,000m^2.–