Using readers and writers to extract and load data.
Recently active
I have a bunch of text files and each files contain one feature different attributes. I want to load the first line data as the first attribute, the second as the second attribute. Could you please give me ahint how to implement it? Here is the process, that I am using:
Has anyone had success using the ProjectWise connector in FME 2018.0.0.2 (64bit)? If so would you be able to share your set up or configuration - or if there were any "gotchas" that you came across.We are using ProjectWise which allows me to access it through a browser via https://projectwiseweb.lendlease.comThis succesfully brings up a page whereby you can select a "Location" (of which we have multiple) and type in credentials. Once you are in you can navigate similar to the ProjectWise explorer desktop app. If I use that URL and credentials in the ProjectWise Connector I get "Failed to Load folder from Bentley ProjectWise"Would love to hear from anyone who has had success with this connector as it will really open up some great opportunities for us. Could someone from Safe also have a look into the help documentation for this - there doesn't appear to be any. Thanks!
Hey,I'm converting data from IFC to CityGML. I used the GeomertyPropertyExtractor to extract attributes from the IFC PropertySets. These attributes all have the datatype string. These attributes are set as generic attributes in CityGML, but I want to change their datatype. I can do this for integers, doubles,... in the CityGML-Writer. But I also want to set data types like meter and square-meter. CityGML supports the data types like meter with the data type MeasureType.Does anyone know how to set these data types?Thanks
Hey FME 2019! What's up!? Do you know how I can calculate a value and pass it through the Start Column / Row Excel Writer parameters? I don't see the way to do it! There is no Attribute value option. Thanks!
Hello, I'm trying to clip a dxf file with a shapefile into sections and export back into separate dxf files. I'm using the clipper but I'm unsure whether to merge individual feature types on import and how to retain all the layers on export.
I have an ArcPy script that is simply renaming ~40 datasets in an ArcSDE database. I'd like to run it once by Master FME workspace is complete (set of workspace runners ), so i had thought of using the Shutdown Phyton Script in workspace parameters. However i am very new to FME and to Python to be honest, so it's all a bit confusing (even after reading the information relation to the Python transformers etc).Can i simply copy and paste my script into the blank window of the script parameter? i.e. import arc py, list variables, include updates to be made etc? or is there a way of including the file path to the python script that sits on my c:drive and have FME activate it? Thank you in advance
Dear All ,I have a roofs & footprint of each building, from this how i will create all the below mentioned attributes in Shape file (.shp).Please help and suggest.1,Unique Feature ID2,Reference Name – China3,Building Area (m)4,Building height Values (m): Max, Min, Mean, 75th and 25th percentile5,Building Height will be orthometric (Mean Sea Level) and Above Ground Elevation (AGL)6,Building attributes will be MSL_Ground, MSL_Min, MSL_Per25, MSL_Mean, MSL_Per75, MSL_Max, AGL_Min, AGL_Per25, AGL_Mean, AGL_Per75, AGL_Max, Shape_Length and Shape_Area
Hi all,I am having issues viewing spatial data outputs in ArcPro or ArcMap. FME successfully writes all features to either feature class or shapefile (tried both) but when I open the data in Esri many of the features are not displayed. This doesn't happen all the time, but its been an issue with multiple workbenches all doing different things. When I add the result layer to Map/Pro the correct number of features show in the attribute table but the 'problem features' have the following issuesFill symbology not applied, only outline symbology (i.e. Problem features not selectable with "Select By Attributes" toolProblem feature only selectable using select tool if the selection box cross feature outline The image below shows layer results right after adding to ArcPro. Copying the feature class either by catalog or copy features tool does not resolve issue, but running a tool like buffer with 1cm seems to fix it. Any ideas? Much appreciated!
Hi all, I have over 15,000 GML files, totaling 43 GB, containing grids for OS Mastermap, and I want to stitch them together into one Esri Geodatabase.I tried a single merged feature type reader to a single writer, but it became painfully slow and only wrote a fraction of the files. Has anyone any advice or know any limitations to try and attempt this? Thanks in advance!Jack
I'm following this write-up on how to update AGOL hosted feature layer from file geodatabase feature class. I spent hours on a chat with FME tech support troubleshooting but no luck so far. This is my first experience with FME so I'm not sure what is going on as I followed directions precisely.The AGOL reader gets stuck after processing 24,000 parcels (30,162 total) and throws the error. I'm demo the software so its the latest version.
Our company is currently upgrading our Active Directory to MS AD 2016. We are reaching out to our vendors to ensure applications won't be impacted by the move to the latest Active Directory. We currently use FME server build 17539 and would like to know if this build will work with AD 2106. Appreciate the info.
Hello all,I am doing a simple KML to CSV conversion. For now I need the name and coordinates. I'm unable to extract the coordinates from the kml file, seems like a simple fix. I attached a sample file. Thanks for the help.
Hey all,So I am using FME server to run a workspace for multiple GML files. The workspace is taking the GML and transforming it for GEODFATABASE_SDE. Every job runs on same workspace and uses the same SDE connection file.The issue is that every time I run it FME server runs 21 jobs (1 for each GML file), fails 19 of them and succeeds on 20 of them and writes features to the GDB. It's never the same two files that succeed but the ratio of 19:2 is always the same.The error message is: An error occurred while attempting to retrieve the connection parameters from the connection fileThis is the same on all 19 failed jobs.I made a workspace runner and used a text file of all the files file paths as the input and ran them all through using that and they all worked fine first time.I have tried deleting the Writers and re-adding them to make sure there was no issues with them but still the same result, a random 19 will fail and a random 2 will succeed and write features to GDB.Any help or a
I'm trying to create a citygml file which includes an inventory of trees. Coordinates are obtained from a txt file but I would like to asign geometries obtained from more detailed file type such as SketchUp. I would like to know if there is a way to assing the sketchup geometry to several pair of coordinates. I've been trying using FeatureMerger Transformer but all trees are located in the same, which is logic because the supplier is located in the same place but, it's there a way to change it?.I haven't set up any citygml attribute because I haven't been able to change the geometry of the feature. After that I have to assing the base height or z coordinate from a DSM, I guess I will try with the transformer surfacedrapper.
Hi,Will anyone can help me on tutorial on citygml convert to Censium 3D titles? Thanks
Hi There,I'm currently working on a script that will run every month to send my co-workers updates on documents. However, if the filter has no outputs then there is no input to the FME Server Email Generator and it won't send an email. Except, I would like to be able to send an email in that case that says there are no updates but I'm not sure how to do that. Does anybody have an idea?Thanks
Hi,=============================How to delete the key "x" in a json attribute by JsonUpdater transformer:{ "x" : "aa", "y" : "bb" }=============================I send the feature both into the ports of "Document" and "Update", and setUpdate Type: "Delete From Object"JSON Path: json[*]Object / Array Index: x=============================but get warnings below:2016-06-16 17:27:38| 0.2| 0.2|WARN |JSONUpdater(XQueryFactory2): The following error occurred while executing query number 1: 2016-06-16 17:27:38| 0.2| 0.0|WARN |JSONUpdater(XQueryFactory2): The following error occurred near line 3, column 21 of the query: 2016-06-16 17:27:38| 0.2| 0.0|WARN |JSONUpdater(XQueryFactory2): xs:string can not be promoted to parameter type json-item() of function json-item-accessor()=============================Thanks
HI Team, I would like to know is there any way where I can know the Delta data of resultant of two shapefiles differences. I get some data from vendors frequently in shape file format. Every time I am getting a full dump of data in shapefile not the only updates. So, is there any way to find only delta data from the new shapefile comparing with old shape file. Please let me know the solution.
Hi all, i was wondering if it is possible to convert a gml file into a pdf? or convert the gml file into an image and place that image in a pdf? Thankyou
My question is more on the SoQL than FME. I have a JSON reader with a filter on hospitals located in GA and AL.In my workspace, the user enters a location parameter (Lat, long) which is then buffered by 50 miles. The 50mi buffer is then used as a clippee on the hospital points and this results to the number of hospitals in the two states that are within 50 mi of the user location entered during run time.I wanted the reader to be more efficient by using the SoQL function DISTANCE_IN_PARAMATERS on the filtered list. (Reference: https://dev.socrata.com/docs/functions/distance_in_meters.html)I tried several things but none of my attempts has worked so far.Once I get the results this will be published to FME Server where the workspace will be used in another app.<a href="https://data.medicare.gov/resource/xubh-q36u?$where=%28%28state ='AL'%29 OR %28state = 'GA'%29%29">https://data.medicare.gov/resource/xubh-q36u?$where=((state ='AL') OR (state = 'GA'))</a>
Hi, i would like to copy some files from a directory by using an ESRI shape file containing the name and the file extention.We have a directory with over 300+ aerial photos of our town. Every photo has an unique name. Using an georeferenced Esri shapefile of a specific area we want to copy the photos that are coverd by the shapefile to another directory.I used a feature reader that reads the directory. Apparently the feature reader reads the directory with the rasters and loads all the rasters into its memory. The scanning process of 300+ files (800mb each) takes very long and uses a lot of memory. This is a problem, we are short of memory. That is why i would like to use a selection polygon to select only the 4 rasters that i need and copy them to a different directory.How can this be done?
It is possible convert OBJ files (from LiDAR source) to FLT files with texture?I just select OBJ (input box) and FLT (ouptut box) and then RUN... but no textures...FME DESKTOP 2018Help, please: https://we.tl/t-7RksIu0kJZThanks
I have several workbenches running as jobs on FME Server that read/write to an ArcGIS SDE geodatabase in SQL Server. They all use a shared SDE connection file, currently stored in the \\Shared Resources\\Data folder on the server. One of the workbench jobs is apparently having an issue with this connection file. Whenever it runs (and the workbench logic allows trying to open the SDE geodatabase for a write operation), the job fails with this error:Creating writer for format: Esri Geodatabase (ArcSDE Geodb) Trying to find a DYNAMIC plugin for writer named `GEODATABASE_SDE'Loaded module 'GEODATABASE_SDE' from file 'C:\\Program Files\\FMEServer\\Server\\fme\\GEODATABASE9.dll'FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20180209)FME Configuration: No destination coordinate system setFME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20180209)Writer `FeatureWriter_2_0' of type `GEO
I am trying to adjust the text orientation by changing the fme_rotation attribute in the TextAdder transformer. However, the text orientation attributes does not take the changes. Do you know how I can access or somehow manipulate the values in the red box from the image below? In this example i have change the rotation to 116, but the text still have a rotation of 118.
Hi Everyone,I attempt to create a new work space in FME Desktop 2018 and add a reader to read .shp file. However, I wasn't able to create the reader and saw the following error:"Failed to obtain any schemas from reader 'ESRISHAPE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information"Can some one please point me to where I can resolve this issue? Which components are the culprit in this case? I've ArcGIS and ArcGIS Background Geoprocessing installed as well.Thank you for looking into this