Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Notes:

  1. By use the exist gdb as the reader to match the data structure with the writer;

  2. Remove the ObjectId filed from the writer;(double click the - sign to make the lat row all empty), select the truncate first;

  3. double check the layer name and sub-layer name are matching with the portal feature service;

1.       When creating a new ESRI Portal Feature Service, ensure all output attributes can accommodate the maximum Width of strings it is supposed to populate. In general, a value of 200 is sufficient. However, very often attributes such as Title, Description, Remark etc. might have longer strings which requires width between 200-2048. Adjust it as desired.

...

2.       Create a unique ID (uid) for each record using CRC Generator. Set the width to 2048.

**NOTE: No loner required as we can change to output to “Truncate” to delete all existing records then repopulate new ones.

3.       All Date related fields must go through DateTimeCoverter or generated using DateTimeStamper to ensure compatibility.    

...

4.       Ensure all geometries all validated for integrity using the GeometryValidator with Basic Integrity.   

...

5.       Prior to output, filter geometry type, polygon, line and point and connect to the appropriate output port to avoid getting invalid features type.

...

Notes:

  • In create, you can only use Insert mode. The update can be insert, update or delete.

  • ​ In create, if you don't delete the original Feature Service, the output accumulates. (1 liked)

There will be a lots of limitations for the writer updating operations in the FMW, here are some examples and solutions:

Problem 1

Can’t change java date string to ArcGis date field

Solution

Add transformer DateTimeConverter to change the date

  1. @DateTimeFormat(@DateTimeNow(), %Y-%m-%d)

  2. Problem 1

Problem 2

ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '500' and the message was: 'JSONObject["globalId"] not found.'. Details: ''

Solution 2

  1. when creating writer of the feature layer, please use the Global id

...

2. Trim all attribute length to match output using string function @Left(*,#) as shown.

...

Problem 3

DEPRECATED: Add CRCCalculator transformer if the source data has no real unique id

Solution 3

...

Problem 4

Cannot convert a value of type 'java.lang.Double' to 'INTEGER'.'

ArcGIS Portal Feature Service Writer: 'addResults' error for a feature in 'Air_Carrier_2'. The error code from the server was '10500' and the message was: 'Cannot convert a value of type 'java.lang.Double' to 'INTEGER'.'

Solution 4

  1. Use Attribute Rounder to enforce numeric attribute values to 0 decimal.

...

Info

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@20714c
showSpacefalse
sortmodified
typepage
reversetrue
labelsFME FMW Updating Creating
cqllabel in ( "updating" , "fmw" , "fme" , "creating" ) and type = "page" and space = "EGIS"

...