Proto Software

Hi Byron/Esan,

I am having a problem appending two datasets, one from excel and one from a database, the one from database is the total cumulative file and the one from excel is the new file.

if i try to merge two files and if both of them are either from excel or from database then it works, else its not.... it saying entryset schema doesn't match.....everything else looks fine to me....

Please have a look!

Thanks
Kamal

Attached File

Append sets.proto

669 KB

Hey Kamal

Append Entryset, currently does its validation check on Attribute Name as well as type.

For performance reasons the attributes coming out of a pdb are always strongly typed. ( If you open the "Total Database" table you'll see the assigned type column is "Any Text", while the "Preview New Trustee Report" has attributes with type "Any")

Unfortunately there's no easy way in this version of proto to re-cast attribute types without using the VBA module. I've attached an updated version that uses the vba module to convert the attributes from the database to type "Any"
(See "Table 5")

Let me know if you have any more questions or issues

Thanks
-Esan

Attached File

Append_sets_v1.1.proto

734.2 KB

Hi Esan,

your vba tool does the job, thanks a lot, however i have around 10000 rows of data, after the vba module u input the data in a new table, so i have around three tables with 30000 rows of data in all (including the new table)....this is slowing proto a lot on my comp....can u suggest something for this...

another thing that i am thinking is that i need a trigger (a button i would say) to input data in a table, do u have a custom module for that or something else......

thanks
Kamal

Kamal - can you give me a little context as to how the data is being used in Proto?

The reason I ask is that I've seen people use a CSV before for a couple hundred thousand rows to store them, but then they only need to process / use a few thousand at a time in Proto. In that case, they used the ODBC module to hit the CSV with SQL queries that were actually built with the Formula in Proto.

For example:
"Select Date, Vol from Volgrids where expiry='" + expirey + "' AND tenor = '" + tenor + "'"

then the expiry/tenor is set via listboxes and the Query is refresh. Make sense?

Beyond that, currently in our dev pipeline is native PDB filtering so that, for example, you could do the above type queries on a Proto DB versus reading the whole dataset into memory and then using the Entryset Filter.

let me know if this generates any thoughts/ ideas and then we can work it out.

On your second question I'm not totally sure I gather what you're trying to do w/ the Button? Append rows to a Table or just gate an Entryset?

Hi Byron,

I would get back to you on the first answer

in the second question yeah i am just trying to gate an entryset....kind of not getting it...

thanks for the reply
Kamal

Hey - just run it through a Button ("Set Value" and "Get Value")... that should do the trick.

ah!

thanks............just didnt click........