Import is greyed out or nothing was written: rows in the sheet failed the check

Question 1

Why do I see "Choose a filled-in sheet first"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 2

Why do I see "Fix the N rows listed below, then choose the file again"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 3

Why do I see "This sheet has no rows to add or update"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 4

Why do I see "Nothing has been written. Fix the rows below in your sheet and choose the file again."?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 5

Why do I see "Checked, nothing written yet. Use Import to apply it."?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 6

Why do I see "Pick one of the values listed on the Lists sheet."?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 7

Why do I see "<field>: required"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 8

Why do I see ": required, one of "?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 9

Why do I see ": "" is not one of "?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 10

Why do I see ": no called "" (known: )"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 11

Why do I see "category: say Landowner or PAP Tenant"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 12

Why do I see "category: "<v>" is not a category"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 13

Why do I see "category: <X> belongs under a society, not under a project"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 14

Why do I see "category: <X> belongs under a project, not under a society"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 15

Why do I see "tenant_id: no allottee with this id here (was the sheet exported from another society or project?)"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 16

Why do I see "membership_no: "<no>" is already used here"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 17

Why do I see "membership_no: "" also appears on row "?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 18

Why do I see "first_name: required"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 19

Why do I see "phone: required, 5 to 20 characters"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 20

Why do I see ": "" is not a number"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 21

Why do I see ": "" is not a whole number"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 22

Why do I see ": is out of range"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 23

Why do I see ": "" is not a date (use YYYY-MM-DD)"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 24

Why do I see ": "" is not Yes or No"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 25

Why do I see "unit_id: no unit with this id in this project"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 26

Why do I see "unit_number: the same unit appears on row <n>"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 27

Why do I see "designation: unit is ; release it before changing what it is for"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 28

Why do I see "parking_slot_id: no parking slot with this id in this project"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 29

Why do I see "parking_slot_number: the same parking slot appears on row <n>"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Question 30

Why do I see "parking_type: required for a new parking slot"?

Accepted Answer

Imports are all or nothing. When you choose a file, the app first checks every row and reports what it would add, update or skip, without saving anything. The Import button applies the sheet in a single step only when no row fails. If one row in three hundred is wrong, none of the three hundred is written, so the data is never left half-imported and you can simply fix the sheet and try again. The checks are the same rules the screens apply one record at a time: required fields, numbers and dates in the right form, names that match what already exists on the project (towers, parking areas and types, unit types, pricing plans, charge components, construction stages), and records that are not listed twice. Rows are matched to existing records by their id column (from an export) or by their natural key (tower, floor and unit number; parking area and parking slot number; membership number), and updated rather than added when they match. Row numbers are the spreadsheet's own row numbers, so "Row 14" is row 14 in Excel (row 1 is the header). 1. Read the listed rows in the dialog; each red line names the column and the problem. 2. Fix them in your sheet in Excel. Pick closed columns from their dropdown (the values live on the Lists sheet); use the names exactly as the app shows them; write dates as real dates or YYYY-MM-DD; remove duplicate rows. 3. If ids point at another project or society, export the list from this one (Export) and copy your changes into it, or clear the id column so the rows are matched by their key or added as new. 4. If a name is unknown (a tower, parking type, unit type or charge component), either correct the spelling to one listed under "known", or add the missing item on its own screen first (for example the charge component under Masters > Charge Components, or the unit type under Settings > Lookups), then download a fresh template so its dropdowns include it. 5. Save the sheet and click Choose another file, then pick it again. The check reruns on the new file. 6. When the blue "Checked, nothing written yet. Use Import to apply it." appears, click Import N rows. You see "Imported into ." and a toast " added, updated.", and Cancel becomes Done. Importing needs the Create and Edit permissions on the tab's module: Towers, Floors & Units for units, Parking for parking slots, Construction Stages for stages, Pricing Plans for unit pricing, and Tenants for members, landowners and PAP tenants. Without both, the Import button is not shown at all.

Message	Meaning
"<field>: required" / "<field>: required, one of <values>"	The cell is blank but must be filled.
"<field>: "<v>" is not one of <values>" / "<field>: no <thing> called "<v>" (known: …)"	The value is not one the app knows, for example a tower, parking type, unit type or charge component spelt differently.
"<field>: "<v>" is not a number" / "… is not a whole number" / "<field>: <v> is out of range"	A number cell holds text, a decimal where a whole number is needed, or a number outside the allowed range.
"<field>: "<v>" is not a date (use YYYY-MM-DD)"	Dates must be real Excel dates or written as 2026-10-05.
"<field>: "<v>" is not Yes or No"	Yes / No columns take Yes or No.
"unit_number: the same unit appears on row <n>" / "parking_slot_number: the same parking slot appears on row <n>" / "membership_no: "<no>" also appears on row <n>"	The same record is listed twice in the sheet.
"unit_id: no unit with this id in this project" / "parking_slot_id: no parking slot with this id in this project" / "tenant_id: no allottee with this id here (was the sheet exported from another society or project?)"	The id column points at a record that is not on this project or society, usually because the sheet was exported from another one.
"category: say Landowner or PAP Tenant" / "category: "<v>" is not a category" / "category: <X> belongs under a society, not under a project" (or the reverse)	On a project's allottee sheet every row must say Landowner or PAP Tenant; society members belong on the society's own sheet. The "belongs under" message names the sheet you are importing into, not where the row belongs: a Society Member row on a project's sheet reads "belongs under a project, not under a society", and a Landowner row on a society's sheet reads "belongs under a society, not under a project".
"first_name: required" / "phone: required, 5 to 20 characters"	An allottee row needs a first name and a phone number.
"membership_no: "<no>" is already used here"	Another member of the society already has that membership number.
"designation: unit <n> is <status>; release it before changing what it is for"	A unit that is reserved for tenants, on hold for a buyer, allotted, booked or sold cannot change designation.
"parking_type: required for a new parking slot"	New parking slots need a parking type.

Import is greyed out or nothing was written: rows in the sheet failed the check

Messages this explains

Import is greyed out or nothing was written: rows in the sheet failed the check

What you see

Why it happens

How to fix it

Related