How do I use .Net Memory Mapped Files in Ranorex

[torrgil]

Hi All,

I'm trying to read from a CSV and write to a Memory Mapped File to be used later in subsequent script for lookup. Doable?

[Support Team]

Hello,

You can use the CSV Data Connector in Ranorex. Please read the section "CSV File" in our user guide in order to get more information how to create a CSV data connector.
Please let me know if I didn't understand your issue correctly.
Thank you!

Regards,
Bernhard

[torrgil]

Bernhard,

That is a partial answer.... I plan to use the CSV connector to read from the CSV file.

Please see MSDN link: msdn.microsoft.com/en-us/library/dd997372.aspx

Here's what I'm trying to do:
=========================================
1) Open EXCEL CSV file
2) Create Memory-Mapped file
3) Read 1st CSV row of data
4) Write data to Memory-Mapped file
5) Get next CSV row of data
6) End_o_file? Yes; Next Stmt / No; go to step 4
7) Close files & End

That's it

[krstcs]

Why are you using a memory-mapped file instead of just using the CSV? It looks like you are complicating matters for no real gain.

Maybe if you told us why you are needing the memory-mapped file we could help you figure out a way to do what you need. If you are just needing to manipulate test data at run-time, you could just use a simple-data-table, read the data into a manipulator method and put it in the SDT the way you need it. Then use the SDT as your data-source for the test cases.

Or, if you are needing real-time lookup, maybe you should just use a database and do real SQL queries on it at the time you need them. SQL Server has an express edition that is free and can be made portable.