Data

The 32-bit installer for beta build 18254 is not working, see this question. Could somebody from Safe look into this?

Hi Team,Can you please let me know if FME can write data into SDE geodatabase or not.I need to automate spatial data creation process.My sde geodatabase is in Oracle. SDE/ESRI version is 9.3.1, Geometry storage is SDE binary (BLOB) and feature dataset has geometric network.Please share your expert views and any details which you can provide.Many ThanksManoj

Hi, I am currently using the AzureBlobUploader to try and uploading it to Microsoft Azure blob storage. At first, my workbench was working fine (it uploaded the files to blob storage) but after a few successful attempts, it no longer works? I now get an error [Errno 2] No such file or directory: u'C:\\\\Users\\\\aileen\\\\AppData\\\\Roaming\\\\Safe Software\\\\FME\\\\FME Store\\\\Transformers/New\\\\Missing_BT_links.csv' Any ideas on how to rectify this would be greatly appreciated. Thank you, Aileen

I'm testing my current workspaces in FME 2018 Beta and i'm getting a new warning from an Excel Writer. WARN |Excel Writer: Attribute xlsx_row_formatting is empty, no row formatting applied  It doesn't seem like this warning is anything to be concerned about but i'd like to make any changes possible to prevent it from showing up as many times as it does while running. I can't seem to locate the much documentation on the xlsx_row_formatting attribute, so i'm wondering, is there any way to populate it to prevent the warning? Thanks! 

I have a kml with the attributes 'kml_additional_files{0}.href' and 'kml_additional_files{0}.path' filled with filenames and -paths. I want to place the locations (points) as objects in a local database with the filename(s) in an attribute to these locations. But I can't find how to do this.I'm using FME desktop 2017.1

I am working on AIXM 5.1 task. the task is to convert and map a GIS data to AIXM format for eToD.I have mapped the feature but I have an issue with message metadata and feature metadata like EX_Extent,nameofmeasure and dataStamp .Any idea how to map it .

We are running FME desktop 2017 and are struggling to do a custom number format that will show the 'pound' symbol when writing to a new Excel sheet. shows a '?' symbol instead. the doller '$' works fine. We have changed the font to Arial and checked the character encode and it still wont display the £.

Hi,I want to read the following attributes related to symbology from a CAD file and want to store it in Single Attribute by using Json Packer and want to store it into File Geodatabase. Color: Color Template: Template File Source Blocks–> Block Name, Block Rotation, Block Size By, X, Y, Z Lines–> Line Type, Line Type Generation, Line weight, Line Scale, Line Elevation, Area–> Area Entity Type, Fill Pattern Name (if Gradient), Pattern Scale, Gradient Name, Gradient Fill Color 1, Fill Color 2, Fill angle, Fill Origin x, Fill Origin Y. Text–>Text Entity Type, True Type Font Name, Text Shape Name, Text Justification, Text Size, Text Rotation, Text.I also want to use these attributes by unpacking it in DWG Styler in some another workflow.Can help in this?Thanks in advance. Appreciate your quick support.

I have a set of nodes on this format:<node lat="56.07686365" lon="12.11483240" id="800000002" changeset="1" timestamp="2017-09-10T20:50:35.826Z" version="1">  <tag k="ActiveFrom" v="1900-01-01T02:00:00.000000000Z"/>  <tag k="ActiveTo" v="3000-01-01T01:59:59.000000000Z"/>  <tag k="ProductionPointCategory" v="4"/></node>When I read them in to the OSM reader as basic nodes, I get a list of tag{}.k and tag{}.v. I want to do some light filtering on this data, mainly checking if they exist in another dataset.Thereafter, I want to write them back to the same format that they came from. However, if I just connect the reader straight to the writer, it doesn't write out any of the content of the tag-list. I have to expose all the attributes that I want to be written, which seems like a backwards idea since the information is already there in the key-part of the tag-list.Is there a way to get the writer to write the contents of the tag-list, without me manually expos

I am Testing for matches json.ID against SDE db sde.ID. The problem is no matches yet there are 26 matches in the test case. I think I have a data typing error. The sde.ID is VARCHAR2 (30 Byte) and I assume the json.ID is data source json. ANyway to covert to get a matchup??

Since I am new to FME I have no idea if this is even possible. I have an Access database that contains projects that are related to specific AutoCAD drawing located in the project folder. I want to create a KML file showing not only place markers (with attribute table in it) for each project but also DWG route. Place markers are easy to do, already done it but I am having trouble figuring out how to implement AutoCAD drawings. Is it possible to do it through Access database , or I have to use separate Reader for DWG files.Thank you

Hi There!We are having issues with the Google Sheets Writer timing out and failing. I worked with someone in Support & they were really helpful - but we didn't solve it. My boss was wondering - could it be a firewall issue on our side, and if so what ports need to be opened up to communicate? Thanks so much! Christen

Hi, I'm new to FME and I'm wondering if FME supports connections to Civil 3D survey databases? This would be helpful for syncing attributes in a projects survey database with other databases. More specifically point data in survey databases for my needs.I know Autodesk added a survey api in 2017 and they've upgraded the file type of the survey database in 2018. Project survey databases reside in the project folder and use data shortcuts in Civil 3D to connect the database to the projects drawings. The database is a Microsoft® SQL Server® Compact 3.5 database. New and converted survey database files for 2018 have the file extensions SDBX and SDXX.

I have a 3D gis file need to be converted to IFC format to analyse in Ansys. I had tried with FME, however the output files always has no geometry in it. How can I make it? Thank you

Hi,I have an FME Workbench that is writing to a dynamic schema.I have set the fme_feature_type and fme_feature_type_name explicitly using an AttributeCreator, but I keep getting this error when trying to write to an Excel spreadsheet:XLSX Writer: No DEF line could be found for feature type Does anyone have any ideas as to what this error means and how to solve it?I also get the following warning prior to the error, if this helps:Cannot define schema for 'RP_100CC' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration. I am using FME Desktop 2017.1 64 Bit.Thanks

I am using a FeatureReader to read specific JPEG images, on desktop it works fine, brings in the JPEG. Once i publish this to FME server i get:JPEG reader: file '"\\pathname\\filename.JPG"' cannot be located. Please ensure the file exists and is accessibleI know that the path\\filename are correct, and i can go onto the server and access this location and image without any problems.Any ideas why it can't access it when running the workspace on server though?Just to also add each image has a .jpg, .jgw and a .xml part to it.

Hi Team,I have 7 million records coming out from source and i need to write to two databases simultaneously. why simultaneous:if i write one writer and the second writer will be waiting first one to complete. And in between memory issue comes and fme hangs or stops abruptly.so I need to write to two databases at a time. need serial connection to the writers.not parallel.can anyone please help me.

I have been Working with Esri Shape 2,5D and transforming them into IFC. I have follow the CADtoIFC example but i will like to have the buildings in ifcBuilding because i don't have any information about the wall, Slab or RoofI generate an Area(polygon) from a lines then use Extrude to get the height of the building, aggregate sam attributes to the Polygon, then use GeometryPropertySetter /Geometry Name="Body"the IFC file look like thisand just after Aggregator_5 in FME DATA Inspector look like thisAs you can see is missing one building and a part of the roof is wrong have anyone know how to fix this or what can be the problem?

Currently using AutoCAD 2017. Have a customer who needs shapefiles for a county dwg. I know these can be created in AutoCAD Map. Do you have a software that does this? If so can you briefly tell me what is does? Also what is the cost?

I want to modify which attributes I get when reading OSM data.For example I want to see the "generator:source" tag as an attribute in the power feature.I can add it as an atribute to all features by adding it to the list of attributes near the top of "fme_map_features_config.xml" as follows:<fme_osm_config> <add> <geom_type name="aggregate"></geom_type> <geom_type ..... <attribute name="id" type="string"></attribute> <attribute name="timestamp" type="string"></attribute> <attribute name ........my addition->   <attribute name="generator:source" type="string"></attribute>But there is a section further down for the power feature that looks like this: <key k="power"> <value v="cable"></value> <value v="cable_distribution_cabinet"></value> <value v="catenary_mast"></value> <value ...... </key>Can I edit this section so that "generator:source" appears as an attrib

I have oracle table that needs to be exported to excelthe table has 1 column that has multiple lineExcel Writer is good enough to make it into 1 line automatically. But the 2 words that separated by New Line or Carriage Return became 1 word instead split it with single space.For Example an address Column:"Hello  World"Excel Write put it in 1 cell "HelloWorld"no space between "Hello" and World" How to tell Excel Writer not to do that ?Expected Result "Hello World" with space in the middle 

HI FMEI got this error while writing to Neo4J through JDBC, I thought it was supported ?https://www.safe.com/solutions/jdbc-support/Creating writer for format: JDBC (Java Database Connectivity)Trying to find a JAVA plugin for writer named `JDBC'FME Configuration: No destination coordinate system setUsing Java Writer Interface Version 2.0 (Oct 31, 2000) with module JDBC to write data to dataset `jdbc:neo4j:http:<solidus><solidus>localhost:7474<solidus>'Writer `JDBC_1' of type `JDBC' using group definition keyword `JDBC_1_DEF'JDBC Writer: Creating connection using connection string 'jdbc:neo4j:http://localhost:7474/' and properties '{user=neo4j, password=************}'JDBC Writer: If the desired JDBC driver was recently installed, restart FME and try againjava.sql.SQLException: No suitable driver found for jdbc:neo4j:http://localhost:7474/ at java.sql.DriverManager.getConnection(DriverManager.java:689)java.sql.SQLException: No suita

Hello,I'm having some problems with making LOD2 roofs and buildings from my point clouds. I don't have much experience with FME yet, so some tutorials are hard to understand yet. The point cloud is areal and LAS format. I also have a DWG building outline file, but it does not include the height or elevation of the buildings. I have tried this tutorial, but I could'nt get it to work properly. I have tried the alternative method, but I have no idea where I should implement it. I really like some help with my project. I'm new at FME and don't really know a lot of the tools and tricks, but I'm eager to learn. Thanks in advance.

We are currently upgrading our Smallworld from 422 to 5.1.X and I am trying to get the existing FME 2014sp4 fmw files to work correctly. They will run (the text and lines translate) but it appears that the Smallworld mapped Geometries for our points that are in the fmw file are not recognized. I also tried creating a new simple fme workspace (In 2014sp4 and 2017.1.1.1) and when the reader comes back with a list of Smallworld geometries none of the mapped geometries are available. Are there any know problems with Mapped Geometries and Smallworld 5.1.X. Any help would be appreciated. Thanks

Hi, I would like to convert a Map info table file into a TIFF file but it doesn't work ! Can't you help me please