Best Answers

I have two line datasets. Dataset A was created by using the snipper on dataset B (attributes BeginMeasure and EndMeasure), resulting in 15 segments in dataset A. They are both saved in SDE. Now I want to use the LineOnLineOverlayer to segment dataset B (only 1 segment before segmentation). I would expect that there will be 15 segments with _overlap = 2, and attributes from dataset A at each segment. Except that is not what is happening. There are only 10 segments with _overlap = 2, the rest are 1, which indicates that the two datasets do not overlap completely which is weird since A was created by B. I'm attaching the ffs for each dataset as well as the result ffs. What is going on and how do I fix?

I am trying to use the WorkspaceRunner to start another workspace. Two parameters are sent along which are linked to published parameters in the latter. One of the published parameters include the "|" character (something like "|abc|def"), causing the workspace that includes the WorkspaceRunner transformer to fail. The Transaction Log has the following output:illegal use of | or |& in command' contains invalid characters and could not be converted into an integer (stfutil.cpp:738)If the published parameter requiring the "|" character is omitted from the latter workspace (ie, it is not required in the WorkspaceRunner anymore), all works fine and the latter workspace is executed as expected.Is there a way to escape the "|" character so that it is not interpreted as a special character when the workspace is run? I have tried |abc|def, "|abc|def", "\\|abc\\|def", ""|abc|def"", ""\\|abc\\|def&

Hello,I am trying to work with data from OpenStreetMap, and I have an issue with retrieving tags. The only tags I get are the ones related to 1st level types. Other attributes appear in the inspector right panel, but I cannot access it from in my workflow. So what is the difference between attributes from the Table View and the Feature Information ? Is there any way to access those specific features information from the Workbench ? Strangely enough, when I check the "Determine feature by scanning the entire dataset", all tags also appears in the Inspector Table View (with a lot of missing values). But I cannot use that option from my main workflow, as my dataset is an URL (returning an OSM XML file). So far, I am only looking for a few attibutes on a few elements, like the "layer" value for highways (which indicates if they are underground and above or below other highways).  Any help would be much appreciated, as this is very important for my work :)

I have a workspace that can generate a table with permutations of rows = 1 to x and rows = 1 to x to possibly create table variations from 1x1 up to at most 10x10 (see pictures). I'm looking for suggestions on how I can create images out of the table created. I'd like to see the format similar to the picture I attached. My 3rd sample is a 12x12. I'm using this pictures for a underground conduit inspection form. Sequence as well as matching picture matter to the users. Attached is my workspace to generate each table. I'd love to be able to create all 100 pictures using one workspace.

I have several hundred TIFFs that I want to load in to a File Geodatabase (FGDB) raster mosaic. ArcGIS allows you to load one image, then mosaic additional images into the same raster. I'm trying to do this with FME.So far, I have tried the following:1) RasterMosaicker, but that seems to create the mosaic in memory or temp before writing one huge raster to the FGDB.2) Read several TIFFs (e.g. select 2 TIFFs or specify *.tif in the Reader) and send to the same FGDB raster dataset (i.e. no fanout on the Writer) with Drop Table set to "No" for obvious reasons. This loads the first image then fails on the second with "ERROR |Failed to write raster data tile when writing to raster dataset 'TIFF2'. The error number from ArcObjects is: '-2147467259'".3) Using the Path Reader to get the TIFF names, then sending these 1 at a time to a second Workspace using the WorkspaceRunner (Wait for Job to Complete = Yes). The second Workspace loads the TIFF into

FME People, I'm trying to limit the number of source values I use in the AttributeValueMapper by using the following statement as my Source Value: @Value(LAYERTYPE) Ends With _Wd, In other words I have many different attribute values ending with "_Wd" and I want to reassign all of the those to one new value. The destination attribute ends up being an empty value. I moving data from SDE (oracle) to a file geodatabase.Gary

Hi there,I have a table (lets call it TableA) which contains a field (lets call it Types). I need to compare each value in the Types field with ALL of the values in another field (lets call it OriginalTypes) which is in another table (lets call it TableB). If there is a match a value gets updated, if not nothing happens. Currently I have these 2 tables feeding AttributeManager which has a Condition Statement checking if Types In OriginalTypes but this is not producing my expected results. Any thoughts on what I am doing wrong here or what might be a better approach?Regards

Dear people,I've to use zip files for input, and this file name is the actual date so that change everything, how can I do for that ?Thank you for your help.

I have a SystemCaller that simply deletes a file. I would assume if the deletion is successful, it would give code 0, otherwise 1. However, it always gives 0 whether the deletion is successful or not (for example, I keep the file open before hand to cause the deletion to fail). Any workaround? I could use PythonCaller to do the deletion and generate an exit code, but would be nice just do this simple operation in the SystemCaller.

Just want to convert from string containing fractional numbers (e.g., 4 1/2 2 7/8...to decimal doubles 4.52.875...Anyway to not use multiple transformers for this? ( I know I can separate the fraction from the whole number, then value map the fractional segment to decimal segments, and then patch the number back together via concatenation...). However, I thought I'd check to see if I'm missing something less bulky.Many thanks, Pete

Hi,I have a TXT file (point cloud) containing 2 columns col1=X and col2=Y.I want to create groups every 1cm (according to X axis) and compute for each group Xmean, Ymean, Ymin and Ymax.I think it is necessary to create a point cloud and then create slice of points (every 1cm) but I don't know how to do this.Thank you for your help.

The following lines of code work when run as an independent python script, ie python script.py.  These lines also work when run in the startup portion of the script.  The exact same lines however do not run when run in a shutdown script.  When run in a shutdown script the fme.exe process crashes and I get the following error in fme log:Precondition failed at stfconf.cpp:798. Expression: instance_ != 0The lines of code I am trying to run read a static .ffs file. They are:ffsFile = r'<path to any .ffs file you have>'import fmeobjects# The following line never completes.reader = fmeobjects.FMEUniversalReader('FFS', False, [])reader.open(ffsFile, [])feature = reader.read()featureCnt = 0while feature != None:    featureCnt += 1    feature = reader.read()print 'featureCnt:', featureCntreader.close()I am trying to do some automated reporting of failed features after the script has completed by reporting on the number of features that did not pass, and possibly more information down the 

I have a raster dataset stored in a file geodatabase and when I read this into a workbench the nodata bit masks for each band are merged into a single additional alpha band named geodb_nodata as default and stated in the help documentation.When I view the grid in the inspector Band 0 contains data values and a value of 0 or -3.40282e+38 for nodata cells. Band 1 (ALPHA8): geodb_nodata contains a value of 0 for nodata and 255 for cells containing data. My question is how can I set the values in Band 0 as nodata using Band 1 (ALPHA8)? I assume it's a combination of using the RasterSelector with the RasterBandNodataSetter transformers, but no combination has worked for me so far.Specifically, I want to set the values in Band 0 to nodata using Band 1 and then sending the output to a RasterCellCoercer transformer to create points for all raster cells containing a value i.e. excluding nodata cells.Thanks

Right now I test if MTF (manged file transfer site) or UNC file location are going to pass, because what's the point of proceeding if network IT services are not available for file storage. If I terminate I'll have the find failed email and manually resend to FME Server. Is this possible for FME Server to hold the job and resubmit in an hour instead of just terminating?

I am using FME to convert ESRI Raster Dataset orthophotos to an .ecw file and there are some very ugly black pixels added to the border.

Im simply trying to get fme to use FileCopy (so that I can copy csv files inside a large zip file (about 4 gigs)) to a network folder. I only used a reader with format set to CSV, dataset set to the path of the zip file, and workflow options set to Individual (connected to filecopy writer). Are there any issues with fme and large zip files? Is there a better method to extracting a specific file type from the zip than what I used? Thanks for any help--latest error states: "failed to open file. failed to get any schema from reader". i am able to manually use filezila or 7 zip and perform this

I want to aggregate or dissolve a set of input polygons based on 3 fields - Authority, Category, Site_Name. So where these values are the same, there should be one output feature. If the polygons are not adjacent, a muti-part feature should be output (File Geodatabase). If they are adjacent, then I expect them to be merged. However this is not happening. I've tried both Aggregator and Dissolver, individually and together. The boundaries may not be shared, but I believe the polygons overlap, so why aren't they being merged?In the attached image, the blue fill is the input, and the hatching is the aggregated/dissolved polygons.Also, there are 2 blue polygons on top of each other in the middle, but in the output there's no polygon visible.

https://www.safe.com/transformers/kml-view-setter/I've been looking at the KMLViewSetter transformer, but when I set lat/long values in there it continues to open to the default location in Google Earth. I've tried using the values in the doc example, but it still opens to the default location.  I might be missing something - but has anyone got this to work and could help me out?FME(R) 2018.1.0.0 (20180321 - Build 18442 - WIN32

Hi,I have a workspace that makes an initial SQL database call to write to a table that generates an id key that subsequent database writers require. The problem is that the initial call doesn't seem to close/finish writing before the subsequent calls look for the id key. I have placed a feature holder before the subsequent calls but if the records fall below a certain number the process fails (and the initial table is not populated). Over a certain number or records the process is fine. Any ideas?Thanks!Sam

Is it possible to do a substring(0,10) with the BulkAttributeRenamer? I want to simulate truncating the columns as writing to shape does. I know I can do this with a SchemaMapper, this is my current workaround.

I am trying to add file reference to a job submitter from an email that come is through the notification service. The email comes in here:Resources /System /temp/emailattachments/20180323010138-tgsdata@production-tgs.fmecloud.com-test/autocad.dwgI had use the email attachments before when they came into ${FME_SHAREDRESOURCE_TEMP}/${FME_JOD_ID}

Hi, I have created some JSON in FME but would like to remove the first couple of levels.At the moment I have:[    {        "output" : {            "status" : "200",            "body" : [                {                    "well_id" : 25325,                    "well_name" : "MYALL_CREEK_3",                    "latitude" : -27.046011,                    "longitude" : 149.236806                },                {etcideally I would like to remove the "output" level[    {            "status" : "200",            "body" : [                {                    "well_id" : 25325,                    "well_name" : "MYALL_CREEK_3",                    "latitude" : -27.046011,                    "longitude" : 149.236806                },                {Could you please tell me how to achieve this.For reference my workbench looks like: Many Thanks,Oliver 

I have a Condition Statement within AttributeManager that checks if an attribute has a letter at the end of the value. If this is true then I use Substring to drop the last character.However, when I use the above it always returns the original value (ex. 999a returns 999a instead of 999).It does not seem to work with any negative number at the end but if I change -2 to a positive number like 3 it works and returns 999. Any thoughts on what I am doing wrong here?Regards

I am using a Condition Statement in the AttributeManager to check if the attribute ends with a letter. Using [a-z] does not seem to work and I am assuming it is because the test sees it as text not a Regular Expression. Is there a way to get this to work or do I need to have a Test Clause for each letter of the alphabet? Regards

Hi all,   I am using FME Workbench 2018.0 Build 18284. I would like to run an update to sharepoint list on Sharepoint Online.  Readers:Sharepoint list using (http link to the sharepoint rather than https; using https would run into an "Error message 403- error authenticating via SAML" (log-in details are correct)Excel spreadheet with new lat/lon values I am using a feature Merger to update lat/lon column in sharepoint list Writer the same Sharepoint List - when specifying the url to http://XXXX.sharepoint.com/Projects/XXXX the translation runs into a Client-side error: '405 Client Error: Method Not Allowed for url: https://XXXX.sharepoint.com/Projects/XXXX/_api/contextinfoI have not specified the above https url ending in _api/contextinfo- when specifying the WRITER url to https the translation runs into the above 403 SAML error  Do you now of any ways to work around these errors or are they possibly solely due to my sharepoint security settings?  Thanks a lot for