Authoring

I am trying to use a GUID field to update records in an ArcSDE Writer. It seems to work perfectly when using an integer field for the Update Key, but when I use a field with type=guid the update does not go through.

Hi All,I'm very new to FME, so I apologize if this is a silly question.Is it possible to re-run only part of a translation?I have a series of transformers (clippers and surface modelers) which make up my translation, the whole thing takes 6 hours to run. I let it run over night and when I checked the output file this morning I realized I messed up something in the last transformer.I changed the parameter on the last transformer and it should be good now. Is it possible to just run the last transformer or should I re-run the whole thing and wait 6 hrs. I see the numbers of features on the connections between transformers, so I was hoping they're stored somewhere on the memory and don't have to be recalculated.

Hi folks,This is my first post here so apologies if this is a basic question. I have a quick one about a workspace runner operation I am using. I have a project that makes sense and is working but I'm looking at trying to make it more efficient.It takes 2 files, workspace runner passes it file A, the workspace runs and matches variables in A to another static file, file B. then outputs the resulting file in File C. This all makes sense. It works beautifully.However it would be nice if I could read file B once as oppose to every time the work space runner fires off a process. It's a static file and quite big, and I have about 17,000+ file As to process, loading in File B for each of these is a massive drain on time. Is it possible to 'preload' a file for a workspace runner? I've looked everywhere for an answer but not seen anything that leads to an answer.  

Hi,I don't get the difference beetween these 2 user parameters (FME 2017.1) :Text (multiline)Text (multiline) or Number"Text (multiline) or Number" don't have a configuration button to specify numbers limits (like the Number parameter), so what's the point ?Regards, Mathieu.

Good morning!I'm trying to implement an ATOM feed with FME Server 2017 that fulfills the INSPIRE requirements.I've been following this tutorial for the first steps: https://knowledge.safe.com/articles/1340/create-inspire-atom-download-service.htmlWith that tutorial, the following XML is created as feed:?xml version="1.0" encoding="UTF-8"?><feed xmlns:gml="http://www.opengis.net/gml" xmlns:georss="http://www.georss.org/georss" xmlns="http://www.w3.org/2005/Atom"> <generator version="2015.0" uri="http://h-0106"/> <id>http://myweb/Catastro</id> <link rel="self" href="http://myweb/Catastro" type="application/atom+xml"/> <rights>data.gov.uk</rights> <subtitle>Smoke control areas declared under the Clean Air Acts</subtitle> <title>INSPIRE ATOM Feed: Smoke Control Areas</title> <updated>2015-02-23T16:15Z</updated> <entry> <author> <name>Brent Council</name> </author> <categor

Hi,I recently needed to run the same workspace (command line) with two different target setups, but I wanted to see separate log files for each run. Simplified example:fme.exe myworkspace.fme --p1 ABC --p2 DEFfme.exe myworkspace.fme --p1 XYZ --p2 KLMSo I had FME create a workspace parameter (--LOG_FILE) for this value. This value is normally blank, prompting FME to use the workspace file path with "log" extension.I.e. my setup had the first run without a value, and the second run with a value for the log file..However, I found out, that the value given in the second run are somehow reused in the first run at a later time !?!Is this a correct observation, that FME somehow caches the last parameter values given to the workspace, and reuses these whenever the same workspace is run at a later time (and no other values are provided) ??I got my two runs to work only when both set the "LOG_FILE" parameter.Cheers.

HiI have a workbench that takes a csv file and creates 10 csv files , 1 for each site - it does this using AttributeFilter. This works great but the csv reader gives the last 8 months of data with each month as a column. So the first version we ran had Nov to Jun. This latest month is Jan to Aug. So every time we run this the attributes change and I had to manually update this last time. Is there a way of automatically picking up new attributes from the reader and adding them to the writer (and removing any no long needed) please?I'd ideally like to schedule this with server but I can't unless this is automatic. Thanks

Hi,Workspace attached. The first part is the CAD_Parcels bookmark. The second part is the CAD_Properties bookmark. I only want to run CAD_Properties bookmark contents if there are any features in the Update, Insert or Delete ports from the CAD_Parcels bookmark.I assume tester and workspacerunner may be in order. I have to turn this into a FME Server job submitter also.

Hi, for my first time I need to define a Custom Coordinatesystem - since EPSG:3275 is not defined in FME.I have made the following entry under \Documents\FME\CoordinateSystems:COORDINATE_SYSTEM_DEF WGS84.SCAR-SU01-05        \  DESC_NM "WGS84 /SCAR IMW SU01-05"               \ DT_NAME WGS84                                   \ EL_NAME WGS84                                   \MAP_SCL 1                                       \ORG_LAT -80.23861111111111                      \ORG_LNG -165                                    \PROJ PSTERO                                     \SCL_RED 1                                       \UNIT METER                                      \X_OFF 0                                         \Y_OFF 0                                        I do:- Creator, create point with X -160 and Y -82 - Set CoordinateSystem to "LL-WGS84" - Reporject to "WGS84.SCAR-SU01-05" (my defined system) gives an error :Reprojector(TeeFactory): Reprojector: Reproject: Could not reproject the g

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.

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!   

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

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.

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 (

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 

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

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.

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

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!