Using readers and writers to extract and load data.
Recently active
From ESRI documentation it shows that they use the field GDB_GEOMATTR_DATA as an 'extra' way to store complex polygons. That is, if you want to use more than regular straight lines between the points of that polygon. Inmy case, that field only contains 'NULL' values, as I only use simple straight polygons.So far, so good in ArcGIS pro, but when you try to read the FCL in FME(2019.2) an error occurs that the row is not available. The only way is to exclude the field when you want to read the data. The problem is that you normally don't look for that field as this is not allways added to the FCL. Also FME_server cannot handle this field.The question: is there a way to get past this issue without having to think about field GDB_GEOMATTR_DATA, even better: I hope that FME will fix this reader issue.
Is there any way to write to an esri sde feature class with attribute rules and database sequences?
Hi,Is there a way to automatically create new coded domains into Esri Geodatabase (File Geodb) writers? I have all the domain information in an excel file. Is it possible to have a function to import the table into the coded domain window?Thanks.
Hi All, Just been playing around with the 3D PDF writer and have noticed that my output seems to be in mm rather than meters (AdobeReader has a measurement tool) I've turned off "Move to local Coordinate System" but the issue is still there. Is there a way to specify the unit in the writer? or is the only way to do this to scale the model so that the measurements are at least accurate?
Good afternoonI have a workbench that is using the sharepoint reader to to pull the contents of a list into fme, where when I run it fme reports Microsoft SharePoint List Reader: Client-side error: '404 Client Error: Not Found for url: https://........The list has ~95 fields in it (so quite a few and the url call is quite long). Through trial and error I have found that there are a couple of fields that if I exclude from the Reader the workbench runs ok. The fields are type string line of text in sharepoint. They have / characters in their names (but so do some of the other fields). None of the records in the list actual have any values entered in those fields at the moment (but there are others like that which read ok) and so I'm a little stuck as to what's causing the error.These are the 2 bad-eggs I dont' have any Features to Read parameters set in the Reader. Has anybody out there run into a similar issue with the sharepoint reader?@mark2atsafe I see a few share
I've been trying to upload an excel file to a shared drive on Google Drive using a GoogleDriveConnector and keep getting an upload error where it can't find the folder I'm sending it to (404 Client Error: Not Found for url). I can upload it fine to My Drive, but can't find a way to upload it to the shared drive. Has anyone had the same issue and found a way around it?
I want to write areas with holes as "osm_relation_type=multipolygon".It works fine when I give the objects directly to the OSM-writer (FME does all the work).However, I would like to assign the node/way/feature-ID myself and determine the number of vertices of a "way" myself.I tried following workflow:Getting a "feature-ID" to the areaSplitting the areas in simple features an features with holesExtracting the outershell and holeWriting the tag "role=inner" (hole) and "role=outer" (outershell) to the geometrySplitting the geometry after 1964 (e.g. year of birth) verticesCopy the "feature-ID" to "feature_relation_id"Getting a "way-ID" to the wayJoining a feature and it's ways by "feature-ID" and the attribute "feature_relation_id" an creating the members (ref/role/type)Dropping the original feature-geometryAdd the attributes "user", "timestamp", "version"
Hello, We have a workspace with transform a Geodatabase file in more thant 300 dwg based on surface. When I open the dwg with AutoCAD, I have a message like below. It says that "file was written by a school version of Autocad and A text is written in the trace banner". (Print Screen 1) THe workspace run with the version of FME : FME(R) 2018.0.0.2 (20180414 - Build 18301 - WIN64) and the version of AutoCAD I chose to write it's AutoCAD 2010 I have the same type of message with files (Print Screen 2 wrtten with FME(R) 2019.1.0.0 (20190710 - Build 19608 - WIN64). The message the files was written by a application which hasn't been developped by Autodesk or which hasn't got an Autodesk's licence Can you help me with this issue ?It's not very good to have this kind of message in file to share for internal and external purpose. I can send files if necesssary. Best Regards Bernard DinonPICC_Crisnée-Odeur.dwgOSP3_2020_Blegny_Plan_20200319.dwg PICC_Crisnée
Hi, How can I broken the attached JSON file into attributes? Thank´s
Hi, I'm looking for a way to automatically generate URLs for each feature in an ArcGIS Online feature service and add it as an attribute. If possible I also need the URL to zoom into the specific feature instead of opening the entire layer view. The URL will then be attached to an email body to allow the necessary people to view what feature is requiring repair. Has anyone been able to do something similar to this or have any ideas of how I can accomplish this task? Thanks!
I'm trying to read a .dgn-file with Bentley MicroStation Design (V8) reader. When i change parameter to group element by Geometry instead of Level names i get this error. Anyone know why i can read elements by level names but not with geometry? 2020-06-03 13:14:04| 15.0| 0.0|ERROR |f_0: Lookup table `DESIGNGEOMIgdsTypeToGroupLUT' doesn't contain key `igds_oriented_arc' or have a default value
HiI have created cesium 3d tiles from a shapefile. The screenshot with pink 3d cylindrical shape shows that. I would like to add border and vertical lines as you can see in the sample screenshot from google earth below: Can anyone help on how I can do that?
Hi list.We're importing data from customers on a daily basis, and we utilize the strategy of creating a new schema for the new data with the date included, e.g. "Fiber20200602" (with yesterday's data still in schema "Fiber20200601"). The tables and views in each "day-schema" is identical.I want to have FME read tables from the latest schema, and I use an SQLExecutor the generate the wanted schema name. But how do I utilize it in FeatureReader ?I added two tables under "Feature Types to Read" (by point and click). This worked very nicely.Using the text editor I then changed the hardcoded schema name to be my variable. This removed my two output ports, even though my "Output Ports" was set to "One per Feature Type".I then tried to change the setting to "Specified", and added the two tables as fixed schema. This regenerated the output ports, but the read input data was output on the "Generic" port none
I want to transform a Personal Geodatabase to a PostGIS database. In my Personal Geodatabase are Polygons (which also have multi parts). I used an Aggregator Grouped by OBJECTID of the features to create Multipolygons. Unfortunately this resulted in a geometry collection, so I used a GeometryRefiner which was suggested to me, but this only converted the Geometry collection back to Polygons. I also applied a GeometryFilter to check that there are only Areas in the dataset - this is actually true. So, how can I identify the error? And how can I create Multipolygons so that my transformation will be successful?
When investigating access to geopackages from network drives, a temporal difference in loading behavior between geopackages created by FME and geopackages created by QGIS was determined.In comparison, GeoPK created in QGIS will load 10 times faster when opened in QGIS than GeoPK from FME.The reasons for this behaviour and an evaluation of possible steps to remedy the problem could be investigated. Differences:geometry ConstraintFME: = GEOMETRYQGIS: = POLYGONDimension ConstraintFME: = xyzmQGIS: = xyVersion des GeopackagesFME: 1.0QGIS: 1.2Probably the difference depends on the version of Geopackage:FME: 1.0QGIS: 1.2 Questions:What does the time difference depend on?If from version, then how can the version in FME be changed from Geopackage 1.0 to 1.2?Thank you in advance
Hello, i have 3 csv writers, one is a header record from an sql database that has 10 fields. the second is the main body of the file i'm writing and this has 12 fields. the third a footer record again read from a sql database. to write them as one csv output i use a file name attribute the same for the 3 files with the second and third appended. my problem is the output file only shows ten fields not the twelve as defined by the structure in the writer. does anybody know how to overcome this. Thanks
I have a shape file with points and I would like to get the points which are inside an Autocad-boundary. I tried it with Pointonareaoverlayer and spatial filter, but every point goes to the 'failed'output :-S....It isn't rocketscience, but I can't fix it.Who could get a look at my workbench and fix it? It would be great! :-DThis is the input:
I'm new to FME, so if there's a better option it would be greatly appreciated: I have multiple geotiffs (georeferenced black and white aerial phtographs) that I want to convert to a single ECW for use in Geoserver. As there were issues with black and white I set the cut off edges (which contained labels e.g.) in MS Paint before georeferencing in QGIS to RGB red (as these could be manually set to nodata in QGIS).So the corresponding geotiffs have all band 0 (red8) value 237 / Band 1 (green8) value 28 / Band 2 (blue8) value 36 (and a band3 alpha8 255) for the nodata values. I'd like to have this RGB value 237, 28, 36 set to be interpreted as extra nodata value or set to be replaced by value 0 and add this (with the other value 0 for nodata for the normal background, as the geotiffs are not fully upright) to the ECW as nodata.I tried rasterPaletteExtractor but it rejected the geotiff. Or should they all be extracted by band first (bandselector) or should it be done in some way
Hi.I have LiDAR data in .asc and .las formats. I also have .shp file points that I would like to attach the elevation from the LiDAR. How would I go about this?Any help wold be much appreciated.Paul
I have a raster maps (old land use maps) that I want to digitize into shapefiles for ArcGIS. I am new to FME and not familiar with the interface. Is there a way to do this efficiently? I have attached the map to this message. The map jpeg is geo-coded. It also has a blue grid overlayed that does not need to be digitized. I would like to retain the different colors as separate layers.
Trying to run very simple workspace read several DWG files and write them back out to new files with the AUTOCAD_OD writer. Using FME 2018. I have set a path to the Template file and the shape file folder (which I take to be fonts & linetypes), but it keeps erroring out with "Shape defined within template is not stored. Error." Any suggestions?
I'm trying to update some feature service layers in AGOL from a file gdb, but I'm having some issues with the change detector. Many of the layers are working fine, and some that didn't work at first could be fixed by unchecking the "check geometry" option. Unfortunately, some of my change detectors are still processing many of the features as "updated" (I have made no changes to the layers), even with the geometry option unchecked. I have also tried to use a coordinate rounder with no success, and now I'm not sure what else I can do. If I try to continue with the update, I get an error 1019. Any help would be appreciated!
Hi,I'm using FME 2019.1 and would like to insert an image (raster) into an DWG-file. I cannot find any detailed description regarding this and my attempts all end in an error saying 'Failed to write raster with raster reference '1', ignoring texture'.I'm using a reader to read either a GeoTIFF-, JPEG- or PNG-file and send it to an AutoCAD RealDWG writer without any transformations.Could anyone please upload an example FME-file that does this? Thanks for your help
Hi,I tried to create a FME Server App with drag and drop functionality. Seems "drag and drop" only works with text files and not e.g. shapefiles?
Hello,I'm using a series of 'SQL Executor', 'FeatureWriter' and 'AzureBlobStorageConnector' transformers to extract data via an Oracle SQL connection, write it to a .csv file (via a 'TempPathnameCreator') and upload it to Azure Blob Storage. It has been working, albeit intermittently. More often than not it is failing to write to Azure Blob with a rejection code of "UPLOAD_ERROR" and a rejection message of "'('Connection aborted.', timeout('The write operation timed out'))". I'm unsure if this is something I can fix, or if the problem is on the FME end, or the Azure end. Any help would be greatly appreciated!