Method importTableFromCsv

app/src/DataModel/ProjectModel.cpp:5736–5819

* @brief Imports registers from a CSV file into an existing table, accepting both the * read-write/read-only permission terms and the legacy computed/constant type values. */

 * read-write/read-only permission terms and the legacy computed/constant type values.
 */
void DataModel::ProjectModel::importTableFromCsv(const QString& tableName)
{
  const int idx = findTableIndexByPath(tableName);
  if (idx < 0)
    return;

  auto it = m_tables.begin() + idx;

  const auto path = QFileDialog::getOpenFileName(nullptr,
                                                 tr("Import Table"),
                                                 Misc::WorkspaceManager::instance().path("CSV"),
                                                 tr("CSV files (*.csv)"));

  if (path.isEmpty())
    return;

  QFile file(path);
  if (!file.open(QIODevice::ReadOnly | QIODevice::Text))
    return;

  QTextStream in(&file);

  if (!in.atEnd())
    in.readLine();

  constexpr int kMaxImportRows = 1'000'000;

  int imported = 0;
  int rowsRead = 0;
  while (!in.atEnd() && rowsRead < kMaxImportRows) {
    ++rowsRead;
    const auto line = in.readLine().trimmed();
    if (line.isEmpty())
      continue;

    const auto parts = line.split(',');
    if (parts.size() < 3)
      continue;

    const auto name     = parts[0].trimmed();
    const auto permsStr = parts[1].trimmed().toLower();
    auto valStr         = parts.mid(2).join(',').trimmed();
    if (valStr.size() >= 2 && valStr.startsWith('"') && valStr.endsWith('"')) {
      valStr = valStr.mid(1, valStr.size() - 2);
      valStr.replace(QStringLiteral("\"\""), QStringLiteral("\""));
    }

    if (name.isEmpty())
      continue;

    const bool computed =
      (permsStr == QStringLiteral("read-write")) || (permsStr == QStringLiteral("read/write"))
      || (permsStr == QStringLiteral("rw")) || (permsStr == QStringLiteral("computed"));

    bool isNumeric              = false;
    const double dval           = SerialStudio::toDouble(valStr, &isNumeric);
    const QVariant defaultValue = isNumeric ? QVariant(dval) : QVariant(valStr);