- - Community Resources
  - Resources
  - Get Started Here10
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

7,005 Posts
25,811 Replies

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

7005 Posts

jatoxaContributor

Update AutoCAD block attribute

Hi all, I want to update certain attributes in a DWG block. To the left where it says "test" I have updated an attribute. However FME writes out duplicate blocks and the new one is also bigger than the original. Is there a way to update attributes and write the changes to a DWG without touching anything else? Thanks! /Jacob

852

3 months ago

frobertsContributor

asked in Data

Mbtiles conversion create Black tile background

I have tiff file that I have been provided when I run it through FME Workbench 2024.2 to create a mbtiles package, I get this strange black background, I assume it is the defulat tile for the area. The orginal tiff only occupies the extent of what you see in the map itself below. So the conversion is tacking on this huge black boundary. Any ideas on how I make it not do that? I have included a screen shot of my settings below. Thanks for any ideas!!

262

4 months ago

kanteyemaodoContributor

posted in Data

EXTRACTION dgn vers shp

j'ai un fichier dgn contenant les câbles de type polyligne avec leurs extrémités. -je veux extraire les câbles et les convertire en shapefile (.shp) avec les noms des extrémités.???

9811

4 months ago

fme_hansContributor

asked in Data

Allign in PDFPageFormatter

Hi,I am trying to prepare a PDF with the PDFPageFormatter. I have 6 input ports in the PDFPageFormatter and it seems impossible to align them exactly with each other. I have the same upper left x and -y for all 6, the same size. I selected them all and centered them with allign. but there is still one of the input ports that shifts slightly. How can you set this alignment correctly?The top part of the attachment is the Data Inspector. The bottom part is the PDF. The green areas have shifted.

282

4 months ago

garybContributor

asked in Data

Shape defined within template is not stored. Error

magda_czContributor

I have hundreds of json file saved to one location, they have a structure as example below: [ { "json_featuretype" : "1da87ac9-2472-42da-a80f-cba37a36cce5", "path_directory_windows" : "C:\\Magda_H\\test\\", "uuid" : "1da87ac9-2472-42da-a80f-cba37a36cce5" }] I’d like to use PythonCaller to save them to location as state under: "path_directory_windows" : "C:\\Magda_H\\test\\". Can I please ask for the help with creating a python script to run this. Thank you

IFC_API Reader should have parameters to read IfcOpeningElement and non-subtracted walls etc.

I found that Industry Foundation Classes (IFC) (Tech Preview) [IFC_API] Reader in FME 2024 cannot reader IfcOpeningElement features and non-subtracted wall, slab etc. features.In some cases it's essential to read IfcOpeningEelement features as simple solid geometries and non-subtracted features.It would be nice if the [IFC_API] reader would have parameters equivalent to the "Subtract Openging Geometries" parameter in the current Industry Foundation Class STEP/XML Files (IFC) reader.

200

4 months ago

jokerfmeContributor

asked in Data

how to reorder points ?

hello , 👋 I'm working on finding the path for specific lines and reorder points .I have several lines, each defined by a start and end point, but these lines also contain intermediate points. Should I merge the intermediate points with the lines before using a shortest path finder, or how will the transformer know which intermediate points belong to each line if I don't provide them? My goal is to reorder all points, including the intermediate ones, to find the correct sequence from point A to the final point, such as A, B, C, D, E, F, G.

Writing JPEG Image to Geodatabase

Is it possible to write an image from a jpeg url into a file geodatabase? In other words, I want to store images directly from a url into a geodatabase. I need to extract the image from the url and move that image into a geodatabase. Thank you!

2124

4 months ago

albineproSupporter

asked in Data

Feature writer - feature types order

How to securely achieve the desired order of in which are feature types (tables) written in the database? I have some FK dependecies in the target tables and I have somehow discovered that its written from the bottom to the top of the feature types list. If its not written from the parent to the childs it crashes on FK violations. I know there is an idea registered. But so far what are the options? It consider the inserts/updates and also deletes where i would need the inverse order.Thank you for the suggestions.

526

4 months ago

haziraParticipant

asked in Data

Same rows of data aren’t being saved to both writers

Hello, I’m new to FME and I’m encountering a problem where the same rows of data aren’t being saved to both writers. I have two writers connected to the same database but with different tables. When the data is processed, the one saved in the shp_db_b table and can be seen, but there’s no output for the dashboard table (Even though it said ‘Translation was SUCCESSFUL’). I think the issue might be with the Aggregator transformer, but I'm not completely sure. I've attached the relevant pictures for reference.

211

4 months ago

fme_hansContributor

asked in Data

Write to a zipped file geodatabse

Hi,I am trying to put data in a zipped file geodatabase in 4 feature tables. Only 1 table is written to the zipped file geodatabase, the rest are not. (no error message). If I write to an unzipped geodatabase file, the 4 tables in the geodatabase are written. How do I write multiple feature writes in the same zipped file geodata tables? (I have tried feature holders to put tables 1 by 1 in the zipped file geodatabase but that makes no difference).

833

4 months ago

akielyContributor

asked in Data

Writer - ESRI ArcGIS Portal Feature Service

Hi all,When I write to a newly created Feature Service on ArcGIS Enterprise, the attribute data doesnt populate, all the attribute column data is null.The shape data populates but the attibute data doesnt for the Feature Service.Has anyone come across this when writing a Feature Service to ArcGIS Enterprise using FME?ThanksAnthony

422

4 months ago

marta.podsiadSupporter

asked in Data

Convert Text to jpg

Hi, I have generated a tree in FME that looks like that (data type=buffer)How can I save it as in Excel so it looks the same? I assume the question is how to change buffer data to an image

542

4 months ago

hodsen96Contributor

asked in Data

Running into issues using TempPathnameCreator > HTTPCaller > FeatureReader

Hey all, In my previous post It was suggested to use TempPathnameCreator to download these files and once processed, the location and file will be deleted, saving disk space. However, I am unable to view any data in the FeatureReader. In this instance, my FeatureReader has 905 records under the <Generic> Port, but when I view it via Feature Caching, it says “No Schema” for the attribute name and all the values are empty. However, If i click the Columns and hit “select all” it seems that I can actually see the tables, but I can’t seem to access the data with an attribute remover or the likes. Do I need to expose some attribute within the Generic Port <Attributes to Expose>?Any help will be appreciated! Thank you!

271

4 months ago

sarah.h.aContributor

asked in Data

Shapefile writer stops with no warnings or errros

Hi all,I am working on a translation in FME, and I’m encountering an issue where my data is being fanned out to multiple locations. However, when FME tries to write the shapefiles to the first file location, the translation stops without any specific warnings or error messages, other than the general "Error running translation."Interestingly, on FME Flow, the process behaves similarly. It doesn't throw any errors, but the translation simply stops after attempting to write to the first location, as if it's hanging or failing silently.I’ve tried to troubleshoot by checking the file locations and permissions, but the issue persists. I would appreciate any guidance or suggestions on what might be causing this or steps I can take to diagnose it further.Thanks in advance for any help :)

457

4 months ago

teresa_roParticipant

asked in Data

Calculating values in excel

Hello,I have an excel files with values in it. I read the excel file, want to use the value from column E (value is 45), use it in a math formular and calculate a new value. At the end the result should be written in to a Feature class in a FGDB. The transformer I want to use is expression value. But the calculation doesn’t work. Has anyone an idea? Thank you!Teresa

Does writing to a MapInfo Extended TAB format take longer than to a MapInfo TAB ?

Does writing to a MapInfo Extended TAB format take longer than to a MapInfo TAB ? Just wanted to check with the community if this is a known/expected behaviour with writing data to MapInfo Extended TAB and also if there are workarounds to quicken the writing process.Although I have experienced FME 2017 take considerably longer time to write a MapInfo Extended TAB for polygon data that is about 1.2 million in count, I failed to take note of the actual time it took, from the log. I do have a stat for a much smaller dataset, that of 1500 polygons and it took about 14 minutes to write to a MapInfo Extended TAB

406

4 months ago

Jonathan SlopeContributor

asked in Data

Create centerline on highways and intersections

Hi! I have a new question today. I want to create centerlines on highways. Now, long lines, without intersections, work fine. However, i get wrong results when fme encounters a intersection, like in the pictures below. I expected this and tried to solve it, but it only became worse. Does anyone know a right way to do it? Thanks in advance!

Microsoft SQL server Spatial reader failing

Microsoft SQL Server Spatial Reader now fails to connect post upgrade to 2020.1. It worked with 2020.0. We are getting this error: Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. - is there something we need to install?

Can FME write to an Excel table?

I have got some beautiful Excel templates containing tables (not normal ranges). It's quite easy to write to a named range within Excel but I haven't figured out how to write to a Table. Does anyone know how to do so?

1825

4 months ago

denverinpagosaContributor

asked in Data

Join excel file to geodatabase to match addresses

I have an excel file that has a list of addresses, and their associated license number.I want to join this to a geodatabase file to output any parcels that have any of the addresses in the excel file. I can’t seem to make that work. Can anybody point me in the right direction? I’ve tried FeatureJoiner and FeatureMerger and can’t seem to get any output without failure.

392

4 months ago

denverinpagosaContributor

asked in Data

Can't add Excel reader

I’m using the Data Interoperability extension in ArcGIS Pro. I can’t seem to get a excel reader to add in. I’ll set the parameters, it’s not open anywhere else, it’s not password protected or anything like that, and it’s on my local system. When I click ok to add it, fme acts like it’s trying to add it, but then just sits there and spins until it eventually times out. What am I doing wrong? I haven’t used FME in about 7 years or so, but I used it extensively prior to that and never had this sort of issue.

372

4 months ago

sar_coppContributor

asked in Data

Help with creating a nested JSON from an Excel table

Hello,Is it possible to transform a table (ie from Postgresql, or Excel) into this complicated Json format within FME please? I have attached the json file and also a small dummy sample excel file (which doesnt quite have the correct column headers as its a work in progress).I am completely new to JSON and I have done the JSON Templater tutorial but no idea how to actually apply it to my needs!!Help wanted!!

662

4 months ago

marta.podsiadSupporter

asked in Data

Read Share Group information from Esri Enterpise

Hi,I am having trouble reading the names of the groups with which the layer is shared in Esri Enterprise. I am using an HTTPCaller with the following settings, but the Share info does not appear in the JSON response.The only information I get is: "access": "shared". Could you please advise on how to retrieve this information?

355

4 months ago

Page 7 / 281

Badge Winners

aaron_chaputhas earned the badge FME Certified Professional
flmuenznerhas earned the badge Integrate Data with the FME Platform Training
bmoody81has earned the badge Teacher (Grey)
gruelle88has earned the badge Webinar Watcher (Grey)
gruelle88has earned the badge French Speaker

Show all badges

Community Stats

31,327: Posts
118,852: Replies
38,954: Members

Latest FME

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.