Messages

76

MP Server / arssockd-CMOD_DBP1: license (Cur(15), Max(10))

« on: September 16, 2013, 10:02:08 AM »

arssockd-CMOD_DBP1: license (Cur(15), Max(10))

Hi

If I see this, does it mean that 5 users will be in wait list until the current user count comes down below 10?

Thanks
Pankaj.

77

Report Indexing / Re: Automated process to create generic index for Excel file and load report

« on: August 22, 2013, 03:15:10 AM »

In our case we receive a separate file with the metadata from the source systems.
But in your case you can easily extract the metadata from the file name using shell script.

78

MP Server / Re: Overlay in OnDemand

« on: August 22, 2013, 03:13:43 AM »

Hi

The thick client is a local installation on your desktop.
Unless you do the font mapping certain characters for which the fonts are not available in the font directory on your desktop would be defaulted to some font.
When you use ODWEK, the transformation happens at the server end where all the font and overlay mapping is proper.
So you get a good document via ODWEK.

79

MP Server / arsdate

« on: August 21, 2013, 11:56:40 AM »

i have the following query which runs perfectly fine, meaning it gives me some results.
what does arsdate -1 imply?

arsdoc query -v -h ORSAPOH1-PHYS -u admin -p ondemand -f 'System Load' -i "where input_filename like '%%' and load_time between -1 and 1376989200"

80

Report Indexing / Re: Automated process to create generic index for Excel file and load report

« on: August 20, 2013, 07:18:35 AM »

We do similar stuff.
In our case we wrote either a java program or a shell script to generate the IND and calles arsload from the script.

81

MP Server / Re: Line data Indexer

« on: August 20, 2013, 07:12:18 AM »

I don't think this is possible out of the box.

82

WEBI interface / Re: Adding additional servers in WEBi

« on: August 20, 2013, 07:11:00 AM »

Hey could you tell me what xml has to be changed, and a sample entry.

83

WEBI interface / Re: Adding additional servers in WEBi

« on: August 12, 2013, 12:27:34 PM »

No. I have different servers with different CMOD installations.
Meaning I have multiple library servers.
I want to access all these servers through one WEBi.

84

OD/WEK & JAVA API / Re: Pagination

« on: August 09, 2013, 09:24:57 AM »

Thanks Egon.
These are AFPs with TLEs, soI really don't have that option.

85

Presentations, Newsletters, and such / Re: Free workshop offered by IBM

« on: August 09, 2013, 09:22:31 AM »

It would be great if there could be a workshop in New York!!

86

Report Indexing / Re: Export the indexed data into the database

« on: August 09, 2013, 09:19:04 AM »

Alessandro alredy posted this.

arsload -h CMOD_instance -u username -p password -nvf -g applicationgroupname -a application file_to_be_loaded

What server is your CMOD installed on? AIX/Windows??

87

Report Indexing / Re: PDF Indexer issue

« on: August 09, 2013, 09:16:18 AM »

Here is what I would suggest.
From what I understand you have PDFs from two sources.
For one source, they load successfully but for the other they fail to load.

1. Take one sample PDF from each source.
2. Run arspdump on both the files. Ref. - http://publib.boulder.ibm.com/infocenter/cmod/v8r3m0/index.jsp?topic=%2Fcom.ibm.ondemand.mp.doc%2Fars1d171399.htm
3. Then open the output of the arspdump and search for the Trigger, Field, etc that you defined using the graphical indexer.
4. Compare the UL, LR that you get with the values below.

I suppose that for the files that load successfully, these values will match.
Whereas for the other it would not.

 TRIGGER1=UL(0.15,10.53),LR(0.42,11.49),*,'TOPAS-BEL-MET'
 FIELD1=UL(0.29,9.34),LR(0.53,9.72),0,(TRIGGER=1,BASE=0)
 FIELD2=UL(0.43,9.31),LR(0.67,9.68),0,(TRIGGER=1,BASE=0)
 FIELD3=UL(0.86,9.15),LR(1.15,9.68),0,(TRIGGER=1,BASE=0)
 FIELD4=UL(1.17,8.92),LR(1.42,9.67),0,(TRIGGER=1,BASE=0)


It may also happen that due to the modification being done in the PDFs, the TRIGGERS and FIELD coordinates are getting off than the original.
It could also happen that there is additional string in the box that has TRIGGER or the fields.
I have been through similar issue where we were using iText to modify the PDFs to insert hidden triggers, etc.

So you may end up creating a separate CMOD Application for one set of PDFs and another for the set that fials to load. Offcourse with different coordinates.

Hope this helps.

Cheers
Pankaj.

88

WEBI interface / Adding additional servers in WEBi

« on: August 09, 2013, 09:03:33 AM »

Hi

On the WEBi login screen there's an option to select the server name from drop down.
I want to add additional servers for the users to select from.
How can this be done?

Thanks
Pankaj.

89

OD/WEK & JAVA API / Re: Pagination

« on: August 02, 2013, 09:08:00 AM »

These are actually daily trade confirmations. We have some accounts whose trades for a given day exceed 2000 pages.

So I think we will have to convert the big files into PDF and load them.
I need to figure out how this could be done. But it seems like this is the only solution.

However, when you say "you could retrieve and convert the last X months of data in advance, and cache it for 24h or so"; I am not sure how to do this.
Any pointers?

90

MP Server / Re: NULL dates

« on: July 31, 2013, 06:58:18 AM »

Alessandro

I didn't get your point when you said

if you want NULL dates, then the only way is either use string field, OR if you want to keep the date field, then to define that a NULL date is 01.01.1970 (CMOD < V9.0) or 01.01.01 / 31.12.9999 (CMOD V9+).

Does this mean, i need to write some extra logic or probably use the default in Application and put the default date as 01.01.1970 (CMOD < V9.0) whenever I encounter a blank or invalid date in data?