- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,825 Posts
25,142 Replies

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

6825 Posts

arthyContributor

Failure of the XLSX writer when exporting

Hi,I'm trying to export my data to excel. My workbench was working fine and suddenly I can't even run it.I'm having the following error and I don't know what could be the issue.I restart my computer and I close all the excel files on my computer but the issue persists.XLSX Writer: Saving changes to dataset 'folder_name'XLSX Writer: Failed to save changes to the spreadsheet 'folder_name'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Note that folder_name is the localisation path where I want to export the data.Thanks

POSTGIS Feature Writer in FME Workbench 2016 : Where do I set the TRANSACTION_INTERVAL?

7 years ago

asked in Data

JP2 reader

Has something changed within the JP2 reader between FME2014 SP4, and FME2017? I'm using a simple workbench to convert from JP2 to Geotiff, which worked fine in 2014. I'm getting a message in 2017 that I do not get in 2014, "JPEG2000 reader: Mercator projection should not define both StdParallel1 and ScaleatNatOrigin. Using StdParallel1 and ignoring ScaleatNatOrigin." The resulting geotiff does not seem to retain the coordinate system.

How to add active directory user to access fme server and run workspace

we have configured our Active Directory with FME server and some active directory user already added to access and run FME workspace.But when I try to add new user then its asking to set password. we no need to set password. User can use there AD default password.

I am converting Sketchup file to City Gml v2.0 , I want to give seperarate layer names for Building, Lift , door,park and lift ? Can anyone suggest me a the way to follow?

7 years ago

gioContributor

asked in Data

png text rotation

Hi all,I seem not able to rotate text objects written to a png file.They are rotated, rotationfield has correct value when arriving at the writer.Even using gif_text_rotation or fme_rotation...nothing seems to make the png have the text rotated .Anyone know this issue and maybe what I'm missing here? (please answer in relation to png writer if possible...;))

6720

7 years ago

hoa_leContributor

asked in Data

how to create .mdb from structure format in excel file?

Hi all,I need to create a .mdb access file from excel file which have informations about field name, width and type datal. Could you tell me how to make it from FME workbench?This is my excel data (input). I want to make 4 columns in .mdb with type, width data the same here.

Basics.... writing text file

Hello,In the Text_File writer I cannot select an attribute I've just created How can I solve that?Best,Harmen

How to duplicate a XLS writer but unlink them from automatic updating?

7 years ago

redgeographicsCelebrity

asked in Data

PNG text rotation

Regarding this thread: https://knowledge.safe.com/questions/43262/png-text-rotation.htmlCould somebody from Safe reach out to Gio? I don't know if he actually filed a support case regarding this, but it seems the only answer he's willing to accept is that it doesn't work.

7 years ago

rralbritton

asked in Data

Cannot write a non-area feature to an area feature class

I am using an AutoDesk Revit Reader to transfer an RVZ file to a Feature Class in an ESRI GEoDatabase (ArcObjects). When using the 2DForcer to transform the 3D RVZ data to 2D data the translation fails and there error I get is 'Cannot write a non-area feature to an area feature class.' I am using a Geometry Filter which has the solid and area options checked, followed by a GeometryValidator with all options checked. and the output feature class type is set to polygon.

3000

7 years ago

gis2020Participant

asked in Data

removing non breaking spaces from GDB file

. but not getting desired results

exporting sql server non-spatial table info as xml file?

To get an xml file automatically we are currently storing all attribute table of sql server DB into a enterprise GDB in sql server, which is creating a trouble that everytime it is taking the primary key field as OBJECTID and changing the name of the field. So we want now to have the attribute table as it is in a non-spatial database, and want to read it's table name, field names and datatype into an xml file. But I cannot read the field names and data type as a list thus I can use it inside our own schema. Can anyone please guide me.?

I have a Geotiff file where the colour (a real number) represents the elevation. I wish to generate contours form this data and can not see how to get the data into the contour generator in an appropriate way. What other transformers do I need and how do i use them?

Writing a combination fanout to ArcGIS Portal Feature Service

I'm trying to write a dataset and featuretype fanout to ArcGIS Portal. The desired behaviour is:Each feature service is determined by Attribute Column X (dataset fanout) A layer in each feature service is determined by Attribute Column Y (feature type fanout) I have performed a few fanouts before on different writers and they seem to work, but I can't get Portal Feature Services to successfully produce a fanout. My workflow is similar to the fanout template here: https://knowledge.safe.com/articles/565/fanout-1.html (see Combination fanouts)A feature type fanout is successful, but a dataset fanout using this workflow generates the following error: https:\\portal.bluedot.global\\arcgis\\AttributeValue1' does not appear to be a valid domain I have also tried specifying the feature service parameters:firstname.lastname/@Value(attribute_values) with the following error:The error code from the server was '400' and the message was: 'Item does not exist or is inacces

7 years ago

jneujens

asked in Data

Getting temporary folder of Data Download Service

Hi all,Workspace A is uploaded to FME Server as a Data Download and Job Submitter Service. Several files are written in the workspace (excel, sdf, json, txt) and -logically- they appear in the output .zip package of the data download service. Problem: A FileCopy writer is used to copy a .dwg file to the output folder. Because the files for the .zip package of the download service are stored an a temporary folder on FME Server, it is not yet possible to have to .dwg also in the download package. The Job Submitter does its job and all my files are written correctly (including the .dwg file). The data download .zip-package does not have this .dwg file and that is my problem. I just need the URL or the location of where the files for the download package are temporarily stored on FME Server, so I could use this URL as a parameter for the output location in the FileCopy Writer.The documentation online told me this should be the 'FME_SERVER_DEST_DIR' parameter? But when I use this

how to import ArcGIS online image data into FME Data Inspector

110

7 years ago

elponeContributor

asked in Data

Shapefile to dwg becoming a block and losing attribute data

Folks, I know I am missing something simple here. What I am trying to do is convert polygons from a shapefile to a dwg while conserving the attribution. The shapefiles are polygons and may or may not have multiparts and donut geometries. As such it seems a mpolygon is the best fit as an AutoCAD datatype.Something similar has been asked Here: Shape to AutoCAD with attributes by @lmerino but no answer I can get to work.I have the cad writer set to extend entity dataHowever when I look at the output in CAD the polygons are coming through as blocks. @Mark2AtSafe suggested using a Deaggregator transformer but I am not sure how this will help. I have done as @erik_jan suggested and added autocad_entity set to autocad_mpolygon via a AttributeManager and everything in the target drawing will then end up as a mpolygon as desired. However there is no attribution.Sample data: Edit: Seems that using a different writer such as Autodesk AutoCAD Map 3D Object Data ends up with the desired outpu

1620

7 years ago

ciarabContributor

asked in Data

Movement of Database to Linux Machine- Impact

If I move my database to a windows to a linux machine is there any impact on FME users of this database other than updating database connections

7 years ago

shepthedog63

asked in Data

Directory and File Path when reading a zip returns 'wrong' dates

Prologue: this suggestion puzzled me, but it's right: in 2016.0 (what I'm using) you can't point a Directory and File Reader at a zip file. You can with a FeatureReader though. Now read on!I'm retrieving the file properties out of a zip file with a FeatureReader with format 'Directory and File Pathnames' and 'retrieve file properties:' set to Yes. Workspace attached, .The file name and file size comes back correct, but all the dates, path_accessed_date, path_created_date and path_modified_date, get set to now. I think FME should be returning the dates the files have inside the zip.P.S. It looks like FME is actually unzipping the files to get at the info:path_windows (string) = d:\\temp\\ea_admin_boundaries.zip_1481293489605_5384\\AREAPF_EA_NE_010K_V1_3.shx...which explains the dates. Still not the right output to give, though, IMNSHO.

7 years ago

mjoarder_pln

asked in Data

Use writer file as a Reader in next step?

Hello Everybody, I am facing trouble to use a writer file (xml) as a Reader file for the second step. I am writing ESRI format metadata in a text_line and saved as a .xml extension. At the second step i want to use this xml file as a input file. Nothing is working , please see the attached imge. I have tried several ways like user parameter, feature to writer and so on,

How to change elements(namespaces) in GML ?

Hi, I am trying to produce a GML 3.2.1 file with elements based on an xsd. Any suggestions ? Thanks in advance,Valantis

295

7 years ago

matiasContributor

asked in Data

IFC4 setting Unit and Coordinate System

I'm Transforming georeferenced EsriShape to IFC4 the problem is that when I convert the buildings are in millimeters and when I use Scale to switch to meters the location is scale too so the position (georeference) change but the buildings in 3D are scale to Meter. I can not find how to use FME to set the corresponding parameters in ifcSIUnit and IfcCoordinateReferenceSystem have some one use FME and IFC4 ?

IFC attribute reading

p { margin-bottom: 0.25cm; line-height: 120%; }I would like to get the value of a specific attribute of an IFC data (data from BIM software). Whereas I can see this attribute in the "feature information" window in the inspector, I cannot see it in the user attribute tab or in the format attribute tab of the "feature type" window in the workbench. Thanks for any help.

FME Exporter for Revit

We are having problems with certain IFC Parameter data not being available. The IFC Exporter has been installed and all settings correct, but some shared parameters in Revit are not coming through into the FME Data Inspector. Is anyone having the same problem?

7 years ago

Page 193 / 273

Badge winners

jlebrun24has earned the badge FME Form Basic Training
jlebrun24has earned the badge English Speaker
jlebrun24has earned the badge French Speaker
aawad.93has earned the badge Teacher (Grey)
aawad.93has earned the badge Student (Grey)

Show all badges

30,458: 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.