- - 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

dheeraj

asked in Authoring

Multiple CAD files to multiple File Geodatabase (*.dwg --> *.gdb)

Hi, Query regarding how to perform the following task:Need to process the translation from multiple CAD files with dynamic schema to multiple file Geodatabase.(*.dwg --> *.gdb)for e.gabc.dwg --> abc.gdbdef.dwg --> def.gdbghi.dwg --> ghi.gdbprobably fanout is the process but need guidance how can i do it in best and easy way.Thanks in advance.

Many of our ArcSDE connections are OS Authentication and not username/password. How can I connect to the SDE instance with ArcSDEQuerier? It seems that the ESRI Geodatabase reader/writer uses a connection file but the Querier doesn't.

111

7 years ago

jatoxaContributor

asked in Authoring

Subtract list values from eachother based on index.

Hi, For some reason I have a problem wrapping my head around this and I know it might be easier to solve with a script. I have a list containing different numeric values and each value has an index. How would I go about to subtract one value with the next based on the index? For example; If index = 5 then subtract value5 from value4 If index = 4 then subtract value4 from value3 If index = 3 then subtract value3 from value2........ etc. There could be any number of values in a list so I need to somehow loop through all the values. Thanks!

Need an idea for a new useful custom transformer or format!

So... until my new job starts in October, I have some time to kill! I'd love to build a useful custom transformer or format and share it on FME Hub, but the problem is: I'm out of ideas...Do you have an idea for a transformer/format that would really be helpful to the community? So not something that only applies to your unique situation, but can be used by everyone? Post it below and who knows... it might appear on FME Hub the next coming weeks! Your name will be mentioned of course :)

Adding transformer to Workspace using single click in FME 2017.1

Hi,I have just upgraded to FME 2017.1 and want to be able to add transformers using a single left click - like I could using FME 2016 - however it looks like it is defaulting to double click. Is this a setting that can be changed?I try to minimize the amount of double clicks because of RSI.

7 years ago

casper

asked in Authoring

Testing on a group of rows

Hi everyone! I'm new to FME (using 2016) and have a question that keeps bothering me.I have an excel sheet with inspection results from a different company, these are based on different parts of an object. Each row is a different part of the object, with a column with specific inspection results. If any of the parts of the object has a value in the inspection column, I need the entire object to be copied to an output sheet. If none of the parts of an object has a value, the entire object needs to go to a different output sheet.The input looks like this (simplified).And the result should look like this:The objects with any row that contains a value in InspectionResultThe objects with without a row that contains a value in InspectionResultIt seems so easy, it looks like testing on a group but I can't figure out a solution. I tried selecting (tester) only the rows with a value, make a list of unique value of objectnumbers (list builder) and merge them again to the original table (

loop? for this.. if so how?

Hi All, I'm a novice. I have a MSSQL_ADO reader working on a non spatial table. My next challenge is to find the best way to iterate through a field in that table and use that value (which is a set of table names) to copy a Feature Class of the same name to another DB. I have done some reading and video watching on loops but haven't been able to implement anything that does feature by feature only the entire record set. If that's the best approach. I've no problem writing loops in Python\\.NET or cursors in SQL Server but I'm trying to avoid code. Regards, Richard

Find out group by Max and Min value

721

7 years ago

johnglickContributor

asked in Authoring

Anybody have examples connecting to office 365 calendar?

hi, i need to connect fme to an office 365 calendar. has anyone done this, any tips, resources available?

how to create the database connection into fme workbench software from c# window application ?

7 years ago

ngstokeContributor

asked in Authoring

Error prepending < FME_HOME>/plugins/ to path environment variable

I keep getting this line when I run a translation. FME still works but it seems to pause for a few moments before it starts:Error prepending '<FME_HOME>/plugins/' to path environment variable.The addition may not exist, or on Windows the resulting path may be longer than 2047 charactersAny ideas on how to correct this?Thanks in advance.

remove attributes on read

On the FME roadshow someone mentioned there was a way to remove attributes on the reader to improve performance. Unchecking attributes on the feature reader properties User Attributes just seems to hide them but reads these attributes anyway - eg. hidden attributes still appear in Data Inspector. See attached.

Hi,I'm sorry if there's already a discussion about that, but I havn't found it.Here's my problem :I'm requesting a Solr index to fetch some datas, and I'm using an HTTPCaller to do that.There's more than 10M documents indexed and I can't fetch them with just one Solr request.So I would like to first, fetch 200 000 datas, from 0 to 200 000, and then fetch 200k more datas, from 200k to 400k etc etc... (I hope I'm clear).I'm able to pass attributes directly on the Solr url used to fetch those datas. I've also find a way to know dynamicly how many times, I'll have to loop. But I don't know how to loop, on the caller, and change the variables on it to increment the number and the range of the datas I need to fetch.So do you know any way, to loop and fetch the datas 200k per 200k ? Thanks by advance, Kind regards,Nicolas

want to pass credential to FME workbench from C# window application .

7 years ago

fmelizardContributor

asked in Authoring

How to formulate the names of existing attributes using values from another attribute?

In this scenario, the source data has some attributes with names following a common pattern. e.g. test (a), test (b), test (c), etc. We want to use all of these attributes on the left side of some test clause (in TestFilter). Instead of manually selecting every attribute, is it possible to use a formula to represent test (a), test (b), test (c)? We do have an attribute "name", whose values are a, b, c, etc. Also, the right side of the test clause can be set with the same expression, for all of these attributes. Any suggestions would be much appreciated!

7 years ago

jamesclarke

asked in Authoring

Create list based on Raster Nodata values

I've got a large number of raster tile and would like to create a list that shows how many have a certain nodata value, for example, how many have a nodata value of o, how many have a nodata value of -39 to -1 and how many have a nodata value of <= -40. What would be the best way to do this?I've tried a few different methods but so far have only ended up with empty csv files.Thanks.

104

7 years ago

sussexpeteContributor

asked in Authoring

How to get the Current Working Folder

Hi.I want to include the name of the "current working folder" (e.g. H:\\00-Data\\FME\\PlanningSitesForGIS) in the body of an emailer so that the recipient can see where a workspace has been run from.I am using the FME_MF_DIR parameter to do this but as it is listed separately from "current working folder" in the log, wonder if this is correct?I would also like to know if the parameters FME_MF_NAME and WORKSPACE_NAME are one and the same?Many thanks for any help

Reader: how to determine if an attribute is exposed or not?

Hi all,the following use case - please see the screen-shot: Is there any way from code side (C++ custom plugin) to determine that "CUSTOM1" shall be exposed (checked by user) but "CUSTOM2" shall NOT (unchecked by user).In the mapping file, DEF line I still see "CUSTOM2" is present.But from another site if I open saved .fmw file - FME WB knows which attributes are unchecked/checked.So FME WB is aware of that - any way to make my custom plugin (Reader) to be aware as well?Thanks!

7 years ago

fmelizardContributor

asked in Authoring

FME and Memory

I care about memory. What do these FME log file messages mean? FME Configuration: Process limits are 32.00 GB of physical memory and 128.00 TB of address space FME Configuration: Start freeing memory when process usage exceeds 96.00 GB of memory or 128.00 TB of address space FME Configuration: Stop freeing memory when process usage is below 72.00 GB of memory and 96.00 TB of address space I like to tell my processes what to do. How can I control the memory FME uses?

Family data is lost in ArcGIS

I am working on a BIM/GIS project where I need to convert revit models into GIS. I used the FME exporter and chose the 2*3 coordinate view to export to ifc file, then in ArcScene, I use quick import to convert ifc to multipatch. As a result I get the model sorted in revit family, such as wall, column, slab, etc in multipatch form. The 3D model turn to be fine, but there are extra tables attached to each family and I found much of the data in there was lost. I wonder if this is the problem with exporting ifc in revit. (I have pics below to specify)As you can see here in Arcscene, lots of data in the family is lost. For example in the door lining properties, there are null values.

7 years ago

mirzasa

asked in Authoring

Is there a way to update (core or custom) metadata fields of a dataset on Socrata Open Data Portal?

Is there a way to update (core or custom) metadata fields of a dataset on Socrata Open Data Portal? Socrata Write seems to only update data.

My Shutdown Python Script is calling arcpy to run the Arc Extend and Trim tools on my dataset, is there a way to have inspector display the results?

7 years ago

mark_f

asked in Authoring

Data Inspector via Windows Remote Desktop

Anyone using FME via a Windows Remote Desktop? Whenever using Data Inspector on my office based PC and I select a polygon feature inside the Remote Desktop session, my local machine Remote Desktop process starts to consume around 16% CPU and makes it unresponsive. Clearing the selection returns the CPU to 0%, as does minimising the Data Inspector.This only happens when you select a feature, and the geometry is more than a simple geometric shape (rectangle, triangle, circle etc.), but doesn't have to be super complicated. Thought it was transparency related at first but it doesn't appear to be as get the same effect with solid colours.Clearly could be an issue with the graphics driver on either PC but wondering if anyone else sees the same?Sample data attached.Remote Desktop running locally on Windows 10 (but saw same issue with Windows 7)Data Inspector running remotely on Windows 7FME 2017 (but see the same on earlier versions)

How to merge two datasets based on matching attributes

Pl. see attached zipped excel file to find the explanation of the problem statement

How do to split features coming into python caller?

I have 2 features feeding into a Python Caller and I'd like to separate each feature into it's own array. When I read an attribute that is in the first feature, but not the second, I get several None values in addition to the first feature's values.

5415

7 years ago

Page 80 / 122

Badge winners

nick_ahas earned the badge Integrate Data with the FME Platform Training
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

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.