tag:blogger.com,1999:blog-1951542926024108564.post319477890771053536..comments2024-01-12T19:52:27.760+11:00Comments on The Map Guy(de): Using the Data Query view in FDO Toolbox (part 2): CRUD operationsJackie Nghttp://www.blogger.com/profile/14319639645667992869noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1951542926024108564.post-20311107150536473262010-06-16T00:20:39.320+10:002010-06-16T00:20:39.320+10:00Perfect!!
Thanks so much Jackie.
WarrenPerfect!!<br />Thanks so much Jackie.<br /><br />WarrenWarren J. Medernach, BGIS, GISPhttps://www.blogger.com/profile/06428056376860827413noreply@blogger.comtag:blogger.com,1999:blog-1951542926024108564.post-54071089187623824702010-06-15T18:50:48.551+10:002010-06-15T18:50:48.551+10:00There is an XML schema definition (BulkCopyTask.xs...There is an XML schema definition (BulkCopyTask.xsd) that describes the structure of a bulk copy task.<br /><br />If XSDs are alien to you, the simple answer is that the ExpressionMappings element can have any number of ExpressionMapping elements. Each ExpressionMapping element requires a unique alias (to identify this expression) and a target property where values from this expression are written to. <br /><br />Optionally you can specify whether to use NULL in case of failed conversion (nullOnFailedConversion. Default value: true) or whether to truncate the value to be inserted if the target property is of a lower precision (truncate. Default value: true)<br /><br />Here's an example with 1 expression mapping that maps the CurrentDate() expression to a property named "MyTargetProperty", because I haven't explicitly specified any conversion attributes, they will default to "true":<br /><br />< ExpressionMappings><br /> < ExpressionMapping <br /> alias="MyFdoExpr"<br /> target="MyTargetProperty"><br /> < Expression><br /> CurrentDate()<br /> < /Expression><br /> < /ExpressionMapping><br />< / ExpressionMappings><br /><br />Hope that helps.Jackie Nghttps://www.blogger.com/profile/14319639645667992869noreply@blogger.comtag:blogger.com,1999:blog-1951542926024108564.post-4545277064452961202010-06-10T05:14:21.690+10:002010-06-10T05:14:21.690+10:00Hey Jackie, I realize you've moved on to manag...Hey Jackie, I realize you've moved on to managing Maestro, but I was hoping I might ask a question about FDO Toolbox. <br /><br />I am attempting to create a Bulk Copy procedure with a filter, but the filters don't seem to 'stick'. When I view the saved XML it is not there either.<br /><br />Can you let me know what the syntax is to manually try to add an Expression Mapping? I'm assuming something like:<br /><br />< ExpressionMappings><br /> < MyExpression><br /> < unsure of syntax here /><br /> < / MyExpression><br />< / ExpressionMappings><br /><br />Thanks for your time.<br />Warren MWarren J. Medernach, BGIS, GISPhttps://www.blogger.com/profile/06428056376860827413noreply@blogger.com