Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,700 Posts
  • 24,701 Replies
6700 Posts
N
ndohet
asked in Data
AutoCAD2004Writer::setExtents

Hi, I'm trying to create an error file with AutoCAD DWG/DXF Reader/Writer and i've got an issue :  Specified block 'CENTRO_LOCAL' is not defined in AutoCAD file. Skipping featureMULTI_WRITER: multi_writer_id `3': Writing feature 0 AutoCAD Writer: Performing database audit...AutoCAD Writer: An error occurred for dataset 'D:\\Routines2014\\LOGS\\DWG_ENGLOS_01122016.dwg', in function AutoCAD2004Writer::setExtents. Exception thrown: 'Invalid input'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ... Anybody's got an idea ?

0
N
7 years ago
A
antonlarsson10
asked in Data
3DAffiner: Add additional z-values

Is it possible to add extra z-value to a point cloud (las) with 3D affiner? I need to add extra 0,507m to my already existing z-values. I'm changing from a local to an national height system but i don't know the parameters from the local one.regards, Anton

3
A
7 years ago
U
uba_kp
asked in Data
NetCDF – problem with spatial reference

Dear FME-users,  I’ve created a GeoTIFF-file based on NetCDF-data.   The problem is the spatial reference. A compare to OSM-data in the attachment shows you, that the GeoTIFF-file is not placed right. The second picture is from Copernicus and right placed.  Do you have an idea?  Thank your very much.  Best regards.  Konrad

10
david_r
Influencer
7 years ago
sigtill
Contributor
sigtillContributor
asked in Data
Use Directory and File Pathnames on ftp and sftp?

Is this possible? Or do I have to recursively use FTPCaller for "each level" of the ftp/sftp and build the strings manually? This is on both FME Desktop and FME Server. Even better: Add support on FME Server to "Add resource" and Type of Resource Connection would be ftp/sftp

3
sigtill
Contributor
7 years ago
taojunabc
Participant
taojunabcParticipant
asked in Data
FME 2017.0.0.2 64bit Can not use Esri Geodatabase (File Geodb ArcObjects)

Not long ago, I updated the FME from 2017.0.0.1 to 2017.0.0.2, But today I found that it can't use Esri Geodatabase (File Geodb ArcObjects) format. If I choose Esri Geodatabase (File Geodb ArcObjects) format, FME prompts the error and automatically shut down. And I open workspace that include reader or writer with Esri Geodatabase (File Geodb ArcObjects) format, I try to change reader or writer's parameters, also can appear the same problem. FeatureReader and FeatureWriter have the same problem. I remember in the previous version?FME 2017.0.0.1 64bit?, there is no problem .Also installed the FME 2016.1.3.2 64bit on my PC?Use FME 2016.1.3.2 64bit can read and write with Esri Geodatabase (File Geodb ArcObjects) Without any problems.I also refer to the following URL?I confirm that I have installed [ArcGIS for Desktop and 64 bit Background Geoprocessing].Notes on FME and Esri Versions and CompatibilityDon't know if anyone had experienced the same problem with me. I want to know

3
taojunabc
Participant
7 years ago
D
davidwesstrom
asked in Data
Regarding FBX Reader/Writer

Hi! I have been looking into the FBX reader/writer functionality in the 2017 version. All works as intended regarding the 3Dmodelling which is great! But i was hoping to add/read attribute data to/from this format.We use the Unreal engine to visualize and have the FBX format as our input to it.I read on the reader/writer page for FBX that it is not available in this versionSo, attribute data on the FBX format, is this something that is being looked into at the moment or is it beyond the horizon?We are mostly looking forward to the potential of writing the attribute data onto a FBX model.Thanks/David

3
D
7 years ago
M
michaellampi
asked in Data
Why doesn't FME Desktop write all the selected parameters to a CSV file?

I have a workspace in which I have selected a CSV file writer to contain the results. The user parameters selected to be written appear in the CSV file. On the other hand, the format attribute (fme_text_string) I have selected does not appear in the CSV. All the results appear in the data inspector, and for a workaround I am forced to select the data in the table and save it to a file from there.What am I doing wrong?

3
M
7 years ago
L
locontem
asked in Data
Socrata SODA API to anything!

I spent most of today struggling trying to get a Socrata SODA API dataset to an ESRI file geodatabase. I am able to read the data using the text reader and this url as the source:https://chhs.data.ca.gov/resource/c2p3-ahn4.json?$where=county_name%20=%20%27ALAMEDA%27&$limit=5 This is valid JSON according to JSON lint, but no geometry is recognized because it isn't in a GEOJSON format. I have tried using the JSONFragmenter/JSONExtractor/JSONUpdater transformation tools but just can't get the hang of it.  I am using the Data Interoperability extension for ArcGIS. Any help is appreciated. 

3
itay
Contributor
7 years ago
S
stgt
asked in Data
It is possible to run password-protected workbenches on the fme-server?

The title says it all. Directly you can not upload these workbenches. But maybe using the FMEServerJobsubmitter. The password is then passed using published-parameter. You could upload a dummy workbench with the same name and exchange these directly on the FME server against the password protected Workbench. Or are there other tricks?

7
david_r
Influencer
7 years ago
R
rkcha
asked in Data
Write file / item to a AGOL content folder?

Hi,we´re having a AGOL account were we would like to put other stuff beside naps, layers, applications etc. It would be nice if it would be possible to write / upload a PDF or DWG file (item) to a specific content folder / group, so that our users easily could access this information in one place. Using the AGOL writer it seems that it´s only possible to select folders with feature services in?Christian

1
runneals
Contributor
7 years ago
angwan
Contributor
angwanContributor
asked in Data
Extract from ArcGIS Online Feature Service

Hi, How can i extract feature service from arcgis online. I've feature service that i want to pull them down to local file geodatabase using fme. Kindly help

1
runneals
Contributor
7 years ago
andrew_r
Contributor
andrew_rContributor
asked in Data
How does one apply a filter to the MongoDB reader to limit results?

I'm a GIS guy and new to MongoDB. I'm trying to use FME to read and analyze data in a Mongo database. The collection I'm trying to read has 10 million plus records so I'd like to be able to filter that down to a subset for testing. If this was an Oracle or ArcGIS reader I'd place a SQL whereclause on the reader to limit what FME starts with. On the MongoDB reader I don't see a whereclause option. I see a Collection Qualifer and a JSON query parameter on the Feature Type window, so is this where I would apply a MongoDB filter? I tried entering so MongoDB'ish find() code in this but it doesn't work, so maybe I'm entering it wrong.To simplify an example, here's what I'd like to do on my reader in SQL:select * from MyTable where MyStringField = 'MyClassification' And here's the Mongo translation of the same thing:db.MyTable.find({ "MyStringField": "MyClassification" });Now I'm left figuring out how to

2
andrew_r
Contributor
7 years ago
tim_wood
Contributor
tim_woodContributor
asked in Data
What does this mean? "Splitting feature table into features..."

I'm reading a couple of CSVs using the CSV2 Reader in FME 2017.0 then passing the data through AttributeManager. When it gets there, this appears in the log file: 2017-04-20 14:07:14| 89.6| 1.3|WARN |AttributeManager(AttrSetFactory): Splitting feature table into features because this factory does not support feature tablesCan someone explain what this means? Is it something to do with CSV2?

3
david_r
Influencer
7 years ago
R
rawansaleh
asked in Data
A generic tool/ workbench to convert multiple mdf files to gdb in ArcMap

To enjoy multiusers editing environment, our data is stored in mdf files (enterprise). However, when it comes to publishing, we convert the mdf to gdb in order to gain some performance as the services that read from gdb are much faster than those read from mdf. We are wondering if there is a generic tool that can convert multiple mdf files to gdb. Thank youBestRawan

9
david_r
Influencer
7 years ago
D
dunuts
asked in Data
DGN Colours to GIS Attributes

Hi all, I've got a workbench where I'm trying to convert a series of dgns to a geodatabase. I have used the tester to filter out the colour white (which is the title block, the dgns are 20 years old) and then I've used a geometry filter to filter by 'area' so that I only get the polygons I need. The inspector gives me exactly what I want except that I now need to made the 'fme_color(string)' an attribute, for example I would like green (0,1,0) to be freehold in my geodatabase attribute table. Can anybody help me out? Thanks

2
erik_jan
Contributor
7 years ago
R
robyn_studts
asked in Data
Microstation V8I to Microstation V8i Cells with Embedded text nodes (Enter Data Fields"

I am translating V8I Cells with embedded Text Nodes to V8i. The Text in the text node is not translating. The text node is being nulled out. Is there a transformer that I can use that will allow me to keep the text and use it in the new cell with an embedded text node?

5
R
7 years ago
I
ian2016
asked in Data
Appearance Styler only working for jpeg

I have successfully managed to add a jpg to a TIN surface using a jpeg, appearance styler and appearance adder. When I swap in a png, with the same extent, (perhaps any image with transparency?) it no longer works. I get a black surface, or sometimes a silver one.

2
redgeographics
Evangelist
7 years ago
H
hui
asked in Data
Extract data from a database to a csv file and upload to s3

New to FME. I roughly know the first half, i.e. extract data to csv file is simple. But how to get the csv writer to trigger the next step of the workflow to upload it to s3 bucket? The writer has no output. Thanks!

4
H
7 years ago
pschout
Participant
pschoutParticipant
asked in Data
? Edit Text File parameters

Edit Text File parameters In a workbench that reads messages from waterway users I will join weather info based on date and time to those messages. Most off these messages concern cases off near misses (interaction of ships or ships and infrastructure). Weather info like wind, winddirection and visibility are important parameters for further analyses. With a Text File reader I make a connection to our weather institute and get hour data from the datacenter. So every night I read the messages from the day before and the idea is to join the weather info from the same day. In the source text file one of the parameters is the start date from where the weather data is read (in this case 20170411 and start hour is 01, see png). So what I want is to make the start date variable and depending of the actual date, I will only read the last 2 days of weather data! Is it possible to make the start date variable in this case? I use FME desktop 2015 but will also publish the workspace at FME serve

6
pschout
Participant
7 years ago
K
kumarkannan1980
asked in Data
Hi I am getting error(" ORA-01002: fetch out of sequence") while converting oracle spatial to microstation dgn for a particular database table . Kindly let me know how to resolve it.

4
K
7 years ago
N
navaneeth
asked in Data
How can i read the DIMENSION parameter of a DGN to determine if a dgn file is 3d file or 2d file.

How can i read the DIMENSION parameter of a DGN to determine if a dgn file is 3D file or 2D file. We have a lot of dgn files and would like to find a way to identify the files which are 3D. Is there a way to do this? Please see the screenshot below from FME data inspector. I would like to read the property highlighted in red color and make a decision if the file is 3D or 2D.  Thank you. 

5
fmelizard
Contributor
7 years ago
gmbutler2
Contributor
gmbutler2Contributor
asked in Data
How to Write Text Nodes to Microstation V8i (Select Series 3) using FME 2017?

I have read an article on the forum entitled Writing Microstation (DGN) Text Nodes with FME but after trying to understand all of the multiple items needed demonstrated in that article, I can't get text nodes to write properly into Microstation using FME. The DWG's are so nice in that they write multi-line text perfectly but Microstation just goes crazy. Is there a simpler way to write them? Whenever I do, they lose a lot of the linkages and no matter what I do I can't get the text to recognize carriage returns or new lines. Can somebody help me?

1
L
7 years ago
L
luigibr
asked in Data
How to read binary header, samples etc from a segy file?

Hi,i am trying to read a segy file.the coordinate are ok but the attribute no.They show weird character (maybe encoding?)How can i configure that? I can't find any option on segy reader.Is this possible?Thanks.

1
L
7 years ago
lottegis
lottegis
asked in Data
AutoCAD text height and width

I am converting Microstation DGN to AutoCAD DWG drawings. One thing I'm trying to translate exactly is the text insertion point and horizontal alignment. While the values come through exactly, visually, some of the text don't match. I have the following mapped:igds_original_justification -> autocad_justificationigds_insertion_x -> autocad_alignment_xigds_insertion_y -> autocad_alignment_yAnd conditional values set for the following:autocad_width_factorautocad_shape_nameOne thing I noticed is in Microstation, one can set both text height and text width. For DWG, the text width seems to assume the height (or size) value. See the attachment for the difference in the alignment:I'm hoping the alignment issue will be resolved if the width is the same as in DGN. Is it possible at all to set text width for DWG?Is there any other way I can get the alignment to match perfectly?Thank you.

9
G
7 years ago
E
emmythammasine
asked in Data
Revit 'Mark' Parameter to ArcMap

First post ever!I am exporting from Revit (RVZ) to FME and finally importing the ESRI Shape file into ArcMap. The problem I am getting is that I cannot get the Revit instance parameter "Mark" to eventually show up in ArcMap.I've tried many options but have not succeeded. Please help!!!Thank you

4
E
7 years ago

Badge winners

  • Teacher (Grey)
    paulmcm601has earned the badge Teacher (Grey)
  • I Treasure Lists
    bwnhas earned the badge I Treasure Lists
  • English Speaker
    vadishas earned the badge English Speaker
  • Swedish Speaker
    vadishas earned the badge Swedish Speaker
  • Student (Grey)
    vadishas earned the badge Student (Grey)
Show all badges
29,707
Posts
Terms & ConditionsCookie settings