Creating multiple projects at once via spreadsheet

Author Message
Steve K. 11/01/2006 05:58 am
1 November 2006

Hi Oleg,

I would love to create a large number of OEP Projects at once, using a spreadsheet (or CSV text file) that would be imported or merged into OEP. If this were possible, a new OEP Project would be generated from each row of the spreadsheet.

Each column of the spreadsheet would correspond to a separate field in OEP Project Properties. Only 3 or 4 fields would need to be supported: Project name, Addresses (for URLs & "Additional=" commands), and Level Limit. If possible, a plain-text Project Description field would be nice too. All other fields would be covered by the default template or another selected template.

Of course, none of this might be possible. But if you could add such a feature to OEP, I would be thrilled!

Thanks, as always.

Sincerely,
Steve K.

PS: Perhaps this would be easier to do if a separate field if a separate field existed in the Project Properties for the "Additional=" command line. If such a field existed, and if it could be filled using a template, it would save me time apart from the above feature request. After all, I use the same "Additional=" commands on almost every Project.
Oleg Chernavin 11/01/2006 07:12 am
Steve,

This is a feature that would not be useful for many people. I would suggest you to write a simple program that would feed these data to Offline Explorer using its command-line. It has enough features for this already.

Best regards,
Oleg Chernavin
MP Staff
Aaron 03/04/2008 07:18 am
Hi,

I just thought that I would comment on this, since I have recently been evaluating many of these types of programs. I have actually downloaded and tried about 6 of them, and have to say that Offline Explorer Pro seems to be the most reliable and easy to setup program. However, the one feature that you seem to lack, that all of the others did have, is the ability to import a list of urls from a text file. The beauty of this import, at least from my standpoint, is that I can use a different program to build the text file, and then have OE work from the text file. I realize it looks possible using the Command Line functions to address this issue, but thought you might like some feedback.

Thanks,
Aaron
Oleg Chernavin 03/04/2008 08:47 am
I can add such feature easily. The only issue is that each project might have its own settings - level, filters and so on. So, this feature might be quite sophisticated to do such import.

There is another way to feed a large amount of URLs.

Copy all of them to clipboard and use Edit - Paste menu. By default it creates one project with all these URLs. You can choose a template for pasting with the desired Project settings. If you press Shift key while using Paste, Offline Explorer Pro will create multiple Projects - one per line in the clipboard.

Oleg.
Aaron Dones 03/04/2008 09:02 am
Thanks for the fast reply. The copy/paste idea is certainly workable, and an obviuos solution.

My overall idea for wanting an import function, is to have another program create the text import file, then through a simple and single command line, have OE begin to work on the list of urls, all under the same project guidelines.

I would suggest that if a user wants to import a quantity of urls to have OE work on, then all of those urls in the import group, would be processed under the same project guidelines. I think this would be appropriate functionality for a basic Import Function.

If enough requests came to you, then an Advanced Import Function could be added to allow logic/intelligence to be applied to each url in the import group. Actually, in this case, if each url needs a different project, I would think that your original Command Line solution might be the better answer.

In my humble opinion, the idea of an import function, is just to satisfy the simply situation, where multiple urls need to be processed the same way.

Thanks again,
Aaron


> I can add such feature easily. The only issue is that each project might have its own settings - level, filters and so on. So, this feature might be quite sophisticated to do such import.
>
> There is another way to feed a large amount of URLs.
>
> Copy all of them to clipboard and use Edit - Paste menu. By default it creates one project with all these URLs. You can choose a template for pasting with the desired Project settings. If you press Shift key while using Paste, Offline Explorer Pro will create multiple Projects - one per line in the clipboard.
>
> Oleg.
Oleg Chernavin 03/04/2008 09:34 am
You can do it this way - create a Project that has the following in the URLs field:

{:file=c:\file.txt}

And each time you start the download, Offline Explorer Pro will get links from this c:\file.txt and download them.

Oleg.
Aaron Dones 03/04/2008 03:50 pm
I must be doing something wrong, because it doesn't seem to work.

I have tested my project with the correct url in the URLs field, and it works. When I replace the destination url with exactly {:file=c:\file.txt} then the program appears to look at the file.txt and you can see the link in the progress window, but no files get downloaded. Is there another setting that needs to be changed? I am currently testing with only one url in the text file, for multiple urls, will they need to be separated by something, or just be on their own line?

Thanks!


> You can do it this way - create a Project that has the following in the URLs field:
>
> {:file=c:\file.txt}
>
> And each time you start the download, Offline Explorer Pro will get links from this c:\file.txt and download them.
>
> Oleg.
Oleg Chernavin 03/05/2008 06:52 am
Please allow downloading from all servers and directories. Would this help?

Oleg.
Aaron Dones 03/05/2008 03:52 pm
Yes, that seems to have fixed the problem. Thanks!

> Please allow downloading from all servers and directories. Would this help?
>
> Oleg.
Oleg Chernavin 03/06/2008 04:52 am
OK. Great! I will need to improve the code to allow starting server/dir in this case.

Oleg.
Steve K 03/22/2008 09:09 am
Though I'm rather late in returning to this thread, I did start it, and I just want to say that I too will be using the last method you suggested -- which involves specifying a local text file path in the URL field.

This could be very useful. Thank you.


> OK. Great! I will need to improve the code to allow starting server/dir in this case.
>
> Oleg.
Oleg Chernavin 03/22/2008 12:23 pm
You are welcome! If it has to be improved somehow, let me know.

Oleg.