slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - SalesLogix Imports
Forum to discuss general SalesLogix import and data migration topics. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Imports | New Thread

View: Search:

Author

Thread: Scribe Table ID

Ian Fitzpatrick
Posts: 146

Scribe Table ID Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Jul 08 3:54 PM

I am running an Import from a SQL databes into my SalesLogix database (v7.0.1) using Scribe 6.1. I am running an Update/Insert statement. The Update works fine, but the Insert is failing and the reason is "Null value was provided for a required field : [tablename]id" where [tablename] is the name of my table.

From searching IT toolbox and SLX Developer it appears that Scribe should be creating the table ID for me automatically if I leave it out of the import map (which I have done). Does anyone know why this might not be working? I have checked the Autoincrement field in Sectabledefs and marked that to 'T'.

Also this is a database that I upgraded from v5.2, just in case that matters.

[Reply][Quote]

Todd Dickinson
Posts: 4

Re: Scribe Table ID Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Jul 08 9:10 AM

I've seen some odd behavior like this with Scribe. I found the that if I split my Update/Insert into multiple steps, I can make it work.
Start with a Seek and then Update if something is found, Insert if nothing found. You can just copy your all your data links from one step to another.
Surprisingly, using a Seek+Update+Insert has better performance that an Update/Insert, according to the performance tips from Scribe.

Good Luck,
TjD

[Reply][Quote]

Ian Fitzpatrick
Posts: 146

Re: Scribe Table ID Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Jul 08 11:40 AM

Thanks Todd. I never realized that a seek would be faster than an Update/Insert, I've got some changes to make!

Changing this particular map didn't work for me but I think the reason is that this table was created in SQL and not in the Administrator, so I'm going to have to recreate the table and then re-run the map.

Thanks for your help.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 3:11:56 PM