Data

I'm reading a couple of CSVs using the CSV2 Reader in FME 2017.0 then passing the data through AttributeManager. When it gets there, this appears in the log file: 2017-04-20 14:07:14| 89.6| 1.3|WARN |AttributeManager(AttrSetFactory): Splitting feature table into features because this factory does not support feature tablesCan someone explain what this means? Is it something to do with CSV2?

To enjoy multiusers editing environment, our data is stored in mdf files (enterprise). However, when it comes to publishing, we convert the mdf to gdb in order to gain some performance as the services that read from gdb are much faster than those read from mdf. We are wondering if there is a generic tool that can convert multiple mdf files to gdb. Thank youBestRawan

Hi all, I've got a workbench where I'm trying to convert a series of dgns to a geodatabase. I have used the tester to filter out the colour white (which is the title block, the dgns are 20 years old) and then I've used a geometry filter to filter by 'area' so that I only get the polygons I need. The inspector gives me exactly what I want except that I now need to made the 'fme_color(string)' an attribute, for example I would like green (0,1,0) to be freehold in my geodatabase attribute table. Can anybody help me out? Thanks

I am translating V8I Cells with embedded Text Nodes to V8i. The Text in the text node is not translating. The text node is being nulled out. Is there a transformer that I can use that will allow me to keep the text and use it in the new cell with an embedded text node?

I have successfully managed to add a jpg to a TIN surface using a jpeg, appearance styler and appearance adder. When I swap in a png, with the same extent, (perhaps any image with transparency?) it no longer works. I get a black surface, or sometimes a silver one.

New to FME. I roughly know the first half, i.e. extract data to csv file is simple. But how to get the csv writer to trigger the next step of the workflow to upload it to s3 bucket? The writer has no output. Thanks!

Edit Text File parameters In a workbench that reads messages from waterway users I will join weather info based on date and time to those messages. Most off these messages concern cases off near misses (interaction of ships or ships and infrastructure). Weather info like wind, winddirection and visibility are important parameters for further analyses. With a Text File reader I make a connection to our weather institute and get hour data from the datacenter. So every night I read the messages from the day before and the idea is to join the weather info from the same day. In the source text file one of the parameters is the start date from where the weather data is read (in this case 20170411 and start hour is 01, see png). So what I want is to make the start date variable and depending of the actual date, I will only read the last 2 days of weather data! Is it possible to make the start date variable in this case? I use FME desktop 2015 but will also publish the workspace at FME serve

How can i read the DIMENSION parameter of a DGN to determine if a dgn file is 3D file or 2D file. We have a lot of dgn files and would like to find a way to identify the files which are 3D. Is there a way to do this? Please see the screenshot below from FME data inspector. I would like to read the property highlighted in red color and make a decision if the file is 3D or 2D.  Thank you. 

I have read an article on the forum entitled Writing Microstation (DGN) Text Nodes with FME but after trying to understand all of the multiple items needed demonstrated in that article, I can't get text nodes to write properly into Microstation using FME. The DWG's are so nice in that they write multi-line text perfectly but Microstation just goes crazy. Is there a simpler way to write them? Whenever I do, they lose a lot of the linkages and no matter what I do I can't get the text to recognize carriage returns or new lines. Can somebody help me?

Hi,i am trying to read a segy file.the coordinate are ok but the attribute no.They show weird character (maybe encoding?)How can i configure that? I can't find any option on segy reader.Is this possible?Thanks.

I am converting Microstation DGN to AutoCAD DWG drawings. One thing I'm trying to translate exactly is the text insertion point and horizontal alignment. While the values come through exactly, visually, some of the text don't match. I have the following mapped:igds_original_justification -> autocad_justificationigds_insertion_x -> autocad_alignment_xigds_insertion_y -> autocad_alignment_yAnd conditional values set for the following:autocad_width_factorautocad_shape_nameOne thing I noticed is in Microstation, one can set both text height and text width. For DWG, the text width seems to assume the height (or size) value. See the attachment for the difference in the alignment:I'm hoping the alignment issue will be resolved if the width is the same as in DGN. Is it possible at all to set text width for DWG?Is there any other way I can get the alignment to match perfectly?Thank you.

First post ever!I am exporting from Revit (RVZ) to FME and finally importing the ESRI Shape file into ArcMap. The problem I am getting is that I cannot get the Revit instance parameter "Mark" to eventually show up in ArcMap.I've tried many options but have not succeeded. Please help!!!Thank you

Revit to 2D Floorplan

Hi,I'm using FME Server (2016.1) to read a text file using the TEXTLINE reader, but it appears to be caching the contents of the file - it's stuck on a version of the file from a week ago.Does anyone know how I can turn off the caching?Thanks!Roland.

Hi there,I'm having some trouble with performing conditional checks on some shape files I have. Basically, this is what my input looks like:CityDistrictAA1A2BC C1DEWhat I want do do is exclude Cities with blank districts IF they have entries where District is present, but Cities that only have one blank entry should be kept. In this case, I want to keep A1; A2; Bblank; C1; Dblank; and Eblank, whilst removing Ablank and Cblank.I tried toying with using a tester an making it a composite test, but I have no idea how to use the correct expression.Thanks in advance,Robbie

Hi,is it possible to install PostgreSQL to non-standard port (5432) during FME installation?

Hi,A dinosaur has raised its head from the tar pit! We've been given a set of Paradox data tables to import.As far as I remember, it was something that the long-time retired Borland Database Engine (BDE) could access, but how do you read such data in this day and age (if at all) ? Preferably directly with FME of course.I was happy to find a Paradox ODBC driver from Microsoft in my Windows, but it doesn't seem like it's capable of reading any of the provided table files (DB, and MB) :-(Do anyone here have any insights on this issue they want to share ?CheersLars I.

Hello FME community, Can someone help me with this error message on FME Server ?"Excel Reader: Failed to open dataset '<filepath>'. Error message was: 'damaged or not a zip file.'I run a workspace on FME Server which reads an Excel-file (.xlsx), but FME Server reports that the input Excel file is zipped or corrupt. Although, the Excel file exists on that particular location and is not corrupt or zipped. The file is published with the workspace so it's on the same directory on server.I don't get this error when I run the process on my local computer.Dries

Hi,I am trying to set the Writer Destination folder to dynamically or automatically set to the location of the Reader Source folder but I am not having much luck.I thought the easiest approach would be to use the FilenamePartExtractor and set the _dirpath as the attribute value or user parameter of the Destination folder but it doesn't work.Does anyone know the best way to set these parameters in FME?ThanksAndrew

Hi, I'm simply trying to write a summary list of the layers used in all dwgs in a folder to excel. The workbench will do this to inspector but not xls but I can't figure out what's going wrong, any hints?

Hello,I am trying to read or write the various text attributes such as "Title" or "Comments" listed in Microstation under File -> Properties. I have checked all format attributes in my DGN Reader as well as trying different reader parameters to get the attribute to show up in my inspector - no luck so far.Is there some way to read these as FME attributes?Thanks in Advance 

I am attempting to write lines and polygons to an SDE annotation feature class. If I create the annotation feature class without a custom field this works fine. But, if I add any custom field to the annotation feature class FME crashes when its starts writing. I am using FME Desktop 2016.1.1.0 build 16609 32-bit if that makes a difference.I did the same operation but writing to a File Geodatabase and get the same result.If the input data is annotation instead of lines or polygons writing to custom fields works fine.Any trick to get this to work? Is this a known issue?

Hello,Lets say I have given JSON structure being passed to FME workspace as a published parameter value:{ "users": [{"user":"John", "age":"33"} ],"otherParameters" : [ {"name":"parameter1", "value":"NULL"}, {"name":"parameter2", "value":"NULL"}]}It may contain different users and otherParametersI would like to add a transformer/tester at the begining of the workspace flow so that if in the json there is a user with the name John and age 33 then do some things and if tha age is different or for example users list is empty do others.What would be the best approach to do that? Thanks in advance.