- - 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

charryContributor

asked in General

cesium 3d object write can add lod?

Feed Detail (safe.com) I search a question about cesium 3d lod, but The description is not clear，who have some advice?

Stop Excel & CSV from rounding data, where the number can contain a prefix 0

Hi All, I'm trying to write Bag-ids (adress ids of the Netherlands) to an Excel or CSV file. However I'm unable to write it to these formats without destroying the data. Source data example Bag_id _ 0735200000017598 1735200000017598 If I write it to CSV i'm losing the prefix 0 (while using varchar type).If I write it to Excel the numbers without the prefix 0 are rounded (while using the string type) See appendices. The only fix i'm able to come up with is prefixing everything with " ' ". But that of course transforms the source data. This I don't want. Does anyone have a solution for this? I have added my test sample in the appendix aswell (e.g. source_data_v3)

FME Desktop 2022.1 Build 22618: How to perform the “AttributePivotor”?

FME Desktop 2022.1 Build 22618: How to perform the “AttributePivotor”? I couldn’t figure out how to apply the “AttributePivotor” in order to derive the “R” table from “Q” table as per the screenshot. The data is attached

FME Desktop 2022.1: Why clicking the gear sign of a transformer gets the displayed table disappeared?

FME Desktop 2022.1: Why clicking the gear sign of a transformer gets the displayed table disappeared? I couldn’t figure out if there is a way to keep the displayed table appearing when clicking the gear sign of a transformer as per the screenshot below

2 years ago

jamal

asked in General

FME Desktop 2022.1 Build 22618: How to connect C or D drive to FME to be able to drag and drop data decently?

FME Desktop 2022.1 Build 22618: How to connect C or D drive to FME to be able to drag and drop data decently? For example, in ArcGIS Pro, there is a catalog pane from which C or D drive can be connected to be able to drag\\drop data decently. Do we have such facility in FME?

2 years ago

lairdd1989

asked in General

Connect to Windows File Server

Hello, I am trying to build a process where files are being generated on a Windows Server. I am wanting to takes these files convert them from .doc to .pdf then upload them to a SharePoint location then delete the files from their original location on the Windows server. I believe I can see to the the format conversion and SharePoint upload but am really struggling to figure out how to connect to the Windows Server which requires different permissions from my normal user account to read the files in the specific folder. What Reader/Connector should I use to be able to connect to the Windows Server to gain access to the files? Thanks

FME Desktop 2022.1 Build 22618: How to filter the content of a file geodatabase (gdb) based on its feature classes (layers),

FME Desktop 2022.1 Build 22618: How to filter the content of a file geodatabase (gdb) based on its feature classes (layers), For example, in the screenshot below, I wanted to get the two feature classes (layers) from the geodatabase but couldn’t figure out the best practice to perform this

I try to group the polygon

I am. try to group all CellValue as you can see I am getting 4881593 records so I need group them please find the workspace

2 years ago

travisk

asked in General

Is there a why to export or view the command line args without running your workbench?

I have some workbenches that take a over a hour to run and I'd like to get the command line arguments to create a batch script without having to run the workbench

2 years ago

nareshjilla8055

asked in General

How to find and filter the Alphabetic with numeric in fme highlighted with selection in below image. Please give me solution.

2 years ago

larsec

asked in General

Is ArcSDE connection files embedded

Hi everyone,I have a script with a reader that connects to an ArcGIS Enterprise database through a connection file. My question is: Is the connection file information embedded in the script itself, so if I move the script to another location, that do not necessarily have access to the connection file, will it still work? Or is there a way to make sure that my script works whether it has access to the connection file or not? Thanks 🙂

2 years ago

jamal

asked in General

FME 2022 Build22153: Calculating the value of an attribute fails,

FME 2022 Build22153: Calculating the value of an attribute fails, In the screenshot below, I wanted to calculate the “BuildingPercent” attribute field by dividing “BuildingArea” field on “BoundaryArea” field but appears not to work. It doesn’t perform the calculation. What could be the issue here? The data and the workbench are attached

146

2 years ago

vkiContributor

asked in General

FME 2022.1 Tester-Failure

We just updated to 2022.1 and now I'm getting an error when using the Tester.That's what I did:I used a Creator and created an attribute "attr1" with the value 5 in an AttributeManager.Now I add a Tester with "attr1 = 5" then I get this error: Tester (TestFactory): The clause 'TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>attr1<closeparen>,Tester) = 5 ENCODED }' within 'FACTORY_DEF * TestFactory FACTORY_NAME Tester INPUT FEATURE_TYPE AttributeManager_OUTPUT TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>attr1<closeparen>,Tester) = 5 ENCODED } BOOLEAN_OPERATOR OR COMPOSITE_TEST_EXPR <Unused> FEATURE_TABLE_SHIM_SUPPORT Yes PRESERVE_FEATURE_ORDER PER_OUTPUT_PORT OUTPUT PASSED FEATURE_TYPE Tester_PASSED OUTPUT FAILED FEATURE_TYPE Tester_FAILED' is incorrect. TEST must look like: TEST <value> <operator> <value> [ENCODED]The clause 'TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>V

Removing keyword based on the value of another column

Hi all, I am trying to remove some keywords based on the value of another column. What I am hoping to achieve: Removing Oxley & Victoria in Column A Can anyone please provide some assistance. Thanks

2 years ago

rossdognz

asked in General

How generate measure for mutlipart line geometry

Hi, Can anyone recommend a workflow to have measures generated across line multiparts with measure formed based on the order that the multiparts are stacked in the geometry. The measuregenerator is rejecting multipart line geometry items. I have valid multpart lines (roads with gaps) for which i need to run a measure across the gap (but not including the gap in the measure). If not possible using current FME transformers, could i please submit this as a feature request to enable multipart measuregenerator. With thanks.

364

2 years ago

olivierContributor

asked in General

Python sample script for accessing local GDAL library

Hi, Are GDAL raster processing tools available in QGIS also accessible from FME Desktop on the same machine? If yes, does someone have an example script of how to call and run such a tool from the GDAL library. In QGIS I would for instance use the tool itself with the following command line for generating contour polygons:gdal_contour -b 1 -p -amin minimum -amax maximum -i 50.0 -snodata -999999994.0 -f "ESRI Shapefile" <input path> <output path>How would the code need to look like for example in a PythonCaller on a typical Windows machine with both FMEDesktop and QGIS installed on it? Thank you! Best regards, Olivier

How to extract an adress from a point from X and Y coordinate?

Hi, I have a feature point with X and Y coordinates Attributs filled by using the CoordinateExtractor. I would like to know the adress of the point. So I have prepared an attribut called ADRESS. How can I extract the adress from X and Y coordinates?Thank you

372

2 years ago

charryContributor

asked in General

if desktop support red hat centos stream

if desktop support red hat centos stream? centos stop updating

2 years ago

jscottlehrContributor

asked in General

Read Folder of Shapefiles, rename Attributes and Export GDB

A Program I use can't export a GDB but can export a folder with shapefiles. The problem is the names of the attributes are truncated for shapefiles upon Export. I would like to Set a feature reader to pull all .shp from a folder I set as a parameter. Then I would like to batch rename attributes of the features. But different feature classes have different attributes that may or may not be truncated. When I export my GBD I need to set up the new schema somehow. Any Ideas?

Identify self intersecting polygons along with spikes

I have a dateset of polygons which I know includes some anomalies such as self-intersecting and spikes. I'd like to identify these and if possible count the number of instances of each type in a report. I have tried following the FME guide on self-intersecting polygons but it does not seem to be working as I expected on my dataset. I'm not sure if its my setting in the GeometryValidator transformer or my base data that is at fault. Any guidance would be much appreciated. I'll include some images of the types of issues I'd like to identify along with the workbench I created and some sample data:

2137

2 years ago

franco69Contributor

asked in General

problem with ExcelToPDFWriter

Hi I've tried to use The Excel To PDF Writer but i have problemsafter some errors about phyton stuff i have installed pywin32 and pypiwin32 https://docs.safe.com/fme/2021.0/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Installing-Python-Packages.htm fme.exe python -m pip install pywin32 --target C:\\Users\\<username>\\Documents\\FME\\Plugins\\Pythonfme.exe python -m pip install pypiwin32 --target C:\\Users\\<username>\\Documents\\FME\\Plugins\\Python fme.exe python -m pip list it was successfully but again an error message ExcelToPDFWriter_ConvertPDF (PythonFactory): Splitting bulk features into individual featuresPython Exception <ModuleNotFoundError>: No module named 'win32api'Error executing string `"""Converter from Excel (.xlsx) to PDF (.pdf).This module depends on the following modules: - pywin32To install open an elevated command prompt and enter: pip3 install <module_name>.Heijmans18-04-18Rob BraggaarCan somebody m

Draw connectors to point I have a polygon with a pole and demand points. I want to draw lines from pole point to demand points in that polygon as shown in the image. Any help please

2 years ago

tlilixmed

asked in General

i'm having difficulties using linebuild ,why does it link all points and not in single line ?

i have an excel file with a GPS coordinates that i changed into points using vertexcreatori'm tying to build a line between those 500+ points, i used linebuild but instead of one line i got a lot of emif anyone knows how to fix it please tell me !it should look like this ( same excel file just sorted by Date attribute ) :

Reading csv files from FTP

hello, i'm interested to know the usual process in reading/getting files from FTP caller.I did make FTP caller run, however, I don't know the next transformers to use to read the csv (not in a zip file) from the FTP server. I tried attribute splitter and list exploder, but didn't work. Can you share a sample workbench for the same case, please?Thanks!

1994

2 years ago

jbradforContributor

asked in General

PostGIS > SQL* - Issue with timestamptz

FME Desktop v2021.1.1.0postgresql v11.13 We have an expiration date col that we default to a hard coded high value on INSERT using a trigger and function. The value of that timestamptz col is:9999-12-31 23:59:59.000 -0600 SQLCreator or SQLExecuter will not allow the selection or reference of that column. However, I can select or reference the col in DBeaver without issues. This statement produces this error in FME:select exp_ts from test_table;POSTGIS reader: An error occurred. FME will attempt to obtain more information on the error, but this may cause the translation to be terminatedPOSTGIS reader: An error occurred. Here is the information that FME was able to find on the errorPOSTGIS reader: stk::ex::bad_expected_access Workaround was to change the col to timestamp.Any ideas?

215

2 years ago

Page 64 / 162

Badge winners

gavhas earned the badge FME Certified Trainer
metwalyhas earned the badge Arabic Speaker
metwalyhas earned the badge Integrate Data with the FME Platform Training
linds-mhas earned the badge Conversationalist
linds-mhas earned the badge Teacher (Grey)

Show all badges

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