Data

I have a workspace in which I have selected a CSV file writer to contain the results. The user parameters selected to be written appear in the CSV file. On the other hand, the format attribute (fme_text_string) I have selected does not appear in the CSV. All the results appear in the data inspector, and for a workaround I am forced to select the data in the table and save it to a file from there.What am I doing wrong?

I spent most of today struggling trying to get a Socrata SODA API dataset to an ESRI file geodatabase. I am able to read the data using the text reader and this url as the source:https://chhs.data.ca.gov/resource/c2p3-ahn4.json?$where=county_name%20=%20%27ALAMEDA%27&$limit=5 This is valid JSON according to JSON lint, but no geometry is recognized because it isn't in a GEOJSON format. I have tried using the JSONFragmenter/JSONExtractor/JSONUpdater transformation tools but just can't get the hang of it.  I am using the Data Interoperability extension for ArcGIS. Any help is appreciated. 

The title says it all. Directly you can not upload these workbenches. But maybe using the FMEServerJobsubmitter. The password is then passed using published-parameter. You could upload a dummy workbench with the same name and exchange these directly on the FME server against the password protected Workbench. Or are there other tricks?

Hi,we´re having a AGOL account were we would like to put other stuff beside naps, layers, applications etc. It would be nice if it would be possible to write / upload a PDF or DWG file (item) to a specific content folder / group, so that our users easily could access this information in one place. Using the AGOL writer it seems that it´s only possible to select folders with feature services in?Christian

Hi, How can i extract feature service from arcgis online. I've feature service that i want to pull them down to local file geodatabase using fme. Kindly help

I'm a GIS guy and new to MongoDB. I'm trying to use FME to read and analyze data in a Mongo database. The collection I'm trying to read has 10 million plus records so I'd like to be able to filter that down to a subset for testing. If this was an Oracle or ArcGIS reader I'd place a SQL whereclause on the reader to limit what FME starts with. On the MongoDB reader I don't see a whereclause option. I see a Collection Qualifer and a JSON query parameter on the Feature Type window, so is this where I would apply a MongoDB filter? I tried entering so MongoDB'ish find() code in this but it doesn't work, so maybe I'm entering it wrong.To simplify an example, here's what I'd like to do on my reader in SQL:select * from MyTable where MyStringField = 'MyClassification' And here's the Mongo translation of the same thing:db.MyTable.find({ "MyStringField": "MyClassification" });Now I'm left figuring out how to

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