The tool used to import concepts in CSV format to Arquimedes has been improved (Decomposition tree menu > Tree > Import from CSV format). In previous versions, this option was called “Import decomposition from CSV format” and allowed for a CSV file to be imported to be added as the decomposition of a chapter.
As of the 2013.k version, this option is now called Import from CSV format and allows for information to be imported from:
- CSV format files
- The clipboard of the operating system, where the user has copied information from Excel spreadsheets
The option, Import from CSV format, has also been included in the contextual menu that appears when users click, using the right mouse button, on a “Chapter” or “Job item” type concept (with or without decomposition) in the “Decomposition tree” window of Arquimedes.
Additionally, the program offers several import possibilities, depending on the concept that has been selected in the Decomposition tree window of Arquimedes. These possibilities are displayed in a dialogue box before importing, when the option to Import from CSV format is selected. These are:
- Chapter tree and its decomposition
This option must be used when the information to be imported contains one or more chapter levels, including job items with their decomposition and, optionally, their quantity details. For the information to be extracted appropriately, each decomposed element, be it a chapter or job item, must have a line referred to as the “decomposition footer” that indicates which is the last element of its decomposition, and so be able to interpret the nested decompositions correctly. The files produced when the jobs are exported to Excel belong to this type of format.
This option can be activated in the “Import from CSV format” dialogue box if the concept that has been selected previously is of the “Chapter” type (including the root chapter). - Job items tree and its decomposition
This type of import should be used when the information to be imported only contains job items with their corresponding decompositions and details. This format is a subgroup of the previous format, and so the same rules are applicable concerning the “decomposition footer”.
As in the previous option, it is only active when the selected concept is of the “Chapter” type. - Concept list with its decomposition
The information imported using this option requires a more simple format. A “decomposition footer” is not required. In this case, the different column arrangement is used to distinguish the decomposed concepts (do not have a price or amount) from the unit items they are composed of (contain quantity and price).
It is active with the “Chapter” and “Job item” concept types. - Simple concept list
The information imported using this option requires the most simple format. It consists of a list of concepts that may or may not contain a quantity or yield, which will be added to the decomposition of the current concept.
It is active with the “Chapter” and “Job item” concept types.
Once the option has been chosen, the program opens another dialogue box to edit the data import process.
