Creating and organizing workspaces. How to use Workbench.
Recently active
I already read the article (https://knowledge.safe.com/articles/886/working-with-geodatabase-subtypes-and-domains.html), but it doesn't seem to work. I get: "An error occurred while attempting to add the subtypes to the table/feature class 'Feature_Outline'. The error number from ArcObjects is: '-2147219885'. The error message from ArcObjects is: {An expected Field was not found or could not be retrieved properly."
I am using a feature writer to write something into a featureclass but I do not get records for each feature that is written using a feature writer.I have the following setting for featurewriter but everytime I do not see any feature that is written/updated via feature writer.
I'm trying to create a dynamic schema writer that outputs as the feature's reader filename. I have tried the answers in https://knowledge.safe.com/questions/65227/how-to-read-csv-dynamic-and-write-csv-dynamic-with.html with no success.Can anyone suggest a different workflow?Thanks
Hi guys,I am currently trying to automate numerous bits of GIS data we get from various sources. I have managed to do the following. Simple Terms currently: Excel/Shapefiles/Geodatabases ---> Data Validation via FME ---> FME/Python Script run via a scheduler --> Loads into Enterprise GeoDatabase I am currently trying to decide what would be the best way to improve this process for it to be more accurate and so numerous users can also load their data successfully.In terms of excel/shapefiles should they place their files in a shared area folder and then possibly break it down into various folder categories or would you suggest SharePoint? I would be interested to hear other's views on this and how they may use it within their business.Also what scheduling tools are best suggested, I am looking at FME server as a possible option.We are also using a SQL Server Geodatabase
Hi, I am trying to build a workbench that performs certain checks irrespectively of the Input data. That means that it must accept data with different data types (.shp, .mdb...) and schemes (e.g. different attribute names and types). As far as I know, a generic dynamic reader is what I need. So I inserted one and tested it. Although this reader reads the (spatial) data and shows its polygons in the inspector, the attributes are lost. Instead of the original attributes, there is only one row in the table with the header <no schema>. In the feature information part of the inspector, however, the attributes are still listed. Since I want to write a log file including all the errors found by the checker, the attributes are important. What do I need to do, so that I can access the attributes of the generic dynamic reader? Best regards André
Hi Everyone,I need to have the intersected areas between two areas from different fonts.I have tried intersector, Clipper and also create a spatial query in SQLCreator, once my data is in Oracle Spatial format.But none of this worked fine in terms of performance.Anyone has clues of performance enhancement ? I've not tried yet Python or R interface to achieve the clipper operation.All of this options, are processing in FME Server, because of the time of processing, but I can try with limited data in FME Desktop also.The best that I achieved until now, is use clipper, but limiting my data between states boundaries, but I have loss of information in limits areas.
I'm using the HTTPCaller to download PDF documents to a set destination folder. The files get saved with the following name structure: "http_download_1582786318570_11140". This is not the same name I get when downloading the documents manually in a browser. I need the documents to be saved with the same name I get when doing it manually. Example: "Askholmen_SE0220343". Is it possible?Website: https://www.lansstyrelsen.se/sodermanland/natur-och-landsbygd/aktiviteter-och-ingrepp-i-naturen/tillstand-i-natura-2000-omrade.html (URL to PDF-documents are found under the heading "Bevarandeplaner kommunvis")HTTPCaller:
Hi everyone, I'm currently updating some FME Workspaces from Python 2.7 to Python 3.6.The workspaces have a private parameter containing a python script which imports arcpy and reads data from a SDE DB. The first transformer is a feature reader which reads features from an arcGIS Server (10.7.1) in my organization.The python script containd in the private parameter is executed successfully.The workspace fails when executing the feature reader with following log : Loaded Python module `arcgisonlinefeatures' from file `C:\Program Files\FME\python\python36\arcgisonlinefeatures\__init__.pyc'Python Exception <ModuleNotFoundError>: No module named '_socket'Could not create Python Reader `ARCGISFEATURES'A fatal error has occurred. Check the logfile above for detailsThe python interpreter is set to use the dll installed with ArcGIS Pro : C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python36.dll. the python home in the fme options is left blank.The python compatibility is set
Hello!I have a python script that calculates slope between points. I want to complete it with a while loop, to calculate between only those points where _lineID is equal, so like:while _lineID == _lineID z_kulonbseg = b_z - a_z slope_degree = (z_kulonbseg / a_t) * 100 and so on....import fmeimport fmeobjectsfrom functools import reducefrom math import sin, pidef left_slope(feature_a, feature_b): a_x = float(feature_a.getAttribute('x')) a_y = float(feature_a.getAttribute('y')) a_z = float(feature_a.getAttribute('z_uj')) a_t = float(feature_a.getAttribute('tavolsag_szomszed')) b_x = float(feature_b.getAttribute('x')) b_y = float(feature_b.getAttribute('y')) b_z = float(feature_b.getAttribute('z_uj')) b_t = float(feature_b.getAttribute('tavolsag_szomszed')) ###### WHILE LOOP z_kulonbseg = b_z - a_z slope_degree = (z_kulonbseg / a_t) * 100 if slope_degree > 0: elojel = "1" else: elojel = "0" feature_a.set
Hi,I have a workbench wherein I am trying to batch process several .dwg datasets in one directory and put them into a file .gdb as follows:I am building polygons based on a .dwg layer and am outputting to the desired .gdb.I then have a separate workspace for utilizing the workspace runner so that I may process all these datasets as shown in "FME Workflow Management" as follows:I receive the following error when running which I am unable to resolve:WorkspaceRunner: Failed to run workspace C:/Users/blee/Desktop/MyDocs/Projects/PlanExtentWorkbench/Workbench/MissingPlanExtents.fmw -- Trace was: FME 2017.0.1.1 (20170512 - Build 17291 - WIN64) FME Desktop ESRI Edition (floating) Permanent License. Machine host name is: WLTS4018 Operating System: Microsoft Windows 7 64-bit Service Pack 1 (Build 7601) Copyright (c) 1994 - 2017, Safe Software Inc.
HEllo,I want to create an attribute (distance) between two points. I am using AttributeCreator to do it. Here is the code:@Evaluate(@sqrt((@Value(feature[+1].y)-@Value(y))*(@Value(feature[+1].y)-@Value(y))/(@Value(feature[+1].x)-@Value(x))*(@Value(feature[+1].x)-@Value(x))))The problem is that I want to calculate it only between points where lineID is the same. How can I add a kind of group by?Thanks
Hey there,I made a website (HTML, JS, CSS) with which I can list and execute several workspaces. The last workspace I added fails when executing, but works properly when running on the server directly ("Run Workspace").The first error in the log is:E57 reader: An error occurred while reading. The error was 'open() failed (E57_ERROR_OPEN_FAILED)' with context 'err=13 fileName=. flags=32768 mode=0' (error code = 17) The file is uploaded and available. I can't see the problem. Other workspaces where uploaded files are nedded work great. Cheers, Maria
Hi list.I've avoided the 2019 version due to multiple issues. So this is a bit late, I know.But now I tried to run a workspace I made in 2018 in 2019 (and 2020 beta), and both failed to run my custom transformer, giving an error about not being able to locate its components.All my custom transformers are located in a shared location using the "Shared FME Folders" feature. This worked fine in 2018 and previously.Only when I specifically added the path to the shared Transformers sub folder to my FME_PYTHON_PATH, did 2019 it find it. But then what's the point of having an official "Shared FME Folders" installation ?Was the "Shared FME Folders" functionality changed in 2019+ ?Cheers
Hello community, I'm quite new to fme and I've been stumbling on something that might be easier than i think. Basically i have a filled access database table and I'm trying to fit these filled records into a template table. This template has less column headers/attribute names than the source. I'm trying to get the values that do no longer have a place to be put into a string. I have managed that, however I'm trying to have this long string be readable by having the attribute value be preceeded by the attribute name. I'll give an example below: (sorry I'm currently only on mobile so writing it out is a bit harder) OldFruits vegetables grains soup Apple cauliflower bread tomatosoup New:Fruits vegetables otherApple cauliflower grains: bread, soup: tomatosoup This is just an example. The real table has like 52 fields per records that has to fit into 30. I hope anyone can help me out.
I am trying to limit the attributes read by the FeatureReader. The data I want to read are coming either from an Oracle or PostGIS database. Of course I can use the WHERE clause to limit the features based on limiting values, but I do not need all the columns the data table holds. I there a way to do this inside the FeatureReader? Currently, I am using an AttributeManager after my featureReader to remove columns not needed, but that's a waste of ressources and more important, time.
Hello everyone ! Does anybody use SAS DB connection? Right now I'm exporting CSV files from SAS and importing the CSV to FME. Is there a way to add a direct connection between SAS and FME (like PostGreSQL - FME connection)? Ciao,Théo
I would like to hide half of my transformer in one workspace and do password for half of workflow so User will not be able to show the whole work .I mean ,for the same workspace ,I want to make security password to appear the whole workspace .But without password ,user can open the work space but it does not show him the whole work space till he write password to show the whole work .Do we have a method to do that
Currently ,i am trying to create user parameter in shared parameter linked with excel file. i have an excel file ,it includes id number and names of building , i want to create user parameter when i write the number ,it wiill read automatic which names that i want to work on from specific excel file ,then it starts scanning or searching for this excel file in specific folder that include the same name and import ths excel file to workspace . Thanks in advance
Hey Everyone,I have had some challenges creating apps in FME Server that have published user parameters that are as robust as Workbench. I wasn't sure if it was just a limitation of FME Server as of 2019 or if I am doing something wrong.For example, if my workbench parameter needs a user to select a Coordinate System Name, it is very easy to find the CS you need:On the other hand, on an FME Server App the search functionality is unable to find my CS and it it giving way less results to scroll through. If I knew the EPSG code I'm guessing it would be fine but I'm thinking in my users' shoes who need to type in more broad terms like "texas". In the App, searching texas doesn't bring up any NAD27 CS choices at all. It is a similar situation with folder/file locations. I was hoping this folder selection view would be similar in the app as well. Does anyone have any thoughts? Is this more of an idea for improvements?
Hello!I have point next to each other with a slope value between two neighbor points. Now I want to average these values with a loop, like:for n in range(num): numbers = float(input('Enter number : ')) total_sum += numbersavg = total_sum/numCan you help me to put it in practice with FME
We recently upgraded to FME Server 2019.1.1 and have run into user parameter issues. We built an extractor tool in our ArcMap Portal GIS that enables users to extract GIS data into styled dwg or shapefile format to create maps. We have user parameters linked to FME process for layer names, projection and user input selection via draw tools in the tool. After the upgrade from 2018 to 2019.1.1 we have noticed the process will give an error if too many layers are selected and also if you use the draw tool and create polygons with too many vertices. I am wondering if there is a limit setting for the user parameter values or other setting causing the issue. I did test running the process on the server interface with the string used for the selection box and it works. Below is example of the failed string running from Portal, but passes if I paste value in the box selection user parameter on the server interface. <lt>?xml<space>version=<quote>1.0<quote><space>e
Hello!I would like to calculate the difference of z value between two neighboor points in the following way:- test if the extreme_ is LOKMIN- if it is LOKMIN , then take the two neighbor value (the points are sorted), take the higher (so the bigger number) and exract them each other.Here is my attempt:import fmeimport fmeobjectsfrom functools import reducefrom math import sin, pidef left_slope(feature_a, feature_b, feature_c): a_x = float(feature_a.getAttribute('z_uj')) a_sz = feature_a.getAttribute('_szelsoertek') b_x = float(feature_b.getAttribute('z_uj')) b_sz= feature_b.getAttribute('_szelsoertek') c_x = float(feature_c.getAttribute('z_uj')) if b_sz == "LOKMIN": k = c_x - a_x #_nyomvalyu = b_x - a_x feature_b.setAttribute('_nyomvalyu', k) return feature_a return feature_cclass FeatureProcessor(object): def __init__(self): self.features = [] def input(self,feature): self.features.append(feature) def close(self):
We have a problem with the cases of our attributes. Normally the attributes were all uppercase, but we have some customer which send us data where they are not. They sometimes mix the cases in all sort of ways. We have a ArcGIS SDE Reader and a Hexagon SQL Warehouse Writer. Here an example: Table: WASS_SUBART_HYDRAttributes: OBJECTID, CODE, DESCRIPTION_G, GlobalIdThis is our configuration, but our customer send us data, where the CODE Attributes is lowercase. Then our FME Workbench does not work, because the code Attribute is "ignored" and the writer will write a NULL Value to the Database. If we see it correctly, the problem is, that the reader has the wrong information about the attribute.Is there a way to ignore the upper- and lowercase of a reader? (If not, this would be a nice feature, because ArcGIS and MS SQL can handle this no matter how it is written)Or is there a way to change the reader dynamically?This is only a small example to keep it simple. We have to deal wit
Hi, Is it possible to rename Repositorys by changing the text in the .fsproject file? and then reimport the file. It does not seam to be possible, but would be a great function to implement in future versions of FME. Best/ Johan