- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27668 Posts

andrewj74Supporter

Hi i am trying to read lots of excel using the feature reader transformer, passing in the locations form a directory path reader. all the excel have different tab names but the data always start on row 10. As the dataset is a file path the option for telling it to start on row 10 are blanked out. anyone know how i get around this?Many thanks,Andy

Excel Writer: Failed to refresh Pivot Tables and recalculate formulas.

We recently downloaded the 2021.1 version of FME. All previous scripts run on 2020.1 without problems. Now however, I get a warning message "Excel Writer: Failed to refresh Pivot Tables and recalculate formulas. Note this is only possible on Windows with Excel installed" when exporting to an excel with the use of a template. I write my data in 1 tab, and that tab is used to make a pivot table in another tab. Because of this warning, the excels in my dataflow I have stay open and after 20-ish files the memory in my task manager is full, so the translation fails. We did not change the version of Excel, that should not be the problem. Anyone an idea what could be the problem?

Token not being renewed on ArcGIS Portal Feature Service Writer

@We have 2020.1 Desktop/Server and are writing to an ESRI ArcGIS Portal Feature Service. It successfully reads and writes using the configured web connection based on the ArcGIS Portal (Template). Unlike ArcGIS Online, the writer doesn't seem to update@ the token and I have to go into the web connection settings and re-authenticate manually. We are connecting to a 10.7.1 Portal and it happens in both FME Desktop and Server. Our 10.7.1 Portal is currently only operating from 7am to 7pm and restarts nightly (Dev environment). I've noticed in the workbenches connecting to AGOL, that the token in updated automatically. But that doesn't appear to be happening in the Portal writer. Is it something I'm doing? Or is it the nightly restarts of Portal? Thanks

IFC: write class IfcZone

Currently I am working on writing to an IFC-file. One of the classes I would like to write is IfcZone. However, when I try to do that, I get the warning: IFC: Unable to write objects of type 'IfcZone'Now I am wondering whether I did something wrong and I am missing some settings or whether FME does not (yet) support writing to IfcZone?@DaveAtSafe

506

6 months ago

vimva679Supporter

asked in Transformers

Error in PDF Writer name HOW to get it right ?

I am trying to write PDF file using PDF writer, when I add @Value(Scan_Location) in fanout dataset it creates 2 different files as output. And that is not what i want . I just want this name ….20240621 NI2-HK-L03 As-built_PDMS Comparison Report F1.pdf and just one file

10822

6 months ago

julian_talaContributor

asked in Data

I need a bucle? Yes, I think so.

Good morning everyone.I am working with a text type file that I take as an example for cadastral constructions.This text file has a specific structure but a variable number of lines depending on the number of heights of the buildings and the number of premises in each height.I use the file to:Know the name of the floor, for example “Basement”, “Floor 00”, “Floor 1”, etc. Know the number of heights it represents, that is, I do not have to draw floor 02 if it is the same as floor 01.This plant name and the number of heights it represents are related to a DXF file that I am not using at the moment.The first line that I need to read in any file is 27 where the number of heights of the building is expressed, this line number is fixed; and for each of the plants I find the following structure. “23” (Number of total heights of the building” (line 27 of the file)“01” (Number of heights that the drawing represents) (line 28 of the file)“SOTANO -2” (Floor name) (line 29 of the file)“95” (Number

615

6 months ago

s.jagerEnthusiast

asked in Data

JSON: extract object key as attribute value

Hi all,I am trying to read a json file, that contains a collection of objects. It is NOT an array, and the objects have no name, they have just a number. It’s that number I am interested in, but I can’t seem to find a way to get it exposed. My Json looks like this:{ "1": { "name": "msg_status", "data": { <snip> }, "port": 4, "timestamp": 1717497996, "timestamp_parsed": "2024-06-04 12:46:36" }, "2": { "name": "msg_ublox_location", "data": { <snip> }, "port": 2, "timestamp": 1717498735, "timestamp_parsed": "2024-06-04 12:58:55" }, "3": { "name": "msg_ublox_location_short", "data": { <snip> }, "port": 13, "timestamp": 1717498741, "timestamp_parsed": "2024-06-04 12:59:01" }, "4": { "name": "msg_ublox_location", "data": { <snip> }, "port": 2, "timestamp": 1717499651, "timestamp_parsed": "2024-06-04 13:14:11" }}and so on, for a couple of thousand objects per file. The d

1204

6 months ago

kwellerContributor

asked in Authoring

ACAD writer ignoring viewport center attributes

So I have a workspace that reads a DWG, and writes another one after setting viewport attributes according to this article: https://support.safe.com/hc/en-us/articles/25407658483341-Working-with-AutoCAD-LayoutsHowever, even though I’ve set autocad_viewport_view_center_x, autocad_viewport_view_center_y, autocad_viewport_center_point_x and autocad_viewport_center_point_y to display the view at the center of the page, I keep getting the viewport centered at 0, 0 in paper space, so my viewport content is centered close to the lower left corner of the page on output. I have quintuple-checked that all the required viewport attributes are set correctly. It seems like the writer is simply ignoring my viewport center settings.I’ve been banging on this for more than a day now, and have made no headway against it. Hopefully some kind soul out there will have an idea of what could be going wrong.The layout pageThe viewport, 1st page of attributesThe viewport, 2nd papge of attributes + geometry

241

6 months ago

achambersContributor

asked in Authoring

Geodatabase SDE connection not working in FME, fine in ArcPro

I have an SDE file I created in ArcPro that works in ArcPro, but whenever I try to add it as a reader in FME (Data Interoperability, ArcPro version 3.2.1) I get a simple error of “MULTI_READER reader: GEODATABASE_SDE reader: An unknown expectation occurred.I tested other SDE connections and they work fine in FME and ArcPro. I have tried generating a new SDE file and connecting with an embedded connection and an database connection in FME. Any other ideas on how to get this connection working? Also, it was working until this past weekend. This is a new issue we have not had before.

522

6 months ago

lvv.gisContributor

asked in Data

SDE & SQL Connection Issue

I’m unable to establish a connection to SDE after recently receiving a permanent license file from Safe. I’ve tried connecting using several methods: connection files stored in 'C:\Users\AppData\Roaming\Esri\Desktop10.8\ArcCatalog\’, connection file stored on a network directory; and typing in the database credentials. I was able to successfully use the same connection files while using the temporary license file provided and am not aware of any other changes in our IT environment. I’ve also tried (unsuccessfully) to connect to other SQL databases in our Data Warehouse (outside the GIS environment) that contain tabular data and receive the same error message (shown in red below) which appears after selecting the ‘...’ under “Tables” in the Esri Geodatabase (ArcSDE Geodb) Parameters dialog box that normally opens the list of feature classes/tables that can be added to the workspace.‘Failed to retrieve feature types. An error occurred while attempting to retrieve the connection paramet

1268

6 months ago

ravibansalContributor

asked in Data

Not able to see more than 100 records in visual preview table

In FME 2024, i have feature caching enabled but when I run the workspace, I cannot see more than 100 records at any transformer in the workspace. And if I try to sort them in asc or desc order by clicking on any column, nothing is displayed.

How to implement XLink:href for referencing geometries (spaces and space boundaries) in CityGML 3.0?

I want to implement referencing geometries of spaces and space boundaries using XLink:href. I found this solution (https://hub.safe.com/publishers/con-terra/templates/citygml-create-building-lod-2-using-xlinks). This solution works very well for CityGML 2, but I couldn't implement it for CityGML 3.0 using the GML writer. I changed the transformers and tried different approaches (considering the "boundary" relation in CityGML 3.0), none of them worked! I will appreciate any help and suggestion 🙂

1082

6 months ago

michiedemContributor

asked in Transformers

Networkcostcalutor: I'm doing something wrong with the network preparation

I am trying some network analisys (isochrones and route/gpx creation) and I am obviously doing something wrong, I just can't figure out what.I am using OSM highways, unfiltered (I also tried a local route network, same result). The only manipulation I did is convert it to espg 28992RDnew (because it's in meters) before using it as an input for the topologybuilder (also tried topology calculator). Since I have multiple start points I created a road network Per stop_id and used ‘group by’ on the topologybuilder and networkcostcalculator. The results are very weird. Connected and (way too many) not connected seem random: (green = connected, red = not connected) Zoomed in:I tried pretty much all settings on the networkcostacalculator. When I try the shortestpathfinder it's also clear that something is off, it refuses to use some (random) paths/roads/lines. So it's obvious I am doing something wrong, I just cannot figure out what.

1378

6 months ago

chaitanyamallaContributor

asked in Authoring

.jpg .jgw with different coordinate system to Geotiff

Hallo FME community, I am new to this FME software and got a task. I have 100 city folders with single .jpg and .jgw file inside each folders. .jgw has x and y coordinates of a reference system. Can anyone tell me workflow with necessary transformers to select each jpg with their .jgw and create their own destination folder and save the Geotiffs in individual folders.

1424

6 months ago

liamfezInfluencer

asked in Transformers

Linked Custom Transformer Data Path Performance

Does anyone know if there would be a performance difference between having linked transformers stored on a shared external drive compared to a local drive?I do not have much experience with linked custom transformers yet, but my current understanding is that there may be slightly longer load times when opening the workspace using the linked transformer, however no performance decrease in translation. Would this be correct?

361

6 months ago

tcrossmanContributor

asked in General

What geodatabase version does a FeatureWriter in FME 2023.2 produce when the version parameter is set to "Current?"

I am running FME 2023.2 and have a dynamic workspace that is creating a File Geodatabase (FGDB) with a FeatureWriter, and I am running against ArcGIS Pro 3.2. Recently, I have wanted to access some annotation class properties in that GDB, but I find that I cannot access them. ArcGIS Pro says that the FGDB is version 10.0 and that I need to upgrade the FGDB to the latest version to activate those properties. I looked at the log for the last run that built the FGDB, and I see "Created and connected to the ArcGIS 10.0 File Geodatabase at '[Location]\\template_General_Prod.gdb'" I checked the FeatureReader geodatabase version parameter, and it is set to "Current." So, ArcGIS Pro is telling me that there is a later FGDB version than 10.0, while FME, though set to "Current," is creating a 10.0 version FGDB. I am confused. Can FME only create a maximum 10.0 FGDB version, or is there actually no later FGDB version ... or is something else going on?

869

6 months ago

larueContributor

asked in Authoring

Dwg file Errors using RealDWG Reader, but not AutoCad Dwg/Dxf Reader

I am working on a process to read in dwg files, parse the text and assign metadata attributes. I have one file that I am using that had missing xrefs. Using RealDwg Reader, it worked fine. But, when I bound the xrefs, it gave me the following error after reading in most of the file: AutoCAD Reader: An error occurred for dataset '<filepath>\FIRESPRINKLER.dwg', in function RealDWGReader::processDimBlockCommon: 'eNullObjectId' I purged and also made a .dxf file, but still got the error. I am using FME 2023.2.4Using the regular AutoCAD dwg/dxf Reader, it worked no problem. I suspect there is some entity in the CAD file that the RealDwg Reader did not like, but after multiple purges and audits, I can’t find anything to delete. If I am going to publish this Workspace, I need to know if there are things to look for that would help choose the correct reader. The file is in AutoCAD version 2018.Questions: Is this error related to a specific function in RealDwg Reader, or is it just

1073

6 months ago

tara_heContributor

asked in Data

Writing to MBTILES format doesn't inherit transparency

I’m trying to upload a raster to Mapbox, but no matter what I do, the output file always turns the nodata cells to black. I have tried fixing this using RasterBandNodataSetter and RasterPaletteResolver. If I look at the feature cached output from those transformers the nodata cells are still transparent. The issue arises when I use the MBTILES writer. No matter what, it writes nodata as black. I also tried removing the nodata (RasterBandNodataRemover), doesn’t work. I have tried outputting the data both as png, png8, and jpeg. Does anyone have any other suggestions? Thank you in advance!

764

6 months ago

marjan_nikoukarContributor

asked in Data

Convert Text file to CSV

Hi,I have a .add file that I just could open it as a text file in FME. Do you know anyway to read this file as CSV? Or a way to replace all spaces with one space?There are irregular spaces between them, and when I open it as a CSV, it is not a helpful file.I tried to use SrtingReplacer to replace many spaces with one space, but there are many different numbers of spaces in each attribute.Thank you for your assistance.

651

6 months ago

tschoppenhofContributor

asked in Transformers

Is the FileExistenceChecker able to recognize url-adresses?

I tried the FileExistenceChecker to check fo a online xml-document but it seems that it can not check url adresses (result -> DoesNotExist). It didn't recognize an url-Adress that the xml-Reader is able to read (See attached Test Workspace). Any Idea what the problem could be?

312

6 months ago

p.wintjes

asked in Transformers

Must be the owner to perform this operation

When reading FCL from ArcGIS sde database, also the information about the FDS in which the FCL resides is available in FME. There is no problem in writing it to another database in a FDS, even if this FDS does not exist in the target. If one would like to create the new FCL not in a FDS (in my case SQL server database) straight from the input, you will get an error creating a FDS.Geodatabase Writer: Creating feature class `ARCFMUT.FCL_BW_LOGGER' in feature dataset 'BW_intern.ARCFMUT.FDS_BW_DIVERSEN'An error occurred while attempting to create the feature class 'ARCFMUT.FCL_BW_LOGGER'. The error number from ArcObjects is: '-2147220969'. The error message from ArcObjects is: {Must be the owner to perform this operation.}After some time of investigating this issue, I concluded that the writer tries to create a FDS using the credentials of the reader, which of course did not exist in the writer, even if I explicit had left the field for a FDS to blank.My solutio

1387

6 months ago

alfonsContributor

asked in Transformers

Reading Features with Feature Reader using a list for WHERE Clause

I have two feature classes (FC) that are linked by a 1:1 relationship. Both FCs contain about 4,000,000 objects, of which I ultimately need about 20,000 objects. I understand that I could join all 4,000,000 objects, but that would take a considerable amount of time, which I want to save.My idea is to select the required objects in FC A and create a new list using the join attribute. Later, I want to use the FeatureReader and a WHERE clause query to read and process the required objects in FC B. Unfortunately, I am having a problem with the creation of the WHERE clause, so no objects are being read.My workflow is as follows:Read and select objects from FC A Prepare the join attribute for the WHERE clause (add quotes) Create the list using the join attribute Convert the list to a string with commas as separators Read the objects using FeatureReaderEverything seems to work except for the last step. If I enter the WHERE clause manually (without the list), it works. Below is my current work

1261

6 months ago

vvaldorContributor

asked in Data

Error Server codes '1003' and '1001'

FME Workbench ver. 2021.2.3, build 21812FME Server ver. 2021.2.3, build 21812Hi Everybody.Sorry for my Canadian French, I try to be correct as much as possible in English, you may notice some errors on my part.Yes, I know, we should migrate to FME Form/FME Flow. The steps have been initiated with our supplier but we must wait until the migration from ESRI ArcGIS Desktop 10.8.1 to the ESRI Enterprise 10.9.1 version is completed. Premises:We maintain data that we share on a feature service hosted on ArcGIS Online with a subcontractor (different types, SQL Server, GDB and Shapefiles); The address of the feature service must remain constant for the processing of our subcontractor; The initial creation of the feature service goes correctly (an FME Workspace process launched manually for creation; We must replicate the update autonomously on our FME Server (same version as the FME Workbench, 2023.2.3, build 21812) so that the data is up to date over a 72-hour period.The update workspace fail

1152

6 months ago

saravanakumarSupporter

asked in Integration

trigger mail when my workbench face error in fme forms?

Hi All, I would like to know thatis there any possible way to trigger mail while running my workbench in FME Desktop/ Forms if it is facing a error?.FYI : I am using FME Desktop 2020.1.1 version. Thanks in advance!

476

6 months ago

myadegaryiutacContributor

asked in Integration

_response_body is not in JSON format

HiI am using the HTTPCaller to get the information from Issues page in Autodesk Construction Cloud (ACC).The AuthorizationToken has been created and looks good but once I am using HTTPCaller to get information form issues page, the result created in “_response_body” is not in the json format so consequently I am not able to use JSON extractor Is there any step that I am missing?P.S:In “HTTPCaller4”in requested URL I used “https://developer.api.autodesk.com/docs/issues/projects/$(PID)/issues”*I have predefined $(PID) in User Parameter. In Header I used “Authorization Token” created in 1st stepThanks

1047

6 months ago

1
...
41
42
43
44
45
46
47
...
1107

Page 44 / 1107

Badge winners

sameeryukhas earned the badge Expert (Grey)
sameeryukhas earned the badge Teacher (Grey)
sameeryukhas earned the badge Student (Grey)
balkrishnagote1has earned the badge Expert (Grey)
balkrishnagote1has earned the badge Teacher (Grey)

Show all badges

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