- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,048 Posts
12,635 Replies

When you subscribe we will email you when there is a new topic in this category

3048 Posts

Most replies

Most views

Newest first

virtualcitymattCelebrity

asked in Authoring

Handling hanging processes on FME Server - ABORT

I'm looking for ideas to help me get around a problem with hanging FME Process. I've found (at least one case) where FME is hanging with a difficult geometry - I've tried a few things to fix the geometry, however, I haven't had much luck (I'm going to pass it on to support for them to look at).The process is being called web API and it's expecting a response back when completed, either failed or successful - I am just using Fail topic to send back a response. I decided to add in a 'tm_ttc' directive to make the job timeout instead of running forever. It works great, however, now the Failure topic isn't getting triggered and I can't let the tool know to wait for a response. It's the same when the job is canceled manually from the FME Server web ui. Any ideas on this one? Cheers

Column Aligned Text (CAT) in a Feature Reader missing dataset and basename attributes - 2019.2

I thought I would check here first to see if anyone has seen this issue - before I log it with support.The Column Aligned Text (CAT) reader embedded in a Feature Reader is missing the fme_dataset and fme_basename attributes - even though they are specifically exposed. I am using FME Desktop version 2019.2 (build 19801 – WIN32).This was working fine in the last version of 2018.Thanks in advance.Mike B.

HelloI have to deal with a data versioning issue.Do you know if any tools of data management are available with FME ?What do you advise me to version data according to a software version?Thanks

5 years ago

virtualcitymattCelebrity

asked in Authoring

Turn off feature caching for Workspace?

When delivering workspaces to a customer or a user, I really want the workspace to run without feature caching turned on. With FME 2019.1 the feature caching is turned on by default. Does anyone know of a way to set this behaviour in the workspace file like a worksapce parameter? Issues come when the user want to run the process again, FME 2019.1 is clever and hides the input parameters, however, not all of them. When clicking run again sometimes there is the option to select new data, however, the other options are not there. This results in unexpected behaviour (like dropping a database table instead of inserting into it...oops!) The user actually needs to Re-Run the whole workspace which is also now not the default. I've been getting a lot of support request because of the workspace producing unexpected results. I've also documented it and made it as clear to the customers as I can, however, the issue still comes up with users who are not familiar to FME. I'd really l

How to replace multiple strings in single attribute?

I have attribute, that contains mostly 3 street names (there are 1 to 4 street names per attribute).Street names are in finnish, but I would need them also in swedish. I have csv-file that contains street names in finnish and swedishSingle street name would be easily changed with AttributeValueMapper, but how can I change 3 in same attribute?for example "Mikael Lybeckin tie (Kasavuorentie-Bredantie)" => "Mikael Lybecks vägen (Kasabergsvägen-Bredavägen)"This solution is quite close ebygomm Python script

select group by Value

I have a filed like Language and Values as English, French, Italian, Hindi and EtcBut i don't know how many languages are present in that field.Challenge: I would like to export separately for each language.

110

5 years ago

fmelizardContributor

asked in Authoring

I am trying to set the coordinate system in my EsriReprojector using a published parameter but it's failing, how can I do this?

5 years ago

christian_b

asked in Authoring

How to migrate tables from database to another with dynamic schema

Hi,Il have to migrate several tables from a mysql database to a postgres database.This seems quit simple but the main difficulty is that the table list to migrate is defined in a specific table and the schema (structure) of all tables to migrate is not known and has to be dynamic.I tried the following:- read the table list with a mysql reader- for each entry in the table list, read the concerned table with a featurereader- send (write) the concerned table in Postgres with a dynamic schema.But this doesn't work, I always have errors:Failed to obtain any schemas from reader 'MYSQL_DB' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information. I tried to change many parameters but never achieve to make it work.I would really appreciate any help.Thanks,Christian.

ListKeyValuePairExtractor - encoding error

Hello,I'm facing a new issue with ListKeyValuePairExtractor componant, for some data it encounter an encoding error : Python Exception <UnicodeDecodeError>: 'ascii' codec can't decode byte 0xa0 in position 12: ordinal not in range(128)Traceback (most recent call last): File "<string>", line 30, in input File "<string>", line 118, in get_list_attribute_namesUnicodeDecodeError: 'ascii' codec can't decode byte 0xa0 in position 12: ordinal not in range(128)Error encountered while calling method `input'f_60(PythonFactory): PythonFactory failed to process featureA fatal error has occurred. Check the logfile above for detailsError encountered while calling method `input'f_42(PythonFactory): PythonFactory failed to process featureA fatal error has occurred. Check the logfile above for details I tried a lot of things, encode all attributes on utf-8 or windows-1252, I've try a stringreplacer with this regex ([^\w\S"]{0,2}$). But anyway still the same issue, the job stop on

Hello, I need to use fme server rest api to make a web service application to convert cad to kml. The workspace uses ESRI Reprojector. Now the parameters I publish have no given input and output coordinate system. How do I pass parameter requests to this FMEserver through the web To complete the task

split upto specific count

I have source with 10 L count like below I need to select Upto 5L points within source,I have fields like Object ID and ID both are same and those starts with numeric 1.Note: should select from one side

5 years ago

burgasserContributor

asked in Authoring

oracle spatial reader unwanted schema attributes

Hi:In FME Desktop 2019.1.3.1, when adding a table using the Oracle Spatial reader, I'm getting some unwanted attributes shown below (starting with fme_geomattr). I am not purposely exposing additional schema attributes. They just show up unwanted. Does anyone know how to avoid having these additional attributes exposed when adding feature types? Thanks!

5 years ago

prpa_gis

asked in Authoring

Would someone at SAFE be able to show me how to automate an FMW file to start using Python?

I would like some quick instruction on how to automate the start of an FMW process. The current FMW uses a series of files that it converts based on date (i.e. the date is in the filename). I need a Python script to be able to load those files into the FMW project once a month and then run the conversion process. I realize that this would be best done using FME Server...but what I'm trying to do is build a "proof-of-concept" for management here (they will see and understand the pitfalls of automating a desktop process to run indefinitely).Thank you

110

5 years ago

bwnEvangelist

asked in Authoring

FeatureWriter creates indices before writing features = Slow writing?

So, I hope I have this right. As far as I can tell, the default behaviour for FeatureWriter is to create any field indices during the CREATE TABLE or ALTER TABLE stage by issuing commands like CREATE INDEX before any features get written.However, this would be against normal mass data append default convention? Writing bulk data against indexed tables can be very slow and in most cases best performance is to create the indices after the data is written. For instance, my FGDB FeatureWriter takes 2 hours to write my current project with the relevant fields set for indexing because every single feature written triggers a resorting of the indices, versus 15 minutes if I leave the field indexing options off.The best workaround I can come up with at the moment is to instead do post writing index creation by manually writing out the the "CREATE INDEX..." statements in the "SQL to run after Write" parameter, but can anyone think of other workarounds or why indices would gen

Can I get FMEWorkspaceRunner to automatically read multiple files (one at a time) from a folder?

I'm trying to demonstrate how FME (eventually FME Server) can automate a process for us. I have all of my NMEA data in one folder (they are stored by day in a given month; hence, there can be 700-800 NMEA files in each folder), and I can get the reader to read them all manually...but I would like to know if it's possible to get FMEWorkspaceRunner to automatically read and load all of the files in a folder that will then be converted.The FMEWorkspaceRunner variable is set to: runner = fmeobjects.FMEWorkspaceRunner()I tried to be sneaky and use parameters['SourceDataset_NMEA'] ='\\\\2018ais\\c$\\rawnema\\Feb2019\\*.nmea', but it did not work using runner.runWithParameters(workspace, parameters).I can (of course) do it manually from Python by using runner.promptRun(workspace), but this then defeats the purpose of my Python script.Is there a way to get the FMEWorkspace Runner to automatically read/load all of the files in a folder that will then be converted?When l

170

5 years ago

arthyContributor

asked in Authoring

FME Server Job submitter and Splitting jobs on engines

Hello, I have a workbench that called children in sequence using FMEServerJobSubmitter transformer.I have a strange behaviour. A job in one branch should finish before another job in another branch starts. My understanding is that the run is sequence should affect only the job in the same branch not in other branches. Why is that the children called from the three different branches of the ETL can not be run in parallel (i.e. at the same time)? Thanks

880

5 years ago

thdrgContributor

asked in Authoring

Workflow stop running without any errors

Hello everyone, I have two datasets:- One of lake polygons,- Another containing the postal code polygons,My goal is to calculate the sum of area occupied by the lakes in each of the postal codes. My problem is not really technical because my workflow works with data samples (when I use an attribute filter on postal codes and I reduce the size of this data set). However, when I launch it with all the data, the workflow always stops at entity number 104. I tried to check in my input file if there was a corrupted data, but that n doesn't seem to be the case. Any ideas ? Thanks !!:)Théo

Fussioner plusieures features class

BonjourJe suis nouveau sur le FME et je voudrais savoir s'il est possible de fusionner plusieurs features classes en un seul.Quel est l'outil que je devrais utiliser. Y a-t-il un document avec les étapes à suivre ou une vidéo indiquant comment le faire?Merci beaucoup pour l'information.

460

5 years ago

keithhastingsContributor

asked in Authoring

Having trouble with published parameters containing text with accents in FME Server

I have a workspace that has a published parameter (selected from a list) that may contain a character with an accent. In desktop this causes no problem.However when running from FME Server the accented character seems to get converted when being run.So when a user selects this:in the log file the command line arguments look like this: Any ideas on what will fix this? ThanksKeith

103

5 years ago

bwnEvangelist

asked in Authoring

How to mix 32 bit and 64 bit workspace execution

So, yes I've read about how to get FME 64 bit to run on a machine with 32 bit ArcGIS Desktop installed, but for ease of deployment on different user PCs that will only have the standard ArcGIS configuration, I've opted for 2 workspaces:One to run an extraction of source data with an ArcSDE Reader executing in FME 32 bit. This is due to the dependencies of FME on the bitness of the ArcGIS installOne to transform it by executing in FME 64 bit. The data model is very large and RAM intensive so needs to run in FME 64 bit.FME 2018.1The best solution I can think of it to BAT file this by calling the workspaces against the individual 32 bit and 64 bit FME executable file paths, because I don't think a conventional running them in a Parent workspace with 2 WorkspaceRunners can work, since you can't specify the bitness of the WorkspaceRunners and they would all have to execute as 32 bit or 64 bit inheritted from the Parent workspace mode, but not a mixture of both.But, intereste

Set Published Parameters in a Python Startup Script

Hello! I tried to set a published Parameter in the Python startup script, but the parameter changes just in the dictionary (I think), but not in the workspace. Is it possible to set a published parameter in the python startup script? Here's my Python Code: def ReadParameter(): ParameterFile = open(r'R:\\212_TIM\\Konzept\\TIM_Auskunft\\FME_Migration\\LOG\\ParameterFile.txt','r') for line in ParameterFile: key, value = line.split(' = ') if key == 'CountStart': return int(value) return 'Konnte Id nicht finden' HIS_ID_intern = ReadParameter() d1 = {'HIS_ID' : HIS_ID_intern} FME_MacroValues.update(d1) Thanks for your help! Regards, Isabell

1114

5 years ago

fmelizardContributor

asked in Authoring

How can I change the folder structure returned in the zip file from FME Servers Data Download Service?

I recently upgraded my FME Server and now when I run jobs using the data download service the zip file returns an unwanted file hierarchy with additional folders named after each Writer in my workspace (e.g. XLSXW2_1 and GEODATABASE_FILE_1), how can I remove these folders?

25610

5 years ago

nagContributor

asked in Authoring

Unable to run the workspace from newly installed FME server 19

Hello Team,We have installed FME Server 2019 and published a workbench which was running fine with the FME Server 2015. But in newly installed 2019 server it was throwing following error. oordinate system named NiSource_AE_US_Foot does not exist.2019-12-12 08:49:53| 23.7| 0.0|WARN |Failed to get parameters for coordinate system `NiSource_AE_US_Foot' -- No definition was found for coordinate system `NiSource_AE_US_Foot'2019-12-12 08:49:53| 23.7| 0.0|INFORM|FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20190621)2019-12-12 08:49:53| 23.7| 0.0|INFORM|Writer `GEODATABASE_SDE_1' of type `GEODATABASE_SDE' using group definition keyword `GEODATABASE_SDE_1_DEF'2019-12-12 08:49:53| 23.7| 0.0|INFORM|FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20190621)2019-12-12 08:49:53| 23.7| 0.0|INFORM|An ArcGIS license is already checked out. The product checked out is 'Advanced'2019-12-12 08:

Has anyone created an ODBC Reader connecting with a Snowflake Driver?

When creating the reader, I get the following error. I know this driver works because I was able to make an ODBC connection in Excel. I'm using FME 2019 32bit and created the source in a 32bit ODBC Data Source Admin. Error connecting to databaseDatabase Generated Error Information:Database Error Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedDatabase SQL Statement Text: SQL State: IM002Variable Information: ODBC 3.x Reader: Failed to connect to database

expression and set attribute

Hello I 'm tring to set any value to AttibuteManager Transformer as you can see in the attachement. I have created an RandomNumberGenerator to fill a list but it doesn't work. I try also a rand function. Without success. Short, how to set random value in an AttibuteManager Transformer ? (the easiest way ...) Subsidiary question, how to create correct expression with the "text editor_attribute value" ? any help will be welcome.thanks

529

5 years ago

Page 38 / 122

Badge winners

chandcolehas earned the badge Teacher (Grey)
boostpadhas earned the badge FME Form Basic Training
nathanherzoghas earned the badge Student (Grey)
nathanherzoghas earned the badge Teacher (Grey)
adam_timmonshas earned the badge 12 Days 2024 Bronze Badge

Show all badges

30,414: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.