To register for the forums, please contact your Digital-Clay representative.

How to import from external sources

Community-oriented help and tech-support for the Digital-Clay platform.
Post Reply
NewAspeqt
Posts: 9
Joined: Tue Jun 07, 2011 10:21 am

How to import from external sources

Post by NewAspeqt »

Is it possible to import data into digital clay custom defined tables from Excel source files?
How to do this and how to implement the mapping between the source and the target?
Thanks
ZevToledano
Posts: 722
Joined: Fri Apr 03, 2009 2:29 pm

Re: How to import from external sources

Post by ZevToledano »

Yes. Use the ClayIntegrator client which is installed with the normal install and should be in your start menu. It lets you select a source, and map fields easily to any table.
NewAspeqt
Posts: 9
Joined: Tue Jun 07, 2011 10:21 am

Re: How to import from external sources

Post by NewAspeqt »

By trying to import the excel file, I get the next error: "AddObject2 Unexpected error: (ערך כבר קיים במערכת)"
In the log file the same message is written. The message isn't informative and it's hardly to get the real problem. By trying to add the same record as in excel, manually from digital clay, it works good.
What can cause such an error :?:
ZevToledano
Posts: 722
Joined: Fri Apr 03, 2009 2:29 pm

Re: How to import from external sources

Post by ZevToledano »

Two possibilities:
- You added a unique index to one or more of your fields and your mapped fields don't take care of duplicate values in that field.
- You are running an older alpha version.
Post Reply