Using readers and writers to extract and load data.
Recently active
Hi All,I want to draw a polyline that is defined in a layer of my template file. but dwgstyler has only got lines as options.How do I draw a polyline using 'DWGstyler' or any other transformer?Thanks in advance.
I need to be able to set the row for the field names to Row 3 for a folder of excel files. The only way to do this I have found is to read each excel and set the row to 3 in the Parameters dialog. This is very time consuming and I am guessing there is a way to set Row 3 for all Excel files read in from a folder. Any ideas welcome.
Dear All , We try to convert anything to Shape file, We have problem with file geodatabase , we upload the file as zip but it did not work , even if we give it as separate files is not working , how can we upload file geodatabase to generic reader format
I have a format, which is unknown in FME. It stores hexadecimals, (I can open it with hexinator). I want to know how I can read it with FME, so that I can start trying to convert it into something nicer! (I have the data structure, so I know what the hexadecimals tell me, but I don't know how I can read it with FME). can someone give me a hint?with kind regards,Ine De Cubber
I am experiencing a problem displaying mulipatch features read from Esri geodatabase. The features lose the ability to be rendered with shading. The problem is best demonsrated using the following workspace. On the top, a shape file multipatch feature is read, the (default) appearance removed (for consistency with the geodatabase operation), the appearance is then set to green and then displayed on the left. On the bottom row, a geodatabase multipatch is read, appearance removed, appearance set to green and then displayed on the right. The box on the right is not shaded. An identical problem re-occurs if saved to a geodatabase and viewed in ArcScene.How do I get the box on the right to look like the box on the left?
Hello,I am trying to download a small extent of OSM data using the OSMDownloader but the output osm file is empty (except for the header). The transformer generates the following call (which also specifies my bbox extent): http://overpass.osm.rambler.ru/cgi/xapi_meta?*[bbox=50.83,4.49,50.85,4.51]The download action seems to be successful however because the outcome of the transformer comes out of the Success port.Thanks for your help!Best regards,Olivier
Hi, I'm trying to write to a linked table in an MS Access database. I'm using FME Desktop 2015, the access database was created with Access 2016, and the table is linked to a SharePoint list. My Access writer in FME is using version 2007 and set to INSERT. When the access table is local (same attribute schema), it works fine, but when the table is linked to the SharePoint list, I get the following Invalid pointer error. Any ideas how I can try troubleshot?Microsoft Access Writer: Data type `autonumber' of attribute `ID' of feature type `Daily Changes' is not supported for writing. Attribute will be ignored by writerMicrosoft Access Writer: Failed to write attribute `Title' of feature type `Daily Changes'. Provider Error `(-2147467261) Invalid pointer'A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details
I am trying to use the FeatureReader to undertake a spacial intersect query against a MongoDB. The feature hits the FeatureReader and the log states that it has connected to the MongoDB, it even states the projection it is in. It then just does nothing. The MongoDB does not register any connections with FME. If I use a MongoDB reader it reads the database find. It is just when I use the FeatureReader. Does anyone have a similar issue with this? I am using build 17259 as the RC Desktop version.
Is there a way to call a pipelined function with parameters and then read the results as a table in FME desktop? I am only interested in non-spatial attributes being used.Thanks in advance...
The post titlePOSTGIS Writer: Fanout for feature type [postgis_table_name] failed to find feature type template ''is the error I'm getting in the FME log when I try to run a workbench which has already worked flawlessly a lot of times.It looks to me a database-related issue (template?) but I can't understand it and can't find any solution. I have no fanout and database configuration has to my knowledge not changed. I did not even change writers configuration.My FME version:2015.1.1.0 (20150715 - Build 15515 - WIN32)Any ideas on how to handle that?
Hi,I would like to add 100m to all the elevation values in a DWG file. However, how do I do this if the file contains polylines? I want to add 100m to all the vertices along the polyline.I am using FME2016 Desktop.Thanks,
Hi all!I want to read an xls-list without the first row to be the attribute-namer. As a result I will have attributes A, B, C, D, etc. I couldn't see a setting for that. Is it even controllable?Cheers, -Maria(I am using FME 2016)
Hi Guys,I have excel table with Road Names. There is a column that contains Names of all the streets and there are instances where they are repeating number of times. I tried using Testfilter to parse out the Roads that I am interested in but it didnt work for me. I am wondering what is the best way to go about doing this in FME.Any feedback would be greatly appreciated.
We are using 2016.1 (Build 16492) and I noticed that we no longer have the option to rollback on failure with the AGOL writer. Is this enabled by default or is it something that got removed purposely?
Fellow FME programmers. I have a large LAS and a DGN file that goes with it, is there a way to generate a clipped LAS file on the basis of a subset of features in the DGN ? I know I can overlay and view it, but I need to clip and produce a subset LAS file.
A question for the developers, I suppose:https://knowledge.safe.com/questions/41002/arcgis-online-rollback-on-failure-parameter.html
Right now it looks like I can write into "Esri ArcGIS Portal Feature Service" but I want to use this functionality on a hosted feature layer without involving portal in the mix, can we get a direct connector to write into a feature service?
It seems that the default behaviour for FME writers is to NOT write any records if an error is encountered, is that case? I want my writer to write the records that are good UNTIL the error occurs. This is for the Oracle Spatial writer, the SQL Server Spatial writer, and the Esri Geodatabase (ArcSDE Geodb) writer. Is it possible?Thanks
Hi,I am facing a problem while writing into a csv.file:FME converts the string '2-4' into 02.Apr., no matter what field type is set.E.g. '17-19' remains as it is since it cannot be changed to a date Format.Is there any smart Workaround or do I have to avoid/replace these strings?
Is there any way to have the Excel Reader read the contents of a shared workbook?
Hello everyone, I've got a few AutoCAD blocks saved as Blocks.dwg (e.g. with the different blocks named "Block1" and "Block2"). Furthermore I've got some points out of a shape file. Now I want to export the shape file as a dwg file and set "Block1" on some points with an attributive filter and "Block 2" on some other points. My first idea was to read in the shape file, create a DWG writer, use the Blocks.dwg as Template File and fill the attribute autocad_block_name of the points with "Block1" or "Block2". That does not really work. Have you got ideas or hints to realize that. Best regards, Felix