Authoring

Hello,Is there any way to assign Index “Primary key” to the field and Type “serial” somehow in another way rather than in Feature writer - User attributes? These options are not present in AttributeManager transformer, unfortunately. That would help me to reduce number of manual adjustments and use “Automatic” attribute definition. Because I have many FeatureWriter transformers in my workspace and I need to replicate it to read another data.   

In the above image, I read a text file that contains lines of data where specific lines that start with an ID relate to different features.In the #1 category it contains the projection information but I want to be able to set the projection of the other output ports based in the information in that line.How do I hold and set the projection of the Lines, Points, etc?I was thinking that I may just need to read the text file twice, once to get the projection from Port #1 and then have a feature reader that can then set the projection before processing the other output ports.Is there a more efficient way of doing it? 

Hello.I have a JSON file the looks roughly like this, containing a list of un-named values:{ [ { “UniqueID”:123446,      “Dealership”:”Dan’s Dodge”,      “Owner”:”Dan”,      “BestSelling”:        [ “blue”,          “red”,          “blue”,          ...          “red”        ]      ...       “Telephone”:”411”    },    ...  ]}My first JSONFragmenter feeds two workflows: the first workflow captures the named values (including “UniqueID”), and the second

I want to Run FME process through task schedeuler. The fme workspace is reading data through postgresql. I am able to run it through any specified user. I want to run this through LOCAL SERVICE in Task scheduler.But it is showing error. My 0objective is the process become independent of user  Error connecting to PostgreSQL database(host='', port='', dbname='abc', user='', password='***'): 'fe_sendauth: no password supplied Thanks

Trying to free up some space on our existing FME Flow server and noticed that there is a folder on the root C: named “FME” that have various FME installations folders. In each of those folders, there is .cab and other installation (.msi, .exe, .log) files. The total file size of these folders is ~50GB on the server!I cannot find any documentation that states that is okay to remove these files.  Does anyone have any information about these?Thanks for any help!-Cameron

Hello, Im using FME form on macSilicon and ran into an error trying to run simple workspaces: /Library/FME/2024.1/fme is trying to execute itself. Aborting to avoid infinite loop. I managed to solve it temporarily by reinstalling the whole package, but after a while it started giving me the same error.Ive tried different workspaces from the tutorials with the same result, I imagine is something about the setup. Any suggestions can help, thanks!

Hi,I have seen a few articles about updating metadata using the ArcSDE writers, which involve writing data and adding metadata simultaneously. However, what I want to do is just add new metadata while leaving the existing data unchanged (without accidentally overwriting it with nothing). I already have my metadata and types formatted as described in the articles I’ve read.xml formatted for esri importHowever, I am struggling to determine the exact settings needed for the writer. Since we don’t have a test system, I want to ensure I’m on the right track before proceeding. That said, I can create some test tables to trial the process. This is a related article which also update the data: 

Hi this puzzles me: using FME(R) 2022.2.3.0 (20230131 - Build 22789 - WIN64), when reading an Open File Geodatabase from a zip file, features are duplicated. I created and attached a template which demonstrates the error. The workspace uses two readers to demonstrate the phenomena, both of type File Open Geodatabase.The first reader reads from ..\test.zip\test.gdb The second reader reads from ..\test.gdbRecords on the first reader are duplicated. When reading from just test.zip the duplication does not take place. Is this behaviour as meant to be?

Hi, If I’m writing a fme-binary attribute out to jpeg using an AttributeFileWriter is there any way to publish as DataStreamer on FME Flow?  

Hi,I am wondering if someone can give me some ideas on how I could pass the result of a sql query from a sql executor so that the result or specifically an ID is passed sequentially so that each is fully processed before the next one starts. So the result is as shown below. The attribute I’d like to pass one by one is either the device_id or the row_index.I have had a look at this post iterating/looping a workspace using attribute values | Community but cannot formulate the workbench to do this task.Any suggestions very welcome.Thank you.fb

Has anybody experienced an issue starting FME Form (tried from v2023.2.1 to v2024.2) when having 3 displays connected.We have 2 LG 24MP60G 1080p monitors conected to a Dell Alienware X15 R1 (Intel Core i7-11800H 4.20Ghz, nVidia GeForce RTX 3070 8GB GDDR6, 32 GB DDR4). In this setup FME opens as a blank white windows.If we disconnect any monitor FME starts as usual.Please let me know if anybody else experienced something similar or if this is a known issue.

Connection to postgres seem not to close after query execution to postgres db. We are here allowed to have 5 connections to the postgres db and with the SQLExecution for each feature entering the transformer, a connection is established but seem not to close after the the query has been executed. After 5 features have entered the sqlExecutor I receive an error message: Error connecting to PostgreSQL database.....................: 'FATAL: too many connections for role "xxxxxxx"Is there a way to close the connection after each featue that enters the SQLExceutor? We are using FME 2021.1

With a permanent licence fme desktop hit much engines do we have available ? 

Hello, In the case of having a permanent FME Desktop license, can it be reused on new machines ( i want to use it only in one engine so i would like to know is it possible to use it in anothe engine), or do we need to purchase new ones?

Hello,I’m having a hard time figuring out why a json file created with a Text Writer is not accepted by the GoogleBigQueryConnector.I have an original JSON Key File downloaded from Google Cloud for the Service Account we are using to authenticate to BigQuery. This JSON file works fine and I am able to authenticate and select the Dataset I want to upload data as well as the table in that Dataset.The problem is that since I have to use a system environment variable and specify the service account key file location in that variable in order for the GoogleBigQueryConnector to be able to use Service Account instead of Web Connection, it seems the GBQC takes the project_id specified inside that json file and uses it as default project to log you in, which means that even if you have access to different projects in BigQuery you can only access 1 project per Service Account Key File.Here is an image of the error I get for when the GBQC tries to use the JSON file

Hi,I have a workspace the reads json files: I need to publish this to Flow, and configure parameters to enable the user in Flow to read files from a certain folder. This will change several times, and I do not mind this part being a manual process.I am unsure of exactly how to configure this.I have set up a Folder and Pathnames user parameter:I have configured it to select Folders, and called this “SourceDataset_PATH”. I have then configured the parameter for the json reader to point at the SourceDataset_PATH parameter.

I have a series of Feature Services in ArcGIS Online.  Unfortunately they contain attribute names of varied case. This is proving difficult for me when I try to create a dynamic workflow that updates the data in ArcGIS online.  When the Reader reads the source data (also of varied case), it converts them all to lower case.Therefore, when my workflow tries to write to ArcGIS online, it cannot find matching attributes to write to because the case is different.It is now too late for me to change all the layers on ArcGIS online to lower case because of downstream dependencies. Will I have to write a separate workflow for each individual layer and individually do the field mapping?Or is there a way around this ?

From a csv file, I determine the target layers that I wish to update on ArcGIS online.The following 2 transformers build the source layer name deriving it from the csv data.My source data name is an attribute titled “portalservice_andfolder”This is fed to a dynamic reader that reads my enterprise portal for each layer.There’s an issue with the Reader.  Refer blue summary for settings.I’m getting all the features come through but only the schema for the FIRST feature type only.Refer the below image which is the result <Generic> port from my reader.  The schema port has a count of 1 when there are actually 2 source layers.The image below shows that the fme attributes are missing for the second feature type.

Hi,I have a scenario where I need to recode the pixels of raster, but the values are determined at run time.I have a list of from-to values, but what is the best way to implement that?The RasterCellValueReplacer will take attributes, but not a list.  Is there any way other than looping through the list and recoding the raster one value at a time?   There can be anything between 1 and 300 elements in the list.

I am writing to a file gdb, I will need to run my workbench to update this file gdb each month. The schema of my incoming tables may change so I have used a schema scanner with a dynamic writer.I want to use drop and create for table handling but it is not behaving as expected. Instead of dropping the existing feature class it just appends the entries to the existing table.I am not sure why this is happening. Of note, my feature classes are also within feature datasets. See attached screenshot of writer settings.  

I’m trying to follow the FME Form course from a MAC and one of the very first exercises is using a Esri Geodatabase (File Geodb Open API) writer. Unfortunately I’m getting this error on the platform. Is there any workaround for this?

Error: “the number of points is less than required for feature”,  We are extracting data from CAD files. The destination is layers stored in ESRI file Geodatabase. Copying the features from the generated layers to other enterprise geodatabse layers result in the error below:  CAD file: http://www.mediafire.com/download/ii2dszjoo4zoij4/AsSamou_Hebron_MasterPlan_05_X_03.dwg    Workbench   Extracting the Roads polygon (Roads = Boundary – Landuses)    

I have a large number of points, which I would like to join by simple lines (point-to-point), minimizing the overall summed length of the generated lines. There's no preferred path, but all points must be connected to each other by a single network of lines.My output just needs to be a set of simple lines.Do anyone have an idea on how to accomplish that, other than grinding it out in a PythonCaller ?CheersLars I

Hello, we have inherited a range of very large workbenches and was wondering if there is a way to get a summary report of the major components like parameters, database connections,  inputs,  outputs and names of bookmarks. 

I had a pair of coordinates stored in a single column named "geometry." I used the Attribute Splitter to separate these coordinates and then exploded the list. Now, I have each latitude and longitude in the same column. Is there a way to copy these latitude and longitude values into separate columns labeled "Latitude" and "Longitude" while maintaining the same order?