Authoring

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 int

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.

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&lt

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(obje

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 e

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 m

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 Crea

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