ESdat Forums
»
Forums
»
ESdat
»
Table Template - ESdat desktop
Rank: Advanced Member
Groups: Registered
Posts: 84
Thanks: 2 times
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 327 Was thanked: 29 time(s) in 29 post(s)
|
Hi Nick,
Multiple columns in standards can occur when you have conditionally based standards, such as depth dependancies, matrix dependancies, chem code depaendancies.
I suspect this is the case with the tables where you have two columns (Boron>1.5m, HWS Boron<1.5m).
Cheers,
Nick
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 84
Thanks: 2 times
|
OK - so in server, I can expand or hide the conditional depth columns. If I expand them, then there is a heding that indicates the depth range, which makes it much clearer.
Is adding headings to the conditional depth columns generated in desktop something that can be added to a future update?
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 327 Was thanked: 29 time(s) in 29 post(s)
|
Hi Nick,
ESdat Desktop does this also:
range.JPG (187kb) downloaded 2 time(s).
I note in your example that the line with the EQL has been merged with the Standard name, which is where this depth range should be.
Can you please post a screenshot of the Table Layout tab of the Chemistry Table Output Setup (from the More Options button before you click Finish on the export)?
Does the depth information export if you modify any of these settings?.
Thanks,
Nick
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 84
Thanks: 2 times
|
Table sample and screenshot attached. I tried several iterations with different options selected, I never see the depth range headings.
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 327 Was thanked: 29 time(s) in 29 post(s)
|
Hi Nick,
I'm not sure that screenshot attached correctly.
Nevertheless, I have been able to replicate this using a very similar setup to how your data was presented.
It seems to be related to the fact that there is only one conditional depth included in the standard.
If all parameters in the standard have a conditional depth applied, then it outputs with the depth info shown.
We will look into why it is doing this.
As a workaround, setting the Conditional_Depth_From value for the other paramters to 0 will allow the headers to export.
Thanks,
Nick
|
1 user thanked Nick Support for this useful post.
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 84
Thanks: 2 times
|
Can this be done by generating a populated zref standards table and reimporting using update existing?
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 327 Was thanked: 29 time(s) in 29 post(s)
|
Hi Nick,
No that is likely to duplicate the records (duplicates are allowed on this table to allow the conditions). If you want to use this approach, you'll need to delete the standard completely.
You'd be better off just editing directly within zRef_Environmental_Standards.
Apply the following filter (please double check the filter is correct for your data so you don't accidentally populate other standards as well):
ActionLevelSource = 'Table 2 - Agricultural or Other, coarse soil' AND Conditional_Depth_From Is Null
Then you should be able to select the Conditional Depth From column using the header, and the value you type in the first cell will be filled down. Cheers,
Nick
Edited by user Wednesday, November 20, 2019 10:27:11 AM(UTC)
| Reason: Not specified
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 84
Thanks: 2 times
|
Perfect. Thanks. Wish I had known that trick before!
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 84
Thanks: 2 times
|
ChemistryTable (9).xlsx (42kb) downloaded 4 time(s).So the quick fix worked fine for Desktop, but had an unintended consequense for Server. See attached Chemistry Table (9).xlsx. Now there are four standards colums, one of which is blank.
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Table Template - ESdat desktop
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.