Using readers and writers to extract and load data.
Recently active
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
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 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
Does FME support federated or enterprise ArcGIS Online accounts?Thanks in advance!
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.
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
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.
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.
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?
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
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.
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.
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
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.
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
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?
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
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!
I have an enterprise geodatabase, but no SDE services running. Can I use the sde writer to write to it?
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?
Hey Everyone, it is me again with some more annoying questions!I have fulfilled most of my requirements for writing out to a CityModel. However, there is one req that is outstanding: adding the gml:id to the CityModel itself.i have followed the CityModel Templates that are available through hub, and have added an attribute (gml_id) for the citymodel feature, and exposed it as a format parameter. but it still does not write to the output GML file.I have even replicated the same ID as the gml_parent_id parameter in the building feature, but still no luck. It is very frustrating!Here are some screenshots of my workbench, and inspector against the CityModel Feature Class / table or however you would refer to it when in inspector. You will see it is using FME Generated ID, and actually the GML has it missing.The above workflow is just a snippet - the full workflow includes the buildings and surfaces also.Many Thanks in advances for any time anyone spends in helping me figure this one ou