- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,814 Posts
25,106 Replies

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

6814 Posts

Creating polygon from API response

Hello - I'm trying to create a polygon from co-ordinates received from an API call. The response body containing the co-ordinates is attached. The response can include shells and holes and I would like to be able to create both of these features if required (the attached example doesn't include shells but we will encounter these in future use).I think the response form the API is JSON and the workbench I've built to call the API is storing this response in an attribute ('_response_body').I'm really not sure how I can turn these co-ordinates into a polygon and I would be so grateful for any help.Thanks in advance and all the best,Matt

310

4 years ago

sigtillContributor

asked in Data

Powerpoint, change background

There is no Powerpoint reader in FME, but is it still somehow possible to replace background and/or color/styling on existing powerpoints on several Powerpoint-files by using FME?

I am trying to add Reader, using PostgreSQL and connect to CrateDB. Is it possible?

Anyone that has successfully implement it please share.I read from CrateDB that it contains support for the PostgreSQL wire protocol v3.

Hi there, I am using AGOL writer to insert the data into a feature layer. I noticed that whenever I ran the transformation, it insert the data into a feature layer. I wanted to set AGOL writer in such a way that when I run the transformation, it deletes the existing data and insert the new one. Could anyone guide how to do that? Please note that the data on FME transformation does not have OBJECT_ID attribute.

4 years ago

muzhnastoContributor

asked in Data

Create correct cesium tile

Hello to the masters of FME. I am a new user. and I have a question that I can’t find the answer to, I really hope for the help and support of the community. I'm trying to create the correct cesium tiles, but in the sea of information I found only two parameters that I can not make work.The first parameter is cesium priority, following the description https://knowledge.safe.com/answers/48967/view.html I created a test scene and could not achieve this parameter.the second parameter was found in this answer https://knowledge.safe.com/answers/77990/view.html it, due to my meager knowledge, I could not even realize how this should work.Third, when creating cesium tiles, it is possible to control only the number of individual objects in a single file. And in tiles, objects are collected not in a limited uniform area, but in some pieces. How is it possible to control all these parameters without losing the individuality of objects?Maybe someone can present a compiled example in one place

Geodatabase Error (-2147220987): The user does not have permission to execute the operation.

Hi, We are writing to a new geodatabase with FME 2013. This geodatabase has already a schema without any records. Geodatabase Error (-2147220987): The user does not have permission to execute the operation. FileGDB Writer: A feature could not be written. Has anyone experienced this error before. It is strange, we are able to write some features but some other give this error. Thanks, Jo

Create empty shapefiles and dbf tables based on excel schema

Hi, I have one excel file containing following columns: - feature_type --> defines output file - attribute_name --> defines the attribute name - attribute_data_type --> defines the attribute data type - geometry_type --> defines the output geometry type - order --> defines the attribute order I now want to create a set of output files based on the feature_type. If the field geometry_type is filled, a shapefile should be created. In all other cases a dbf table. Attributes should be created based on the fields attribute_name and attribute_data_type. Aim is to have all work done in the input excel file and minimum of manipulations in the workspace. I only want to create empty files that will be filled later by an operator manually. Any ideas on this? Rob

receive "FFS writer: Failed to write to file" while reading large dataset

Hi,I want to perform spatial operation (point in polygon) using Spatial Relator. Point dataset has 30 millions of records. I have used Oracle spatial reader to read the dataset. But After reading nearly 15 millions of records , fme job was failed with error. "FFS writer: Failed to write to file..Please ensure that you have sufficient privileges to write this file, and that sufficient disk space is available" ..Is there any way I can read all point records at a time without error?Memory stats before start:START - ProcessID: 29545, peak process memory usage: 16893 kB, current process memory usage: 16893 kBSystem Status: 7.83 GB of disk space available in the FME temporary folderSystem Status: 18.42 GB of virtual memory availableOperating System: Red Hat Enterprise Linux Server 7.7 (Maipo)FME Platform: linux-x64The memory allocator being used by FME is : `/lib64/libtcmalloc_minimal.so.4'FME Configuration: Process limit is 15.67 GB of physical memoryFME Configuration: Start f

GEoJSON geometry replacement issue.

Hello everyone ,I have two JSON files 1. RoadElement.json2. WaterArea.jsonI want to create geometry from each JSON file that would be polyline& Polygon features I have also created FME workbench but could not able tocreate Geometry having some problem can any one help me what is wrong?Please find attached JSON file and created Workbench

Using fanout to export to excel tabs

Hello, I want to create an excel file for each customer, within each file, you can find information regarding this customer. I use therefore the fanout option in the writer. However, I have two tabs that I want to change in Excel, so I tried using 2 writers (one for each tabs), with the same name output name on the same location but fme does not seem to be able to see that these tabs need to be merged in 1 file (th name I put in the fanout). This results in 2 files in the output, and because they have the same name, one file is not exported as Excel. Is there a possibility in fme to export two multiple tabs, when using fanout?

How to check for the presence (existance) of a google sheet?

The google writer has the path its going to write to... How do I see the path (URL) it is going to use to write a google sheet?

3DTiles - Level of Detail

I'm using the 3DTiles writer to export our entire city model in order to use it in Cesium.In 3D TIles, there is the possibility to have different evel of details in order to improve the viewing performances. Is there any plan at Safe to implement this feature?Thanks for your answer.

ArcGIS Portal Feature Service writer failing

I'm attempting to update a ArcGIS Portal feature service using the ArcGIS Portal Feature Service in Dynamic mode and after the workbench finishes the original features remain unchanged. I'm expecting to see the features locations shifted slightly, various attribute values changed and my user account name in the last_edited_user attribute with today's date in the last_edited_date, but I see none of these.My workflow includes...Reading features from a ArcGIS Portal feature service with a FeatureReaderJoining each feature with it's schema via the Schema port plus a FeatureMerger joining on fme_feature_type and fme_feature_type_name Also reading the schema in via the Workspace Resources, which I believe will work better for what I'm trying to achieveMaking requested changes to the dataEnsuring all attribute names are lowercase to match the feature serviceWriting the revised features using the ArcGIS Portal Feature Service writer in Dynamic mode and these settings...Laye

2160

4 years ago

j_geoParticipant

asked in Data

Raster DEM from pointcloud - raster origin

Hello,I have one point cloud tile with extents, for example, of min (0,0) and max (1000, 1000).I want to make a DEM from this point cloud, which seems pretty straightforward, but it isn't.If I want a raster with a 1x1 cell size, the RasterDEMGenerator makes a DEM that has 1001x1001 pixels and extent min (-0.5,-0.5) max (1000.5,1000.5). The main problem is, that the values of the bounding pixels are not ok, as half of the pixel surface does not have corresponding points.Is it anyhow possible to define that I simply want a DEM between 0,0 and 1000, 1000 (original point cloud extent) with cell size 1x1?From my point of view, it just doesn't make sense to implement a "point cloud to DEM" solution that always takes half of a pixel size larger extent than the original point cloud extent, which is, of course, empty (without points). I know how it works; the algorithm places the center of the left lowest DEM cell to the point of min extent of the input point cloud, and this

How to find the top of each bump in a DEM or DSM

(FME 2019.2.1.0, WIN64)Hi,I have a raster DSM of max tree heights (max elevation heights over eucalypt forest). I would like to place a point on the top of each tree (max z value). The trees are not pointed like pine trees but have rounded tops.I have attempted to use RasterSegmenter (water shed) with limited success, by using RankCalculator with group on each water shed polygon, and then filtering with rank =1 (1 being the highest ranked pixel in each group). But this relies on the water shed being applied correctly.I have converted the raster to a point cloud using GeometryCoercer, I can see in a 3D point cloud viewer the tree tops, but I do not know how to go about finding the max z value for each clump of points that represent a tree.Is it possible to do something like this?Ben

Read (select) query with "Intergraph GeomMedia Access Warehouse" reader

Hi all,Is there a way to read a select - query (with geometry) with the "Intergraph GeomMedia Access Warehouse" reader like with the "Microsoft Access" reader?

4 years ago

anhphanuet

asked in Data

How to separate large data into small tiles with Cesium 3D Tiles

Hi,I'm currently using FME 2017.1 Smallword Edition. My problem is that I'm trying to convert Collada data to Cesium 3D-tiles and I don't know how to specify the coordinates to separate the large input data into small tiles. The image is how I want to tile my dataset.Here's the Collada data.http://bit.ly/2DhOxIDIs there any solution?How to create 3D-Tile data in popular way?If anyone knows the answer, please let me know.Thank you very muchPA

590

4 years ago

pschoutParticipant

asked in Data

insert images into an Excel spreadsheet

I found an article about "insert images into an Excel spreadsheet" (https://knowledge.safe.com/articles/33588/writing-images-to-ms-excel-spreadsheets.html), this article was made with FME desktop 2016. I was wondering of it is possible to do the same action with fme desktop 2015? In fme desktop 2015 the "attributemanager" is not available, so i as wondering which transformers to use in fme desktop 2015 to make the same actions as with the "attributemanager" in the article!I hope anyone can help me!Peter

Issue with ArcGIS Indoors to IMDF (Template Used)

I am facing an issue. all my ArcGIS Indoors layers are stuck in the middle of the process because it seems they are being marked as unfiltered. see screenshots below, please! images links in case they don't showhttps://ibb.co/3pjgpM2https://ibb.co/ns6S0Ny Any help please?

4 years ago

just_jasper

asked in Data

Trouble parsing XML file

Hello, I am in dire need of help, as I have been trying to parse an XML file for the last 5 hours. I have looked at the XML tutorial, in addition to many other posts on this forum, but I cannot figure this out. Can anyone help me? I am interested in getting a Feature for each Task, with all its subelements as attributes.The XML file and fmw workbench are attached. Thank you, and have a great weekend! Edit: You might have to change the path to the XML file in the reader.

200

4 years ago

gogopotter90Contributor

asked in Data

how can i show user Attributes in Dgn Feature types

how can i show user Attributes in Dgn Feature types where is the missing tab user attributes ,how can i show it .my file is dgn v7thanks

360

4 years ago

sameerContributor

asked in Data

FME Server - Schedules - Start Time field

Hello,Is there a way to filter "Start Time" field in Ascending / Descending order or any other fields for that matter.I have too many tasks scheduled and it's hard to find the right "start time" slot.On a different note (Not sure if it's the right place): My test/live site is now fully functional and FME Data driven including the HTML Outputs / Layers update... Notification service, which will soon be provided to residents, makes use of FirmStep but the delivery of the notification service is FME at its best!! The other bits rely on Open Source (PostGIS / QGIS...) Basemap = work in progresshttps://molevalley.cloudmappin.com/mmv/ (Not a molevalley.gov.uk domain name because of hosting issue due to time constraint) Thanks and hope you like it. I also take this opportunity to thank the community for their assistance as I've managed to complete my project (well almost).Kind Regards Sameer

4 years ago

jmhomzaContributor

asked in Data

Creating Tables from Excel

Hi,I have an Excel spreadsheet that has thousands of rows that need to be grouped by a couple of columns/attributes, then each grouping written to their own respective fan-out spreadsheet. I've accomplished creating reports by using the HTMLReportGenerator, then writing each report to an emailer. So, I need to accomplish what the ReportGenerator can do - group by attributes and create tables - but I need the results written to either individual spreadsheets or as tables in individual Word documents. Any ideas on what Transformers will give me the grouped Features to write to individual files?

350

4 years ago

jmhomzaContributor

asked in Data

Read spreadsheet, group by attributes, then write to separate spreadsheets

Hi,I have an Excel spreadsheet that has thousands of rows that need to be grouped together by a couple different columns, then write all grouped Features to their own individual spreadsheets. I've done this using the HTMLReportGenerator, then putting the HTML content table into an email, but I need to instead write each 'report' in a spreadsheet, so each table row would be an Excel row. Can anyone help with what transformers would be able to group the features without analyzing them, then write each grouping to their own respective fan-out spreadsheet?

230

4 years ago

gogopotter90Contributor

asked in Data

how can i work with dgn file v7,extract only polygon and lines

i have dgn file that include map for a place ,as first step when i put this file in fme which properties should i adjust to work on it , and also i need to get lines from this file and polygon to check intersection between lines and polygon.so what should i do ? thanks for help

150

4 years ago

Page 89 / 273

Badge winners

scarborough123has earned the badge English Speaker
sigbetshas earned the badge Welcome Back
havermhas earned the badge Student (Grey)
muhammadsambe0has earned the badge Teacher (Grey)
scarborough123has earned the badge Welcome Back

Show all badges

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