Using readers and writers to extract and load data.
Recently active
I have csv data in a single attribute like this (field names are first line). Grower,Date,SampleNum,P,K,C1000,05/01/2018,350,275,1500how can I parse this into feature(s) with the correct collums using fme?
I have a model which failes without giving any specific feedback in the log, just: "Translation FAILED". After enabling Log Debug one line is added in red: "(stfgeometryproperty.cpp:42) STFGeometryProperty::getAsSimpleAttribute".Is this a known error? Where do I have to start looking? It is a large model with a lot of input, debugging the model piece by piece will take some time.
How to convert wms to kml in fme.I tried converted but the file got converted has no geometry and schema is defined for the converted file.Why is this happening what error am i doing.Or how to convert wms to shape file.
I've a large installed base of Revit with versions from 2016 to 2018 and one of the worst problems we are dealing with is the incompatibility between these versions. I would like to know if FME Destkop can act as an intermediary in order to read from one version and write to a different one. Maybe the plugin for Revit and the rvz format could be the solution, but I'm not sure about this (I didn't have explored this). Thanks a lot!
Has anybody ever tried to create an external Style.kml file that is being referenced by other KML/KMZ files? I have seen several blogs where the KML StyleMap is defined by creating a Style feature, and I've got that working fine. But I've got 500+ KML files (all regionalised etc.), and the result is that each of them has the same StyleMap definitions in the top of the KML. I would like to define all my Style definitions in a separate KML/KMZ file, and each KML file to reference just this file.The Google KML documentation shows this is possible, and all you need is a line like this:<styleUrl>style.kml#counties</styleUrl> But how to get this in FME? I have been playing around with the kml_style_url_* and kml_target_style_* attributes, but have been unable to crack it, and there doesn't seem to be any documentation on all these kml_* attributes.
Hello All,I am new to FME. My actual intention is to build a geopdf from 2 or more vector sources. And I would like to overlay some point layer which should hide in the default view but should be revealed when I zoom in the geopdf. Can you please let me know if this is possible and how.Thanks in advance,Praveen Kumar Bandi
I'm using FME Workbench 2018.1 FME(R) 2018.1.0.2 (20180903 - Build 18547 - WIN64)Sometimes the directory and file pathnames reader does not stop once it has read all files on my external hard drive. It reads the same files multiple times. The only way I've found to fix this is to delete the reader and recreate it, however even then it's pretty inconsistent with whether it stops or not after reading all the files.I have tried setting max number of features to read to 5 in order to test if it stops, and it doesn't stop after 5 features.Has anyone else had this happen? Is there a solution?After a little further testing, it appears that I start running into problems when I use * as a path filter.
As part of one of my workflows, I would like to create an excel spreadsheet that includes diagrams.My current way to do it is as follows:create excel file with diagrams manually,update data within file during workflow,automatically rename file and copy to output directory.This works reasonably well for some cases but also poses problems. For example, I cannot figure out a way to dynamically change the range of the data referenced in the diagrams. Is there a better way which I haven't thought of yet? Thanks!
Good afternoon,I am having trouble viewing IfcCurtainWall. Originally I had IfcPlate and I was able to view join based on a unique id, but I currently do not have IfcPlate. Is IfcPlate needed in order to view CurtainWalls? Or is there a setting I can check in order to view it, like IfcSpace?Thanks,David
Using the GOQRCodeGenerator transformer I can write the output into a PNG writer. It works very well. However, I wanted to add one of the attributes below the QRCode so each code can be added to the right bin. How do I add this attribute with the raster before it writes to PNG. I've tried TextAdder, rastermosaicker and I have not gotten it to work.
Hi,How to use a crosstab to convert a fgdb to autocad with the layer, color, style and point to block settings in the crosstab.
How does "Import" work.I have tried to make a list in Excel to store my mapping (input/output attribute).But i only get the first row added as a new attribute.
An email update show's me a comments. When I look them up on the forum then I can't see them.In the unanswered list are items that are answered. So whats happening?
Hello, I have AIXM 5 reader in my workspace. When I load geometry, I got 2D points. I need to get elevation from geometry trait. My problem is that the geometry property extractor does not offer me any traits for export. Where can be a mistake?Here is my data in Data Inspector:
Able to use the USGS WMS topo basmap service to create background for a PDF map (using FeatureReader, PDFStyler and PDFPageFormatter. Has anyone been able to use the ESRI basemaps for their PDFs? https://services.arcgisonline.com/arcgis/rest/services/USA_Topo_Maps/MapServerorhttps://services.arcgisonline.com/arcgis/rest/services/World_Topo_Map/MapServerWorld_Topo_Map, when I put that URL in a FeatureReader only finds a feature called "Citations" that does not show me anything. The PDF also gets a weird massive extent. USA_Topo_Maps appears to connect to a feature called "USA Topo Maps" and the PDF ends up with the right extents, but the background is blank. Cannot share my workspace, but let me know if there are questions and will try to clarify.
I have a satellite image of the Suomi NPP satellite (nighttime lights). I have use ArcScene to create a 3D model. I exported that model in a .wrml format and I imported it into FME Desktop. I would like to know the workflow for converting a .wrml file to .obj. I am totally new to FME.
I have configured a Workspace to process both resupplies and Change Only Updates (COUs). The data is written to SQL Server. Parent Workspaces handle pre and post processing tasks such as truncating the SQL table if it's a resupply.I have created a "Resupply" parameter which is set to "Yes" for a resupply and "No" if it's a COU. This also determines whether Bulk Insert is set to Yes or No. However, because fme_db_operation is used as the Feature Operation value in the SQL Server Writer, Bulk Insert is ignored if it's a resupply, even though the only Feature Operation will be Insert. This results in a resupply taking 20 minutes longer to load (1 hour 13 mins instead of 53 mins).I tried creating a "Feature Operation" parameter which would be set to "Insert" for a resupply or "fme_db_operation" for a COU, but this failed because it used "fme_db_operation" as the value for the Feature Operation, not as a
Hi!I am trying to tile some PNG:s with the WebMapTiler. My problem is when writing the data to PNG-format the writer put extra "_1" to some of the tiles.The fanout is @Value(_zoom_level)/@Value(_tile_column) and when I inspect the objects just before the writer no object has any "_1" as fanout. But when the writer writes data to my folder it divides some of the PNG:s into two, like this:1218.png1218_1.png1219.png1220.png1220_1.png 1221.pngDoes someone know why the writer prints PNG:s with the "_1"-ending?
How to retrieve width and height of JPG and PDFs?
Hey thereI have a series of .pdf multipage files that I need to convert into .tiff files and output them in the same location as they are now. Problem is that TIFF writer outputs each .pdf page separately. Any ideas how to solve this? I attached a sample file and and my script. I am using:FME Database Edition (node locked-crc)FME(R) 2018.0.0.1 (20180328 - Build 18295 - WIN64)
When reading features from a GeoSpatial PDF created by ArcMap, CRS EPSG:28992, I get the following warning in the log:Unsupported projection provided; Using Non-Earth projection insteadThe result is shifted 117 meters north north east.Checked the CRS of the frame:pdf_frame_coordinate_system: _Netherlands-RDNew-2008_0In the Coordinate System Gallery this CRS is known under the names: - Netherlands-RDNew-2008 - EPSG:28992Is the underscore in the pdf_frame_coordinate_system causing the problem?
Hello, I have one large ECW file (~135gb). It has a white border around the area of interest but my problem is that pixels that appear to be white have value between 250 and 255. I would need to remove them but I am not sure how to do it. I have seen some posts on community but I am not sure if that helps me. (example: https://knowledge.safe.com/questions/28053/thrim-white-borders-of-a-tiff.html) Every hint is more than welcome. Thank you in advance. Dejan
I have several CSV files exported from Hadoop so the separator is the SOH control character. What do I type as the separator for the CSV reader? I've tried the hex code (\\x01) and copying/pasting the SOH character from Notepad++ but neither work.Thanks,Aaron
To read WFS from a token based secured ArcGis Server we would like to access behind a proxy with http basic authentication to the WFS. I would like to fill the URL like this: https://fmeserver.local.com/MapServer/WFSServer/" target="_blank">https://example.com/proxy.ashx?https://fmeserver.local.com/MapServer/WFSServer/ When we RUN the translation FME cuts all behind the question mark "?" --> https://example.com/proxy.ashx (Removed: ?https://fmeserver.local.com/MapServer/WFSServer/) How can we avoid this? Is there an "escape" character to avoid this? Or another solution?
I’m trying to view my DXF file using FME Data Inspector and it is taking a very long time to load the file for viewing. Why is it so slow? How can I make FME display my DXF file faster?