Using readers and writers to extract and load data.
Recently active
Hi, I'm a Master's student using FME Workbench for my thesis project, and I'm using the Cesium 3D Tiles writer to convert CityGML files into Cesium 3D Tilesets. I am curious how the writer determines which features should go into which tiles? The Cesium 3D Tiles spec states that tiles are loaded roughly by distance to the camera; however, when I convert a large CityGML dataset to a 3D Tiles dataset, the writer scatters features over a large geographical area rather than clustering them together based on spatial location. I was also wondering how the writer calculates the bounding volume property of 3D tiles, as the bounding volume shows up as a very large box tilted at an angle. I would appreciate any insight anyone might have on how the 3D Tiles writer determines bounding volumes and how it determines which features are assigned to which tile. Thanks!
I am trying to update fields in a feature class that is attached to a geometric network. The feature class that I am writing to is a point geometry that is attached in the network to one end of a line. The error message is this: Error while updating feature in the table/feature class 'SDE.wServiceConnection'. The error number from ArcObjects is: '-2147217384'. The error message from ArcObjects is: {} I found a possible definition of the error online: (-2147217384) FDO_E_INVALID_CONNECTION_POINT_GEOMETRYThe geometry for a complex junction point is invalid.It appears that the issue is that my workspace errors out when the line length is less that 0.01 foot. I have tested this by finding one that erred out and then lengthening the line and rerunning the workspace with success. While there are only a handful of these in the feature class and they could be manually fixed, this workspace runs as a scheduled task and therein lies the problem. I wouldn't know when it err
I am running a simple read GDB Write GDB and adding a UUID in the process. I am getting this Error (-3). The source is a 3D line file 60K lines long and has four fields. (survey data). I've rerun the script several times and the error halts writing at different locations in the file.
The current way to convert revit files is to generate rvz files through ifc, but this process is very long and often not successful. Before I saw the official plan to do an exporter specifically for revit, but it seems that it has been a year and I wonder if the plugin will be released in the near future. Thank you.
Why does the shape file reader truncate the names attributes to 10 characters on loading / inserting the reader? I have fme version (FME(R) 2018.0.0.1 (20180328 - Build 18295 - WIN64)) installed.
Hi,Can someone please help me load this XLM file to FME?I am new to this tool and trying to convert this XML to Excel.
I'm trying to expose attribute only 'fill-opacity' from the below json.{"type":"FeatureCollection","features":[{"geometry":{"type":"Polygon","coordinates":[[[-81.0007,29.2057],[-81.0055,29.2029],[-81.0105,29.205],[-81.0107,29.2097],[-81.0059,29.2125],[-81.0009,29.2104],[-81.0007,29.2057]]]},"type":"Feature","properties":{"stroke-opacity":0.9,"fill-opacity":0.9,"hail_size_in_int":0.5,"hail_size_in":"0.5-0.9 inches","stroke-width":0,"fill":"#FFFFC0"}}]}It returns blank values. Can someone please help me ?
I am having problems translating a dgn with a custom line style to another dgn. no matter what I try in the FMW file the line style ends up with the line style saying "Not Found" and is a solid line. I made sure that the seed file had the .rsc file attached. perhaps it is the way I am creating the FMW. Any help would be appreciated
Hi....an easy one for you....i have features with list attributes ...list{0....list{1 etc....now i want to write it in an excel..... one feature per row.....every list attribute in a column...how can i do that?GreetzFranco
Hello!I encountered a bug in the AIXM 4.5 writer. The feature type "AIRSPACE_DERIVED_GEOMETRY" is mixing up the order of the elements in the resulting AIXM file. Therefor the output file is not valid against the AIXM 4.5 schema.The XML fragment which looks like this in the source file (AseUid and codeOpr are alternating):<Adg> <AdgUid mid="1"> <AseUid mid="1"> <codeType>RAS</codeType> <codeId>ABCD</codeId> </AseUid> </AdgUid> <AseUidBase mid="2"> <codeType>PART</codeType> <codeId>ABCD_1</codeId> </AseUidBase> <codeOpr>UNION</codeOpr> <AseUidComponent mid="3"> <codeType>PART</codeType> <codeId>ABCD_2</codeId> </AseUidComponent> <codeOpr>UNION</codeOpr> <AseUidComponent mid="4"> <codeType>PART</codeType> <codeId>
I'm trying to represent our city in a Minecraft world with the following data:dem (geotiff)ground cover (polygon shapefile)rails (polyline shapefile)buildings (obj)trees (point shapefile)Now, in the final Minecraft world the trees (and rails) are always "swallowed" by the surrounding ground cover. The thing is, I can see that the block ID is correct in the point cloud just before it enters the Minecraft writer. But after, they disappear and are replaced by the surrounding block IDs. I tried buffering the tree points up to 1m (because of the 1m block size in Minecraft) and cutting holes in the ground cover, but still the result is the same.Does anyone have an idea where the problem is? Do you need some screenshots for clarification?Thanks a lot! Natalie
This is data that have been received from client. They mention this data in Strumap format. I try to convert it to personal geodatabase but it failed.
Good Day FME'ers,I am having trouble writing to SalesForce. I understand the FME writes the features out to temporary CSV file before using the SalesForce Bulk API to load the data. The problem I am having is FME is dropping fields when writing the CSV file. Particularity, FME is dropping an ID field which is required in the SalesForce App. This ID field is Master-Detail data type (1:n parent-child relationship) and it set to read/write.What's frustrating is, if I export the records as a CSV field then upload them manually, it works fine. The log file and help are rather useless too.Thanks,David
If $(FME_MF_DIR) references "C:/project1/overview/tasks", is there a simple way to reference one directory up, ie: "C:/project1/overview" ? The way I am thinking is to process $(FME_MF_DIR) with some string functions, based on occurrences of the slash - is this the best way forward, or is there is more elegant or simple solution?Thanks
I have a Geodatabase Feature Class in ArcSDE/Oracle. Using ArcGIS software I published an ArcGIS Online Hosted Feature Service. The Geodatabase Feature Class will be editied manually, and I want to periodically send any inserts/updates/deletes to the ArcGIS Hosted Feature Service. (I don't want to truncate and append all data because that is too slow.)My .fmw file looks like below: (1)read the feature class and the feature service, (2)detect any inserts/updates/deletes , (3) write those to the feature service. I think the error I get suggests something is not quite right with my OBJECTID field: "ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in '<feature class name>'. The error code from the server was '1019' and the message was: 'The specified feature could not be updated or does not exist.'" Does somebody have a working example of this secenario that you don't mind sharing? (Screenshots would probably
Hello, I am wondering if something is possible to be done using FME. I have an Excel table that has many cells and entries. I need to manipulate with certain cell entries. One cell contains many entries. For example in one cell I have multiple parcel numbers and the name of cadastre municipality. I need to separate those values. They should make new row and copy all the cell values the same as previous but in that cell it should keep only for example cadastre municipalitys name and put the parcel number in new column. Any hints and help?
Hi,I'm reading an IFC file with an user-defined property set (PSET - Atrributs Mensura). I would like to check the values of those attributes. I don't understand why the DataInspector is able to read them (A_THEMATIQUE, B_TYPE, ...) but I can't reach them in the Workbench...any idea ?I'm using the "Industry Foundation Class STEP Files (IFC)" format with hierarchical data model and read property sets as Features.
I'm having an FME Workbench 2017 error reading my R datafile (.rda) with the RDATA reader and the licensed, installed StatTransfer 12 necessary to enable the RDATA reader. The error message reads: "'The signature of the input file is not recognized.'" What does this mean? How do I fix it?
Want To Connect ArcGis 10.5 Sde Mssql Database from Client Machine . It is Mandatory ArcGIS 10.5 at Client ? at client side 10.2 is already install .
Hi,I'm new to FME and just wondering if there's any support or other plug-ins in FME for ArcGIS Pro .lyrx-files. I wish to tranform a lyrx-file to open in ArcGIS desktop.
How can I set the precision for individual points in a point cloud? After applying a 3D Rotation on my point cloud, I end up with x and y values with a precision of 13 and 14 digits, when my source has only 6 digits. I've used a PointCloudCoercer to get individual points that I can then pass through a CoordinateRounder before recombining them with a PointCloudCombiner. It works, but the process is much longer than before.
I am trying to convert hundreds of Bentley Microstation RDL files to either shapefiles or a file geodatabase but have only been able to convert geometries and no useful attributes. All the RDL files have accompanying MDB files, which I believe hold the attributes. How do you complete the conversion while maintaining the attributes?Thank you!
Is there a transformer that can pull pipelines off a PDF and convert them into SHP files?
Hi,i have two readers:personal geodatabaseInterlis ITFI filter object from reader 1 and i need to filter reader 2 if an attribute is the same between 1 and 2.It's possible? Best regardsGiacomo
Hi!Does any one know of a good resource on formating FME output in excelfiles? I have, for example, an excel writer where I don't manage to get the rows that get written to land inside the table in my excel template. Instead the rows write themselves outside of the table, and then I have to go in manually to cut out and paste the rows into the table. There are many other small things and fine tuning I would like to do with the way my excel file gets written. Another couple of formatting things I want to learn how to do are hiding columns, filtering on certain values (while making the data still available in the sheet) etc. If you know of any, please recommend a good website,video or document where I can read more on these kinds of formatting tips and tricks!