Authoring

Himy question is if one can use a template file in feature writer with excel as output format/F

i have two excel writer but i want to have one excel output has both of them as seperated sheet so i used fme_feature typebut it still give me output as two excel file , i do not know why i used attribute creator then attribute filter to get two seperated sheet but it does not work with me  i used sheet name @Value(fme_feature_type)and also edit parameter fan out and overwriting yes  First excel writer :  because i have many seperated tables so i used output field name NOUSE ATTRIBUTES NAMES AS COLUMN POSITION YES   i have A B C D AND SO ON NAME OF COLUMNS so my question should i used attribute creator for fme_feature_type before connects to excel writer direct and so excel writer will recognize fme_feature_type or should i enter it in each table that i divided  i tried both of this metthod but i did not get my expected output  second excel file utput field names yes and use attribute names as column position no whatever i did not have many tables in this excel sheet so i do not want

I am sure this is probably covered in another post but can't seem to find the right solution :)I have a list that I have exploded into its elements.  I have polygon layer that I need to add each of the names as a column in the polygon table so that I can put a value against each polygon for each column. i.e.PolygonID, Advertising Near Signalised Intersections, Affordable Housing, ...., etc

I am doing my first experiments with ArcGIS Portal Feature Service Reader.I run into some strange behaviour in Workbench with editing its parameters and wonder what I am missing out on, or if we have some problem here ... I add a reader (old style) and try to publish settings I want to keep variable. This works well for all settings except for the "Feature Service:" setting. There is no way to edit this in Workbench Navigator, and it is not editable in the Reader settings once it is created.  I try the same with a Feature Reader (new style) and voila I can publish "Feature Service:" as a parameter. Small trap here: I can only set it to a predefined parameter and the option to create one is missing in the dialog ;-(  Problem with this variant: I can't set Search Envelope coordinates as I can do with the old style reader. Seems like there is no way to have all parameters published I want and I need to choose which variant from above comes closer to what I need ? T

Hi partners,Here's a round-up of some of the March updates so far: Two new subscription pages have been launched on safe.com. As mentioned in our February bulletin, we are now offering Education and Small Utilities Subscriptions. We're keeping an open dialogue with our partner community about these offerings and would like to hear any input or feedback you may have. Please get in touch with your Channel Account Manager at any time. FME 2020.0 is set to release today at approximately 2:00pm PST. Keep an eye out for resources appearing on safe.com throughout various channels including demo webinars scheduled for March 17 and March 19, a blog post, updates to the customer engagement slide deck, and Knowledge Centre articles. For our localizers: All of the FME 2020 resources (splash screens, Transformer Guides, etc.) can be found on the Marketing Collateral Resources in the Localization corner. If you don't have access to this page, please get in touch with or the

I have a workbench where I have used Spatial Relator and List Exploder to make a list of polygon IDs and Neighbor_IDs of those polygons touching it. I want to count the number of touching polygons, and if they are greater than 3, find which are the same land cover type.Something like: for every unique ID with more than three touching polygons of the same land cover type, with a combined area of less than 200,000m^2 -> dissolve.I have a tester set up to test LC_type ID= LC_type Neighbor_ID, which passes to a counter measuring ID >=3But I don't know how to give dissolver the condition not to dissolve if the resulting polygon is > 200,000m^2.–

HiI would like to use a attribute value as a parameter for ather transfomer.Could you tell me the procedure?

Are there any javascript experts out there? I have created a data download web application where you draw a polygon and return some data. I have done this primarily from some samples made available on the knowledge base. It looks ok I have customized it a bit and added some extra functionality/background mapping.This is all working very well when I draw my polygon and submit the request it goes to Server and my data returns.Problem is I want to run the workspace even if a polygon is not defined/drawn - as in I have another parameter option to input x,y min and max values. I would like the workspace to submit without the polygon geometry part being drawn.  But when I try to do this I get the following error stating it can not read lengthmapinfo.js:175 Uncaught TypeError: Cannot read property 'length' of undefinedat processClip (mapinfo.js:175)at HTMLInputElement.onclick (mapinfo.html:1)  Can anyone tell me how I could get around this basically if its null ignore or something sim

Hii have a data set that looks like this  Row_IDNameType1Ashville Medical PracticeGP Practice2Dr CampbellStaff3Dr PringleStaff4Dr AiswortStaff5Brierly Medical CentreGP Practice6Dr A J LittlewoodStaff7Chapelfield Medical CentreGP Practice8Maxine OrrStaff 9Dr BannonStaff what i would like to do is create a new attribute for each feature that contains the name of the GP Practice the Staff belong to. Which would look like this: Row_IDNameTypeName of GP Practice1Ashville Medical PracticeGP Practice 2Dr CampbellStaffAshville Medical Practice 3Dr PringleStaffAshville Medical Practice 4Dr AiswortStaffAshville Medical Practice 5Brierly Medical Centre GP Practice  6Dr A J LittlewoodStaffBrierly Medical Centre 7Chapelfield Medical Centre GP Practice  8Maxine OrrStaffChapelfield Medical Centre 9Dr BannonStaffChapelfield Medical Centre  but, as you can see, there is not a fixed number of staff per GP Practice.  Any help greatly appreciated  ThanksMark   

Is there any function exists in FEM equivalent to oracle function decode. DECODE(supplying_code, 1, 'Oracle', 2, 'FME', 3, 'ArcGIS', 'GIS') result

Hello again,We have a DWG that contains blocks that have been drawn in model space and then displayed in paper space using annotative scale. The block in paper space is scaled to the correct size based on the annotative scale but when I send the output to TIFF / PDF the blocks are the wrong size. TIFF Image above, DWG below. I know I need to scale the block, probably using the Scaler transformer, but how do I figure out the annotative scale used in the drawing associated with the paper space scale.There are AutoCAD references to the annotation scale but not sure how to find that scale out in FME as I can't seem to find in through exposing various attributes.  Sample drawing attached :

I already read the article (https://knowledge.safe.com/articles/886/working-with-geodatabase-subtypes-and-domains.html), but it doesn't seem to work. I get: "An error occurred while attempting to add the subtypes to the table/feature class 'Feature_Outline'. The error number from ArcObjects is: '-2147219885'. The error message from ArcObjects is: {An expected Field was not found or could not be retrieved properly."

I am using a feature writer to write something into a featureclass but I do not get records for each feature that is written using a feature writer.I have the following setting for featurewriter but everytime I do not see any feature that is written/updated via feature writer. 

I'm trying to create a dynamic schema writer that outputs as the feature's reader filename. I have tried the answers in https://knowledge.safe.com/questions/65227/how-to-read-csv-dynamic-and-write-csv-dynamic-with.html with no success.Can anyone suggest a different workflow?Thanks

Hi guys,I am currently trying to automate numerous bits of GIS data we get from various sources. I have managed to do the following. Simple Terms currently: Excel/Shapefiles/Geodatabases ---> Data Validation via FME ---> FME/Python Script run via a scheduler --> Loads into Enterprise GeoDatabase I am currently trying to decide what would be the best way to improve this process for it to be more accurate and so numerous users can also load their data successfully.In terms of excel/shapefiles should they place their files in a shared area folder and then possibly break it down into various folder categories or would you suggest SharePoint? I would be interested to hear other's views on this and how they may use it within their business.Also what scheduling tools are best suggested, I am looking at FME server as a possible option.We are also using a SQL Server Geodatabase

Hi,  I am trying to build a workbench that performs certain checks irrespectively of the Input data. That means that it must accept data with different data types (.shp, .mdb...) and schemes (e.g. different attribute names and types). As far as I know, a generic dynamic reader is what I need. So I inserted one and tested it. Although this reader reads the (spatial) data and shows its polygons in the inspector, the attributes are lost. Instead of the original attributes, there is only one row in the table with the header <no schema>. In the feature information part of the inspector, however, the attributes are still listed. Since I want to write a log file including all the errors found by the checker, the attributes are important. What do I need to do, so that I can access the attributes of the generic dynamic reader?   Best regards André

Hi Everyone,I need to have the intersected areas between two areas from different fonts.I have tried intersector, Clipper and also create a spatial query in SQLCreator, once my data is in Oracle Spatial format.But none of this worked fine in terms of performance.Anyone has clues of performance enhancement ? I've not tried yet Python or R interface to achieve the clipper operation.All of this options, are processing in FME Server, because of the time of processing, but I can try with limited data in FME Desktop also.The best that I achieved until now, is use clipper, but limiting my data between states boundaries, but I have loss of information in limits areas.

I'm using the HTTPCaller to download PDF documents to a set destination folder. The files get saved with the following name structure: "http_download_1582786318570_11140". This is not the same name I get when downloading the documents manually in a browser. I need the documents to be saved with the same name I get when doing it manually. Example: "Askholmen_SE0220343". Is it possible?Website: https://www.lansstyrelsen.se/sodermanland/natur-och-landsbygd/aktiviteter-och-ingrepp-i-naturen/tillstand-i-natura-2000-omrade.html (URL to PDF-documents are found under the heading "Bevarandeplaner kommunvis")HTTPCaller:

Hi everyone, I'm currently updating some FME Workspaces from Python 2.7 to Python 3.6.The workspaces have a private parameter containing a python script which imports arcpy and reads data from a SDE DB. The first transformer is a feature reader which reads features from an arcGIS Server (10.7.1) in my organization.The python script containd in the private parameter is executed successfully.The workspace fails when executing the feature reader with following log : Loaded Python module `arcgisonlinefeatures' from file `C:\Program Files\FME\python\python36\arcgisonlinefeatures\__init__.pyc'Python Exception <ModuleNotFoundError>: No module named '_socket'Could not create Python Reader `ARCGISFEATURES'A fatal error has occurred. Check the logfile above for detailsThe python interpreter is set to use the dll installed with ArcGIS Pro : C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python36.dll. the python home in the fme options is left blank.The python compatibility is set

Hello!I have a python script that calculates slope between points. I want to complete it with a while loop, to calculate between only those points where _lineID is equal, so like:while _lineID == _lineID     z_kulonbseg = b_z - a_z          slope_degree = (z_kulonbseg / a_t) * 100     and so on....import fmeimport fmeobjectsfrom functools import reducefrom math import sin, pidef left_slope(feature_a, feature_b):        a_x = float(feature_a.getAttribute('x'))        a_y = float(feature_a.getAttribute('y'))    a_z = float(feature_a.getAttribute('z_uj'))    a_t = float(feature_a.getAttribute('tavolsag_szomszed'))     b_x = float(feature_b.getAttribute('x'))    b_y = float(feature_b.getAttribute('y'))    b_z = float(feature_b.getAttribute('z_uj'))    b_t = float(feature_b.getAttribute('tavolsag_szomszed'))    ######  WHILE LOOP    z_kulonbseg = b_z - a_z    slope_degree = (z_kulonbseg / a_t) * 100    if slope_degree > 0:        elojel = "1"    else:        elojel = "0"    feature_a.set

Hi,I have a workbench wherein I am trying to batch process several .dwg datasets in one directory and put them into a file .gdb as follows:I am building polygons based on a .dwg layer and am outputting to the desired .gdb.I then have a separate workspace for utilizing the workspace runner so that I may process all these datasets as shown in "FME Workflow Management" as follows:I receive the following error when running which I am unable to resolve:WorkspaceRunner: Failed to run workspace C:/Users/blee/Desktop/MyDocs/Projects/PlanExtentWorkbench/Workbench/MissingPlanExtents.fmw -- Trace was: FME 2017.0.1.1 (20170512 - Build 17291 - WIN64) FME Desktop ESRI Edition (floating) Permanent License. Machine host name is: WLTS4018 Operating System: Microsoft Windows 7 64-bit Service Pack 1 (Build 7601) Copyright (c) 1994 - 2017, Safe Software Inc.

HEllo,I want to create an attribute (distance) between two points. I am using AttributeCreator to do it. Here is the code:@Evaluate(@sqrt((@Value(feature[+1].y)-@Value(y))*(@Value(feature[+1].y)-@Value(y))/(@Value(feature[+1].x)-@Value(x))*(@Value(feature[+1].x)-@Value(x))))The problem is that I want to calculate it only between points where lineID is the same. How can I add a kind of group by?Thanks

Hey there,I made a website (HTML, JS, CSS) with which I can list and execute several workspaces. The last workspace I added fails when executing, but works properly when running on the server directly ("Run Workspace").The first error in the log is:E57 reader: An error occurred while reading. The error was 'open() failed (E57_ERROR_OPEN_FAILED)' with context 'err=13 fileName=. flags=32768 mode=0' (error code = 17) The file is uploaded and available. I can't see the problem. Other workspaces where uploaded files are nedded work great. Cheers, Maria

Hi list.I've avoided the 2019 version due to multiple issues. So this is a bit late, I know.But now I tried to run a workspace I made in 2018 in 2019 (and 2020 beta), and both failed to run my custom transformer, giving an error about not being able to locate its components.All my custom transformers are located in a shared location using the "Shared FME Folders" feature. This worked fine in 2018 and previously.Only when I specifically added the path to the shared Transformers sub folder to my FME_PYTHON_PATH, did 2019 it find it. But then what's the point of having an official "Shared FME Folders" installation ?Was the "Shared FME Folders" functionality changed in 2019+ ?Cheers