Best Answers

I am reading from a postgresql database. Attribute [publication_time] has a primary key and type timestamp. In the postgresql database this attribute has values, but FME 2018.1 inspector shows no (blank) values.Can timestamp as primarykey be the cause? Kind regards Kees 

Hello, I'm having a problem when trying to write records from an ESRI file geodatabase feature class to an ArcGIS Online hosted feature service. The error message in the log is as follows: ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '504' and the message was: 'Your request has timed out.'. Details: '' Any ideas on how to resolve this issue? Thanks.

I have an orthophoto in ESRI GRID format stored in a file geodatabase. It works really well in ArcGIS and ArcGIS Pro; however, I need to convert this image into a GeoTIFF for a contractor that does not have an ESRI based GIS. I have tried to do this in ArcGIS Pro but I keep running into resolution and grainy output problems, and the documented fixes and remedies are not helping.  As I have FME Desktop, and I have seen that FME is capable of converting raster imagery from one format to another, I thought I would give that a try...but now my output is even worse than before.  Not being one to give up I thought I would come here to see how I should approach this using FME. Is there a trick to converting raster images? I thought it would be something quite straight forward (e.g. Geodatabase raster reader --> TIFF writer), but obviously the process will be a little more complex than that, at least this is my current thinking.What is the best way to convert an image from one format to

Hello.This is a two-parter question, I hope that is ok. This is a bit of a long post, but both questions are related. And I'll start by saying I don't know much about AutoCAD but..Question #1: I have a question about the Autodesk AutoCAD DWG/DXF reader at FME 2012 vs FME 2019. I know this is a very big leap in terms of software versions, but we're doing an upgrade at the moment so I am going through updating scripts. Where I can, I've been updating transformers to the newest versions. What I've noticed, is that the same dataset read by FME 2012 identifies fme_type / autocad_entity areas and ellipses differently than FME 2019. For example (using the exact same dataset):FME 2012 reads this feature as autocad_entity = autocad_polygon / fme_type = fme_area:But FME 2019 reads the exact same feature as autocad_entity = autocad_ellipse / fme_type = fme_ellipse:I guess I'm just trying to confirm whether this makes sense - I'm assuming geometry handling has been impr

Hello,I am interested in how to get a given point distnce with FME.I have points arranged by counter (pontID is ascending) and I want to get the next point's distance. I tried NeighborFinder, but the problem is that sometimes an other point is closer,so it gives a wrong distance.Thanks!

I've got some data in json which have some different geometries in it I want to read these with FME and output geometries, polys, lines, etc I attached the files, do I need to somehow change the way the coordinates are formatted' to be able to create the geometries? How do I best go about this in fme?  also have pretty much the same data in xml, attached that too.my plan was to extract the coordinates with attributesplitter but that got troublesome for anything other than a point feature

Hi all, I'm having a problem writing to Azure Cosmos DB where I format the attributes as in the image below and use the Azure Cosmos DB writer to write to the DB. When I test connection and write it says all good however when I go to view the data I get this error and the data hasn't been written. ActivityId: e39bb0d8-2a86-45db-bb62-d50efecc43b7, Microsoft.Azure.Documents.Common/2.9.2' A fatal error has occurred. Check the logfile above for details Failed to specify the feature index as constraints on the reader Cosmos DB (DocumentDB) Reader: Request failed with HTTP status 400. The message from the server is: 'Cross partition query is required but disabled. Please set x-ms-documentdb-query-enablecrosspartition to true, specify x-ms-documentdb-partitionkey, or revise your query to avoid this exception. Any help would be very much appreciated! Thanks Joe

I'm trying to map levels names from one MicroSation DGN file into different level names in another DGN file. Most of the levels are being mapped correctly but some features are not being mapped at all. Not sure why that is happening. Has anyone else had this problem?

When converting Autodesk Civil 3D data (specifically pipes and structure for creating water, storm and sanitary features in shape or geodatabase) with FME, I am not getting any invert elevations. The newly converted features have some AutoCAD attributes in HEX (assumed) format, but non of them make sense as invert elevation when converted to decimal. The export LandXML file from the same Civil 3D does have those invert elevation that could be read as part of structure description, so it is there, just can't get it out into GIS. I really wanted to avoid the process of manual entry of those invert elevations every time I need to add new developments to the infrastructure features. Any help on that?

Are there any javascript experts out there? I have created a data download web application where you draw a polygon and return some data. I have done this primarily from some samples made available on the knowledge base. It looks ok I have customized it a bit and added some extra functionality/background mapping.This is all working very well when I draw my polygon and submit the request it goes to Server and my data returns.Problem is I want to run the workspace even if a polygon is not defined/drawn - as in I have another parameter option to input x,y min and max values. I would like the workspace to submit without the polygon geometry part being drawn.  But when I try to do this I get the following error stating it can not read lengthmapinfo.js:175 Uncaught TypeError: Cannot read property 'length' of undefinedat processClip (mapinfo.js:175)at HTMLInputElement.onclick (mapinfo.html:1)  Can anyone tell me how I could get around this basically if its null ignore or something sim

Can FME Cloud be configured to access my local network drives? For example, could I read something from ArcGIS Online and write it to a shapefile or FGDB on one of my on premise servers?

Hello,Can you please help me with HTML parsing. Which settings I should using (css selector and etc) into HTMLExtractor that I can get only value of data-title attribute ?Regards, Pavel.

Picture 1: Picture 2: I want to do a Raster Mosaik so i need to make sure that the Rasterbands of the two Pictures are the same.why has the picture nr 2 behind the channels "#"? Never saw a Raster with the Band behind the Channel.

Hi all,I am using 2DGridAccumulator, which works perfectly fine. I would like to write also the bbox coordinates of each grid to my final output. I can see those values in the inspector but I don't know how I can extract those attributes so that i can write it. Any idea how i can do it? thanks in advance.  

Hello FME users,I am trying to configure the RabbitMQ JMS client for FME Server, without success. I copied the client files and dependencies directly in "FMEServer\\Server\\lib\\jms". Next, I configured a JMS subscriber to send message to my RabbibMQ Server :- Protocol : JMS- Provider Type Or Context : com.rabbitmq.jms.admin.RMQObjectFactory- Provider URL : server-name:5672- Connection Factory : com.rabbitmq.jms.admin.RMQConnectionFactoryUsername and password : OKDestination: a queue nameWhen I confirm my configuration the following error message appears : "Unable to find provider named com.rabbitmq.jms.admin.RMQObjectFactory. Ensure that the appropriate libraries are available and the correct provider is selected."What I am missing? Any help will be really appreciatedThank youAlex

Is there any function exists in FEM equivalent to oracle function decode. DECODE(supplying_code, 1, 'Oracle', 2, 'FME', 3, 'ArcGIS', 'GIS') result

Hi folks, New to the forum and FME, I'm hoping I can leach some knowledge. I have a csv file that imports into FME like this: I would like to manipulate it into the following format: Depending on which file is imported Costs 1, 2 & 3 may be there, or it may be a combination of 1 or 2 costs. All costs do share a common three characters at the left of their name. Is it possible to dynamically look at the cost columns and then transform the data into the format shown in the second pciture? Thanks in advance. Andrew

Hello again,We have a DWG that contains blocks that have been drawn in model space and then displayed in paper space using annotative scale. The block in paper space is scaled to the correct size based on the annotative scale but when I send the output to TIFF / PDF the blocks are the wrong size. TIFF Image above, DWG below. I know I need to scale the block, probably using the Scaler transformer, but how do I figure out the annotative scale used in the drawing associated with the paper space scale.There are AutoCAD references to the annotation scale but not sure how to find that scale out in FME as I can't seem to find in through exposing various attributes.  Sample drawing attached :

Good day, I am just looking if someone can point me in the right direction. GoalIfc/Cad File to .svg The goal is to create .svg for PowerBi. By taking a view from a 3d File and saving the view to turn into a .svg file. Below a few screenshots how I have done it before. A .svg is imported into powerbi.   When clicking the .svg graphic in PowerBi, the PowerBi table changes to filter only that Column In this example the .svg has the following ID: <polygon id="M1" description="M1"  If this ID is found in the PowerBi Data, the column for "M1" is called. ( I have added an example of such an .svg file that I work with: SvgPowerBiExample.txt(saved as .txt file) FME QuestionIs it possible to save a "view" of an .ifc file or Cad file such as .dwg in 3d? Then Vectorize that View and save the internal surfaces as the polygon id needed for an .svg file.  For Example, a view in FME that I would like to save as .svg file:  My current WorkflowThe workflow is

Hello Everyone,I am trying to run the translation on the Electric Migration workspace for Electric Asset Package V3.2 (Electric Migration V3 2019_12_18.fmwt file) using FME Desktop version 2019.2.3.1. It fails because it is missing a file called "NapervilleElectric_2019_10_22.gdb.zip". Is the file available for download, and is the workspace supposed to produce an asset package that is ready to load into a Utility Network without further configuration?

Hello, I need to write the resulting file to the same directory where my source file is, no matter where is the workspace. However, variables cannot be inserted into the writer's destination directory. Can anyone help?

Hey, I want to calculate values from 2 columns and get the results into a new column. Its only a multiplication: values of column a * values of column b = values in new column. Does anyone know how i could do this?

We have a DWG that has a number of scale bars shown in paperspace. In the DWG the units are visibleBut when it is brought into FME the units are missing. My guess is that the units are dynamically generated in the DWG based on the viewport scale and as such are not really annotation but some attribute / tag associated with the line.Is there a way for FME to find the values so they can then be used to output to PDF.  Update 1:Here is a a sample DWG with the issue included. Update 2:What I have discovered is the scale bar is a 'block' and the text is a tag associated with the block. Is there a way to convert the 'tag' to text in FME? 

I have 2 dynamic writers in which data are coming from 2 readers (SQL Spatial and SQL non-spatial, respectively). Actually the readers are reading from the same database (A, for example) and the writers are writing out to the same database (B, for example). The reason why I have 2 readers is because there are spatial data and non-spatial tables in database A. I have a SQL script that can set ObjectID to Primary Key. It doesn't seem working properly when I put SQL script into the first writer (spatial). Therefore I had to put this SQL script into the second writer (non-spatial) to make it run properly. Any ideas? Thanks 

Hi,I am trying to set up within an FME workspace a way to run select transformers within the workspace based on the day of the week, and other parts based on the month.I have various external datasets I want to refresh internally (SDE) by pulling them externally; some datasets are to be pulled every Tuesday, while others are on a quarterly basis (2/1,5/1,8/1,11/1). I would be running the workspace from FME server on a daily basis but have the coding within the workspace to refresh based on preset conditions.I am running FME 2018.1 build 18547