Authoring

Hi All, I am trying to set the values for 2 Published Parameters without the user input such as Attribute Creator so it can be used when I call the FME Workspace using POST Body HTTP Call.  I need this attributes to be Published Parameters because is the only way I can make Generalizer transformer dynamic, so I can choose both Algorithm and the Tolerance of it. Any suggestions would be highly appreciated. Thanks,Ana

Hi All, It is often when I need to make used of HTTPCaller transformer to call another FME Workspace hosted on FME Server.  I commonly pass all attributes using Query String Parameters. Unfortunately, this time this method doesn't seem to work as my URI gets too long due to complex geometry stored as WKT. I am trying to find a way to upload these parameters as part of the Body instead as Content Type application/json but I might have something wrong as even though it runs the workspace is not able to retrieve these attribute values from the transformer. I know how to do this using Python but I would like to avoid this and use HTTPCaller transformer if possible. I would appreciate any help or suggestion. Thanks,Ana 

Hi list.I've built a workspace with a loop looking for information, that I don't know the exact end of. So I loop with a margin, and I save an ID of the last found instance, and check whether I've had too many consecutive fails. If too many fails have been found, I redirect to a Terminator transformer.However, when I ran the workspace, expecting some output to a database, no output was produced.It seems that the Terminator transformer rollback previous database inserts. When I disabled the Terminator, all worked as expected.Is there a way of making a peaceful halt of processing of a workspace, not the "pull-the-plug" kind of behaviour that Terminator seems to perform ?I.e., is there an option to make the Terminator transformer less "Terminator"-like ??Cheers

Hi All, I am writing to a KML and trying to change the Root Document Name dynamically by retrieving the attribute value from a DB in the middle of the workspace. I am aware that by using Format Attribute kml_document you are able to assign this to an attribute value; however by doing so I am losing all Metadata and Hierarchy assigned to that specific Writer. Any idea will be welcome :) Thanks,Ana

I have a large dataset split up into three shapefiles (south, middle, north). From this I use Clipper to cut out the area of interest. To save processing time I would like to only read the data necessary (i.e. one of the three files). I have a bounding box for my area of interest so I would like to select one (or two) of the files (south, middle, north) to read depending on the y-max/y-min values of my bounding box. Is this possible?

FME Server provides Authentication and Access Control using the Java Authentication and Authorization Service (JAAS) framework. Is the way of Authentication/Authorization subject to change ?

Hi, everyone, I tried to create user parameter select multi-attribute in some transformers like AttributeKeeper/Remover, but it won't work. I've tried with type "Text", "Attribute List (comma delimited)" and "Attribute List (space delimited)", it will only work when input only one atrribute. For example, I'd like to keep attribute "NAME" and "ADDRESS", when I type "NAME,ADDRESS", I get no atrributes left in Inspector which show no schema, it seems that the transformer treated it as one attribute not two atrribute split by comma.How can I make it happen? I'm using FME 2020.

I would like to the HTTPCaller to get info from a municipality website. I have an account on the website. It is my email address. But in reading some questions on here, it is not possible to send the username if it is an email (something with the '@' sign). Does anybody know if there's a workaround?

I'm building a simple workspace to generate a (for now) simple dashboard for FME Server. I'm naturally using Workbench for this. But every time I run to test the workspace, it fails because the FME Server parameter isn't available on desktop:Starting translation...Undefined macro `FME_SHAREDRESOURCE_DASHBOARD' dereferenced in file .....Program TerminatingTranslation FAILED.Why are these server parameters not just missing or blank, so I can run and test for them and run the workspace on desktop, instead of crashing my workspace ? They're readily available in the transformer dialogs.Any work-arounds for this ?Cheers 

first sorry if the question is not in the right place I have a problem with Excel Writer inconsistently showing the Error:Excel Writer: Failed to save changes to the spreadsheet 'file name'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'bad allocation'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...sometime it doesn't show at all and other times for the some unchanged WB it appears and I only restart my machine and it would work fine but other times it wouldn't unless I manually run the WB till the Excel Writer and run the Writer alone and it will be fine I thought that the problem was only appearing when I use the same writer to write multiple Sheets and tried to have them be separate (multiple Writer one for each sheet but all writing to same file) but it appeared again in a wr

Hello,  I have multiple records with 3 attributes which i'd like to format a particular way into a word document (see below)Input Ex: At the moment, I use two MSWordStyler transformers taking said record and styling both the Title and the Heading.  Unfortunately when it runs, the heading information reaches the writer first before the title. As such, the heading is above the title in the word document. My question is how can I specify which document element gets written first? Is there a way to control the input order?

I have moved to a new machine and have had to install FME on the new machine. Is there a way of exporting all my settings and database connections to install on my new machine or do I have to set it all up from scratch again?

 Hi, Is there a way to automatically document a workspace by reading the bookmarks, for example? .A workspace uses notations and bookmarks. I would like to export this to a separate document so that some sort of description of the data stream is created. Greatings

We are deploying two FME servers, one for production, and one for testing (staging).The workflow I've built (7-8 separate workspaces) all refer to one MS/SQL database and one external HTTP service endpoint. There's one "connection set" for production, and another for testing.Using the same set of workspaces, what is the best practice to maintain identical workflows on the two servers, each with its own "connection set".I've streamlined all database connections to a single linked database connection, and know that it can be replaced quite easily in Workbench. But this will require me to publish twice every time, which is not optimal.And what about the HTTP endpoints, is there a way to store these on each separate FME server, so they automagically work ?Any ideas and insights on making the maintenance as simple as possible ?CheersLars I

I have three database tables that I joined using the FeatureJoiner tool. I was able to use the CSV writer to produce a file on my desktop. However, when I use the Socrata writer to write to my Socrata platform. I am getting the following error message:  Socrata Writer: HTTP 503 (None): Auth succeeded but view lookup failed -- https://domain.com/api/publishing/v1/revisionSAFE.SOCRATA.SOCRATA2 writer: A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Translation FAILED with 4 error(s) I am not sure why I am getting this error message. I used the Socrata writer last week. It worked fine. Credentials are saved. Since this a new dataset. I doubled check that the Socr

I have a column (route_num) with a list of route numbers. How can I extract each route number as it's own feature and all other attributes as copies. See belowFrom: To: 

I'd like to get more information on when the SQL Creator can be used.

This universal multi-source reading and writing workspace, how to make color parameters adjustable when selecting output kml.How FME server can identify the coordinate definition and geographic parameters of ESRI Reprojector

Hi All, Is there a way to allow the jobsubmitter workspace to be partial populated by some means from user clicking a prebuilt URL? (Or other method) I have a ESRI webmap that contains a feature service with Asset locations. These assets contain a unique identifier attribute I wish to pass into the workspace so the user doesn't have to type it, or select it from a drop down.The workspaceI have a workspace that requires the unique identifier to maintain a relationship with other data, however the user needs to load in a CSV and add other parameter details before executing the workspace. Currently I have set it up so the user types this ID, but this is fraught with danger of the relationship being lost due to typos. My research so far....I have found that I can either build a URL from the attributes in my ESRI web map as a popup to either 1. Open the job submitter with blank

In FME 2019, I can pass feature class names to a workspace without error.  Now, using FME2020, I'm getting warnings from the workspace that didn't run properly reporting the following:The table name '@Value(fme_feature_type_poly)' could not be found in the Geodatabase as either a feature class or a tableAll other parameters pass fine (postgis where clauses, etc.)  The only hiccup is with file geodatabase feature class specification, which is correct within the workspacerunner fmw.There is no error reported by the workspacerunner fmw, just in the target workspace.I've checked over and over and the problem keeps manifesting. However, when using FME2019, everything is smooth-sailing. Anybody else run into this phenomenon or have a known fix?  Is there another way that the user parameter needs to be formatted/Thanks,Pete

Hello people, I am new to FME (about 3 months) and this is my first post on this community. So, please be patient, if this question sounds ridiculous to you ;-)The background of my question is as follows: I have a big major workspace and want to split this into a few smaller, less complex, workspaces. In addition, I would like to re-use some of these new small workspaces in another context. Therefore, my idea was to build a few FME-workspaces as modules and use these modules to build bigger major workspaces.I understand that I can use custom-transformers and/or workspace-runner for this, but both do have some disadvantages on its own.Workspace-runner on the one hand, can just run another workspace (as the name says) and it can transfer data from the parent-workspace to the child-workspace via published parameter. However, the workspace-runner cannot give you an output from the child-workspace back to the parent-workspace (if I am right here?

I have an FME script which takes specific headers of a source spreadsheet and copies the them and the field values to two new fields (Substrate Size Distribution & Substrate Size Distribution Value). There are transformers which replace alphanumeric characters from the original header string, sorts the numbers that are left, and concatenates the alphanumeric characters back to the sorted values. This works great. But, the script is coping a header from a field called "Visit_Year" to Substrate Size Distribution field and its value, "1989", to Substrate Size Distribution Value, where values are null in the specific headers I am trying to reformat. This is not what I want. See attachment. I want Substrate Size Distribution and Substrate Size Distribution Value fields to contain only the headers and their values, not the header text Visit_Year. Thoughts as to what is going on?

i want to know how u are converting 3d files format to json

I have spreadsheets with Date and Time fields. I assign them to a Reader in FME 2018 and funnel them through AttributeManager. When I check the output that comes out of the Writer, I see that the Date and Time fields have been modified. I have tried to find a setting in the Reader and transformer which would prevent these fields from changing so I don't have to use the DateTimeConverter. Does anyone have suggestions? The only solution I have found is to change the field in Excel to concatenate Date and Time. Then this field stays the same after the AttributeManager transformer. However, some of my spreadsheets don't have a time metric, just date. Thoughts?

Hi list.I have next to no knowledge of what OAuth2 entails, other than it being a security protocol.A customer wants to use OAuth2 when exposing a WFS and/or an Esri Feature Service to us, and we want to use FME (Server) to fetch the data.Both desktop and server have a facility for custom "web connections", and here you can create both "Esri ArcGIS Portal" (w/OAuth2) and a straight up "OAuth2 Service" connections, but how do I utilize them when reading data ?Are there any in-depth resources available that covers this area ?CheersLars I