When you are adding a file to Sync, before you run the sync process, you have the option to:
Edit a column, such as rename a heading, change the data type (text, number, date/time, boolean, unicode) and set a field length.
Disable a column, to temporarily remove it from the sync process. This option is suitable when you have very large data sets where not every column is required, as it makes sense to only sync the columns that you want to see in Phocas.
To achieve this:
Go to Data Items and 'Edit columns'. From here you canĀ enable and disable columns.
Image Removed
If you are adding a new file, click the Edit button in the Add File window. If you have already added the file, double-click the file in the Data Item tab to open the Edit File window, then click the Edit button.
Image Added
Make your changes, or to disable a column, clear (uncheck) the Enabled checkbox, then click Save.
Image Added
After you save the file, an asterisk displays in the Edit Columns column in the Data Items tab.