Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 7,088 Posts
  • 26,099 Replies
7088 Posts
U
unitysopra
asked in Data
How to convert .las file to .fbx using FME Desktop?

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

1810
egge
Contributor
M
mamaieron
asked in Data
LoD2 buiding output without link to surfaces (using boundedBy xlink: href attribute)

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

490
S
bush_walker
Contributor
bush_walkerContributor
asked in Data
BIM360 Connector - Cannot find Hub

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.

110
birgit
Influencer
toin
Contributor
toinContributor
asked in Data
Microsoft SQL Server Non-Spatial Writer: Provider error `(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server [53]. '

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

2320
jatoxa
Contributor
lau
lau
asked in Data
Oracle Spatial Reader : All spatial filters failed... FME 2022.2.

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)

280
lau
michiedem
Contributor
michiedemContributor
asked in Data
Why can't I open this Netcdf?

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

210
michiedem
Contributor
nitinshahane
Contributor
nitinshahaneContributor
asked in Data
Does FME supports reading / writing to CityGML 3.0 version?

Does FME supports reading / writing to CityGML 3.0 version?

370
nitinshahane
Contributor
gisbradokla
Enthusiast
gisbradoklaEnthusiast
asked in Data
directory and pathname reader performance lag

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. 

630
gisbradokla
Enthusiast
rmpayaby
Contributor
rmpayabyContributor
asked in Data
QUADRI and QMS

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." 

310
jovitaatsafe
Safer
dmerrick
Contributor
dmerrickContributor
asked in Data
Insert watermark into PDF

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!

640
dmerrick
Contributor
E
emorris4
asked in Data
How to rename a file when using filecopy to move them to a new location.

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?

2810
dmerrick
Contributor
ctredinnick
Supporter
ctredinnickSupporter
asked in Data
Spatialite Native geometry support with SQLCreator

I have been investigating replacing my use of SQLite Spatial (GDAL) with the new (FME 2022) SpatiaLite Native format.Previously I used to be able to start a workspace with a SQL Creator with a statement like:SELECT id, column, geometryFROM table With a script like that, the old SQLite Spatial (GDAL) format SQLCreator would read the geometry correctly from a database created by a SQLite Spatial writer. However, I can't get the same to work with a SpatiaLite Native SQLCreator selecting from a database created by a SpatiaLite Native writer. Instead of reading the geometry of each feature, it reads a blank string attribute called geometry.Is selecting a geometry with a SQL statement no longer supported? I can probably replace this sort of use with Readers, but would prefer to not.Thanks.

892
ctredinnick
Supporter
T
tobibruehlmeier
asked in Data
Translation successful, but process keeps running

HiSituationWe have a quite simple FME Workbench, loading CSV data from an URL, and writing it's data to a MSSQL database. The workbench works fine, writes all data and terminates with "Translation was successful". ProblemSometimes (actually mostly) the workbench doesn't stop right after it logs "Translation was successful", as it's supposed to do. Everything's done, all records have been inserted, but the workbench keeps running. Sometimes it takes 5min or 10min, sometimes it takes days until the workbench stops.The screenshot shows the situation. In this case it was a time lag of 5 min. FactsFME 2018.1MSSQL 2016; it's on the same machineWith PostgreSQL or Oracle we never experienced the same issue Any ideas or hints?Regards, Tobias

1130
fdw
Contributor
E
eric.collins
asked in Data
I need to run approx 10K zipped LAS ASPRS files and generate an xyz file with 5 m grid using ground values. Looking for a workflow to do this.

I need to run approx 10K zipped LAS ASPRS files and generate an xyz file with 5 m grid using ground values. Looking for a workflow to do this.

70
caracadrian
Contributor
joe.fme
Contributor
joe.fmeContributor
asked in Data
Connection to Sharepoint List Reader and URL formatting

Hi all, I've been tasked with trying to connect to a Sharepoint list and have the appropriate security (read-only) applied to the sites and file/lists. When I try to read in the Sharepoint URL with FME, I am presented with errors, be it for Web Auth, Basic, NTLM or Kerberos. I've attached screenshots of the errors. Any help is appreciated. I do also have another URL which is formatted as "https://<site>.sharepoint.com/sites/<subsite>/_api/web/lists" which I have tried as well, but to no avail

310
joe.fme
Contributor
T
tgroeneveld
asked in Data
GEODATABASE_SDE Writer Specify a backslash in table qualifier

I have a sql server table that I do not own but have full permission on.I can setup a GEODATABASE_SDE Reader and read it no problem the table qualifier is "abc\\username" When I try to setup a writer for it the Table Qualifier gets set to _abc_username_ When I try to write to it I get an error message statingGeodatabase Writer: Feature Class or Table '_abc_username_.table_nm' must exist when Table Handling is set to 'Use Existing' Unfortunately using FME2018.

1510
frro
Contributor
datablue
Contributor
datablueContributor
asked in Data
How to write csv file to AGOL?

I have a writer that creates a CSV file to a folder on my computer. How do I write this CSV file to AGOL (ArcGIS Online account)? I already understand how to write data to an AGOL Feature Service. I need to create a CSV file to my AGOL account. I plan to update this CSV file every night (via the Task Scheduler) and share it with others. I'm using FME Desktop (not FME Server). Thanks.

1870
datablue
Contributor
A
aritchie
asked in Data
Is it possible to define the layer ids, or layer order when using ArcGIS Online Feature Service writer?

I'm a bit surprised I haven't found this answered already - maybe I'm just not seeing it. When using the ArcGIS Online Feature Service writer - is it possible to define the layer ids, or layer order that will be used when creating a new feature service? I want to help ensure that the new layer ids match previous ids. Since the writer can't add new layers to an existing service, I need to delete the existing service first. Do I need to ensure the different layers are passed to the writer in the preferred order? Thanks!

530
A
K
krishnamohan
asked in Data
Copy classiffication from one LAS file to another LAS file

Hi, I have two LAS files of same area. One is the classified data and another is unclassiffied data. I want to copy the classification from the classigied LiDAR data to Unclassified LiDAR data. Any help is greatly appreciated. Regards, Krishna

710
kailinatsafe
Safer
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Data
CityJSON textures/color support: Is there a timeline for this yet?

In the documentation I see that Appearances are planned for a future release. Just wondering if this is already on a timeline somewhere: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/cityjson/quick_facts_cityjson.htm @deanatsafe​ - perhaps you're the one to ask?

270
LizAtSafe
Safer
sigtill
Supporter
sigtillSupporter
asked in Data
Raster with 1 channel and 3 values as palettes - strange!

I`m trying to make a strange raster, due to a specific software demanding exactly that format.  It seems to be a GeoTIFF with 1 rasterband (UINT8) that has palettes with 3 values (RGB). See below for more information. I have managed to create the 1 channel TIF with the correct value, however I struggle to add the palette, and add the correct value for each palette to each pixel. Since FME can read the file correctly, I assume it can also create such a file, however I am stuck after examining all the RasterPalette* Transformers.  Any raster-wizards out there? 

400
sigtill
Supporter
mhab
Contributor
mhabContributor
asked in Data
FME 2021.2.6 64-Bit reading/writing Esri ArcSDE 10.8.2: Issue with missing BG Geoprocessing

I successfully can read/write Esri Arc SDE (Geodatabase) with FME 2021.2.6 64-Bit and ArcGIS 10.8.2 + Esri BG Geoprocessing installed. So far so good. If however ArcGIS Server 10.9.1 is also installed in the same enviroment, problems arise and an error message appears, that "BG Geoprocessing is missing" and needs to be installed. What is the issue here ? How can it be solved ?It seems only uninstalling ArcGIS Server 10.9.1 solves the problem, but I need ArcGIS Server for other reasons/applications. B.T.W.: ArcGIS Server 10.9.1 is the corresponding version to ArcGIS 10.8.2, in case you wonder about the version mix ;-) Thanks for any clue about this Michael  

270
danminneyatsaf
Safer
rishi1804
Contributor
rishi1804Contributor
asked in Data
I am working with DWG Civil 3D. I want to Read Property set of civil 3D models. How can I expose the attributes from Property set?

Also When I am trying to use Civil 3D and CAD Entities. I am getting reader error "BADNEWS: BADNEWS: No geometry mapping entry found for 'autocad_wipeout' in metafile 'C:\\Program Files\\FME_2022_1\\metafile\\CIVIL3D.fmf'. Please visit http://www.safe.com/support"

3510
natalieatsafe
Safer
timnil00
Contributor
timnil00Contributor
asked in Data
How to read DWG file in FME with attributes data

Hi! Im having a struggle to merge the "objec data" to the "block" or the actuall autocad_ellipse. When i zoom to line 1 it contains no geomtery, how can i add the object data to the ellipse (line3)?   

160
danilo_fme
Evangelist
kathyjbryce
Contributor
kathyjbryceContributor
asked in Data
AWS DynamoDB reader certificate error, but S3 and SQS working with certificate

Hi,I have a service account that I use for connecting to our company's AWS, this works successfully for S3 and SQS and DynamoDB on a windows server. However using the same workspace, same AWS account on my laptop I get the certificate error:PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target- I've upgraded to 2021.2.6 as suggested in other posts.- I've confirmed it is not a certificate issue on my laptop because SQS and S3 are working (this didn't work before I installed the certificates).- I've confirmed it is not an issue with my AWS account permissions because I can run the workspace on the windows servers. Any ideas what the issue could be? How does the DynamoDB reader work, is it looking somewhere different for the certificates? What is the HTTP request it makes behind the scenes so I can test with other applications? Thank-you!Kathy

1100
kathyjbryce
Contributor

Badge Winners

  • FME Form Advanced Training
    maz.ghasemihas earned the badge FME Form Advanced Training
  • Welcome Back
    nataliarojashas earned the badge Welcome Back
  • Integrate Spatial Data
    dezuviriamhas earned the badge Integrate Spatial Data
  • FME Form Basic Training
    johnrochehas earned the badge FME Form Basic Training
  • FME Form Advanced Training
    sahan969has earned the badge FME Form Advanced Training
Show all badges

Community Stats

31,801
Posts
120,804
Replies
39,418
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.