/**
*
* @param string $jotFormUrl
* @param string|null $password
* @throws UnableToRetrieveCsvFile
*/
public function __construct($jotFormUrl, $password = null)
{
// My Constructor
$this->jotFormUrl = $jotFormUrl;
$this->password = $password;
$downloadHelper = new JotFormDownloadHelper();
// Download Excel-File from jotForm
$filePath = $downloadHelper->downloadFromJotForm($jotFormUrl, $password);
$splFile = new \SplFileObject($filePath);
// Parent Construct
parent::__construct($splFile, $rowNumber = 0);
}
/**
*
* @param string $jotFormUrl
* @param string|null $password
* @throws UnableToRetrieveCsvFile
*/
public function __construct($jotFormUrl, $password = null)
{
// My Constructor
$this->jotFormUrl = $jotFormUrl;
$this->password = $password;
$downloadHelper = new JotFormDownloadHelper();
// Download CSV-File from jotForm
$filePath = $downloadHelper->downloadFromJotForm($jotFormUrl, $password);
$splFile = $downloadHelper->fileNameToSplFile($filePath);
// Parent Construct
parent::__construct($splFile, $delimiter = ',', $enclosure = '"', $escape = "\n");
$this->file->seek(0);
// jotForm Specific CSV-Options
$this->setHeaderRowNumber(0, CsvReader::DUPLICATE_HEADERS_INCREMENT);
$this->file->setFlags(\SplFileObject::READ_CSV | \SplFileObject::READ_AHEAD | \SplFileObject::SKIP_EMPTY);
// Sometimes the CSV-Entry contains a "," at the end and sometimes not
// Stupid jotForm
$this->setStrict(false);
}