Quote:
It looks like in the process of moving data between your BulkEdit sheet & excel, etc profileid's have been corrupted by excel - removing leading zeros and by rounding exponentializing others . . .

ahhhhhh

I correct a few by hand to verify that that is the issue . . . then start over.

Thanks

Quote:
Hey mediadogg,

Just wanted to let you know that I successfully imported personal (disc,location,slot,collection#) for all of my ~1150 disks last night.

Thank you.

Quote:
This new feature provides for mathematical computations to be peformed on Regex results prior to updating the spreadsheet. In fact, it is possible to write small applications conforming to either Visual Basic or C Sharp syntax, including File IO and XML processing.

To assist in developing logic within your script, a built-in method called RowData has been provided. It will output a string version of the named column, for the particular row that the script is operating on. For example, RowData("Location") yields the value of the Location field within the selected row. The "Location" field must be displayed in the spreadsheet in order for this to work.

RowData("row") returns the index of the current row, as a string, index 1. RowData("rowcount") returns the number of rows in the spreadsheet. This makes it easy to determine when to do startup processing (e.g. read a file into a memory stream), and final processing (e.g. write the stream back out to a file.) The RowData method simply executes a key search on the global variable rowdatalist (SortedList), which your code can also access directly.

UserData("key") returns a string that you have previously stored associated with the value "key". Since Regex Math is re-invoked on each row iteration (ALL or Next), this is a way for your code to save data between iterations. This may save time by eliminating the need to repeatedly open and close files. A file can be opened when row = 1, some data saved and then processed for subsequent rows, then file output can be done when row = rowcount. User data is saved in the SortedList global variable userdatalist, which your code can manipulate directly.

Two work columns ("Work 1" and "Work 2") can be optionally displayed. Data can be copied from other columns and manipulated before copying back into profiles. In addition, the Regex Math function can be optionally made to output to a work column instead of modifying the original column. This is good for testing or for making more complex scripts, as RowData("Work 1") and RowData("Work 2") are both supported.

Two additional items have been added to the context menu (right click) of the Regex Replace box: "Load Math Script" and "Save Math Script." The default extension for CSharp is .cs and for Visual Basic, .vb.

Syntax Notes
To return a value from the script, a "return" statement (C Sharp) or "Return" statement (Visual Basic) must be used. All code statements are case-sensitive in order to take advantage of built-in Microsoft compilers. C Sharp requires each statement of your script to be terminated with ";", while Visual Basic uses the the "end of line" as the default statement end. Comments can be added to scripts using the standard delimiters for C Sharp ("//" ) and Visual Basic (" ' "). Using C Sharp, you must explicitly convert any returned value to "string", e.g. by using the ToString() method.

Quote:
Disclaimers and Limitations
(1) There has been limited testing, although the code and methods have been derived from existing BulkEdit code. There are numerous tests in an attempt to protect against crashes from ill-formed data, but be careful.
(2) "Using" and "Imports" statements have been established with a test Namespace. In some cases, it may still be necessary to fully qualify references to classes used in your code. Attempts to use unsupported class will result in syntax errors. (Note there is a bug in VB Imports, fixed in V2.48).
(3) It is not possible to interactively debug your code inside the Regex box. It is best to debug more complex scripts prior to using them in BulkEdit. I have attempted to cause meaningful error messages, in the case that scripts need to be adjusted in context.
(4) Regex Math works only on simple Text or Combo fields - not numeric (e.g. disc) or Rich Text (e.g. Notes). If regex Math returns a value that is not allowed in the Combo Box drop-down list, the update will be silently bypassed.

Examples - Pay attention to case, and to use of ";" in C Sharp

(1) xyrano: add a fixed number to collection number, and update

Math box checked. Cursor lies in Collection Number column. Visual Basic.  (optional output to Work 1 or Work 2)
Regex Look For:    (\d+).
Regex Replace:    Return ($1 + 15)

Math box checked. Cursor in Collection Number column. C Sharp  (optional output to Work 1 or Work 2)
Regex Look For: (\d+)
Regex Replace:  return ($1 + 15).ToString();

(2) ljckbailey: Reformat Location and Slot, based on modulo scheme

Math box checked. Cursor in Location Column. C Sharp
Regex Look For: D(\d+)
Regex Replace: (There are many alternate ways to do this)

// Look For in Location, using Regex search D(\d+)
// This Math is the Regex Replace
int slot = int.Parse(RowData("Slot"));
double A = 0;
string media = "";  // This needs tweaking to cover case of disc > 1
if (RowData("Blu-Ray") == "true") media = "Blu-Ray";
else if  (RowData("HD") == "true") media = "HD";
else media = "DVD";
if (slot > 99) { A = Math.Ceiling((double)(slot / 4)); }
else {  A = 1 + Math.Ceiling((double)(slot / 4)); }
double B = ( $1 - 1) * 100;
return media +" ~ "+"Page: "+(A + B).ToString()+"  Disk "+(((slot % 4) == 0)?4 : (slot % 4)).ToString();

Known Bugs

- Known bugs fixed V2.50.

Futures
- Consider a way to update other columns within the script
- A way to interrupt hung script
- Loop counter and length to allow the script to perform start / end processing (Done - V2.50)
- Need a way to save global data between row iterations (Done - V2.50)

Quote:
Hi Mediadogg,

I keep getting an error message when I open profiler from your plugin.

" Bulk Edit: Could not load file or assembly 'System, Version=4.0.0.0, Culture=netural, PublikKey Token=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified"

Please help me to resolve the problem is I would like to use your plugin on my ordered list.