Authoring

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

Hello community, I'm quite new to fme and I've been stumbling on something that might be easier than i think. Basically i have a filled access database table and I'm trying to fit these filled records into a template table. This template has less column headers/attribute names than the source. I'm trying to get the values that do no longer have a place to be put into a string. I have managed that, however I'm trying to have this long string be readable by having the attribute value be preceeded by the attribute name. I'll give an example below: (sorry I'm currently only on mobile so writing it out is a bit harder)  OldFruits vegetables grains soup Apple cauliflower bread tomatosoup New:Fruits vegetables otherApple cauliflower grains: bread, soup: tomatosoup This is just an example. The real table has like 52 fields per records that has to fit into 30. I hope anyone can help me out.

I am trying to limit the attributes read by the FeatureReader. The data I want to read are coming either from an Oracle or PostGIS database. Of course I can use the WHERE clause to limit the features based on limiting values, but I do not need all the columns the data table holds.  I there a way to do this inside the FeatureReader? Currently, I am using an AttributeManager after my featureReader to remove columns not needed, but that's a waste of ressources and more important, time.

Hello everyone !  Does anybody use SAS DB connection?  Right now I'm exporting CSV files from SAS and importing the CSV to FME. Is there a way to add a direct connection between SAS and FME (like PostGreSQL - FME connection)?  Ciao,Théo

I would like to hide half of my transformer in one workspace and do password for half of workflow so User will not be able to show the whole work .I mean ,for the same workspace ,I want to make security password to appear the whole workspace .But without password ,user can open the work space but it does not show him the whole work space till he write password to show the whole work .Do we have a method to do that

Currently ,i am trying to create user parameter in shared parameter linked with excel file.  i have an excel file ,it includes id number and names of building , i want to create user parameter when i write the number ,it wiill read automatic which names that i want to work on from specific excel file ,then it starts scanning or searching for this excel file in specific folder that include the same name and import ths excel file to workspace . Thanks in advance

Hey Everyone,I have had some challenges creating apps in FME Server that have published user parameters that are as robust as Workbench. I wasn't sure if it was just a limitation of FME Server as of 2019 or if I am doing something wrong.For example, if my workbench parameter needs a user to select a Coordinate System Name, it is very easy to find the CS you need:On the other hand, on an FME Server App the search functionality is unable to find my CS and it it giving way less results to scroll through. If I knew the EPSG code I'm guessing it would be fine but I'm thinking in my users' shoes who need to type in more broad terms like "texas". In the App, searching texas doesn't bring up any NAD27 CS choices at all. It is a similar situation with folder/file locations. I was hoping this folder selection view would be similar in the app as well. Does anyone have any thoughts? Is this more of an idea for improvements?