Authoring

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    

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

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. 

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

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

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 

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?