Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldBox » Changing Goldbox Field Length Goto page 1, 2  Next
Post new topic  Reply to topic View previous topic :: View next topic 
Changing Goldbox Field Length
PostPosted: Tue Apr 10, 2012 7:30 am Points: 0 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




I import two fields, one for Sales Last Year and one for Sales YTD through Goldbox. Looking at the fields mapping, the first field is 8 characters long and the second one is 9. So once sales top 100,000.00 the first field get truncated. I have looked at the actual fields in Goldmine and they are both 12 characters long. So how do I tell Goldbox to make the one field longer in the mapping? Thanks.

GM 9.0.2.36
GB 9
View user's profile Send private message

PostPosted: Tue Apr 10, 2012 8:17 pm Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




One of the most puzzling things in GM is the way they handle Sales amounts and quantities, especially when completing a Sale, so that the record moves from the Cal table the Conthist table.

Best thing to do at this point is for you to clearly identifty the fields and tables you are working with. I do suspect, though, that you may find that if you are dealing with the History table, it will be necessary to drop the pennies (with Conthist, the fields change from Numeric Type to Character, I believe). I'd be surprised if this were actually GoldBox's fault.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Wed Apr 11, 2012 6:24 am Points: 0 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




BobTaylor wrote:
One of the most puzzling things in GM is the way they handle Sales amounts and quantities, especially when completing a Sale, so that the record moves from the Cal table the Conthist table.

Best thing to do at this point is for you to clearly identifty the fields and tables you are working with. I do suspect, though, that you may find that if you are dealing with the History table, it will be necessary to drop the pennies (with Conthist, the fields change from Numeric Type to Character, I believe). I'd be surprised if this were actually GoldBox's fault.

Bob,

I am not completing any sales in GM. I am just importing this data from my legacy system. In Goldbox it has identified the field as 8 characters and I want to make it 9 and am not sure how. In GM, these are user defined fields. Thanks!
View user's profile Send private message

PostPosted: Wed Apr 11, 2012 6:46 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




Terry, you are saying that you have a UDF of length 12 in GM (is it a Character field or Numeric?); and that the GoldBox mapping screen has incorrectly read that field as length 8. Am I correct so far?

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Wed Apr 11, 2012 8:42 am Points: 0 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




BobTaylor wrote:
Terry, you are saying that you have a UDF of length 12 in GM (is it a Character field or Numeric?); and that the GoldBox mapping screen has incorrectly read that field as length 8. Am I correct so far?

Yes, Bob. Goldmine says it is a character field with a length of ten. The data size for the field is 12 in the layout.
View user's profile Send private message

PostPosted: Wed Apr 11, 2012 8:50 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




Now I'm really confused. You just told me that the size in GM is 10, and the length in the "layout" (which I guess means the mapping screen) is 12. That doesn't sound like a problem to me.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Wed Apr 11, 2012 9:12 am Points: 0 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




BobTaylor wrote:
Now I'm really confused. You just told me that the size in GM is 10, and the length in the "layout" (which I guess means the mapping screen) is 12. That doesn't sound like a problem to me.


I am sorry. I was talking about the field properties in Goldmine and the layout tab there. That is where I see a length of 12.

In GM field info, I see Character and 10.

In Goldbox mapping, I see length of 8.

I hope that helps!
View user's profile Send private message

PostPosted: Wed Apr 11, 2012 9:40 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




It does. Apparently GoldBox misread the value for lengh on the field. The only times I've seen that happen were when a field length had been changed, and may somehow have left an incorrect value in ContuDef; but that doesn't matter now.

GX is supposed to check all the field lengths of a setup when it opens. I would:

1. Query out the C2 table via GoldBox and use the drop-down to get the table structure. If the Length of the Character field in question is 12, then the problem must be in ContUDef, or maybe its Index.

2. Close GoldBox. Rebuild Contudef through GM; you might even change the field's length to 14 before you do that, just to make sure the length gets changed everywhere.

3. Open the GX Setup and see if it has changed.

If not, you may have to try creating another setup, and see if it gets picked up correctly. If so, you may have to start over, But just before doing that, you may want to try something I've never tried: actually changing the field length on the mapping screen. You'd open the dBase file in the root that has the same name as the Setup using BR7. Let me know if you are going to do that.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Wed Apr 11, 2012 12:24 pm Points: 0 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




That last part is scary, Bob!

I will try your first three steps and report back.

Thank you so much for hanging in with me on a solution to this one!
View user's profile Send private message

PostPosted: Wed Apr 11, 2012 12:29 pm Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




That's why I've never done it; I scare easily Laughing The worst that could happen would be corruption of the setup, and by that point you've probably already lost it anyway.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Wed May 02, 2012 6:36 am Points: 0 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




Update: The field actually is 8 characters long. I was confusing the layout size with the field size. I can increase the field to 9 in Goldmine, remove all of the data, rebuild and then re-import to fix it. Will do that soon. Thanks again, Bob!
View user's profile Send private message

PostPosted: Wed May 02, 2012 6:43 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




Thanks for the feedback; glad you got it sorted out!

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Tue Aug 07, 2012 8:25 am Points: 0 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




BobTaylor wrote:
Thanks for the feedback; glad you got it sorted out!

I had another look and this still isn't right. The field mapping in Goldbox shows the field to have 8 characters. Goldbox hasn't picked up on the fact that field is now 12 characters long. I am afraid I am looking at creating a new import which is scary, because this one is pretty extensive. Will have to see if a new import will pick up the proper field length, or else this is all pointless. Thanks for all your help, Bob. The CONTUDEF has been rebuilt, so it isn't that.
View user's profile Send private message

PostPosted: Tue Aug 07, 2012 9:47 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




OK, I can't account for why this is happening; it really shouldn't. But since it is, I'll discuss a possible hack with you, First, though, I want you to perform GoldBox's routine maintenance, including backup and rebuild.

Then I want you to create a LifeRing file for your setup and store it in a safe place.

Then I want you to do extra backups of these files:

If your import unique identifier is IG12345, then backup IG12345.dbf and IG12345.MDX

Also backup GXSETUP.DBF and GXSETUP.MDX and GXSETUP.DBT

Post back when you have all that done, please.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Tue Aug 07, 2012 12:53 pm Points: 0 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




BobTaylor wrote:
OK, I can't account for why this is happening; it really shouldn't. But since it is, I'll discuss a possible hack with you,

First, though, I want you to perform GoldBox's routine maintenance, including backup and rebuild.

Then I want you to create a LifeRing file for your setup and store it in a safe place.

Then I want you to do extra backups of these files:

If your import unique identifier is IG12345, then backup IG12345.dbf and IG12345.MDX


Also backup GXSETUP.DBF and GXSETUP.MDX and GXSETUP.DBT

Post back when you have all that done, please.


I've put in red text everything that I have done. Thanks, Bob!
View user's profile Send private message

Changing Goldbox Field Length
  ContactReview Forum Index » GoldBox
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 2  
Goto page 1, 2  Next
  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin