1. GeniusConnect support
  2. Database
  3. Database General
  4. GeniusConnect won't load or store
americo
2006-01-30T18:17:00Z
Hi, i hope you could help me with this problem. GeniusConnect won't load or store. Please take a look at my log file and .ini file below and advice thanks. I have No problems with Calendar db just with contacts db. Many thanks in adv. Americo

======FROM LOG FILE=============
INFO:20060130 17:04:18 Folder: Contacts
INFO:20060130 17:04:18 Connecting to database: genius
INFO:20060130 17:04:18 Connected to database
INFO:20060130 17:04:18 Preparing to load items
INFO:20060130 17:04:18 Loading items
INFO:20060130 17:04:18 Summary:
INFO:20060130 17:04:18 ->Successfully loaded 0 items(0 updated, 0 inserted, 0 unchanged)
INFO:20060130 17:04:18 Disconnecting from database

--

INFO:20060130 17:04:31 Connecting to database: genius
INFO:20060130 17:04:31 Connected to database
WARNING:20060130 17:04:31 No Outlook Items selected
INFO:20060130 17:04:31 Disconnecting from database
INFO:20060130 17:04:31 Disconnected from database

---

INFO:20060130 17:04:33 Folder: Contacts
INFO:20060130 17:04:33 Connecting to database: genius
INFO:20060130 17:04:33 Connected to database
INFO:20060130 17:04:33 Preparing to save items
INFO:20060130 17:04:33 Summary:
INFO:20060130 17:04:33 -> Successfully saved 0 items(0 updated, 0 inserted, 0 unchanged)
INFO:20060130 17:04:33 Disconnecting from database
INFO:20060130 17:04:33 Disconnected from database


INFO:20060130 17:05:10 Connecting to database: genius
INFO:20060130 17:05:10 Connected to database
INFO:20060130 17:05:10 Preparing to save items
ERROR:20060130 17:05:10 Error Item:X X x
ERROR:20060130 17:05:10 23000 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'internal.dbo.Contacts'; column does not allow nulls. INSERT fails.

0
1000 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (515)
INFO:20060130 17:05:11 Summary:
INFO:20060130 17:05:11 -> Successfully saved 0 items(0 updated, 0 inserted, 0 unchanged)
INFO:20060130 17:05:11 Disconnecting from database
INFO:20060130 17:05:11 Disconnected from database

=============END LOG FILE===================

============== .INI FILE EXPORT===============
# Exported settings file of Genius@WORK OutlookConnect
# Comments are allowed on a single line only!

[Fields]
# Format: outlookfield=column,conversion
Body=comments,
Business Fax=fax,
Business Home Page=web,
Business Phone=tel,
Categories=category,
Company (Name)=company,
Email=email,
First Name=firstname,
Job Title=position,
Last Name=lastname,
Mobile Phone=mobile,
Title=title,
CreationTime=posted,
MailingAddress=address1,
MailingAddressCity=address3,
MailingAddressPostalCode=password,
MailingAddressStreet=address2,

[PrimaryKeys]
# Format: column=newstatement
rowguid=select newid()

[MandatoryKeys]
# Format: column=newstatement

[WhereFilter]
# Format: WHERE=statement
WHERE=

[FolderOptions]
# Format: OPTIONS=X,X,X. 0 or 1 values slash for advanced options in format:NOPRIVATE,NOOUTLOOKUPDATE,NODBUPDATE,,,DELOUTLOOK_ITEM,DELDB_RECORD,BLOCKDELETECONFIRM,DBTIMEOUT,BLOCKDB_DELETECONFIRM\USE_LASTMODIFICATION_TIME,CONFLICT_RESOLUTION
OPTIONS=1,0,0,,,0,0,0,30,0,0,0,1
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2006-01-30T18:35:00Z
Hi,

'ERROR:20060130 17:05:10 23000 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'internal.dbo.Contacts'; column does not allow nulls. INSERT fails.'

You have a mandatory column 'id' in your table, please assign a value to it in Mandatory/Primary keys dialog.
The SQL value depends on type of your 'id' column .

Example:
Column,Type, SQL Statement
Id,Mandatory,select ....
americo
2006-01-31T11:34:00Z
Hi, Many thanks for that.
I've tried this; please take a look at my log and advice. Cheers.

DB FIELd | TYPE | SQL statement |
id |Mandatory| select newid()|
rowguid |Primary | select newid()|

WHEN TRYING TO STORE, I GET THE FOLLOWING RESULT;
INFO:20060131 10:19:36 Connecting to database: genius
INFO:20060131 10:19:37 Connected to database
ERROR:20060131 10:19:37 37000 [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'BFC6BD5C' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names
are not permitted. (128)
INFO:20060131 10:19:37 Disconnecting from database
INFO:20060131 10:19:37 Disconnected from database
---
INFO:20060131 10:20:03 Folder: Contacts
INFO:20060131 10:20:03 Connecting to database: genius
INFO:20060131 10:20:03 Connected to database
INFO:20060131 10:20:03 Preparing to save items
ERROR:20060131 10:20:03 Error Item:X X X X
ERROR:20060131 10:20:03 37000 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'D802C27'. (170)
INFO:20060131 10:20:03 Summary:
INFO:20060131 10:20:03 -> Successfully saved 0 items(0 updated, 0 inserted, 0 unchanged)
INFO:20060131 10:20:03 Disconnecting from database
INFO:20060131 10:20:03 Disconnected from database

WHEN TRYING TO LOAD, GET THE THE FOLLOWING RESULT;
--
INFO:20060131 10:18:50 Folder: Contacts
INFO:20060131 10:18:50 Connecting to database: genius
INFO:20060131 10:18:50 Connected to database
INFO:20060131 10:18:51 Preparing to load items
INFO:20060131 10:18:51 Loading items
INFO:20060131 10:18:51 Summary:
INFO:20060131 10:18:51 ->Successfully loaded 0 items(0 updated, 0 inserted, 0 unchanged)
INFO:20060131 10:18:51 Disconnecting from database
INFO:20060131 10:18:51 Disconnected from database

--
Any ideas?
Administrator
2006-01-31T11:56:00Z
What is the datatype of the column 'Id'?
americo
2006-01-31T12:48:00Z
id field is the table's primary key

DB SQL TABLE SETTINGS FOR BOTH COLUMN ARE AS FOLLOW:

Column Name | Data Type | Length | Allow Nulls |
id | int | 4 | NO | (Primary Key)
rowuid | uniqueidentifier | 16 | YES |

RESET TO THIS, PLS SEE RESULTS BELOW

DB FIELd | TYPE | SQL statement |
id |Primary| select newid()|
rowguid | Mandatory | select newid()|

NEW LOG RESULTS
LOADING...
INFO:20060131 11:40:41 Connected to database
INFO:20060131 11:40:41 Preparing to load items
INFO:20060131 11:40:42 Loading items
INFO:20060131 11:40:42 Summary:
INFO:20060131 11:40:42 ->Successfully loaded 0 items(0 updated, 0 inserted, 0 unchanged)
INFO:20060131 11:40:42 Disconnecting from database
INFO:20060131 11:40:42 Disconnected from database
STORING...
INFO:20060131 11:40:52 Connecting to database: genius
INFO:20060131 11:40:52 Connected to database
INFO:20060131 11:40:52 Preparing to save items
ERROR:20060131 11:40:52 37000 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'select'. (170)
WARNING:20060131 11:40:52 The following item will be inserted without primary key value(s)!:X X X X
ERROR:20060131 11:40:52 Error Item:X X X X
ERROR:20060131 11:40:52 23000 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'rowguid', table 'internal.dbo.Contacts'; column does not allow nulls. INSERT fail
s.

01000 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (515)
INFO:20060131 11:40:52 Summary:
INFO:20060131 11:40:52 -> Successfully saved 0 items(0 updated, 0 inserted, 0 unchanged)
INFO:20060131 11:40:52 Disconnecting from database
INFO:20060131 11:40:52 Disconnected from database
americo
2006-01-31T17:46:00Z
Hi, Tried on another SQL server and the results are as follow;

On loading...
INFO:20060131 16:37:55 Folder: Contacts
INFO:20060131 16:37:55 Connecting to database: contacts
INFO:20060131 16:37:55 Connected to database
INFO:20060131 16:37:55 Preparing to load items
INFO:20060131 16:37:55 Loading items
INFO:20060131 16:37:55 Summary:
INFO:20060131 16:37:55 ->Successfully loaded 0 items(0 updated, 0 inserted, 0 unchanged)
INFO:20060131 16:37:55 Disconnecting from database
INFO:20060131 16:37:55 Disconnected from database
--
INFO:20060131 16:38:02 Folder: Contacts
INFO:20060131 16:38:02 Connecting to database: contacts
INFO:20060131 16:38:02 Connected to database
WARNING:20060131 16:38:02 No Outlook Items selected
INFO:20060131 16:38:02 Disconnecting from database
INFO:20060131 16:38:02 Disconnected from database

On storing...

INFO:20060131 16:39:46 Folder: Contacts
INFO:20060131 16:39:46 Connecting to database: contacts
INFO:20060131 16:39:46 Connected to database
ERROR:20060131 16:39:46 37000 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'DAF'.

37000 [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. (17
0)
INFO:20060131 16:39:46 Disconnecting from database
INFO:20060131 16:39:46 Disconnected from database
Administrator
2006-02-01T10:47:00Z
Hi,

you can't use newid() function for a integer column!
newid will return a GUID not an integer value!

Please use some othe SQL Statement like select max(id)+1 from .....
americo
2006-02-01T11:55:00Z
Thanks. Storing seems to work but loading doesn't. Below are my new settings and log results.

MANDATORY KEY SETTINGS
DB Field | Type | SQL statement
id | Primary | select max(id)+1 from contacts
rowguid | Mandatory | select newid()

STORING RESULTS:
INFO:20060201 10:47:14 Folder: Contacts
INFO:20060201 10:47:14 Connecting to database: contacts
INFO:20060201 10:47:14 Connected to database
INFO:20060201 10:47:15 Successfully inserted: Americo Do Rosario

---

LOADING RESULTS:
INFO:20060201 10:46:22 Connecting to database: contacts
INFO:20060201 10:46:22 Connected to database
WARNING:20060201 10:46:22 No Outlook Items selected
INFO:20060201 10:46:22 Disconnecting from database
INFO:20060201 10:46:22 Disconnected from database

#nothing is being loaded.
Administrator
2006-02-01T12:00:00Z
If you hit Load "Item" button, only the selected item (Contact, Task etc) will be loaded (if exists in the database).

"WARNING:20060201 10:46:22 No Outlook Items selected"
this means no item has been selected.

Try to use "Load All", Load All works on Folder level, you don't have to select anything.
americo
2006-02-01T12:31:00Z
Tried "Load All" same result. please analyze the log and advice. Thanx.

INFO:20060201 11:27:27 Connected to database
INFO:20060201 11:27:27 Preparing to load items
INFO:20060201 11:27:27 Loading items
INFO:20060201 11:27:27 Summary:
INFO:20060201 11:27:27 ->Successfully loaded 0 items(0 updated, 0 inserted, 0 unchanged)

Administrator
2006-02-01T12:46:00Z
can you send us your table creation script, we will check your setup.
americo
2006-02-01T15:08:00Z
I just like to point out that it worked before when i first tested it in October or November.


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Contacts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Contacts]
GO

CREATE TABLE [dbo].[Contacts] (
	🆔 [int] NOT NULL ,
	[parentid] [int] NULL ,
	[network] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[category] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[subcategory] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[atype] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[invoice] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[company] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[agencyclient] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[ref] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[status] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[staff] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[award] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ,
	[position] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[title] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[firstname] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[lastname] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	📧 [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ,
	[tel] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[mobile] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	📠 [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[address1] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[address2] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[address3] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[city] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[postcode] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[country] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[cardtype] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[cardnumber] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[securitycode] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[cardstartmonth] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[cardstartyear] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[cardexpirymonth] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[cardexpiryyear] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[cardissuenumber] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[password] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[web] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	💺 [int] NULL ,
	[booking] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	🎟 [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[posted] [datetime] NULL ,
	[action] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[credit] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[discount] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[comments] [ntext] COLLATE Latin1_General_CI_AS NULL ,
	[rowguid]  uniqueidentifier ROWGUIDCOL  NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Administrator
2006-02-01T15:23:00Z
Hi,

Please download latest version (3.0.0.3 or higher):
http://www.geniusconnect...es/GeniusConnect/2/3/53/ 


We have fixed a bug related to the ntext datatype, and you are using it in column "comments".

Please open the Assign Table dialog after install and close it using OK (to refresh the datatypes).

Please let me know if the problem is fixed.
americo
2006-02-01T17:17:00Z
Many thanks for your help - it's working now.
 Atom Feed Rss Feed
Similar Topics
  1. GeniusConnect support
  2. Database
  3. Database General
  4. GeniusConnect won't load or store