 Posted: Tue Aug 07, 2012 1:39 pm |
Points: 0  |
|
| BobTaylor |
| GoldBox Guru |
|
 |
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
 |
|
OK, the IGXXXXX.dbf is where all the mapping screen info is stored. So, please open that file with the GXBrowser, and find the field in question. It may or may not be at or near the end of the file,
I'd like for you to highlight that record when you find it, and click the "Display record in Text Editor" button (may look like a scroll), That will produce a display in Notepad. Copy and paste that into a post, please. |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
 | |  |
| Posted: Tue Aug 07, 2012 2:07 pm |
Points: 0 |
|
| TPorter2 |
| Awesome Administrator |
|
|
| Joined: 30 Jun 2006 |
| Posts: 334 |
| Location: Addison, TX |
|
|
|
|
|
|
|
| BobTaylor wrote: |
OK, the IGXXXXX.dbf is where all the mapping screen info is stored. So, please open that file with the GXBrowser, and find the field in question. It may or may not be at or near the end of the file,
I'd like for you to highlight that record when you find it, and click the "Display record in Text Editor" button (may look like a scroll), That will produce a display in Notepad. Copy and paste that into a post, please. |
Got it!
RECORD VIEW FOR: IGASNEW (RECORD 72 OF 122) FIELDS: 20
...1 FIELD_NAME: USERDEF01
...2 FIELD_TYPE: C
...3 FIELD_LEN: 12
...4 FIELD_DEC: 0
...5 DSCRIPTION: Sales YTD
...6 POS_FLD_1: FLD0046
...7 POS_FLD_2:
...8 IMP_SORT: 0
...9 REXPRESS:
..10 UPDEXPRN:
..11 SEPAR01:
..12 LWRITEBACK: FALSE
..13 LUPPER: FALSE
..14 LPROPER: FALSE
..15 LSHIELD: FALSE
..16 LPROTECT: FALSE
..17 LREQUIRED: FALSE
..18 NUIMCODE: C2
..19 FLDCOMMENT:
..20 MISC_USAGE:
(END OF LISTING) Created 08/07/2012 04:09:47 PM
Looks like this is showing the field length of 12.
BTW, in the field mapping of that Import/Update is where I see the 8 character length. |
|
|
|
|
| | |
| Posted: Tue Aug 07, 2012 2:34 pm |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
Yes, it does show 12. About the only thing I can think of (short of making a dummy source file with one record that has a value of length 12 in that field, and see if it comes through) is to do a Cleanse of that table in BR7 and see if it helps. But that might destroy the file instead of fixing it, which is why I had you make those backups.
Use the bottom of the menu option "Open in BR7 Utility"; then the menu option to Cleanse the table. Once that's complete, open your setup again,,,any change?
BTW, what kind if system and version of GX and GM do you have? Oh, and any chance it's a video driver issue (just not refreshing, somehow)? |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
| Posted: Tue Aug 07, 2012 2:49 pm |
Points: 0 |
|
| TPorter2 |
| Awesome Administrator |
|
|
| Joined: 30 Jun 2006 |
| Posts: 334 |
| Location: Addison, TX |
|
|
|
|
|
|
|
| BobTaylor wrote: |
Yes, it does show 12. About the only thing I can think of (short of making a dummy source file with one record that has a value of length 12 in that field, and see if it comes through) is to do a Cleanse of that table in BR7 and see if it helps. But that might destroy the file instead of fixing it, which is why I had you make those backups.
Use the bottom of the menu option "Open in BR7 Utility"; then the menu option to Cleanse the table. Once that's complete, open your setup again,,,any change?
BTW, what kind if system and version of GX and GM do you have? Oh, and any chance it's a video driver issue (just not refreshing, somehow)? |
Goldbox 9 and GM 9.04.28.
I think the problem is in the mapping template. There is an option there to clear the template but I don't know what that will do.
I will try cleanse of the table in the morning when I am sharper.
Thanks again for all of your time and effort on this one, Bob! |
|
|
|
|
| | |
| Posted: Tue Aug 07, 2012 2:56 pm |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
OK. Keep in mind that there is no separate mapping template; what you see as the mapping template is this file, with a few rules applied to it.
I do think that it's not really a problem; that it just appears to be. Maybe that one-record import to prove it would be a good idea. After all, what's really important is what it dioes, not what it looks like  |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
| Posted: Wed Aug 08, 2012 7:07 am |
Points: 0 |
|
| TPorter2 |
| Awesome Administrator |
|
|
| Joined: 30 Jun 2006 |
| Posts: 334 |
| Location: Addison, TX |
|
|
|
|
|
|
|
| BobTaylor wrote: |
OK. Keep in mind that there is no separate mapping template; what you see as the mapping template is this file, with a few rules applied to it.
I do think that it's not really a problem; that it just appears to be. Maybe that one-record import to prove it would be a good idea. After all, what's really important is what it dioes, not what it looks like |
I can try that. I did the table cleanse with no change. |
|
|
|
|
| Posted: Wed Aug 08, 2012 2:11 pm |
Points: 0 |
|
| Paul Laufer |
| GoldBox Guru |
|
|
| Joined: 27 Oct 2008 |
| Posts: 125 |
|
|
|
|
|
|
|
|
This thread has left me royally confused.  |
|
|
|
|
| | |
| Posted: Wed Aug 08, 2012 3:05 pm |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
Sorry, Paul. Looks to me that it had nothing to do with the mapping template; had to do with the way the source dbf file was being created (parsed from an ASCII file). I suggested (off forum) that the source dbf be created via Q-file into a template that had been re-worked to increase the field length (which really was coming out to be 8 characters long).
This is very reminiscent of the problems that can occur involving GoldMine's Forecast Sale Numeric field (Cal table), but hers is not from GoldMine. I don't know whether my suggestion worked or not. |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
| Posted: Thu Aug 09, 2012 8:07 am |
Points: 0 |
|
| TPorter2 |
| Awesome Administrator |
|
|
| Joined: 30 Jun 2006 |
| Posts: 334 |
| Location: Addison, TX |
|
|
|
|
|
|
|
| Paul Laufer wrote: |
| This thread has left me royally confused. |
Sorry to have confused you! Bob and I took this to email and he gave me a great suggestion to explore. I think it will work, Bob, just have to get it done. Thanks! |
|
|
|
|
| Posted: Sat Aug 11, 2012 9:15 am |
Points: 0 |
|
| Paul Laufer |
| GoldBox Guru |
|
|
| Joined: 27 Oct 2008 |
| Posts: 125 |
|
|
|
|
|
|
|
|
| This is the kind of thing where actually looking at it would probably result in a 5 minute fix, but forum threads make it tough on some things to figure out what's going on. |
|
|
|
|
| Posted: Mon Aug 20, 2012 6:50 am |
Points: 0 |
|
| TPorter2 |
| Awesome Administrator |
|
|
| Joined: 30 Jun 2006 |
| Posts: 334 |
| Location: Addison, TX |
|
|
|
|
|
|
|
| Based on the info Bob provided, this has been resolved. Thanks so much, 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 2 of 2
Goto page Previous 1, 2
|
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin
|
