Authoring

for example:TableA has attributeA and keyA. TableB has attributeB and keyB.if keyA is found in keyB, copy attributeA to attributeB. Don't create a new record; just populate attributeB in TableBThere's a 1 to many relationship between TableA and TableB.Does this require multiple transformers and if so which ones and how would they be setup?

I'm running the WSR with 7 concurrent processes. Is there a way to add information to the opend cmd window to identify which window belongs to which processes?I need to terminate from time to time a cmd as it's hanging but I can't identify know which window belongs to which process and I need to guess.In a batch file I would add TITLE parameter in it. Can something similar be set for WSR? Below screenshot shows 7 CMD's but no distinction between them is possible:The provided command is too long to check in the taskmanager. The part to see the difference can't be set on the monitor:

I have a workspace reading a polygon which is buffered and send to several featurereaders that read data from several sources (shapefiles, WFS, dwg,…).Data is selected within this searchpolygon (using a spatial filter in the featurereaders) and the selection is written again using featurewriters.All the summary-ports of the featurewriters are going to a featureholder (from the hub): when all data is read, written and ready a new process of map production starts based on the original polygon.This works very well, except when there is no data to select from a certain datasource/featurereader, then I get this error:2019-12-10 09:54:57| 1.1| 0.0|ERROR |FeatureWriter_11 (WriterFactory): Internal Error: Failed to thin feature table2019-12-10 09:54:57| 1.1| 0.0|ERROR |Internal Error: Failed to thin feature table Is this something buggy or excepted behavior? What is the best way to ‘catch’ this situation and still go on with the map production flow when all other data is written?A simplified w

I've used a method in the past with a WorkspaceRunner to pass a timestamp value into the log file name parameter of a second workspace to ensure that I always get a unique logfile for each rn of the same workspace. But, that's only any good when I can trigger the process in this way. Right now, what I want to be able to do is to use a scripted parameter ideally to generate a unique log file name that is say a concatenation of the workspace name and the start time so like: FMEBatchRun_2014-03-12T12:01:52.log.  Is a scripted parameter the best option for this and if so, can anyone help me with the syntax as I'm not much good (any good really) at writing python...  Thanks, Dave

In FME Server 2019 + a new feature 'Automations' was introduced. Among other things this features allows you to create Schedules, however the Schedules only page still exists as well. After a successful restore should I convert all my existing Schedules into Automations? Moving forward how do I decide when I should be using the Schedules page vs building an Automation?

Hi Everyone,We are trying to execute FME workspaces in batches of eight in parallel to avoid license limit issue. The requests are received dynamically above 8 by a java/ python program but the processing should be done in batches of 8 always. Ideally the requests above 8 should go in queue and wait for the last batch of 8 to finish.

attribute transfer from input to another input ? two input no public attribute?how to do ?

Hello, I have the following question: I would like to automate a process that involves running an ArcGIS Python script and then 5 FME workspaces. I thought about doing this with 6 workspaces, which I call using the WorkspaceRunner. For this to work, I would have to use the ArcGIS Python interpreter for the first workspace and after that the FME Python interpreter. Is it possible to set this as an option in each Workspace? I know it is possible to change the standard Python interpreter in the FME Options, but is it also possible to define it separately in different FMW files?Thanks a lot for your help in advance!

The attached workspace contains of two parts. In part 1 I transform an excel document which contains many records of clients and products. Some clients have had only one product, others might have had 10. The result is also an excel document in which each client has only one row. In the row the order of al te products is displayed in time starting with the first product and ending with the last product (in time).In part 2 some checks are done on the data. For example some products of the same categorie may not be handed out within a short time period. The workspace does the trick, but is quite slow. I think things could be made more efficient using loops. I've done some research on the internet but can't find the solution yet. Any help would be appreciated.

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

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

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

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

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. 

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.

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

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  

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!

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

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

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

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