Merging of existing notepad documents

Ask the Community
1

Hey there . Is it possible to merge multiple notepad documents generated using the notepad template ? if so, is there a way to automate it ?

2

Hi @shay , unfortunately, Notepad does not natively support a way to merge multiple Notepad documents generated from a Notepad template.

You could explore various workarounds such as:

  • Exporting the generated documents as PDF, and stitching these PDFs together outside of Notepad
  • Create another template to generating a single document instead of multiple
3

hi @leons , thanks for the response. i’m currently doing the first one but it being a manual task will take lot of time for multiple set of documents. the second one is not possible as the dynamic row generator has a threshold of displaying upto 100 objects currently

4

Hi Shay, the 100 object generator limit is per generator row. A workaround you can explore is having two separate adjacent generator rows. The first generator can be configured to an object set of the first 100 objects, and the second generator can be configured to an object set of the next X objects.

5

Hey @leons , thanks for the inputs and i even tried this approach but couldn’t figure out the way to configure This would be helpful if there’s a way to dynamically decide the number of row generators to be included like a conditional rendering thing and the way to dynamically configure the input keeping in mind there could be more that 200 rows or let’s say 300.
The idea i had is to write a function that takes an object set as an input and return an array of object sets but the question is do we have a way to configure this dynamically ?

6

I tried exploring and i had an idea of using 3 dynamic row generators but the input to each of them can be the paginated data. when i say paginated data i thought of 2 approaches.

  1. write a function that takes an object set and a batch number as input and perform some sorting and return either 1-100 records or 101-200 and so on based on the batch number but i couldn’t find a way to create an object set from an array.

something like this:

@Function()
    public async generateObjectSet(invoices: ObjectSet<InvoiceForFixedLineItems>, batch: Integer): Promise<ObjectSet<InvoiceForFixedLineItems>> {
        const pageSize = 100; // Number of objects per batch
        const offset = (batch - 1) * pageSize; // Calculate the starting index for the batch

        // Convert the object set to an array
        const invoiceArray = await invoices.allAsync();

        // Order the invoices by a unique property, such as 'rowHash', to ensure consistent pagination
        const orderedInvoices = invoiceArray.sort((a, b) => a.rowHash.localeCompare(b.rowHash));

        // Use array slice method to get the desired page of invoices
        const paginatedInvoices = orderedInvoices.slice(offset, offset + pageSize);
        Objects.create().invoiceForFixedLineItems(paginatedInvoices)
        // Convert the array back to an ObjectSet if needed
        return Objects.create().fromArray(paginatedInvoices);
    }

2)thought of utilising the objectset api with pagination and offset values

if you can help with either of them, it’d be great

7

I think you will want to pre-process the object sets into intermediate objects sets before passing into Notepad. e.g., generator 1 is configured to object_set_1 which contains the first 100 objects, generator 2 is configured to object_set_2 which contains the next 100 objects; etc

8

yes that’s the idea but couldn’t find a valid way of doing