I have run into a brick wall at 90 mph - At this point I have no
solution for the problem encountered.
The Report Data Definition consists of 12 tables
My customization Imports all but the RptLinkField data.
The adapter GetNewRptLinkField Method takes 5 parameters (fields) the
Unique Primary Index on the table consists of 6 fields - The
underlying AddRow method in the IF takes 6 parameters(fields). When
the Update method checks the data a unique index error is thrown
because it is only checking the first five fields, and the 6th makes
the record unique.
I do not have the SDK available nor the source code to attempt to
resolve the parameter count mismatch between the AD and IF
This may be intentional or an oops, in any event it would require
someone to manually input all the link fields on a 'imported' report
If anyone cares to take this further contact me offlist and I will
send you what I have.
hairless in NY.
solution for the problem encountered.
The Report Data Definition consists of 12 tables
My customization Imports all but the RptLinkField data.
The adapter GetNewRptLinkField Method takes 5 parameters (fields) the
Unique Primary Index on the table consists of 6 fields - The
underlying AddRow method in the IF takes 6 parameters(fields). When
the Update method checks the data a unique index error is thrown
because it is only checking the first five fields, and the 6th makes
the record unique.
I do not have the SDK available nor the source code to attempt to
resolve the parameter count mismatch between the AD and IF
This may be intentional or an oops, in any event it would require
someone to manually input all the link fields on a 'imported' report
If anyone cares to take this further contact me offlist and I will
send you what I have.
hairless in NY.
--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> I have a form customization that exports and imports report data
> definitions about 99% done.
>
> It may not be the most elegant, but I will post in the files
section
> when complete - later tonight or tomorrow...
>
> bw
>
> --- In vantage@yahoogroups.com, Ed Garbowski <egarbowski@> wrote:
> >
> > We are using SQL, and just tested the Report Data Definition
> Export/Import tool and it works just fine for us. It has saved at
> least a day or more of work and report testing time.
> >
> > Thanks,
> > Ed
> >
> >
> > ________________________________
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of randyduly
> > Sent: Thursday, September 25, 2008 1:20 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Saving report data definition changes -
> 803.404b
> >
> >
> > The tool in the forum is for SQL database, not for the Progress
> > database.
> >
> > We have ask Epicor for this enhancement and they are well aware
that
> > there needs to be a tool or utility for saving off the report data
> > defintion. Yes, patches can affect your report data definition
> > because of changes Epicor makes to the database structure.
> >
> > Right now if you ask Epicor about this enhancemnet their answer is
> > that it is available in Epicor 9. Well most of us can't wait till
> > Epicor 9 and most of us will probably wait till other people try
out
> > Epicor 9 for a year before we just on the band wagon.
> >
> > I don't think that Epicor is even thinking about making a utility
> for
> > Vantage 8. That is my 2 cents worth.
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> Ed Garbowski <egarbowski@> wrote:
> > >
> > > There is a tool in this Forum's file section that is supposed to
> > facilitate the export and import of the Report Data Definitions,
but
> > I haven't had a chance to test it yet. If you try it, please share
> > some feedback on the tool and I'll do the same.
> > >
> > > Thanks,
> > > Ed
> > >
> > >
> > > ________________________________
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>]
On
> > Behalf Of Brian Stenglein
> > > Sent: Thursday, September 25, 2008 9:44 AM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Saving report data definition changes -
> > 803.404b
> > >
> > >
> > > As someone who is embarking on the upgrade journey, I'd like to
> ask
> > > for a bit of clarification on this.
> > >
> > > My limited understanding is that the Report Data Definition is
how
> > > you can modify data going to the Crystal Forms like a Sales
> > > Acknowledgement or Job Traveler, is that correct?
> > >
> > > If that is true, then my understanding is that we can save the
> > > changes to the customized Crystal Forms and copy them from one
DB
> to
> > > another, but not the changes to the data we are supplying that
> form.
> > > Is that correct?
> > >
> > > If that is true, then during testing if I build customizations
to
> > > those documents that include changes to the Report Data
Definition
> > > then during the go live weekend I would have to re-create the
> > changes
> > > to the Report Data Definition as they would be missing after I
> > > upgrade by 6.1 DB to 8.03.xxx. Is that correct? Will patches
also
> > > cause problems with these?
> > >
> > > Has anyone asked Epicor if they could provide functionality to
> > export
> > > those and start an enhancement request?
> > >
> > > Thanks,
> > >
> > > Brian Stenglein
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%
> 40yahoogroups.com><mailto:vantage%
> > 40yahoogroups.com>, "Vic Drecchio" <vic.drecchio@>
> > > wrote:
> > > >
> > > > Unfortunately, no way to export like a dashboard, BAQ query
or
> BAQ
> > > > Report. It's horrible when making changes in one environment
to
> a
> > > RDD
> > > > and then you need to duplicate efforts in the other
environment.
> > > >
> > > > I've moved report styles via the back end (SQL) before, but
the
> > > RDD's
> > > > involved too many tables for me to worry about and I had some
> > > oddities
> > > > initially. It was more time consuming to try and
export/import
> my
> > > RDDs
> > > > then to simply re-create them with my thorough documentation.
> > > >
> > > > For us ex-Epicorians on this list, this was a huge PITA during
> > > > implementations. Manasa -- I'm sure you remember.
> > > >
> > > >
> > > >
> > > > Vic Drecchio
> > > > ERP Administrator
> > > >
> > > > TIMCO Aviation Services
> > > > Greensboro, NC
> > > > Email: vic.drecchio@
> > > > Office: 336.668.4410 x3091
> > > > Mobile: 704.530.3092
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com<mailto:vantage%
> 40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com<mailto:vantage%
> 40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
> > > Behalf
> > > > Of Ed Garbowski
> > > > Sent: Tuesday, September 23, 2008 4:52 PM
> > > > To: vantage@yahoogroups.com<mailto:vantage%
> 40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Saving report data definition changes -
> > 803.404b
> > > >
> > > > I've made quite a few changes to a number of Report Data
> > > Definitions and
> > > > to the Report Styles and am searching for a way to save or
> export
> > > the
> > > > changes so they won't be lost in case of a database restore or
> > > Vantage
> > > > upgrade. All of the changes appear to be in a series of SQL
> tables
> > > > beginning with dbo.rpt.... . Is there a recommended way to
> backup
> > > and
> > > > restore these report changes?
> > > > Thanks,
> > > > Ed
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You
> > > must
> > > > have already linked your email address to a yahoo id to enable
> > > access. )
> > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > Builder
> > > > and Crystal Reports and other 'goodies', please goto:
> > > > http://groups.yahoo.com/group/vantage/files/.
> > > > (2) To search through old msg's goto:
> > > > http://groups.yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services
goto:
> > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > >
> > >
> > >
> > > ________________________________
> > > The information contained in this message is intended solely for
> > the individual to whom it is specifically and originally
addressed.
> > This message and its contents may contain confidential or
privileged
> > information. If you are not the intended recipient, you are hereby
> > notified that any disclosure or distribution, or taking any
action
> in
> > reliance on the contents of this information, is strictly
> prohibited.
> > > We have taken precautions to minimize the risk of transmitting
> > software viruses, but we advise you to carry out your own virus
> > checks on any attachment to this message. We cannot accept
liability
> > for any loss or damage caused by software viruses.
> > >
> > > This message (including any attachments) is intended only for
> > > the use of the individual or entity to which it is addressed and
> > > may contain information that is non-public, proprietary,
> > > privileged, confidential, and exempt from disclosure under
> > > applicable law or may constitute as attorney work product.
> > > If you are not the intended recipient, you are hereby notified
> > > that any use, dissemination, distribution, or copying of this
> > > communication is strictly prohibited. If you have received this
> > > communication in error, notify us immediately by telephone and
> > > (i) destroy this message if a facsimile or (ii) delete this
> message
> > > immediately if this is an electronic communication.
> > >
> > > Thank you.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > ________________________________
> > The information contained in this message is intended solely for
> the individual to whom it is specifically and originally addressed.
> This message and its contents may contain confidential or
privileged
> information. If you are not the intended recipient, you are hereby
> notified that any disclosure or distribution, or taking any action
in
> reliance on the contents of this information, is strictly
prohibited.
> > We have taken precautions to minimize the risk of transmitting
> software viruses, but we advise you to carry out your own virus
> checks on any attachment to this message. We cannot accept
liability
> for any loss or damage caused by software viruses.
> >
> > This message (including any attachments) is intended only for
> > the use of the individual or entity to which it is addressed and
> > may contain information that is non-public, proprietary,
> > privileged, confidential, and exempt from disclosure under
> > applicable law or may constitute as attorney work product.
> > If you are not the intended recipient, you are hereby notified
> > that any use, dissemination, distribution, or copying of this
> > communication is strictly prohibited. If you have received this
> > communication in error, notify us immediately by telephone and
> > (i) destroy this message if a facsimile or (ii) delete this
message
> > immediately if this is an electronic communication.
> >
> > Thank you.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>