Re: PDesk CSV import/export plugin BETA version for testing

Tom,

It seems to work!! great!!
OK, let's cool down a bit, here is what I did:

- I downloaded the new file (link below), unzipped it, and 
copied/replaced the files in the plugins folder.
- I opened the demo file and could see it.
- I tried to make a few changes (adding tasks) and exported as csv 
with new name.
- I opened this new file with excel and could see the way columns 
were loaded, I mapped the info to what was in the project (priority, 
% of progress, task name and note content, ...)
- I guessed first column was the indentation level (tasks, sub-tasks, 
sub-sub-tasks,...)
- I guessed last column was (will be?) for the icon index.

Armed with this, I tried to create a project from scratch in Excel:
- filling the columns as I understood them,
- pushing the envelop as far as creating sub-tasks (level 1) and sub-
sub-tasks (level 2) with some % of progress,... ;-)
- I struggled a bit with saving as CSV, I needed to tell excel twice 
that I wanted the CSV format but this is Microsoft, right?
- then I tried to import it in PDesk and ... "Tom's magic at 
work" .... I was able to see the project exactly as I had imagined it 
when I created it in excel.

So, now if I have a project in excel, I can write the macros to put 
the information in the right format, in the right cells, in the 
proper order, create some information for task types (informative, 
action, progress,...) then save as CSV. I'll try that.

If I have a project in an other application, I need to try to save it 
in CSV format but I am not sure if there are different format or not. 
I guess I'll have to try too.

Again, you are good! thanks for the effort.
If there is any other test, torture, you want me to do on the current 
version, let me know.
I'll keep continue to try different things anyway.

Take care,

 


--- In [email protected], "Tomas" <dr.tom@...> wrote:
>
> Thanks again for testing and suggestions.
> 
> New version of plugin is now available at:
> http://www.vscripts.net/wp-content/uploads/2006/09/csvinout.zip
> 
> It will now import the file it exported, and uses Excel dialect of 
CSV
> format. Task types can be imported too. Default/suggested values are
> pre-setup. 
> 
> Known problems:
> # TODO: whole opened file content is overwritten on import
> # TODO: doesn't change file status to changed, thus no question
> whether or not to save the file on exit
> # TODO: CSV module to be included with PDesk install and not 
separately
> 
> Known shortages/to be fixed in more distant future:
> - doesn't import nor export values of numeric type
> - doesn't work with task status (completed vs. uncompleted)
> - icon can only be exported (?, probably just an icon number)
> 
> I would appreciate bug reports and suggestions.
> 
> What was not tested yet and should be, in particular, is quotation
> marks in notes, multi-line notes, and notes with commas.
> 
> Greetings,
> Tom
>







------------------------ Yahoo! Groups Sponsor --------------------~--> 
Something is new at Yahoo! Groups.  Check out the enhanced email design.
http://us.click.yahoo.com/TktRrD/gOaOAA/yQLSAA/b2FxlB/TM
--------------------------------------------------------------------~-> 


Remember to visit Polls, Files and Bookmarks sections at http://groups.yahoo.com/group/progect. You are welcome to vote, upload your files and submit bookmarks. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/progect/

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/