- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20226 Posts

Recently active

Most views Most replies

gisrewards

asked in Transformers

Converting AGS file to Standard Format

Hi all, I am trying to convert a AGS File to a standard format to view such as Excel or Shape. I seen something like this online using leapfrog https://www.youtube.com/watch?v=OtyrYsx9teE but struggling to find a simple solution in doing this with FME. Any useful tips would be great.

532

7 months ago

raaijennielsParticipant

asked in Data

Help reading attributes from multiple dwg. files

Hi there,I am fairly new to FME. I have around 6000 dwg. files regarding the same industrial drawings and the data is roughly found in the same place in each file. I would like to know how i can extract the attributes that i need out of these files.I have started using a wildcard function to read multiple files. I know this question is fairly vague, still I was wondering if anyone has the time to help me with this, or knows any recomendations for explanation (youtube or similair examples/workspaces) Like I said, FME is still pretty new to me so any advice would help. Thank you

421

7 months ago

siguseider56Contributor

asked in Transformers

SQLExecutor Not Inserting All Rows

I have a SQLExecutor that inserts data child records for contract IDs. It does fine if it’s a one-to-one but if it’s one contract ID with many children, it only inserts one. Nowhere in my workbench does it group by the contract ID though. If there are 2 contracts and each has 2 children, there are 4 individual rows of data to insert. I managed to resolve the issue by adding a select statement after the insert to produce a result. I don’t understand why it’s behaving this way though. Note that I’m using a SQL Executor instead of a writer because of the need to set the audit user for each insert. Below is the sql statement I’m using. Why does the select statement at the end make it work? FME_SQL_DELIMITER |EXEC sp_set_session_context 'AuditUser', 'SNOW Sync' |INSERT INTO CONTRACT_ASSOCIATE (CONTRACT_ASSOCIATE_ID, BA_ID, CONTRACT_ID, CONTRACT_ROLE_ID)SELECT @Value(CA_ID), '@Value(BA_ID)', @Value(CONTRACT_ID), @Value(CA_ROLE)WHERE NOT EXISTS (SELECT 1 FROM CONTRACT_ASSOCIATE WHERE CONTRAC

160

7 months ago

dallas2011Contributor

asked in Transformers

Calculation of IRI by integration for a colliding surface

How to calculate the IRI between two points in FME if we know the distance and the slope?Thank you.

423

7 months ago

swachContributor

asked in Deployment

How to control FME Flow distributed engines

I have finished a fresh install of FME Flow 2023 with a core machine and a distributed engine machine. The distributed engines show up on the web interface but I can’t control them. I can’t tell it how many of them to start (or stop). What additional configuration do I need to do?

Unable to load a library in the folder: C:\\Program Files\\ArcGIS\\Pro\\bin. The error number returned from GetLastError is: 126

After upgrading to ArcGIS Pro 3.0.3 i get the above error when writing to an Esri Geodatabase (File Geodb). Does anyone know what the reason could be? I've also upgraded to FME 2022.2. Thanks in advance!

1986

7 months ago

ottadini

asked in Transformers

Is there a way to use a python virtual environment?

In FME 2018, I want to use a custom python interpreter, and a specific python virtual environment (conda environments).How can I do this?

1769

7 months ago

lsugumarContributor

asked in Transformers

Convert Excel to pdf

Hi! I am trying to convert an excel spread sheet (no spatial data involved, just plain data) into a pdf file with pagination based on a field in the spread sheet. Can somebody help me through the steps of this conversion? I have seen posts about using table adder, text adder, pdf styler, pdf page formatter etc. but I am trying to understand the high-level steps to start developing this process.I was hoping SAFE would have some webinar or tutorial on simple excel to pdf conversion, all I can find is extracting data from pdf and converting to excel.Any help is much appreciated.Thank you,LSugumar.

1171

7 months ago

filipovitzContributor

asked in Transformers

Custom HTML automatic value addition

351

7 months ago

od10Contributor

asked in Automation

Upload Cesium 3D Tiles through Cesium API

Has anyone managed to upload a ZIP file of Cesium 3D Tiles into Cesium Ion through its API? I can upload a CityGML through the CesiumIonConnector but want to try writing Cesium 3D Tiles and uploading the ZIP file. Thanks

892

7 months ago

virtualcitymattEvangelist

asked in Architecture

404 not found from jobsubmitterservice

I’m trying to debug an issue with the Job Submitter Service (I haven't actually tried any of the other services) .I have a process which runs fine from the FME Server UI (FME Server 2021). I can fill in the parameters (also upload an input file) etc. The jobs runs.If instead I try and run this using the jobsubmitter service via REST call - e.g., http://Host/fmejobsubmitter/Repository/workspace.fmw?parametersThe response is a 404. What is interesting to me is that I’m able to use the URL without the parameters and get back a proper response - that is for example: http://Host/fmejobsubmitter/Repository/workspace.fmw. It seeeeems like the issue is somehow related to the input file, however, in that case I would expect the job to fail rather than return a 404. so to me it seems like there is a problem actually submitting the jobI’ve checked permissions and the user definitely has access to the repository where the workspace is, and in my testing removing the permissions returns a 401 ERROR

502

7 months ago

benvkContributor

asked in Integration

Failed to submit job. Error: 404

Hey, I have FME Server running great, my workbenches are running fine on schedules etc. I have several that are 'job submitters', and I am now trying to use the mobile app to trigger them manually, each time I connect to my server, navigate to my Repository and open the workbench, I click "Run Workspace" and I am immediately thrown an error: Failed to submit job. Error: 404 I am not finding any help articles etc, has anyone seen this issue before?

463

7 months ago

alisonsepContributor

asked in Data

AGOL writer-is there a limit?

Hi, I have one Form workspace that writes to a hosted feature service on AGOL fine. It is set at insert and Truncate. It writes a little more than 9,000 features and I run it every week without issue. However, I now have a different hosted feature service on AGOL that has +23,000 features. When I try the same process to update it, it drops all the data and only ends up writing out 15,000 records at most. The number of records diffs as well. I have tried adjusting the timeout and features per request, but have not been successful in achieving the full write out. Any suggestions would be appreciated.

946

7 months ago

filipovitzContributor

asked in Transformers

List of special characters in Text Editor

Hi, I'm looking for a list of special characters used in a text editor. Is there a description of their function? Are there any others available that are not listed in the window? For example, I use the MSWordStyler transformerThanksFilip

1925

7 months ago

fme_hansContributor

asked in General

Esri Geodatabase (ArcSDE geodb) readers gives an error only on FME server. (The item does not have a definition.)

Hi, With FME I want to read a sde geodatabase. (feature class). For this I use the reader: “Esri Geodatabase (ArcSDE geodb)”. Until recently this worked. With ArcGis Pro an Attribute rule has been created for 1 field and since then the reader no longer works if the workspace is on FME server. If the workspace is run in FME desktop (not FME server) the reader will still work properly. The message I get when the workspace is running on FME server is: An error occurred while attempting to open the table, feature class or relationship class 'My_TABLE'. The error number from ArcObjects is: '-2147211773'. The error message from ArcObjects is: {The item does not have a definition.} What could be the cause of this. FME server and FME Desktop are the same version. Greatings, Hans

2154

7 months ago

todd_davisSupporter

asked in Security

Moving user data between Active Directory (AD) to Azure Active Directory (AAD or ME-ID) in bulk

Hi,I have a basic outline of how I would do this with FME Rest API, but wondering if anyone else has done it already in a comprehensive fashion, or whether Safe may have already created something for it? @siennaatsafe We are moving from Active Directory to Azure Active Directory (new name: Entra ID) in FME Flow. I just need to be able to move all user content and roles to a new AAD (new name: ME-ID) user.For instance:group: FME from AD already exists, but I am going to import group: FME from AAD and then switch all the content and role capabilities for all the underlying users. Happy to take anyone's learnings as well, just to ensure we don’t overlook anything? Cheers,Todd

701

7 months ago

fmelizardContributor

asked in GIS-StackExchange Alerts

Problem to insert features into PostGis table with FME

GIS (StackExchange) user ennine just made a new post with the tags: qgis, postgis, fme-form.Would you like to know more? Click here to find out more details!StackExchange content licensed as: CC BY-SA 4.0

240

7 months ago

missp29Contributor

asked in Architecture

Can I still run a workspace in command line on a separate distributed machine when the FME Flow Core server down?

Hi All,I am new to FME Flow. We are installing FME Flow 2023.1. We are setting up a two-tier distributed FME Flow environment with a machine which hosts FME Flow Core and Web server, and two separate distributed machines where the workspaces will be executed within the same network. Let’s say I have an automated scheduled job which supposed to run at one of distributed machine at a certain time. For some reasons, the FME Flow Core machine is down at the time when the scheduled job supposed to run. When the FME Flow Core machine down, is the scheduled job still able to start to run at the scheduled time automatically? If not, am I able to start the job manually on the command line on the distributed machine without the FME Flow Core machine available?Your help is great appreciated. Thanks, -John

903

7 months ago

alejacdContributor

asked in Transformers

Count if event occurred consecutively

Hello,I have some data which shows if an event occured per month. Events 202301 202302 202303 202304 202305 202306 a 1 1 0 0 1 1 b 1 1 1 1 0 0 c 0 0 0 1 1 1 d 1 0 1 0 1 0 I want to count the events which occurred 3 or more times consecutively. So I want to get thisEvents More than 3 consecutive events? count b yes 4 c yes 3 Not sure how I should do this in FME. Can someone help me?Thank you!

FME SharePoint Online Connector - site not showing in site list within transformer

Our goal is to write files on Sharepoint. Therefore, we used the Sharepoint Online Connector transformer, whereat the connection to Sharepoint works fine, but we currently have the following issue: The specific site we want to connect to does not show in the sites list within the transformer. We already checked the rights, but everything looks correct. What are the preconditions that a specific site is listed in the site list and can be used by the Sharepoint Online Connector transformer?

1154

7 months ago

jinseokContributor

asked in Data

Issue of visualization failure after data conversion (obj to citygml /obj)

We have tried to export(write) an obj 3D building file to dae / citygml / slpk file formats, and all three of the conversions were successful.However, only the dae format was successfully visualized in a viewer, and citygml/slpk failed to visualize with the viewer that supports the formats.Could you give some advice for this issue?CASE1 - obj to citygml (failed to visualize)input 1784_OBJ.zip output 1784_CityGML.zip output import view capture (KITModelViewer) No geometry information, only attribute information can be verified CASE2 - obj to slpk (failed to visualize)input 1784_OBJ.zip output 1784_slpk.zip FME Capture output import view capture (ArcGIS Pro)

1243

7 months ago

mgg_becaContributor

asked in Transformers

Filter Point Cloud above/below a TIN surface

Hi there, If I have been given a TIN and a point cloud, how can I find out which points are above the surface and which are below, without rasterizing the surface to retain maximum surface fidelity.Thanks,Marc

563

7 months ago

787dContributor

asked in Transformers

Vertical coordinate system

Hello,I am trying to transform a point cloud with ellipsoidal heights into orthomethic heights (DHHN2016) using the CsmapReprojector. The settings can be seen in the image. For the Geoid Height Grid I need a file in .gdc format. My target system is DHHN2016, for which I have the quasigeoid in various file formats (e.g. JPG, TIFF, GEM, TXT, GSF, GFF, GGF) but not in .gdc. Is there a website from which I can download the appropriate format or another way?Thank you very much.Translated with DeepL.com (free version)

281

7 months ago

james_c_452Supporter

asked in Authoring

DGN V8 writer not writing global display levels properly

Hi,I have a process that writes out a dgn. Some of the levels in it are required to have their global display turned off and others are on, in the initial state. Basically some levels are hidden on opening a file. I used a feature writer to do this with one stream having their global display set to on and another to off. This worked a treat.Until recently when my company upgraded to 2023(.2.1) from 2022. I haven’t changed anything but now everything writes as turned on even though some is set to be hidden. I did not see that this is a bug that was fixed in future versions from the changelogs.Does anyone have any hints for me how to get this working again please? Or have I lost the functionality now?ThanksJames

Write an IFC in Postgres with Postgis extension

Hello, I have an IFC file I wish to import in Postgres(PostGIS extension) to go through spatial analysis. Oriinally, what I did was to convert the IFC to a 3DGIS compatible format (GML) and import it in Postgreswhich was successful. Exploring a little more, I saw that Postgres supports the solid geometry type of FME and I performed the same conversion, without converting the geometries to b-rep. This photo shows the input in Postgres and this photo shows the output when I am reading it from Postgres. The highlighted part is visualised differently. I couldn't help but wonder the reason why.Could you please help me figuring this out?Thank you, George

1435

7 months ago

Page 48 / 810

Badge winners

gosiahas earned the badge FME Flow Authoring Training
dinhomourahas earned the badge FME Form Basic Training
ishithamhas earned the badge Welcome Back
mohamad22has earned the badge Welcome Back
yputhealyhas earned the badge FME Form Basic Training

Show all badges

30,162: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.