Creating and organizing workspaces. How to use Workbench.
Recently active
Hello!I have point next to each other with a slope value between two neighbor points. Now I want to average these values with a loop, like:for n in range(num): numbers = float(input('Enter number : ')) total_sum += numbersavg = total_sum/numCan you help me to put it in practice with FME
We recently upgraded to FME Server 2019.1.1 and have run into user parameter issues. We built an extractor tool in our ArcMap Portal GIS that enables users to extract GIS data into styled dwg or shapefile format to create maps. We have user parameters linked to FME process for layer names, projection and user input selection via draw tools in the tool. After the upgrade from 2018 to 2019.1.1 we have noticed the process will give an error if too many layers are selected and also if you use the draw tool and create polygons with too many vertices. I am wondering if there is a limit setting for the user parameter values or other setting causing the issue. I did test running the process on the server interface with the string used for the selection box and it works. Below is example of the failed string running from Portal, but passes if I paste value in the box selection user parameter on the server interface. <lt>?xml<space>version=<quote>1.0<quote><space>e
Hello!I would like to calculate the difference of z value between two neighboor points in the following way:- test if the extreme_ is LOKMIN- if it is LOKMIN , then take the two neighbor value (the points are sorted), take the higher (so the bigger number) and exract them each other.Here is my attempt:import fmeimport fmeobjectsfrom functools import reducefrom math import sin, pidef left_slope(feature_a, feature_b, feature_c): a_x = float(feature_a.getAttribute('z_uj')) a_sz = feature_a.getAttribute('_szelsoertek') b_x = float(feature_b.getAttribute('z_uj')) b_sz= feature_b.getAttribute('_szelsoertek') c_x = float(feature_c.getAttribute('z_uj')) if b_sz == "LOKMIN": k = c_x - a_x #_nyomvalyu = b_x - a_x feature_b.setAttribute('_nyomvalyu', k) return feature_a return feature_cclass FeatureProcessor(object): def __init__(self): self.features = [] def input(self,feature): self.features.append(feature) def close(self):
We have a problem with the cases of our attributes. Normally the attributes were all uppercase, but we have some customer which send us data where they are not. They sometimes mix the cases in all sort of ways. We have a ArcGIS SDE Reader and a Hexagon SQL Warehouse Writer. Here an example: Table: WASS_SUBART_HYDRAttributes: OBJECTID, CODE, DESCRIPTION_G, GlobalIdThis is our configuration, but our customer send us data, where the CODE Attributes is lowercase. Then our FME Workbench does not work, because the code Attribute is "ignored" and the writer will write a NULL Value to the Database. If we see it correctly, the problem is, that the reader has the wrong information about the attribute.Is there a way to ignore the upper- and lowercase of a reader? (If not, this would be a nice feature, because ArcGIS and MS SQL can handle this no matter how it is written)Or is there a way to change the reader dynamically?This is only a small example to keep it simple. We have to deal wit
Hi, Is it possible to rename Repositorys by changing the text in the .fsproject file? and then reimport the file. It does not seam to be possible, but would be a great function to implement in future versions of FME. Best/ Johan
matlands
i tried a lot more than one hour but i did not success,i did my work space and my output will be in different tables in the same sheet , so i would like to design a table include my result.i mean,as example for the first table (Table A,) ,it will count how many rows that i have in my result then copy the first table from tempelate excel and add some rows or minus depend on the counter that counted my result ,and so on the same idea for the second and third .i got from my workspace different tables but without any table format designed so i want to copy from my tempelate the design but with modify counter of my rows in output.so i used the counterthen i want the first row to include filter arrows for each table. something else,i want to know i marked on overwriting existing file yes then i rerun workspace but i did not see any change in my output excel file till i delete it and rerun work space.it seems for me ,overwriting parameter does not work .how can i fix it .Thanks FME ver
The HTTPCaller is a great transformer for making HTTP requests, but I have quite a few requests is there a way to speed up this process?
Hi, We are with the 2017 version of FME Server and we would like to modify the database connection string in the “FMEServer\\Server\\fmeCommonConfig.txt” file. It's the same database (same provider, same version, same content), with just an update of the connection string. We have already done the test by modifying this file and restarting the server, but FME Server has stopped working. The home page was then presented without the "Use Windows Credentials" button (which is not normal according to our configuration) and if we manually entered a credential, a page informed that FME Server was unavailable. What is the procedure for making this type of change?If this type of update is possible, would the procedure be the same with the FMEServer2019 version? Thanks in advance,
Hi all, As the title says I need to expose the basename or file name for multiple PDF files I read with FeatureReader. Seems there is no way to expose PDF attributes neither in the PDF reader or FeatureReader where PDF is selected as format? I use a directory reader to make a list of Word documents that I convert to PDF using an external program and then pass the file name + pdf extension to the FeatureReader. However I'm stranded if I don't find a way to indentifying my input files. Thanks! /Jacob
Hello,i was succesfull with static R script insede RCaller transformer. But, when i try to include some FME parametres insede R script like this:kr = autoKrige(h~1, new_data = grid, input_data = measures, nmax = $(NMAX), maxdist = $(MAXDIST))I got this error:Error: unexpected '$' in:So this is clear syntax error message complaining about $ inside that script. But is there way how can I pass FME parameters to R script inside RCaller?
Installed FME2019 unattended. When starting up, it asks for the floating license server. Where is that information stored in registry/files?We have a non persistent VDI and next time I login, everything is gone.
Hi, when securing our DB Connections I noticed that the only choice for the Connection security item, either by user or by role, is "Full Access". Does that mean that an (FME or Active Directory) user that can use the Database Connection also has the right to delete it? Or does it mean that the user always can use the Database Connection yet only can remove it if the user has Full Access?
Hello FME Community, i need help to understand how i can solve my problem. The outcome should be a Excel-File where all Adresses on a parcell should be stored. 1.)i got Points(Adresses) and Areas 2.) Use the PointonAreasOverlayer and make a List on the Areas. 3.) Use the ListExploder: Take the List and Create a _element_index (rest is standard) now comes the part that i dont really understand. 4.) i use the AttributeCreator for Creating Attributes like "@Value(_element_Index)Adress" = "@value(Adress)" then i use the "centerpointreplacer" and a "pointonpointoverlayer" to merge the "new" attributes then comes the duplicatefilter(group = ID) to get the unique Adresspoint with all the AdressesStored in a parcell. and then comes the tricky part: after i use the AttributeCreator my Created Attributes where gone but when i redirected it to the datainspector my attributes where stored an the "Areas" and that was it. I tri
Parameters and Attributes seems like two really confusing concepts sometimes. Can we have someone clarify the main differences between them? Thank you!
So, what would be the easiest way to do this. Lets say we have generated 2 separate, but parallel Lists like this (say from ListExpressionPopulator):Colours{}Precincts{}And it is desired to combine these into a single list with the original list names as instead the component names like this:Report{}ColoursReport{}PrecinctsAs far as I can tell, this can't be done with either ListRenamer or AttributeRenamer, and the closest got to is using BulkAttributeRenamer.
Hello FME gurus,I have a polygon layer where some polygons overlap and I need to end up with a single polygon per label. In the image above, I have three polygons, A, B and C (shown in green) but sections of each overlap i.e. B/C and A/CI have converted the labels as attributes to the polygons and split the attributes into parts.I want to be able to clone the overlapping parts and then merge based on the label i.e. A, B or C.Any ideas would be very much appreciated.ThanksDean
I am trying to publish a FME Workspace(FME Desktop) running on a serviced platform (Citrix) to FME Server(FME Cloud) but I am getting the below error message in the Log file."Login failed (Connection Error) - Unable to connect to FME Server""Request to update access token failed. HTTP Error: SSL connect error"But when I tried to publish a FME Workspace from a local FME Desktop, it got published successfully.So, can some one who had similar experience share their solution.Thanks,arizona
Hello,I noticed a difference in attribute handling in my FME workbench. I hope anyone can explain what is causing this.I have the following data:With the AttributeManager I want to convert the numbers from meters to millimeters (see below).The outcome of the AttributeManger is:Why is the bottom value of the first row different than the other two rows?It is luckily not an obstructing issue in my workbench, because I solved it with the AttributeRounder. But I am curious how this happens, and what the options are to prevent this from happening.Thanks in advance!
Good day.I faced the problem with running jobs on FME-Server. Periodically (not always) jobs are crashed with status message: "The Workspace requires Python version %0, but Python version %1 is already loaded". I absolutely confused, because if I start this WB again the process will be completed successful.ArcGIS and FME-Server installed on this machine together and as the custom python the Esri ArcGIS Desktop (Python 2.7) selected.Who knows how to overcome this problem?Thanks in advance.
Hi, I would like to create 72 features with predefined ID and NAME attributes for instance: ID NAME 689 Kativic 711 Monts et marées 712 Charlevoix ... ... So far I used the creator (1 instance) followed by AttributeCreator where I added all IDs separated by a coma into 1 attribute. Then I used the AttributeSplitter to create a list on the IDs and finally the ListExploder. The result is ok, I have one feature with the ID, but I cant find a way to have the NAME attribute also attached to those features. Instinctively, I would use a JSON key:value list, but I am not sure how and if it is the correct solution. Thank you for your help
I am running fme from cmd and while passing command line parameters to run workspace I use cmd.exe at the start e.g. fme.exe C:\\Maps\\OraDWG.FMW --BoundaryName PTCL526 ...and if I use a same command but without using .exe in command like -fme C:\\Maps\\OraDWG.FMW --BoundaryName PTCL526 ...It's still running the workspace.So my doubt here is that what is the difference in using .exe? Does it use extra floating license instead of using one that is dedicated for this workspace. We have few more floating licenses.
FME(R) 2019.2.1.0 (20191202 - Build 19813 - WIN64)Hi,Int the following reference - https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Running_a_Batch_Translation.htmUnder the heading - Running a batch translationThe following is stated;For example, you can apply an existing workspace transformation to a large number of input files, and produce separate outputs for each.How do you implement this, ie output to sepate output files?I have set up Batch Deploy to use a folder as its source.I have Run my workspace using the Batch Deploy method, but it continually overwrites the single file.Ben
I'm having trouble with a relatively simple task - I want a field to be a specific data type (DOUBLE). The source for the values is a text field with a number (comma separator). However no matter what I try (e.g. creating a brand new field with @Evaluate(@double(@Value(MYTEXTFIELD))) or replacing comma with dot beforehand), it ends up as (as seen by ArcMap) text. StringFormatter didn't work either: the decimal option gives me (textual) scientific notation - yuck! Give me proper decimals or give me DEATH!
I have asked similar questions before and tried loads of different solutions. It seems like such a simple thing, but so far I have not been able to get the result I want. I thought I would try and start clean, maybe this can help me make sense of this.Imagine a dataset where some of the features are overlaying. (There are more attributes than those described, varius sources and not all features are overlaying.)In this dataset I want to identify polylines that are overlying and merge certain attributes from them. Feature Attribute A Attribute B Attribute C Attribute D1 A 2 B 3 C 4 D The desired outcome of the four overlaying features above would be a new feature with the following attributes:newFeature A B C D Empty cells should always be filled if possible. A kind of dissolver of attributes.How would you experts go about achieving this?