The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Ogw and multiple files
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

RockerSWE

Sweden
6 Posts

Posted - 04/04/2010 :  08:50:00 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
I create a custom report sheet, and do "Save window as..." to be able to use the formatting of the custom report sheet for other data files.

If I then do import ascii and chose a file, and choose "replace existing data", everything is fine, but if I want to import multiple files in the same way, it creates new books, without the report sheet. I would like to create multiple books with both the new dataset, and the custom report sheet. Is that possible?

Origin Ver. and Service Release (Select Help-->About Origin): 8.0
Operating System: Win Vista

larry_lan

China
Posts

Posted - 04/05/2010 :  10:18:46 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi:

You'd better save the workbook as Template. Right-click the workbook title bar and select "Save Template As...".

Then, when importing files with Import Wizard, in the Source page, select the template you saved from Template drop-down, and choose Start New Books from Import Mode.

Thanks
Larry

Edited by - larry_lan on 04/05/2010 10:19:13 PM
Go to Top of Page

easwar

USA
1964 Posts

Posted - 04/06/2010 :  1:23:26 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

When you save the OGW file (Save Window As...), save it to your User Files Folder (UFF).

Then in Import Wizard, the Template drop-down will pick up and show such OGWs from the UFF so you can then easily select multiple files, select the OGW as template and set Import mode to new book.

When saving ogw, save it with data sheet active so the data from the file will go into active sheet.

In version 8.1 we have a Batch Processing tool which works much nicer than having to use Import Wizard in this manner. The Batch Processing tool can also provide a summary sheet of desired info from each file. You can watch this movie:
http://www.originlab.com/index.aspx?s=9&lm=407&pid=1559

Easwar
OriginLab
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000