Using readers and writers to extract and load data.
Recently active
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
Hello, Really dumb question: can do I use FME workbench to create a new folder, ideally with todays date?Will the filecopy mover just create the folder if it doesn't exist? CheersN
Hello,I have troubles with the creation of IfcTesselatedItem.When I create an IfcBuildingStorey object in a FME Workbench (v. 2020)automatically IfcProject, IfcSite, IfcBuilding and IfcBuildingStorey are created in the ifc file: Otherwise, if I create a IfcTesselatedItemonly IfcProject is created: How it's possible to create IfcTesselatedItem objects with FME?Thanks for all suggestions and help
When reading NMEA log ( ) using the flow pictured below, some of the lines have an erroneous timestamp.Using FME(R) 2020.0.2.1 (20200511 - Build 20238 - WIN64), GPSBabel 1.6.0.Is there something i'm overlooking?
Hello there, Hope you are doing well and safe. I am trying to connect to a SharePoint list but I did not have any success with FME 2018, so upgraded to 2020. However, still, I am getting errors. Could you please advise. Many thanksMohsen AADSTS70011: The provided request must include a 'scope' input parameter. The provided value for the input parameter 'scope' is not valid. The scope https://[TENANT].sharepoint.com/.default offline_access is not valid. The scope format is invalid. Scope must be in a valid URI form <https://example/scope> or a valid Guid <guid/scope>. Please see the screenshots.
Hello Everyone, I have a question how to copy row data, but cant seem to find an efficient way to do it yet. Below, attached is a Screenshot of the Original Excel file. The idea is to take a cell value (in this case the 0.10 in the blue field at the top) and copy it for all empty column values until it reached the next filled value (0.20), which will then be copied downwards in the column. So your result will look like this. I assume with something like: If CellValue Col x Value is EmptyThen Copy Col x - 1 Value to Col X Continue to Col x + 1 and loop Something along those lines.Has someone dealt with this before? CheersFred
Hi team,I was wondering if there was a timeframe to resolve: FMESERVER-14602?I have a number of large number of work spaces which use the Database Connection, whilst this works with Schedules I can work around using that, but would prefer to use Automations as the tags and search functionality is a lot easier to use. Also, are Automations primed to take over from Schedules in the future (i.e. if we're building something new, should we be looking to build workspaces within that space?)
I am looking for help to learn Apple MapKit JS to display IMDF files created by FME Desktop. Especially difficult is the process to create a JWT (JSON Web Token).I am trying to provide Church and School floor plans for Emergency Response.There are many Google Maps examples in http://maplab.orgThank you
Hello, I have features with geometries stored in a db. My process is manually currently:1. Reading the features from db and displaying on inspector with a background map.2. Open Google maps. Find the feature on google map. (for the example in this screenshot, it should be something similar to https://www.google.com/maps/@41.533164,-88.0750639,15.5z )3. Copy google map url (which is showing the respective feature) to an excel file. This excel contains all features id and their google map url.I would like to automate the process. Is this possible in FME?Or is there any way to locate automatically the features on google maps?
Using FME Desktop 2020, I'm writing to ArcGIS Portal (10.7) using the 'Esri ArcGIS Portal Feature Service'. This works successfully and the user attributes (field headers) are 'Full Title Case'.However my issue is when I use the reader 'Esri ArcGIS Portal Feature Service', it read back the feature, however all the user attributes are all 'lowercase'. Does anyone experience the same issue?The same issue does not appear when using the 'Esri ArcGIS Online (AGOL) Feature Service'.
Hi partners,This is to inform you that before the end of the month, Safe will be launching two global nurture campaigns to all local government and utility customers, educating them about FME and the subscription offerings for their industry. This campaign will run for approximately 3 weeks (May - June).UPDATE: The copy for this campaign are still being reviewed but we are able to share some high level details with you:- We are educating users about the benefits of the FME platform - Subscription pricing will be mentioned - The email campaigns will direct users to various resources (e.g. blog posts, webinars) specific to their industry - The primary goal of these campaigns is to educate and nurture leads and users, encouraging them to speak with either Safe Software or a Partner depending on their region We will be encouraging customers to reach out to their local partners for more information or if they have any questions about any content in the email.If you have any questions, pleas
Have FME Desktop 2020. It turns out that writing UPRN's into a CSV doesn't work for values above 99.999.999. Have tried all data types in the writer (real64 is the one that FME sets automatically, but have tried String, int64, etc..). Nothing works.Can somebody help me please? First capture is the output before writing csv (upper workflow): Second capture is the output after reading the CSV (lower workflow). Notice that there are 14400 records with null UPRN.
Is there a way to control the order of layers that are output to the DWG Writer or is that controlled by the DWG Template used?I have a number of layers say A,B,C but I want the DWG output to be B,A,C. If I output to a PDF the order of the layers is the order they appear in the PDF Output but if I send the same layers and order to the DWG they are ordered in the same order as the template. My guess is I just need to change the order in the template but just wanting to see if anyone knows of a way in FME.ThanksDean
Hi FME folks,My first post so go easy on me please :)We use FME at work for various geo-spatial projects and I've been asked to look into it's C.Vision capabilities. Previously I had a crack at anaconda and some GPU accelerated approaches but the amount of back-end stuff necessary to get started go a little too involved.I've gone through your video tute @dmitribagh as well as all the workspaces provided and with some solid hrs. of practice I managed to get all of them working. I am somewhat of an an FME newb with less then 50hrs. of usage at a rough guess.I'm trying to build a model for recognizing houses (roofs) in aerial photography. I've managed to create auto annotations using some footprint data which we have.Idea being that I need a "clean" image of a single house rather than a house surrounded by other houses, and annotations being rectangles sort of forces you to improvise. I have a bunch of negatives of empty lots which I manually created ... ...
Why my FME 2020 Doesnot Read IFCSpaces? When reading IFC Step Xml file with Read Ifcspace geometries' to Yes, but still not present in select feature Type. i tried on different IFC Files from Revit in FME 2020.
Dear all, Task: create DSM raster from point cloud with highest points in each cell 0.5 x 0.5m I tried with RasterDEMGenerator - but it's not taking the highest point in each cell. PointCloudStatsRasterizer receives good values, but i got holes. Is any tool to close gaps in raster, like SAGA GIS - close gaps? From LASTOOLS.lasgrid i received also holes: Or maybe any idea more? Thanks for help in advance
Hello,I am trying to read and oracle layer with -where- condition but i have problem because it failed with reading of character Ë or Ç.I get this error:ORA-01756: quoted string not properly terminated'If i replace Ë with E, it is ok.Find below part of the error log.
I am using the FeatureWriter transformer to write an AutoCAD drawing (*.dwg). That’s working great. Within this drawing, I have an XREF. I am using the autocad_xref_name and autocad_xref_path attributes to identify the XREF drawing. This is working BUT the layer is linked to Layer 0 in the primary drawing. Any idea how to link the XREF to a layer other than Layer 0? This would allow the AutoCAD user to, for example, turn off the XREF drawing by freezing the non-Layer 0 layer. I tried the autocad_layer attribute but that just creates a new layer. Any ideas?
When using a Generic Reader with Guess format from extension, I know it is possible to create a "dummy" resource in the workbench to pass configuration parameters, but how do you set the preferred order of readers that is applied? Say for argument's sake I need to read TAB files using MITAB (not MAPINFO) or SHP files using SHAPEFILE (not ESRISHAPE). I'm not making a judgement on which reader is preferred, rather if you are required to use one that isn't the default, how do you do that?
I'm working with the Laspublish transformer to view point clouds in potree. The script runs fine but results in a blank html document. I have confirmed that the original Las data is valid via Data Inspector.Even the side bar css or html code does not seem to be rendering correctly.Any help is greatly appreciated!