Using readers and writers to extract and load data.
Recently active
Hi all, Could someone tell me how can I put non-spatial features into a shapefile? Here is an screenshot: (as you can see, with inspector they are found 4 features, but once I check the Shapefile, there are just writen two features) Note: the original Shapefile has spatial and non-spatial features inside. Many thanks, JuanM.
Hello! How I can tranform shp file with "height" to citygml lod2 model with roof and textured wall?
Hello All: I am creating a workspace that translates an Autocad .dwg cad file into an xml. The workspace works fine. One of the validation I would like to do on the cad file in the workspace is to check if the input cad (.dwg) file is a 3d or 2d file. I know how to check the dimension of each of the cad layers using DimensionExtractor transformer. But I want to check whether the cad file itself is in 2D or 3D. I have been researching all of the Autocad Reader Feature Type Propoerties. One of the Format Attributes that might be able to give some info on the cad file's raw dimensions is autocad_dim_flag (or autocad_dimension_flag). Unfortunately, I have not stumbled upon any available documentation on how to extract any dimension (2D or 3D) info from the cad file. Any help/sugggestion is highly appreciated! Thank you!
I've gor an ascii raster that I want to convert to a xyz file. This should not be to difficult now should it?! I get this errorr: POINTCLOUDXYZ writer: Failed to obtain point cloud from feature. Only features with point cloud geometry are expected A fatal error has occurred. Check the logfile above for details
We are beginning to process Travel Time probe data using INRIX and Excel. My question is if there is any documentation on the use of FME and probe data?
Apologies for this very simple question, but I don't seem to be getting a Help tab in my 2015.0 Desktop. From a previous version (2012?), I seem to recall that when you selected a Transformer in the Transformer Gallery, a Help tab/box would show you the basic instructions for that transformer. However, I can no longer see it. And when I select View --> Windows --> Help, I can switch on/off any of those windows, except Help. I can tick it and untick it but nothing happens. Could it be that it is an undocked window, which sits outside my screen boundaries? If so, how can I get it back in view, so i can dock it? (Note I can still access the FME online help, it's just this window within Desktop that seems to have gone) Fingers crossed there is a very simple solution...
Hi, On the FME Server I get an error when writing to SOSI. "504 ERROR 0.0 9.0 2014-12-12 08:44:20 BADNEWS: File C:\\apps\\FMEServer\\Server\\fme\\metafile\\SOSI.fmf could not be opened (tabrdr.cpp:1048)" A workspace is tested and works well on FME Desktop of course. Is there any special setup for GeoSOSIprofessional when working together with FME Server? Tips?
Hi all, We're currently processing a 1.6gb jpeg2000 file. We're applying a clipper to break it down to a 4x4 grid and then resampling using bilinear interpolation within the RasterResampler transformer. Its setup to clip first the resample. All files are running locally. The issue is at current estimates, per grid cell will take 40 hours. Strangely enough, we processed a 1.2gb jpeg2000 file a while ago with same setting presumadly, and took 19 hours for the entirety of the project. Not sure whats happened. Wanted to ask if any has tips/tricks to improve speed or recommend different transformer combinations. Cheers,
Hello All, I couldn’t figure out why the API writer produce a feature class without Shape area and shape length in their attributes. Best Regards, Ahmad
Hey, So I'm curious why all my writers to geodatabase sde always say <not set> everything writes out just fine but more a just wondering sort of question. Also It seems that (though I might be wrong) because its not set I can't seem to get a workspace runner to run the said workspace. I have a two step process I'm trying to use a workspace runner to run them both one creates the layer in DEV then the next one sends it from DEV to PRD. So I have to wait for the first workspace to finish before the next one starts. Currently just run two bat files (no fme server). Though I could be setting up the workspace runner model wrong as I have no experince in using that transformer. I notice that i dont have a destination perameter when setting up the workspace runner to run. Thanks.
Hello all, I was wondering if anbody has any experience in adding additional files to a zipped data downlad result in FME Cloud. According to this article : http://fmepedia.safe.com/articles/How_To/Including-Additional-Supporting-Files-in-your-Output-ZIP-File-Desktop-Zipster The data writer should be adapted to the File Copy writer, but since the results for a data download registered workspace are automatically zipped and have each time a different location, I was wondering if I can actually reverse the recommended way and associate the File Copy writer to the dynamically created data location? I am going to try this myself but wanted to know if anybody succesfuly did something similar and would like to share the method. Itay
Hello, I am working on a reader, that connects to a remote database and receives a .gml file. Because I do not want to implement the CityGML specification, the received file is forwarded to the CityGML reader (provided by FME itself). IFMEUniversalReader* additionalReader_; additionalReader_ = fmeSession_->createReader(kSysCityGML, FME_FALSE, directiveReader); additionalReader_->open(dataset_.c_str(), *params); dataset_ stores the path to the received .gml file. However, I have no idea how to adopt the feature types to my reader during the read operation. The read method contains a simple forwarding: additionalReader_->read(feature, endOfFile); Using this code I get a warning each time the reader is running: Unexpected Input: During translation, some feature were read that did not match a reader feature type in the workspace. This can happen if the reader dataset if changed, or a reader feature type removed or renamed. Of course this message makes perfect sense, since my r
Hi, I am using Google Sheets new reader with 2015.1, I am finding that I have two problems that might be interconnected: 1. When bringing a sheet into a workspace, using several tabs from that sheet to verify data passing through, on the first run the attributes are read from the first row and everything is fine, but then eventually the attributes change to column letters instead of the first row field names.. not sure why it changes or what triggers it but only starting a new reader fixes it. For reference, the feature type still has the proper attribute names, but if I inspect right after the feature type all attributes are coming through as 'A' 'B' 'C' etc... 2. Any fields with formulas in them, specifically the vlookup formula come through fine until they reach a featuremerger to merge with the data I am using the spreadsheet to QC, after the featuremerger the formula fields dissapear.... they go into the feature merger and they do not come out on the &#
Hi Guys, easy question: I want to write an excel file and want to have a sheet for every different attribute entry. (like a fanout) I haven't find a fanout yet.....how can i do that? Thx Franco
Hello, Is there a possibility to disable the casesensitivity on the writer site? I am working with an AIXM Writer, with Attributenames in CamelCase (like validTime). I get all Attributes in a CSV File in UPPERCASE (like VALIDTIME), and my Writer can't assign them because of that. Is there a Parameter I don't know of, to make that possible? (I am working with FME Desktop 2015) Thanks, Melanie
Source is a shape file (point) with certain attrbs....(screenshot) GNR is a parcel nr. which i want to show with an arrow to the parcel (because these are little parcels and there is not enough space for the number) ROT_GNR is the rotation for the number RW_PFNR and HW_PFNR are the coordinates for the number (because they are different to the coordinates of the point) thats all clear but I've tried and tried to get this right but i have no ideas left because i have to place this in an AUTOCAD block called GNP screenshot 1 shows the block in AUTOCAD as it should be screenshot 2 is from blockeditor from this block: as you see the arrow has Layer PN screenshot 3 also from Blockeditor as you see the number placed in Layer PNA and thats my challenge....I cant find the way which attributes i have to fill (inserts, rotations, block_insert, text_inserts,etc....) because there are two layer definitions in one block and as a source i have one shape file. Sometimes the arrow app
I have a workspace set up to read features in a GDB and log the count of the number of features it finds using a combination of StatisticsCalculator + Counter + TestFilter. It logs the correct number of features in an Excel spreadsheet (Writer set to INSERT). Works perfectly to log the GDB name, the feature class name and the count found. But, when there are no features in the feature, how do I log the GDB name, the feature class name and the count of 0? The first transformer, the StatisticsCalculator, is never reached. I was thinking that a Python Shutdown script might be the way to go...? Use arcPy to append an entry to the Excel sheet only if the TotalFeatureWritten == 0...? TIA Brian
In FME Desktop 2014, I am reading a spatial dataset (point data) from an Oracle database, then doing some maniupulation like creating a balloon with HTML text, setting symbols for the points, then writing the data to KMZ (OGCKML writer). I understand that all FME Readers read dates and times into a string field using a common syntax that is database neutral (e.g., YYYYMMDDHHMMSS). Without using a DateFormatter transformer, my output KML file date attributes are being written as YYMMDDHHMMSS format. Do I need to use the DateFormatter transformer and specify each date-time attribute excplicitly? I'd like to save future hassles (when existing date-time fields are removed or new date-time fields are added to the source Oracle table that I'm reading). I'm trying to automate this FME workspace as much as possible, so is there a way to tell the KML writer to generally write all date-time attributes in a specific format (and not have to specify each individual date-time attribute
Hi, to start off I've got to admit to having no experience of Esri SHP files but have been asked by a colleague to provide some map background information in this format for use on some mobile units. I thought it would be easy to tag an additional FME workspace onto my existing GZ to TAB routines to provide this. From what I can see SHP requires a separate file for each geometry type which differs from TAB's combined approach, converstion seems simple enough as I should just be able to create a MapInfo TAB reader and then an Esri SHP writer for each type of geomtery. The problem I am having is that I don't know how to convert the text from TAB to SHP as there does not appear to be a text geometry type available in the SHP writer. I'm probably missing something simple but any assistance would be appreciated. Many thanks
Hello, I am running FME 2015, and I have been experiencing some odd behaviour for reading Excel tables, I load a feature reader, and I am reading one spreadsheet with numerous columns, let's say I close the FME workspace, and I open it again the next day, none of the columns are read, and everything appears as null, I current workaround, is just re-adding the feature reader... and this does the trick, but its starting to be a pain every time I open the workbench Thanks for any help!
I want to set my text justification to center. It has the option in the dwg styler for middle center but my text is not aligned to the center of my polygon I am labeling. I tried to set justification attribute to center but it will not work and FME bombs out. Thanks, Chad
Hi, I'm looking to process about ten large ECW files, these need to be color balanced all together so it's as seamless as possible. In terms of the color, some tiles might be brightness changes, others need color tints As a possible method, I was thinking if I manually picked a point to white balance in each file then perform cell value manipulation based on the RGB differences. I suspect it will be an average output though. I'm not sure what transformers to be using. In photoshop its an intuitive slider available but I've not seen something in FME. I could really do with ideas, transformers or processes on how to handle the color balancing. Thanks.
Hello everyone, I want to make changes to existing XML files based on Microsoft Word in FME Desktop 2015, for that I use the XMLReader (Elements to Match: *; Flattening enabled and using the workflow Option Single Merged FT) and the XMLWriter. All I did by now is connecting the reader and the writer to get an exact copy of the XML file, but it creates an XML File including tags (<fme:*>) that I don't want to be in there. For example: <fme:xml-tables xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:fme="http://www.safe.com/xml/xmltables" xsi:schemaLocation="http://www.safe.com/xml/xmltables FME_EDDH2_Testfile.xsd"> <fme:family-table> <fme:family> <Relationship xmlns="http://schemas.openxmlformats.org/package/2006/relationships" Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"/> <fme:xml_id>id-Relationship-1.1.1.1.1</fme:xml_id> <fme:xml_
I'm working with ArcSDE geodatabases. I have a workspace that builds areas from boundary lines. If it encounters any areas that can't be built, the boundary lines for that area are written to a separate feature class table. I've set the writer to INSERT and I've set the error table to Truncate Table First: Yes. It all works fine, the error table is emptied and the new errors written. However, when the process completes successfully and no errors are written to the error table, the error table isn't truncated. As a result, the errors from the last run in which errors were detected are still found in the error table. What is the best workaround to ensure that the error table is empty when no errors are encountered?
Hello everyone, I have what I thought was a simple model to create. Basically I will run this once a week. What it is, is a table from SDE that is updated nightly I just want to write out a row with number of features (or how many new features added) and the date the model was run basically. I was just going to build a list and use ListElementCounter to sum up total features. My main problem is obviously when it writes out it always wipes the spreadsheet. If anyone has any imput on any aspect of what i'm trying to do (but mainly keep adding rows for the new dates that come in). I'm all ears. One last thing I have tried setting the Writer Mode to Update but it ends up blank so might not be what I'm looking for... Thanks for your time.