Both the user and task imports work according to the same general principles. In each case, the import source file must be in CSV format with DOS/Windows Carriage Return + Line Feed invisible characters. The 1st “line” of the CSV contains “headers” that are associated with AceProject “fields”, each header being separated from the next […]
Articles Tagged: Exporting/Importing Data
Where in the interface is it possible to export data?
AceProject allows you to export data to Excel and CSV formats in several areas of the interface. First, account administrators have access to the Administration => Tools> Export Data interface page. On that page, project structure, tasks and timesheet items from one or all projects may be exported. This page also allows you to export your […]
Are there important things to know when importing users?
Here are a few important things you should know when importing users: When you export your users, the export file will contain stars (“*********”) in the Password field for all users to mask the actual passwords. If you wish to perform mass modifications to user profile information through an export/import procedure, do not make any […]
Are there important things to know when importing tasks?
Here are a few important things you should know when importing tasks: Although the source CSV file may contain values for both the ProjectNumber and ProjectName fields, only the ProjectName field is mandatory. This means you can actually leave out the ProjectNumber field altogether and AceProject will refer to the ProjectName values in the CSV to determine […]
What is the FTP service for and how can I get the credentials for this service?
The FTP site we provide our customers will give you access to the last 3 nightly backups we perform of your SQL database (only available with paid packages). The database backup is a .bak SQL database file that you can restore into SQL Server 2014 or higher. An account administrator may request the credentials for the […]