Data Managementផ្ទាំងអន្តរកម្ម

Settings (Excel Editor)

កំណត់រចនាសម្ព័ន្ធការនាំចេញ-នាំចូល Excel — កន្លែងសរសេរ workbook អ្វីដែលវាផ្ទុក និងរបៀបផ្ទៀងផ្ទាត់ការកែពេលអនុវត្ត។

រកឃើញនៅឯណា
KGA Toolbox ▸ Necessary Edit Tools ▸ Edit in Excel ▸ Settings

ទិដ្ឋភាពទូទៅ

These settings govern the behaviour of Edit in Excel and Apply Excel Edits. Set them once before using either.

ការប្រើប្រាស់

  • Export Location is the folder workbooks are written to. Leaving it empty uses the system temp directory, as the dialog notes. Set a real folder for work that spans more than one session — the operating system can clear temp files, taking an in-progress edit with them.
  • Export Options shape the workbook:
OptionEffect
Show OBJECTID column (read-only)Includes OBJECTID as a read-only column. Worth enabling: it makes visible the key the apply step matches on, so it is obvious that those values must not be edited.
Apply domain value dropdowns in ExcelTurns coded-value domains into Excel dropdowns, keeping entry within the permitted values and preventing rows the apply step would reject.
Max records (0 = unlimited)Caps the exported row count. Check this before exporting a large layer — a cap below the layer's row count means only part of the data is exported, and only that part will be edited.
  • Import Options govern the apply step:
OptionEffect
Create backup before applying editsBacks up the feature class before writing. Leave this on — it is the practical way back from a bad apply.
Skip invalid rows (otherwise abort all)Unchecked, the whole apply aborts on the first invalid row and the feature class is untouched. Checked, valid rows are written and bad ones reported, leaving the data partly updated.
  • Reset Defaults restores the original settings.
  • The two most consequential choices are Max records (which can silently limit what you export) and Skip invalid rows (which decides whether a failed apply leaves the data whole or partly changed).

ប៉ារ៉ាម៉ែត្រ

Parameters for Settings (Excel Editor)
ផ្ទាំងគ្រប់គ្រងការពិពណ៌នា
Export Location

The folder workbooks are written to. Empty means the system temp directory.

Browse...

Browses for the export folder.

Show OBJECTID column (read-only)

Includes OBJECTID in the workbook as a read-only column.

Apply domain value dropdowns in Excel

Renders coded-value domains as Excel dropdowns.

Max records (0 = unlimited)

The maximum number of rows exported. 0 means no limit.

Create backup before applying edits

Backs up the feature class before the apply step writes to it.

Skip invalid rows (otherwise abort all)

Skips invalid rows instead of aborting the whole apply.

Reset Defaults

Restores the original settings.

OK

Saves the settings.

របៀបប្រើ

  1. On the KGA Toolbox tab, in the Necessary Edit Tools group, open the Edit in Excel menu and click Settings.
  2. Click Browse... and set an Export Location in a real folder, not the temp directory.
  3. Check Show OBJECTID column (read-only) and Apply domain value dropdowns in Excel.
  4. Set Max records to 0 unless you deliberately want to cap the export.
  5. Check Create backup before applying edits.
  6. Leave Skip invalid rows unchecked for an all-or-nothing apply, or check it to let a large edit proceed past a few bad rows.
  7. Click OK.

ព័ត៌មានអាជ្ញាបណ្ណ

Requires an active KGA Toolbox license. The tool validates the license before running.

មើលផងដែរ

ត្រឡប់ទៅឯកសារណែនាំ