Manually creating lists in OCM

[Dale]

Hi guys,

After looking at length through the dep and ref guide, i found a few lines on importing on a .hmtl file, though it didnt go much further than "Click File->Import".

Im trying to create a list from Excel, to put via OCM into my dialler.

The last few hours trial and error, (and interrogating exported lists to get an idea of formats), have led me to thinking that you need a pipe delimited file in a 'field=value' format.

Ive taken an exported file (which i randomly imported into a spare campaign and it worked), text to columns around the pipes, then split them up again  between the '=' sign.

I then built it back together, coupling the field,=,and value, and saved it as tab delimited.
I then opened it in Word and replaced tabs for pipes.

Went into OCM, Import, from OCM v7.x.

The egg timer went a bit, and nothing came up (dialling filters all off).

Are there any basic guides on what to do? Any blazingly obvious mistakes here?

Thanks,

Dale

[cavagnaro]

On your OCM installation folder check for the .rej files and take a look at them

[Steve]

You definitely do need a pipe delimited file with field=value.

For this type of issue it is worth trying to import a list with a single row, once that works move on to multiple rows. Make sure you have values wherever the data is set to "not null" and that values are in the right format, numbers where numbers are specified and dates in the right format for your database.

[Dale]

Thanks Steve, i was doing exactly that, a file with 1 row.

Cavagnaro, i dont think i have access to where youre pointing me. Could you be more specific so i can look into it?

[cavagnaro]

If you installed your OCM on C:\GCTI\OCM on this folder you will find some .rej files

[Dale]

On my local machine, thats great, thanks.
Ive found them, opened in Excel.

Error: -

DBServer returned SQL error ORA-00917: missing comma

Where should this comma be? I thought there were no comma's, as we were using this format: -

field=value|field=value|field=value...etc etc

[Steve]

Although you send the data to OCM/OCS in pipe delimited format, it is converted into a standard Oracle insert statement to be sent to the database.

You need to find the sql insert statement in your DB-Server or OCS log and look what is wrong. Copy the code and try it in SQLPlus.

Something to look at is how you have ended the line in the pipe delimited file, if you have got carrage return + line feed, try a UNIX style line feed only, or vice versa.

[Dale]

Thanks Steve,

I've just managed to get it in 

It seems I had to specify a value in the chain_id and chain_n field (i was previously leaving blank). The manual process of converting from .xls to tab del .txt worked fine (replacing tabs by pipes in Word).

Im going to go get the live data now, and see if that works ok!

Thanks all for your help, its much appreciated

[Dale]

Ok, the import of live data wasnt 100% successful.

on the .rej file on my C:\ it says

Total records : 45355
Records processed: 45355
Records rejected on input: 398
Records rejected by database: 41559

I have  41559 lines of the 'DBServer returned SQL error ORA-00917: missing comma' error.

I dont have access to the OCS logs so ill have to pull some favours in.

thanks