- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,779 Posts
24,921 Replies

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

6779 Posts

Recently active

Most replies Most views Newest first

sladlow

asked in Data

convert kmz to tab

Is there a way to convert a KMZ file that contains a description field to tab format, where the description field becomes a field in the tab file? I have tested readers and writers for KMZ to KML and kml to tab and Vertex creator (it would be good to have the lat/long fields listed too) and none of this quite works.

Edit encoded format attributes and write in output

Hi, I am using FME13, trying to modify a .dwg file. The original file has lots of information written in format attributes and there are also some encoded utf-16 format attributes. I am able to expose them and transform or modify the strings but I cannot get any in the writer output file. I don't want new extra attributes so renaming the format attributes to something else wouldn't work. Is it possible to edit encoded format attributes and write them out?Thanks!

7 years ago

ejdkeys

asked in Data

We wish to link an ESRI geodatabase to a ‘.mdb’ database. The ‘mdb’ database is updated daily.

We would like to make sure that the GDB is up to date whenever updates are made to the ‘.mdb’. The database is created from ‘Acquire’, and is exported in ‘.mdb’ format.We wish to use this ‘.gbd’ as a template for ARCMap workspaces, where all the geoscientists have access to up-to-date information. Currently many geoscientists in the organization have out-of-date files they are using on their personal machines. Currently people work from their own workspaces (.mxd), where it is never known if they have access to all the pertinent files, or if the files they have in their workspaces are up-to-date. We wish to have the changing ‘.mdb’ database regularly ‘merged’ into the gdb. Additionally, other files (raster images, tenement polygons ect) are desired to be automatically updated into the ‘.gdb’ as changes occur to the master files. As long at the raster image names, along with tenement polygon shapefile/layer names remain static, I think this should not be a problem (?). I have been taske

7 years ago

clives_online

asked in Data

Merge DWG then convert to SHP

I have approx 40 DWG files, each file contains a number of separate features - see below I merged all 40 into a single DWG file - see belowThe merged DWG file does not contain/display the individual features (G902APEX, G902BUILDING_EVES, etc)The aim is to: Merge all 40 DWG files into a single DWG, then write each feature (G902APEX) to a Shapefile with the associated tabular data.Any assistance would be appreciated. Thanks,Clive

I have a *.LAS file, I want to transform it to ASCII ....file which contains the coordinates of the points, organised in one line per point. The coordinates are separated per spaces or tabs. Any thoughts?

ms excel data manipulation

I have two sets of tables in an excel sheet. I want to pick each element from one column of one of the tables and try to find a match in another column of the other table. As soon as I find a match, I want to merge the corresponding rows. I was trying to use FeatureMerger but wasn't able to perform the task. Could you please help me out? Thank you

3618

7 years ago

carmijoContributor

asked in Data

Data Inspector Background Maps & Federated or Enterprise ArcGIS Online Account Support?

Does FME support federated or enterprise ArcGIS Online accounts?Thanks in advance!

106

7 years ago

redgeographicsCelebrity

asked in Data

"Number" parameter not optional on FME Server/Cloud

I've set up a workspace with a user parameter of the type "number", which is optional, no range limitations specified This works fine on Desktop, but when I upload this to my FME Cloud that parameter is suddenly not optional:Any ideas? I'm using FME 2017, build 17280 on Desktop, 17259 on Cloud.I guess I could work around this by having it default to a value that can't possibly be a valid value and then filter on that but that seems a bit of a nasty workaround and is almost certainly going to come back and haunt me in the future.

7 years ago

mhabContributor

asked in Data

PostGIS 3D Texture writing

HelloI am fairly new to 3D data handling and stumbled over the problem, that I can write 3D data to PostGIS but texture information seems to get lost.Is it generally possible ? If yes, what do I need to do ?Thanks for any hintMichael

Running a workspace or translation by field based users without using FME Workbench or no access to FME Server (no internet)

Is this even possible? At the onset, there is a license issue involved. Is FME Plug-in SDK an option? My use case is a drone pilot needs to create a geopackage or an fgdb from pictures/videos collected during the mission and would need to do this from his laptop onsite so that he can pass on the data to a courier or deliver the data to the utility owner. I already have a workspace created with FME Desktop but it's not cost-effective to provide a license for each pilot.The next best option is to provide ESRI's Drone2Map to each pilot which will do it - costs $1200 subscription per named user. If I can develop something smaller and cheaper in FME that would be better.

Is there a way to extract extents from AutoCAD drawings? These are held in drawing system variables $EXTMIN and $EXTMAX.

226

7 years ago

lsugumarContributor

asked in Data

How to connect to ESRI's versioned (e.g. QA version as opposed to default version) database using FME.

7 years ago

lavairyeContributor

asked in Data

The translation of numerous FGDB by using the same script fails

Hello,I'm a beginner with the FGDB translators in FME. I would like to create a generic script which will be able to transform any FGDB into Geojson files. As I don't have any ESRI license, I use the FGDB Open API reader/writer.When I launch the script, the first FGDB is correctly transformed, but when I try to relaunch with a new one, which doesn't use the same tables, nothing happens.Did I forget something?Here is my (very, very simple) script.Thanks for your advice.

7 years ago

klas_f

asked in Data

Reading and writing to ArcSDE Geodatabase problems in build 17539

When I read or write to/from my Arc sde geodatabases, I get <UNUSED>[GEODATABASE_SDE] and <NOT SET>[GEODATABASE_SDE] in the Navigator-panel. This occurred after I updated to the latest version. When I read from one database and try to write to another one, the process cast an error. If I do the same but replacing either the reader or writer with a file database(gdb), It works, even though I have the same<UNUSED> in front of the sde geodatabase. What am I missing in the settings?

Convert Coordinate from pseudo Mercator to Geographic Coordinate System in Shape file

i m converting georss file to shapefile. But when i convert my all georss file to shapefile and i check the data it goes shifted from its position. i m using coordinate converter transformer but it show error. without this transformer file converts to shapefile. Data is 15 km shifting from its original position. Pls Help

Importing to Smallworld - missing geometry/coordinates

HI, I am importing data from FME to Smallworld. Only physical data is imported like attributes but geometry/coordinates for teh records are not getting exported. Please help me.

Expose Autodesk Civil 3D Property Sets

Is it possible to read the Property Sets from Autodesk Civil 3D with the current FME Desktop? I only found this topic while searching.https://knowledge.safe.com/questions/34435/new-autodesk-civil-3d-2017-property-set-definition.htmlIf not I will create a new Idea for this.

How to determine the highest point along a series of lines from DEM

I have 80km of embankments which have been laserscanned. I have a polyline running approximately along the top of the embankment. At regular intervals (20m) along this polyline I have a point feature from which I have created perpendicular lines 10 meters each side of the point. Each perpendicular line has been assigned an ID corresponding to it's distance from the start .ie 0, 20,40,60 etcFrom my DEM I need to extract the values along the perpendicular line. I then need to sort the z-values descending and keep the highest z-value. I then need to group the values according to the ID of the perpendicular line thus keeping the highest z-values along the perpendicular line. The resulting value must then be kept as an attribute of the center point (green) of the perpendicular line for a label on a map showing the ridge of the embankment and the highest point.I have managed to create perpendicular lines each side of the embankment but cannot find a transformer that will extract the val

IFC wall geometry with windows: how to prevent the holes from being closed?

I'm having trouble with FME closing up window holes. The holes don't disappear completely, but are instead covered up (randomly?) on either side by, as far as I can tell, a flat (triangulated) polygon. This problem exists when simply viewing the IFC in the inspector as well as writing it to Esri multipatch. The behavior doesn't show in all walls either, as you can see on the right grey side, where the window holes are as expected. Any ideas how I could remove the coverings?The bottom screenshot is the building viewed in Solibri Model Viewer.

264

7 years ago

f.kemminjeContributor

asked in Data

How can i connect to oracle if my password contains @ symbol in it

Hi Team,fme 2016Both reading and writing to oracle spatial.My customer has @ symbol in his oracle password string.in my fmw file, oracle connection string is published parameter, and user has to pass the easy connect string to this parameter likeuser1/x3#@rtye@mydbnow there are two @ symbols and fme treats rtye@mydb as dbname and fails to connect.but thru oracle's sqlplus i can connect. not from fme.and if i give these three parameter separately to sql executor it works good. how can i connect with just one text string with @ symbol in password? please help.there are lot of fmws developed and i exposed connection string as published parameter

DWG Writer Attribute from shape output?

I want to expose the attributes of a esri sde30 to a dwg writer.How are the Settings of the dwg writer:Parametres>Advanced>Attribute Output:Or someware else?

7 years ago

dave29Contributor

asked in Data

Read/write arcgis feature service

How do I read attribute values from an arcgis feature service, update an attribute value for all records read, and write those updates back to the feature service as updates?I'm using the httpcaller to return attributes from an ArcGIS feature service. Below is the json result. { "attributes": { "OBJECTID": 103, "POI_ID": "8", "POI_TITLE": "Selmon Greenway", "DESCRIPT": "The Selmon Greenway begins at the Tampa Riverwalk. It’s a nice wide paved path that winds around and under the Selmon Expressway for about a mile until it ends at the Meridian Ave Greenway.", "FACILITYID": "191841", "LASTUPDATE": 1494363906000, "LASTEDITOR": "DPD3", "GlobalID": "{B93C41EA-5A6A-4BEE-8629-FE547DC74EB1}", "PICTURE": null }, "geometry": { "x": -9178887.5983503778, "y": 3241906.7689313167 } }I'm creating a url value for PICTURE and I want to write that new PICTURE vale back to the feature service as an update post. Below is the httpcaller post url I'm sending back to

7 years ago

egorbaykovnn

asked in Data

Custom reader: sync "SOURCE_DATASET" value with custom keyword value

Hi all,question please regarding "SOURCE_DATASET" value.My custom reader has its own dataset parameter, SB_DATASET.I need to sync SB_DATASET with SOURCE_DATASET: SOURCE_DATASET <-> SB_DATASET The following way doesn't work:SOURCE_SETTINGS...DEFAULT_VALUE SB_DATASET $(SB_DATASET)GUI TEXT SB_DATASET Dataset Name:...END_SOURCE_SETTINGSSOURCE_DATASET $(SB_DATASET)when IFMEReader::open(const char* datasetName, const IFMEStringArray& parameters) - is called - the datasetName is "."The opposite doesn't work as well:SOURCE_SETTINGS...DEFAULT_VALUE SB_DATASET $(SOURCE_DATASET)GUI TEXT SB_DATASET Dataset Name:--------OR-------->DEFAULT_VALUE SB_DATASET $[SourceDataset]GUI TEXT SB_DATASET Dataset Name:...END_SOURCE_SETTINGSSOURCE_DATASET \"$[SourceDataset]\"After creating the reader - SB_DATASET has "$[SourceDataset]" or empty value.Any ideas how to sync these two variables will be very appreciated.Thanks!

7 years ago

fmelizardContributor

asked in Data

Can I write to a Enterprise Geodatabase (SDE) that is not running?

I have an enterprise geodatabase, but no SDE services running. Can I use the sde writer to write to it?

7 years ago

tara

asked in Data

How to write all points to a multipoint feature class, even if there is a single point

I have a multipoint feature class in an Enterprise Geodatabase that I need to copy over to a File Geodatabase. The problem is that not every feature in the feature class has multiple points. Only ~2% of the features have multiple points, but it is critical I retain the option to have multiple points. The problem is that the FME File Geodatabase writer will only copy over just those features that are represented by multiple points (selecting multipoint as the geometry) or just those features that are represented by a single point (selecting point as the geometry). How do I get FME to accept all of the points as potential multipoints and write everything in the File geodatabase?

895

7 years ago

Page 187 / 272

Badge winners

adrian_farrellhas earned the badge Welcome Back
jsextonhas earned the badge Welcome Back
carolina_whas earned the badge Webinar Watcher (Bronze)
user01has earned the badge Welcome Back
siobhan.hallhas earned the badge FME Form Basic Training

Show all badges

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