Authoring

Hello FME friends, I have a question about system path variables and how that translates to FME server.I downloaded the Google cloud Storage connector from FME HUB. I'm using a Google service account along with a service account, JSON key file. Part of the configuration is to set the windows environment variable GOOGLE_APPLICATION_CREDENTIALS to a JSON key file I downloaded from Google Cloud Console.The package works flawlessly in FME workbench on my workstation. I would like to now publish a workflow to FME server, but am scratching my head trying to figure out how to deal with the environment variable GOOGLE_APPLICATION_CREDENTIALS and how that translates to FME server. I assume the .JSON key file for this Google service account needs to be on FME server somewhere, but how do I tell FME server that the environment variable points to the .JSON file on an FME server resource folder? Thank you!

I've got some features and one of their attribute is a sequence of number or number with letter such as A001, A002... Now some of numbers are miss from sequence due to editting was performed. Is there a way to find out miss numbers and asign them to newly created feature from North to South, West to East?

I would like to create new attributes for all features with a value of null. The tricky part is that the number of these attributes and their names is not known before running the workflow. The names have to be equal to the feature values provided by some part of the workflow. I attach an image of what I am trying to do: I am feeding the AttributeCreator with the main table (the one where I want to have new attributes --or columns -- with null values) and with the UnmergedRequestor of the Feature Merger. The feature values of SimWaterBodies_FN (the output of the UnmergedRequestor) are supposed to be the names of the new attributes (2 in this case) of the table. I have tried by setting @Value(SimWaterBodies_FN) as the New Attribute and null as the Attribute Value of the Attribute Creator, but this doesn't create the 2 columns with same length of the main Table. Here is a simple example of what I am trying to do: Let's say this is the main Table initially:  When I run my workflow

HiI'm using FME 2018.1.1.2 18586 and having weird crash errors. The app crashes apparently at random, I have taken a blank workspace and added a MapInfo file as a reader and the workbench app crashed. this happened several times. I left Workbench open for a while (maybe an hour - working on other things!) and tried again and it added successfully this timeThe odd crashes have been going on all through the 2018 releases. I only have this release installed on my machine. It seems to like to crash when using Feature Caching mode more than any other time or when using HTMLReportGenerator (which is quite annoying because this transformer is a gem)Is there any advice that anyone can give me to stop this please? FME used to be rock solid on my machine and recently it has become very buggy, to the point where it is becoming quite unusable.I've reinstalled previous versions to try and combat this issue and I am using a build that is only a few weeks old nowThanks in advanceAdrian

I have a problem with one of my workbenches. A few actually, but the most important one: It skips a part of the workbench and I have no clue as to why.  After this, it continues, but no suprise: Point on area overlay does not work without points. Problem 2: Featuremerger does not work. It simply refuses to merge 2 identical columns. The weird thing; If I use chashing and run from the featuremerge onwards it will merge and it won't skip. And then the second feuturemerger refuses to merge only a few (+/1 100 out of 3000) feutures. I get no error messages at all. I am at a total loss as to what is happening and I am getting a bit frustrated.  

Hi,I am creating a dynamic schema from a list, however when I am trying to create a GUID in an Esri File Geodatabase it is showing the field as text (using both writers and changing the format_short_name). What's more annoying is this same example is shown in this article: https://knowledge.safe.com/articles/1051/index.htmlDoes this no longer work, or can you see an issue in this example??Guid.fmw

Dear community,I don't find a solution to my problem and hope someone can help.  To automatically create XML documents for a metadata catalog, I created a generic FME workspace. An SQL Creator serves as an initiator to a FeatureReader and all features and feature classes are received through the <Generic> Port of the FeatureReader.Because I tend to create a document for each feature class (POSTGIS table) rather than for an individual feature, I use an Aggregator to only have one feature per feature class. Important here seems to be that I use the Group By setting which groups all features by feature class (attribute fme_feature_type).After having gathered all necessary information for each deature class (like bounding box and description/title) with various transformers, the processing chain comes to the XML templater which creates the XML file document.The problem is that I have no idea how to deal with the keywords that are saved in a list attribute (array). I have a root templ

I'm currently trying to create a script to run a workspace, and test the output against an expected result. However, although I can successful import fmeobjects, it seems to have no attributes?console example: in a script:AttributeError: module 'fmeobjects' has no attribute 'FMEWorkspaceRunner' I'm using fme 2018.1Any ideas?

I have a workspace that uses a feature reader to read just one table from a geodatabase. I need to batch run this workspace for every feature type in the geodatabase.I created a new workspace with a schema reader and a workspace runner to run the original workspace, with the feature type populated from the fme_feature_type_name from the schema reader. The feature reader in the child workspace fails. If I hard code the feature type in the published parameter in the workspace runner in the parent workspace, the feature reader in the child workspace runs. But as I need to batch run this doesn't solve my problem.I've made a pair of sample workspaces that replicate this issue with an Excel Spreadsheet. They're here:  Is there any way to do a batch run with a feature type as a parameter that can be varied to cover the whole schema?  

I am looking to make lists based off of attributes that have i currently have. For example (photo below), I am looking to build a list between Field1 and Field2.For example in the first row _list{0} = 40, _list{1} = 41, _list{2} = 42, ... _list{10} = 50. 

Hello All,I have an excel file wherein i have two header rows, first one with a main heading like 2019 and the second one below it having sub-categories like Furniture, Music, Fun and then the data from third row. Is there a way to write the data to an excel file in the same manner of first row showing the merged cell and the second row showing all showing all separate values?Thanks

FME Server 2017.0 Does anyone have insight on what permissions are required for the FMEServerJobWaiter to work? I have tested with other admin level users and there are no issues using this transformer. FMEServerJobWaiter(ServerFactory): <servername> - Waiting for job #384798 to start; polling every 10 second(s)...FMEServerJobWaiter(ServerFactory): <servername> - Failed to wait for job #384798FMEServerJobWaiter(ServerFactory): Reason - user '<username>' is not authorized to perform this action

Hi all, I have an issue in new FME. I'm trying to set up User Published Parameter that will give user list of attributes available in workbench. But after choosing a Type: Attribute Name it doesn't see any attributes available. As my input I use shp files. Is it a bug or I didn't do it properly? Regards

I need to make an export of my data with a format like this:   I want the output to be in seperate files (fanout) based on a single row value per group I grouped the data by groups, so each group has unique attributes. How I can fanout and get the filename to be a single row attribute? ('bestandsnaam'), so in this case '504.pfrl' 

Hi guys, i would like to split attribute value into 2 substrings separated by comma delimeter. I am unable to split it with string replacer or attribute creator.Type of data:What i tried:@Substring(@Value(NASLOV),0,@FindString(@Value(NASLOV),",")) andAny suggestions? thanks in advance, Bye Miha

I ran a rather lengthy fmw using feature caching...open in one window.I opened another fmw and decided I didn't need feature caching for that fmw so i disabled feature caching and ran my workspace.When I returned to my completed fmw window the caching indicators were removed since no caching data existed anymore.I think this is an obvious issue. Running or not running with Feature Caching enabled should not be globally reflected just workspace specific. Either that or a previously run fmw should not be altered.Anyone else experience this?Thanks,PeteP.S. About details:FME InformationEdition: FME Database Edition (node locked-crc) Version: FME(R) 2019.1.0.0 (20190704 - Build 19604 - WIN64) Locale: en_US Codepage: 1252 (ANSI - Latin I) Registration Key: 1-542-353-546 Serial Number: 0 Customer Number:  Home Folder: C:\\Program Files\\FME\\Beta\\ Operating System: Microsoft Windows 10 64-bit (Build 17763) 

I've got an excel spreadsheet of data with a primary key column, a foreign key column, then various other columns that may or may not contain data. I'm trying to create a single attribute that lists all of the columns/attributes that do not contain data for a given PK/FK combination (i.e., are null/empty/missing).PKFKAttribute1Attribute2Attribute31A DATADATA2ADATA  3BDATA DATA4BDATADATADATA So the output would look like this...PKFKList_of_null_attributes1AAttribute12AAttribute2, Attribute33BAttribute24B  Any ideas? I can't seem to wrap my head around this. My first thought was to attribute all null/missing/empty attribute values with a unique identifier, then replace all real data values with an empty field so that I can drop those attributes with a ListConcatenator.Right now my workflow for that includes a NullAttributeMapper to replace null/missing/empty values with a specific unique character (lets say "X"), a stringreplacer & regex to replace all data valu

Using FME Server and Desktop 2016.1 I created a workspace calling a job on FME Server using the FMEServerJobSubmitter transformer.The "Wait for server job to complete" is set to "Yes".If the job succeeds I use the _job_id to get the log file and email using the file as attachment.If the job fails (it generated a log file containing an error) I do not get the _job_id attribute (see image).How can I retrieve the log file from the server if the job fails, but produces a log file?This log file is even more urgent than the succeeded job's log file.

Is this expected behaviour?I am extracting a 32 bit real value of "7.35" using python using feature.getAttribute in 2018.1/2019.1 (and probably every other one). It is returning 7.349999904632568 as a 64 Bit Real . I get that this calculating using 64 bit, so that's where it is coming from, but interested that it is performing that calc on an existing known number.The workaround was to use feature.getAttributeAsType(<attribute>, 11) to treat as a stringExample attached

Hi all, Context: I have a workbench that is aggregating and compiling data from 13 different SDEs. The datasets are managed slightly different source-by-source. I determine adds, updates and deletes via a CRC comparison, but there are feature classes (not all, some) that are participating in editor tracking. There are two different possibilities for the pertinent editor tracking field: MODIFY_DATE and last_edited_date. Sometimes, both of these fields exist in a feature class, with one being associated to esri's editor tracking. Objective: I want to use the arcpy method, describe, to pull the editor tracking field name. Based on that result, I want to filter features on 1) if they have editor tracking enabled, then 2) between MODIFY_DATE and last_edited_date. Method: I have a private parameter python (named editorTracking) script as follows:import fmeimport fmeobjectsimport arcpydef processFeature(feature):    desc = arcpy.Describe(feature.getAttribute(pathway))    if desc.editorTrackin

Hello,I'm trying to find an elegant solution for a feature merge based on the same list, twice.So, data is a shapefile with polygons as features. Each polygon have a _class{}.ID list. The goal is to compare each _class{n}.ID to other polygons (not itself) _class{n}.ID (nmax is different for each polygon), to finally agglomerate their geometry.Issue is that ListBasedFeatureMerger takes attributes as supplier key and not lists.Example:NAME _class{0}.ID _class{1}.ID _class{2}.ID Oscar 27 92 1 Tango 1   Charlie <Missing> <Missing> <Missing> Golf 22 12  Whiskey 92   Hotel 137 4 6  So here, Oscar, Tango and Whiskey would be agglomerated.How could that be done ?Thanks

Hopefully not too obvious an answer, but I've been wading through FME documentation all day to try and figure this one out.Essentially I want to build a dynamic workflow that I can point to a series of GeoJsons that:Will have similar, but differing schemas Many will share attribute fields, but not universallyWill be consistently namedI want to then write to an SDE, initially as a new table but from then on only as an update. These output SDE FeatureClasses:Will require additional fields that again are not universalWill vary in geometry type, but only between FC, not within a FCI'd like to be able to design a workflow that will be able to generate the output FC schema based on the input, and picture that this should be achievable by using a lookup table something like the following:1FCA, FCBInput attribute fieldDestination attribute field2FCA, FCC, FCDInput attribute fieldDestination attribute field3FCB, FCDInput attribute fieldDestination attribute field4FCA Destination attribu

While using FME 2019.0, I have noticed that I now get the following error when trying to write a datetime to a file geodatabase date field."An error occurred while attempting to convert the '' component of a date. A possible reason for this is that the data in the date field may be corrupt"This is not an issue in version 2018.1 or if I write to a text field instead in the 2019 version.I do use the following in an AttributeManager to reformat the datetime"@DateTimeFormat(@DateTimeParse(@Value(Date_Created), %s), %Y%m%d %T)"If I drop the "%T" part then it works but I no longer get the time which I would like to keep.Is anyone else experiencing a similar issue and/or found any resolutions?Regards

I have a workspace that has three initial inputs - 1 - A DWG file, 2 - A PostgreSQL table and an excel file.I would like to use Workspace Runner to process all DWG files in a particular directory but when it runs doesn't kick off the process for each drawing as I would expect. How do I use workspace runner to pick up the correct input and process each of the DWG files?

There is a workspace that copies a dataset from a production oracle database to a postgresql database. The postgresql database will be weekly updated with fme-server.What is the fastest way to udate the postgresql database?- check for the differences and write only these to the progressql database - drop and create the table, so you write each time the complete dataset.-or maybe another solution?Thanks,Kind regards Kees