- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
General

General

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

4,033 Posts
13,789 Replies

When you subscribe we will email you when there is a new topic in this category

4033 Posts

Recently active

Most replies Most views Newest first

david_Contributor

asked in General

How can I read only cell A1 of an excel file?

I am trying to read cell A1 from an Excel file but FME Desktop seems to have a problem with that cell for any Excel. Example 1 (fail): Example 2 (success with other cell): What is happening with cell A1? Why can't I read it like the rest of the cells? Any help would be appreciated! Thank you!

I am not able to read ArcFM ArcSDE data in 64-bit FME

I have 64-bit FME installed and want to read ArcFM'ised ArcSDE data. I have ArcGIS Pro v2.8 on the same machine and 64-bit Oracle client as well. I was able to generate the .SDE connection file in Pro. However using the same .SDE file, I am not able to view the feature classes in FME. I am constantly getting the following error message "Could not open Enterprise Geodatabase. The error number from ArcObjects is -2147216072. The error message from ArcObjects is {Underlying DBMS error[Unknown error No extended error.]}" We also have ArcFm ObjectReader for ArcGIS Desktop 10.6.1a installed as well. What could be the possible reason ?

FME server update and configuration on server.

Hi Support team, Could you please provide temporary license to test the FME server V2022. So that we can tell user to run jobs on FME server for testing purpose. Please provide if you have any manual instruction and document for FME server update and configuration on new server.

1 year ago

embee

asked in General

Hello everyone, I am doing the geocoder exercise and keep getting this warning(see below). Any help would be greatly appreciated!

DEBUG: urllib3.connectionpool Retrying (Retry(total=7, connect=2, read=2, redirect=None, status=2)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1129)'))': /?format=json&q=Willow+Street%2C+Vancouver%2C+British+Columbia%2C+V5Z

611

1 year ago

gislinchuxianContributor

asked in General

Can machine B be like machine A to read gdb?

Hello FMEs, I wanna know how I can switch the license call variable.Can machine B be like machine A to read gdb? 1）Both have ArcMap 10.2.2 and ArcGIS Proin machine A & machine B2）machine A has FME x64 but can read gdbcurrently.3）machine B also has FME x64 but can not read the same gdb

1 year ago

bertila

asked in General

We are experiencing FME server not processing jobs intermittently. Once it stops taking job requests, we have to restart the FME server services for it to start taking job requests again. What could be causing FME server to stop processing jobs?

171

1 year ago

djmcdermottContributor

asked in General

Workbench Documentation: Best Practice Template

Hello,We are slowly getting new users into using FME and building a catalogue of production level FME Workbenches . As a result, we need to start properly documenting them beyond bookmarks and annotations. I am looking for a template, advice or best practice. Things like description, reader/writers, data sources, FME Server components. Many Thanks, David

2017

1 year ago

scarterContributor

asked in General

Creating lines from (possible) WKD strings

Hello Group, I'm wanting to see if I can can create lines from what may be well known binary (WKB) strings (e.g.: 0xE61000000114297C137101D7B2BFE65D8A76C0BF494030842DCBFFD3B2BF70EC7899C0BF4940). To be honest I'm not 100% certain that they are WKB. I have a csv containing these potential WKB values. The workspace is... Creator>FeatureReader (reads in the csv setting the field called 'sp_geography', which contains the WKB value to varchar>GeometryReplacer (with encoding as OGC Well Known Binary and the geometry source set to 'sp_geography'). When I run it all 171 records goi to the Rejected port. There's a curious blue message in the log: "Invalid WKB encountered.... Last line repeated 170 times ..." This is odd as the WKD values in the csv are, as far as I can see, all unique.

HTMLReportGenerator HTML Coding

HiSee attached my e-mail report generated by Emailer & HTMLReportGenerator.How can I modify the layout/appearance under HTMLReportGenerator. Tried to look for custom HTML coding under HTMLReportGenerator but couldn't find it. Please kindly provide instructions. Thx.

2317

1 year ago

arnold_bijlsmaEnthusiast

asked in General

FME2022, ArcGIS Pro 2.9.5, A compatible ArcGIS application not found

I have read pretty much all the articles on getting arcpy working on FME, but somehow I keep getting the message that a compatible ArcGIS application could not be found. I have FME 2022.1 installed. ArcGIS Pro v2.9.5, which ships with Python 3.7. In the Navigator, Esri ArcGIS Compatibility is set to Esri ArcGIS Pro, and Python Compatibility to Esri ArcGIS Python 3.7+In the Options, Preferred Python Interpreter is set to Esri ArcGIS Python 3.7+. I also tried C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\python37.dll I have a 1-line Startup Python script: import os, but it still keeps giving me the same error: "ERROR : A compatible ArcGIS application could not be found or is not licensed for Python Compatibility 'Esri ArcGIS Python 3.7+'The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.7+', which requires an appropriate version of ArcGIS Pro or ArcGIS Server. ...Program Terminating Notes:I also have ArcGIS Desktop 10.8.1 with 64-

Is this a bug in the testfilter?

Hi Guys, I have a strange error when i running an testfilter transformer.When I want to pass data through the test filter, then set it to "No" and all other must be filtered. The Test filer give an output as you could see on the pictures. Also i'm seeing chinese characters......is this a bug?Before testfilter..... Same feature after testfilter...

About the difference of column values initially and count of same column values after filtering.

Hello all,I would like to know about the difference between the count of values of one column initially while reading and count of values of the same column after filtering. If difference between the count of values is same then we will send an email. so how can we achieve this in fme

1 year ago

a_afiaaxParticipant

asked in General

Issue with FME Server 2022 Excel Writer Output Splitting Data into Multiple Files.

Dear members of the FME community, I am currently facing an issue with my FME workbench 2020, which is running on FME Server 2020. The workbench includes an Excel Writer (latest version) that fans out data into multiple sheets within a single Excel file. This process has been functioning well on a weekly basis for the past two years on FME Server 2020. However, when I attempted to run the same workbench on FME Server 2022, the output was split into two Excel files instead of one, with the data divided between them. Additionally, the file naming convention in FME Server 2022 has changed, with the file name split into two halves, one for each file. For example, in FME Server 2020, the correct file name for the output would be "20230101_filename.xlsx." However, on FME Server 2022, the file name has been split into two parts, resulting in two separate files named "20230101_.xlsx" and "20230101_filename.xlsx." I would greatly appreciate any suggestions or poten

Hello everybody I want to know is there a way to convert my 3D shapefile to a 3d tiles cesium ( I don't know if I should transformt it to citygml then 3d tiles cesium) and if there is a way is there a workspace to do so. Here is my shapefile

811

1 year ago

wisegisContributor

asked in General

Are there users that can show an example using ggplot in FME Server?

I have a workbench script that makes multiple ggplots (graphs) for end-user reports. The Rcaller works great in FME Server without error, but it will not export the plots. The output excel files export, but not the plots.

3213

1 year ago

aresContributor

asked in General

How to merge a list of attributes based on just the attribute name

I would like to combine 2 datasets: one containing about 500 monument_id's and one with about 20 types with scores and remark fields that should be added to this monument_ids (to create a list of about 10.000 items). As there is no attribute value to match (so FeatureJoiner or ReatureMerger doesn't work); can these somehow be combined based on predefined matching attribute names? Or what would be a good idea in this case? Thanks in advance!

bayramContributor

Hello there are vertex at equal distance (0.100) but these are unnecessary, only one vertex in 1m is enough. How can I remove the vertex in between, I looked for vertex remover, but I think I am doing something wrong, can you help me please? Additional information: There are always 10 vertexes in 1m.

FME server 2022.1.1 (22623) & Arc Pro 3.0.0 & ESRI python 3.9 compatibility error

I'm trying to run a python shutdown script and get this error - "The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.9', which requires an appropriate version of ArcGIS Pro or ArcGIS Server" I've also tried calling the script from cmd line and get this in the engine log - "Thu-19-Jan-2023 10:02:35.348 AM INFORM Thread-1100 WP301_Engine6 File "createaprx.py", line 9, in <module>Thu-19-Jan-2023 10:02:35.348 AM INFORM Thread-1100 WP301_Engine6 import arcpyThu-19-Jan-2023 10:02:35.348 AM INFORM Thread-1100 WP301_Engine6 File "C:\\Program Files\\ArcGIS\\Pro\\Resources\\ArcPy\\arcpy\\__init__.py", line 77, in <module>Thu-19-Jan-2023 10:02:35.348 AM INFORM Thread-1100 WP301_Engine6 from arcpy.geoprocessing import gpThu-19-Jan-2023 10:02:35.348 AM INFORM Thread-1100 WP301_Engine6 File "C:\\Program Files\\ArcGIS\\Pro\\Resources\\ArcPy\\arcpy\\geoprocessing\\__init__.py", line 14,

Hi, how come i got Status as successfull but actually there is no records of 2 readers. my goal is create an email to users to let they know if job was either success or failed. ( i have log file in attached). I this case is failed, what i would to d

1 year ago

solene01Contributor

asked in General

is it possible to change the name of a column in a shape?

I am new to fme, I set up a processing chain to compare two shape files and I would like the output file which will be a renamed shape of the columns.for Example the file checked I have a column called depth_1 I would like the export ca to be depth_upstream.is this possible in fme ?

How to calculate the last day of previous month in FME?

Hi guys, I am fairly new in FME but have been working in a workflow and got stuck on something that might be simple solution for some of you. I need to be able of calculating the last calendar day of previous month from today's date. So today being 21/02/2023 my result should be 31/01/2023. Can you please advise how I can do this ? I have been really struggling to do this and have attempted DateTime Calculator transformer.

1932

1 year ago

fme_hansContributor

asked in General

How can I give 3d polygons the height of a ground plane?

Hi, How can I give 3d polygons the height of a base. The ground plane I created with the PointCloudSurfaceBuilder. The 3d Polygons have a z-axis with a value of 0.See the image, the polygons lie above the base and disappear below it.

1 year ago

louielou1234Participant

asked in General

sharepoint (file-overwrite) lock?

Hi There, So I am using the: safe.microsoft-sharepoint.SharePointOnlineConnector to download and create .xlsx files in my organization's SharePoint site-- and this transformer is awesome save for one fatal problem...the problem is that the connector only appears to be able to Download or Upload/Overwrite files--but it can not Update existing documents at SharePoint. And the problem is that if a user has the .xlsx document open (in a browser session) the Upload will terminate / fail until all users have closed out of their browser sessions viewing the document. My question: is there a way to Update documents at SharePoint that are being viewed, or is Overwriting the only option. And if the latter is the case, is there a way to terminate all open user sessions of the document at Sharepoint so that the new version can overwrite the old version...Otherwise this transformer, great as it is, is somewhat useless. Any thoughts on this issue, or is it just another "Curse you Bill&q

log file text line data -- Separate columns

how can I separate the data into separate columns? E.gDate Information result 2023-02-20 07:24:00 inform Current FME version: FME 2022.2.0.0 (2022110)

1 year ago

kyle_rContributor

asked in General

How can I create distance markers along a road/highway line feature at a regular interval and apply the correct distance along the line to each point?

I am trying to automate creation of highway markers along a highway line feature class. I have been able to create the points along the highways at the correct interval (Using the DistanceMarker transformer) but I can't figure out how to apply the correct distance along that line (in Kms) to the newly created points. Ie. 2km, 4km, 6km, etc. in an attribute for the new point features.

795

1 year ago

Page 38 / 162

Badge winners

knutoshas earned the badge Integrate Spatial Data
mcseamushas earned the badge Conversationalist
mcseamushas earned the badge Teacher (Grey)
tiztrainhas earned the badge Expert (Grey)
arunkumarkchas earned the badge Integrate Spatial Data

Show all badges

30,160: 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.