Data

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

Folks,I've been converting Mapinfo to AutoCAD and largely successful. I have a fully defined template drawing I need to adhere to so I have almost no flexibility. I have successfully labeled lines with an attribute. However I'm tasked with the requirment to repeat a label at some defined interval along the length of a very long line.Is there a convenient way to have a repeating label text along a line with a "distance" parameter?

I am currently looking for a solution to change my data set (Excel) into multiple Excel files using a template file. Each file(or tab) should contain information about one tree. The data set contains data about 250 trees (ID, name, year planted, height, LAI and photolink number). I made an excel file with a nice format that looks something like this:Tree research information fact sheet:Name:Year:Age:an Excel formula generating the current ageHeight (m):LAI:  I'm currently using a template file and know how to format the data to the correct font type but can not find how you add the information for attribute to write to the the specific cell. Tree 1 Tree research information fact sheet:Name:Quercus roburYear:1942Age:an Excel formula generating the current ageHeight (m):15LAI:3and so on for all the other 249 records.Short question:How can i write the information of one record to specific cells in Excel so that it fits in my format.

I have a TIFF file I am converting from 32Real to JP2 16Uint. The TIFF has NoData = -9999. I run a RasterCellValueReplacer to change -9999 to 0 and set NoData to Yes. Next is the RasterBandInterpretationCoercer to make it a 16UInt. When run, the JP2 has edge chatter with pixel values that were NoData now having values from 1 to 10. What is causing this edge chatter and how do I remove it?

My source data is the multipatch model data in ESRI File GDB format, I use FME to convert it to Cesium 3d tiles one by one, everything is good, but the generated b3dm no attributes, how can I solve??if i don't convert it totally?the b3dm file contains attributes,but the models are not Seperated?

hi, i installed the fme server version 2017.01 in Ubuntu 16.04, the server can start, and I can access the system from localhost:80?but when i run the fme server console in Clients/FMEServerConsole?i got the errror "error while loading shared libraries, libboost_filesystem-fme.so.1.58.0: cannot open shared project file: No such file or directory", i have not got any satisfied answers from google, anyone can help? thanks.

Hi all,I'm currently having some trouble updating a file geodatabase. I have a workspace that uses a regex to create individual feature classes in a file geodatabase. I have set the 'Feature Class or Table Name' in the writer to:@ReplaceRegEx(@Value(Actual_URL),^.+/(.+?)\.zip$,\1) It works fine on the first run but when I try to run the workspace a second time with 'Overwrite Existing Geodatabase: Yes' it gives me the following error:"Unable to connect to the File Geodatabase at 'C:\Test.gdb'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147024894'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for details" From what I've read here it may be because the overwrite relies on the spatial indexing from the original file geodatabase. Perhaps there is a workaround where I can set the workspace to delete the

I am trying to convert shp file to cityGML. In shapefile I have building footprints with attributes "storey" as number of storeys. I want to match this attribute to number of storeys attributes of cityGML buildings class. How can I make this?

With great help from the folks here I've started being productive in writing Mapinfo tables to DWG. However I've run into a problem writing text.I have a number of layers that need to have labels applied. One is a polygon layer. The goal is to write a piece of text in the centroid.To achieve this I've used a LabelPointReplacer to get the something like the centroid. From here it gets bit weird.For the life of me I cannot get the labels to orient with zero(0) rotation. Initially the label wanted to align with the first vector in the polygon so that was understandable.I tried to overcome this by using a DWGStyler but this seems to have no effect.My suspicion is that my source tables are Lat\\Long and the CAD is GRID projected. However there must be a way to set the rotation to CAD zero.Any assistance appreciated.

Hi everyone,I wonder if there is a possibility to figure out the drawing order of features within an AutoCAD-Layer. I haven't found any format-attributes about that.kind regards,Thomas