Data

I am trying to create a weekly summary report using data from multiple CSV's. Currently I have each CSV writing to multiple sheets within an xlsx file, but ideally I would like to write all of the CSV's in succession in one sheet. The issue is that the CSV's do not have the same name or number of columns and when they all write to one sheet with FeatureWriter it creates duplicate columns and blank cells.On the attached xlsx, Sheet1 shows how I would like the final sheet formatted and Sheet2 is how the writer is currently combining the CSVs. Thank you in advance!

I attempt to add a file geodatabase reader for this database (D:\\Workspaces\\My FME Workspaces\\Support\\AnnoFClassError\\CompetitorLeasesArcGISPro.gdb\\CompetitorLeases) and I get the following error: |WARN |Unable to read from the table/feature class 'CompetitorLeases_Anno'. If 'CompetitorLeases_Anno' contains a class extension, make sure it is registered on this computer. A reader is added, but no featureclass.The annotation layer was created by ArcGIS Pro 2.2, but I'm using FME 2018.1 and the email I received today claimed that the ArcGIS Readers/Writers are upgraded for ArcGIS Pro 2.2.Has anyone else experienced this and have a suggestion?

Hi!  Im having trouble producing a 3D mesh from my point cloud (.las). I'm using the PointCloudSurfaceBuilder which seems to be just what I'm looking for, but the process halts after some warnings in the translation logg."PointCloudManipulatorFactory: Converting 'x' from type 'Real64' to 'Real32'. If this conversion is undesired, consider changing the type explicitly." (seen below)This line is said for x,y,z and a similar line for "color_xxx" and is undesired.  The PointCloudCoercer > Output Geometry: Singel multipoint makes these warnings go away, but instead redirects the process into "Rejected".Does anyone know how to proceed with this?  Any clues is much appreciated!! 

Hi I have setup fme server 2019, as a fault tolerant on 2 server, with share and a SQL Server Database in HA clusterWe are using netscaler for load balancing, but the documentation is not very clear on how to config the load balancer partI am struggling to get the topic monitoring working for fault tolerant, and IT also unsure how to configureour load balncer has been setup as http://gisfmelb:8080, and it opens up the fme server GUI interface, this seems to work OK.but configuring the monitoring on port 7078 for websocket, we can't seem to get it right.i am receiving this error on topic monitoring service i was not sure, on the url you need for topic monitoring, setup as - ws://gisfmelb:7078/websocketattached are the netscaler config settings, for r

I have a workbench that is taking a DWG and converts it to a PDF and then I want it to also create a TIFF of the PDF. If I have a normal PDF writer it works fine but if I try and add a FeatureWriter that creates the PDF and feed that to another FeatureWriter to create the TIFF it fails. I have attached my workspace and a sample drawing  I could create a separate workbench reads the PDF and outputs the TIFF after the first one runs but was hoping to do it withing the same workbench. 

Hi Everyone, I am fairly new to FME, so please be patient with me! I have some As-Builts in PDF format that I need to convert to TIFF format as part of a monthly update to an external stakeholder (individual PDFs to individual TIFFs). I have attempted to use the Adobe Geospatial PDF reader and translate it to the TIFF/GEOTIFF writer, but to no avail. I keep getting an error message "Failed to obtain raster from feature. Only features with raster geometry are expected"; this is despite having 'Read Rasterized Pages' set to 'Yes'. I would appreciate any help and suggestions that can be offered!  Thanks in advance!

How do I retrieve the setting for Global Width on the geometries? 

I converted from dgn file to esri shaoe file but it does not work properly .could soemone provide me what am i missing to do .to get all attributes and also coordinate in output Thanks

Hi! I'm struggeling to create a 3D object/mesh from this point cloud I have. I really wanted to try out the PointCloudSurfaceBuilder but it wont work for me (asked about that in an other Q).  Instead I've tried to process it through SurfaceModeller/TINGenerator but left with an undesired result. My problem is that the empty space is included in the model.  I now try to work with vertices (generated from SurfaceModeller) which I transform further into polygons trying to get the outlines or the general shape of the point cloud, without success. Does anyone have a suggestion on how to either drop the empty space in the TINSurface or approach this matter of generating a 3D model representing the point cloud.

Dear All,I would like to read .skp file and scale it to specific size with BoundsFitter. It works perfectly until I want to write it as FBX file. The output looks strange. Translation .skp -> .fbx works fine. Also, with all my other transformers but after BoundsFitter step geometry is "spoiled". However, this is the case only in external viewers i.e. native Autodesk tool. In FME Inspector everything looks good.Moreover, lamp is positioned under the plane - the Z centroid is somewhere in between the whole geometry. This is also strange as the Move to Local Coordinate System is set to: "No" in FBX writer.Do you have any idea why is like that? I am marking Mr. @takashi as I assume that You was the creator of the BoundsFitter. Lamp after BoundsFitter in FME:Lamp after BoundsFitter in Autodesk:

I've had great and amazing success translating objects into the model space of an Autocad drawing but I've been asked to also setup the paper space. Does FME support creating new paper spaces and inserting the viewports?I have information for where the viewports should point to in model space and the paper space can be easily defined with a block and standard page size so I don't have to get FME to generate any layout information, just insert the relevent objects into the file.

Hello - I'm trying to create a polygon from co-ordinates received from an API call. The response body containing the co-ordinates is attached. The response can include shells and holes and I would like to be able to create both of these features if required (the attached example doesn't include shells but we will encounter these in future use).I think the response form the API is JSON and the workbench I've built to call the API is storing this response in an attribute ('_response_body').I'm really not sure how I can turn these co-ordinates into a polygon and I would be so grateful for any help.Thanks in advance and all the best,Matt

There is no Powerpoint reader in FME, but is it still somehow possible to replace background and/or color/styling on existing powerpoints on several Powerpoint-files by using FME?

Anyone that has successfully implement it please share.I read from CrateDB that it contains support for the PostgreSQL wire protocol v3.

Hi there, I am using AGOL writer to insert the data into a feature layer. I noticed that whenever I ran the transformation, it insert the data into a feature layer. I wanted to set AGOL writer in such a way that when I run the transformation, it deletes the existing data and insert the new one. Could anyone guide how to do that? Please note that the data on FME transformation does not have OBJECT_ID attribute.

Hello to the masters of FME. I am a new user. and I have a question that I can’t find the answer to, I really hope for the help and support of the community. I'm trying to create the correct cesium tiles, but in the sea of information I found only two parameters that I can not make work.The first parameter is cesium priority, following the description https://knowledge.safe.com/answers/48967/view.html I created a test scene and could not achieve this parameter.the second parameter was found in this answer https://knowledge.safe.com/answers/77990/view.html it, due to my meager knowledge, I could not even realize how this should work.Third, when creating cesium tiles, it is possible to control only the number of individual objects in a single file. And in tiles, objects are collected not in a limited

Hi,    We are writing to a new geodatabase with FME 2013. This geodatabase has already a schema without any records.    Geodatabase Error (-2147220987): The user does not have permission to execute the operation. FileGDB Writer: A feature could not be written.   Has anyone experienced this error before.  It is strange, we are able to write some features but some other give this error.    Thanks,    Jo

Hi,  I have one excel file containing following columns: - feature_type --> defines output file - attribute_name --> defines the attribute name - attribute_data_type --> defines the attribute data type - geometry_type --> defines the output geometry type - order --> defines the attribute order  I now want to create a set of output files based on the feature_type. If the field geometry_type is filled, a shapefile should be created. In all other cases a dbf table. Attributes should be created based on the fields attribute_name and attribute_data_type.  Aim is to have all work done in the input excel file and minimum of manipulations in the workspace. I only want to create empty files that will be filled later by an operator manually.  Any ideas on this? Rob 

Hi,I want to perform spatial operation (point in polygon) using Spatial Relator. Point dataset has 30 millions of records. I have used Oracle spatial reader to read the dataset. But After reading nearly 15 millions of records , fme job was failed with error. "FFS writer: Failed to write to file..Please ensure that you have sufficient privileges to write this file, and that sufficient disk space is available" ..Is there any way I can read all point records at a time without error?Memory stats before start:START - ProcessID: 29545, peak process memory usage: 16893 kB, current process memory usage: 16893 kBSystem Status: 7.83 GB of disk space available in the FME temporary folderSystem Status: 18.42 GB of virtual memory availableOperating System: Red Hat Enterprise Linux Server 7.7 (Maipo)FME Platform: linux-x64The memory allocator being used by FME is : `/lib64/libtcmalloc_minimal.so.4'FME Configuratio

Hello everyone ,I have two JSON files 1. RoadElement.json2. WaterArea.jsonI want to create geometry from each JSON file that would be polyline& Polygon features I have also created FME workbench but could not able tocreate Geometry having some problem can any one help m

Hello,   I want to create an excel file for each customer, within each file, you can find information regarding this customer. I use therefore the fanout option in the writer. However, I have two tabs that I want to change in Excel, so I tried using 2 writers (one for each tabs), with the same name output name on the same location but fme does not seem to be able to see that these tabs need to be merged in 1 file (th name I put in the fanout). This results in 2 files in the output, and because they have the same name, one file is not exported as Excel.  Is there a possibility in fme to export two multiple tabs, when using fanout?

The google writer has the path its going to write to... How do I see the path (URL) it is going to use to write a google sheet?

I'm using the 3DTiles writer to export our entire city model in order to use it in Cesium.In 3D TIles, there is the possibility to have different evel of details in order to improve the viewing performances. Is there any plan at Safe to implement this feature?Thanks for your answer.

I'm attempting to update a ArcGIS Portal feature service using the ArcGIS Portal Feature Service in Dynamic mode and after the workbench finishes the original features remain unchanged. I'm expecting to see the features locations shifted slightly, various attribute values changed and my user account name in the last_edited_user attribute with today's date in the last_edited_date, but I see none of these.My workflow includes...Reading features from a ArcGIS Portal feature service with a FeatureReaderJoining each feature with it's schema via the Schema port plus a FeatureMerger joining on fme_feature_type and fme_feature_type_name Also reading the schema in via the Workspace Resources, which I believe will work better for what I'm trying to achieveMaking requested changes to the dataEnsuring all attribute names are lowercase to match the feature serviceWriting the revised features using the ArcGIS Portal Feature Serv