Using readers and writers to extract and load data.
Recently active
p { margin-bottom: 0.25cm; line-height: 120%; }I would like to get the value of a specific attribute of an IFC data (data from BIM software). Whereas I can see this attribute in the "feature information" window in the inspector, I cannot see it in the user attribute tab or in the format attribute tab of the "feature type" window in the workbench. Thanks for any help.
We are having problems with certain IFC Parameter data not being available. The IFC Exporter has been installed and all settings correct, but some shared parameters in Revit are not coming through into the FME Data Inspector. Is anyone having the same problem?
Is it possible to use FME to convert a SQL MapInfo database into an ESRI SQL database? What are the steps needed to complete this task?
I'm trying to convert an ASTM e57 file to LAS, and retain the e57 station IDs as the LAS Point Source ID attribute. Is there a way to do this? Thanks!
I am having trouble converting the dwg/CAD file to a file geodatabase. I convert it to a shapefile; there is no problem. Any ideas whats going on?This file a has plan layouts of a building. It shows floor plans for 3 different floors.See attached file
Hi,if you try to write aggregates in AutoCAD you'll get block, which is kind of unwieldly, especially if you need to modify geometries in AutoCAD.As it looks like groups can't be written (only read) using FME.I'd like to ask you, what are your experiences with this. Are there some other workarounds...Thanks in advance,Želimir
I have a .OSM file of Australia.I can extract the roads by choosing the Feature Type "highway"But the result is missing the names of the roads.How do I get the names of the roads?I do get the type of road as an attribute, for example; "residential", "secondary", "tertiary"But I want the name of the road as well.
Is it possible to write Autocad groups to dwg.I have tried the available format_attributes.Setting these on objects causes them to not be written, other objects do.Any tips or hints?(NOT talking about reading groups )
Hi I would like to output only the rejected records on each transformer output to a CSV file, and also write total count of invalid records.Any suggestion what's the best way to achieve this?
I am trying to output CSV files to a specific directory structure like so:directory1/ bike/ ride_log.csv bike_features.csvdirectory2/ bike/ customers.csv When I run the Data Download job the resulting file structure in the output zip file looks like this:directory1/ bike/ ride_log.csv bike_features.csvdirectory2/ 2/ customers.csvThe CSV features ride_log and bike_features belong to the same CSV writer: bike_1, and the customers feature belongs to a CSV writer: bike_2.The bike_1 and bike_2 writers have Dataset Fanout applied based on an attribute named 'directory' which gets set to 'bike' in the transformation process of all three features. There is also a prefix directory set for bike_1 as 'directory1', and a prefix directory for bike_2 as 'directory2'. Both features have their output directory linked to $FME_SERVER_DEST_DIR, which as an FME server parameter is set to \. So how can I get the same folder name in two different subdirectories when using fanout
Hello all,I have an incredibly weird issue....Running the workspace from FME Desktop, and running manually via Server there is no issues at all. When the workspace runs via a schedule nightly it is writing files into different folders...FME Desktop and Manual Server run - \\\\server\\folder\\folder\\folder 1On server via a schedule - \\\\server\\folder\\folder\\folder 2 I have deleted the schedule and added a new one but the same issue occurs, and it is only for this workspace.Any ideas..?
Hello, my goal is to delete a previous' week file from google drive and upload the file of the current week on a weekly basis. The file name changes weekly. This week I would like to delete report_201729.xls and upload report_201730.xls, next week it would be report_201730.xls to delete and report_201731.xls to upload. The upload is working fine with the Google Drive Connector transformer of FME 2017, but I have troubles to delete the previous' week file. The transformer doesn't have a file name option, only an Object-ID, but this ID changes weekly. How can I solve this problem? Thanks!
Good afternoonOnce again i find myself trying to do something relatively simple in FME and failing miserably. Frustrating doesn't come into it.I have an excel spreadsheet with multiple worksheets, each one populated with planning data.I would like to end up with one spreadsheet for each of the individual worksheets, so i can then use them for some other work with some spatial tables.When i add the excel writer, i'm given the option of all the worksheets, which i select, then attach them to the corresponding reader. But the resulting output spreadsheet contains all the worksheets in one worksheet.Have tried the fanout option to no avail.Have tried adding the source spreadsheet as a a workspace resource, with all the worksheets selected, again, to no availI'm sure this is a simple thing to do in FME, but it's currently beyond me. Any advice would be gratefully appreciatedregardsSimon Hume
Hello Everybody, I have seen some examples to open geodatabase metadata directly in FME using Feature Type Mode (metadata) but I cannot see this in FME 2016 version. I want to open the metadata of a SQL server based feature class/table's in FME and want to export it into our own metadata schema. Please guide me. Thanks
I have an ESRI Feature Class with 4000 records, of staff and the location they are each based at, in a field "Location." So for arguments sake, there are 50 different locations. What I would like to do is symbolise in ArcMap using proportional symbols the number of staff at each location. Is there a way in FME that I can set up the Feature Class to enable me to do this ? So for example, say of the 4000 staff records there are 1000 based in London (simply populated "London" in the "Location" field) then I wish to then symbolise this proportionally (based on that 100 figure), and likewise for other cities too.Thanks
Hi guys,I'm trying some autocad text features formatting. So, I have a number of text features at their insertion coords. I want those to be formatted like they are aligned in some text editor and I want it in DWG output if possible. I have:100 200 390 420 210 333Of course, this is only a sketch. There can be up to 300-400 text feaures at their locations.I want them to be aligned like this:100200390420etc.Possibly in DWG format. If not possible, some other solution that can be copied to DWG is also an option.Thanks in advance.Best regards
HI, i am hoping someone is able to help me.I am building a html output and i am using the fanout expression to build individual html documents. My question is does the fanout expression need to have values from within the html content or can i use attributes from a attribute manager to set the fan out expression?hope that makes sense
I'm using the Cesium 3D Tiles Writer to export some CityGML data to Cesium. Although I can export and interact with entire buildings, I would like to model and interact with buildings as a hierarchy of individual parts (e.g. walls, roofs, etc.). The 3D tiles spec appears to support specifying such relations in the batch table (https://github.com/AnalyticalGraphicsInc/3d-tiles/tree/master/TileFormats/BatchTable#batch-table-hierarchy).I'm looking to achieve something similar to this: https://cesiumjs.org/Cesium/Apps/Sandcastle/index.html?src=3D%20Tiles%20Batch%20Table%20Hierarchy.html&label;=3D%20TilesI've looked and can't find any information on how to write this type of information to the tiles using FME. Does anyone know if this possible using FME? Are there any examples or documentation I could use?
I am just one week into FME (a friend recommended it to me)I want to loop through a 761,000 rows by 25 columns excel document, for the each rowcount columns with values>0 and store in a column called countfor the values > 0, add them and store in a new column called anim_locreturn the names of the column title that has values greater than zero and store in a column called anim_namesPlease how can i achieve these with FME.
Good morning.This week has been released the new INSPIRE validator:http://inspire-sandbox.jrc.ec.europa.eu/validatorThis tool allows you to validate a GML file.I have several GML that I got using the INSPIRE GML writer in FME. To validate them, I just checked them against the XSD provided by INSPIRE. That validation was always OK.But with the new validator I'm getting this error:cvc-elt.1.a: Cannot find the declaration of element 'gml:FeatureCollection'. I have attached a sample of my GML. There is a FeatureCollection tag...Does anyone know if I have to change something of the INSPIRE GML writer to build a proper FeatureCollection?Thanks!
My workflow is pretty easy, I drag and drop a CityGML file in the workbench and then add a CityGML writer and connect it. FME proudly tells me it wrote features, but when I open the file there's no geometry. Do I have to add a bunch of transformers?Variations tried on reader:- all features- single mergedVariations tried so far on writer (feature type definition):- all of themMore info:- the source CityGML file is fine and displays without errors in the inspector- no errors are reported during the translation
Hi Team,I have a simple example attached and it contain just a Reader and i would like to generate another shapefile.The problem is: the Writer ( using the transformer FeatureWriter ) needs contain one Attribute:@Value(De_Produto) I tested to get the value from the source attribute De_Produto configurating the Writer, but without success:How can i get the value attribute and transform the value this attribute as Attribute Name my Writer?Thanks in Advance,Danilo
I have a shapefile that I need to convert to JPG. The shape file has an attribute with values ranging form 90 to 130. I need to give different colors for this attributes in JPG based on the following criteria90 to 100100 to 110110 to 130I tried using image rasteriser, it shows "This format cannot support more than 3 bands. Please remove the extra bands and try again"I am new to FME so please explain it even if its a trivial question