Authoring

Hello,Is there a way to copy several tables from an oracle database to another oracle database?I don't want to have to list all the table separately in a workspace given that I have to deal with approximately one hundred tablesThanks

Hello everyone, I have one question. Is it possible to do next: for example, I have 2 features ( feature_1, feature_2 ) and in their attribute table I want to add more ID from other polygons ( polygon with id 123 and polygon with id 527 ).  Thanks a lot.

SQL Creator is working fine while parameters are provided in query itself. But its not working while using published parameters and embed connection parameters.

I know how to upgrade a traditional readers and writers from an older version to a current version in FME. Is the same functionality applicable to the FeatureReader and FeatureWriter transformers? Or, are reader and writer definitions nested in the FeatureReader and FeatureWriter transformers dynamic and will use the current installed version?

Hi all,  I'm facing a problem while adding an Excel Reader to my workspace: Adding Excel Reader - I'm selecting only one attribute to be exposed: When the Reader is brought into the workspace all attributes are exposed: Is this a bug or am I doing something wrong?I'm using FME(R) 2019.1.2.0 (20190829 - Build 19630 - WIN64) but I've noticed this on older versions as well. Cheers,Eduard   

Hello;I collected all of my data into a single feature how can I separate and put them to put in other attributes?Thanks

Hello;I attached my standardize excel file and desired output file My work space does not work for middle partThanks

Hello to all fans of FME :-)Please, I work with DGN files and I need to work with its metadata - X/Y/Z origin etc. As I found there (https://knowledge.safe.com/articles/849/how-to-extract-and-use-log-information-in-workbenc.html?childToView=102471#comment-102471 - Extract file or table Metadata part), there is only one way, how to get requested metadate, via Python script. Anyway, it looks that script works only for one input file (DGNMetadata.fmwt). But if You wanna load metadata from more than 1 file, other features and their attributes are inherited from first loaded feature.Im not python expert, but I think that it shouldnt works like that.Please, do You any idea, how to reedit python script to load metadata correctly? Thank You so much!Lubo

Is it possible to write ST_Geometry to Postgis database? I don't see any parameters in the Postgis writer that would allow this, so I am wondering if there is any work around?

Hi all,  Is there a way to write a csv to the temporary directory of the fme cloud server and use that file as an attachment? i am using the ($shared_resource_temp) server parameter to identify where the file should be written but this is not writing the data to the temporary directory.  Cheers

I have a a startup python script that will execute in workbench, but after being published to fme server fails when connecting to the SDE workspace. See image below. Any ideas why this might occur?Thanks,FrankHere is the startup python script which executes in workbench and not in fme server:# Name: DisableEditorTracking.py# Description: Disables editor tracking on a feature class. # Import modulesimport os, arcpy # Local variables:TrackingFeature = "GIS.address" # disconnect usersadmin_workspace = r"C:\\Users\\Administrator\\AppData\\Roaming\\ESRI\\Desktop10.7\\ArcCatalog\\SQLDEV_sde_wilco.sde"arcpy.DisconnectUser(admin_workspace, "ALL") # assign workspace environmentworkspace = r"C:\\

Hello everyone, if somebody has some ideas, it would be great. I have 2 excel files. In the first one, I got attributes: indicator_id, indicator_name, iso3, country_name, 1990, 1991, 1992..., 2017 and in the second one I got attributes: ID, Country, Year Deaths, Deaths, Year Birth, Births. I need to get one excel that looks like picture 3 where indicator_name get in the column and all that has to be based on the year (picture one for Afghanistan is 2015 so we have to take the data from the same year from picture 2 ). Thanks.

Hello,I've written a Python script that performs some data extraction and saves the results to a dictionary. I now need to expose these keys and values as attributes to FME.My Python code is simply as follows:feature = fmeobjects.FMEFeature()for keys, values in row.items():    feature.setAttribute(keys, values)self.pyoutput(feature)The only issue is that both the length of the dictionary and names of the key value pairs will be changing on a very regular basis. This essentially means that I do not have any fixed names that I can expose.If possible, I'm looking for a solution such as assigning the attributes to a parameter and then passing this parameter to the 'Attributes to Expose' box within the Python Caller.Is anything like this possible?Thanks,Jamie

Hi, we are having a problem in running a workspace in FME Server.We has FME Server 2016.1.2.1. using FME Desktop we created a simple workflow that connects to a Oracle Geodatabase, reads a Feature Class, creates a new field and fill this new field with a value. We would like to save the result of the workflow in another Feature Class that already exists in the geodatabase. When running the workspace in FME Desktop, everything Works good and the results are successfully but when we published this workflow to FME Server and runs the workspace, FME Server runs the workspace but shows a message saying that 0 feature was written to the destination Feature Class. in the logs i can find the following messages: Features not written - verify feature type fanout/dynamic settings(Check that fanout/dynamic feature type attribute exists and has a value) We are new using FME and can not find the reason of this behavior, we

Hi FME Community,I am using FME Workbench 2019.1, after successfully running a translation, click on the inspector icon, the whole workbench will crash. Tried to uninstall, reinstall still have this issue.Any idea how to fix this?Thanks.

Hi all, I have two source of data, one is introducing an ID code, the second one is a point cloud. After some processing on the point cloud data, I want to use the ID code (coded as a number) as an attribute to offset the point cloud in z. (I actually want to offset z using both the ID code and the Min value of the point cloud). The 'Aggregator ' is messing the point cloud. I also tried featutre merger with zero success. Digging into this issue, i found myself unable to do any attribute I don't find the way to add, merge or replace attributes of the point cloud (or a TIN based on a point cloud) with attributes imported from another data source. Thank you for your help! Jorge

From a workspace I have created an app in FME server 2019.Two of those parameters I do not want the user to see (I uncheck the "Show in app"-boxes in the app-config page), but I want to populate the parameters from outside the app. Is that possible? How?Thanks /Nisse@frro

Hello,I have a workbench that updates metadata by reading a file geodatabase with multiple feature classes. The multiple feature classes will change every time, i.e. in effect I want to update metadata for all feature classes in a file geodatabase based on excel provided for every feature class.I am reading the file geodatabase with directory and file path reader and then using feature readers for file geodabase and raster dataset. They need to be split as raster dataset has a separate reader.Then I am updating the metadata for each feature class based on input excel, which works fine.However, I cannot write the metadata back to the original file geodatabase feature classes using either feature writer in a dynamic way, i.e. write to all feature classes in the file geodatabase or with a dynamic file geodatabase writer.I am getting errors and I run out of options on how to do it.This is how I am reading:

Hello everyone, I need help. I got excel with data that looks like this picture. So, I have two blocks in excel name "CR" and "M". I need to compare attribute "Ownerstag" from block "M" to attribute "Location" from block "CR" and if they are the same then I need to write values from attribute M (column J) from block "M" in attribute "Location" from block "CR". Thanks in advance.

Hello everyone, I have build a FME workflow to "convert" an Oracle DB to a PostGis DB.I have made some test with a small sample of the Oracle DB, everything went well (processing time less than 1 hour).But, when I try to run the same workflow to the whole Oralce DB, which last more than 1 hour, it fails. It seems that my company network/firewall is closing the connection after 1 hour long.I have contacted a network administrator and it will too complex to change this setting of 1 hour.So, is there a tool/transformer/option in FME desktop to keep the connection alive more than 1 hour ?

Hello,Within the user parameter, with a type of Choice with alias (Multiple), is it possible to retrieve the display name AND the value into an attribute?   

I am running an AnchoredSnapper transformer to snap lines to vertexes. after the operation is complete all the lines previous attributes are intact, however when exported to a shapefile the attribute names and values are truncated to one character. I've tried the default attribute definitions as well as played around with the string type and mapped each individual attribute with no luck.

Hi Guys,I'm looking for a possibility to set published parameters of a workspace by running another workspace. My scenario is as follows: I've a set of workspaces with a lot of published parameters in a repository folderfor some users, these workspaces are copied from my repositors to user-foldersinside these user-folders the published parameters must be set to different values workspace.Copying the workspaces to the user-folders is done by a workspace to avoid interactive work. But I can't figure out if the second part of my task (definition of the published parameters) can also be addressed to any FME functionality, or if I have to do this manually. To be 100% clear at this point, usage of a batch-command or a Workspace Runner to set published parameters at runtime is no option in my case! I must be able to run the user workspaces in FME Workbench without any tweaking of the published parameters, ex

Hello, I make a Workspace to import CAD Data in Oracle Spatial.  In my CAD file, i have some layer with accented character like 3.1 MP - A désaffecter.  When FME read Autocad Writer i have the error : "ACAD reader: The encoded string is not a valid fme-wwjd string: '3.1 MP - A d\\xC3\\xA9saffecter'"  In other workspace, I met same problem with parameters which contains accented character or with excel files with accented character.  Can you help me? With FME 2018, i hadn't this problem.  Thanks  Bernard Dinon 

How to set the attribute name to published/private parameter value in FME 2019.1 ? Is it possible to do ?Original post here:https://knowledge.safe.com/questions/2329/renaming-an-attribute-name-to-a-parameter-value.html