Skip to main content

Data

Using readers and writers to extract and load data.

  • 7,310 Posts
  • 26,856 Replies
7310 Posts
A
arka
 Data
M
ma2cdw
 Data
mattias
Contributor
mattiasContributor
 Data
ESRISHAPE readers don't fetch schemas from all source tables in ZIP archives

Hello!TLDR; My ESRISHAPE readers don't fetch schemas from all my source tables.I have a workspace with multiple ESRISHAPE readers, each of which are reading its own separate ZIP archive.The readers are using Merge Feature Type (*) to allow all Shape files in each archive to be read.I'm writing all these Shape files to a dynamic MSSQL_SPATIAL writer using "fme_feature_type" as Schema Definition Name. Most Shape files have copies (containing data from separate geographic regions) in each source archive. Their region suffix is ignored so they can be written to the same destination tables.It goes something like this:Reader1 The archive contains the tables: Table_A_1Table_B_1Table_C_1The reader fetches the schemas of all the tables in the first archive, logging: "Reader `ESRISHAPE_1' of type `ESRISHAPE' provided schema for types: Table_A_1,Table_B_1,Table_C_1"Reader2 The archive contains the tables: Table_A_2Table_B_2Table_C_2Table_D_2The reader seems to

925
mattias
Contributor
J
jhuillery
 Data
Proper formatting for writing EXIF gps data to jpg

Hello,  I'm attempting to geotag photos with FME Desktop by writing coordinates to the jpgs with an AttributeCreator.  The following headers have been attempted with no luck: jpeg_exif_gpslatitude jpeg_exif_gpslatitude jpeg_exif_gpsmapdatum etc... which is how the data appears in the data inspector with a properly geotagged photo. The tag names from http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/GPS.html were also attempted with no luck.  The proper data types were also considered.  Any idea of how to write gps EXIF data to jpg?  I know its possible with the exiftool and other third party apps but I'd like to keep it all within one workbench, without calling any other applications.  Thanks,  John 

5823
LizAtSafe
Safer
J
jwisb
 Data
R
ralf
 Data
A
anilkb1105
 Data
C
claire_wilson
 Data
Excel to multiple DGN layers

I have a database of hundreds of assessment results for utilities. In FME, I have taken the utility coordinates from the database, joined into lines, sorted into 'pass' or 'fail' and organised by utility owner. This all works. I have done a microstation DGN writer for each e.g. electric 'pass', electric 'fail', gas 'pass' etc etc. I have also tried putting all outputs into one DGN writer. Neither gave me what I needed which is to have individual layers for each result and utility type, which can be switched on and off. I can't do a fanout (I dont think) because I need to fanout by an attribute and I dont have the results as attributes, but rather as sorted/styled data. Would I need to use an AttributeCreator, or is there a way in the DGN writer to get multiple layers in the DGN based on my sorted data? Thanks.

1348
C
M
maliodpalube
 Data
M
maliodpalube
 Data
redgeographics
VIP
redgeographicsVIP
 Data
M
mojgarg
 Data
V
vral
 Data
carmijo
Supporter
carmijoSupporter
 Data
M
maartjekuijten
 Data
M
malikgam
 Data
P
p80cey
 Data
D
dheeraj
 Data
How to read the symbology related attributes from a CAD File

Hi,I want to read the following attributes related to symbology from a CAD file and want to store it in Single Attribute by using Json Packer and want to store it into File Geodatabase. Color: Color Template: Template File Source Blocks–> Block Name, Block Rotation, Block Size By, X, Y, Z Lines–> Line Type, Line Type Generation, Line weight, Line Scale, Line Elevation, Area–> Area Entity Type, Fill Pattern Name (if Gradient), Pattern Scale, Gradient Name, Gradient Fill Color 1, Fill Color 2, Fill angle, Fill Origin x, Fill Origin Y. Text–>Text Entity Type, True Type Font Name, Text Shape Name, Text Justification, Text Size, Text Rotation, Text.I also want to use these attributes by unpacking it in DWG Styler in some another workflow.Can help in this?Thanks in advance. Appreciate your quick support.

755
gabriel_hirsch
Contributor
F
fhilding
 Data
Reading Openstreetmap and writing it right back loses tags?

I have a set of nodes on this format:<node lat="56.07686365" lon="12.11483240" id="800000002" changeset="1" timestamp="2017-09-10T20:50:35.826Z" version="1">  <tag k="ActiveFrom" v="1900-01-01T02:00:00.000000000Z"/>  <tag k="ActiveTo" v="3000-01-01T01:59:59.000000000Z"/>  <tag k="ProductionPointCategory" v="4"/></node>When I read them in to the OSM reader as basic nodes, I get a list of tag{}.k and tag{}.v. I want to do some light filtering on this data, mainly checking if they exist in another dataset.Thereafter, I want to write them back to the same format that they came from. However, if I just connect the reader straight to the writer, it doesn't write out any of the content of the tag-list. I have to expose all the attributes that I want to be written, which seems like a backwards idea since the information is already there in the key-part of the tag-list.Is there a way to get the writer to write the contents of the tag-list, without me manually expos

704
gabriel_hirsch
Contributor
dbklingdom
Contributor
dbklingdomContributor
 Data
K
klika68
 Data
C
cmcnamara
 Data
P
paulmascaro
 Data
M
maxbuiaus
 Data
A
aquamarine
 Data
Show more activity

Badge Winners

  • FME Certified Sales Professional
    cfellinger1has earned the badge FME Certified Sales Professional
  • Online Training
    lambertbhas earned the badge Online Training
  • Online Training
    chriswilsonhas earned the badge Online Training
  • Excited by APIs
    j.botterillhas earned the badge Excited by APIs
  • Online Training
    zinniahas earned the badge Online Training
Show all badges

Community Stats

32,865
Posts
124,710
Replies
41,465
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.