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!
|
|
Migrating Attachments from SLX 6.2.6 to SLX 7.1 using Scribe
Posted: 02 Jul 07 9:18 AM
|
Hi, everyone.
I need a hand with this. I'm trying to migrate the attachments from one DB to another, and the error I’m getting is that the adapter for SLX don't find the file physically in the HD when try to make the insert. I've configured the Documents path with Administrator to the place where the files are.
I don't know how really the adapter works with this table.
To import the file path I’m using the virtual field named vFilePath.
Note: the connection the source DB is through Native SQL because I have installed SLX 7 and the DB is 6.2
THX |
|
|
| |
|
Re: Migrating Attachments from SLX 6.2.6 to SLX 7.1 using Scribe
Posted: 02 Jul 07 10:13 AM
|
Thanks for the quick reply.
I already move the files to the attachments folder, but scribe still didn't find them. One thing that I notice is that the files seem to have an "ID" included in the name.
Do you know how the virtual fields "vFilePath" works?
THK |
|
|
|
Re: Migrating Attachments from SLX 6.2.6 to SLX 7.1 using Scribe
Posted: 02 Jul 07 10:25 AM
|
| If the files are already there in the proper folder you don't need have Scribe find them. All you need to do is create a script to insert new records into the attachment table. You can use the attachment table in the old database as the source. Does this make sense? |
|
|
| |
|
Re: Migrating Attachments from SLX 6.2.6 to SLX 7.1 using Scribe
Posted: 02 Jul 07 11:34 AM
|
You could do it without Scribe by:
- copy files to attachment folder on new server
- create bundle containing needed records from attachment table on old server (make sure bundle is set to genrate new IDs)
- apply bundle to new server
Questions:
What version of SalesLogix are you running?
Do you have any remotes? |
|
|
| |
|
Re: Migrating Attachments from SLX 6.2.6 to SLX 7.1 using Scribe
Posted: 03 Jul 07 2:57 AM
|
Hi Matias
At a guess, if you are using the old attachment table as the source, you are providing the original path to the file. If Scribe is implemented the same way as we implemented Inaport then it will be looking for the file at the old path so that it can move it to the new library directory.
Have you tried leaving the files in the original directory? Of course, that will only work if the path to the original directory is still valid.
Regards
David Evnas
Inaport - CRM Integration
http://www.inaplex.com |
|
|
| |
| |
| |
|
Re: Migrating Attachments from SLX 6.2.6 to SLX 7.1 using Scribe
Posted: 04 Jul 07 1:02 PM
|
Thanks, both.
I'm trying something different, but I need a little help.
I'm going to inserts the Attachments even with the old ids and then update the SITEKEYS table with the last Attachment ID from the SITEKEYS from the Source.
My problem is that the source is 6.2.6 and the target 7.1. And I can't find the KEYTYPE nor the KEYDESC in the Target DB. And I need that to successfully update the SITEKEYS table.
|
|
|
| |
|
Re: Migrating Attachments from SLX 6.2.6 to SLX 7.1 using Scribe
Posted: 05 Jul 07 3:24 PM
|
Matias , it is not clear to me what your trying to do.
Are you moving attachments from slx db to another? Then do you have all the entityids mapped between these 2 slx systems? Otherwise how are you going to link these attachments to the new entityids? |
|
|
| |
|