- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,026 Posts
12,531 Replies

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

3026 Posts

Recently active

Most replies Most views Newest first

qed

asked in Authoring

Create Another Record from Multiple item list

Apologies for cross posting. What i'm trying to achieve is from this Excel table ----------------------------------- | Name | Listed_Item | ----------------------------------- | Mr A | [1234] | | Mr B | [6352], [2344] | ----------------------------------- TO ----------------------------------- | Name | Listed_Item | ----------------------------------- | Mr A | 1234 | | Mr B | 6352 | | Mr B | 2344 | ----------------------------------- I using StringReplacer to remove the "[ ]". Beyond that, I not sure how to go abt it. If anyone can just point to me the transformers needed to produce this. Thanks.

396

7 years ago

fmelizardContributor

asked in Authoring

problem returning python generated value to published parameter

HiI have an FME process that uses as its inputs a GDB file and its associated XML schema file. I want to generate the XML from the GDB at runtime, and I have a python startup script to do this in ESRI - this works. My issue is with populating the parameter for the XML reader to set the location (for the generated file). I've read through some of the articles and previous questions, and this one seems to be what I'm looking for, although given I'm not python literate/new to it, I wasn't able to make the solution work for me - apologies for the ignorance. https://knowledge.safe.com/questions/4296/set-published-parameters-in-a-python-startup-scrip.htmlI think I need to add 'import fmeobjects' and 'return ResultsXML' added to my current script (below), but when I do so I get an error about return statement being outside a function. I don't know how to place it inside a function,.. help please. Assuming that works, how do I expose it within FME? I was thi

163

7 years ago

samisnunuContributor

asked in Authoring

Passing Named Connection Value from attribute

Hi,In workspace_01 I have a WorkspaceRunner transformer that runs workspace_02 that uses a SQLExecuter transformer. The SQLExecuter utilizes a parameter to receive the Named Connection required (e.g., gisdata_01@SDEDB or gisdata_02@SDEDB, etc..) that's working great.However, the issue happened within the workspace_01 with the WorkspaceRunner, unless I select from the available named connection to assign, the workspace_02 won't work successfully; i.e. assign by 'Attribute Value' or 'User Parameter' from the sub menu.A closer look into the log window revealed how the parameter was interpreted/passed to the workspcase_02 as:--SDE_NAMED_CONNECTION {\\<at>Value<openparen>_Named_Connection<closeparen>}While it should be:--SDE_NAMED_CONNECTION' `gisdata_02@<at>SDEDB' `#FME 2016.1Please help

7 years ago

johnbyrnejb

asked in Authoring

Expose FeatureWriter attributes

Hi All,I might be asking a silly question but here it goes:I am trying to pass some records through a Feature Writer and off the back of that pass the unique id of the written records into a SQL stored procedure so I can track it has been written successfully. However if I use the Feature Writer then I lose the attributes in the summary and therefore can't use the unique id in my stored procedure :( Is there a way to expose this attribute so I can use the unique id. I have attached some screen shots.

How can I export 3D building, textures, and attribute from Revit 2017 using FME exporter for Revit to ArcScene?

Hi, Could anyone please help me to transform the 3D object from Revit to ArcScene? I exported the 3D using FME exporter to get RVZ file, however, when I tried to visualize the result in FME data Inspector, the texture of the building wasn't appeared or transformed. I am not sure of the options I have to choose from the Export dialog to export the texture. Any Idea? Also, I transformed the RVZ file as it is (without texture) using FME Workbench Desktop to Shapefile and I have noticed that the multipatch layers for the building didn't come/merge in one attribute in ArcScene, and of course the texture was not appeared as well. Thank you,

Why use fme over python and arcpy?

Hi guys,I probably can say I'm at the point of being very confident with my skills in using python including libraries such as os, xlrd/xlwt, numpy, arcpy etc. I can create simple to complicated scripts, which can have simple line of codes, or several functions or several class objects and I can pretty much work seamlessly side by side with ArcGIS. In our office we have FME. I am finding it difficult to see any reason why I should use it over my pythonic process. I am thinking if only I encounter a very unique data format that python thru arcpy or another library cant read will I use FME to possibly do some translation. Other than that, any spatial operation I can fully use arcpy. But I don't want my boss to think I'm wasting our investment. I want to use it but cant find anything on the web that will convince me its a practical tool over things I can set up with python.

Conditional attribute evaluation one input, depending on value, two different outputs targets

Folks, first post and rank newbie. I've been using Mapinfo for 25 years and MSSQL for 15 so the basic GIS and query stuff I know well. First time user of FME.I've had a live chat today and the SAFE guys were super helpful but it's clear my lack of understanding of the FME nomenclature has prevented a better outcome.Hopefully I can explain here what I'm after.I have some Mapinfo tables and want to create a GML. That's the easy part. The hard part is that I have a single Mapinfo ID column that could have two different formats. One integer, one alphanumeric. The column is type char.Depending on the value, the ID could be written to a GML tag, techID OR name.My understanding is I use an AttributeManager (I could be wrong) and that I can somehow create a condition that will produce different results.However all the examples I've looked at seem to evaluate the input value, modify the value and insert the modified value into the target field.There doesn't seem to h

How do I create, install and use a custom writer?

I created a custom reader and writer with the wizzards in the reader and writer gallaries. I can install and use the reader, but I can not install and use the writer. Attached the reader, writer and an example file.

103

7 years ago

nic_ranContributor

asked in Authoring

Generic workspaces with custom processing configured at runtime

This may be more of an idea for an FME enhancement but I'm curious to know if anyone thinks this is possible, or if there's a way to do it...I want to create a truly generic/dynamic workflow. The source and target data and schema requirements can be driven by database tables, as can reprojection requirements. The majority of the time this will likely be sufficient to achieve what we need, however, there may be cases in which a simple source->target mapping is insufficient and we need some custom ETL transformations. Is there any way that the name of a custom transformer can be passed in as a parameter at runtime and have that transformer called during processing?This functionality could be partially met by using the WorkspaceRunner or the FMEServerJobSubmitter but both of those transformers fire up a whole new translation for each feature that enters them. What I really need is a "TransformerRunner" transformer. Something that can dynamically include a (custom) tra

610

7 years ago

gisgeekContributor

asked in Authoring

Preserving attributes

I am trying to update a feature class in sde with a new one. Two of the fields in the existing table are not in the new table so I want to add them to my new table. I have tried featuremerger and not getting the results I want. This seems simple enough but featuremerger isn't copying over the additional two fields. One is modified user and the other is a Gazettedate. Any help would be appreciated to resolve this issue.

7 years ago

garydlester

asked in Authoring

Running a workspace from cmd.exe

I'm trying to run a workspace from the command line and I get an error that the metadata template cannot be read, I am not an FME user and I am coding this for another department in our company. Any help is much appreciated.import osgdbW=r"C:\Users\YouDoWellItDoesGood\Desktop\1701051\DB_TGS_8171_AF2113452_30_C00_00_20170210.gdb"qcWorkspace=r"C:\Transglobal\larry_d_gester_qc_basic.fmwt"def fnRunFromCmd(gdbW,qcWorkspace): os.system("start cmd /c fme.exe C:\Transglobal\larry_d_gester_qc_basic.fmwt --gdbPath C:\Users\YouDoWellItDoesGood\Desktop\1701051\DB_TGS_8171_AF2113452_30_C00_00_20170210.gdb")fnRunFromCmd(gdbW,qcWorkspace)

413

7 years ago

takashiContributor

asked in Authoring

Issues on Date/Time User Parameter

Testing a workbench from a certain point

Hi,When testing a workbench files with a large number of features, is there a way to only test a certain part of the workbench instead of reading through the whole workbench every time you run it, so as to save time?I have access to FME Desktop 2016 and 2017.Thanks

7 years ago

princeravinderi

asked in Authoring

Regarding FME(tools for content mgmt) meta data reading

Hello All,Greetings !!I am new to FME tool and wanted to check with you folks here. We have to do a migration of few contents to Documentum, wanted to know the list of meta data files which are supported by it? Could you please help in same, will be grateful to you.Thanks,R. Singh

7 years ago

jonathan

asked in Authoring

Converting list values to an attribute depending on other list values

Hi All,In 2016.0, I have a list like this: _list{0}.class = 1 _list{1}.class = 2 _list{2}.class = 3 _list{3}.class = 5 _list{4}.class = 2 _list{5}.class = 1 I need to know how many of any given class there are with the feature.ListHistogrammer does this nicely: _histo{0}.value = 1 _histo{0}.count = 2 _histo{1}.value = 2 _histo{1}.count = 2 _histo{2}.value = 3 _histo{2}.count = 1 _histo{3}.value = 5 _histo{3}.count = 1 My problem then is turning those into attributes simply. I don't want to have to explode or deconstruct my feature further (this workspace is already too large and slow). In this example, I'd like my output feature to have attributes like these: first_class = 2 other_thing = 2 third_item = 1 fourth_item = <missing> final = 1Any ideas how to do this? I could likely do it with a PythonCaller, but surely there's a better way?

Download multiple workbench files from FME Server for use in FME Desktop?

Is there an easy way to download (or backup) whole repositories from FME Server 2015.1 to workbench-files for use in FME Workbench (Desktop)? In older versions of FME Server I could locate the files in the file system on the server, but not any more.I'm not really interested in backing up the whole server configuration and I not sure how I would use that from FME Desktop.I have seen the FME Server Repository reader/writer and in the help it seems that it can be used for backup, but I haven't figured out how to do that. What I would want to do is basically do a "Download from FME Server" in Workbench, but for multiple files or whole repositories.Any suggestions?/Tomas

10810

7 years ago

oscardInfluencer

asked in Authoring

Custom transformation issue

Hi.I have defined a custom transformation in the file "MyCoordsSysDefs.fme":XFORM_DEF Test \\ SRC_DTM ED50 \\ TRG_DTM ETRS89 \\ DESC_NM "7 parametros" \\ GROUP "Custom" \\ INVERSE Yes \\ MAX_ITR 8 \\ CNVRG_VAL 1e-09 \\ ERROR_VAL 1e-06 \\ METHOD 7PARAMETER \\ DELTA_X -130.5090 \\ DELTA_Y -89.9490 \\ DELTA_Z -145.9030 \\ BWSCALE 5.2690 \\ ROT_X 3.1126 \\ ROT_Y -0.4718 \\ ROT_Z 3.3181How can I tell FME to use th

145

7 years ago

erik_janContributor

asked in Authoring

How to use Data Download after FMEServerJobsubmitters?

Hi all,I have the following scenario:A "master" workspace calling 3 other workspaces on FME Server 2017 using FMEServerJobsubmitter transformers.Followed by a FileCopy writer (in the same "master" workspace) copying the files on the FME Server (using the resources folders).This works perfectly (files are created and copied to the right location).But I want to run the "master" as a Data Download service.The ZIP file is created and a link is delivered. But the ZIP file remains empty.It does not seem to collect the output from the FileCopy writer.Am I missing anything (other than the option to re-read the data using a FeatureReader and writing using actual writers)?Thanks for any suggestions.

153

7 years ago

takashiContributor

asked in Authoring

Input Ordered parameter doesn't work in FME 2017?

Hi there, I don't think the Input Ordered parameter (Input is Ordered by Group in older versions) works properly in FME 2017.0 build 17271. See the following movies and attached workspace: - created with FME 2016.1.3.2 build 16717Run the attached workspace with FME 2016.1.3.2 build 16717. Looks good.Run the same workspace with FME 2017.0.0.1 build 17271. The PointCloudCombiner seems to cache all input features before starting processing, even if the Input is Ordered by Group parameter is set to Yes.Am I missing something?

7 years ago

takashiContributor

asked in Authoring

Conflict between Format Attribute and Writer Parameter

We sometimes encounter a conflict between a format attribute held by the feature and writer parameter setting, especially in a case where the writer format is the same as the reader format.It may be difficult to define generic rules regarding which one should take priority, but in this case, I think the Compression Method parameter setting for the writer should be respected regardless of the value of "geotiff_compression_method".Convert Packbits geotiff to lzwHow do you think about this?

7 years ago

slop

asked in Authoring

FME desktop VDB connection

Hi,I'm new on FME and I've to copy data from a VDB to oracle. I'm working with FME 2013 SP4, I think I've to initiate a new reader with the JDBC driver but I don't know how.Is it possible to have some help/information about that ?Thanks by advance,Slop

510

7 years ago

jelleContributor

asked in Authoring

update with Oracle writer based on equal geometry

Hi All, during the process, I use the Matcher to split up the features that have identical geometry. For this set of features, all kinds of attributes can have changed (in other words, there is no fixed ID). Hence, I would like to use the Update Operation of the Oracle writer. I cannot use the 'Match Columns', since they all might have different values,even though the geometry is equal. Is there any way to have a WHERE clause I could use? I see SDO_EQUAL, but what are the arguments for the geometry already in FME and the one in Oracle, so both can be compared? Would that be slow?I could use a delete statement and then an insert, using FeatureWriters, so I am in control of the order of execution. I was just wondering whether it would be possible to make it work like described above. regards, Jelle

7 years ago

masoj1

asked in Authoring

Editing a .dbf table - find and replace attributes

Hello All, I have a .dbf table created in ESRI's UK Productivity Suite - it's simply a table to point to raster files of base mapping, with a field containing the file path to .tif files, an OID field and fields for xmin, ymin, xmax, ymax. My problem is that I want to find and replace the file path with a different path. I have tried this in ArcMap but the file locks and isn't editable. I can't even think what Transformer I need to do a find and replace of text! I'm sorry - it's Friday and I'm very tired..... I'd be very grateful if anyone is able to help. Many thanks, Jane

212

7 years ago

fmelizardContributor

asked in Authoring

how does seed file work in FME workbench

7 years ago

annette2Contributor

asked in Authoring

Writing to Dutch Kadaster SFN format

258

7 years ago

Page 87 / 122

Badge winners

reveszhas earned the badge FME Flow Authoring Training
magdahirschhas earned the badge FME Certified Professional
sandrawanghas earned the badge FME Flow Authoring Training
mglancloshas earned the badge FME Flow Authoring Training
halinakozak29has earned the badge English Speaker

Show all badges

30,159: 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.