Data

I'm using five Excel readers that are pulling the spreadsheet data from a REST endpoint (URL). The purpose of the model is to combine all five spreadsheets into one output. They have the same schema. The issue I'm running into, is that the spreadsheets will all have a variable number of rows from week-to-week and when I specify the Cell Range in the Reader Parameters as (*:) the writer is still including all of the blank rows below the data for each spreadsheet, so the final output has a chunk of data, blank space, chunk of data, blank space, etc. Is there any way around this?

Hi, I just encountered an unexpected problem with the MSSQL_SPATIAL writer. I originally set a manual command ("exec some-stored-procedure-with-arguments") to define a spatial index and more, which err'ed because there was no primary index on the relevant table. That's fine and understandable. As I really didn't needed a spatial index on the specific table anyway, I just switched the dropdown "Spatial Index Type" to "None", and reran the translation. But the translation still failed in the same place, while trying to execute the now deselected and unwanted command. It seems like the command was still present, and FME tried to execute it as such, even though the setup stated it shouldn't. This I believe to be buggy behaviour, the overall choice should not be overridden like that. Cheers Lars I.

The best practice to print 20,000 rows of 6-columns each in pdf landscape A3 page size while to repeat the 6-columns 3 times in each page , I couldn’t figure out how to print 20,000 rows of 6-columns each in pdf landscape A3 page size such that the 6-columns can be repeated 3 times in each A3 page as shown in the screenshots below

Dear FME-Users, I’d like to create JSON-files which describes some metadata of NetCDF input data. It works well when I use the “RasterToPolygonCoercer” before, but this transformer takes a lot of time. Without conversion to vector data the JSON-file doesn’t describe the metadata of every single pixel, even by using “RasterCellCoecer”. Please take a look in the attachment, there are 2 screenshots of 2 JSON-files. Necessary is that every cell value of the input data is listed in the JSON-file. Maybe it works with the “JSONTemplater”, but I don’t have any experience with this transformer. If you have some ideas, it makes me happy. :) Thank you very much and best regards. Konrad

Hi, I'm trying to create an error file with AutoCAD DWG/DXF Reader/Writer and i've got an issue : Specified block 'CENTRO_LOCAL' is not defined in AutoCAD file. Skipping feature MULTI_WRITER: multi_writer_id `3': Writing feature 0 AutoCAD Writer: Performing database audit... AutoCAD Writer: An error occurred for dataset 'D:\\Routines2014\\LOGS\\DWG_ENGLOS_01122016.dwg', in function AutoCAD2004Writer::setExtents. Exception thrown: 'Invalid input' A fatal error has occurred. Check the logfile above for details ... Last line repeated 2 times ... Anybody's got an idea ?

Is it possible to add extra z-value to a point cloud (las) with 3D affiner? I need to add extra 0,507m to my already existing z-values. I'm changing from a local to an national height system but i don't know the parameters from the local one. regards, Anton

Dear FME-users, I’ve created a GeoTIFF-file based on NetCDF-data. The problem is the spatial reference. A compare to OSM-data in the attachment shows you, that the GeoTIFF-file is not placed right. The second picture is from Copernicus and right placed. Do you have an idea? Thank your very much. Best regards. Konrad

Is this possible? Or do I have to recursively use FTPCaller for "each level" of the ftp/sftp and build the strings manually? This is on both FME Desktop and FME Server. Even better: Add support on FME Server to "Add resource" and Type of Resource Connection would be ftp/sftp

Not long ago, I updated the FME from 2017.0.0.1 to 2017.0.0.2, But today I found that it can't use Esri Geodatabase (File Geodb ArcObjects) format. If I choose Esri Geodatabase (File Geodb ArcObjects) format, FME prompts the error and automatically shut down. And I open workspace that include reader or writer with Esri Geodatabase (File Geodb ArcObjects) format, I try to change reader or writer's parameters, also can appear the same problem. FeatureReader and FeatureWriter have the same problem. I remember in the previous version?FME 2017.0.0.1 64bit?, there is no problem . Also installed the FME 2016.1.3.2 64bit on my PC?Use FME 2016.1.3.2 64bit can read and write with Esri Geodatabase (File Geodb ArcObjects) Without any problems. I also refer to the following URL?I confirm that I have installed [ArcGIS for Desktop and 64 bit Background Geoprocessing]. Notes on FME and Esri Versions and Compatibility Don't know if anyone had experienced the same problem with me. I want to know whether

Hi! I have been looking into the FBX reader/writer functionality in the 2017 version. All works as intended regarding the 3Dmodelling which is great! But i was hoping to add/read attribute data to/from this format. We use the Unreal engine to visualize and have the FBX format as our input to it. I read on the reader/writer page for FBX that it is not available in this version So, attribute data on the FBX format, is this something that is being looked into at the moment or is it beyond the horizon? We are mostly looking forward to the potential of writing the attribute data onto a FBX model. Thanks /David

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 apply that same filter in the FME world Thanks for any help you can provide

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 tables Can 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 you Best Rawan

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 server!

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.