Method exportChartData

server/controllers/ChartController.js:1057–1127

(userId, chartIds, filters, projectId)

  }

  exportChartData(userId, chartIds, filters, projectId) {
    const parsedChartIds = Array.isArray(chartIds)
      ? [...new Set(chartIds
        .map((id) => Number(id))
        .filter((id) => Number.isInteger(id) && id > 0))]
      : [];

    if (parsedChartIds.length === 0) {
      return Promise.reject(new Error("Invalid chart IDs"));
    }

    const whereCondition = { id: parsedChartIds };
    if (projectId) {
      whereCondition.project_id = projectId;
    }

    return db.Chart.findAll({
      where: whereCondition,
      include: [{ model: db.ChartDatasetConfig, include: [{ model: db.Dataset }] }],
      order: [[db.ChartDatasetConfig, "order", "ASC"]],
    })
      .then((charts) => {
        if (charts.length !== parsedChartIds.length) {
          return Promise.reject(new Error("One or more charts are not accessible"));
        }

        const dataPromises = [];
        charts.forEach((chart) => {
          dataPromises.push(
            this.updateChartData(
              chart.id,
              { id: userId },
              {
                noSource: false,
                skipParsing: false,
                filters,
                isExport: true
              },
            )
              .then((data) => {
                // first, make sure the sheet name is no longer than 31 characters
                let sheetName = `${chart.name} - ${nanoid(5)}`;
                if (chart.name.length > 26) {
                  let newChartName = chart.name.substring(0, 23);
                  if (newChartName.lastIndexOf(" ") > 10) {
                    newChartName = newChartName.substring(0, newChartName.lastIndexOf(" "));
                  }
                  sheetName = `${newChartName} - ${nanoid(5)}`;
                }

                // remove any special characters
                sheetName = sheetName.replace(/[^a-zA-Z ]/g, "");

                return {
                  name: sheetName,
                  datasets: chart.ChartDatasetConfigs,
                  data,
                };