Welcome to the Calyx Software Message Boards where you can share ideas and solutions with other Calyx users! Calyx personnel including Tech Support, Development, QA, and Business Planning often visit these message boards unofficially to better understand our customers' needs. To submit your suggestions Click Here.
This discussion forum is a service provided by Calyx Software. Calyx Software does not endorse any particular point of view expressed in this forum or any information provided in it. The use of the information provided by other users in this message board is at your own risk.
Calyx Software Message Board
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


12»»

Data problem - intermittently populating in...Expand / Collapse
Author
Message
Posted 5/8/2008 7:02:39 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 5/8/2008 10:41:52 AM
Posts: 17, Visits: 91
I'm trying to make a simple report with one of the fields being Subject Property County (Field ID 35). However, when I generate the report, maybe half or more of the entries have a blank field. The other fields populate just fine.

Since the Subject Property County field on the Prospect Information page can be auto-populated, I tried the following:

I chose a file where the county field was empty in the report. I opened the file, clicked on the Zip code field and then tabbed off it, so as to cause the program to auto-populate the county field again (even though it's already populated). I ran the report again, and lo and behold the county field was populated.

Couple questions:

1) Why are some of the county fields populating in the report while others are not?

2) Is there anything that can be done to fill these fields without going into each individual file to "re-auto-populate" them?

Thanks...

(btw, I'm using version 6.0b.)
Post #6605
Posted 5/8/2008 7:37:25 AM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 2:47:53 PM
Posts: 1,178, Visits: 9,204
What if you just open the Point file and save it? do you see the zipcode in the report?  Its possible its not in the file until you open it in Point.

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
Post #6606
Posted 5/8/2008 9:06:10 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 5/8/2008 10:41:52 AM
Posts: 17, Visits: 91
All the information in all the files is complete (they're closed loan files). The problem is that the report is not pulling the county field for some of them.

That's the thing--I'm trying to avoid having to open several hundred files one by one.

I've attached the report in an Excel file. I've deleted all the columns except for Zip and county. As you can see, the Zip (and everything else for that matter) is present for all entries but the county only populates for some.

  Post Attachments 
fieldid35.xls (43 views, 59.00 KB)
Post #6607
Posted 5/8/2008 9:15:26 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 5/8/2008 10:41:52 AM
Posts: 17, Visits: 91
Update: I'm finding a similar problem with Field ID 560 - the checkbox for ARM on page 1 of the 1003. If I add it to the report, the "X" doesn't show up for a lot of ARM loans, even though the box is checked in the file.

Post #6608
Posted 6/12/2008 8:06:39 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 2 days ago @ 1:05:39 PM
Posts: 23, Visits: 58
I'm finding a similar issue with a couple of fields actually. It seems any fields that are "additional" supported fields do not work correctly within the report. The work around is to go in and take out your data, paste it back, then hit save and it will finally show up on the report. This is NOT a good solution though when we are running a report of around a hundred loans. Is there anway to get this to sync up automatically?
Post #6811
Posted 6/12/2008 9:16:43 AM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 2:47:53 PM
Posts: 1,178, Visits: 9,204
Are you using pds?

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
Post #6814
Posted 6/12/2008 9:23:02 AM


Supreme Being

Supreme Being

Group: Moderators
Last Login: 11/15/2008 10:00:24 PM
Posts: 835, Visits: 1,899
What version of Point and PDS do you have?
Have you asked the PDS Administrator to resynchronize all the additional fields in the PDS Admin site?


Bryan
Point Product Manager
Post #6815
Posted 6/12/2008 10:14:55 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 2 days ago @ 1:05:39 PM
Posts: 23, Visits: 58
PDS 6.1
Post #6816
Posted 6/12/2008 1:23:11 PM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 2:47:53 PM
Posts: 1,178, Visits: 9,204
Its probable that a forced sync was not done after adding the additional fields to pds.  This will leave blanks in the new fields until they are edited in Point.  If this is the case you would want to take Bryan's advice a perform a foced file sync over the weekend.

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
Post #6819
Posted 6/12/2008 1:37:47 PM