- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,818 Posts
25,115 Replies

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

6818 Posts

Most replies

Most views

Newest first

davideagleContributor

asked in Data

Reading an XLSX and using a WHERE clause

All, I'm attempting to issue a WHERE clause on reading an Excel file... but the source worksheet has column names that include spaces. So I can get this to work: Test_me = 'Dave' but this doesn't: Test me = 'Dave' and it returns a provider error: Provider error `(-2147217900) Syntax error in GROUP BY clause. I'm assuming its the space that is causing the issue, does anyone know of a work around, short of ensuring the source data has underscores instead? Thanks

how do I set the text justification when writing to DWG?

How do I set the text justification when I write to DWG

Unable to generate correct cesium 3d tiles

m trying to generate 3D tiles form shp file. Just simple shp reader directly to Cesium 3D tiles writer. It does generate files, but after uploading them to Cesium Ion it does not work. It cant even generate preview of it.Am I missing some step in FME?Coordinate setting: reader - read from source

How to write in AutoCAD format

@takashi Hi! I'm new to FME, I'll need some help to export my data in ACAD format. My input file is also in AutoCAD format.The problem I'm having is that there is no output file. Actually I want it in the same format and layer style. Thank you in advance.

5 years ago

geoworld

asked in Data

Can the "FeatureReader" access Azure Blob Storage directly?

Hi all,In the "AzureBlobStorageConnector" documentation ( http://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/azureblobstorageconnector.htm ) is written that: "The FeatureReader can access Azure Blob Storage directly, without using the AzureBlobStorageConnector. In this case, a permanent local copy of the dataset will not be created". Since I do not need a local copy of the file, I tried to use the "FeatureReader" to access the Azure blob storage, but I am not sure which reader format I should choose. Could someone help about this topic, please? Thanks a lot

How to convert 3ds file to CityGML LOD2?

I'd like to convert 3ds file to CityGML LOD2 (CityGML version is 2.0). Actually I want to classify roof and outer-wall. I already found similar question in the Community as below as https://knowledge.safe.com/questions/22115/how-to-convert-3ds-file-to-citygml.html But the shared workspace doesn't work. If possible please share workspace .

Is FME Server provide service for Cesium like Cesium ion?

Hello, I'm using FME Desktop to convert 3D files to Cesium 3D Tiles, and have published the workflows to FME Server. I read the FME Server REST API, and it seems like operating the FME Server functionality, so my question is: Is FME Server provide any web service or api for Cesium client to present 3D data just like Cesium ion?

ORA-01756: quoted string not properly terminated only when using Published paramater

Hi, im using FME in an oracle database copying data from one table to anotherI am trying to put a published parameter on a "WHERE clause..". If i write the whole query, everything is OK:"DE" in (SELECT CZ FROM REF_CZ WHERE MONO = 'BORË')':but,If i put a part of it as a published parameter i get this error:Query: "DE" in (SELECT CZ FROM REF_CZ WHERE MONO = '$(P1)')Field type is a string.Error is : ORA-01756: quoted string not properly terminated'. (serverType=`ORACLE8i'..........

Multiple shape files to Multiple Excel sheets

Hello,I need help in addressing multiple shapefiles in .zip , add some transformers to it and then write it to an excel file with different shapefiles result copying in different sheets in the same excel.Thanks in advance.Mukhtar

3D clipping - 3D modell with textures

Hi @MattAtSafeI want to clip a 3D model with textures in FME. My modell has the following spesifications:.obj format with texturesno coordinate systemIf I use a clipper in FME, it doesn't accept the IFMEMesh. Can you give me some recommendations on how to clip the modell and keep the textures? Thanks!Cecilia

2680

5 years ago

peteralstorpContributor

asked in Data

3D vector profile from 3D resistivity point data

Here's a fun problem! And, as always, any hints or ideas are welcome!I have 3D-point-data with resistivity values and I would like to generate a 3D vector profile with resistivity "areas" like the one below (but as vector data) - if at all this is possible with FME? And just the areas/3D-polygons would suffice. I'm mainly interested in getting the same information content than an exact replica. It doesn't matter if the information is made up of faces, meshes or solids as long as I can get circa the image below in 3D representations in say Autocad.I attach a template file with the data so if you feel like doing some testing you should be up and running directly.Like I said, any ideas or hints are welcome!Peter

5 years ago

click4vk

asked in Data

compare table data cross database

I am very new to use this tool and thought some of expert from this forum might help meI have oracle11 database and migrated to MS SQL server 2014I would like to compare data between oracle11->database1->table1 with mssqlserver2014->database1->table1I would like to compare data between each table with cross databasesPlease, let me know steps to do this

596

5 years ago

tonoContributor

asked in Data

How can i write data to excel and build a chart from one column into several sheets?

I would like to write several sheets into an excel file: on every single sheet there should be data and a chart based on one of the columns. I have tryed it using a template file which already has a chart on the template sheet. I am already using a template file and a template sheet.On the output file i just get data on every single sheet which is perfect, but only get a chart on the first sheet. The chart is based in one of the columns.Any clue on how to get an automatic chart per sheet?

RGB Point Cloud and NDVI Raster

Hi I want to visualize in 3D NDVI values (single band .tiff raster) in combination with RGB .las point cloud. What would be the best apporach? Cheers

SQLite VACUUM command after writing to db file

I was wondering if anyone might be able to help me out? I'm writing tabular data to a SQLite database and I'd like to run the VACUUM command after it's been written. I thought it might exist in the SQLITE3 writer parameters but no luck. I'm using FME 2019 desktop

Creating an SDE reader for metadata causing an error (Underlying DBMS error)

I am trying to read metadata from feature classes in an SDE but am consistently getting an error. I add a reader (format "Esri Geodatabase (ArcSDE Geodb)", point it at one table (interactively selected in the Table List field), set the Feature Read Mode to "Metadata", and then click Ok, and then comes the error (The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error}). My overall goal is to read a feature class's metadata, update it to show when the feature class was updated, and then write the new metadata to the feature class. I am able to create and update tables in this SDE using FME so I don't think it's a permissions issue. I've tried various settings in the reader but cannot get past that error. Has anybody ever encountered this? The full log file:Starting translation... FME 2018.1.0.1 (20180730 - Build 18528 - WIN32) FME Desktop ESRI Editi

How to build a geometry from different srid to set up postgis parameters correctly

I get datas from a csv file that contains a latitude and longitude field. These geographical data must be reprojected with different local systems. What should I do to build a postgis table with the correct coordinates (after reprojecting the given lat and lon in the correct geodetic system) for each point that I get ? Should I split in many different tables ?

Setting position for 3d models

I want to create many number of 3d model with different position. I am having one 3ds model file and an excel(.xlsx) file which has location data(latitude, longitude) to create many number of 3d model. Using Cloner transformer, I cloned required number of 3d model. But I don't know, how to set the location(longitude, latitude) for the cloned 3d models from the excel file?. Can anyone help me out?.Here I attached 3d model and it's position excel file.

Reader Sharepoint Office 365

Hi,i want read from Sharepoint 365, but i get only error messages. What can i do for connect? https://***/AllItems.aspxuser: ***@***.depw: ******@Rileygreene

Batch Processing in FME Desktop working sporadically with AGOL

I have a number of workspaces pulled together into a .bat file that runs on a schedule every night. Recently, a few of the workspaces fail to run but if I open the workspace in Desktop and run it is fine. The workpaces are pulling data from AGOL and often get an error "ArcGIS Online Feature Service Reader: Encountered an unexpected error. The error code from the server was '503' and the message was: 'An error occurred.'. Details: ''" and nothing further. The issue may well be with AGOL but it feels a little inconsistent when the individually ran workspaces seem to be fine.Has anyone else had this issue and if so, what suitable steps did you take to resolve?

how to define and write IfcShapeRepresentation properties?

Hi, i'm trying to define and write IfcShapeRepresentation properties (attributes) like the RepresentationType and RepresentationIdentifier for geometries (2D points) in IfcBuildingElementProxy (class) , but unfortunately without success.So how to define and write a 2d point in IfcBuildingElementProxy classe? According the IFC definitioin (link below) i have to define the RepresentationType as "GeometricSet" and the RepresentationIdentifier as "FootPrint" for defining a 2D pointhttps://standards.buildingsmart.org/IFC/RELEASE/IFC2x3/FINAL/HTML/ifcproductextension/lexical/ifcbuildingelementproxy.htm By following your "AutoCAD to IFC Conversion Example" Tutorial i have to set the geometry name to "FootPrint" (what defines the RepresentationIdentifier) with the GeometryPropertySetter-Transformer. (see workspace below)Now, how to set the RepresentationType as "GeometricSet"? (A "normal" point geometry like fme_point do not

Error in writing to Relationship Classes “Failed to retrieve origin row for a relationship feature with OBJECTID '226' from table/feature class 'ARSiteVision_Images'

Hi Folks, I’m trying to download images from Google Drive and convert these images to point and add the photos as attachment to the extracted points.I’ve created the relationship class in ArcCatalog and I could have the points and the attachment table when I disabled the Relationship writer. But when I enable it I got the following error “ERROR |Failed to retrieve origin row for a relationship feature with OBJECTID '226' from table/feature class 'ARSiteVision_Images'”I’m not sure what I missed here, I followed the instruction in this link but with no luck. I attached the FME Workbench if this is could be helpful. Ps: I have only 224 images so I would have 224 points so I’m not sure from where 226 come! Thanks,Rawan

Read Civil 3D Property Sets in 2019.1

There's been several topics on reading Civil 3D Property Sets on the FME forum, and according to the release notes for FME 2019.1 support seems to have been silently added: -------------------------- FME 2019.1 b19527 20190309 --------------------------Civil 3D: Added read support for property sets [FMEENGINE-10155]-------------------------- FME 2019.1 b19540 20190327 --------------------------Civil3D: Read property sets from CAD entities as well as Civil entities [FMEENGINE-10155] However I'm having trouble in getting it to work in a reliable manner and there doesn't seem to be any documentation of the extent of the support.Above are some of the attributes from our Property Sets. NV-Corridor are automatically assigned by Naviate and all of the information from that plugin works fine. BIP are attributes that we define ourselves with Property Sets. The ones that showup in the Property list in FME and that I'm able to read in the workspace seem to be limited to plain text Properties in t

Error message while writing to a relationship geodatabase "Failed to retrieve origin row for a relationship feature with OBJECTID '1' from table/feature class"

Hello, I created a FGDB that has a Feature Class, Relationship Class and Related Table. I used this url https://knowledge.safe.com/articles/28340/working-with-geodatabase-relationship-classes-atta.html) as a reference to set up the FME workspace to write data to the feature class and related table. What is interesting is that it writes without errors if I only write to the feature class and related table. If I try to also write to the relationship class writer, then I get this message. "Failed to retrieve origin row for a relationship feature with OBJECTID '1' from table/feature class" This makes me wonder if in this situation I don't need to write to the relationship class. If I do, hopefully someone can provide an answer as to why I am getting this error.Kind Regards,Laura

Convert SHP to DWG/DXF

Hi,I want to transfrom shapefiles into dwg-files. Therefore I tryed this tutorial:https://knowledge.safe.com/articles/18703/how-to-convert-shp-to-dwg-esri-shapefile-to-autoca.htmlBut I have a problem. If I want to transform polygon shapefiles, I always get more objects in the dwg file, then the original dataset had. In the video tutorial is the same problem. The original shape has 18 objects and after the transformation the dwg file has 21 objects. How could this happen?

2390

5 years ago

Page 101 / 273

Badge winners

philiphas earned the badge Welcome Back
marys2has earned the badge Welcome Back
marys2has earned the badge FME Form Basic Training
samipeltonenhas earned the badge Welcome Back
ramu36has earned the badge Expert (Grey)

Show all badges

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