Author Topic: Request for Horoscope/List comma separated output  (Read 207 times)

0 Members and 1 Guest are viewing this topic.

Unoit

  • Newbie
  • *
  • Posts: 10
    • View Profile
Request for Horoscope/List comma separated output
« on: February 16, 2021, 01:57:28 AM »
Hello

I am really liking Planetdance, especially the Horoscope/List Feature

Could you add an option to create comma separated output?

Right now I have to copy the output from the Planetdance output window - paste into notepad++, add two blank spaces to "in orb" - save as text file - and then run this file through some javascript to create a txt file that I can paste in a LibreOffice spreadsheet - this way I can sort the entries by date, by Natal, Transit, or Progressed Planet, or by aspect

Here is the part of the javascript:
var myoutput = lines.substr(0,1) + "," + lines.substr(2,10) + "," + lines.substr(13,5) + "," + lines.substr(21,1) + "," + lines.substr(23,1) + "," + lines.substr(25,2) + "," + lines.substr(27,11) + "," + lines.substr(38,14) + "," + lines.substr(52,14) + ","

I use an html file to read this text file [from notepad++] and copy the newly formatted output into a LibreOffice spreadsheet [doesn't seem to work with Excel]

This works when I select In/out and -//- along with the major aspects - it does not work with Text only
Also it does not work with if I include Cusps and or Retro as there is an overlap of text that I can't parse properly - so I made another script just to process Cusps and Retro without In/out, -//- or major aspects

I suppose if csv output was generated then it should work with Text only as well as all the other options

e.g. if a comma was placed after every "variable", [here I am using longhand to represent the Planetdance symbols], i.e.
T, 01/01/2020, 05:09, Mars, trine, Jupiter, out of orb, 0046'19", sagittarius, 2946'19", cancer

as this appears in notepad++ [without Planetdance font]:
T 01/04/2020 05:09    out of orb    0046'19"     2946'19"

I tried to add an image file - a screenshot of some spreadsheet entries - but was unable to do so using Insert Image [via icon] or as an Attachment
Update - looks like I was able to add the screenshot

TIA
« Last Edit: February 16, 2021, 02:12:32 AM by Unoit »

Jean

  • Administrator
  • Sr. Member
  • *****
  • Posts: 258
    • View Profile
Re: Request for Horoscope/List comma separated output
« Reply #1 on: February 16, 2021, 09:03:32 AM »
You know that if you select 'text only' and do a right mouse click you can export the text to the clipboard ?

Will think about this but my first thought is that it's too complicated, i would have to write a whole other way of output providing the comma's, the lists scripts are complicated enough as it is, they can't have much more.

Code: [Select]
T 09/07/2019 01:39   Chiron Conjunct Chiron  0039'02" 0556'25" Aries R  0635'28" Aries
T 15/04/2020 21:18   Chiron Conjunct Chiron exact      0635'28" Aries    0635'28" Aries
T 12/10/2020 15:11   Chiron Conjunct Chiron exact      0635'28" Aries R  0635'28" Aries
T 16/02/2021 08:57   Chiron Conjunct Chiron exact      0635'28" Aries    0635'28" Aries
T 19/12/2021 17:33   Chiron Conjunct Chiron  0150'43" 0826'11" Aries    0635'28" Aries
T 07/07/2069 07:44   Chiron Conjunct Chiron  0131'35" 0503'52" Aries R  0635'28" Aries
T 01/05/2070 03:55   Chiron Conjunct Chiron exact      0635'28" Aries    0635'28" Aries
T 22/09/2070 14:44   Chiron Conjunct Chiron exact      0635'28" Aries R  0635'28" Aries
T 04/03/2071 03:10   Chiron Conjunct Chiron exact      0635'28" Aries    0635'28" Aries
T 19/12/2071 00:50   Chiron Conjunct Chiron  0059'20" 0734'49" Aries    0635'28" Aries
T 21/12/2072 18:20   Chiron Conjunct Chiron  0428'54" 1104'22" Aries    0635'28" Aries
Greetings from Groningen Netherlands <)))><.`.><(((>

Unoit

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: Request for Horoscope/List comma separated output
« Reply #2 on: February 16, 2021, 11:34:07 PM »
Hello

Yes, I know I can right-click, select all and copy to clipboard or save the output as a text file - however when that is done and the contents are pasted into a spreadsheet [or a MS Table] the columns do not line up for every entry - this is why I need to take the steps I mentioned, i.e. add two blank spaces to "in orb' then run this text file through my javascript line parser. I did not realize that it is not a simple process to add commas after each entry. Even though it takes a few extra steps, the method I am using does work in terms of getting this output nicely situated in a spreadsheet.

Thanks again for your excellent astrology program.

Jean

  • Administrator
  • Sr. Member
  • *****
  • Posts: 258
    • View Profile
Re: Request for Horoscope/List comma separated output
« Reply #3 on: February 17, 2021, 10:26:38 AM »
what you could do is rename horoscope list.ab to something else so it won't be ovewritten when you update, then edit it using application edit.
Look at line 346 and on

Code: [Select]
        strset(s, "%c %s %s   %p %s%t%1a %i", typestr[type], datestr, timestr, findp1, retronames[findtype], findr1, findr1 / 30);

Change these to

Code: [Select]
        strset(s, "%c %s %s,   %p, %s%t%1a, %i", typestr[type], datestr, timestr, findp1, retronames[findtype], findr1, findr1 / 30);

Note the extra komma's in the first part of strset(). You can run he script with F9.
It's a lot of work though.
Greetings from Groningen Netherlands <)))><.`.><(((>

Unoit

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: Request for Horoscope/List comma separated output
« Reply #4 on: February 18, 2021, 08:32:11 PM »
Hi

Thank you for this information.

I played around editing this file - I was able to get more or less what I wanted, except for a couple of things:

1. when there is an exact major aspect I can't get the longitude and the sign of each planet in the same column i.e one column that has the longitude and sign for the transiting/progressed planet and another column that has the longitude and sign for the natal planet.
 
2. when the major aspect is close to exact, e.g.   0035'01", I can't get the longitude and the sign of each planet in the same column

Obviously this is not a problem when the aspect is // or # as there is no sign given

What line should I edit and what should I do to get the longitude and sign in the same column

Jean

  • Administrator
  • Sr. Member
  • *****
  • Posts: 258
    • View Profile
Re: Request for Horoscope/List comma separated output
« Reply #5 on: February 19, 2021, 07:47:59 AM »
You could try to leave out things but it's tricky, a sign is %i in the first part of strset() and has a corresponding value in the list of arguments, mostly something like 'findr1 / 30'.
Greetings from Groningen Netherlands <)))><.`.><(((>