- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,809 Posts
25,083 Replies

When you subscribe we will email you when there is a new topic in this category

6809 Posts

FileCopy writer creating 2 destination folders

I'm copying PDF files from a source folder to a destination folder. The destination folder is named with today's date (.../outgoing/October-11-2021/).I used the AttributeCreator to create and format the date attribute called "Date_today" and set filecopy_dest_dataset to "Date_today".This all works well, the PDF's are copied into the date folder, however, I also get another empty date folder created in the folder that the workbench is in.Fanout is off. Any ideas how I can stop this extra folder being created?

470

3 years ago

samarpandeyContributor

asked in Data

Unable to transfer data into ArcGIS enterprise unversioned geodatabase on SDE.DEFAULT version when someone is connected through either ArcGIS Pro or feature services

Need to understand how to avoid error "Table is already locked" while doing transforming data into ArcGIS enterprise nonversioned geodatabase on SDE.DEFAULT version when someone is connected through either ArcGIS Pro or feature services. When close the ArcGIS Pro session, FME transformation works fine. When schedule the FME transformation using FME Server, users must not to be disconnected before transferring the scheduled workbench. Please advise.

3 years ago

elenahiguera

asked in Data

ORACLE_SPATIAL : Error - Cannot have NULL value for 'z coordinate'

Hi,I want to read with FME the data from a database oracle.I can connect FME to the database but I am not able to read the linear objects. I use the ORACLE_SPATIAL reader. I have the following message : “Error - Cannot have NULL value for 'z coordinate'” Do I have to parametrize FME to be able to read the null value of Z ?Find attached the text.log oracle_spatial.zipThanks,

I have converted a large geoJson into cesium 3d tiles -- wonderful... but not when enabling terrain -- tiles are partially visible obviously due to elevation. Is there something available in FME to consider the terrain?

410

3 years ago

bboContributor

asked in Data

Is it possible to read 3D PDF? Or another Synchro PRO 4D (export) format?

I have received an 3D PDF and would like to extract attribute information. It is an export from Synchro PRO 4D. If there is an other possibility to exchange information from Synchro PRO 4D that would also be an option.

270

3 years ago

richemcdContributor

asked in Data

Hi all, Im trying to write 40 Shapefiles from 40 PostGIS Tables, but while my workbench completes successfully the last 6 (Always the Last 6) shapefiles to be written out have a file size of zero. has anyone experienced this or has solutions?

I have successfully written the data to an OGC GeoPackage (over 7.6GB) I dont believe any of the shapefiles would have exceeded 2GB Largest shapefiles wrote perfectly 174,649KBJust to add, I have in testing it cached the workbench and all translators have data passing through, with even the Log, logging the number of features written, only the outputs are blank

3 years ago

clowncutie

asked in Data

Figure out if my DWGs in a folder Civil 3D or AutoCAD files? FeatureReader, Civil3D, AutoCAD version.

I have path_windows for all dwgs in a folder. I could get AutoCAD file OR Civil3D files, I won't know that. How would I get results which I canIs it Civil3D or AutocadGet version for Civil3D. With the top autocad feature reader I figured out how to get the autocad version already, even when I have 2 files with a civil 3d features(these are now included in my tests but should be excluded from my result). I want to only get one result per file, autocad or civil AND the version per type. I tried many things but I cannot find a way to get "there are ciivl these are autocad" not all Civil has pipes network for example so the sum of civil types isnt a guarnateed solution.Current results: Top Feature Reader is AutoCADthe Bottom is Civil3D results I want my current AutoCAD version results(the 2 marked read have pipe network so they should be marked as missing)

AutoCAD Writer Creating Empty Layers d_y_00, d_y_01

I am using the ACAD writer to convert GeoJSON to a CAD file. The issue I'm having is the ACAD Writer seems to be creating a bunch of empty layers named d_y_00, d_y_01, d_y_02 etc. that aren't in the GeoJSON I'm passing. The layers that are in the GeoJSON are written to the CAD file and work perfectly. The issues is I can't seem to figure out where these layers are coming from or how to remove them.

110

3 years ago

helmoetzContributor

asked in Data

Snowflake geometry types honoured by FME?

Hi, is it possible that FME does not honour geography types for SnowFlake? SnowFlake should be able to store geometry as WKT / WKB / EWKT / EWKB or GeoJSON. Currently (FME(R) 2020.2.3.0 (20210129 - Build 20820 - WIN64) only GeoJSON seems to be supported. When I try to specify a different format, FME keeps on writing GeoJSON format geometry.I tried specify it in the JDBC connection parameter GEOGRAPHY_OUTPUT_FORMATI tried specify it in a pre-write SQL statement ALTER SESSION SET GEOGRAPHY_OUTPUT_FORMAT='WKT'Any ideas? Or file a support case? Love, Helmoet.

530

3 years ago

mhabContributor

asked in Data

DXF: How to style 3D lines ?

In writing DXF when lines are output I use autocad_width and autocad_linetype in combination with a DXF Template file in order to get the desired output styling for 2D lines. For 3D lines this doesn't work and 3D lines are output in some default manner. As I am not an expert with DXF/DWG and only create such files with FME could somebody help me out with the following questions:Is it possible to style 3D lines in any way ? Thickness, dashed, etc.If NOT: what do people usually do if 2D and 3D lines are coexistent and should be combined in the same output file, while the 2D visual appearance matters and should be used also for 3D lines? At the moment the only way to cope with 3D styling deficiencies seems to be double 3D line layers, in order to have a 2D and seperate 3D copy force one layer to 2D and style it as usualoutput the redundant 3D layer as is in order to keep the 3D information Thanks for any helpMichael

100

3 years ago

kschultzParticipant

asked in Data

MSSQL geometry column is being written as a Geometry Column

FME is writing a the geometry column as:GEOMETRYCOLLECTION (GEOMETRYCOLLECTION EMPTY, POINT (Y X)) When it should be outputting as POINT (Y X) Is there a way to correct this?

3 years ago

fmeuser_gcContributor

asked in Data

Error creating PostGIS reader in FME

I get this error while creating PostGIS reader in both 2015 and 2017.1 FME versions.Please advise for the below error.ERROR |Error executing SQL command ('select version(), postgis_version()'): 'ERROR: function postgis_version() does not existLINE 1: select version(), postgis_version() ^HINT: No function matches the given name and argument types. You might need t...'2018-06-04 20:46:28| 2.4| 0.0|WARN |Error retrieving version for PostgreSQL database2018-06-04 20:46:28| 2.4| 0.0|INFORM|Successfully closed POSTGIS database reader2018-06-04 20:46:28| 2.4| 0.0|ERROR |Reader failed in open() callTagging in @takashi, @erik_jan, @TiaAtSafe, @Mark2AtSafe, @RylanAtSafe, @jlutherthomas

2097

3 years ago

gpt_geoinfoContributor

asked in Data

How to read/write SQLite embedded in an Autodesk DWT?

To all Autodesk'ler,I have a DWT-file, which is noch an ordinary Autodesk template file, but an application module. I can open and read it with the Autodesk's 'Infractruscture Admin'. Editing it possible with 'Map3D', where you can see the representation definitions. Usually you are hosting your data in an oracle database and holding the representation in LAYER-files. With a DWT you now have everything in one file.I already tried to open this file with the inspector - no success.Does anyone has experience with this? Cheers,Maria

650

3 years ago

asmallContributor

asked in Data

How do I stop FME adjusting the compression tolerance to '1' when using POD writer?

When using the POD writer I get a warning message "POD writer: Compression tolerance '0.001' is too small for the point cloud coordinates and may produce poor results. Adjusting compression tolerance to '1'

How can I import the correct the locations for CAD annotations?

I am reading in a complex CAD file from our engineering team. The DGN has multiple reference files, but the only information I need is the annotation layer. Specifically, the callout boxes and the leading arrows. When I read in the DGN as a Microstation v8 file in FME Data Inspector, the callout boxes are shifted in the wrong spot and the arrows are missing. Any ideas of what could be wrong and how to fix it?

i have a project in FME that take data from xlsx and import into postgresql table. After i run this project allseems to be ok - Translation was successful but in database is not any line inserted. Sometimes working well and sometimes is not working

I'm probably wrong somewhere

120

3 years ago

jackydContributor

asked in Data

Save a csv to SharePoint

I have a task where I need to extract data from a database and save it as a csv in SharePoint I had hoped to b able to specified the path to the SharePoint folder in the csv writer, but this does not seem to work. The error I get is CSV writer: Failed to open file 'HTTP:\\\\projectzone.tnad.tasnetworks.com.au\\business-projects\\iap\\TE\\HVDC Cable Specifications\\SATVUE_99021037_2021_08.csv' for writing. Please ensure that you have sufficient privileges to write this file. If the file already exists, please ensure it is not open in another application I am using FME Server and the FME Server service account has permission to write to this location.

How to charge cityGML devices to Cesium ion?

HiI generated a CityGML model in LOD 4 with its respective appearance using AppearanceSetter. I am trying to load the model to Cesium Ion but it loads without appearance. Can anyone help me with some idea to solve this issue.

3 years ago

silvo

asked in Data

Export multiple "Line Dash Arrays" with PDFStyler

I have a dwg-file with multiple linetypes (dashed, dash-dot, solid).The Option in PDFStyler allows me to define only one "array" or use a parameter.Is it possible to write multiple "Line Dash Arrays", or ca i put only one in a pdf?Who can help me?

170

3 years ago

pratapContributor

asked in Data

Reading internal features from Smallworld

Is there any way to read the smallworld internal features in EDO in GESW 4. X.

150

3 years ago

wisegisContributor

asked in Data

I have image files that I need to run through and extract the pixel values at my point layer's locations. It is not working out as planned...

It seems straightforward enough using the PointOnRasterValueExtractor. The problem is it is only grabbing one value and putting that in all the points. I am guessing that the secondary files with the tiff may hold that 'value,' but I am unsure. The last screenshot shows the data doing it the slow way through ESRI's geoprocessing tools. Any help would be appreciated.

400

3 years ago

lennartmContributor

asked in Data

Revit reader does not read all feature types

Dear FME community, Within a workspace that uses a specific view for reading a revit file, we have found that not all feature types that are present within the specified view are read by FME server. On desktop (using the same version and same workspace) it does automatically read all feature types. At first we tried leaving the 'feature types to read' option empty, which made this difference visible within the log and output files. Secondly we tried adding all possible feature types to read to the reader, however this also did not fix the issue. Does anyone else have a similar problem and a possible solution? Maybe the cache is used differently on desktop vs server? Added some log images of the feature types read by desktop (6 feature types read) and server (stops at 3th feature type read). server: desktop: Edit: After adding a featureholder after the readers, all feature types are read by both desktop and server.

How to use the XML filter in the WFS reader?

I'm having a hard time using the WFS XML filter. I surely built a working workbench before so I am sure this worked. The only thing I want is adding a boundingbox in the WFS (2.0.0) request. I open the XML Filter setting and entered: bbox=48187,407743,148934,408593 The workbench fails. Log: <ows:ExceptionReport version="2.0.0" xsi:schemaLocation="http://www.opengis.net/ows/1.1 http://geodata.nationaalgeoregister.nl/schemas/ows/1.1.0/owsAll.xsd"><ows:Exception exceptionCode="XML getFeature request SAX parsing error" locator="org.vfny.geoserver.util.requests.readers.XmlRequestReader"><ows:ExceptionText>org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog. Content is not allowed in prolog.</ows:ExceptionText></ows:Exception></ows:ExceptionReport> I look up the URL in the log and there it is: FME prefixed my filter with "FILTER=" FILTER=bbox=48187,407743,148934,408593 When I copy paste the url from the log to

78711

3 years ago

scottshenbergerContributor

asked in Data

I am new to FME and this is my first post. I am trying to create a workbench that will search through hundreds of windows folders and convert pdf to tiff images. I have tried the ImageRasterizer with no luck. Is this even possible? Thank You

210

3 years ago

naveenContributor

asked in Data

Write to SDE Version Issue

Dear All, I am trying to write some features in a versioned featureclass. Instead of writing it directly to the SDE.Default,I have created version in ArcGIS and I have set the FME output to write to that version and I have made sure you have Versioning set as your Transaction Type under Advanced settings.I have Run the FME workspace and it has come up with below error message. I am not sure why this has come up. Please let me know if you are aware of this. Error message: An error occurred while attempting to store a row into the table 'ARCFM.Lamp_LV'. The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {} The Zone of the assembly that failed was: MyComputer log4net:ERROR XmlHierarchyConfigurator: Appender named [MinerEventLogAppender] not found. log4net:ERROR XmlHierarchyConfigurator: Could not create Appender [Log4NetEventLogAppender] of type [log4net.Appender.EventLogAppender]. Reported error follows. System.Security.Securit

270

3 years ago

Page 48 / 273

Badge winners

adnanyazdanihas earned the badge Student (Grey)
adnanyazdanihas earned the badge Teacher (Bronze)
adnanyazdanihas earned the badge Teacher (Grey)
ivanbakkerhas earned the badge Integrate Spatial Data
johanmarkshas earned the badge Integrate Spatial Data

Show all badges

30,354: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.