[OT] Japanese PDF Translator

Yahoo Archive
1
Does anybody have a recommendation for a good (& free) language
translator for .pdfs? It doesn't come up that often, but is needed
occasionally.



Thank you,



Bruce



[Non-text portions of this message have been removed]
2
I had a consultant from Epicor attend on-site and create some excellant
Crystal Reports forms for me, in a database that we use for training.

I'm now moving the forms over to our production db, however, one of the
forms is using a custom 'Report Data Definition' (the others all use
the standard ones that are allready in Vantage).

Is it possible to extract the custom data definition and then import it
into our production db ? (we use MS SQL 2005 for our db's). I've asked
the cinsultant via e-mail but he's a busy guy so may not get back to me
for a while :(

Thanks.
3
Hi,
Yes you can do it, just have a look to the tables begins by report..
and rpt..

--- In vantage@yahoogroups.com, "clive.1972" <clive.1972@...> wrote:
>
> I had a consultant from Epicor attend on-site and create some
excellant
> Crystal Reports forms for me, in a database that we use for
training.
>
> I'm now moving the forms over to our production db, however, one of
the
> forms is using a custom 'Report Data Definition' (the others all
use
> the standard ones that are allready in Vantage).
>
> Is it possible to extract the custom data definition and then
import it
> into our production db ? (we use MS SQL 2005 for our db's). I've
asked
> the cinsultant via e-mail but he's a busy guy so may not get back
to me
> for a while :(
>
> Thanks.
>
4
Mr. Frederick: Please elaborate - I don't know what you mean.

Thanks,

DaveO

--- In vantage@yahoogroups.com, "frederic.naslis" <fnaslis@...> wrote:
>
> Hi,
> Yes you can do it, just have a look to the tables begins by
report..
> and rpt..
>
> --- In vantage@yahoogroups.com, "clive.1972" <clive.1972@> wrote:
> >
> > I had a consultant from Epicor attend on-site and create some
> excellant
> > Crystal Reports forms for me, in a database that we use for
> training.
> >
> > I'm now moving the forms over to our production db, however, one
of
> the
> > forms is using a custom 'Report Data Definition' (the others all
> use
> > the standard ones that are allready in Vantage).
> >
> > Is it possible to extract the custom data definition and then
> import it
> > into our production db ? (we use MS SQL 2005 for our db's). I've
> asked
> > the cinsultant via e-mail but he's a busy guy so may not get back
> to me
> > for a while :(
> >
> > Thanks.
> >
>
5
Ah, thanks for that.

Looking at the 'report...' tables I see no reference to the custom
data definition anywhere, looking at the 'rpt...' tables each one of
them has multiple rows that do refer to the custom data def.

So ... I just copy the required lines that I've found in the 'rpt...'
tables in one database over to the other ?, is it as simple as that ?.

Thanks :)

--- In vantage@yahoogroups.com, "frederic.naslis" <fnaslis@...> wrote:
>
> Hi,
> Yes you can do it, just have a look to the tables begins by
report..
> and rpt..
>
> --- In vantage@yahoogroups.com, "clive.1972" <clive.1972@> wrote:
> >
> > I had a consultant from Epicor attend on-site and create some
> excellant
> > Crystal Reports forms for me, in a database that we use for
> training.
> >
> > I'm now moving the forms over to our production db, however, one
of
> the
> > forms is using a custom 'Report Data Definition' (the others all
> use
> > the standard ones that are allready in Vantage).
> >
> > Is it possible to extract the custom data definition and then
> import it
> > into our production db ? (we use MS SQL 2005 for our db's). I've
> asked
> > the cinsultant via e-mail but he's a busy guy so may not get back
> to me
> > for a while :(
> >
> > Thanks.
> >
>
6
Hi all,

In fact you got a table named reportstyle for linking report and data
definition and after all datadefinition are managed in tables :
rptcalcfield
rptdatadef
rptexclude
rptlinkfield
rptlinktable
rptliterals
rptrelation
rptrelationfield
rptrule
rptrulecond
rpttable
rptwhereitem

so if you production database doesn't have custom report that are not
set in your test database you can simply copy those tables (don't
forget reportstyle table, indexes and triggers).

if you are not sure you can made queries between those database to
compare it like this :

SELECT
TRAIN.reportid,TRAIN.stylenum,TRAIN.styledescription,TRAIN.rpt
defid,PROD.reportid,PROD.stylenum,PROD.styledescription,PROD.rptdefid
FROM MfgTrain803..reportstyle AS TRAIN
LEFT OUTER JOIN MfgSys803..reportstyle AS PROD ON PROD.reportid =
TRAIN.reportid AND PROD.rptdefid = TRAIN.rptdefid

And after for example you can compare de number of record for a
specific Data Definition (rptdefid) like this :


SELECT
count(*),
(SELECT count(*) FROM MfgSys803..rptcalcfield WHERE rptdefid
= 'ApCheck2')
FROM MfgTrain803..rptcalcfield
WHERE rptdefid = 'ApCheck2'

SELECT
count(*),
(SELECT count(*) FROM MfgSys803..rptlinkfield WHERE rptdefid
= 'ApCheck2')
FROM MfgTrain803..rptlinkfield
WHERE rptdefid = 'ApCheck2'

SELECT
count(*),
(SELECT count(*) FROM MfgSys803..rptlinktable WHERE rptdefid
= 'ApCheck2')
FROM MfgTrain803..rptlinktable
WHERE rptdefid = 'ApCheck2'

SELECT
count(*),
(SELECT count(*) FROM MfgSys803..rptliterals WHERE rptdefid
= 'ApCheck2')
FROM MfgTrain803..rptliterals
WHERE rptdefid = 'ApCheck2'

SELECT
count(*),
(SELECT count(*) FROM MfgSys803..rpttable WHERE rptdefid
= 'ApCheck2')
FROM MfgTrain803..rpttable
WHERE rptdefid = 'ApCheck2'

Hope this Help.


--- In vantage@yahoogroups.com, "clive.1972" <clive.1972@...> wrote:
>
> Ah, thanks for that.
>
> Looking at the 'report...' tables I see no reference to the custom
> data definition anywhere, looking at the 'rpt...' tables each one
of
> them has multiple rows that do refer to the custom data def.
>
> So ... I just copy the required lines that I've found in
the 'rpt...'
> tables in one database over to the other ?, is it as simple as
that ?.
>
> Thanks :)
>
> --- In vantage@yahoogroups.com, "frederic.naslis" <fnaslis@> wrote:
> >
> > Hi,
> > Yes you can do it, just have a look to the tables begins by
> report..
> > and rpt..
> >
> > --- In vantage@yahoogroups.com, "clive.1972" <clive.1972@> wrote:
> > >
> > > I had a consultant from Epicor attend on-site and create some
> > excellant
> > > Crystal Reports forms for me, in a database that we use for
> > training.
> > >
> > > I'm now moving the forms over to our production db, however,
one
> of
> > the
> > > forms is using a custom 'Report Data Definition' (the others
all
> > use
> > > the standard ones that are allready in Vantage).
> > >
> > > Is it possible to extract the custom data definition and then
> > import it
> > > into our production db ? (we use MS SQL 2005 for our db's).
I've
> > asked
> > > the cinsultant via e-mail but he's a busy guy so may not get
back
> > to me
> > > for a while :(
> > >
> > > Thanks.
> > >
> >
>