This is what we're trying to achieve, let's say:
1. We had a form with these two columns:
╔════════╦═══════╗
║ Job No (UID) ║ Cient ║
╚════════╩═══════╝
We have already +1000 records for these 2 fields.
2. We added these two new columns to our form:
╔════════╦═══════╦════════════╦══════╗
║ Job No (UID) ║ Cient ║ Department ║ Code ║
╚════════╩═══════╩════════════╩══════╝
3. We exported the data (with blank values for Department and Code) and populated values for them, using a formula and saved it as a CSV file (or XLS)
Q1: Can we use the update option in Zoho Migration Tool to only update the values for these two new columns in each of the existing records, without touching the rest of the data, assuming that the Job No is our UID? What are the risks involved? Any better way to do this?
Q2: Zoho Migration Tool takes a very long time to upload my sample data to my test system, returns no messages or errors and doesn't actually upload anything ; the progress bar fills multiple times but then restarts from half-way again. How can I troubleshoot this?
Thanks