Need UCYBDBRR -> to Excel spreadsheet

[Phil Frankford]

Greetings -
Has anyone been able to get UCYBDBRR output to automatically generate a spreadsheet?

Be Well,
Phil Frankford

[Alain Moisy]

Output in csv format is a supported spreadsheet format but not a full Excel spreadsheet. If it is properly associated on the workstation where the file is opened shouldn't be a problem. Except for the encoding that may require a validation from the user if you are using a ; instead of , or other delimiter.

Regards.

Alain

[Phil Frankford]

Great, How do you get UCYBDBRR to generate a CSV formatted output? 
What is the batch option to ask it to output the CSV?
I'm not seeing that as a runtime option.
Be Well,
Phil

Here is what the doc says,

Create Revision Reports

Start the AE DB Revision Report utility from the command line and define the parameters you require, such as the period, or the areas that should to be monitored. Use the following syntax where the order of the parameters does not matter:

UCYBDBRR -B -Cclient [-Farea -Ooutput file-D1start time-D2end time-X -A-IINI file-Llanguage]

Example:

All start time and runtime modifications of client 3 which take place between 1 April 2017, 20:00 (08:00 pm) and 2 April 2017, 06:30 am are output to the file C:\revision\report01.txt.

UCYBDBRR -B -C0003 -FSTART,RUN_MOD -OC:\revision\report01.txt -D120170401200000 -D220170402063000

The parameters -B and -C are required, the rest is optional with default values being used for the non-specified parameters. For a list of all values including their descriptions, see Start Parameters - Utilities.

AEDB Revision Report

This utility creates revision reports. For more information, see AE DB Revision Report.

Syntax

UCYBDBRR [-V[Path and file name]] [-IFile name] [-LLanguage] -B -Cmmmm [-OPath and filename] [-FType1,Type2,...] [-D1yyyymmddhhmmss] [-D2yyyymmddhhmmss] [-A] [-X]

Program: UCYBDBRR.EXE

The following start parameters are available:

• -V
  Prints the Automation Engine version and hotfix number in the following format:

UCYBDBRR version Automation Engine version plus hotfix number

• -VPath and file name
  Prints the Automation Engine version and hotfix number to the specified file in the following format:

UCYBDBRR version Automation Engine version plus hotfix number

• -IPath and file name
  Path and name of the INI file
• -LLanguage
  Language parameter
  Allowed values: D (German, E (English), F (French)

  The language that is specified in the INI file is used if you do not specify this parameter.

• -B
  Batch mode
• -Cmmmm
  Client number for processing
• -OPath and file name
  Path and name of the revision report

Default: The report is stored as UCYBDBRRoutput.txt in the utility folder.

• -FType1,Type2,...
  Handles the required contents of the auditing report. Indicate your preferred content types separated by commas.

Allowed values:

• ACCESS
  Unauthorized access
• CANCEL
  Aborts tasks
• CREATE
  Creates new objects
• DELETE
  Deletes objects
• IMPORT
  Imports objects
• MOVE
  Moves objects
• OBJ_MOD
  Object modifications
• RENAME
  Renames objects
• RESTART
  Restarts tasks
• RESTORE
  Restores objects
• RUN_MOD
  Modifies at runtime
• START
  Starts tasks
• TRNSPRT
  Transports objects
• USER
  Successful user logons and logoffs

The utility outputs all contents to the revision report if you do not use this parameter, or if you use -F*.

• -D1yyyymmddhhmmss
  Start date and time for logging

Default: The selection is not limited by a start time. It is recommended that you specify a start time, as otherwise the Revision Report will be very large.

The time zone of the client is used. If the client does not include a time zone specification, the one of system client 0000 is used. If it does not include a time zone specification, UTC is used.

All modification data is written to the report if the time parameters -D1 and -D2 are not used. The filters -F and -X are taken into account.

• -D2yyyymmddhhmmss
  The end date and the time for logging

Default: Current date and time

The time zone of the client is used. If the client does not include a time zone specification, the one of system client 0 is used. If it does not include a time zone specification, UTC is used.

All modification data is written to the report if the time parameters -D1 and -D2 are not used. The filters -F and -X are taken into account.

• -A
  Archive flags are set when you use this parameter. It is related to the parameter -X.

The start of tasks is retrieved from the statistical records, see start parameter -FSTART. Therefore, the utility cannot set archive flags for these data records.

• -X
  Use this parameter to have only modification entries that have never been output by the utility before written to the report such as entries that do not have archive flags.

Examples

All revision information of client 1 between 01.05 00:00 and the current date are output to a report.

UCYBDBRR -B -C0001 -O/uc4/reports/report01.txt -D120170501000000

All start and restart points between 01.10. 08:00 and 01.10. 12:00 are output in a report.

UCYBDBRR -B -LD -C0100 -FSTART,RESTART -D120171001080000 -D220171001200000

[Tim Quakulinsky]

Hi Phil,

Don't get confused by the .txt extension: The file contains the data in a comma-separate format. Give it a try.

Regards,
Tim

------------------------------
Automation Evangelist
Fiducia & GAD IT AG
---
Mitglied des deutschsprachigen Automic-Anwendervereins FOKUS e.V.
Member of the German speaking Automic user association FOKUS e.V.
------------------------------

[Phil Frankford]

Okay, our UCYBDBRR reports seem to be simple TXT format, NOT to be in CSV format. 
I opened them using notepad, notepad++, and Excel.
We need to generate them in CSV format?  What needs to be done differently?

[Carsten Schmitz]

I have never used it, but according to the documentation it's tab separated:

https://docs.automic.com/documentation/WEBHELP/English/AWA/11.2/AE/11.2/All%20Guides/Content/ucabuw.htm

When you open these files in excel, in most versions of Excel it brings up a Wizard where you can select what the delimeter is. It then imports it much as shown in the documentation.

The wizard coming up may be dependent on the file suffix. Try renaming it to .csv and then opening it in Excel.

[Phil Frankford]

Okay, here's what I found.
1) My UCYBDBRR reports are NOT  CSV formatted files that are natively readable as spreadsheets.
2) My UCYBDBRR reports are generated as TXT formatted files that are delimited by tabs.
3) Excel Legacy import wizard allows these TXT files to create a meaningful spreadsheet, when tab delimited format specified.

It would be very nice if UCYBDBRR could actually generate CSV formatted files that are natively readable as spreadsheets. If anyone knows how to get UCYBDBRR to output CSV formatted files, please let me know.

Best Regards,
Phil

[Carsten Schmitz]

It would be very nice if UCYBDBRR could actually generate CSV formatted files​

I suggest to put this into ideation, it's Broadcom's tool of choice for feature requests.

https://community.broadcom.com/ideation/allideas

Br,