Using readers and writers to extract and load data.
Recently active
I am translating a group of point objects at different rotations from Smallworld to Microstation V8i. The same object in Smallworld and using the same FME translator. The resulting DGN has different size cells to represent the same object. The point objects that are at 0, 90, 180 or 270 are the correct size when translated but other angles translate larger. I am open to any ideas on why this is happening and what can be done about it. Thanks
Ultimately, i aim to end up with a map where you know depending on your location, where your nearest point is, represented by area.
Dear All,I need a full video tutorial to convert objects on Micrcsation v8i software to Autocad software using FME software?Someone did it, please guide me.Thank you very muchPham ngoc Quang
Hello,I want to create simple mesh trees from Point Cloud (LIDAR) in FME. And the closest thing I came to was with the "PointCloudSurfaceBuilder" transformer.Can anybody help me with this, please. The file is the way I want the final trees look like (it seems like it is about 8 piece of pentagon polygons for each tree).And the file is the closest I came in FME.I attach the FME-Workbench file and the input LAS file (and it looks like this ).Best regards,Jonas
We are working with a legacy dataset of scanned images and are moving everything to SharePoint. We discovered these files that have all the document information stored as a title property that is lost when moving to SharePoint. We are hoping that there is a way we can rename these files with the title information using FME. I have tried to expose it using the Directory and File Pathnames reader but cannot find the attribute anywhere.
Hello,I use FME to transform data in S-57 format (the native format of our databases) into more traditional formats, in particular shapefiles. The database export is therefore in S-57 format (extension .000), with the classes and attributes present for the ENCs, but this model is enriched with additional attributes and classes. This can be done by modifying the files s57attributes.csv, s57objectclasses.csv and s57expectedinput.csv in the directory $FME_HOME/s57 (Custom Object Classes File and Custom Attributes File). These files are also useful for correctly displaying additional attributes and classes in QGis (in the directory C:\\Program Files<QGIS>\\share\\gdal). While in QGis an S-57 file with additional classes and attributes is displayed correctly, this is not the case in FME.For additional classes: some are handled correctly, others generate an error when read and you can't go further in the processing (there are also cases where the class seems to be ignored, without
I want to extract data within the masked polygon by using FME. Can you please guide me how it should be done. Which transformer to use?
Hi, I'm trying to convert An AutoCAD(DWG) file to Esri Geodatabase with the labels (Annotation) to attributes. How can I do that?? and also if I have the Geodatabase schema, how can i convert these labels to the attributes?
The SFC (Scadec Feature Comment file) file is a format for Japanese specifications; it is used to store CAD data and is included in the SXF (Scadec data exchange format) format, a CAD data exchange standard.
I have a Data collected using Survey123 but sending data has issue and it was stored in android device only , so the format will be in sqlite database.. I want to extract the data from SQLite database and im able to read and see the data but not able take it into XML Fragmentor ..May be im doing some wrong.. I have attached screenshot and workspace ..Need Guidance and advice to fix this Thank YouNeed expert advice
So I have created a work space with an SQL Creator to query a table of inspections I am interested in. It seems to have the proper number of results showing, but I am not sure how to actually view the queried table in the FME interface. I also have a feature class from our SDE in the workspace as well as the table of ALL the inspections. What I want to do is only use the related features that would match to records from the SQL Creator query to export to ArcGIS Online. I also want the full inspection table to also be exported to ArcGIS Online, so that a user can click on the feature and see all related inspections (which should include the one from the SQL Creator). Hopefully that makes sense. Here is what I have so far...what do I do next??
Hi all, Trying to read in UK LiDAR composite data via a FeatureReader and spatial filtering - https://www.data.gov.uk/dataset/01b3ee39-da3f-47b6-83da-dc98e73a461f/lidar-composite-dtm-2022-1m I see there is an Esri ArcGIS Image Server Reader (https://docs.safe.com/fme/2021.1/html/FME_Desktop_Documentation/FME_ReadersWriters/arcgis_image_server/arcgis_image_server.htm) which should help facilitate this - but it is not available on 64 bit. Is there any update as to when this may be supported or a current workaround for 64bit? Thanks!Jack
We noticed that the speed of data writing to the DGN format depends on the type of objects. If we set the cell object at the beginning the writing was fast, then at the end, the speed slowed down several times. And the question is, is it a writer's trait or an object's trait?
Hi, we have a citygml file that contains a bridge. The validation by "citydoctor " showed no errors. Now we wanna extract the geometry. FME can read the file without error. But only a core element is shown and I cannot get the geometry!By the way we got the same result with the template bridge from the university (KIT)! Does anyone have any ideas or tipps for me?Thanks in advance.
I am trying to add an ArcGIS Server Feature Service reader to my workspace. I just need one of the layers from the service. Several of the layers have the same name but are differentiated by their parent layer (which are scale dependencies). FME Desktop Help claims it shouldn't be a problem, stating "The reader resolves ambiguity by appending the layer ID to the end of feature types if multiple layers share the same name. If a layer ID is present in the feature type, the ID takes precedence over the name." That doesn't appear to be happening because I receive the following when I select my desired layer and try to add it: "ArcGIS Feature Service Reader: Found multiple layers/tables that match the feature type 'Stations, PNM (4)'. They are: 'Stations (4), Stations (10), Stations (16), Stations (22), Stations (28), Stations (34), Stations (40)'. Resolve the ambiguity by specifying the layer/table ID in the feature type." Ok, but how? I do so in
I would like to insert to a Postgres table where ther is set up an trigger event with hstore function to write to another table. While running in common SQL client with "public" search_path, there is no problem.I can't make it run in FME workspace, always getting an error:ERROR: function hstore(vfk.par) does not existwhere "vfk.par" is the table I'm writing to. I have tried to add search_path "public" setup in "SQL To Run Before Write" but with no luck. Any hints, please?-------EDIT: In another workspace with another schemas but with similar tasks it runs without errors as expected. The triggers with its functions are almost identical.
I renamed a hosted feature service in ArcGIS Online and now need to update the name in a few FME workspaces (FME Desktop 2020.1.2.1 - Build 20624). But how? The feature service path is not editable under Parameters and neither Update nor Import Feature Types accomplishes the task from what I can see. It looks like I can do so using Find and Replace in a text editor but I'm not entirely comfortable with that solution. Is there a standard method I'm overlooking? And yes, I will be replacing the feature service name with the item id moving forward so this is no longer an issue. 🙂
Hi All, I was wondering if its possible to retrieve attachments from one feature service in portal and insert them into another table within a different feature service in portal. I am able to read the attachments however i dont understand how to write these attachments back to another table without using the arcpy interpreters.
Hello I’m new to FME. How do you rename a source_file (MapInfo.Tab) and copy it to another folder using a Filecopy writer? I've seen similar questions to this but I still don't know how to do it. I managed to replicate the Filecopy following the instructions here: https://knowledge.safe.com/articles/How_To/Including-files-dynamically-in-a-data-download-result .However, I want to rename my MapInfo tab file (which I am copying with the Filecopy) and I’m not able to do this. This is what my process looks like: The source table is named Car_Parking.Tab and I want it to be CARPARKING.Tab in the output folder. Landmark is copying fine and I don’t need to change the name. These two are part of a bigger workbench which copies many files. For now Car_Parking.* is copying as Car_Parking.* to my output. I did try various things -changing the _filename_part in an attributecreator, Fanout options (I managed to create a CARPARKING folder )- Creating a Path and file name reader... etc-
Hi when I reproject dwg file from NAD27_MTM_zone_10 to NAD_1983_CSRS_MTM_10 using Csmapreprojector, it reprojects all elements of DWG files execpts Arcs. is there any setting that handle this issue?
Example: First user parameter is choice type with values is Provinces (Ha Noi, TP.HCM, Da Nang...)Secondary user parameter is also choice type with values is Districts (Hai Ba Trung, Dong Da, Ba Dinh,...)I select User Parameter 1 with a province and it'll filter and just show choice are districts of this provinceIf you know how to solve let's show me! Many thank!
The folder that should be containing the .fmeks file has .jceks files. Everything was working correctly before I upgraded to ArcMap 10.8.1. Error message is attached.
Is there a possibility to suppress annoying WARN messages of the 'Autodesk AutoCAD RealDWG DWG/DXF' FeatureReader? Please see the following example:I use the AutoCAD reader to read features from an DWG file. I am only interested in the features of one specific layer (specified by a user parameter):Hence, the AutoCAD reader reads the file and skips all layers but the specified one. In the log, the reader starts writing which layers are skipped. These messages are written at 'Information' level. After writing the 10th skip message, it writes a message "Further instances of this message will be suppressed" on WARN level. -----As text:2023-03-23 14:17:38| 1.8| 0.0|INFORM|AutoCAD Reader: Successfully opened the 'Release2018' AutoCAD file '<SOME_PATH>'2023-03-23 14:17:38| 1.9| 0.1|INFORM|AutoCAD Reader: Features for feature type '0' will be skipped based on the feature types requested2023-03-23 14:17:38| 1.9| 0.0|INFORM|AutoCAD Read
I am getting the following error when I use the ArcGIS Online Feature Service Writer: "ArcGIS Online Feature Service Writer: Multiple Global IDs defined for feature type 'd_y_n'. This is not permitted." I am trying to copy the data from one ArcGIS Online (AGOL) hosted feature layer to another hosted feature layer with the identical schema. The source is a view-only feature layer, and the target is an editable, blank duplicate of the source. The target has hasVersionData=false and supportsApplyEditsWithGlobalIDs=true. All layers with attachments have global IDs defined and all attachment relationships are defined to use GlobalIDs as keys. In the Writer parameters, I have tried Use Global IDs=No and also UseGlobal IDs=Yes and Preserve Global IDs=Yes. I still get the same error with either of these cases. What might be going on here? I can't say I really know what the error is getting at. Might the problem be that there is at least one table that is related to two ot
Hi, I want to update an ArcGIS Online hosted feature service which has read-only 'Editor' and 'Creator' Fields. Has anyone been able to update read only fields on ArcGIS Online? Thanks