Data

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?

So I have a collection of 50 Tiff files (historical aerial images). Metadata exists in a separate file, and I get to choose - CSV, XML (FGDC), or KML for the Metadata (I have the metadata in each of the formats.)Metadata includes: Raster Filename, Lat/Lon of image centers, Lat/Lon of each image corner, as well as some more specifics on the image collection. My question is- how do I combine the metadata with the raster files and write out to GeoTiff?I tried FeatureMerge and the data inspector shows what I expect to see after the merge- raster files that have a feature table. When I go to write the files, this "feature table" (metadata information from CSV, in this case) disappears.What am I doing wrong here?Thanks,Andrew

Hello,I'm struggling with an integration problem.I've published a workbench in FME server that must be called from an external application.The standard URL of the published service is like this:http://11.111.111.11:8080/fmedatastreaming/sample/FindAddressCandidates.fmw?param1=AAA &f;=json&maxLocations;=&searchExtent;=&category;=admin&POI;=fme123&outFields;=&forStorage;=&outSR;=while the external application can only call the service using the following URL (without ".fmw" extension)http://11.111.111.11:8080/fmedatastreaming/sample/FindAddressCandidates?param1=AAAIs that possible?Thanks in advanceRoberto

FME(R) 2018.0.1.0 (20180518 - Build 18310 - WIN64)If you set reader parameters and then change filename (as workbench is published to server) all of the ranges and other parameters are lost and workbench fails. For example setting read at row 2 to skip headers fails.

Hello,I am new-ish to FME and primarily used model builder for previous needs which may show in how this model was created.So I am reading from .sde, changing some field names among other things and outputting the data to both a kmz and to individual shapefiles to a zipped folder. Not all of the feature classes have NFID within their table so I am using this parameter not only for the output file names, but also to select the line with the specified NFID and then buffer to select surrounding features.I created this to run for one project at a time using a parameter NFID which is basically a project name/number to select the correct data and to name the output folder and kmz file. I want to expand this further and have it run through ideally a list of NFIDs and ultimately read from a good sheet and run based on those values when project status is updated in the table but that will be the next step once I can get this to reset and run for each NFID entered. Current Process: input projec

I have an oracle .dmp file from FRAMME data and I have no way of reading the data. Can anyone help me with this?

I am looking to write to word doc using the new wordStyler transformer, the images with their header, the problem is I am getting all header together then images. Attached the WS as referenceThanks

i have a line of 1500 mts, and i could trim it in different parts (the same longitude), and now i calculate the statisticscalculator sumary the vertex of each line (first and last number point), to know what is the value of the last poiny of each line. if i know what is it, what can i do to search in each line by these value, because each line have diferents point.if some one can help me, thanks for all :)