02-01-2017 03:44 PM - edited 02-01-2017 03:46 PM
I am trying to use Schema Remodeler to export features from a WFS source to local SQL DB.
The WFS service I am using is:
I am not using any area filters, tilesets or attribute filters. I can set up source connections under Sources tab fine, however whenever I try to choose the source feature class, following error occurs.
Initially I thought this issue could be WFS service dependent, then I tried a number of other WFSs, same error persisted.
I am using GM16 Build 1415
02-01-2017 06:10 PM
What you want is better achieved by ' Output to FeatureClasses ' command.
You can Select Attibutes , Reorder Attributes and Rename Attributes and output to SQL Server
02-02-2017 01:40 PM
I am using Schema Remodeler because:
02-02-2017 02:53 PM
Yes, there seems to be a problem with 3 of the Attributes
Location_nilReason, Shape_nilReadon which are memo format
and Shape_owns which is boolean.
I changed the two memo attributes to Text(255) and the boolean to text
and it all works OK SQL Server
I note all these attributes have NO data, I believe the boolean needs a default, not sure
about the two memos. Maybe ask support.
02-02-2017 03:29 PM
The problem where Schema Remodeler is throwing an error when attempting to work with WFS data is reported CR Defect 1-KEP0QR. You may want to log a Service Request that can officailly applied the report.
02-02-2017 06:13 PM
thanks Roland, tried to use the Output to feature classes tool again, unselected Location_nilReason, Shape_nilReadon and Shape_owns attributes, exported fine.
Yup need to find out the rules around data types.