Data

Hi, Im trying to write data to an xlsw writer where i want for each partner a seperate excel file with a sheet for each municipality.So i tried to create a writer where i set my sheet name to an variabel attribute (gemeente) and then by the fanout option i tried the variabel attribute "gegevenspartner". But is doesn't work, what am i doing wrong?

Does anyone know if there is an attribute or attributes that can be read from a DWG file that will define the linestyle i.e. if it is a dashed line what are the line lengths and the space lengths?

I'm looking to check and compare the collected lidar coverage against a given AOI. In other software's I have used the bounding box feature however FME boundingbox transformer looks to only create rectangular bounding boxes. Any insight would be much appreciated.

HiI am trying to write hyperlinks to a powerpoint but it fails and I get this message:AttrDecoder: Unable to parse line table attribute 'link'. Please update transformer and retry. If problem persists, please contact technical supportError encountered while calling method `input'PowerPointStyler_8_CALLER (PythonFactory): PythonFactory failed to process featureA fatal error has occurred. Check the logfile above for detailsI have created an attribute called link = <a href="@Value(url_1)">link text</a>Br,Felipe Verdú

CSVJoiner2.fmwI have many CSV files in a folder that I want to join together based on attribute in first column of every file. Each file has about 300 records and 50 attributes. I want my output excel sheet to have 300 rows with all attributes from all the input files, joined by the code in "Col0"I've tried DatabaseJoiner and my output has all the input column names, but only the values from the first input table. See attached two CSV files and workspace.

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 review       

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:  Settings of BoundsFitter: 

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 uniform area, but in some pieces. How is it possible to control all these parameters without losing the individuality of objects?Maybe someone can present a compiled example in one place

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 Configuration: Process limit is 15.67 GB of physical memoryFME Configuration: Start f