Using readers and writers to extract and load data.
Recently active
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 :)
Is there a way I can use the Attribute transformers to read the exif data from a JPEG and record it into a text file or spreadsheet?
Hi All, I am using ESRI Geo-database (10.4) Writer that updates a feature class in a geo-database (hosted on SQL Server). I have business requirement where if there is an error during writing there are no records committed. I found a property on writer: “Commit Transactions at the the end of the write” and set it to yes. During one of the runs, there was an error while writing, I was expecting that original state of feature class would be maintained but that didn’t happen. I am not sure what I am missing here. Are there any change required on geodatabase side for this. Appreciate any feedback.Thanks Jay
Hi,Yesterday I started a Workspace which is taking a lot of time to process. About 24 hours up to now. I didn't save the workspace. I'd like to inspect the log file to see if I could find a potential problem and also see the time spent on each operation. Is the log file saved somewhere. Thanks,Simon
Good morning FME'rsDoes anybody know about a clever way to create relationships between tables while writing to an access database?
Hi FME'er,I have CSV data that is stored in a table in Oracle. The data is created using a stored procedure and is stored in a single field with one row per line. I would like to read and parse this data as a CSV file into FME for further processing. I figured I would start by aggregating the field (attribute) into a single row but don't know where to go from there. I can't use the AttributeSplitter because it uses " qualifiers around data that has commas. Many Thanks,David
Hello all,I uploaded an IMDF file of for a building to Online IMDF Validator and received a validation report. But I found something wrong that some warnings were confusing because every Unit feature must has an unique ID.(below table) But it showed me that their ID were none.I appreciate any guidance!Thank you!Feature Type | ID | Category | Level | Validation Error unitNonestructure01ca9f36-6b0e-48ab-92c0-43af7fdb417cWarning|Display-point not within Unit.unitNonestructure01ca9f36-6b0e-48ab-92c0-43af7fdb417cWarning|Display-point not within Unit.unitNonestructure2110f506-1b2b-4679-8bd8-cef2257861f4Warning|Display-point not within Unit.unitNonestructure2110f506-1b2b-4679-8bd8-cef2257861f4Warning|Display-point not within Unit.unitNonewalkway2110f506-1b2b-4679-8bd8-cef2257861f4Warning|Display-point not within Unit.unitNonestructure2110f506-1b2b-4679-8bd8-cef2257861f4Warning|Display-point not within Unit.unitNonestructure3cb84699-b393-4bcf-ad15-06fb37fcaa55Warning|Display-point not
We have an Oracle RAC cluster with 8 threads each for two nodes. It appears that the Oracle driver (non-spatial) runs out of threads on the first node, but never falls over to the second node.Is there a way to configure the FME workflow to do this, or perhaps the driver itself? We have intermittent failures during our overnight process that magically "fix" themselves the next time this workflow runs. And after a lot of testing and trial-and-error, we came to the conclusion that the 8 threads on the first node are probably filled by other processes, and FME gets denied access because it never goes over to the second node. The error we get (not exact wording) is that the data source is unavailable.Has anyone experiences this and has a solution or a hint at what might help?Thanks!
Hi folks,I am quite new to 3D Data-Modelling with FME... Now I must convert an e57-dataset into TrimbleSketchup. Uhhh, have no idea how to... Just adding the e57 reader and an skp-writer doesn't really work...Can anyone give me a hint about the neccessary steps?Thanks in advance!! :-)