Skip to main content
  • EN

General

A read-only category for lost FME Form topics. We hope to move them shortly.

  • 4,042 Posts
  • 13,932 Replies
4042 Posts
laurentp
Contributor
laurentpContributor
asked in General
Can't connect to G3 Smallworld using the SBS Plugin for Smallworld in FME.

I am working as a consultant for Consortech Solutions and I have a client who is trying to make his G3 Smallworld connection work in FME using the SBS Plugin for Smallworld. Unfortunately, the reader in FME doesn't work all the time. When it fails to show the table to choose from for reading data using the SBS plugin for Smallworld reader, the error message returned is "Bad or Invalid License for feature: spatialbiz_read [-12]". What's weird is that sometimes he is able to read his data in FME using that same reader but sometimes it fails to read the data.  Is that something people have experienced in the past and if so, is there a way to solve this issue?

950
laurentp
Contributor
creinier
Contributor
creinierContributor
asked in General
Validating a schema.

I have 200+ shapefiles I would like to read in and merge into a single fgdb feature class. Some of the shapefiles have slightly varying schemas. Is there an efficient way to read them all in at once and validate if the schema is the correct format I would like? Rather than going through them one-by-one?

240
hvukasinovic
Contributor
jatoxa
Contributor
jatoxaContributor
asked in General
How to write geometry to AIXM 5.x

Hi all,I'm new to AIXM data but I'm facing the challenge of converting GIS data to AIXM 5.1. I am beginning to understand the structure and complexities of the model and I also went through the article and FME template that is online here. I can write out the desired structures but I can't write geometry. It seems it expects an attribute called part{} for the geometry. I have tried different variations of renaming and extracting the geometry.  Edit:Theres's an example of writing to FILEGDB to AIXM and back in this webinar, but the workspace itself isn't available anywhere. https://www.youtube.com/watch?v=3KW0Bj01Wj0&t=960s&ab_channel=FMEChannelWould it be possible to share this AustriaObstacles filegdb to aixm workspace? Any pointers would be greatly appreciated!Thanks!

680
jatoxa
Contributor
soly
Contributor
solyContributor
asked in General
How to solve self intersection p-case ?

Hello , How to solve self intersection ( p-case ) ?i would like identify which lines has p-Case and solve this problem ?as example I have a line with specific id starts at point and closed back at the same point .Will be possible to let the line to cross this point and no intersection at start point ,if it is possible .Thanks in advance .FME 2021

170
soly
Contributor
C
clives_online
asked in General
Merge records into one row

Greetings,I used FeatureJoiner to merge a Spatial and non-spatial records using a common value (grid_id).  I use a Tester to select a scenario ie date is 2000, 2030, 2040, etc.I then use a StringConcaternator to add a value to a cell (overwrite cell value), the cell for 2000 will be 0 -5. I also have a Tester for 2030 (2C), 2030 (4C), 2040 (2C), 2040 (4C), etc. The records in the FeatureHolder, should all be written to a single row.Instead I have a row per date/scenario?? For 2000 I have the following data. The output is written over n rows, not a single row?? How do I append records into a single row??Any suggestions are appreciated. ThanksClive

330
C
kdwss
Contributor
kdwssContributor
asked in General
Discrepancy is AutoCAD outputs when running in FME Flow vs FME Form

I've built an AutoCAD based automation in FME Form and use blocks with text for some of the output features. The text aligns how it was designed in the block in the FME Form output.   However, when running in FME Flow the text shifts. If I move the block slightly or edit the text in AutoCAD then it snaps back to the correctly designed position.I'm using the same template dwg in FME Form and FME Flow. 

100
siennaatsafe
Safer
M
mbatinic
asked in General
Creating a new table from the main database based on attributes

Hello,I have a main table called "Documents". I need to create a table called "List" based on data from the "Documents" table. Within the "Documents" table, I have a column called "ElaborationType," and within it, the number 1 represents the main document. Numbers 6, 14, 33 represent documents related to the main document, i.e., they are lists. My goal is to generate results in the "List" table where the "RecordID" in that row matches the "ElaborationType" equal to 1, but it also repeats or duplicates that number based on the numbers 6, 14, 33.(EXAMPLE: 2302(6), 2304(MAIN DOCUMENT NUMBER 1), 3177(14) belong to the same group because they are in the same cadastral municipality KO_ID).Within the "List" table, I need to have 2304, 2304 because they are lists for the main document 2304, and they must have their corresponding year from the "FromYear" attribute.Is it somehow possible to solve

3220
M
tnarladni
Enthusiast
tnarladniEnthusiast
asked in General
HTTPCaller returning 403 error

This is the URL i'm trying to access. https://qpublic.schneidercorp.com/Application.aspx?AppID=1048&PageTypeID=4&KeyValue=450070160000It's a public link. If I try to access it via the HTTPCaller, it throws a 403 error. Why would accessing the link via HTTPCaller throws an error? Thanks

730
thijsknapen
Contributor
afrancio
Contributor
afrancioContributor
asked in General
How to connect to an open data base such as the Government of Canada Open data

Is it possible to establish a connection to the Government of Canada's open data portal. From there I would like to be able to pull certain layers of interest and then transform them to output products I can share to staff/public.

90
redgeographics
Celebrity
dos_gis
Contributor
dos_gisContributor
asked in General
The download link for FME Form 2023.0.2.1 for 64-bit Windows seems to be broken?

https://engage.safe.com/support/downloads/fme/2023/win64/fme-form-2023.0.2.1-b23339-win-x64.exe

2740
redgeographics
Celebrity
R
romuldkiobya
asked in General
SUBTYPE DISPLAY CODED VALUED INSTEAD DESCRIPTION

I ask I have checked subtype/Assetgroup but the data still displays coded values instead of description

50
redgeographics
Celebrity
db_apha
Contributor
db_aphaContributor
asked in General
What are the transformers that benefit the most from being upgraded?

Currently I am moving from FME 2018 to FME 2022, but during the FME Desktop Advanced trailhead training it says that some transformers only have cosmetic changes. I want to know what the main, commonly used transformers which I can advise my team to always upgrade in their workbenches. Thank you in advance

480
dustin
Influencer
viviancfhung
Contributor
viviancfhungContributor
asked in General
license related issues

We updated our FME server from 2022.0.1 to 2023.0.1, ButWhen I try to convert a FGDB file to another format. I get the error screen as belowWe installed Arcgis pro 2.9.3 already.But it is working fine in FEM server 2022.0.1

90
viviancfhung
Contributor
naveen
Contributor
naveenContributor
asked in General
Marking FME server job failed

When the published workspace is unable to connect to database or ArcGIS services via feature reader, then the translation fails but the FME server job status is success. I would like to know if there is a way that FME server status can be marked as failure when specific condition are not met with in the FME workbench workflow??

710
naveen
Contributor
angwan
Contributor
angwanContributor
asked in General
OpenAICompletionsConnector: Getting this error OpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): An error occurred while accessing the URL 'https://api.openai.com/v1/completions'. This connector used to work in FME Form 2022.2. Any advise?

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 size: 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [1]: HTTP Upload: sent 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [2]: Starting HTTP

450
j.botterill
Influencer
sameer
Contributor
sameerContributor
asked in General
Cannot resize "Page Contents" pane using "HTMLReportGenerator"

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

80
sameer
Contributor
E
eric.collins
asked in General
How do I set up HTTPCaller to get a token using curl

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"}'

1200
daveatsafe
Safer
perry
perry
asked in General
I use the custom-transformer WordToPDFWriter. On my desktop it works fine. When I run this workspace on the server I have a failure. What causes this error and how can I solve this?

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:\\Users\\xxx_fme\\Documents\\FME\\Plugins\\Python\\comtypes\\__init__.py", line 1197, in QueryInterface125 20

560
keziaatsafe
Safer
mapixse
Contributor
mapixseContributor
asked in General
Exercise in training module refers to MapInfo file which isn't included

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. 

50
samatsafe
Safer
creinier
Contributor
creinierContributor
asked in General
Reading in hundreds of files.

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?

400
creinier
Contributor
B
barbara
asked in General
start workspace by http-Request -> Send response

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?   

593
B
M
moostang88
asked in General
Multiplication of two attributes

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?

930
geomancer
Evangelist
vxn43
Supporter
vxn43Supporter
asked in General
Select Files with path_modified_date last year

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?I added a Year field to Attribute Manager takes the left 4 digits (the year) from the path_modified_date field. Then I changed the Righ

1803
boydfme
Contributor
nielsgerrits
VIP
nielsgerrits
asked in General
AutoDesk dwg schema reading performance.

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.

350
daveatsafe
Safer
izabreton
Contributor
izabretonContributor
asked in General
Generate attributes per feature type table dynamically

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

2830
boydfme
Contributor

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,396
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.