OpenPetra
Free Administration Software for Non-Profits
|
import and export partner data More...
Static Public Member Functions | |
static PartnerImportExportTDS | ReadPartnerDataForCSV (Int64 APartnerKey, List< String >ACSVColumns) |
read data from db for partner with given key according to csv columns needed More... | |
static PartnerImportExportTDS | ImportFromCSVFileReturnDataSet (string ACSVPartnerData, string ADateFormat, string ASeparator, out TVerificationResultCollection AVerificationResult) |
This imports partners from a CSV file and returns the imported data as a dataset More... | |
static bool | ImportFromCSVFile (string ACSVPartnerData, string ADateFormat, string ASeparator, out TVerificationResultCollection AVerificationResult) |
This imports partners from a CSV file More... | |
static bool | ImportFromODSFile (byte[] AODSPartnerData, out TVerificationResultCollection AVerificationResult) |
This imports partners from a ODS file More... | |
static bool | ImportFromXLSXFile (byte[] AXLSXPartnerData, out TVerificationResultCollection AVerificationResult) |
This imports partners from a XLSX file More... | |
static Boolean | CommitChanges (PartnerImportExportTDS MainDS, Boolean AReplaceAddress, Boolean AIgnoreImportAddress, Int64 ASiteKeyToBeReplaced, Int32 ALocationKeyToBeReplaced, out TVerificationResultCollection AVerificationResult) |
Web connector for commit changes after importing a partner Before calling SubmitChanges on the dataset, this does a load of checks and supplies values to index tables. More... | |
static bool | CheckExtractContainsFamily (int AExtractId) |
Checks to see if an extract contains at least one family partner More... | |
import and export partner data
|
inlinestatic |
Checks to see if an extract contains at least one family partner
|
inlinestatic |
Web connector for commit changes after importing a partner Before calling SubmitChanges on the dataset, this does a load of checks and supplies values to index tables.
MainDS | |
AReplaceAddress | |
AIgnoreImportAddress | |
ASiteKeyToBeReplaced | |
ALocationKeyToBeReplaced | |
AVerificationResult |
|
inlinestatic |
This imports partners from a CSV file
ACSVPartnerData | The data to import |
ADateFormat | A date format string like MDY or DMY. Only the first character is significant and must be M for month first. The date format string is only relevant to ambiguous dates which typically have a 1 or 2 digit month |
AVerificationResult | A collection of import errors |
ASeparator | Comma or Semicolon |
|
inlinestatic |
This imports partners from a CSV file and returns the imported data as a dataset
ACSVPartnerData | The data to import |
ADateFormat | A date format string like MDY or DMY. Only the first character is significant and must be M for month first. The date format string is only relevant to ambiguous dates which typically have a 1 or 2 digit month |
AVerificationResult | A collection of import errors |
ASeparator | Comma or Semicolon |
|
inlinestatic |
This imports partners from a ODS file
AODSPartnerData | The data to import |
AVerificationResult | A collection of import errors |
|
inlinestatic |
This imports partners from a XLSX file
AXLSXPartnerData | The data to import |
AVerificationResult | A collection of import errors |
|
inlinestatic |
read data from db for partner with given key according to csv columns needed