 Posted: Thu May 13, 2010 8:53 am |
Points: 0  |
|
| DougCastell |
| GoldMine Guru |
|
 |
| Joined: 15 Jun 2006 |
| Posts: 1639 |
| Location: Los Angeles, CA |
|
|
|
|
|
 |
|
Glad to hear that, Dave. I guess with Raf's bombshell fresh on my mind and everything else I've been busy with lately, your statements got lumped in with Raf's as a, 'Goodbye, thanks for all the fish," kind of thing.
For clarity's sake, are you saying that you plan to continue to update GoldBox indefinitely? The only thing that may be changing is simply the level of free support folks can expect? If that's the case, I think it's easily understandable and, in fact, what people have expected all along. When customers end up getting free support from you, they've always expressed utter amazement and surprise in the past... |
|
|
|
|
 | |  |
| Posted: Thu May 13, 2010 8:58 am |
Points: 0 |
|
| DougCastell |
| GoldMine Guru |
|
|
| Joined: 15 Jun 2006 |
| Posts: 1639 |
| Location: Los Angeles, CA |
|
|
|
|
|
|
|
to get back to the original question.. Given a little more thought, I think you might best achieve this by automating the CSV->DBF conversion. That part could definitely be done by a nightly SQL job and then your GoldBox routine would be able to rune a queue file and perform your import. As for the little tweaks you need to make to the file before handing it to GoldBox, that same SQL job could have a step to take care of it.
So, in the end, I think a hybrid approach, utilizing all the tools at your disposal, would be the most complete solution...  |
|
|
|
|
| | |
| Posted: Thu May 13, 2010 9:08 am |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
| Doug, not to be argumentative, but setting up the conversion of the file via a Q-file is trivial (I'll be explaining that elsewhere). Sure, if someone is comfortable doing it in SQL, that's OK, too. But I know almost nothing about the skills of the person who started this thread, so I'm trying to keep everything in one language, so to speak. |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
| Posted: Thu May 13, 2010 9:09 am |
Points: 0 |
|
| GoldBoxGodfather |
| Experienced Miner |
|
|
| Joined: 07 Sep 2007 |
| Posts: 76 |
| Location: Tinsel Town |
|
|
|
|
|
|
|
| king123 wrote: |
The guy how is helping me with this, says that gbox can't do the import - .csv to .dbf > to goldmine(automatically)
? He says it must xls? I dont have alot of experience with goldmine, please advise.
Thank you |
Hi King -
I think a reversal on what you were told is closer to reality 
GoldBox will NOT import from Excel directly. The reason? Too much variability in that program - it's a kitchen sink. A reliable import needs a very structured, very consistent source of data so that it can be accurately mapped and assimilated into the Target tables (GoldMine's data).
Excel should NEVER BE USED TO TRACK DATA. Which is exactly why everyone does it - we're all seduced by the WYSIWYG nature of Excel. In reality, data is a multi-level, linked type of beast and rarely conforms to straight row/column format. Having stated that: Excel STILL does not excel at data tracking, because - since it is really a giant calculator - it wants to convert everything to numeric values if it possibly can. That's why phone numbers and USA zip codes are mis-formatted in the Extremely Silly Excel Program. For data tracking, that is. For other things, Excel is splendid.
So: GoldBox will auto-convert from anything that can be SQL Queried, True CSV / ASCII formatted text, and SDF text (also called report format).
But NOT a direct convert from Excel. |
|
|
|
|
| | |
| Posted: Thu May 13, 2010 9:24 am |
Points: 0 |
|
| GoldBoxGodfather |
| Experienced Miner |
|
|
| Joined: 07 Sep 2007 |
| Posts: 76 |
| Location: Tinsel Town |
|
|
|
|
|
|
|
| DougCastell wrote: |
Glad to hear that, Dave. I guess with Raf's bombshell fresh on my mind and everything else I've been busy with lately, your statements got lumped in with Raf's as a, 'Goodbye, thanks for all the fish," kind of thing.
For clarity's sake, are you saying that you plan to continue to update GoldBox indefinitely? The only thing that may be changing is simply the level of free support folks can expect? If that's the case, I think it's easily understandable and, in fact, what people have expected all along. When customers end up getting free support from you, they've always expressed utter amazement and surprise in the past... |
You got it, Doug
I've fashioned my 17-year business so that GoldBox support is almost entirely handled by specialists, implementers, VARs, administrators. It's exceedingly handy for me to be available during business hours for the broad-spectrum, basic support and Q&A. it's worked out very well. The big variable nudging that aside currently is that sales aren't enough to guarantee that I'll be available during business hours. It's forcing a change of focus. And I hate it.
I really understand why a lot of software developers drop away completely. Being one, I should It is so difficult to do, so mentally taxing, that if the compensation falls away - it's virtually impossible to continue. |
|
|
|
|
| | |
| Posted: Thu May 13, 2010 9:28 am |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
| king123 wrote: |
The guy how is helping me with this, says that gbox can't do the import - .csv to .dbf > to goldmine(automatically)
? He says it must xls? I dont have alot of experience with goldmine, please advise.
Thank you |
I have answered this already, so I'm not sure that doing it again will help you. Once set up properly, GoldBox CAN do all this, and much more. You haven't even told me which version and build of GoldBox you have, so I cannot get very specific. Here are the basic steps, leaving out the enhancements that I mentioned earlier. I am going to go the "old" route of running everything via a Q-file, though.
1. Using the Convert menu, do a conversion of your original ASCII file. If your first row is fieldnames, check that box. GoldBox will use the fieldnames you give it, UNLESS they are longer than 10 characters. Those will be trucated; you may or may not like the way they look; if not, you can change them after the file has been parsed. This should take about 5 minutes.
2. By default, GoldBox will name the parsed file TXCONVDB.DBF, saving it to GoldBox's root. You can rename it to whatever you want after leaving the conversion utility, as long as the name is no more than 8 alphanumeric characters, plus undercore (first character must be alpha).
3. Save the file to the Template folder I discussed earlier. Then remove all its records. Easiest way is to open the file (File | Open any dBase file | find and select). Open the file; go to the GX Browser Options menu and select Global Delete. Cick the green checkmark on the left to bypass entering a filter (you want to delete ALL records). Proceed to the end of the procedure.
4. Create a Q-file (Automate | Q-file Setup). Give the Q-file a description and an identifier. Then click the Open button with the green check. This will open a blank Q-file. Add the first item:
4a. SYSTEM: Copy a Disk File command (access via the button with the green +, top left. It opens a menu). An interface will appear; select the file in Template and select to copy it to Working. Then...
4b. OPERATION: ASCII / CSV / SDF-Text to dBase Table (access same way as above). A larger interface appears. Select your ASCII file; then the dBase file in Working (you'll need to temporarily copy it there, so you can select it). Ignore the rest of the interface, and select it to close with the green checkmark.
4c. IMPORT / UPDATE: [the name of your import/update setup]. You just need to select, no interface required.
5. You now have a working Q-file that will convert the ASCII file to dBase, then run the Import with the converted dBase file as Source (be sure to make that selection in your import setup).
At this point, you can run it if you like; that will be an option when you hit Exit to get out of the Q-file. Or, you can post back and ask me about launching options. How did you intend to automate the running, anyway? |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
| Posted: Thu May 13, 2010 9:37 am |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
Quote:
| Quote: |
Cool beans, Big Bob.
There are a bazillion ways to say something and perhaps the web statement can appear a bit harsh - but I really wanted no ambiguity.
In reality: GoldBox would have been NOWHERE if the bulk of the support had not been diffused out amongst specialists like yourself and Doug and Paul and others, and the Value Added Resellers.
Hang in there buddy, sorry if I got a bit hot under the collar. |
Hey, we must be getting old. Back in the day, you and I would have made a disagreement like that into something akin to those tornados they've been having in the vicinity of Wicheta. Plenty of thunder and lightening. I think maybe we trust each others' intentions more these days.  |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
| Posted: Fri May 14, 2010 6:15 am |
Points: 0 |
|
| DJ |
| GoldMine Guru |
|
|
| Joined: 29 Jun 2006 |
| Posts: 2055 |
| Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
Kingy:
I'm assuming that you have GoldMine Premium. Why not create a Macro in Excel that uses the Excel Link ability to push data into GoldMine. I haven't tried this with a Macro, but I'll bet you could get this to work. |
|
_________________
DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
| Posted: Fri May 14, 2010 8:22 am |
Points: 0 |
|
| king123 |
| Cuckoo for GoldMine Puffs |
|
|
| Joined: 02 Sep 2009 |
| Posts: 374 |
|
|
|
|
|
|
|
|
Database Engine Error: Incompatible record structures
Any ideas what is that? are the the simbols in csv or formating?
thanks |
|
|
|
|
| | |
| Posted: Fri May 14, 2010 8:28 am |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
I hate to give up after putting so much effort into it, but you are giving me "drive-by" information; not nearly enough to do proper trouble-shooting. You have not told me the version of GoldMine, GoldBox or, with this latest message, how you converted the file (I assume it is now dBase). Were you trying to run the Import/Update setup when the message occurred? If not, what were you doing?
If you are willing to give enough information to be useful, I recommend that you start over in the GoldBox help forum, also on this site. I'll try to help you, but you must be willing to do your part. |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
| Posted: Sat May 15, 2010 4:16 am |
Points: 0 |
|
| DJ |
| GoldMine Guru |
|
|
| Joined: 29 Jun 2006 |
| Posts: 2055 |
| Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
| I agree with Bob here. I have a GoldMine problem. How do I fix it? Step-by-Step detailed instructions are required to give us half a chance at resolving it. |
|
_________________
DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
| Posted: Mon May 17, 2010 9:04 am |
Points: 0 |
|
| king123 |
| Cuckoo for GoldMine Puffs |
|
|
| Joined: 02 Sep 2009 |
| Posts: 374 |
|
|
|
|
|
|
|
|
I apologize my question, I just sent an email to him asking for a more details what is he doing, as far as i know:
- Create a template file for dbf
- Then convert csv to the dbf file based on that template.
- We’re having issue with this convert function “Database Engine Error: Incompatible record structures”.
We are using Gbox 7, GM 8.0.3.
I will try to get more details asap.
I appreciate your help! thanks. |
|
|
|
|
| | |
| Posted: Tue May 18, 2010 8:40 am |
Points: 0 |
|
| king123 |
| Cuckoo for GoldMine Puffs |
|
|
| Joined: 02 Sep 2009 |
| Posts: 374 |
|
|
|
|
|
|
|
|
| BobTaylor wrote: |
| king123 wrote: |
The guy how is helping me with this, says that gbox can't do the import - .csv to .dbf > to goldmine(automatically)
? He says it must xls? I dont have alot of experience with goldmine, please advise.
Thank you |
I have answered this already, so I'm not sure that doing it again will help you. Once set up properly, GoldBox CAN do all this, and much more. You haven't even told me which version and build of GoldBox you have, so I cannot get very specific. Here are the basic steps, leaving out the enhancements that I mentioned earlier. I am going to go the "old" route of running everything via a Q-file, though.
1. Using the Convert menu, do a conversion of your original ASCII file. If your first row is fieldnames, check that box. GoldBox will use the fieldnames you give it, UNLESS they are longer than 10 characters. Those will be trucated; you may or may not like the way they look; if not, you can change them after the file has been parsed. This should take about 5 minutes.
2. By default, GoldBox will name the parsed file TXCONVDB.DBF, saving it to GoldBox's root. You can rename it to whatever you want after leaving the conversion utility, as long as the name is no more than 8 alphanumeric characters, plus undercore (first character must be alpha).
3. Save the file to the Template folder I discussed earlier. Then remove all its records. Easiest way is to open the file (File | Open any dBase file | find and select). Open the file; go to the GX Browser Options menu and select Global Delete. Cick the green checkmark on the left to bypass entering a filter (you want to delete ALL records). Proceed to the end of the procedure.
4. Create a Q-file (Automate | Q-file Setup). Give the Q-file a description and an identifier. Then click the Open button with the green check. This will open a blank Q-file. Add the first item:
4a. SYSTEM: Copy a Disk File command (access via the button with the green +, top left. It opens a menu). An interface will appear; select the file in Template and select to copy it to Working. Then...
4b. OPERATION: ASCII / CSV / SDF-Text to dBase Table (access same way as above). A larger interface appears. Select your ASCII file; then the dBase file in Working (you'll need to temporarily copy it there, so you can select it). Ignore the rest of the interface, and select it to close with the green checkmark.
4c. IMPORT / UPDATE: [the name of your import/update setup]. You just need to select, no interface required.
5. You now have a working Q-file that will convert the ASCII file to dBase, then run the Import with the converted dBase file as Source (be sure to make that selection in your import setup).
At this point, you can run it if you like; that will be an option when you hit Exit to get out of the Q-file. Or, you can post back and ask me about launching options. How did you intend to automate the running, anyway? |
We did everything you described in here, here are some screeshots:
And then o the step 80 i get error:
“Database Engine Error: Incompatible record structures”.
Any ideas?
Thanks[/code] |
|
|
|
|
| | |
| Posted: Tue May 18, 2010 9:35 am |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
It looks to me like you are getting mixed up between 2 different things I've talked about.
The only time you would use a command to delete all the records in a data table (the last item in your Q-file) is when you are creating the empty Template. THAT IS A ONE TIME THING, AND SO WOULD NEVER GO IN A Q-FILE. So, remove that item from the Q-file. I cannot tell what your COPY FILE command, earlier in the file, is intended to do. What it SHOULD do is copy the Template to the Working folder.
And of course, I have no idea what all those BAT files are for, or whether they might have an iimpact on GoldBox's operation. |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| | |
| Posted: Tue May 18, 2010 10:06 am |
Points: 0 |
|
| king123 |
| Cuckoo for GoldMine Puffs |
|
|
| Joined: 02 Sep 2009 |
| Posts: 374 |
|
|
|
|
|
|
|
|
bat files do not impact Goldbox, it just renames the file and logs...
Yes, step 60 copies files from one direction to another(Working Folder), but now - on line 80, we are trying to import data from fsbo.csv to fsboimp.dbf and then we are getting the error. |
|
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin
|
