Data

Hi all,A simple question for you but I am blocked...I have a dwg file containing multiple layers. I want to rename some of autocad_layer.Example : 1ROADS in the writer must be renamed in WAYSThank you for your help.

Good afternoon,I'm trying to write data to our companies Microsoft Azure SQL Database Non-Spatial database, but I keep getting an error saying "Microsoft Azure SQL Database Non-Spatial Writer: Existing table for feature type `Roads' does not have attribute with name `id'. Cannot continue" However, when I open up the Roads table inside the SQL database, I can see the field id. I've set the data type in the writer to match the SQL database type, and I still get the error. David

Hello ,I think this is the right place to get answer for my question I have Batch of Revit Files which are converted in to .rvz through FME Exporter Now i need to convert them in to .gdb using FME SoftwareI have a knowledge converting single files from .rvz to .gdb But am trying to do that in Batch processPlease help me to find out this process..Thanks in advance..

I am trying to convert a set of GML files (KuntaGML) to Shape but am slowly developing a head ache. The source files are each covering a part of the total area, lets call them blocks. Within these "XML-blocks" are a number of features/tables. I want to convert everything to Shape with one shape file for each feature . What is causing me problems is passing on the schema for each feature/table to the shape file, they are all different and there is upwards of 90 of them. The dynamic writer will pick the first schema it encounters and then run with that, but I need it to update for the subsequent files being written. I tried inserting a feature reader to detect the schema, but that was incredibly slow so I gave up. There is no .xsd-file so I can not go that route. Any ideas on how to solve this?

Hello,I have a building model in dwg format. Inside the DWG it contains layers(roads, walkways, buildings etc). When I convert this to SKP it all looks great, but it merges all the layers. Is there a way I can keep the layers seperate within the model?Thanks in advnace.Ash

The GEOM column in not read by the FME MSSQL Reader, and therefore it has been recommended to use the SQLExecutor to obtain the geometry. The transformer executes the SQL Statement for every row in the table, meaning that in my case with 1400 rows, the result is 1400*1400 in size.What is the easyest way to just get the GEOM column from an mssql databse?

Hi,So we had a sharepoint list reader working in 2017.0.1.1 on a local machine and from within a VM in Azure. We had to get the VM set up to allow the authentication to work, but it all worked in the end. Recently, upon coming back to this bit of work, we are getting 403 errors in both environments when trying to load the table list. I even tried off work network with 2017.1.2.0 and also get the 403 Error.We have people looking into it, but wondered if anyone else was experiencing issues, whether this could be a Microsoft patch issue for SharePoint Online, or if anyone knew how to resolve it? It could be a work configuration issue too, so will report back if anyone finds anything.Kind regards, John

Hi, I am trying to read some data that is stored in several subfolders in the FME share resource data folder. It seems like the process didn't like the wild card ie.. Data\\foldername\\**\\*.csvAny pointers/ work arounds?Thank you in advanced for any help you can provide.

I am new to FME. Although I can deduce how to use @value(Attribute) in a text editor in the workspace, I am not sure how the $ symbol is used and how it can be chained to say @value. Also are there other keywords with the @ symbol. Where in the documentation are all these symbols and their usage comprehensively defined and illustrated? Thanks.

It seems like core isn’t starting because the web interface is complaining about not being able to connect to core and running `sudo ./startServer.sh` results in this error:  ```Cannot open log file /opt/fmeserver/resources/logs/core/current/fmeprocessmonitorcore.log for writing, defaulting to standard error output```

Hi Everyone,I am writing to the AVF writer and then using the AVF reader in separate workbench. However, I noticed that there are two different naming conventions for Level _Ids under Sections category. See attached pictures. Is there a reason why they are different? I know that in the AVF Writer, it is a list, but the AVF Reader does not show it as a list. When I run the AVF reader in my workbench, level_id does not exist. I am using FME 2018. Thanks!David

Hi Guys,Did any one tried converting DRW files to DWG/DXF?Pratap

If we use a shape file reader in FME desktop we only need to pick the shp-file but not the other parts like dbf, shx etc. FME desktop recognizes all parts of the shape file and we can start our workflow.If we publish the same workspace to the server and use a published parameter for the shape file then we need to upload all parts of the shape file as a temporary data upload to FME server. If one of the parts is missing then our workflow will not run. How can we check (in advance?) if all necessary parts of a shape file were temporary uploaded to FME server?Best regards,Frank

Hello,I have a DGN file (Microstation v8) which stores spatial data elements (elements with XY coordinates). The elements are linked to an external database. I need to export the data from DGN file and join the exported data with its associated data in external database. I am using FME workbench with reader format as "Bentley MicroStation Design (V8)" and writer format as GeoJSON.When I redirect my output to FME data inspector, I see the linkage data in a field called "igds_linkage{0}.blob (encoded: fme-binary)". Sample value for this field is E06E00000000000000000000. The actual link value in the external database for this element is 28384 which is 6EE0 in Hex. I can get the same value by swapping the first two bytes of igds_linkage data i.e. from E06E to 6EE0.Now, my issue is that this data is visible in data inspector only. How do I export it into my output GeoJSON file?The field "igds_linkage{0}.blob" is a Format attribute of type char(255). I've c

In this drawing there is a block named:'Verkeerssignalering Mantelbuis (Lusconfiguratie)'How do I get this exposed in my FME Workbench? I have tried exploding, not exploding, merging exploded to not exploded etc.

Hi all.I've got a tab file that I run a few queries against it to pull out some values which based on a published parameter used for the query. The results are then written into an Excel tableIn this case the publish parameter ‘LEASE NAME’ used in the query has extracted the Collingwood 3 data from dataset. Seven records were extracted however I’d like to make those into a single record that contains data from each attribute where present. Additional I want to sum the values in the length columns.At the moment it looks like this.But I want it to look like this.What should I be doing to get this result? Thanks a heapMichael

I'm starting with background color as a test, since it takes html I thought this would change the balloon BG color but it's not working.  <html> <body bgcolor="#E6E6FA"> <img src="https://seamlessrnc.nauticalcharts.noaa.gov/rnc/noaa_ocs_small_banner.jpg"></a> <BalloonBGColor = '-1' BalloonFGColor = '-16777216' BalloonBGColorField = ''red" > </body> </html>  

How can I Convert an esri feature class to a KML and assign colors based on the attributes in the feature class  I have some line feature classes (roads) which have a condition rating and a color based on that rating. i would like to convert these feature classes to KML and assign them colors based on the condition rating. 

I get the following error when trying to access a Pervasive SQL databaseStarting translation... FME 2018.0.0.0 (20180308 - Build 18284 - WIN32) FME Database Edition (node locked-crc) Temporary License: 16 days left. Machine host name is: cmcclain Operating System: Microsoft Windows 10 64-bit (Build 16299) Copyright (c) 1994 - 2018, Safe Software Inc. Safe Software Inc.Creating reader for format: Pervasive PSQLTrying to find a DYNAMIC plugin for reader named `PERVASIVE'Loaded module 'PERVASIVE' from file 'C:\\apps\\FME\\plugins/FME_ADO.dll'FME API version of module 'PERVASIVE' matches current internal version (3.8 20180209)Pervasive Reader: Read 0 DEF line(s). Found 0 attribute(s)Pervasive Reader: Opening `mcsdb' for read operationPervasive Reader: Connection failed. Connection string `Provider=MSDASQL;DSN=mcsdb'.

I am trying to create a database connection to a SQL Server Express instance on an in network server, but I'm not having much luck. I have made sure the TCP/IP is enabled, the TCP Port is set to 1434, TCP Dynamic Port is empty (I have tried multiple options there as well). The SQL Server Browser service is running. I have restarted the SQL Server service. I am able to ping the server. Does anyone have any other suggestions to try. This is the error I receive. Thank you!

I am migrating from FME 2014 to FME2017x64. We have been using a workbench for some time in which the output includes writing to a number of excel template worksheets having defined ranges for the writer. In each case the option to truncate the range has been set to yes. When running the same workbench in 2017x64 I am now seeing that some worksheets/ranges are getting populated while the vast majority are not . I've been looking for something that indicates why some would get populated while others would not but have not been able to determine what that might be. Has anyone else experienced problems with excel writer in FME 2017 not writing to worksheet/ranges as they had in a previous version?

Hi All,I am trying to get the center point of a room without replacing the geometry, i.e using the center point replacer. When I use the Center Point Extractor to get the center point lat and long, the lat and long ends up in South America. I'm confused because the Revit file displays in Texas, which is correct. Can anyone help explain this?I am using the IFC reader to run the Revit file. The RefLat and Long are in Texas. Can this be caused by the Revit file Min and Max Reference coordinates? I'm thinking the vertices in the Revit file are not correct. I do not know Revit unfortunately, I only receive these files. If there something wrong with the file, or something that the Revit Technicians should fix, that would be great to know and understand. Any insight would be great!Thanks,David

AutoCAD DXF files created by FME are larger than those produced by other software packages. How we can reduce that. I have many dwg files to convert to DXF. Thank you

Hi all,I’ve a question regarding single sign on into FME Server.I’ve installed FME Server on a domain (let’s call it “Domain A”) and I’ve configured the SSO for the users in the Domain A. I’ve tried to log in on a client using right domain A account and then, using Internet Explorer, I’ve logged into FME Server in SSO mode and It works fine.Now I have another domain (let’s call it “Domain B”) trusted with Domain A in bidirectional mode.In FME Server I added the connection to the Domain B’s Active Directory and imported the users from this domain.I tried to log in on a client using right Domain B account and then, using Internet Explorer, I logged into FME Server in SSO mode but it not works.The returned message is “You are not authorized to access this web application”Can someone tell me if I need to set principal name, using the setspn command, also in the Domain B?Thanks in advanceRoberto