Data

Hi FME team I started on using FMEObjectsDotNet4.dll and started reading CHM helpand I started to write some simple code, and I'm stuck on mapping FMEReader GEOMETRY column to another GEOMETRY column in FMEWriter FMEReader is from shapefile but the target database oracle table has 2 columns and I want to directly update to 2nd column, and seems cannot find the right "keyword" in CHM help, also the samples is not really helping with this problem C:\\Program Files\\FME\\fmeobjects\\dotnet\\apidoc\\FMEObjectsDotNet4.chmC:\\Program Files\\FME\\FMEObjectsDotNet4.dll Also in IFMEOWriter seems lacking IsOpen method to check whether the connection still open or notso we can do something about it. Maybe like manually commit ..    on another topic:1) is there a NUGET feed from you for this library like Telerik nuget feed https://docs.telerik.com/devtools/maui/get-started/install-nuget https://nuget.telerik.com/v3/index.json2) is there a link/resource/forum/video/training/repository

I need to revisit this answer, that I find to be a limited work-around, not a proper solution.The offending and unsupported type "mediumint" is not from the MS/SQL database, where data are sourced, so it has to be something that FME itself generates on the fly. Aka a bug.The database table has a field named ID, which is an "int" (32 bit), and it uses an identity value.This is how the schema feature sees the field:I really cannot understand, why FME cannot transfer this to a table in a Geopackage. The very same schema and data feature are used to create a GeoJSON with any problems.Please advise.Using 2022.1

Greetings,I am finding the settings...AutoCAD Reader > Parameters Tab> General Section > Layer Name field, Allowed Geometries field.....greyed out. How can I access and change these settings? Thank you,Tyler FME 2022.1

Can'i catch the contraints oracle with the FeatureWriter? I need to test the integrity of oracle and catch the exception and do something if an error occure.Execution of statement `UPDATE "MYTABLE" SET "STATUT_PRP_R" = :"STATUT_PRP_R" WHERE "OBJECTID" = :"OBJECTID"' did not succeed; error was `ORA-02290: violation de contraintes (PRP_AQU_BORNEINCENDIE_P_CHK) de vérification'. (serverType=`...

Hi,I posted this earlier on the Package page, but I'll paste it here to be sure to get an answer.  So, I get this error while trying to authenticate with my Google account: Authorization Error Error 401: disabled_client Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In. Learn more Request Details The content in this section has been provided by the app developer. This content has not been reviewed or verified by Google. If you’re the app developer, make sure that these request details comply with Google policies. access_type: offline approval_prompt: force response_type: code redirect_uri: urn:ietf:wg:oauth:2.0:oob client_id: ERASED.apps.googleusercontent.com scope: https://www.googleapis.com/auth/bigquery Is the package valid or is it something I should check on my side ?Thanks Philippe

I have comprehensive worskpace to write many tables in PostGIS, where all the target attributes are in lower case. Now I need to migrate this workspace to work also on MS SQL. I was able to change the writer and bulk update feature types table qualifier. The schemas are just similar to Postgres DB, but I'm getting errors because of the lower case of the attributes while writing to MS SQL.Importing new feature types from schemas is not a way because I need to maintain the attribute mappings on every feature type. For example, the table name in lower case is not an issue but column names are. I would need that the writer forces UPPER CASE on writing to DB or bulk change all the attribute names in all writer feature type to UPPER CASE. I´m not feeling to do all the mappings again from the scratch, if the schemas are the same.On the attached picture you can see the attributes from changed writer feature type (PostgreSQL->MSSQL, left) and new imported feature type (right). There is j

Hi, I wounder how I could manage to install the Rhino module for python (external package)? I have tried to look up info from:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/Installing-Python-Packages.htmand:https://community.safe.com/s/question/0D54Q000080haVOSAY/how-to-install-external-python-packages. What I seem to manage to do is to install the module with the following command:fme.exe python -m pip install rhino --target C:\\Users\\*\\*\\Documents\\FME\\Plugins\\Python\\python37 The module seem to be installed at the directory, but when I try to import it (import Rhino) using python caller I get the error msg:|Python Exception <ModuleNotFoundError>: No module named 'Rhino'.The Rhino module is a non-universal package and I have tried to verify python interpreter to both 3.7+ and 3.9+ when running pyhton caller. I am using FME v2022.1.2.0 64-bit. When I used to command line it prints; "INFORM: Using python interpreter **\\python39.d

Hi,  I am currently writing my master's thesis on the subject of "Geodata according to BIM".  In particular, the georeferencing of the IFC file using FME causes problems. In concrete terms, the necessary IFC entities "IfcProjectedCRS" and "IfcMapConversion" cannot be written. How are these defined and written with FME?  IFC Version 4 is to be written. (FME 2019.1.2.0 (Build 19630) and WIN64 are used for the data conversion.)  Do you already have experience with georeferencing IFC4 files using FME? 

There is a problem that it is not displayed normally when converting IFC Schependomlaan.ifc among the Sample-Test-Files files in buildingSMART.Is there any solution regarding this?​<abnormal>​<normal>Regards,Bongsup Kim​

In a project with archive software an export of a BigTIFF from FME is noticed as a ZIF format. So is the export of a BigTIFF really a BigTIFF? The problem is that BigTIFF is an open format en ZIF is not an open format. Information about ZIF:ZIF File Format Specification (zoomify.com)  

I'm using the new Revit file reader in FME 2020.In the Revit file, I have a view, with linked file. When I read the view in FME, the linked file is not read.Any suggestions?

Hi everyone, I am trying to extract some features from a WFS, but it is giving me an error. I'm reading from: https://geodata.nationaalgeoregister.nl/kadastralekaart/wfs/v4_0?service=WFS&version=2.0&request=GetCapabilities And this is the filter expression I use:  <Filter> <Or> <PropertyIsEqualTo> <PropertyName>AKRKadastraleGemeenteCodeWaarde</PropertyName> <Literal>WMV00</Literal> </PropertyIsEqualTo> <PropertyIsEqualTo> <PropertyName>AKRKadastraleGemeenteCodeWaarde</PropertyName> <Literal>KMN01</Literal> </PropertyIsEqualTo> <PropertyIsEqualTo> <PropertyName>AKRKadastraleGemeenteCodeWaarde</PropertyName> <Literal>ZDM01</Literal> </PropertyIsEqualTo> <PropertyIsEqualTo> <PropertyName>AKRKadastraleGemeenteCodeWaarde</PropertyName> <Literal>KOO00</Literal> </PropertyIsEqualTo> <PropertyIsEqualT

Hello,  With help from this community I was able to round the x,y,z coordinates of a pointcloud (see->Rounding IFMEPointCloud XYZ components) and it seems to work when I click on individual points they have 3 digital numbers (=precision). However, when I write them with the Pointcloudxyz writer to a .xyz file the precision is not correct. This topic has been discussed here: https://community.safe.com/s/bridea/a0r4Q00000HbrBDQAZ/point-cloud-writer-support-precision-control. Is there already a solution in place ?  I also tried the pointcloudtopointcoercer-> coordinate extractor -> csv writer but the first transformer is already taking a long time to run so it would not be an efficient solution. Thank you!

I use FME 2019.1.3.1 with ArcGIS Desktop 10.8.1 (also have Background Geoprocessing Tools installed) and I have encountered a problem when reading a specific table in an ArcGIS Geodatabase. The Geodatabase is stored in a MS SQL Server database. This have worked well for a long time but for the last days, I got this error:2021-05-06 11:20:22|   1.6|  0.0|ERROR |Column 34 is 2021-05-06 11:20:22|   1.6|  0.0|ERROR |Error while performing SE_stream_query. Specified where clause is '"Column1"=28310'.:SDE_ERROR_CODE(-66) Invalid parameter value passed to function2021-05-06 11:20:23|   1.6|  0.0|ERROR |A fatal error has occurred. Check the logfile above for details2021-05-06 11:20:23|   1.6|  0.0|ERROR |2021-05-06 11:20:23|   1.6|  0.0|ERROR |A fatal error has occurred. Check the logfile above for detailsNothing has changed in the workspace since last time it runs successfully so I guess that there is something in the database. I can read other tables in the same database without any problems

How to convert .las file to .fbx using FME Desktop?

Hello everyone,my current project is to generate a citygml model from CAD data, point cloud and DTM. The building model has LoD0 and LoD1 ready, I'm working on LoD2 now. I followed some tutorials and the OGC documentation in CityGML, however, the representation of the buildings is not coming out correctly. Here are some steps that I followed and can be seen in the wokspace print: - I separated the solids on surfaces (deaggregator), storing the gml_id of the original solid (parent_id); - identified the surfaces that were shared by two buildings; - removed the geometry of the original solids (geometryRemover); - In solids, I created the list with the IDs of the surfaces that composes the solids "citygml_bounded_By. {} Xlink_href" (matcher); - For solids, I set LoD name = LoD2Solid and Feature Role = cityObjectMember; - I separated the surfaces in Roof, Walls and Ground by normal (PlanarityFilter); - And for surfaces, I set LoD name = LoD2multiSurface and Feature Role = Boun

Hi everyone, I'm testing the B360 Connector. I can log in okay, but when I click on Hub, it searches for a while but then finds nothing. There are definitely projects in our B360 instance. See screenshot below, can anyone help? Cheers.

I have a workbench that reads features from a table from Microsoft SQL Server Non-Spatial and writes (Feature Operation: Update) into the same table. I have read and write permissions, reading is working fine but writing gets the following error message:Microsoft SQL Server Non-Spatial Writer: Connection failed. <connectionstring>. Provider error `(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server [53]. ' Failed to open writer Failed to open writer f_22(CreationFactory): Failed to open writer I've tried several things, but none of them is working. I've read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and this https://knowledge.safe.com/questions/39002/connection-issues-to-ms-sql.html Our settings in SQL Server: 'Named Pipes' is Disabled and 'TCP/IP' is Enabled. We can enable 'Named Pipes', but the server service then needs a restart (we don't want to restart

Hello,After migrating to FME 2022.2 (desktop and server), I get errors on each workspace that uses Oracle Spatial FeatureReader with a spatial filter:I tried these workspaces on FME 2022.0 and everything works fine...I don't really feel like reinstalling another version of FME Server, so any solutions/workarounds are welcome :)(Using spatial SQL queries instead of FeatureReader is not an option)

simple question: Why does reading this netcdf fail with any (combination of)setting(s)? It works fine in Qgis https://www.ncei.noaa.gov/data/international-comprehensive-ocean-atmosphere/v3/archive/nrt/ICOADS_R3.0.0_1750-07.nc

Does FME supports reading / writing to CityGML 3.0 version?

I have been using this transformer for quite some time and have been living with the pain.i have done some more testing with it and discovered that if i don't use recurse there is a significant performance gain with a giant functionality loss!it can take anywhere from 5 minutes to HOURS to get a response from the initial read in dektop. slightly better in server however i am ussually not waiting on it at that point (if i need it to work i publish to server and walk away) it may be tomorrow before it completes.are there any workarounds. i have considered trying to use a system caller to just do a dir and get really bad data back and rebuild it from that. 

Does anyone know if the newest version of FME still supports QUADRI- and QMS-files? I tried to add a QUADRI-file as a reader, but I get the following error message:  "Failed to obtain any schemas from reader 'GDMMAPPERQUADRI' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading." 

Hi,I am trying to insert a watermark disclaimer into construction PDF's as part of a distribution workspace that is an part of a FME Server App.The key part of the workspace is that pdf's are filecopied into a zipped folder before being distributed, these pdf's range in size (napkin to Arch D, to legal letter, whatever was scanned), but the disclaimer can be in the same spot (ie. bottom left hand corner, 150x, 150y). The PDF writers limitation is that it can only write to certain page sizes, which is an issue, so inserting a text disclaimer is not feasible.The filecopy maintains the page size/pdf quality, but I am at a loss for adding a watermark/overlay/text.FME Desktop 2021.0FME Server FME Server 2021.0.1 Thanks!

I am reading all JPGs contained in a location (including subfolders) and manipulating the attributes. Then, using the filecopy writer, I am moving them to a new location. I am having a hard time getting them to move with the name I am defining in the Text Editor. The original name is retained every time. Does anyone have some advice for me?