Data

Hi all,I'm trying to write a few layers from a .DWG to ArcGIS Online. Is there a way to keep the symbology of the DWG when writing to AGOL? Or, is there a transformer that can change the symbology of a line/point and then write to AGOL?Thanks!

I am writing out to Access (JDBC) and want to use an attribute created in the routine for the filename. I have tried entering @Value(Filename) in the Database Path of the writer but it just creates a database called @Value(Filename).mdb Any ideas how I can get the attribute as the filename. The only option I have found is to use a user parameter to do it but I want a date stamp as part of the filename which is created in the routine. Thanks 

Hello,I have a shapefile whose report I am trying to generate by pivoting. The result, I am able to get on different sheets. But the output is not calculating the formulas and hence I am not able to calculate summary for all the sheets. The template has only one sheet as a reference. It also has some formulas which calculate the summary. When the reporting is done for the single file it reads the formula and generates the summary as well.Attached herewith is the sample workbench and the template file to refer to. Any help in this regard is highly appreciated.Thanks.

i am using google sheet reader and writing it to the database.. but the problem is there are more than 10 readers for google sheets which are are updating each and every hour .so if i just run the workspace it is not writing the fresh (updated google sheet) instead the same old one so i have to do update reader for every time for each reader to write the updated sheet please is there any solution to do it automatic after i run the workspace it will read the fresh data updated in google sheet..

Hi,I'm attempting to connect to an AWS S3 bucket from FME desktop (2018.0). (Colleagues have informed me that the situation is no different in FME 2019). The system proxy settings are controlled via a PAC file as part of group policy. I know that the proxy is NTLM, and as far as I can tell there is no way that FME can pass on authentication credentials correctly and so connections are always refused. I have tried the various settings within tools>FMEoptions>Network Proxy> but I always receive the same connection error -'Unable to execute HTTP request: 'I can navigate to the bucket via the browser with no problems. As at here https://knowledge.safe.com/questions/31838/s3uploader-and-network-proxy.html is it simply the case that the S3 tools do not work with an NTLM proxy? Is the only alternative (in my case to pay for) a proxy authentication bypass?

While migrating data from oracle to mongodb, I am trying to use JSON reader and writer. I need to know if instead of using json reader and writer both is there any simpler way to do this.

Hi,I do not know what happend to my schema, but I need to update a reader all the time when I want to run the workspace. Before I did not need to do this. The schema and Data for reader are always the same ( just name od dataset-[not feature type name], and content are different).I had to upload a new dataset into a reader and that was all.Now, I need to Update reader AND feature types every single operation. Otherwise read the reader only a few feature types.I need to automate this schema in FME Server, but it will not work when I need to update a reader all the time. Does anybody has any idea why this happened?I did not make any changes in my workspace. Thanks

Hello,I have a dgn file containing a 3D model of a ground surface. From the dgn I created a 3D polygon shapefile, extracted the vertices to points and assigned Z values to the points. I would like to interpolate between the points I extracted to create a DEM. This process works well in ArcGIS, using the Create TIN tool and I'm able to create a DEM raster that closely resembles the original 3D model. I've been trying to replicate this process in FME but I can't seem to generate a TIN similar to that of the original model. I've tried using TINgenerator, DEMgenerator, RasterDEMGenerator and Surfacemodeller. With all of these methods it appears to interpolate a surface but the faces are missing (looks like a greenhouse with the glass taken out). Or the interpolation is so course that it creates huge triangles, which is something that the Create TIN tool in ArcGIS appears to overcome.  Is there away that I can generate a TIN with solid faces and a higher resolution of interp

Hello everyone, As said in the title, I'm having trouble converting an SDE Polygon feature class to a KML file in FME 2017. When I do the translation on FME, I can see the geometry and attribute in the inspector, but when I add the KML to Google earth, there is no geometry! I was also using a KML Property Setter and KML Styler, but that shouldn't have any effect. I've made sure to check the coordinate system, and I've re-run the workspace In many different variations, and even tried doing the conversion in Arc, but no results for getting the KML polygon. Please help! One thing I've noticed is that the polygon KML is a very large file when compared to the other KML's generated in the workspace, both of which have many, many more features.  The data that is not 'working' is the writer ending in '_Area'

Hi all, I have a dwg file with a lot of layers. Some of the layers are named in Latin alphabet some are not. The ones that are not are shown like this \\U+041A\\U+043E...............I have two questions:1. How can I see the layer names properly?2. How can I create a list of all layers, in the format dwgname,layername and write out as csv file?

I'm puzzled how to set up tokens for external applications in server 2019.We submit workspaces in server from an external application. (Internal WebGIS.) We manage users (who is allowed to do what) in the WebGIS user management. Only backend users connect with server.Previously we had one authoring account and one api account in server. We maintained workspaces using the authoring account. The api account had submit only rights on specific repositories. When a user started an action, the WebGIS application requested a token using the api account credentials and submitted the workspace.Now we have server 2019 with AD connected. But I'm not sure how to use it correctly.- When I create something under my own account, my colleagues can't maintain it. Yes I can give users or roles full access, but I need to do this every time. And I can't transfer ownership?- When I create an API token it is assigned to my account. This means my name is logged when a job is submitted from We

Has anyone tried to write to an In-Memory table such as a PostGIS temporary table?

hi,how to set attributes (strings) on the objects IfcPerson and IfcOrganization with FME?like "FamilyName" (IfcPerson) orlike "Name" (IfcOrganization)

Hi All,We have a lot of workbenches on our FME Server and the configuration of a fileserver with shapefiles has changed. Therefor I want to have a list of all fme workbenches that contains a reader with format Esri Shapefile or a writer with format Esri shapefile.I also want to know the path of each esri shapefile reader or writer.Or even better: i want to have a list wih the connection parameters of each reader and writer of every single fme workbench on the server.Can anyone help me with this?Thanks a lot,Francis 

 Hi, i like to define the upperBound and lowerBound for an attribut with Property Type "Bounded value" defined with the IFCPropertySetDefinitionCreator. (see below)  How to set the domain (value range) for the PropertyType "Bounded Value" ? Is it possible to set de upper and lowerBound with FME?   The definition of the attribute value is already defined by using the attribute creator. (see below) Test_Attribut_03 = 'test'   Best regards LuHu

 Hi, i like to define the permissible values for attributs with Property Type = "Enumerated Value" defined with the IFCPropertySetDefinitionCreator. (see below)  How to set a liste of permissible values for the PropertyType "Bounded Value" ? Is it possible to set de upper and lowerBound with FME?   The definition of the attribute value is already defined by using the attribute creator. (see below) Test_Attribut_21 = 'Testwert 21'  Best regards LuHu

Hello Community, i'm struggling with this Question:Is it possible to write a B3DM-File (Writer: Cesium 3D Tiles)from "KMZ with Textures" to "Cesium 3D Tiles WITHOUT Textures" ? If the answer is YES - How should my workbench look ? With best regardsMichael.

This is probably a simple question to many of you. I wonder is there a way to read multiple feature classes in one reader (from a single file geodatabase), put DateTimeStamper on it in one single transformer, and split out multiple feature classes in one dynamic writer?Please see my attached file. I would like my writer to have 991 features for the AGG_Inspector_Juris, 5630 features for the AGGSite_Authorized_Active and so on. I don't want to have merging features of 8988 in each of the 3 feature classes.I understand that I can do a one to one (Reader, DateTimeStampler > Writer). However, it would save me so much time if I can just add one transformer to this tool and then somehow split them to appropriate tables.

What transformer would I use to query an AutoCAD file's paperspace properties (specifically the MVIEW viewport's WCS xy center point, the viewport height and width, and the custom scale)? I don't need any of the graphics features per se, just the viewport information to construct a minimum bounding polygon for the plot-displayable "meat" of the drawing file?

Hi, When I start FME Desktop Oracle Edition (floating) (FME(R) 2018.1.0.0 (20180717 - Build 18520 - WIN32)) I can see all my Oracle readers and make use of them. But when I quit FME Deskktop, start SQL Developer and then start FME Desktop again. The readers are greyed out. At this moment I am unbale to make use of the Oracle readers. Is this a bug? Is there a solution? Kind regards,Lucien Davids

Hi All, I could use some assistance on the problem I am facing. The data I have looks something like this. R-AMT517 C-ACB941, C-ACB942, C-ACB943 I want it to look like this. R-AMT517 C-ACB941 R-AMT517 C-ACB942 R-AMT517 C-ACB943 How would I go about doing that?  Regards,  Sahil

Hi fme guys ;-)  I have to create an export tool that will have as reader an excel file... The problem is that the worksheet used won't have the same name everytime...  The structure will remain the same... It's only the name of the worksheet that changes...  My question is, how could I handle this problem... Thanks for you help...

I am trying to work out the actual scale of the viewport(s) in AutoCAD DWG to make sure they conform to a particular scale. Attached is an example DWG that I am trying to determine the scale of the viewport. Any assistance would be greatly appreciated. Regards Dean

Hey folks, Happy New Year.I'm performing a very simple data conversion but something "bug like" seems to have cropped up in FME.I have a DXF file created by QGIS v 3.4.2I wanted to then open this in AutoCAD LT 2019. For some reason this failed a couple of times AutoDESK are looking into it.Anyway I whipped out my trusty FME 2018.0 and performed a really simple DXF > DWG conversion. No DWGStyler.This worked faultlessly except I got a lot of hatches along with the polygons.So I added a DWGstyler. The only setting is "Area" as polygons. No other styles or templates.When I went to open the DWG this time in AutoCAD I got the following dialog.If I accept this, the DWG I get does indeed have the hatches suppressed but since the writer came from FME I'm wondering what bit is being set incorrectly to have it being detected as a "Student Version" of the drawing?Research on similar issues related to DWG's being "infected" with objects from Ed

Hi, I'm rather new to the INSPIRE data format but basically what I'm trying to do is to create some natural risk and natural hazard maps (floods) that are INSPIRE compliant. Preferably I would like to store them as coverages (which is basically the INSPIRE raster format if I understand it correctly). When I try to add the RiskCoverage and HazardCoverage feature types I notice that the Hazard Coverage is present but only in the theme 'NaturalRiskCore (v3.0)', not in NaturalRiskCore (v4.0). The RiskCoverage feature type is not present in either themes. The RiskZone and HazardCoverage feature types (both used for vector data) were always present. From the INSPIRE data specifications website I was able to download the latest xsd schema. (I've added the xsd content as a plain text file to this question because FMEpedia does not allow me to add xsds as attachments)https://inspire.ec.europa.eu/Themes/140/2892I've checked the content and the RiskCoverage is specified. H