Using readers and writers to extract and load data.
Recently active
Hello,I'm wondering if anyone is actively using I3S files from FME in ArcGIS online. I ran into some issues, where depending on the camera position, some meshes disappear. Like this: https://i.imgur.com/R9PMcj3.gifvIs this maybe because of missing LOD defintions?
Hi, I am updating an existing table (in fact updating/inserting/deleting with fme_db_operation, created with ChangeDetector). All data is well updated, all coming from my revised source, on all columns of my destination table. However, I have a lot of warning telling me that the column xxxxxx does not exist in table XXXXXXX.In the database, the columns exist, of course. I am using a FeatureWriter and the feature types have been imported from dataset, Oracle Spatial Object and selecting the tables.All columns are not updated (some have the red triangle, other the green one). Any idea why I get these warning, whereas the columns are well updated ?
When I open my KML file in Google Earth, I can see the data displayed in folders in the table of contents. When I use the KML reader to read the data, that folder name doesn't show up on my features. How do I get that out?
I am creating a mosaic from a bunch of tiff files into an ecw. The shape of all the tiffs together is irregular so there is empty space. It is defaulting to black, I would like it to be white. This seems like it should be an easy fix but I can't figure it out.
Hello!Once again, I've come across an error I have never seen before and can't find online.I'm adding a new ArcGIS Online feature layer to an existing workbench, which matches points inside polygons (using the PointOnAreaOverlayer) and gives the points the project number attribute from the polygon.This works fine for all the layers inside it, but this new layer gives the following error:ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in '<layerName>'. The error code from the server was '1000' and the message was: '24126: Point coordinates cannot be infinite or not a number (NaN).'I checked the point which was sent to the layer (using the feature caching), it shows on the map just fine and according to the attributes it's an IFMEPoint. But at the end of the coordinates it shows <nan>, regardless of the X, Y and Z values. The main difference between this layer and the others is this one is the first with a Z-value attached. So I expect that's the pro
Hello everyone, I recently updated to FME 2019, since then the IFC - Cesium3DTiles conversion does not preserve geometry colors (it was working fine with FME 2018). I think the problem comes from the Deaggregator. When I inspect the IFC, colors are preserved, but they disappear right after the Deaggregator. Has someone got into the same issue ? Thankssj
Is it possible to create ESRI Vector Tiles in ArcGIS Online using FME. I'd like to read from a database feature class for example, and keep an ArcGIS Online Vector Tile layer up to date with period updates. I can only seem to create and update ESRI Vector Tiles in ArcGIS online from ESRI PRO or possible write a script in Python3 and use the ESRI GIS API, in which case I don't really need FME.
I have decided to understand how to resave DGN file with tags using FME. I have dowloaded some files from this article (https://community.safe.com/s/article/writing-microstation-dgn-tags-with-fme#AdvancedExample) and ran it. It works correctly, but when I decided to change data to display into Microstation, I got NOT displayable data into DGN file. Before and after my changes into AttributeKeeper and AttributeCreator transformers: Owner.x_offset and Owner.y_offset are created too. Before and after my changes there are some differences between output DGN files even while trying to enable display option for new tag: Openning modified DGN file into FME, diffences are so big:Reader configurated like: And Exposed some hidden attributes I get:Owner.color = 0Owner.display = noOwner.justification = 2Owner.x_offset = 0Owner.y_offset = 0 But Owner.original_justification = 7Owner.x (y and z) are NOT the same as I set into output DGN file. And I see NEW attributes such:igds_color, igds_weight
I am writing to an ArcGIS Pro annotation feature class in a file geodatabase defined where the text symbol is not required to be selected from the symbol table. My intent is to change the size of the text and have the symbol stored inline, but have been unsuccessful in my attempts. The font size always ends up as 10. This doesn’t seem to be related to the definition of the annotation class symbol, as I have created annotation classes with different size symbols and the resulting size is always 10. I am setting the following attributes in the workbench and exposing these on the writer:geodb_text_size: 72geodb_symbol_id: -1geodb_anno_class_id: -1geodb_allow_symbol_overrides: TRUEgeodb_font_point_size: 72 In my testing I have been able to change these properties and see the results come through:geodb_text_colorgeodb_font_name I have tried using the TextPropertySetter to change the text size but that doesn’t translate to the resulting annotation. I did try running this with FME 2020.1 aga
From the Postgresql Writer, when a table is truncated and then inserted with new data is it possible to reset the Primary Key sequence to '1'? It currently restarts at the last PK value (+1) from previous entry.
We recently moved to an OData feed for one of our data sets, I am still fairly unfamiliar with this format. I am seeking to find out 1. if I am missing something in getting the Odata Reader to work 2. Failing that, what the recommended process would be to bring this data into FME. The feed (https://itd-pr-test.infotechinc.com/AuthModelService.svc/), is behind our firewall so I copied the header and first item into odata_xml.txt. Using FME's Odata reader I used Basic authentication and the link above. When I try to access the Feeds parameter in the reader or enter one of the table names manually into this parameter, it generates the error found in log1.txt, the most usable part of the log states there is an issue with format. After some research, I thought the Odata might be readable in a json format so I appended ?$format=json at the end of the feed to get the json version( first rows in format_json). This actually allows me to see the tables within the odata in the feeds param
Hi FME world, I have a workspace which reads from and writes to several ArcGIS Online feature service layers. At some point, it has stopped updating the data within one of the layers. The workspace still runs successfully and writes features to the layer, but the data is not updated (where there were existing data present) when I check the written features. Where there are blank fields before, the update works as expected. So there is something to do with not being able to overwrite fields where data is already present.The writer mode is set to UPDATE and there are only ever an X amount of features to update, so the OBJECTIDs never change. Any ideas?Thanks
I have a process that is reading from Smallworld (using the SWORLDSWAF reader) in 2020.1. All it is doing is writing to a file geodatabase. It keeps running out of memory no matter what I do. Is there anything I can do to reduce memory usage when accessing Smallworld?- I can't use 64 bit because the Smallworld reader isn't compatible-I have 32 GB of RAM on my Windows 10 machine-I have the temp files writing to a separate hard drive-I have a WHERE clause filtering out the incoming features Thanks
I am looking for the proper format to use the WHERE Clause to query features using the Smallworld 4/5 reader in FME 2019.1. The closest I can seem to get is:[interfaces].maintenance_notification where code_group_for_part = "DMPS0TR"[interfaces].maintenance_notification where code_group_for_part = "DMPS0VM"I have tried every combination of things but it always throws errors.
Hi,I found an example for creating multipage pdf on https://www.safe.com/webinars/choosing-the-right-transformer-for-your-data-challenge/?utm_source=youtube&utm_medium=social&utm_campaign=webinar-transformers-2018. I downloaded the workspace pdfpalooza.fmw and tried it. In the demo I see it crates a pdf with multiple pages, but when I run de workspace in FME 2020.1 it writes evething to one page, see attached PNG. I want to achieve the exact same thing, so multiple pages for one of my own workspaces so it would be nice to have a working example. Anyone?
Hi, I have created a simple workbench that merges two datasets together and performs statistical calculations. So far, I have been unable to set my Excel writer to have one sheet for the dataset and another sheet for the summary from the StatisticsCalculator. I have already seen the "write data to different sheet" post, but have not had much luck. Would anybody be able to offer any advise to me, please? Many thanks, Jess
i have oracle data, how could i configure it to read the data from it .i am not sure how to connect with and read the data parameter available : user and password and Host and port no. and service name FME 2018
I have the following MongoDB Atlas cluster, hosted at Google Cloud, to which I'd like to connect in FME Workbench.FME should be capable of connecting but I did not find the right settings yet to do so.In my Node.js Express app I'm using a connection string which includes the username and password as well as the database. In FME these are separate fields.The connection string looks like so:In FME I think this translates to this, but it does not work for me. And what do I fill in for authentication database name? I'm stuck at the following error message: Any thoughts much appreciated!
My input is a dwg file. Currently, I am reading the layer which consists of the location and the height of the elevation point in the field. I am trying to create point feature with VertexCreator. I think it does create it. However, if I send the output to the PointOnAreaOverlayer, all points are rejected and get "INVALID_POINT_GEOMETRY_TYPE". And idea what I am doing wrong?Here how my workbench currently looks like https://i.imgur.com/nh25NON.png And here is my points and the rejection msghttps://i.imgur.com/75tF2Eq.png
HiI'm trying to read a raster from pdf plan 08 that can be downloaded from his site:https://challenges.dk/en/challenge/banedanmark-digitisation-cable-drawingsThe plan includes i raster feature. I can view it ok in Chrome but when I try to view it in FME all the RGB and A pixels values are 0 and th plan is not visible. Any idea how to fix this?
I am interested in a way to translate these database (Tape) files into a usable format. Anybody have experience? Extended Binary Coded Decimal Interchange Code (EBCDIC) is an 8-bit character encoding used mainly on IBM mainframe and IBM midrange computer operating systems.EBC format descriptionCategory: Document filesApplication: -Mime-type: application/octet-stream
Is there a way to read or write to an MP3 (Music) or MP4 (Video) file's ID(3) Tags? There is plenty of software out there that allows for the editing of a variety of ID(3) tags in music or video files of the MPEG variety, however it might be useful for a Reader to enable those music / video files that identify their origins to be located from their tags onto a map.Anyone wanting to create a catalogue of their music or video would find the reading of the built-in data tags in their music / video files useful too.....just a thought.
Hi All,I have a workbench that reads a feature service from ArcGIS Online exposing the actual attachment attribute associated with each feature and then extracting the photos attached to it.I'm using RasteReplacer to convert the BLOB data to a JPEG and then writing it with a JPEG writer (with the option to save the EXIF data ticked).However, it doesn't look like the EXIF metadata is writing to the JPEG.I'm sure that the EXIF metadata does exist as I have an existing Python script that uses Arcpy to extract the JPEGs with EXIF out from a file geodatabase. But when I do it through the ArcGIS Online feature service reader, it doesn't seem to be retaining this information .Any help on this would be much appreciated.
To know the process of Reading and Writing the data. (output to MS Excel)List of Formats where FME can support Read and Write the data.
Hi All, I have an FME workbench which read a feature layer from ArcGIS online and export the information into excel sheet, my workbench is running fine in the desktop without any error but when I published it to FME server some times it’s working and sometimes I got the following error “Python Exception <HTTPError>: 401 Client Error: Unauthorized for url: https://www.arcgis.com/sharing/rest/portals/self?” Please note that I include the AGOL connection when I published my fme, I created a new app for this workbench so my users could run it from their side I’m using FME 2019 Any Ideas? Cheers,Rawan