Since data types are neither exported by the database program, nor imported into Acoustic Campaign, re-labeling data (columns) with data types is done during the import procedure. Data types can be specified for columns that contain fields with certain data types.
If data types cannot be re-labeled in the new database, queries can be done by specifying text as the data type.
For example, a spreadsheet might have labeled the data in the fields using data types. An account number may be labeled an integer or nominal, and a date might be in a specific date format. Yes and No, True and false, may be labeled Boolean. A database like My SQL has many data types. But data types are not exported into a text file, nor can they be directly imported into an Acoustic Campaign database. It is helpful when doing queries on databases to have labels and data consistency, so data labeling may be very important.
All dates within Acoustic Campaign are formatted as MM/DD/YYYY. The option at import allows you to tell the system how the dates which you are importing are formatted. Thus, if dates on your CSV, TSV, or PSV file are DD/MM/YYYY, you should also choose DD/MM/YYYY as the format during the import.
After the import is complete, all dates are converted to MM/DD/YYYY format and appear as such in Acoustic Campaign.
Dates can also be formatted as dd.mm.yyyy, mm.dd.yyyy, dd-mm-yyyy or mm-dd-yyyy
Important: The date format is critical in Acoustic Campaign. The date cannot be in European format (day first), with the year abbreviated (as in '17'), or with the day missing (12/2020), it also cannot be abbreviated (12/1/2020). For import, dates should be changed to the Acoustic Campaign format, and labeled as dates during the import process.