Authoring

Quick Translator to Workbench File

I have flow data series in excel for every 10 secs for 5 years data, and i wish to convert that data into 1 hour data . can any one suggest what is best way to do in FME or any excel - without skewing my original data and output should make sense

Hi,I need to convert multiple numeric codes in multiple tables into meaningful texts via a suitable "lookup table" (actually a view on SQL Server, but that's not important). Since I need to do this multiple (10+) times, I want to create a custom transformer with published parameters for input and output variables.How do I do this ?My attempts sofar has only resulted in an error: Undefined macro 'VAR_NAME' dereferenced in file ...CheersLars I

Hi,I've made an embedded transformer to reproject an alphanumeric coordinate set, controlled by a published parameter set. It reads the "old" coordinates from two given attributes, and returns the reprojected coordinates values into the same attributes.This works well enough, except when I have a dataset with two pairs of coordinates. It reprojects the first set fine, but completely ignores the latter, leaving them only partially processed.I've tried to insert a FeatureHolder between them, but it looks like the two transformers in the same workflow interferes with each other ?I've swapped the two transformers, and right enough, now the other set gets reprojected, while the former doesn't. So it's at least consistent.Has anyone encountered something similar before ?Cheers

I am trying to bring a workbench to FME Server that has been used on FME Desktop until now. This workbench uses a shutdown python script. The special thing about it is that this workbench uses a custom python interpreter and not FME's Python.The FME server has been installed on a completely other computer than FME Desktop. So first Python and a few packages had to be installed on this computer. Also I edited the FME server settings in the cmd as it is written in the following article unter "Using a Custom Python Interpreter" in "Windows": https://docs.safe.com/fme/html/FME_Server_Documentation/Content/AdminGuide/Using-Python-with-FME_Server.htm In cmd Python and the import of the new packages work fine but when I run the workbench on FME Server the translation fails. It says not more than "FME_END_PYTHON failure". The log file of the job doesn't give more hints about the problem. The last lines are the following ones:Translation was SUCCESSFUL with 43 warning(s) (6398 feature(s) output

Anyone know of a good way to analyze attribute values, and determine if a given value is a word in English?Or maybe even check it against a custom dictionary of names? I'm trying to clean up a bunch of values that have spaces from when the PDFs were output to data via OCR, so it looks like this: Attribute ValueWhat I want attribute to be corrected toThi s is a sent e nc e.This is a sentence.

I noticed that the FMEServerJobSubmitter transformer dialog is missing a button on it, the Refresh Parameters button, which used to be directly under the parameters list in 2017 version (if my memory serves me correctly).The documentation even refers to it:As a workspace evolves over time, parameters are added/removed/renamed, therefor this is crucial functionality that needs to come back. My current workaround is to delete the FMEServerJobSubmitter transformer and add it in again (with the added hassle of re-specifying all the settings).If there's a different way of refreshing the parameters, I would love to know how.

Hi guys,can someone please confirm if there is a character limit to the FME_SERVER_REQUEST_URI in FME Server 2017.1? It seems to be 195 characters.  For example, I have a schedule that is calling a workspace :  https://myservername.com/fmejobsubmitter/a_long_repository_name/and_a_really_long_workspace_name.fmw   If that string is over 195 characters then the scheduler reports that the workspace cannot be found. It works fine if I reduce the length of the repository name or the workspace filename.CheersBatesy

In a workbench I write some Swiss-Interlis-files which have to be uploaded to an FTP-server afterwards. I'm not sure whether I can use the new FTPCaller for that...? How would I do that? Here my questions: - in the FTPCaller I fill in the         - URL         - "Upload from a File"         - File to upload: Path to my files         - connection parameters >> so the FTPCaller doesn't have to be connected neither to a reader nor to a writer at all? - Thus I cannot use it in the workbench, where I write the files but in a seperate one? - If so, I guess it would make more sense to run my workbench and afterwards an FTP-job from a batchfile...?  Thanks in advance Vera 

Hi, I have a following table and I want read rows between start and stop. Is there anyway I achieve this in FME? any help will be highly appreciated.Thanks you IDDESC1 rest2start3run4rest5aaa6 stop7rest8run9start10bbb11run12stop13aaa

When trying to add an RData reader (.RData or .Rda), FME is unable to open the file and gives the error below: Workspace generation failed.

HiI am writing attributes to a shapefile, but the attribute names are being shortened to 10 Characters. Is there a way to stop this?Thanks in advanceMartin

I seem to recall that I was able to sort my display lists for Schedules, jobs, etc in the previous version of FME Server. I see a "sort" order button on schedules, but I cannot apply it to any other columns. Am I missing something?

I am looking for a solution that results in the simplified envelop of a 3D-object. The purpose it to indicate the reservation area of a 3D-object, without revealing the details of that 3D-object. This is a typical demand that Safe Software will encounter in the future when speaking to people handling BIM (Building Information Model) workflows.   Here some examples:    The purpose is to do that on minimally following 3D-objects (input)    The expected result (output) would be something like this (see red lines):We need at least a box, ideally a more detailed geometry (e.g. a trapezoidal geometry)        It’s mandatory to take into account the orientation of the 3D-objet in the 3 X,Y,Z axis and minimize the resulting geometry volume. As an example following result would be useless:      Can transformers be the solution to my requirement? The most likely transformers I have found are    BoundingBoxReplacer : but it should also handle 3D coordinates , and ideally not generate the b

I have to create sample dataset of one region subdivided into sub-regions. I wonder if there is a way to randomly split polygon inputs to create simple sub-divisions. The number of sub-divisions could vary between 10 to 20.  I was thinking about randomly select two coordinates of the input polygon, create a line and split the polygon by this line, but not sure if its a good approach.  Any suggestions? Thank you a lot,  Max Demars

I'm trying to expose the metadata of the source feature types from an AutoCAD file. I've tried two different ways (see attached screenshots): 1.- using a "schema (any format) reader". 2.- using a "creator + FeatureReader". I've added a transformer to count the number of items in the "attribute" list, but in both cases returns 0. (see Inspector screenshots.)The DWG file contains data, as it recognises 88 feature types, but I can only get these attributes: "fme_feature_type_name", "fme_format_short_name", "fme_format_long_name" and "fme_basename".I'm unable to expose the content of the "attribute" list.I've added the screenshots of the readers and transformers parameters. Can you help me?Thank you very much in advance!

Dear FME community,I have data from several districts. Each district has different data sources. I'd like to use the same workbench for every district. Therefore, I'd like to set up a workbench with multiple (dynamic) readers, where the user would choose the district and the source of the corresponding feature types at the beginning of the translation (feature types to read, when run with prompt is enabled). So far I've only been able to do this if there is only one dynamic reader. Is it possible to use more than one dynamic reader? If not, is there a workaround for non-dynamic readers to be able to let the user choose the corresponding feature type?I appreciate your help,Vincent

Currently I can use two ways to sent email after a job is completed in FME Server:1. Configuration of Server Notifications: Here I use HTML Email Format to include information about processing time, download URL and other information. The Email Template is designed using the Email Template Language and the Email Template Keywords.2. FMEServerEmailGenerator transformer from FME HUB: In this case I am able to sent emails but only in text format and without using Email Template Keywords. The predefined keywords are not identified as variables and the keyword names are sent as text only in the email.Is it possible to use Email Template Keywords with FMEServerEmailGenerator? Or is there another way to do this?Best regards,Frank

Hello,I have a set of point and a grid partition. each point is assign to a partitionI have build a list containing all point in a partition (listbuilder group by partition_id)Is there a way to get the feature geometry of each element of the list.Does the geometry is preserved in a listbuilder ?if so How can I retreive it within the list of element in python?so far I only get NoneType in my_list.I saw that I must do something like my_list = feature.getAttribute("_list{}.<attributeName>")But what is the attribute name for the geometry ?later I would like to do something like feature.getAllCoordinates() on each element of the listdef input(self, feature):    my_list = feature.getAttribute("_list{}")    # flush the list    self.fList = []    if my_list is not None and len(my_list) > 0:        for item in my_list:            new_feature = feature.clone()            self.fList.append(new_feature)        self.DBScan(self.fList, self.eps, self.minPts)    else:        partition = feat

The 'download' buttons for layers in this data catalogue... https://environment.data.gov.uk/ds/catalogue/index.jsp#/catalogue ...used to resolve to fixed URLs that we could call from FME to fetch the data. They are now function calls on a widget... <a ng-if="layer.format" target="_self" href="javascript: void(0);" ng-click="vm.performDownload(layer)" bs-tooltip="" data-title="Click to download"> <img src="images/download-small.png"> </a> There are no requests when the button is clicked so a POST won't do the job of a button click. Does anybody know a way to programmatically click the download button or to get hold of the payload by any means?

How can I access list elements dynamically and put it in a loop? I tried this:index = 2r = @Value(keys_list{index}.key)but understand the 'at' is just a templating syntax and cant be used like this..Also, if there is any specific list functions or a dedicated list object, I have not been able to find them under  Class FMEFeature in the documentation.Thanks,UPDATE:Tried        keys_list = feature.getAttribute('keys_list{}')        for key in keys_list:            pass                self.pyoutput(feature)This gives me Python Exception <TypeError>: 'NoneType' object is not iterableVerified: keys_list exists and has several elements.

Hi,Is there a way to add transformers based on a list of variables. Like: for each of the variables in a list, run all the data through a defined set of transformers, and with each iteration change what those transformers do based on the variable?Thanks!

Hi everybody!Currently I'm building a workspace that validates schema features by comparing them with an ESRI XML workspace document. For this purpose I was wondering if it is possible with the FeatureReader transformer to read only the schema feature that has the same fme_feature_type_name as the initiator feature. Can this be done (using FME 2015.1 - build 15539)?I have set the FeatureReader format to "Schema (Any Format)" and selected fme_feature_type_name in 'Feature Types to Read' from attribute:However, this is doesn't output any schema features...Any suggestions would be most welcome!

I'm trying to separate many polygon features (+1mil) by another polygon boundary dataset. I'm using the spatial relator and anything with _related_candidate > 0, are exported to a file with the boundary name. It takes about 32 minutes to run. I would like to use the group by parameter and parallel processing to make this go faster except there's not a common attribute between the datasets. Is this a fruitless endeavor? Should I be happy with 32 minutes? ;)

Hello, I'm using a Feature Reader to read a csv. I would like to keep the incoming attributes from a sql query. Even though I use "Merge Initiator and Result" in the parameters they are not merged in the output. (The incoming are output via Schema and Initiator, the csv attributes via CSV) Is it possible to get a single output with the incoming attributes and the attributes from the csv?