- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27702 Posts

asked in Transformers

Is there a way to log an error when no features in input file or when feature type not exists ?

Hi, I published a workspace to the FME Server (2018) of my client that allows to import a specific sheet of an Excel file in Postgres.But when the input file has zero feature or when the specific sheet doesn't exists, the Workspace doesn't log any error and says that translation was successfull.Of course, we could open the Excel file to check the data but this workspace is running with automatic processes.Is there a way to log an error when there are no features in the input file or when the awaited feature type (Excel sheet) not exists ?Thanks for any help.

1268

1 year ago

robyn_dContributor

asked in Transformers

Is it possible to supply a field name as input parameters in the Feature Reader transformer to read in ArcGIS Online data?

I am trying to create a workbench which will read in the data from a table in an ArcGIS Online feature service, where the feature service is determined by input User Parameters at each run of the workbench. The output will be an excel export of the data from the ArcGIS Online feature service table. I have hundreds of different feature services, identifiable by a unique alphanumerical code and feature service ID. The aim is for the user to input the alphanumerical code for the data they want to export when running the workbench (e.g DA019). This code will act as a look up to a table that contains the feature service ID for the required data. I have then attempted to reconstruct the syntax of the AGOL connection as seen in an ArcGIS Online Feature Service Reader.E.g [AGOL Group Name]/[Feature Service Name]([feature service ID]) I then have passed that as a field called fsid_search into a Feature Reader under the 'Feature Service:' constraint. I've included a screenshot of my

1170

1 year ago

jules_c

asked in Transformers

How to unmelt ? (AttributeCreator ? ColumntoRow ?)

Hello everyone, I am new to FME and I would like to do automatically the task described in the photo, which is an "unmelt"s . I went and check the transformers "ColumnToRow" that did not work for me, and AttributeCreator that works but needs to add one by one every attribute "Thing1", "Thing2" ... Or maybe I missed something ?Thanks for your help !

230

1 year ago

marwa_awadContributor

asked in Data

Hi, I'm trying to convert An AutoCAD(DWG) file to Esri Geodatabase with the labels (Annotation) to attributes. How can I do that?? and also if I have the Geodatabase schema, how can i convert these labels to the attributes?

1460

1 year ago

rtreecareContributor

asked in Transformers

Attribute Manager has wrong attibute types

I am taking a feature reader (ESRI geodatabase) and putting a feature class through an attribute manager. The feature reader shows the guid fields correctly as guid.However, the attribute manager shows them guid fields as buffer.This is happening for all guid field. I've tried "reset table" and import from dataset in the attribute manager. I've also tried recreating the attribute manager. How can I fix the attribute types to be accuate?

360

1 year ago

claire.cioni

asked in Transformers

What transformer should I use to sort existing features of one attribute into specific categories (features in a new attribute)?

For example, I have a "Description" attribute, and I want to create a new attribute called "Categories". Features in the description attribute containing the word "gardening", for example, would go into the "Gardening" feature type of the new attribute.

110

1 year ago

abnan0001Supporter

asked in Transformers

Transpose and Aggegate the JSON body data extracted

Hello Experts..I need your Guidance and Help.. would like to transpose the information available in the FME template i have attached ..In attribute Keeper Transformer - I have 2 fields name JSON index and Data ..I want to JSON Index in Row as heading and Data is its corresponding Value.. I have attached workspace ..Also , I have tried to follow this Article " https://community.safe.com/s/question/0D5Dm000006Zdi5KAC/transpose-a-table"I want to transpose this and aggregate itThe results Comes in this way Kindly Support and Guide Thank You

330

1 year ago

eva218

asked in Transformers

How can I substract the strings, including column names, I need from one cell?

The data that I have is like the following: I would like to substract the information within the brackets, so I get the following result: Can anyone help me how I can achieve this within my workbench?

1 year ago

clairecoContributor

asked in General

How to remove square brackets in a json file?

HelloI am generating a json file for photographs metadata.At the start and end of the file I have an open bracket and a closed bracket. I don't want to have this square brackets in the generated json file.Thanks

5760

1 year ago

rudy_vContributor

asked in General

Microsoft System CLR for SQL Server 2012

Why is Microsoft System CLR for SQL Server 2012, still a requirement for FME to work with SQL Serve Spatial - We are on SQL Server 2019, and we have CLR 2019 and 2017 installed. Surely it should use the CLR that is installed. Without 2012 CLR installed - FME does not work.

270

1 year ago

geodata1

asked in Transformers

I try to intersect a line with 3d coordinates and a polygon with 3d coordinates. How can i calculate the intersection point (the two screenshots may help)? Are there some properties that i have to use? Thank you for help!

110

1 year ago

philippebEnthusiast

asked in General

Generate Hexagonal Grid

Hi !Any idea how to create a 2D grid with hexagons instead of squares?I would like to reproduce this tool : https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/generatetesellation.htmI tried HexBinner transformer but it works with points. So when I try with a grid of points I created, there is some holes in my grid, as you can see... Thank you !

4300

1 year ago

samuel

asked in Transformers

How to read a TIF file without taking into account the associated TFW file ?

Hi, I need to validate if the TFW file content corresponds to the associated TIF file.Therefore, I'm reading the TIF properties (with RasterPropertyExtractor) and I'm reconstructing the 6 TFW-paramaters, to compare them with the content of the TFW file.But... the problem is that the Reader reads the TIF file with the parameters coming form the TFW file. Hence, if the TFW is wrong, then the TIF properties extracted with RasterPropertyExtractor are also wrong.Is there a way to force FME to ignore the TFW file when reading a TIF ?Thank you for your help.

I want to convert a file with extension ".SFC" in FME. SFC does not seem to be included in the Reader's Format. Is there a possible way to deal with this?

The SFC (Scadec Feature Comment file) file is a format for Japanese specifications; it is used to store CAD data and is included in the SXF (Scadec data exchange format) format, a CAD data exchange standard.

1 year ago

abnan0001Supporter

asked in Data

SQLite Database - Data Extraction from HTML

I have a Data collected using Survey123 but sending data has issue and it was stored in android device only , so the format will be in sqlite database.. I want to extract the data from SQLite database and im able to read and see the data but not able take it into XML Fragmentor ..May be im doing some wrong.. I have attached screenshot and workspace ..Need Guidance and advice to fix this Thank YouNeed expert advice

628

1 year ago

alc33Contributor

asked in General

Hi ! I have a workspace with the version 2018. I would like to launch with workspacerunner with an other workspace with the version 2022. That doesn't works but maybe there is a way to make it works. Do you have an idea? Thanks !

1 year ago

jamesb16Contributor

asked in Transformers

I need to filter by date. Its a CSV: that I need to filter by both Open and Closed status. But I need to find the Closed work orders that have been closed in the last 60 days. I am using TESTER to do the filter.

1 year ago

benadei

asked in General

I keep getting a type error in my Python caller

I keep getting an error in my Python caller transformer trying to convert dates in the format '%Y%m%d' to Python 'datetime.datetime' format. The transformer works for the first 236 features and generates the following error:Python Exception <TypeError>: strptime() argument 1 must be str, not NoneTraceback (most recent call last): File "<string>", line 38, in inputTypeError: strptime() argument 1 must be str, not NoneError encountered while calling method `input'I have examined the input data and nothing seems out of place or wrong with the data. I am not sure what's causing this.

3160

1 year ago

katericondoContributor

asked in Transformers

Convert 3D Polylines from Feet to Meters

I'd like to divide my 3D polylines by 3.28084 (feet to meters) - I think I'm close with 3D Forcer, using Arithmetic Editor but it's not quite working... @ZValue()/3.28084

180

1 year ago

aaaaaronContributor

asked in Transformers

AutoCAD Map 3D write FDO connection

Is it possible to write an AutoCAD Map 3D dwg with an attached FDO connection?I have a library of predefined .layer files containing the connection prepared.

190

1 year ago

so_much_moreSupporter

asked in General

FeatureWriter have encoding issues, PostGIS writes does not

I am migrating data and are using a dynamic workflow. When I am using the PostGIS writer it run smoothly. But since i need post processing after writing to DB I sat up the FeatureWriter identical to the PG one. But the writer fail du some encoding issues on attributes with Nordic characters in their nameFeatureWriter (WriterFactory): POSTGIS writer: Internal Error: Failed to copy attribute 'FÃ˜RSTEDATAFANGSTDATO' to 'fã˜rstedatafangstdato'I cant see this being about case sensitivity since there is no issues using the regular postgis writer.Any ideas how this can be solved? Looks like a bug to me?

SAML Method of Authentication has gone from the SharePoint List Reader/Writer, in newer version of FME Desktop.

In FME Desktop 2019.2 b19825, the Microsoft SharePoint List Reader/Writer offers SAML as an authentication method for reading from our corporate SharePoint sites. This method is now absent in 2021.2 b21784 and none of the other authentication methods seem to be working for me. Why was this option removed and is there a workaround to getting FME Desktop to connect to SharePoint sites using normal SPOL credentials.

460

1 year ago

charles.addison

asked in Transformers

How to extract the extents of a point cloud?

I need a polygon or closed polyline of the extents of this data; using max and min (x,y) gives a bounding box which means further down my pipeline, data is being written to areas that should take "No Data". How can I grab extents from the point cloud to use it as a breakline? Pictured; point cloud, and point cloud overlaid raster output, showing data written outside the point cloud extents

870

1 year ago

philippebEnthusiast

asked in Transformers

Convert Excel to Image

Hi, We have tables of values with colors in Excel that we would want to integrate in a mxd.I though to export them automatically in jpeg files. It would be easier after to integrate images in mxd.How could I do that with FME? Thanks !

182

1 year ago

malikusama95

asked in Transformers

Multiple pdfs in order sequence in one booklet is possible in FME ?

i want to merge multiple pdfs in order sequence and in one booklet how i can do please help me

200

1 year ago

1
...
163
164
165
166
167
168
169
...
1109

Page 166 / 1109

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.