Using readers and writers to extract and load data.
Recently active
In my workspace, I've three ESRI GeoDB reader Feature Types with WHERE condition. Here values in the WHERE condition are passed from a private/published parameter input values.Few things to be considered -There are approximately around 100 values to be passed in sequential order from Excel sheet to Parameter values.Workspace has to run completely for every input parameter value Currently I was passing each value manually to the parameter and is time consuming.Any thoughts on doing this more efficiently and quickly? Thanks in advance!
Hi, We have implemented a FME script that an ESRI GIS database on several computer. However the script fails on one computer and succeed on all the other. Here is the error messge return in the FME log file.2020-03-25 14:45:29| 23.0| 0.0|ERROR |FFS writer: Failed to open file '' for writing. Please ensure that you have sufficient privileges to write this file. If the file already exists, please ensure it is not open in another application2020-03-25 14:45:29| 23.0| 0.0|ERROR |BADNEWS: Internal Error: Failed to build feature table class StatusInfo *__thiscall STFFeatureTableWrapper::WrapperFeature::FTFeature::initChangedValuesWriter(void)(c:\\code\\fme\\foundation\\framework\\engine\\stffeaturetablewrapperfeatureftfeature.cpp:764) - class StatusInfo *__thiscall STFFeatureTableWrapper::WrapperFeature::FTFeature::initChangedValuesWriter(void)(c:\\code\\fme\\foundation\\framework\\engine\\stffeaturetablewrapperfeatureftfeature.cpp:764)2020-03-25 14:45:29| 23.1| 0.1|INFORM|Cl
Hi,I have been trying to create a multi-component polygon consisting of line, linestring and arc. The arc parameter consists of Start/From, Centre, End/To, the Radius in metres as well as the arc direction, clockwise or anti-clockwise. Negative radius indicates anti-clockwise arc. Using the python script posted by @takashi in here, I was able to generate most arc except for some instances. In the sample data, I have included 3 polygons. While ID=47 works fine, the other two polygons (ID=407 and ID=482) failed. I tried the Arc Property Setter method in the same post, unfortunately it yields an undesired gap at end points. I have attached the csv file containing the 3 polygons records and the FME workbench. Any help will be much appreciated. Thanks in advance.Lawrence Correct output polygons for ID=407 and ID=482 as shown.
When publishing to ArcGIS Portal the layer has some default configurations that I would like to change. For example, share to a group/everyone, disable editing and prevent the layer from being deleted. Any ideas in how to do that using FME?
I am working on land xml coding in primary stage and I need some samples of basic geometry (point, line, polygon etc.)
It is possible to get the units of a Revit model with the Native Revit reader? I can't find it defined anywhere. Anybody know if this is anywhere? https://www.cad-notes.com/revit-units/
Hello all, Last week we have upgraded FME Server from version 2018.something to version 2020.0.2. Initially everything seemed to be running smooth: scheduled jobs are run on schedule, and can be run manually as needed. But today I ran into a problem: it proved impossible to run a workspace manually from 'Run Workspace'. All I got was an error message: 'There was an error submitting the job.'.Delving into the logging, at last I found something in log file <server_name>_jobsubmitterservice.log: (located in Resources > Logs > service >current): the job was submitted as user guest, and this user was disabled.After enabling the user, I tried to rerun the workspace. THis gave me the same error message, but the log file provided new information: user guest lacked proper permissions.So I turned to the FME Server Documentation, where I learned that a user needs to have 'Run permission on the applicable repository'. As users (can) get their permissions from
Hi, I have a huge dataset sitting in a table in PostGIS, there are loads of duplicate geometries that I would like to identify and hopefully remove. I am trying to see if there is a faster way than doing a geometry match. Is it possible to create a hash of a polygon so that I could compare that? I can see its possible for point but not polygon data in PostGIS. In there anything FME can bring to the party?Thank you
Hi, I am working with an ifc extension file containing 11 floors. I worked with separate workspaces for each floor and created their topology. I want to calculate the shortest path in the building. For this, I have to combine the topology of each floor with stairs, how can I do this?Since the nodes created for topology slowed down the system, I had to work on each floor separately.
I have a shp-file containing Picture frames with attributes showing the name of the frame. I want to use this shp-file to select the correct raster images for the TIFF-reader. There are so many that it would take me some time to select the right ones... Fme_basename, the name of the TIFF-Picture in my folder photoID, corresponding name of the Picture in a subset of Pictures that I want to select for the reader
Is their any reader in fme available to read data from getech and convert into fgdb??
Hello,I'm looking for some help running a DXF to KML. I've not done this type of conversion before and wondered if there is anything else that should be added to the process?I'm currently running it on a generating workspace and a dynamic schema to write. The DXF contains:Point, poly, line, annotation and the coordinate system should be WGS 1984 UTM Zone 29NAny help appreciated.Thanks
Hello there we have this type of structure in our data Attvaluecity1ph1,ph2,ph3 and we want to get this structureattvaluecity1ph1city1ph2city1ph3 Any idea, please Thank you
Dear FME CommunityI have 70 different species datasets - Species 1, Species 2, Species 3, ..., Species 70. Each dataset is stored in ArcGIS Online. I want to write each dataset to Shapefile. I am trying to create a reader / parameter that will enable me to pick a single species to write to shapefile when I run the FME script. Can anyone assist please?The ArcGIS Online reader requires the following parameters for each species:Feature Service : MyFolder/Species 1/Species 1_WFLLayer: Species_1Regards, Damian
I'm running a process to generate around 1500 separate DEM's. Seems without incorporating break lines this process will complete, however incorporating break lines for the extents of the models has resulted in FME breaking the process about 1/10th the way through the series of groups with the following error message: get_next_capacity, allocator's max size reached I couldn't find anything with this error. The group by is set to blocking to ensure all features are loaded into the Generator, Both contours and spot heights are filtered to ensure groupings meet the minimum requirement to generate the model and carry the same group ID, as do the break line polygons (as these are also used later to crop the DEM). Any advice would be gratefully received . CheersChris
We are running into this issue https://knowledge.safe.com/questions/71601/mysql-database-connection-error.html and don't know if this is representative of what we should expect.
Hi Guys,i have a block on Layer 0 which includes also another block which is called Heizhaus.... i explode the block and Use block feature type for components so that i have them in the original layer in the Output: i also use a template filethat are the Basics:so at the end of my workflow (rot 1) the text is in the right Rotation and everything is fine ...but when i write it to the ACAD File teh text gets a Rotation which is false and i don't know where this Rotation Comes from. (rot 2)i have tried to write in the real dwg writer….. i have tried to fill certain Attributes like AutoCAD_rotation, fme_rotation, AutoCAD_text_rotation.. i have tried to read the Output DWG and set a new rotation and no Logical number (e.g plus 180, 360 Degrees or something like that)Nothing happens...Always the same false rotationAny ideas or helpsGreetzFranco
At the moment, the FME script extracts a dataset from ArcOnline and creates a new document with a filename of the previously edited date. Now, I want to have the data imported into Google Drive using a GoogleDriveConnector. However, when doing so, it creates multiple copies of the same document in the drive. Furthermore, when using a Creator instead of an excel reader, I am greeted with this line: Features not written - verify feature type fanout/dynamic settings. I was wondeirng if anyone could help me with this issue. Thanks!
I writter from oracle 9i reader to oracle geodatabase 18c by fme desktop 2018 it comes error running translate as file attache
I have IFC file exported from Revit with All the detail as required for lod 0 to lod 4 citygml, i want to extract lod 0 to lod 2 from IFC using bounding box, I can do that via IFC spaces, but thats not good for me, i have bounding box detail in my IFC as you can check in screen shot. What is the best method of Automatic bounding box extractor from IFC .
Hi there, With all the pandemic story, my organization is accelerating the migration to Microsoft Teams. They are asking us to migrate almost everything to SharePoint / OneDrive. I would like to know if there would be a way that I can edit my FMW directly from SharePoint. Right now I have to download my FMW, edit and repush it to SharePoint. It's kinda ennoying. Do you have any suggestions? I'Ve read this below but nothing about editing workspaces.https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/sharepoint/sharepoint.htm Thanks!
Hi, See my data below, I have lines that are grouped by countries, but each country has a rows that starts on April 1, but there is no rows in the last few days. You want to double the missing days, take the parameter from the previous day and fill in the missing data automatically, until the last day of May.Can you help me with that? Input data: Current: Expected: Thank´s Sorato
Hello, I would like to use a wildcard within a conditonal statement. But I don't know if this is possible. For example, I have the following records:MeldingFor object(s) 001, 002 the date dd-mm-yyyy is later than de original date dd-mm-yyyy. For object(s) 001 the date dd-mm-yyyy is later than de original date dd-mm-yyyy. For object(s) 002, 004 the date dd-mm-yyyy is later than de original date dd-mm-yyyy. I would like to use a conditional statement that gives me recors 1 and 3. So in this case it will become: Instead, I would like to use a wildcard, so that I only need one test clause. Because in my dataset a lot more combinations are possible. Is it possible to use a wildcard so that the test clause can become like this? (I know that % doesn't work, but I use it here to give an idea what I would like to accomplish). Thanks in advance,Eva
The meshes in the generated GLTF file is split into multiple meshes, and nodes' name does not have the information of globalID
Hello everyone, I need urgent help with my workspace for converting Sketchup to Citygml. Some posts among the forum say that FME wouldn't support the creation of XLinks. Therefore I created my workbench according to this old "How to write Citygml in FME"-Tutorial and used gml_id and gml_parent_id to express the part-whole-relationships. Now I found that if I use the Citygml_feature_types.xml file within the program folder to import the Writer Type, the autocomplete function provides a list attribute called citygml_bounded_by{}.xlink_href. I tried it out and indeed it created XLinks for the gml_ids I gave to it, but how can I manage to create a Solid with only XLinks referencing the BoundarySurfaces? With my current workspace it creates the geometries for the BoundarySurfaces twice + XLinks once. I hope you guys can help me -- many thanks in advance. I can also provide sample files to clearify my problem. Kind regards, Philip