Author Topic: DAO.Recordset [3265] (Read 3792 times)

Vonnie · « **on:** February 17, 2006, 09:21:17 pm »

Hi there --

Before we started using EA, one of our team members had been keeping the Glossary in an Excel spreadsheet. I converted this to CSV and then to an XML file with the intent of importing it as reference data into EA.

However, I keep getting the message" DAO.Recordset [3265] Item not found in this collection." I looked for a log and it has this further message" Context:SQL: Select * from t_glossary"

Does this mean I can't actually import the Glossary?

Any suggestions and pointers would be welcome.

Vonnie

thomaskilian · « **Reply #1 on:** February 19, 2006, 11:02:49 am »

Probably there has been some fuzz when converting around. I'd suggest to go back to cvs and import that format. If all doesn't help there's still the possibility do directly import into EA's database table.

Vonnie · « **Reply #2 on:** February 19, 2006, 11:27:07 pm »

Hey Thomas - -

Thanks for the reply. Actually, that's what I was aiming to do... I may have misinterpreted the instructions but I was kind of hoping to get what we had into the Model Glossary.

I've looked through the Help and the only thing I can find seems to imply I needed to Import Reference Data, which I attempted to do with my XML conversion... Not sure where I've gone wrong... Oh well, I shall soldier on!

Y.

thomaskilian · « **Reply #3 on:** February 19, 2006, 11:33:54 pm »

Try the following: Use Export Reference Data for Glossary (put a few data in before) and compare the formats. XML isn't XML

Paolo F Cantoni · « **Reply #4 on:** February 20, 2006, 12:33:20 am »

Quote

Try the following: Use Export Reference Data for Glossary (put a few data in before) and compare the formats. XML isn't XML

Thomas,

We used to have a famous series of advertisements for Castrol Oil (here in Australia) where the protagonist's (a gangster) closing line was:

"Oils ain't Oils..."

So... maybe it fits...

Paolo

They haven't been on for at least 5 years...

sargasso · « **Reply #5 on:** February 20, 2006, 01:29:35 pm »

Tsk tsk "Oils ain't Oils, Sol..."

Paolo F Cantoni · « **Reply #6 on:** February 20, 2006, 02:45:09 pm »

Quote

Tsk tsk "Oils ain't Oils, Sol..."

I stand erected...

Shame on me!

Paolo

Vonnie · « **Reply #7 on:** February 20, 2006, 08:17:16 pm »

After a frustrating day of trying to figure out what was wrong, I thought, "bugger this - it's probably quicker just to copy and paste from the original document". So I did, and I was right.

Still don't know where I've gone wrong - I will probably twig once I haven't looked at it for a few days and the error will leap out at me...

But on the good side. One project glossary. Hurray!

Y.

Sparx Systems Forum

News: