General

Logs: OpenAICompletionsConnector_2 Input Input Collector (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_Input1680804321 Input Splitter (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_ParameterFetcher (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_EmptyNumericValues (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [3]: Starting HTTP upload to 'api.openai.com'. Expected transfer size: 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [3]: HTTP Upload: sent 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [1]: Starting HTTP upload to 'api.openai.com'. Expected transfer

HelloAs stated in the title, the left pane takes too much space thus making harder to write / review codes. It basically cannot be resized. Noticed this in FME 2023.0.0.3 and 2023.0.1

here's the curl:curl --request POST \\   --url https://api.assetpanda.com/v3/session/token \\   --header 'accept: application/json' \\   --header 'content-type: application/json' \\   --data '{ "email": "username@company.com", "password": "pASSWORD123"}'

Install: WordToPDFWriter Dependencies1 comtypes python package To install this depenency,  start a command prompt as an administrator and execute the following command:  fme.exe python -m pip install comtypes --target "C:\\Users\\<YOURUSERNAME>\\Documents\\FME\\Plugins\\Python"2 Microsoft Word must me installed on your machine. ========================================================Error running on FME server: 119 2023-2-13 15:08:46 | Python Exception <ValueError>: NULL COM pointer access120 2023-2-13 15:08:46 | Traceback (most recent call last):121 2023-2-13 15:08:46 | File "<string>", line 47, in input122 2023-2-13 15:08:46 | File "C:\\Users\\xxx_fme\\Documents\\FME\\Plugins\\Python\\comtypes\\_meta.py", line 13, in _wrap_coclass123 2023-2-13 15:08:46 | result = punk.QueryInterface(itf)124 2023-2-13 15:08:46 | File "C

View Data > Exercise: Customize Your Viewhttps://safe.my.trailhead.com/content/safe/modules/view-data/exercise-customize-your-viewUsed the geojson as input instead, worked out fine. 

I am very new to FME and have recently learned the basics of the software. I'm starting to apply some of this knowledge to building workflows and was curious the best way to go about reading in 200+ shapefiles to write to single feature class in a file geodatabase. They all have identical schemas so my thought was to read them in by adding the folder they're stored in, using *.shp as the dataset indicator, and using the Single Merged Feature Type option for the Workflow options. Is this the best way to do this?

Hi everybody, I created a Workspace. This Workspace should be started by an external http-request. If the workspace ended, i wanted to send back a response. I published the Workspace with fmedatastreaming + included the writer to the stream.The response was send as a file. I wanted to send the response as content in response. Any Ideas?   

How do you multiply each row of Attribute A with Attribute of B? Similar to excel operation? I need to convert imperial units to metric.  I can multiply the attribute with a User_Parameter and I can also multiply two attibutes together and I can also use the Expression Evaluator. But, for each operation I get about 200 lines of WARNING. What is going on? What is the correct way to multiply two attributes or an attribute with a user_parameter?

I have files in a folder. I want to select the files with a path_modified_date from the year prior. Example, if the path_modified_date contains "prior year" then zip these files. I know how to do the zip files part.  It is the If the path_modified_date contains "prior year" part that I am having trouble with. The files in question accumulate every year and I would like to set up an automation in FME Flow that runs every March and zips the files from the previous year. I know how to set up an automation. Here is what I have done so far in FME Form. The Tester passed if @Value(path_modified_date) Contains 2022; If I use this workbench as is, every year I want to run the workspace I would need to go in and manually change the Right Value in the Tester to the prior year. I want to know if there is a way where I can automate this portion?

The FeatureReader has the option to read "Schema and Data Features", "Data Featues" and "Schema Features". In an attempt to optimize a process which converts a bunch of AutoDesk dwg's I tried to first read only the schema (the layers), determine which of the layers need to be read and feed that list in a second FeatureReader as Feature Types to Read. I found out I was getting slower performance, due to the FeatureReader being really slow to read the Schema Features.Reading SchemaFeatures from the dwg took 120 seconds.Reading Data Features from the dwg took 2 seconds.Reading from an empty file did not result in a different performance. Why is this so slow? Does it have anything to do with the parameters?I think the FeatureReaders FME Defaults should be "Data Features" as a lot of users would benefit from the increased performance.

Hi,  I would like to create a table showing all the attributes available per feature type and the count for each one.  For example, I have these datasets: Trails, Activities, Landscape which contain similar attributes, but also different attributes. (similar = objectid, name...) (different= trail size, type activity).  I want to generate an overview with all the attributes and to which feature type they belong to.  Any idea how I can do that without using too many transformers?  I have already tried many options:1) attribute exploder, unique values (but then I can trace back to whcih feature type it belongs to)2) attribute manager, change values to feature type, then statistic calculator (but then I have to use one attribute mananger per feature type which is redundent).  Any ideas how I can make this script dynamic? Thanks

Starting out with feature reader, and I am definitely missing something. The input dataset has about 1,600 records. Why is the output at 366,458 (and counting) about 10% of the way through? Thank you,

Some jobs are queued before it is allocated an engine for processing due to shortage of available engines or based on priority of job queues. I would like to know how many jobs stayed in queue for more than 30 second before it was processed? This will help us to allocated additional engines... Is there a way to do this analytics in FME server? Thanks

Hello ,i would like to connect FME professional with Azure AD to write the output from Fme to azure .i would like to ask , after creating web connection in Fme professional. How could I publish the web connection in FME server ? to read the data from azure ad ,which transformer should I use storage blob connectors or https caller my second question : how let the workspace to write the output directly the file into Azure AD ?could someone explain idea or provide screenshot of workspace ? FME 2021 thanks in advance

Hello , How to split the content of one column to two columns ?my output of aggregator looks like string12-string56 at same cell in one column and all rows similar . i would like to have two attributes one called base include string12 and other attribute called next include string56 and implement the method for all rows  Which transformer should i use ?how to use it ?fme 2021 thanks in advance  

Reading/writing files(e.g .xlsx) from /into local drive not working in FME Flow 2023.0 (b23332) but FME Form does read/write the same files from local drive.

The files are ziped .shp files broken up by state. I need to merge them into one nation wide dataset and safe to a geodatabase. A general workflow would be very helful. Or a list of Readers, Transformers and Writers and things to pay attention to.

I am trying to access each row of the excel data I read with pythoncaller. How can I do that         coulumnData = feature.getAttribute('Column1')        data = str(coulumnData).split()        for row in data:            print(row)and how do I read FLOAT values as well? I do not understand what kind of object is returned by feature.getAttribute. If I print coulumnData, it is printed nicely row by row. But, how do I access those row of data? I want to do something like         coulumnData = feature.getAttribute('Column1')        data = str(coulumnData).split()        print(data[10]) 

I'm able to setup and use "OpenAICompletionsConnector" succesfully with text-davinci-003, but since the completions API models will be deprecated at the begging of the year 2024 I wanted to try Chat completions with gpt-3.5-turbo as described here.I understood that is hould use another transformer called "OpenAIChatGPTConnector". I use role "user " and as "content" I use the same prompt as for Completion to resolve not well-structured addresses. With this setup the Connector somehow aggregates all the features from input port an

When I read data from a PostgreSQL/PostGIS database and I inspect the features using the Inspector, all attributes seems to be of data type "string: (UTF-8)" when looking at the "Feature information" panel. But when I look at the "Table view" panel, the id column (defined as serial4 in the database) is formatted as a number (the value is aligned to the right). Boolean values are read as either "t" or "f" (still "string: (UTF-8)") while when reading boolean values from a GeoPackage they appear as "Yes" or "No" (and the data type says boolean). If I look at the debug logging I see that a boolean postgres attribute has an entry like:Attribute(string: UTF-8): `my-field' has value `bool,BTREE' While a GeoPackage attribute has an entry like:Attribute(string: UTF-8): `my-field' has value `boolean' Is this really the expected o

Hi, I would like to use FME in order to retrieve some data by sending HTTP request to a REST API.  A GET request can only retrieve 1000 entries per call and follow the FIFO method (First In, First Out). So I need to GET 1000 entries, process the data and then DELETE 1000 entries and start the cycle again until there is no data left. I setup a loop in FME:I've read on this forum that a blocking transformer can not be used in a loop without beeing exported, so I've exported the custom transformer GET_API that contains (.FMX): So each loop should produce 1000 features.Outside the loop it works well when I only send 1 request. But inside the loop I get this error messa

Hi everyone!I'm new to FME and I have a question on how to group entries of a table based on two columns. This is the table:Now I want a new column with the group ID. It should look like this:Explanation:If the fruit is the same, they should belong to the same group --> Apples are in group 1.If the Buyer of group 1 also buys other fruits, then these fruits should also belong to group 1. -->Anna also buys Bananas, therefore Bananas belong to group 1 I tried different transformers, but did not find a solution. Can someone help?

In Portal for ArcGIS 10.6.1 in the backups folder there is a walarchive folder. The files in this folder accumulate daily. Annually 14,000 files are created. Each year these 14,000 files together equal approximately 143GB. There is no setting to change this in 10.6.1.   Every January, for example, in order maintain a reasonable amount of disk space, I manually delete the 14,000 files from the prior year. It is a fairly straightforward task to delete these files, but I am starting to wonder if I could create a workbench and let FME do this.   The file names are random digits and sometimes a letter is included in the name. There does not seem to be a pattern to the file names. I cannot reference the file names in a workbench because of this.   The only way to identify which files to delete is by the Data Modified column in Windows File Explorer, example, delete all files between 1/1/2022 and 12/31/2022 would be a single year.   H

Hello ,  i got 6 lines at rejected port from network topology calculator transformer .the reason is invalid line geometry .How could I fix it ? What does the reason and what should I check ?FME 2021 thanks in advance .

Hello.I have some data like this:123 m32 m56 m...and I want to keep the numeric part and ommit the unit (m). Which way is the best?