Using readers and writers to extract and load data.
Recently active
Hi,I have a Problem placing shared cells in a V8 DGN.The Cell i'm trying to place has different x- and y-scale and is rotated.I used the DGNStyler to define the settings.The result in MicroStation is shown below:On the left you see the Library Cell and that's how the Cell should look like. It was written with the same Settings in DGNStyler except Cell Mode.On the right you see the Shared Cell which Scale and Rotation is wrongSo the Library Cell is placed correct, but i have to place Shared CellsCan anybody help me ?
I have A csv file with more 10000000 records how can split into 5 smaller csv file (each with + o- 2000000 refcords) to performafter my actions ?
am learning FME Workbench/ Data Inspector etc. But exactly I have a question, which I could use some help. My question is: I am working with a GML file. It has uploaded in FME Data Inspector. From this file, which includes BRepSolid 3D objects, I would like to get the exact heights (as an feature). Than I want to save this data as a shapefile/geojson or something which I can than use in Qgis. Untill now I have not had any succes. Can you give me some tips or links to tutorial(s) to learn this? Topics: heights / .gml file / into writer (for example shapefile)
Anyone have some tips working with FME moving detailed buildingdata to and from 3D Studio Max?https://www.autodesk.com/products/3ds-max/overview
When I enter $(user_parameter) as user attribute name, it will be replaced to $_user_parameter_
Is there a reader for PDF documents? I would like to be able to use FME to batch convert a number of PDF documents into another image format, like JPEG, so that I can georeference the content.
Hello! Writing to an Oracle Spatial Database I get following error: Oracle Writer: Abnormal channel cleanup required, likely due to previous error What could be the problem? Thanks for your help, regards Isabell
Hi GuysI am looking for a workflow to Create SHP file attributes from an excel spreadsheet. The problem I am having, is I can only see a way to extract column headings as Attributes. How do I take attribute titles from the cells below the column heading. I hope that makes sense....Basically, I have an Excel document with Standard Asset data that needs to be included in our SHP files according to discipline. So I have used FME to Test for "Subclass" & "Item_Name", which works great, then I want to extract that list in the "Attribute_name" column to SHP attributes.ThanksMartin
Hello, I'm using the Writer "Adobe Geospatil PDF" and I want to generate the Feature Type Name by using @Value(fme_basename). The result (filename) is "@Value(fme_basename).pdf". Any idea? Thank you very much!Bernhard
Trying to read an ArcGIS Server (10.3) map service. There doesn't appear to be a a dedicated reader for this, unlike the ArcGIS Server feature services. Have also tried the WMS reader, with no luck. I want to ultimately write the output to a file geodatabase. How have other people achieved this work flow?
I get this error for only this scheduler job. All other jobs fine. Insufficient memory available -- error code was 2 - please read the FME Help section 'Adjusting Memory Resources' for workarounds.Nothing much to clean up in /temp folder. How can I make this job run?
I'm running Workbench 2016 - 32 bit on Citrix XenApp v 6.5. and use quick translator to export Smallworld 5.1 data to .dgn format. How do I configure the port in my .fmw file to use the port assigned to my Smallworld session.
I have a number of 16bit RGB raster images which need to be converted to ECW format. The images are displayed perfectly in ArcGIS and have the following attributes.rows and columns: 1506, 2051 No Bands: 3 Format: TIFF Pixel depth: 16 Bit Compression LZWWhen I load the Tiff in FME 2017 and inspect it, it is rendered black with the following information:rows and columns: 959, 250 BAND 0 (Gray 16) BAND 1 (UINT 16) BAND 2 (UINT16)My translation to ecw fails due to "Unsupported band interpretation 'GRAY16'". How can I resolve this?
Hi,I am trying to update a field value of a ESRI filegeodb table (v10.2.1).I have a table called 'Test' with several columns.For example the table contains 100 records with some voltage value ranging from 1 - 100I want to update these record's 'classification' field depends on my filter condition.I would like to read this filegeoDB and filtering the records and trying to update the same database table's classification field (not the entire row) with matching column.If its an oracle DB i can do this either by using DBUpdater or SQLExecute.Any clue or hints will be much appreciated...Thanks,Mari...
I am using the DateTimeConverter in a workbench to convert date and time from an Oracle database to an ArcGIS Online feature service. The autodetect feature works in the workbench and the translation is successful. However, when I upload the workbench to the server, the DateTimeConverter is unable to autodetect the date/time value from the input and the translation fails. Has anyone faced and resolved this situation?
I have an attribute called text_lined_data that contains 6 data columns. How do i extract that information into 6 columns and line one as header?
I'm having a bit of an issue with text fields being truncated, and I can't figure out why...The fields are all text fields of varying length, with writer definitions copied from reader, and for some reason they all come to the writer truncated to 4 or 5 character's length?!This is how the read attribute info looks (reader is GDMMAPPERQUADRI):...and here's the writer (Writer is GEODATABASE_FILE):Note now the attribute LEDNINGSNETTVERKSTYPE is changed from length 13 to length 5. This behaviour seems consistent for most attributes, but not all (like OBJTYPE in the example).I tested a different writer, just to see (ESRI Shape) and it's the same there, also doesn't matter if I port directly from reader to writer or if I mess round with the data inbetween. Is it the reader that "sends the wrong signals", despite the correct attribute definitions being listed?
I have an FFS file (created from a v7 DGN). This file has an attribute named "multi_writer_id" that contains the FFS file name. I can see this attribute in the data inspector but am unable to expose it with the AttributeExposer. I want to fan out the writer according to this attribute but because it cannot find the attribute, the result is a file named "NULL".Any insight into what's happening?
I have an Excel Writer writing outputs of a workspace into a spreadsheet, I have also provided this writer with the location of an Excel Template which also happens to be an xlsx file as the extension of the writer and template need to be the same. In my template file I have a picklist in one of the columns which contain different values, this was enabled in the Data Validation menu of Excel. The picklist works as expected in the Template, after saving and running the workspace the output has all the correct values in the spreadsheet, however the column which should have picklists doesn't contain these and only has the column name. How can I enable this to carry through from the template to the actual writer?
Hello,My fmw used a shp file reader. If this file is empty, ican't get error. Have you any idea to intercept that the file is empty? Thanks an advance.
I have FME reading attachments from AGOL and writing them to a FGDB or SDE GDB. The problem that I'm having now is that FME isn't writing the blobs to the file geodatabase in a way that esri can handle them.The first screenshot is a directly downloaded database from AGOL. The second screenshot is from the database that I reloaded data with FME. The first screenshot allows you to view attachments, while the second screenshot doesn't allow me to view attachments.Thoughts @Mark2AtSafe?
Here's the output: Terminator(TestFactory): Terminator: Termination Message: 'PARCEL_LIMIT_EXCEEDED'Terminator: Termination Message: 'PARCEL_LIMIT_EXCEEDED'Bridge failed to output feature on tag `PYOUTPUT'f_218(PythonFactory): PythonFactory failed to process feature=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Feature output statistics for `FFS' writer using keyword `W_1':=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Features Written=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==============================================================================Total Features Written 0=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Successfully closed POSTGRES database reader... Last line repeated 5 times ...Closing the Geodatabase reader... Last line r
I'm trying to convert my GDB model, which is modeled in City Engine, to Cesium 3d tiles. Both reader and writer are implied with default settings. The transformation process goes smooth, I found that the output models are grouped in different data set. So every time I click on one model in Cesium, a group of models are triggered and all the model share the same attributes.What I am looking for is to keep the original amount of models after transformation, so they are independent and hold their own attributes. What settings are needed to make it work for me?
Hi,Can somebody who speaks French reach out to @ferjanibarour (email: ferjanibarour@gmail.com), he's been asking questions here and has also contacted me directly. @david_r maybe? Or somebody French-speaking from Safe.The problem is that his questions are very generic and I fear there's a big language barrier. I recommended him to contact Veremes but apparently he hasn't had a response yet.