Messages

1

Help for ParamQuery Pro / Re: Handling of quotes in ParamQuery Pro 4.0.2

« on: November 20, 2017, 07:28:26 pm »

Sorry if I wasn't clear about that. Yes, the patch worked perfectly for the issue with quotes.

2

Help for ParamQuery Pro / Re: Handling of quotes in ParamQuery Pro 4.0.2

« on: November 17, 2017, 09:28:03 pm »

Thanks for the quick response!

This works great for single-line fields, but when I copy-and-paste fields containing newlines, PQ always sees them as changes - even if I copy a single field and paste it into itself, which means a lot of unnecessary writing to the database.

Should we be standardising on a specific convention for newlines so it matches what PQ uses? "\r\n", "\r", "\n"?

3

Help for ParamQuery Pro / Handling of quotes in ParamQuery Pro 4.0.2

« on: November 16, 2017, 12:25:15 am »

 Great job fixing copy and paste of newlines within cells!

Unfortunately, we still have an issue that's proving difficult to work around.

Using ParamQuery Pro 4.0.2:

We have a table that contains single line values with quotes in them, ie:

  1"x2" Sealed  Lamp Kit with Base Mount and Pigtail

When we copy these values from ParamQuery, then paste them into another ParamQuery grid, what's in the ui.rows array in our beforePaste function is:

0:["1x2 Sealed  Lamp Kit with Base Mount and Pigtail"]

The quotes are gone.

Also, when pasting thousands of cells, multiple rows get combined.

For instance, when pasting a single column copied from an identical grid, 4484 rows becomes 4134 rows, with some cells containing values that belong in several other rows.

When pasted into a text editor, the data in the clipboard looks identical to what's in the grid, with one line per value, quotes preserved as-is, but when it's pasted into PQ the quotes are gone and lines are concatenated.

Any idea of a fix?

ParamQuery has become an important part of our development cycle for WordPress, one that we're committed to developing solutions around. We're already using it behind-the-scenes for development and data migration. Overall, it's superior to most of the grid editors on the market today.

This is the one remaining issue that prevents us from presenting it to clients as a bulk editing tool for a variety of other use-cases in WordPress.

Thanks in advance!

4

Bug Report / Pasting Cells with newlines

« on: November 06, 2017, 06:23:50 pm »

Hi There

We seem to have bumped into a bug in ParamQuery Pro 4.01. We are loading data into a column (data is a free form product description field) that contains newlines. The purpose for this grid is to provide a bulk product editing tool with a review and approval system so our client can track changes to copy, product specs etc.

We have discovered that when copying and pasting data from any column that contains cells with newlines from one ParamQuery Grid to another ParamQuery Grid, the newlines are being interpreted as new rows as opposed to a single cell with multiple strings with newlines.

We noted this post https://paramquery.com/forum/index.php?topic=2382.msg9297#msg9297 that seems to imply the problem related to imports is being addressed, it the same being addressed for copy/pastes as well?

Any idea of the ETA?

If this is a work in process (understandable), do you have any recommendation that we could use to work around the problem in the meantime?

We are also finding newlines/carriage returns in cell data are erroneously triggering "changes" even if data is not edited (The editor is instantiated but no change is made)

Any advice/guidance you could provide would be greatly appreciated

Regards

5

Help for ParamQuery Pro / Re: pasteModel for appending/replacing data

« on: September 15, 2017, 11:35:18 pm »

Nevermind. Figured it out from documentation. Thanks.

     *  //Format of JSON object returned by 'getChanges' method is as follows:
     *  {
     *      updateList: [row1, row2..]
     *      addList: [row1, row2..]
     *      deleteList: [row1, row2..]
     *  }

6

Help for ParamQuery Pro / pasteModel for appending/replacing data

« on: September 15, 2017, 05:54:37 pm »

Hi folks,

I'm trying to create a paged grid that provides a blank row at the bottom of the last page.

The blank row should allow users to paste multiple rows, and append new rows to the data.

The grid should also allow users to update data in existing rows if they are pasted into.

The data gets updated for existing rows, but when I paste in new rows, they show up on-screen without being added to the data or changes array.

Any ideas?

I'm using a simple pasteModel:

Code: [Select]

var pasteModel = {
            on: true
        };