Where the professionals network; have you Self Assessed? become a Guild Reviewer? or reviewed Guild Phase 2?

Import/Export to Ascci file, please help!!!

4 replies [Last post]
Tue, 2010-05-25 07:29
Mia Nguyen
User offline. Last seen 9 weeks 18 hours ago. Offline
Joined: 14 Jan 2008
Content Credits: 11
Groups: Civil Engineering, GPC United Kingdom
I have tried to export data to Excel (using Import/export to Ascci File), edited and saved the excel file. However when I tried to import the data back to Tilos, nothing happeded (i.e. no changes in current programme). Also the file type that Tilos allow to import is txt. file (not excel file). Is there anything I did wrong there? I was using the same function Import/export to Ascci File to import the file back). Many thanks
Top

Replies

Thu, 2011-06-09 17:36
#1
Hubert Geier
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 27 Jul 2006
Content Credits: 23
Groups: GPC Germany, IT Engineering Projects, Network Rail, Pending Guild Members, Railway Construction, TILOS

It works in the follwing way:

1 Export your xls data to clipboard: 1 Line = 1 Task.

2. Start TILOS 7 and Open the project

3. File / Import Menu

4. Select option ASC TXT

5. Select datasource = Clipboard

6. Select Import profile or Create a new rule: (Press F1 for help how to set up)

7. Slect sub project where data should go to

8 Import

You can import tasks, but also links etc...

Top
Tue, 2011-03-29 22:43
#2
Tekin Guvercin
User offline. Last seen 47 weeks 2 days ago. Offline
Joined: 30 May 2007
Content Credits: 10
Groups: Asta Powerproject, GPC Poland, IT Engineering Projects, TILOS

Which version of TILOS you use? Copy-Past from Excell work quite well in TILOS. IF you want to use complex excell file for import you need to have macro instaled

Top
Tue, 2010-05-25 17:12
#3
Rafael Davila
User offline. Last seen 4 hours 2 min ago. Offline
Joined: 1 Mar 2004
Content Credits: 2701
Groups: Spider Project Team
Save as CSV (MS-DOS)

Try saving the file from excel as a CSV(MS-DOS) file and try to import this file from Asta Tilos. CSV(MS-DOS) file format for many decades have been unchanged an probably will never be, it is a universal standard, contrary to worksheet files that every few years are changed. If Asta Tilos selection for file import was CSV(MS-DOS) it was a smart choice.

In case the required format is not coma separated value or CSV you can try with a copy and paste from the worksheet to windows notepad and then try importing from the notepad file.
Top
Tue, 2010-05-25 16:44
#4
Mike Testro
User offline. Last seen 20 hours 47 min ago. Offline
Joined: 14 Dec 2005
Content Credits: 2957
Groups: Asta Powerproject, Building Information Modelling, Content Moderators, GPC India, GPC United Arab Emirates, GPC United Kingdom, Pending Guild Members
Hi Mai

I don’t run Tilos but usually with Asta products you can copy paste directly from the programme to a spreadsheet and back again.

Best regards

Mike Testro.
Top