Creating and organizing workspaces. How to use Workbench.
Recently active
I'm trying to set up a parameter for the output file path for a geodatabase writer, but having problems with using the "Choice with Alias parameter" type. When I try to set up something like this: Value: \\\\server\\sharename\\examplefolder\\Output.gdb Display Name: Testing When it comes to runtime the path of the geodatabase is passed to the writer like this... <backslash><backslash>server<backslash>sharename<backslash>examplefolder<backslash>Output.gdb ...which causes the translation to fail. Using a 'Choice' parameter for the path works fine but using an alias would be helpful for this particular job. From this FME Evangellist article here it seems like this should work but perhaps I'm missing something. Using FME 2012 SP3 Thanks.
I have attempted to configure Job Routing in FME Server 2017 in the config file but it is not working?
Currently we have an FME Script for that refreshes 1 ESRI Geodatabase to another (i.e. a direct copy). The problem is when there's an error on just one feature class, the entire workspace fails. Is there a way to bypass any errors and continue with the translation. We want to use a simpler way i.e. not validate all of the fields whenever there's an error encountered (i.e. not use the Tester / AttributeValidator). Can anyone please suggest of the most efficient way to do this?
Hi all,I'm working on a project to automate transformation of more than 50 layers. Just wondering is there any way I can get the list of attributes and types from each layer and compare it with another list to make sure it has fields and fields have types I'm expecting?
I am having an issue with my 2017 FME Desktop performing very slowly. The issue is not with running a workspace or reading data but rather with editing the workspace itself. There is a significant delay when adding a reader and editing a transformer. The slowness of FME has almost made the software unusable.Things I have tried: Purge temporary files (Tools > Purge Temporary Files). Start a blank ws and copy ols ws content to it Delete all FME TEMP location filesAny suggestions on how to gain performance in FME?
Scrape a web page showing road closures from X street to y Street, a point of closure from start to end.
Hi,I need some assistance with the following: First of all spec just in case you need it -> FME 2017.1.1.1 (20171014 - Build 17652 - WIN64) running on a Windows 2012 R2.1) I'm running a workspace as a batch file and setup as a scheduled task. .BAT script content: fme "E:\FME Workbench\Biffa\BiffaDbImport.fmw"2) When it runs I get the below error message which is located near the end of the log: 2018-01-14 20:00:05| 2.1| 0.0|INFORM|Connecting to ORACLE database `BS7666-Live' with user name of `' and password of `***'2018-01-14 20:00:24| 2.2| 0.1|ERROR |Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`BS7666-Live', userName=`', password=`***', dbname=`')2018-01-14 20:00:24| 2.2| 0.0|INFORM|FME Session Duration: 23.2 seconds. (CPU: 1.3s user, 0.7s system)2018-01-14 20:00:24| 2.2| 0.0|INFORM|END - ProcessID: 6324, peak process memory usage: 418276 kB, current process memo
Hello, I am wondering if there is a way to change a name of attribute in FME. Attached, You will find a photo of what am I trying to do. I would like to change a name of attribute in those two places.
Hi all,I try to dynamically read values from a list, i.e. sometimes I need to extract the value at index 0, sometimes the value at index 5 and so on and then store the value to a new attribute. The index of the value I need to extract depends on the value of another attribute. The number of entries in the list is roughly limited to 10 in my use case, so I solved this problem with a conditional value in the AttributeManager. However, it'd be nice to know if there's a dynamic solution to this problem.
Hi All,Is there any way to execute workbenches without installing FME in workstation.Pratap
Hi,I am using FME Desktop 2017 and would like to know if there is a way to get a list that I have generated in my FME Workflow, into the PythonCaller, in a similar way to how you use 'getAttribute' function feature.getAttribute(x) to get a normal attribute into the PythonCaller. Thank you for your help in advance.
Hi,I've heard very good news that FME can now read/write autocad regions and I am trying to test it using FME 2018 Beta. I have no problem to read an autocad_region however after several attempts I am not able to write an autocad region. I’ve already tried creating donuts, area or surface in a workspace and writing it to a .dwg file as a region but each time FME creates an autocad_block instead and not a region. If anybody was successfully able to write a region, I will be glad if I can have a simple example/guide on this subject.Many thanksRegards,Hani
HelloI have a large GML dataset which contains various lists. My question is this, how can I filter this data by each list and send those records and attributes in different directions, rather than sending all of the data to multiple attribute keepers which is slowing down performance.
I have a set of records (360 total) that are already assigned a relational ID to 3 other records (2 sets of 144 records, and 1 set of 72) I want to group the records in sets of 12 to assigning a _group_index and then start over again for the next relational ID.For Example:The first 144 records would already have the same relational ID (Let's say A). In relational set A, the first 12 records would receive a _group_index of 0, records 13-24 would receive a _group_index of 1, all the way through records 133-144 receiving a _group_index of 11. This is the end of relational set A, so relational set B would begin and contain 144 records as well. I would like the _group_index to start over and the first 12 records of relational set B (records 145-156) would receive a _group_index of 0. The number of records in each relational set is not always the same, but they are always a factor of 12. Relational set C in this example is a total of 72 records, so its first 12 records (records 289
HiAfter changing the params using params += elem[i].name + "=" + elem[i].value + "&";params = params.substr(0, params.length-1); I am unable to submit a job through FMEServer.submitSyncJob(repository, workspace, params, callback) function, but able to run using FMEServer.runDataDownload.If i use the below line for params and do not change params:params = { "publishedParameters" : [] };then i am able to submit a job.What is the probable reason for this behavior?
Situation: I have a workspace with a JSONFragmenter transformer that occasionally receives malformed JSON (unescaped special characters). I want it to skip over them so I set the workspace parameter for "Rejected Feature Handling" to "Continue Translation" and all is good.But when I reference the above workspace using a WorkspaceRunner (Wait for Job to Complete is set to Yes) on both desktop or server, it bonks the parent workspace even though I have the same setting for the Rejected Feature Handling in the parent as well. So am I missing a setting somewhere?The band-aid fix is to add a Logger to the Rejected port. But I got a lot of JSONFragmenters and I'm hoping for a more elegant solution.-- Brian
Hi,when I replace the hardcoded string to a dataset with a parameter (in my case my $(FME_SHAREDSOURCE_DATA) Resources), the FeatureReader destroys all my 'one per feature type' or 'specified' Output Ports. Even if I add 'FeatureTypes to Read' as a Fixed List parameter. So how can I make the Output Ports persistent to prepare my workspace for FME Server? (FME 2017.1.1.0 build 17650)
Hello,I'm trying to convert compound geometry type from an Intergraph Access database into Esri file database. I'm wondering how to separate geometry type from compound into point, line and area features.
I'm using FeatureReader as CSV format and trying to expose attribute 'fme_feature_type'. It's returning NULL or CSV. Instead it has to return FILENAME.Any thoughts please?
I'm trying to change the default path for the Data Path, but when I do, FME Workbench is telling me that it does not have access to the directory. I'm not sure why it would not have access nor can I find the log file it keeps telling me to look for. Any ideas?
I'm trying to get FME Desktop 2018 Beta to run an AreaOnArea between two large SDE feature classes. It's millions of records in each dataset and FME chokes if I try to run the AreaOnArea in one go. I saw in the help you can use a custom transformer to apply parallel processing to help break the work into spatial chunks. I tried implementing this using by breaking my study area into tiles and then feeding each tiles into a custom transformer that imports the needed data and processes it, but when I check my results, the AreaOnArea results don't show the two datasets cutting each other.Here's the steps my workspace takes:1. Read in the project area polygon2. Use the Tiler transformer to cut the project area into 1 sq mile pieces3. Feed the tile features into a custom transformer4. Inside the custom transformer, use ArcSDEQuerier to read the features from my two input layers that intersect the tile, then feed these results into the AreaOnArea transformer. Within the c
I have a list of numbers from 1 to 100. I want every time I run the workspace that a random number is selected. But it must not be the same no. Before you have been through the entire list. I use the selected number to retrieve some specific information from a particular row in another table where Rowid equals the number. I do not think I've found a transformer that can do this.
I want to load all the dbf files under a folder into an Oracle database, each creating a new table. Attached is workspace I created, but it gives an error that the schema is not defined for the writer. This can be easily done using ESRI arcpy, so should be easy in FME.
FME version: 2016.1.3.2 (20170214 - Build 16717 - WIN64)Hi, i am trying to create a custom coordinate system (custom ellipsoid, custom datum, custom transformation and custom crs).The CRS i am trying to create is the EPSG:26331 (as parametrized by EPSG).Looking at the Coordinate System Gallery, there is a crs with name equal to EPSG:26331 (i will call this FME EPSG:26331)..But there is two points that i want to modify:Ellipsoid ParametersDatum Parameters.Ellipsoid Parameters:Searching into EPSG Registry (http://epsg-registry.org), the ellipsoid used by EPSG:26331 is EPSG:7012 - Clarke 1880 (RGS). This ellipsoid has:semi-major axis (E_RAD): 6378249.145 meterinverse flattening (inv_f): 293.465.using P_RAD = E_RAD [1-(1/inv_f)] = 6356514.8695497755In FME, this same ellipsoid has:semi-major axis (E_RAD): 6378249.1449999996 metersemi-minor axis (P_RAD): 6356514.8700000001.using the same formula above, we get inv_f = 293.4650060791153. A little different from what is in EPSG. (this was one o