Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

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

4 replies [Last post]
Mia Ng
User offline. Last seen 3 years 10 weeks ago. Offline
Joined: 14 Jan 2008
Posts: 15
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

Replies

Hubert Geier
User offline. Last seen 7 years 7 weeks ago. Offline
Joined: 27 Jul 2006
Posts: 26
Groups: 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...

Tekin Guvercin
User offline. Last seen 10 years 33 weeks ago. Offline
Joined: 30 May 2007
Posts: 20
Groups: 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

Rafael Davila
User offline. Last seen 23 hours 11 min ago. Offline
Joined: 1 Mar 2004
Posts: 5228
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.
Mike Testro
User offline. Last seen 1 week 4 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
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.