Skip to main content
  • EN

Authoring

Creating and organizing workspaces. How to use Workbench.

  • 3,287 Posts
  • 13,484 Replies
3287 Posts
tomjerry.vl
tomjerry.vl
asked in Authoring
select more than one special character in a string....

i have HSN field and some times those are having special characters, if it is not having any special character and it having single special character no need to select. But here which string having more than one special character then select.Special characters: /- HSN1-11-11-11/22/21-2/21/2-2/2 In above table i need to select on yellow highlighted data only \\

1050
erik_jan
Contributor
B
bhargavait
asked in Authoring
How to change Oracle SID post FME server installation?

We have FME 2016 installed couple of years ago with an Oracle SID. Now with Oracle migration to cloud, our SID name has changed. post SID name changes, we are not able to login to FME server. Is there any way that SID can be changed and FME can be used again without reinstallation?

82
B
tomjerry.vl
tomjerry.vl
asked in Authoring
I want selected same like little difference names in a field

like these type of name in a field I want selectRavindra BarathiRavindra barathiState Banck Of IndiaState Banck of IndiaRavi KiranRavi kiranRayamal PurRayamal purAndra PradeshAndra PradeshVijayavadaVijayaVada

1110
tomjerry.vl
ekkischeffler
Contributor
ekkischefflerContributor
asked in Authoring
FeatureWriter number of features written incorrect?

I'm using a FeatureWriter with its output attribute "_total_features_written". The attribute holds "_total_features_written"=1 while the log says: Features Written=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==============================================================================Total Features Written 0=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Features With No Schema defined=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-NoFeaturesTester_5_Creator 1==============================================================================Total Features NOT Written 1=-=-=-=-=-=-=-=-=-=-=-=-=-=

726
D
philippeb
Enthusiast
philippebEnthusiast
asked in Authoring
Oracle TO_DATE function into Where Clause

Hello,I have a table with millions of features. I need to use the Where Clause to extract what I want.I'm using a Published Parameter to define a date. My problem is the date format into database (YYYY-MM-DD). And Data Inspector tells me it's encoded windows-1252, not string (don't know if it changes something).I though to use into Where Clause the TO_DATE function to convert my dates.  TO_DATE('@Value(DATE_into_Database)', 'YYYYMMDD') => '$(DATE_FROM)'But it's not working. I get an Unable to execute SQL statement. And I'm not even sure if it's supported by FME because this function isn't into the SQL Date Functions choices. I only have those (the help button sent me there) : SQL Date Functions Do you have an idea how I could extract those dates ?

5390
erik_jan
Contributor
E
emmanuelfrancis
asked in Authoring
FMEERROR

i am trying to learn FME safe as i need it for my career but in the FME 2019 tutorial (basic) I always have this error when running the first tutorial work space. I attached a screenshot of the errorGeodatabase Error (-2147024893): The system cannot find the path specified. Could not open File Geodatabase dataset `C:/FMEData2019/Data/CommunityMapping/CommunityMap.gdb' for reading. In between, i used a MACBOOK PRO and i am running FME 2019.2 student license. Any help please??

421
H
A
aleho
asked in Authoring
Update existing data in postgres

Hello,I think there is a problem with the update of postgres data. I have a table with uuids and dates. The statements for those types are not constructed correctly. FME throws an error for the date like this:'ERROR: syntax error at or near "2009"LINE 1: ...NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, E'2009-10-26... ^You can see that it is used like a string. Same happens usually to the uuid - there no quotes are inserted. Postgres usually expects quotes around the uuids. I also tried the DatabaseUpdater, but the same error occured.

1100
nampreetatsafe
Safer
W
watts
asked in Authoring
fme_feature_type not coming through to writer (excel table)

Hi everyone, I am relatively new to FME and am seeking assistance for a minor issue I am having. As part of a project I need to create an excel table that contains 9999 from various attributes and from multiple SDE feature classes. My excel table works but I want to include an attribute that indicates which feature class the record is from. I exposed the fme_feature_type attribute but am not table to get it to export out into the Excel table. What might I be missing? Please see the below screenshot. Thanks in advance for your advice and suggestions!

1560
W
J
jwcc
asked in Authoring
Indentation issue MSWord

Hi, I'm using MSWord Styler to generate a word document in FME desktop. I have a paragraph which I need indented but it has parameters within which can vary in length. Hence line could spill over and does not keep the indentation. Anyone else have this issue? See example of issue below. thanks.ExampleParagraph construction :Instructions : Please note if any problems using this application, please contact <Name> <Dept>for assistance. It is compulsory to use this application going forward for all customer ordersand inquires.Output as :Instructions : Please note if any problems using this application, please contact Joe Bloggs, Department of Financefor assistance. It is compulsory to use this application going forward for all customer ordersand inquires.

170
debbiatsafe
Safer
arthy
Contributor
arthyContributor
asked in Authoring
Is there a way to copy several tables from an oracle database to another oracle database?

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

1990
david_r
Celebrity
M
maloks
asked in Authoring
Adding more attributes values in one cell

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.

130
takashi
Celebrity
G
gauripearl
asked in Authoring
SQL Creator not working with Published parameters

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

240
nic_ran
Contributor
A
apadilla
asked in Authoring
Upgrade a Writer nested in the FeatureWriter Transformer

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?

80
A
E
edhere
asked in Authoring
Excel Reader: Selecting a single attribute to expose results in all attributes to be exposed [BUG?]

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   

210
E
G
gsaeid
asked in Authoring
How to explode a feature to multiple attribute

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

2540
G
G
gsaeid
asked in Authoring
How to change order of attributes

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

3130
D
lazarlubomir
Contributor
lazarlubomirContributor
asked in Authoring
How to load data from log file - python scripting?

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

570
lazarlubomir
Contributor
mapper
Contributor
mapperContributor
asked in Authoring
write ST_geometry to a Postgis database

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?

660
bigclyde
Contributor
jessebridge
jessebridge
asked in Authoring
Writing data to temporary folder

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

900
nielsgerrits
VIP
billybob
Contributor
billybobContributor
asked in Authoring
Why with a Startup python script work in workbench but not in FME SErver

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:\\Users\\Administrator\\AppData\\Roaming\\ESRI\\Desktop10.7\\ArcCatalog\\SQLDEV_gis_wilco.sde"arcpy.env.workspace = workspace # Disable Editor Trackingarcpy.DisableEditorTracking_management(TrackingFeature, "NO_DISABLE_CREA

296
billybob
Contributor
M
maloks
asked in Authoring
Create new excel based on 2 excel and based on few rules

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.

60
chrisatsafe
Contributor
jamietasker
jamietasker
asked in Authoring
Dynamically Expose Attributes within Python Caller

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

6340
david_r
Celebrity
C
claranjeira
asked in Authoring
error about dynamic fanout when running a workspace in FME Server

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 already search in the documentation but did not find any information that can

5175
C
brandonguo
Contributor
brandonguoContributor
asked in Authoring
FME desktop crashes after click inspector icon

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.

290
nampreetatsafe
Safer
J
jgarciafdez111
asked in Authoring
Using attribute from a different element

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

1850
J

Badge Winners

Show all badges

Community Stats

31,790
Posts
120,757
Replies
39,405
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.