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

ContactReview Forum Index
Search found 23 matches

Convert Text Based Date To Date Format For Import Into GM
PostForum: GoldBox   Posted: Fri Oct 25, 2013 5:41 am   Subject: Convert Text Based Date To Date Format For Import Into GM
tt
 
Replies: 8
Views: 12158




Sorry for the confusion. I'll try to clear things up.

Originally when I first posted, I was not aware that the date mask was there to specify what format the source data was in. I though it was the ...

Convert Text Based Date To Date Format For Import Into GM
PostForum: GoldBox   Posted: Thu Oct 24, 2013 7:18 am   Subject: Convert Text Based Date To Date Format For Import Into GM
tt
 
Replies: 8
Views: 12158




Bob, thanks for your response. I tried your suggestion of using the date mask. My character field is in the mm/dd/yyyy format. However, if the month or date only has 1 number then the are formatted as ...

Convert Text Based Date To Date Format For Import Into GM
PostForum: GoldBox   Posted: Tue Oct 15, 2013 10:12 am   Subject: Convert Text Based Date To Date Format For Import Into GM
tt
 
Replies: 8
Views: 12158




I have a file that I need to import into GM. The file to be imported has a field in it that is formatted as a text field but it only contains date values in it which are formatted as 1/1/2010.

I ne ...

Goldmine 9.2 - What do you think?
PostForum: GoldMine 8 - 2019 (Premium Edition)   Posted: Wed Sep 05, 2012 6:17 am   Subject: Goldmine 9.2 - What do you think?
tt
 
Replies: 62
Views: 34253




We upgraded recently from 8.52 to 9.2.0.59. I can honestly say the calls I got about GM crashing have decreased by over 90%. We have some little things we are working on with Front Range, but other th ...

Not Like SQL Statement
PostForum: GoldBox   Posted: Fri Nov 04, 2011 6:56 am   Subject: Not Like SQL Statement
tt
 
Replies: 0
Views: 6436




I'm trying to figure out if if I can accomplish the following in a sql query for a "Replace History" function.

I have a current sql statement that reads as follows and which works perfect ...

Goldbox 9 Error After Update
PostForum: GoldBox   Posted: Fri Nov 04, 2011 6:42 am   Subject: Goldbox 9 Error After Update
tt
 
Replies: 5
Views: 8627




Well I figured out why I was getting the error. I have to admit that I should have caught it earlier and I'm a bit embarrassed that I didn't. But here's what happened in case someone else has this hap ...

Goldbox 9 Error After Update
PostForum: GoldBox   Posted: Wed Nov 02, 2011 7:52 am   Subject: Goldbox 9 Error After Update
tt
 
Replies: 5
Views: 8627




Thanks for the suggestions Bob. I have been in touch with Ticomix and gave them the info above but I haven't heard back from them yet. I'll try adding the file back to the goldbox folder.

Could you ...

Goldbox 9 Error After Update
PostForum: GoldBox   Posted: Tue Nov 01, 2011 1:04 pm   Subject: Goldbox 9 Error After Update
tt
 
Replies: 5
Views: 8627




I recently updated to Goldbox 9 from Goldbox 7 and am getting a Program Alert when one of my Q-Files runs. The error I am getting says:

Databade Engine Error: Table does not exist.
I:\goldbox\lic ...

Edit Q-File Expression
PostForum: GoldBox   Posted: Fri Feb 04, 2011 6:53 am   Subject: Edit Q-File Expression
tt
 
Replies: 6
Views: 8911




Hi Bob,

You are right, I was asking about the 2nd window and your answer cleard up what I was trying to find out. I basically assumed that I was missing something obvious that would allow me to edi ...

Edit Q-File Expression
PostForum: GoldBox   Posted: Thu Feb 03, 2011 12:33 pm   Subject: Edit Q-File Expression
tt
 
Replies: 6
Views: 8911




Sorry if I wasn't clear. What I am trying to do is as follows:

Go to Automate | Q-File Setup then open an existing Q-file. Within that Q-File there is a step to Rename-File. I want to edit the exis ...

Edit Q-File Expression
PostForum: GoldBox   Posted: Thu Feb 03, 2011 11:23 am   Subject: Edit Q-File Expression
tt
 
Replies: 6
Views: 8911




I'm sure this is a silly question but here it goes.

I have a Q-File that renames a file with the Rename-File function. I am trying to change the file path that is already entered to a new one. I c ...

Import Won't Save Source File
PostForum: GoldBox   Posted: Fri Jan 21, 2011 11:44 am   Subject: Import Won't Save Source File
tt
 
Replies: 7
Views: 9711




The Goldbox version taken from the "Help|About" says 2010-B.

The saving of the file is triggered as a {Save-DBF} write back in the import setup and not as a separate step in a Q-file. It ...

Import Won't Save Source File
PostForum: GoldBox   Posted: Fri Jan 21, 2011 10:30 am   Subject: Import Won't Save Source File
tt
 
Replies: 7
Views: 9711




Here's what I've tried so far. I changed the file name to data.dbf and tried to save it with the following expressions:

"h:\data.dbf"
"c:\data.dbf"
"i:\goldbox\data.dbf&q ...

Import Won't Save Source File
PostForum: GoldBox   Posted: Fri Jan 21, 2011 8:40 am   Subject: Import Won't Save Source File
tt
 
Replies: 7
Views: 9711




Thanks for the help. I made a mistake in my typing of the expression here on the board and I actually did have a : (colon) in my expression in Goldbox. I did not have the double quotes. I had StrTran( ...

Import Won't Save Source File
PostForum: GoldBox   Posted: Fri Jan 21, 2011 7:46 am   Subject: Import Won't Save Source File
tt
 
Replies: 7
Views: 9711




I have an import setup that is setup to save the source file after the import. It was working fine and then all of a sudden it stopped writing the file to the disk. The expression for the location to ...
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 7 Hours
  


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