Using readers and writers to extract and load data.
Recently active
Finding that the Format Attributes documented here are not the same as the ones that are showing up when I use the Microsoft PowerPoint writer within a FeatureWriter transformer (see screenshot below and look for the pptx_title_text parameter):
Hi,I asked the below question a few years ago regarding whether I could change the colour of a graphic cell, and the consensus was that I could only change its colour if I first converted it to a point cell.https://knowledge.safe.com/questions/23887/dgnstyler-cell-color.htmlDoes anyone know if there has been any advancements since then which would allow me to set the colour and level of a graphic cell in FME?Thanks,
HiI am writing out to a Microstation V8 DGN file with the igds_type set to "igds_curve". However, for some reason, the first two and last two vertices of every curve are not joined together in the ouputted DGN. Does anyone know why this would be? They were definitely joined together when I used a normal line_string...I am using FME 2017.1 32 bit.
Is there any way to list all paperspaces found in an AutoCAD DWG or set the FME reader to simply read all paperspaces?Alternatively, is there a way to extract all defined viewport polygons without knowing the paperspace names at runtime?What I am trying to achieve is to batch process a set of DWG's that do not have a standard schema and search the contents of viewports (preferably in the paperspace) for certain blocks. Blocks of the same type not printed on any paperspace must be excluded as they are not relevant to the analysis.A great workaround using an AutoCAD LISP script has been discussed (link) but I am looking for an option that might achieve a similar result without the additional AutoCAD licence.
i am using a LAS dataset, which is too large to share and when using a combine line I get a boundary. I keep getting a combine line around the boundary of the area I am processing. This will have multiple contours that have different elevations, each one connects to another contour along the boundary a ways away. Thank you for your suggestions.
Hello,I have a DWG and an SQL server as readers and the writer should be a feature service on our portal.Problem is at the very end and i get the following error log:Reprojector: Invalid reprojection parametersCoordinate system conversion during translation is not possible -- cannot output feature with coordinate system '_EPSG:31700_0' to output dataset with established coordinate system '_SPHERICAL_MERCATOR_0'=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Feature output statistics for `ARCGISPORTALFEATURES' writer using keyword `ARCGISPORTALFEATURES_1':=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Features Written=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==============================================================================Total Features Written 0=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Reproject: Could not reproject t
I Have ".IFC" format 3D file. I am trying to convert into .gdb file(with 3D Multipathes) by using "Esri Geodatabase (File Geodb API)" option. After converting into .gdb it is converted only Table format. Not 3D format.Again i try to select another .gdb "Esri Geodatabase(File Geodb ArcObjects) option. But it not activated. And it was showing an error. Find the screenshot attached.My question is how to convert IFC extension file to .gdb file. This file i need to use in ARCGIS PRO.Is there any option to use IFC in arcgis pro. Thanks in AdvanceVK
Hello, I am wondering if I am missing something. I am exporting some records from an Oracle dB to a GML2 file. When I validate the resulting XML using online validators I don't find any errors. However when I do the same in the FME validator I find an error. I am a bit surprised by this because the XSD and FME was creating from FME. I am missing something? This are the files (i renamed the .txt to be able to upload them) Thank you Feature Type Inspector_2Coordinate System UnknownDimension 2DNumber of Vertices 0Min Extents nan, nanMax Extents nan, nanAttributes (19) _creation_instance (32 bit unsigned integer) 0 _xml_error{0}.col (string) 41 _xml_error{0}.desc (string) no declaration found for element 'gml:Box' _xml_error{0}.file (string) C:\Users\Me\Desktop\GML\test150319.gml _xml_error{0}.line (string) 4 _xml_error{0}.type (string) Error _xml_error{1}.col (string) 41 _xml_error{1}.desc (string) attribute 'srsName
What are the options in sending data to a Microsoft Teams Channel? Thanks!
Hi,Is there a more efficient way of loading a large CityGML dataset, approx. 15GB unzipped (http://www.3dcitydb.net/3dcitydb/fileadmin/mydata/Cesium_NYC_Demo/CityGML/NYC_Buildings_CityGML_20150907.zip) apart from using the standard reader.I was thinking of using this approach (experimental?) but tests using a smaller dataset did not yield any advantage compared to the standard reader.Thanks
I am trying to create schema and upload data to PostGIS facing Error "2018-11-29 09:18:58| 13.8| 0.1|ERROR |Bulk copy failed on table 'FIN.match_tt' using delimiter ':'. Error was 'ERROR: extra data after last expected columnCONTEXT: COPY match_tt, line 1: "00004649-3100-0400-0000-0000000ab870:30:5.39508913314117:85.76780709963086:80.37271796648969:5.05078..."'2018-11-29 09:18:58| 13.8| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details2018-11-29 09:18:58| 13.8| 0.0|ERROR |Bulk copy failed on table 'FIN.match_tt' using delimiter ':'. Error was 'no COPY in progress'2018-11-29 09:18:58| 13.8| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details" can any one help Please find log file for reference.
Hi,I have an ExcelStyler set with a specific cell background colour. However I want to override this setting for a specific column in my output spreadsheet so I have set a different background colour in the 'Formatting' section of the ExcelWriter. But column in the output spreadsheet is the colour I set in the ExcelStyler rather than the ExcelWriter.I am using FME 2018.1Thanks
Some of my workspaces contain multiple checks before any data is processed and are hooked up to some Terminator transformers. Is there a way to show the custom error message, that is included in the Terminator, in the web gui instead of the default translation failed message? Although the terminator message is in the log file, I would prefer the message be shown to the end user instead of having to access the log file. FME Server 2018.1
I'm looking at 2019 beta. Is there a way that an S3 block can be seamless when writing to a ESRI file geodatabase, or are multiple steps involved that require creating the FGDB and then zipping it up for transfer. I'm not seeing a way using the S3 connector. Obviously I would rather the most seamless and simplest method...more like a virtual file/folder location parameter using the saved web connection and credentials.
Greetings for the day, Can anyone please help me to know that IFC entities are case sensitive or not. For example, if I use “ifcproduct” or “IfcProduct” instead of “IFCPRODUCT” in .ifc file it is right or not. Thank you.
I need to re or write GIS data to an EPANET (hydaulic) file forma. On that moment I use a dedicated externat script but would appreciate to do it in an FME environment
Hi there, I have a hosted feature service which has to get updated with the records from a web app. On the basis of that, I would like to create a workbench where I can use the fields from hosted feature service and using a custom word template I can generate a report. Any help regarding this is much appreciated. Thanks,Anu
I know relatively little about Revit so this may be a noob question. I've got a Revit drawing with features that have an image draped across it, basically signs and what they look like. I can translate the Revit data to geodatabase without issue, but those images don't come across to the multipatch features in ArcGIS. There is no way in Esri to do this programatically (they have a SketchUp workaround) and I was wondering if there was a way to maintain those during the translation?
I have a collection of .zip files (ie. AB_170203, BC_180203) that I would like to move from one drive to another for archiving purposes. I have a tester set up to separate the .zip based on date and now I just need the .zip's to move. Writer ParametersFile Operation:MOVE Copy Source Folder: NoCopy Subfolders: Yes The process will complete but nothing moves.
Dear FME'ersI have a SpatiaLite file, which I can read with the SpatialLite reader in Workbench. However, there is one non-geometrical table, which does not pop up in the Feature Classes.So, I thought, I read this table with the 'SQLite Non-Spatial' Format. I get following error:SQLite 3 Reader: Opening `Z:\\Connector\\GPS2Sirius\\TC_NM_DataFileGPS_V6.sqlite' for read operationSQLITE3 reader: Database query 'PRAGMA table_info("ElementaryGeometries");' failed. SQLite3 Engine error: 'no such module: VirtualElementary'However, in the Data Inspecter, I can open the data with the same reader. Does anyone have an explanation for this? The SpatiaLite database is filled in QGis, but I do not know how it was created initially.
Hello ! I am joining some data with information included in distinct CSV files. For this joining, I use the DatabaseJoiner. As it is quite big CSV files (> 7M entries), the index creation takes some times before actually making the join. However, as the input data are big also, I am processing the joins by tiles, but it means that for each tiles, the DatabaseJoiner is creating its own index again before joining and so on... Is it a parameter or something else to write somewhere this created index so that it only have to read it again to use on the other tiles ? Many thanks ! Nicolas
I have a dataset with a large number of areas (tiles) that border each other. Each area contains a large number of shape files. Each area folder holds the same types of data. All files have unique names.They have the following syntax: area_datatype.shp.I would like to merge all the files of a similar datatype into one. So instead of having X areas with Y shape files in each I would like to have Y shapefiles covering all areas X.The standard procedure is to build a dynamic work space and use fme_feature_type for the output, but I can't get it working this time. My guess is that I somehow need to pull the name of the data table, if that is possible? Or is there some nifty setting that I might have missed?Any advice on how I can get this to work?
Hello! I need to copy the contents of a sheet in a Gsheet format into an xls sheet of an existing file that have others sheets. the operation must overwrite the sheet only by emptying it and repopulating it, but I lose the column names even if I have selected the output field names option. what am I doing wrong?
Hello everybody,I have huge problem - working with SVG format, Im new one in work with this format. I have many questions please, how to figure it out in FME:1.) How could I create body of SVG like this:It means create tags <title>; <defs>; <pattern> etc.2.) How could I put 'elem_type' attribute into <g> quotes (like above)?3.) How could I put text content between <text> quotes without prefix CDATA, check below?My aim is to get line like this: <text stroke=rgb(0,0,0).................................>22.11.1999</text>Please, help me! :-)Thanks, Lubo
In FME Workbench, we can see the "help" of Transformers or Formats when clicking on it. But, it does not work for my part for the custom formats although there is a description inside the custom format : Format Parameters > Description > Help . Is there a specific procedure to follow or maybe it is not possible ?Thank you.