GenoPro Support Forum

Fantastic, it works .  This computer technology is wonderful when you can use it, unfortunately I can't.  I'm happy that you are kind enough and help helpless rookie as I am.  Many thanks and all the best :, wishes Jarmo

Thanks to you good advise I was able to add succesfully the "Second Last Name" into this report, thats great!  As it is so often, one question leads to another ie. is there a possibility to evaluate (during the report execution), that if there is "Second Last Name" you use it as a persons "Last Name" and in a case there is not a "Second Last Name", the "Last Name" fields value is used?  BR, Jarmo

I should modify the report you helped me to create (see attachment; "contacts.js") some time ago.  Now I should add the "Second Last Name" to the report BUT I don't know what is the name of the field in the database.  Would you be kind enough (again) and help me. 

Two silly questions:

1. Where/how do you find the field names?

2. Why it is written (in file "contacts.js") as follows: "...Report.WriteLn('\uFEFF' + 'ID,FullName,LastName..." - nb. "LastName" and then later "...ID.substring(3), i.Name, i.Name.Last,..." - nb. "i.Name.Last"?  I mean that first the field is called "LastName" but then later "i.Name.Last"?

Bestwishes, Jarmo

contacts.js (65 views, 1.23 KB)

Thank you for advising how to get leading zeroes into MS Excel!  I did change, according to your advise, my username.  Sorry for beeing silly and haven't changed it before.  BR, Jarmo

PS. Your "contacts.js" report has helped me a lot beeing secretary for our family's association with "membership register" because now I don't need to keep redundant info in MS Excel but instead updating all information into Genopro.  Do you by the way have experiences how to record yearly payed membership fees into GenoPro - Custom Tag perhaps or any othe data relevant to family associations?   I haven't found issues (on forums) of this kind of need so far.

My Excel is a little rusty but AFAIK you cannot avoid this if you open a .csv file directly. You need to invoke Excel's text import 'wizard' . In Excel 2007 you can start Excel with a blank sheet and then use menu Data / Get External Data / From Text and then select the file. Go through the wizard setting delimiter to comma and then change the format of the first column from General to Text. Then import. Other versions of Excel will be similar. You can also rename to .txt and open with Excel, select the 1st column and use Data, Text to Columns to achieve exactly the same.

p.s. If you visit the Control Panel on this forum you can change your id from 183942 to a proper name of your choice - it just seems a bit weird to me communicating with numbers!

I Added ID from Individual and removed "Ind" -letters from the beginning with substring(3) function (see code below) --> 
now  MS Excel removes trailing zeros when importing <-- any ideas, how can I avoid this?
<%[
// Produce .csv file of contact details for living individuals with a current address, phone no. or email
Report.WriteLn('\uFEFF' + 'ID,FullName,LastName,FirstName,Type,PlaceName,Street,Zip,City,County,State,Country,Telephone,Mobile,Email')
// Loop through all contacts
for (var cCnt=0; cCnt<Contacts.Count; cCnt++)
{
    var c = Contacts(cCnt);
    if ((c.DateEnd.ToStringNarrative=='') && (!Util.IsNothing(c.Place) || (c.Telephone+c.Mobile+c.Email) != ''))
    { // no end date and place, phone, mobile or email is present
    var refs = c.References.ToGenoCollection;
        for (var iCnt=0; iCnt < refs.Count; iCnt++)
        {
            var i = refs(iCnt);
            if (i.Class == "Individual")
            {
                if (!i.IsDead) Report.WriteFormattedln('"{0}","{1}","{2}","{3}","{4}","{5}","{6}","{7}","{8}","{9}","{10}","{11}","{12}","{13}","{14}"',
                    i.ID.substring(3), i.Name, i.Name.Last, i.Name.First, c.Type, c.Place, c.Place.Street, c.Place.Zip, c.Place.City, c.Place.County, c.Place.State, c.Place.Country, c.Telephone, c.Mobile, c.Email );
            }
        }
    }
}
]%>

BR, Jarmo

Thanks a lot for your update to this excellent report.  It seems to work now at least with MSExcel 2003 (11.8231.8221) SP 3 version as expected ie. å,ä,ö letters looks fine and also eMail is included.  Many thanks and have a nice day! 

BR, Jarmo