| Changing Goldbox Field Length | |
Posted: Tue Apr 10, 2012 7:30 am |
Points: 0 |
|
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 |
|
|
|
|
| | |
Posted: Tue Apr 10, 2012 8:17 pm |
Points: 0 |
|
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. |
|
|
|
| | |
Posted: Wed Apr 11, 2012 6:24 am |
Points: 0 |
|
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! |
|
|
|
|
| | |
Posted: Wed Apr 11, 2012 6:46 am |
Points: 0 |
|
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. |
|
|
|
Posted: Wed Apr 11, 2012 8:42 am |
Points: 0 |
|
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. |
|
|
|
|
Posted: Wed Apr 11, 2012 8:50 am |
Points: 0 |
|
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. |
|
|
|
| | |
Posted: Wed Apr 11, 2012 9:12 am |
Points: 0 |
|
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! |
|
|
|
|
| | |
Posted: Wed Apr 11, 2012 9:40 am |
Points: 0 |
|
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. |
|
|
|
| | |
Posted: Wed Apr 11, 2012 12:24 pm |
Points: 0 |
|
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! |
|
|
|
|
Posted: Wed Apr 11, 2012 12:29 pm |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
That's why I've never done it; I scare easily 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. |
|
|
|
Posted: Wed May 02, 2012 6:36 am |
Points: 0 |
|
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! |
|
|
|
|
Posted: Wed May 02, 2012 6:43 am |
Points: 0 |
|
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. |
|
|
|
Posted: Tue Aug 07, 2012 8:25 am |
Points: 0 |
|
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. |
|
|
|
|
| | |
Posted: Tue Aug 07, 2012 9:47 am |
Points: 0 |
|
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. |
|
|
|
| | |
Posted: Tue Aug 07, 2012 12:53 pm |
Points: 0 |
|
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! |
|
|
|
|
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
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|