Data

Hey all,Just wondering if anyone has figured out how to write a brand new google sheet to a folder?I have the following file and folder directory structure:My Drive/My Drive/Statistics/My Drive/Statistics/2017 <---googlesheetI want fme to create the google sheet, '2018' in the "My Drive/Statistics/" folder automatically (without user intervention), but no matter if I include the string "My Drive/Statistics/" or the folder ID & "/" , it always writes the new sheet to the root of My Drive. If the Google Sheet already exists, this is not a problem.

Does FME support migrating Smallworld Dimensions to the ESRI Dimensioning Feature Class?

Is FME already capable of working with a Service Desk / Ticketing type application?  Right now I am researching applications that I could use to manage emails & tickets (tasks). An idea (or hope) I have is for a user to email a zip file to a ticketing system, and then FME Server could be triggered to work along side the ticketing application to do some work with the zip file. We currently don't have a ticket management system, and so I am open to suggestions. Some cloud applications that I have seen online are: Zendesk, Freshdesk, or Freshservice.Thank you for your time,

I have 1.6TB of .tif files. Each file (11,500 of them) are named numerically and stored in individual .zip files. I need to convert all of the .tif files to JPEG2000. So far I ran the tif to Jpeg2000 reader/writer through the batch Deploy on small test runs of 10 files and it worked just fine. But when I run the full meal deal FME freezes. Please Advise

I have a FeatureReader for WFS. Because I want it to work with any WFS source I have parameterised the Dataset and "Feature types to read" fields and set the output to Single Output port.This means that I have to use the Generic output port.Further down the workspace I have some transformers that do logging. I have a ListBuilder followed by a ListElementCounter, so I can log the number of records returned by the WFS service. I also have an UpdateDetector with the same arrangement.Before I started using the generic output port, everything was OK. But since I have used the Generic port, some ListElementCounters are showing problems. (The one connected to the WFS reader and also the one connected to the Unchanged port of the UpdateDetector. Others are OK.) The ListAttribute fields are showing up as red and they don't seem to be able to read the _list{} attribute that should be supplied by the ListBuilder.If I run the workspace, it seems to still work, but of course I get a w

I am trying to create a workflow that would update an existing table in a file geodatabase. It works when i have feature operation set to "Insert" and Table Handling set to "Create If needed" under Format Parameters. When I try to change the Table Handling setting to "Truncate Existing", the workflows fails and errors outError:"Geodatabase Error (-2147220987): The user does not have permission to execute the operation.FileGDB Writer: A feature could not be written"

I am searching for a method to take an XML based array and insert each array value into a new record. Currently my workspace parses non-array XML tags\\variable and inserts them into one single SQL record, but now I need a one to many relationship. The number of array items is indefinite.  The use case is that we get field inspections in the form of an XML document that gets inserted into our SQL database (various tables - all 1:1). We now want to start registering file\\photo attachments to a reference table, however the photos are stored in an array (not a simple 1:1 insert).  Has anyone accomplished this? Idea would be much appreciated. Thanks!

I have a raster in which I need to change the vertical datum. I tried using the CSMapReprojector but it didn't work. It looks like FME just always sees the Raster at 2D when I view it in the Data Inspector. Is this a bug?

Is it possible to get AutoDesk BuzzSaw reader?

I may have encountered an issue with reading Excel sheets with attribute names that start with parts of existing FME format attribute names.My first experience with this was while using the SchemaMapper transformer, but when I investigated the Excel reader, I noticed similar behaviourThe attribute names I wanted to use were:fme_geometry_namefme_type_nameIf a sheet with these attribute names is loaded into the SchemaMapper transformer or the Excel reader, I notice the following behaviour:SchemaMapper Dataset can be loaded and Parameter window works as expected. When clicking Next, a popup with 'Reading Dataset' appears and disappears very quickly. I am not able to finish the SchemaMapper wizard.Excel Reader Dataset can be loaded, but after completing the Add Reader wizard, the FeatureType object on the canvas does not contain the added attributes.When repeating the process with the following attribute names, everything behaves as expected:geometry_name_fmetype_name_fmeMy impress

Hi gents and ladies,I'm trying to move my GIS in cloud:) unfortunately I didn't find the information about how can I add files stored on FME-Cloud to AGOL.F.e. I have the Vessels.kml file in Data folder on FME-Cloud/Resources and I want to add this file to AGOL. Is it possible or not?Thanks in advance.

When will an exporter plugin be available for Revit 2017? We here at the Denver International Airport have upgraded to Revit 2017 and updated our models. We currently are taksed with exporting our facility models from Revit to ArcGIS...

HiI'm new to JSON and GeoJSON, but I have some text for a geometry generated by Mapbox coded as GeoJSON:"{"type":"FeatureCollection","features":[{"id":"c2fc8b172269fb5b220d5661e804a7e5","type":"Feature","properties":{},"geometry":{"coordinates":[[[5.7289984618329015,58.97117391031097],[5.727435803187348,58.97244926566199],[5.725808033947516,58.97459712581869],[5.728542686566385,58.97520118738589],[5.729714680561443,58.974630685071816],[5.728868240463584,58.973858813964995],[5.728314798897173,58.9731876075123],[5.729193794339011,58.972449265591706],[5.730040234436871,58.971274597908206],[5.7289984618329015,58.97117391031097]]],"type":"Polygon"}}]}"In my workspace I have added a creator with an attribute containing this text. I the add a Geometry-replacer and choose GeoJSON. Upon running the workspace I get syntax errors.JSONFragmenter(JSONQueryFactory): A

Hi,We have FME Server 2017.1 with lots of scheduled tasks and sometimes, for several reasons, some of them fails.Do you know if it's possible to tell FME Server to run the process (for some workbench only) a second time if the first time it failed?Exemple : I have a scheduled task supposed to run at midnight but for a reason it fails. FME could try to run automatically an hour later the same process with success, or not. If not, it could stop there, or try an hour later a third time or indefinitely, until it succeed.So, is that possible or I'm dreaming?

Hi,When will the File GDB open API be able to read and write a File Geodatabase without completely locking down the database? We find that only one bench can be in a File Geodatabase when using the OPEN API reader and writer, else we will start getting failures.When using the ESRI GDB reader/writer, you can have as many operations occurring simultaneously as you want in a File GDB, as long as no one is trying to drop and create a table that is currently in use.When will the OPEN API be able to do the same?Thanks!

Will the IFCGUID value differs for a building model entity say IFCProject for LOD200 and LOD300?

hi , i am getting below error while connecting SQL Server from FME desktop ,  Making a direct connection using instance 'sde:sqlserver' and userId = 'username' Error connecting to instance 'sde:sqlserver' for database 'sde' on server '!not_used!' for user 'eifme'.:SDE_ERROR_CODE(-324) Cannot connect to database because the database client software failed to load.  Be sure the database client software is installed and configured correctly.. Error connecting to instance 'sde:sqlserver' for database 'sde' on server '!not_used!' for user 'eifme'.:SDE_ERROR_CODE(-92) Bad connection handle  Currently using Arcgis 10.2.1   any idea...

Hey all,I have a Revit file and I'm using the IFC reader to translate my data. Is there an attribute or way to call the file path of the IFC reader that contains the data? In CAD or SHP I can use an attribute that contains the path. However, with IFC data, it appears that attribute is blank. What I really want is the name of the IFC/Revit file. I tried using some of the FME parameters, but the path remains the same when the Revit file is replaced with a different Revit file. Any advice would be appreciated! Thanks!

Hello,I have text attributes of dimensions - such as 500/90 , 800/460, 30/90 etc. In a result I need to get the largest dimension value and delete the rest. For example - get the value 800 (and delete /460) or get 90 (and delete 30/ ).Any ideas, how to manage this?

I have 10 image in a (.tif) format without coordinate system. I would like to get the same result in the link below, that is, in my case, a final output to the 10 images merged into one GeoTIFF file.https://knowledge.safe.com/articles/22971/basic-raster-mosaicking.htmlWhen I had add the reader, I have select the multiple images, but the images overlap each other in the same position. How can I solve this and then get the final output?

I'm using Map 3D 2018 64 bit and a trial version of FME 2017.1.0 64 bit.However I cannot get FME to load into the data connector in Map 3D. I have used the integration console to enable FME.I'm trying to translate Mapinfo TAB files into Map 3D including the object data from MApInfo

Hi!I have a question regarding ArcGIS Online Readers in FME (2017.1.2). I set up a connection to an existing feature service and created the feature types of the reader. After that, the name of the service (but not its schema or configuration) was changed through the AGOL web site. Since FME cannot find the source anymore, I wanted to change the value of the parameter 'Feature Service'. However, this does not seem to be possible. Neither through published parameters nor the Navigator entry itself.Or there a specific reason for that? Or might it be a bug? What I would expect is the same behaviour as e.g. for a File GDB (change path / change path and update feature types if schema has changed).Greetings, André

Hi, I am pretty new to FME and trying to get my head around the new NetCDF sSupport.I have a NetCDF 4 file with two raster bands: MEAN_WIND (magnitude) and MEAN_WIND_DIR (radians). I need to convert this to two new raster bands U and V. I.e. a vector equivalent to the input bands.The math is like this:mean_uwave = Math.Cos( mean_wave_dir * 2 * Math.PI / 360.0 ); mean_vwave = Math.Sos( mean_wave_dir * 2 * Math.PI / 360.0 ); But how would I apply this calculation to NetCDF files?Thanks.Garth

I have "dirty" lidar data containing first and last returns and also errors under and over the surface level. (Screenshot)What would be a good workflow to clean this data? Is there a full automated method or would I somehow be deleting manually?

I have a workspace which writes geometry features from SDE SQL to Netezza. Most of the time the workspace fails for certain features. But the same workspace goes through if I use the Attribute filter and run those specific features which caused to fail.Any idea for this behavior please?Thanks