Authoring

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

I have got an environment with a set of Named Connections however I would like to test them without pushing up a workbench. Is this possible?

In MS/SQL I have a table with multiple geometry fields. When using a FeatureReader, how can I designate which geometry column to read ?

I have a dataset with values of D15 (mm), D35 (mm), D50 (mm), D84 (mm), D95 (mm), & D100 (mm). I want to use stringreplacer to remove the letter "D" and "(mm)". Syntax to remove?

Hi @GerhardAtSafe , Thanks for developing the new SharePoint Package, I am very excited about its functionality, but have unfortunately already run into an issue when trying to install it. Please see the log below. It may have to do with my version of python.I am using FME 2020.1.0.1 Build 20596. Apologies if this is something I would rather need to pick up with my IT department. Log when trying to install the package:An error occurred while installing package 'C:\Users\Srautenberg\AppData\Roaming\Safe Software\FME\Packages\20596-win64\PackageFiles\safe.microsoft-sharepoint': An error occurred while installing Python package with 'pip install --force-reinstall --no-deps --no-index --find-links C:\Users\Srautenberg\AppData\Roaming\Safe Software\FME\Packages\20596-win64\PackageFiles\safe.microsoft-sharepoint\python --target C:\Users\Srautenberg\AppData\Roaming\Safe Software\FME\Packages\20596-win64\python\safe.microsoft-sh

The circled number is exactly 2x the number of records in that input - an sde point file. This happens no matter which file is "on top." In the translation log, the Total Features Read is exactly the right number.Total Features Written is too high by exactly the number of records in the first input. All other inputs are appended correctly. Does anyone know why this is happening?Thank you,Randy McGregor

Forgive me if this is a stupid question, but I haven't found this process to be very intuitive and I haven't found a solution in the documentation. Let's say I have a database with 10 different tables. There are some common columns in each of these tables, but they also all have unique columns. I want to create a dynamic workspace so that a user can open it, run it, and specify the name of the table they're interested in to send only the features from that one table on to the writer. So I create a reader, I select "single merged feature type", I specify the names of all the tables in the Table Names box in the reader parameters, create it and add it to the workspace. I create a writer (let's say it's an ESRI shapefile), I set the User Attributes to Dynamic, and I connect the two. I run the workspace and in the "Feature Types to Read" parameter I provide the name of just one of the tables. I look at

I have a list attribute that I'd like to use in a JSONTemplator. I am able to get the list into an array no issues, however, I want the result to be an array of integers/numbers rather than a string. If it was not a list I can use the xs:integer to try to force it to be an integer, however, I'm not quite sure how I should do this for values in a list. Any ideas on this?