Using readers and writers to extract and load data.
Recently active
Hi. I am trying to take a 3D model that is build with several grouped geometries into components. Source format is flexible, but say I have an OBJ file with "g" lines in it that define groupings of parts of my model. I can't seem to see these groupings in FME or export them into 3D tiles - I get one single group for the entire output model.
Hi guys i found alot of question about CSS selectorbut no answer to my case so I tried to post my question How can select the blue info <span>ISTITUZIONE TEMPORANEA DEL DIVIETO DI SOSTA PERMANENTE CON RIMOZIONE COATTA DEI VEICOLI IN UN TRATTO DI VIA DONATO BRAMANTE.</span> which CSS I have to use ? Sorry I'm new but the help need more more more examples from my point of view thx for support Francesco
Hi,I have a complex Excel report that we have worked on for half a year on and off as part of an ArcGIS Survey123 project. The users have requested a formula in the Excel. I am using attribute names as column positions and have not been able to get it working.I have tested it in an apart workspace:This works: This does not work: I get the error which I would expect: 2019-10-11 16:24:04| 2.5| 0.0|ERROR |Excel Writer: Column name 'Q.formula' for sheet 'Sheet1' could not be used as a column position. It either contains non-alphabetic characters or is beyond the maximum column of XFD for XLSX or IV for XLS If Q.formula is not present in the output feature class than the formula does not write either. Is there a way to write a formula to an Excel sheet using the Use attribute Names As Column Positions parameter = Yes?
When i try to copy a table from a sde database to another sde database i get the following warning."Could not find the features in the table 'tablename'. One possible reason is that a WHERE clause was specified that references a column/field that does not exist in the table. The error number from ArcObjects is: '-2147216086'. The error message from ArcObjects is: {Attribute column not found [tablename][STATE_ID = 797]" Also i get info "2021-01-11 17:05:12| 0.6| 0.0|INFORM|MULTI_READER(MULTI_READER): Will fail with first member reader failure" Can someone tell what am i doing wrong here ?
Hi all,There is a issue connecting to Postgresql 12.Error executing SQL command ('SELECT c.relhasoids AS oids FROM pg_class c INNER JOIN pg_namespace n ON n.oid = c.relnamespace WHERE ...... 'ERROR: column c.relhasoids does not existAccording to PostgreSQL 12 documentation, the "relhasoids" column has been removed from release 12.The error appears on both readers(PostgreSQL\PostGIS) and on different versions of FME Desktop: 18.1; 19.1; 20_beta.At the same time, the SQLCreator transformer reads the database without any problems.Has anyone else tested how FME works with new PostgreSQL 12?
I have clipped point clouds of buildings and I would like to calculate the maximum height from these point clouds, but without chimneys and other small features. Is it possible to retrieve more detailed point cloud statistics which can be used for this? I am not looking for the median of average values of the point clouds, but really the maximum z-values of the roof constructions.
My workspace compares data from an Oracle database and a versioned SQL Server backed Esri Geodatabase. The Oracle database contains mostly CAD and MapInfo data. It's the source of truth for the data. The SQL Server database is the destination where changes to the source should get written. I am using a change detector to determine if there are any differences between the features. The process generally works ok. The change detector populates the fme_db_operation attribute appropriately, and I'm using that to set the Feature Operation. My problem is that the process doesn't seem to update the features. The log indicates that it wrote the features and that the translation was successful. However, when I try to view the data in ArcGIS Pro, I'm not seeing the changes. If the process was successful, if I ran it again, I should see zero features that need to be updated. However, I get the same number of features that need to be updated over and over again. What could be ca
Hi.Am I correct in assuming, that the DGNV8 writer cannot output neither tags nor XAttributes ?I found this tutorial on writing tags, but it doesn't seem to work: https://community.safe.com/s/article/writing-microstation-dgn-tags-with-fmeI then found this page, that says that both tags and XAttributes can be read, but not written: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/igds/DGNV8_reader.htmCan or cannot ?
HiMy setup:Mac OS Big SurFME(R) 2020.2.1.0 (20201130 - Build 20806 - macosx)Oracle Client installed (Version 19.8.0.0.0) Connection is set up correctly (for example giving wrong username I get error: Error connecting to Oracle database: message was `ORA-01017: invalid username/password) And when giving correct credentials I get error:ORACLE_AUTONOMOUS_NONSPATIAL reader: 'DEC-MCS' is not recognized as a valid encoding name. Any ideas what to try?
Good morning, i have to use the FME software for my master thesis work. I'm trying to convert an IFC file to CityGML to put it next in QGis. I'm using just the readers i need to use for my purpose (Ifcdoor, Ifcwindow, ecc..) but during the translation the Unexpected Input says i have three types of features which cannot be converted, and that stops the whole conversion. Do you have any idea on how and where to connect those features? Because i don't really need those features, but it seems like there is no way of let the software to not consider them.
I'm wondering what the difference is between the DatabaseUpdater transformer and setting the Feature Operation to Update in a database writer.I know there is a lot of overlap is some of the transformers in FME so i'm wondering if one is better or if they'll do the same thing.
Hello! I am having some issues when working with Dropbox both as data input and output. In the case of data input, there is one error that happens sometimes: a retrieval error. At least two different description of this error appears in the log>1. Retrieval error: Unable to create resource with duplicate name on web service2. Retrieval error: "web-service" reporting server-side error. This service may experience issues. (upstream connect error or disconect/reset before headers. reseat reason: local resetI am enclosing printscreens for both cases. Do you have any idea what's the cause(s) and how to overcome this?Thank you very much, Jorge
I have a workspace (attached to question) that writes leaders to a dwg template. As far as I can tell the template has no errors, but the resulting dwg has 2 errors and must be recovered to be opened. Has any one else encountered a problem like this? I have attached the workspace with the behavior described.
I am trying to convert the ESRI format data(feature class) to cad using FME(I have used Extended Entity Data option). When I open the cad output in FME inspector I can see the attributes but when I try to open in AutoCAD or Revit I cannot see attributes attached to the features. Just wanted to know how can I get to see attributes in cad file in AutoCAD
I am reading an Excel file online where the sheet name and attribute names sometimes change. I therefore need to read the sheet and attribute names dynamically. I can get the schema but I haven't figured out how to read in the data using a dynamic schema. ("Scan Schema in Dynamic Workflow" doesn't appear to work for the Excel Reader.) I figured out how to use a FeatureReader to get the sheet name dynamically using fme_feature_type_name and then pass it to a second Feature Reader but I haven't figured out how to get the attribute names dynamically and then pass them along to the second FeatureReader so I can read in the data. Or is there another way?
Good evening.I need to copy all the content from a folder to another one. That means files and subfolders.I have been able to copy any file or subfolder with files, but if the subfolder is empty, it is not copied. I've been playing around with the filecopy_dest_dataset attribute, but no luck. I bet is something obvious, but I'm stuck. I'm using FME 2019.0.2 (64-bits)Thanks for any help provided!
Greetings, I have a microstation DGN file that I'm trying to convert to a dwg or dxf and my output is missing all information from the reference files (see attached images). I tried fiddling with the reader to include reference files but it has not made a difference in my output yet. I even tried to include a DWGStyler that references a dwg template but still no change in the output. Thoughts?
I have a base word document I want to use and set so I use styles from this base file in the MSWordStyler. But I get error msg when I try to use for instance the style "Tyréns - Brödtext". Tips? Tricks? Partytricks? The styles as viewed in Word.Kind regards, Peter
Hello everyone, now I´m working on writing the data to IFC format via FME workbench. It´s quite tough to handle it.... Is there anybody who have small sample of writing IFC via workbench? Thank You so much!Lubo
Hello.I am trying to use the Google Drive Connector to download files from a Shared Drive. But when I click on the Google Drive Source in the transformer all I see is the folders and files which are in My Drive. It doesn't show shared drives which I have created as well as drives someone has shared with me.I'm just wondering if this is a bug and if anyone else has the same issue?Many thanks.
Has anyone managed to construct a workspace with the following requirements:Only to be used in Datastreaming serviceGeneric writer with different file based outputs (demo pdf+png)FME Server streams the correct mime type with the response fileMy current experiment was to use a private python parameter which generates the correct mime type string depending on the format. But even with this, the data streaming sends a PDF but the response headers contain "Content-Type ?image/png".Is this possible at all?
I recently installed FME Server to docker using the installation guide. Since yesterday I have been trying to test it using a simple .fmw in order to write some data to a MongoDB instance. I tried in both local MongoDB and in a MongoDB-docker instance. In both cases I am getting the same error: MongoDB writer: Cannot connect: couldn't connect to server <<PORT NUMBER>>, connection attempt failed.Please note that, I have access to both MongoDB instances from local FME Workbench and I can execute the same .fmw. Find attached the file. This seems to be an FME docker network issue, but I cannot be sure what. Any ideas?
I have been trying to report an issue related to a backup file which is bigger as the 5MB. Following https://community.safe.com/s/article/upload-a-file-to-the-safe-software-support-ftp I have tried to upload the respective file through the given `curl` command. But whatever I try, I keep getting "Failed FTP upload: 553". I tried both zipped and unzipped, where the zipped file is around 6GB. Is there anything I can do to overcome this and continue with problem report?
HiI've been given a JSON file containing registrations for 5 properties. We are looking to use other datasets with a single field in the json file to identify the location of the property. I am looking to produce a csv file initially with each record on a separate line Can someone comfirm if the following is correct or not please. Open the JSON file using the JSONFeature Reader Connected a JSONFragmenter, using one of the fields as the JSON Query. I've attached a screenshot of the settings for the JSONFragmenter. When i run the workspace and view the result in the Inspector,i can see the records listed in the right hand pane, but writing out a csv file with each record on a separate line doesn't work. thanks for any assistance
Hi, I am trying to build a mosaic from 400GB of TIFF files - but is continuous failDiskspace Available 4TB - FME Temp file 1TBHas anyone come across this error - can it that the TIFF is corrupted? 445 2020-12-12 14:18:51 | JPEG2000 writer: Completed 21.76% of intermediate processing446 2020-12-12 14:19:13 | TIFF reader: LZWDecode:Wrong length of decoded string: data probably corrupted at scanline 27520447 2020-12-12 14:19:13 | TIFF reader: TIFFReadEncodedTile() failed.448 2020-12-12 14:19:13 | TIFF reader: \\\\mcc\\gis\\SourceImagery\\Taylors\\2020-10-30_Deliverable\\OrthoImage\\B4.tif, band 1: IReadBlock failed at X offset 215, Y offset 228: TIFFReadEncodedTile() failed.449 2020-12-12 14:19:13 | TIFF reader: Failed to retrieve data from the source dataset450 2020-12-12 14:19:13 | JPEG2000 writer: Could not perform Read/Write on file451 2020-12-12 14:19:13 | JPEG2000 writer: Failed to write dataset '\\\\mcc\\groups\\proptest\\Aerial\\Taylors_October2020_2cm_GDA2020z55.jp2'. Thi