Authoring

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

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 rec

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 i

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:

Is there a way to have the data inspector not show attributes that are empty? When looking at AIXM 5.1 data, the tables is filled with empty attributes and makes it hard to 'inspect; your data

I'm trying to convert some data into the TOMTOM POI format, but I keep getting errors and the output file is created but not populated. A simplified version of the workspace that generates the same error is here: The translation log contains this:TOMTOM_POI writer: Creating layer 'waypoints' with geometry type 'wkb_unknown'TOMTOM_POI writer: dataset C:\\Users\\myname\\AppData\\Local\\Temp\\_14244_1 does not support layer creation option OVERWRITETOMTOM_POI writer: Cannot create GPX layer waypoints with unknown geometry typeTOMTOM_POI writer: Unable to create feature type 'waypoints'. Ensure the dataset is valid, that the user has all required permissions and that the feature type name is valid for the formatTOMTOM_POI Writer: In Feature Type 'waypoints', 'fme_table_handling' has invalid value 'CREATE_IF_MISSING'. Possible values include: 'CREATE_IF_MISSING', 'DROP

I have an aggregator transformer (to aggregate incoming features because I want a single feature to enter the subsequent Emailer transformer). I'm trying to use the python code (in PythonCaller transformer) to extract info about each of the aggregated features for output to the email. I'm using "for x in range (0, feature.getAttribute('Count')-1)" to try to loop over the lists but the workspace isn't accepting x.

Hello,With : - FME Server 2017 - Only 1 engine - A workspace with 1 FMEServerJobSubmitterCould you confirm that the child job launched by FMEServerJobSubmitter is always executed before any new job ?(ie someone asks for a new job before FMEServerJobSubmitter launches the child job)Regards.