Using readers and writers to extract and load data.
Recently active
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 me what is wrong?Please find attached JSON file and created Workbench
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 Service writer in Dynamic mode and these settings...Laye
Hello,I have one point cloud tile with extents, for example, of min (0,0) and max (1000, 1000).I want to make a DEM from this point cloud, which seems pretty straightforward, but it isn't.If I want a raster with a 1x1 cell size, the RasterDEMGenerator makes a DEM that has 1001x1001 pixels and extent min (-0.5,-0.5) max (1000.5,1000.5). The main problem is, that the values of the bounding pixels are not ok, as half of the pixel surface does not have corresponding points.Is it anyhow possible to define that I simply want a DEM between 0,0 and 1000, 1000 (original point cloud extent) with cell size 1x1?From my point of view, it just doesn't make sense to implement a "point cloud to DEM" solution that always takes half of a pixel size larger extent than the original point cloud extent, which is, of course, empty (without points). I know how it works; the algorithm places the center of the left lowest DEM cell to the point of min extent of the input point cloud, and this
(FME 2019.2.1.0, WIN64)Hi,I have a raster DSM of max tree heights (max elevation heights over eucalypt forest). I would like to place a point on the top of each tree (max z value). The trees are not pointed like pine trees but have rounded tops.I have attempted to use RasterSegmenter (water shed) with limited success, by using RankCalculator with group on each water shed polygon, and then filtering with rank =1 (1 being the highest ranked pixel in each group). But this relies on the water shed being applied correctly.I have converted the raster to a point cloud using GeometryCoercer, I can see in a 3D point cloud viewer the tree tops, but I do not know how to go about finding the max z value for each clump of points that represent a tree.Is it possible to do something like this?Ben
Hi all,Is there a way to read a select - query (with geometry) with the "Intergraph GeomMedia Access Warehouse" reader like with the "Microsoft Access" reader?
Hi,I'm currently using FME 2017.1 Smallword Edition. My problem is that I'm trying to convert Collada data to Cesium 3D-tiles and I don't know how to specify the coordinates to separate the large input data into small tiles. The image is how I want to tile my dataset.Here's the Collada data.http://bit.ly/2DhOxIDIs there any solution?How to create 3D-Tile data in popular way?If anyone knows the answer, please let me know.Thank you very muchPA
I found an article about "insert images into an Excel spreadsheet" (https://knowledge.safe.com/articles/33588/writing-images-to-ms-excel-spreadsheets.html), this article was made with FME desktop 2016. I was wondering of it is possible to do the same action with fme desktop 2015? In fme desktop 2015 the "attributemanager" is not available, so i as wondering which transformers to use in fme desktop 2015 to make the same actions as with the "attributemanager" in the article!I hope anyone can help me!Peter
I am facing an issue. all my ArcGIS Indoors layers are stuck in the middle of the process because it seems they are being marked as unfiltered. see screenshots below, please! images links in case they don't showhttps://ibb.co/3pjgpM2https://ibb.co/ns6S0Ny Any help please?
Hello, I am in dire need of help, as I have been trying to parse an XML file for the last 5 hours. I have looked at the XML tutorial, in addition to many other posts on this forum, but I cannot figure this out. Can anyone help me? I am interested in getting a Feature for each Task, with all its subelements as attributes.The XML file and fmw workbench are attached. Thank you, and have a great weekend! Edit: You might have to change the path to the XML file in the reader.
how can i show user Attributes in Dgn Feature types where is the missing tab user attributes ,how can i show it .my file is dgn v7thanks
Hello,Is there a way to filter "Start Time" field in Ascending / Descending order or any other fields for that matter.I have too many tasks scheduled and it's hard to find the right "start time" slot.On a different note (Not sure if it's the right place): My test/live site is now fully functional and FME Data driven including the HTML Outputs / Layers update... Notification service, which will soon be provided to residents, makes use of FirmStep but the delivery of the notification service is FME at its best!! The other bits rely on Open Source (PostGIS / QGIS...) Basemap = work in progresshttps://molevalley.cloudmappin.com/mmv/ (Not a molevalley.gov.uk domain name because of hosting issue due to time constraint) Thanks and hope you like it. I also take this opportunity to thank the community for their assistance as I've managed to complete my project (well almost).Kind Regards Sameer
Hi,I have an Excel spreadsheet that has thousands of rows that need to be grouped by a couple of columns/attributes, then each grouping written to their own respective fan-out spreadsheet. I've accomplished creating reports by using the HTMLReportGenerator, then writing each report to an emailer. So, I need to accomplish what the ReportGenerator can do - group by attributes and create tables - but I need the results written to either individual spreadsheets or as tables in individual Word documents. Any ideas on what Transformers will give me the grouped Features to write to individual files?
Hi,I have an Excel spreadsheet that has thousands of rows that need to be grouped together by a couple different columns, then write all grouped Features to their own individual spreadsheets. I've done this using the HTMLReportGenerator, then putting the HTML content table into an email, but I need to instead write each 'report' in a spreadsheet, so each table row would be an Excel row. Can anyone help with what transformers would be able to group the features without analyzing them, then write each grouping to their own respective fan-out spreadsheet?
i have dgn file that include map for a place ,as first step when i put this file in fme which properties should i adjust to work on it , and also i need to get lines from this file and polygon to check intersection between lines and polygon.so what should i do ? thanks for help
Hello,I am creating dwg files using autocad template and DWG Styler. But when I opened the file in AutoCAD I am not able to see the linetype, instead it shows solid line. But as soon as I execute command REGENALL the linetype is displayed correctly with linetype.I have set autocad_linetype_generation=1 in fme, The scale is also fine, also I could manually create the linetype in autocad,I have done everything as mentioned in this post https://knowledge.safe.com/questions/83076/enable-linetype-generation-for-dwg.html I dont know if this is FME issue or AutoCAD setting issue.Has any one observed this or has any suggestion? Regards
Hi All, I have a workspace published to FME server with a few MI tab readers, nothing special. (read several MI tab files-> manipulate attributes -> extract coordinates -> output to CSV). For whatever reason when the job runs per its scheduled time, It fails with the following error in the log:MITAB Reader: Failed to open and parse file 'E:\\ProgramData\\Safe Software\\FME Server\\repositories\\Workspaces\\SSALocator\\RUR_ADS_PROPNUM.TAB'. Make sure that the file exists and is valid The tab file is located on a network share so i'm not sure why its referencing the location above? Theres no files here other than a copy of the workspace. It doesn't have a long path name (>260) If i manually click resubmit job, it works fine so i don't believe its file access(I used the full UNC path for the readers). Any suggestions are appreciated.
Is there a way to set the justification of text in a PDF writer? I can't find anything in the PDFStyler transformer or any Format Attribute in the writer to control this and this article doesn't mention PDF. https://knowledge.safe.com/articles/16546/text-justification.html The text feature class I'm reading from has the text justified as center, center, but when I write to PDF it shows up as top, right in relation to the anchor point.In GIS:In PDF:Any one have any ideas?
Hello,I have FME 2018.1 and PostgreSQL 9.4.I try to create a reader with non spatial date so I could join them with spatial data but it seems FME can't reader the features in the non-spatial table.I tried to open it in the Inspector but it doesn't work too: Opening POSTGRES reader for dataset 'cadastre_2019'PostGIS client encoding: 'UTF8'PostgreSQL 9.4.0, compiled by Visual C++ build 1800, 64-bitSuccessfully closed POSTGRES database readerSuccessfully closed POSTGRES database readerMerged 1 schema features read from 1 datasets into 1 resulting feature typesSaving spatial index into file 'C:\\Users\\J\\AppData\\Local\\Temp\\FFS_1579770320565_8204_DATA.fsi'Finished saving spatial index into file 'C:\\Users\\J\\AppData\\Local\\Temp\\FFS_1579770320565_8204_DATA.fsi'Removing dataset 'cadastre 2019 [POSTGRES]' from View 1Successfully closed POSTGRES database readerThe dataset 'cadastre<space>2019' was closed successfullyThe 'P
Hi folksI created a "choice multiple (with alias)" parameter, for several writer's format (MID-MID, DWG ...)and I would try to use with a Generic Format Writer, for instance, to produce a DWG and a MIF-MID simultaneously.when I choose more than one format, it do not work.Is it normal ? I attach the workspaceregards
I have built a workbench that takes a shapefile (which isn't one file) as an input. I've published it to FME Server. How do I upload a shapefile(s) so that FME Server will process it?
I have a series of feature readers that read data and schema from a postGIS DB and writes to a GDB using a dynamic writer and the schema feature generated from the Feature reader (see image). For some data I have empty tables and FME does not seem to write the corresponding feature class in GDB if no features are found. Now, what I would like to achieve is to force FME to write every feature class (corresponding to a table in the DB) even if the table does not contain any data. Ideally I would need an empty feature class with one row and empty data but also an empty feature class is fine, as long as there is the schema, that would be the requirement. Is it easily possible to achieve in FME desktop?
I am getting the following error message when I try to connect a reader to a read-only Arc SDE connection "Unable to read from the table/feature class 'GDM.GasValve'. If 'GDM.GasValve' contains a class extension, make sure it is registered on this computer"I would appreciate if i can get any help with getting round this.