Using readers and writers to extract and load data.
Recently active
Hi, I am trying to generate a simple HTML page on FME Server 2017 to start an FME Server Jobsubmitter Job. I use an HTML template where I replace the server part of the URL by $(FME_SERVER_WEB_URL). We are on a secure environment and the FME Server is on URL https://myfmeserver.mycomp.nl:443/fmeserver. But when I use the FME_SERVER_WEB_URL parameter, it returns the insecure version of it: http://myfmeserver.mycomp.nl:80/fmeserver. The service URLs are configured for SSL, i.e., starting with https://. How does FME Engine "know" about its URL? What is the source of the $(FME_SERVER_WEB_URL) parameter? Thanks in advance.
I have a jpg of a historical map (with no accompanying data) that I'm trying to write data for to upload into google maps as a KML file. I know the coordinates of the map, so I started with the RasterGeoreferencer to assign the correct coordinates. The problem is that none of the data that I want to create/ add to the file (for example, a z coordinate with the 3d forcer) shows up. There is a coordinate system assigned, and I can find the coordinates of any point I click on in the graphics window, but the data doesn't seem to be stored in any category.This returns missing data for everything except for the source name...How would I properly write data for my map so that I can turn it into a workable KML file?
When joining file-GDB dataset with GML dataset and then writing to GML the geometry is missing in the output, if I dont join with the GDB the geometry is in the output. Is there some hidden GDB features which causes this ? Or what is happening ?
I'm trying to write jpgs that are created from a blob directly to a folder in ProjectWise. I'm a newbie at this so maybe I'm just missing a step? Works fine when writing to C:\\Temp with JPEG Writer
Due to the COVID-19 outbreak, we are cancelling the Safe-hosted FME World Tour events this year. We are working to bring them online and will be providing details shortly.Our team here at Safe Software has been closely monitoring the evolving COVID-19 situation. After taking the guidance and recommended safety measures issued by the World Health Organization and health authorities into consideration, we have made the difficult decision to suspend all in-person Safe-hosted World Tour events through to the end of April 2020. During this time we want everyone: our team, our partners, and our customers to look after yourselves and those you care about.While we will most certainly miss seeing you all in person, we plan to share the latest updates in FME 2020, along with time-saving tips and best practices you can apply to your work, during our virtual event. More details about this will be provided soon. Stay updated with the latest news by signing up for email updates below. For more inf
Hi, I wanted to make Cesium 3d tiles in FME.My source model is textured collada (open collada from 3dsmax).Fme is producing 3d tile files, but in cesium i have problems rendering them.it gave me errors like so:when i'm creating cesium3d tile file in FME with .OBJ source model its just fine (besides materials):but the goal for me is to produce 3d tile from collada wich i believe would give better anti-aliasing/mipmap result in cesium, what is main problem(as seen on screen above).1. Does anyone knows how to export proper Cesium 3d tile (b3dm) using Collada as reader?2. Does anyknow knows how to get proper antialiasing/mipmapping settings in cesium with 3d tiles(b3dm) using OBJ/DAE as reader in fme?Thank you in advance!
have a few shape files that I'm merging together using multiple transformers including LineOnLineOverlayer and Line Combiner and writing to SQLITE Spatial format. The file processing takes a few minutes but the SQLite Spatial writer takes up to half an hour to write 130,000 line features. It must find something disagreeable with the processed features that is over my head. Once the features are in SQLite format, and doing any additional processing, the SQLITE writer has no more issues. I have tried it figuring this out from all angles, but its time to reach out to the pros. I have attached a sample line feature right before and after SQLite Writer. If you need more details let me know.Thanks in Advance.I
Hi,I have a script where I read from a table, lets call it A, to another table, lets call it B. In table B I have added a number of columns (and attributes in those columns) that doesn't exist in table A. This script needs to be automated. However, what happens is that it deletes the attributes that I added manually. I dont want that to happen. What I want for table B to do is:1. ONLY update columns that derives from table A. 2. DO NOT delete attributes that only exist in table BHow should I proceed with this issue?
I have some aerial images that need geotagging from a CSV file. I'd also like to get the world file for each image. I'm new to FME and have tried to read docs/forums on how to solve this problem but am stuck. Appreciate any tips/how to's. Thanks
After upgrading to FME 2020, I went ahead and changed my password. I entered it into my password keeper, copied it from there into FME, and confirmed the change. However, that password didn't stick in my password keeper. So I am unable to login to FME web interface. Is there a way to reset the password?
Hi. I'm looking for a way for FME to check a folder full of GMLs and either delete the ones that don't fall within a shapefile area feature, or move those that do to a different folder, but I assume the first option is easier ... but I could be wrong. So for instance if I had a GML location for each Corona virus case in a folder, I want it to delete those GMLs that fall outside of my shapefile of the UK. Any ideas? Do it for the children - and the elderly! J
if i rightclick on my excel and look at the Properties i need that date.How can i extract that date so i can work with it?(Origin --> Last save)
I am trying to make a CityGML file from IFC using a slightly modified workbench provided in one of the tutorials for IFC to CityGML conversion. After running the workbench i end up with unexpected input window.
Hi there - We'd like to create a workspace document that searches for log files in a series of folders (most are FME logfiles, but not all), then searches through each log file for errors, run length, etc., then update an SDE table with this information, and send some email notification on failures.I've got no problem with adding a data reader to search for and find the log files. However, after that, is there a transformer I can use to search through each file and extract the information? Or do I need to do the search/extract via a python caller?Thanks. M. Knapp
I am transitioning from using ERDAS Imagine to FME to generate ECW filesI need to understand the difference between the terminology used by both systems with regards to compression.FME ECW writer refers to "Compress by Percentage (0-99)" with a default of 75this means that the output image will be 75% compressed, or one-quarter the sizeERDAS Imagine refers to "Target ECW Compression" with a default of 20this means that the output image will be compressed by a ratio of 20:1, or one-twentieth the size.Two questions;1) Why does FME use a compression percentage and not a compression ratio (the convention established by ERDAS)2) Why is FME's default compression different to ERDAS's default compression?
I have a DWG file with simple 3D shapes of buildings for a town, I need to convert it to Geodatabase so I can import to CityEngine. I can inspect it ok. I have tried various ways to convet it but nothing seems to work. In particular, when I attach a gdb writer there is no option to output a surface geometry (see screenshot). I also tried the auto generate workspace but that output an empty file. Any idea what im doing wrong?
My input data is DGN with complex shapes created orginally from lines. I would like to convert the complex shapes to simple shapes
I did some easy tests on reading CityJSON and writing out the same data I just read in.Reading was easy. Problems start when I try to write the data I just read in.I always get some error ffs with Feature types I don't understand and I don't know where they come from: The CityJSON file which is written cannot be read in again as a CityJSON fileCITYJSON reader: An error occurred. FME will attempt to provide more information on the error, but this may cause the translation to be terminatedRead Metadata Feature Command caught exception: stk::ex::FatalError[0] CITYJSON reader: [json.exception.out_of_range.403] key 'boundaries' not found[1] auto __cdecl STFReader::getFeature::<lambda_e8ad0c4de285582507d80bbbf97fb805>::operator ()(void) const(C:\\code\\fme\\foundation\\framework\\engine\\reader.cpp:61) It is a tech preview, OK and I managed to write CityGML successfully.Any guideline how to do this properly for CityJSON ?Michael
Hi,Since I've updated my FME Desktop to the 2020 version the values when my field name is suffixed with a * aren't been read into FME. I know FME changes the * to _ when it is loaded in Desktop, but this wasn't an issue before.For example, below is a screenshot of my Excel file.And this is how FME deals with it.You can see the values in Your Name* doesn't get read.As I say this wasn't an issue in previous versions. Is there something new I should be aware of?RegardsPaul
I'm reading an HTML table from a website and its bringing in both Real64 and Real32 numbers which I'm writing to a Geodatabase table. No matter if I specify column types of Float, Double, or Integer I get unwanted results where the number has a comma separator in the thousandth position (From table) - the resulting number adds a period in the output. Some of the numbers are dropping a zero when the number ends with zero: 8450 becomes 845. Has anyone experienced this before?
Hello,I need to retrieve the value of a column header in a CSV file. The column header contains the ID of a meter I need to use as an insert into a database. Unfortunately I can't use a filepathreader as the id filed isn't included. Any idea how I might do this? I have attached a test file. The value I need to extract from the column header is the string after the undescore.
Hi All,Is it possible to write an AutoCAD Layer to a DWG File with no geometry, so that it acts as a placeholder for the end user before starting the digitization process?Thanks,Ana
Hello everyone! I need your help urgently! Please help me!I have a point cloud data from Faro Laser Scan. Scan is from a archeological site. I want to see how much of the area is in related parcel boundaries. So, I mean want to see our scan area on our parcel lines. Parcel boundary is in dwg. format. And both of them in same coordinat systems.,In which format is most useful for point cloud export from Scene Software for this?
I would like to read a dwg including modelspace and paperspace data, edit the data and write to dwg including the same model and paperspace.Writing to modelspace works, how can I write/copy the data to paperspace?
i would like to extract the whole attributes from pdf adobe Geospatial pdf .what i did exactly and iam not sure if i extracted the data to be as DGN and it seems good with text on it but my question exactly say if the data is geospatial pdf or dgn ,Does it ossible to extract the information that included inside the data . in my data it looks like nodes and lines connected together and lines connected to lines also each lines has labels ,i would like to extarct each labels include inside it and know which labels connected to which labels as shown inside the file . Is it possible to do ,and if yes ,could someone guide me how to do it .by the way when my reader in FME read my data ,it reads it as pdf no layer is it problem bcs i saw some videos include too many layers excet my file ,write pdf_no layer Thanks alot for any help or suggestions.