Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Account '`' in Transactions.csv but not in Account.csv error
Hello again
Received the following error:
Account '`' in Transactions.csv but not in Account.csv
when running my UpdatePSData.bat file for V3.
Here is psCheckFiles.txt log output:
16:37:24 --- Starting script psCheckFiles.ps1
16:37:24 File Dates.csv. Record count: 3041
Dates.csv. Row count - must be at least 2 (header and at least one date) - OK
Dates.csv. First row (file header) should be 'Date' - OK
Dates.csv. All but first row (header) should be in format YYYY-MM-DD - OK
Dates.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
Dates.csv. Maximum date in file should be today - OK (2023-04-27)
Dates.csv. Dates should be unique - OK
16:37:25 File Dates.csv check completed. No issues found.
16:37:25 File Quotes.csv. Record count: 5102
Quotes.csv. Row count - must be at least 2 (header and at least one record) - OK
Quotes.csv. First row (file header) should be 'Date Close Symbol' - OK
Quotes.csv. Each row should have exactly two column separators (' ') - OK
Quotes.csv. All rows should have 'Date' column in format YYYY-MM-DD - OK
Quotes.csv. Minimum date in file should be after configured MinDate - OK (2014-12-31)
Quotes.csv. Maximum date in file should be today or before - OK (2023-04-27)
Quotes.csv. Date+Symbol should be unique - OK
16:37:26 File Quotes.csv check completed. No issues found.
16:37:26 File Dividends.csv. Record count: 2
Dividends.csv. Row count - must be at least 1 (header) - OK
Dividends.csv. First row (header) should be 'PayDate DividendPerShare Symbol' - OK
Dividends.csv. Each row should have exactly two column separators (' ') - OK
Dividends.csv. All rows should have 'PayDate' column in format YYYY-MM-DD - OK
Dividends.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
Dividends.csv. Maximum date in file should be today or before - OK (2014-12-31)
Dividends.csv. Date+Symbol should be unique - OK
16:37:26 File Dividends.csv check completed. No issues found.
16:37:26 File CurrencyConv.csv. Record count: 4268
CurrencyConv.csv. Row count - must be at least 1 (header) - OK
CurrencyConv.csv. First row should be 'Date ExchRate CurrencyFrom CurrencyTo' - OK
CurrencyConv.csv. Each row should have exactly three column separators (' ') - OK
CurrencyConv.csv. All rows should have 'Date' column in format YYYY-MM-DD - OK
CurrencyConv.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
CurrencyConv.csv. Maximum date in file should be today or before - OK (2023-04-27)
CurrencyConv.csv. Date+CurrencyFrom+CurrencyTo should be unique - OK
16:37:27 File CurrencyConv.csv check completed. No issues found.
Account '`' in Transactions.csv but not in Account.csv
16:37:34 --- Finished. Duration: 10 sec.
=======================================================================================
Your script version is: 3.0.1, Online script version is: 3.0.0
Thank you
Received the following error:
Account '`' in Transactions.csv but not in Account.csv
when running my UpdatePSData.bat file for V3.
Here is psCheckFiles.txt log output:
16:37:24 --- Starting script psCheckFiles.ps1
16:37:24 File Dates.csv. Record count: 3041
Dates.csv. Row count - must be at least 2 (header and at least one date) - OK
Dates.csv. First row (file header) should be 'Date' - OK
Dates.csv. All but first row (header) should be in format YYYY-MM-DD - OK
Dates.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
Dates.csv. Maximum date in file should be today - OK (2023-04-27)
Dates.csv. Dates should be unique - OK
16:37:25 File Dates.csv check completed. No issues found.
16:37:25 File Quotes.csv. Record count: 5102
Quotes.csv. Row count - must be at least 2 (header and at least one record) - OK
Quotes.csv. First row (file header) should be 'Date Close Symbol' - OK
Quotes.csv. Each row should have exactly two column separators (' ') - OK
Quotes.csv. All rows should have 'Date' column in format YYYY-MM-DD - OK
Quotes.csv. Minimum date in file should be after configured MinDate - OK (2014-12-31)
Quotes.csv. Maximum date in file should be today or before - OK (2023-04-27)
Quotes.csv. Date+Symbol should be unique - OK
16:37:26 File Quotes.csv check completed. No issues found.
16:37:26 File Dividends.csv. Record count: 2
Dividends.csv. Row count - must be at least 1 (header) - OK
Dividends.csv. First row (header) should be 'PayDate DividendPerShare Symbol' - OK
Dividends.csv. Each row should have exactly two column separators (' ') - OK
Dividends.csv. All rows should have 'PayDate' column in format YYYY-MM-DD - OK
Dividends.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
Dividends.csv. Maximum date in file should be today or before - OK (2014-12-31)
Dividends.csv. Date+Symbol should be unique - OK
16:37:26 File Dividends.csv check completed. No issues found.
16:37:26 File CurrencyConv.csv. Record count: 4268
CurrencyConv.csv. Row count - must be at least 1 (header) - OK
CurrencyConv.csv. First row should be 'Date ExchRate CurrencyFrom CurrencyTo' - OK
CurrencyConv.csv. Each row should have exactly three column separators (' ') - OK
CurrencyConv.csv. All rows should have 'Date' column in format YYYY-MM-DD - OK
CurrencyConv.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
CurrencyConv.csv. Maximum date in file should be today or before - OK (2023-04-27)
CurrencyConv.csv. Date+CurrencyFrom+CurrencyTo should be unique - OK
16:37:27 File CurrencyConv.csv check completed. No issues found.
Account '`' in Transactions.csv but not in Account.csv
16:37:34 --- Finished. Duration: 10 sec.
=======================================================================================
Your script version is: 3.0.1, Online script version is: 3.0.0
Thank you
Comments
Fat fingers strikes again