# Manage Test Data **URL:** \ **Category:** Miscellaneous\ **Tags:** new-doc-request\ **Created:** [January 4, 2019, 9:52am UTC](https://forum.katalon.com/t/manage-test-data/16695 "2019-01-04T09:52:35Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![system](https://europe1.discourse-cdn.com/katalon/original/3X/d/5/d55596ab02785a255798e87ede769734747b30c4.svg) [@system](https://forum.katalon.com/u/system)\ **Post date:** [January 4, 2019, 9:52am UTC](https://forum.katalon.com/t/manage-test-data/16695/1 "2019-01-04T09:52:36Z")
* * * This is a companion discussion topic for the original entry at [https://docs.katalon.com/katalon-studio/docs/manage-test-data.html](https://docs.katalon.com/katalon-studio/docs/manage-test-data.html) ---
**Author:** ![nigel102938](https://avatars.discourse-cdn.com/v4/letter/n/6de8d8/32.png) [@nigel102938](https://forum.katalon.com/u/nigel102938)\ **Post date:** [January 11, 2019, 7:23pm UTC](https://forum.katalon.com/t/manage-test-data/16695/2 "2019-01-11T19:23:40Z")
The Test Data option looks great. But how do I use it to get data into my web form ? Most online database systems have an import option from CSV. The database I am using has this option and I want to Automate the process of getting the data out of my system manipulate it in Excel, and then put it back into the online database system. It would be great to use this product to do it. But the steps are disjointed from one another. IE you have the option to upload a CSV file to your database. But I need to use my import facility to get access to the CSV file. Anyhow, That is the issue, thanks for listening. Regards, Nigel. ---
**Author:** ![Aliasger\_Kiranawala](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Aliasger\_Kiranawala](https://forum.katalon.com/u/Aliasger_Kiranawala)\ **Post date:** [February 18, 2019, 1:50pm UTC](https://forum.katalon.com/t/manage-test-data/16695/3 "2019-02-18T13:50:01Z")
Team, unlike we add multiple rows and columns in internal test data, is it possible to store multiple database queries in Database test object? Something similar to hibernate? Please advise. ---
**Author:** ![Aliasger\_Kiranawala](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Aliasger\_Kiranawala](https://forum.katalon.com/u/Aliasger_Kiranawala)\ **Post date:** [February 19, 2019, 8:59am UTC](https://forum.katalon.com/t/manage-test-data/16695/4 "2019-02-19T08:59:24Z")
One more suggestion is to have test data in key value pair or store it as variables. Global variables are okay but sometimes we have content which is common for all environment profiles. We cannot replicate same variables for all profiles and there are chances to get missed. There should be something like common test data file which all test cases and keywords can access. ---
**Author:** ![cavoidc](https://avatars.discourse-cdn.com/v4/letter/c/f04885/32.png) [@cavoidc](https://forum.katalon.com/u/cavoidc)\ **Post date:** [February 25, 2019, 2:36am UTC](https://forum.katalon.com/t/manage-test-data/16695/5 "2019-02-25T02:36:14Z")
I want to use global database connection in custom keyword, so how can I call it ? ---
**Author:** ![Monica\_Standifer](https://avatars.discourse-cdn.com/v4/letter/m/a88e57/32.png) [@Monica\_Standifer](https://forum.katalon.com/u/Monica_Standifer)\ **Post date:** [May 22, 2019, 8:23pm UTC](https://forum.katalon.com/t/manage-test-data/16695/6 "2019-05-22T20:23:55Z")
I had the same need. One workaround I used, that works fine is I created a internal DB called SharedVariables that only has 2 columns ( like a key,value pair) first one is the variableName (key) and the second one is the value. I added in all the common items for all environments. Then in the profile for that environment, for those Global Variables that are in the SharedVariables db I reference the SharedVariable DB associated rows. In the Script View for the Profile, after I setup all the ones I had that were shared, I then copied that XML for those Shared Variables to other environment profiles that needed them. Downside is I just have to remember when I create new SharedVariable in the DB and reference in a profile, need to remember to copy it to any of the other Environment profiles as well so they will have it. However, if any of those SharedVariables change I only have to change it in one place the SharedVariable internal DB. Ideally, figure out all of your known variables that are the same across all environments ahead of time, setup the references in the default profile and then make a copy of that one for any other environment profiles. ---
**Author:** ![oswazteca](https://avatars.discourse-cdn.com/v4/letter/o/c37758/32.png) [@oswazteca](https://forum.katalon.com/u/oswazteca)\ **Post date:** [June 6, 2019, 10:36pm UTC](https://forum.katalon.com/t/manage-test-data/16695/7 "2019-06-06T22:36:12Z")
That last link isn’t working [https://docs.katalon.com/pages/viewpage.action?pageId=786668](https://docs.katalon.com/pages/viewpage.action?pageId=786668) I am seeing this [https://share.getcloudapp.com/nOuE2G45](https://share.getcloudapp.com/nOuE2G45) ---
**Author:** ![Aliasger\_Kiranawala](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Aliasger\_Kiranawala](https://forum.katalon.com/u/Aliasger_Kiranawala)\ **Post date:** [July 10, 2019, 1:01pm UTC](https://forum.katalon.com/t/manage-test-data/16695/8 "2019-07-10T13:01:38Z")
Thanks Monica, but this still does not solve the database query storage issue. ---
**Author:** ![rajani.gangadhara](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@rajani.gangadhara](https://forum.katalon.com/u/rajani.gangadhara)\ **Post date:** [August 13, 2019, 3:06am UTC](https://forum.katalon.com/t/manage-test-data/16695/9 "2019-08-13T03:06:35Z")
Can we execute a stored procedure in the query to fetch TestData, asking as when i try using stored procedure it is throwing unable to identify table error or it tells paramters not given though it was it was provided Attached is the screenshot, ![image](https://europe1.discourse-cdn.com/katalon/original/2X/9/93d40fba96619095c81050eee815e930ae675d0b.png) Where as the same query can run successfully with DBMS keywords plugin ---
**Author:** ![jjunior](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/jjunior/32/6633_2.png) [@jjunior](https://forum.katalon.com/u/jjunior)\ **Post date:** [September 13, 2019, 11:34am UTC](https://forum.katalon.com/t/manage-test-data/16695/10 "2019-09-13T11:34:21Z")
Create excel section, item 4, the link for: “data for Test Execution” is bronken (actual link [https://docs.katalon.com/x/7AAM](https://docs.katalon.com/x/7AAM)) ---
**Author:** ![arun.s](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@arun.s](https://forum.katalon.com/u/arun.s)\ **Post date:** [October 29, 2019, 10:58am UTC](https://forum.katalon.com/t/manage-test-data/16695/11 "2019-10-29T10:58:56Z")
Any update to run the Store Procedure by passing the parameters in Katalon? ---
**Author:** ![rajani.gangadhara](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@rajani.gangadhara](https://forum.katalon.com/u/rajani.gangadhara)\ **Post date:** [October 30, 2019, 3:24am UTC](https://forum.katalon.com/t/manage-test-data/16695/12 "2019-10-30T03:24:00Z")
Sorry arun.s. I cannot check that anymore as they moved this free feature into Enterprise edition which is paid , few weeks back. Yes its annoying that all features promised as free are moved to paid. I now use the DBMS keyword plugin for my function which works fine. ---
**Author:** ![Russ\_Thomas](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/russ_thomas/32/11884_2.png) [@Russ\_Thomas](https://forum.katalon.com/u/Russ_Thomas)\ **Post date:** [February 12, 2020, 7:48pm UTC](https://forum.katalon.com/t/manage-test-data/16695/13 "2020-02-12T19:48:33Z")
Split this topic on February 12, 2020, 7:48pm UTC A post was split to a new topic: [How to dynamically update (force read) Excel test data in a testing loop](https://forum.katalon.com/t/how-to-dynamically-update-force-read-excel-test-data-in-a-testing-loop/39793) ---
**Author:** ![sara.h](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@sara.h](https://forum.katalon.com/u/sara.h)\ **Post date:** [February 18, 2020, 7:53pm UTC](https://forum.katalon.com/t/manage-test-data/16695/14 "2020-02-18T19:53:05Z")
Hi, I am wondering what’s difference between internal data with excel data. What’s the pros and cons of internal data? I was trying to make decision which one should I use but I could not find much information about internal data except Katalon Doc. Most online tutorials, blogs or posts are using excel data instead. Could internal data fully replace excel data option? ---
**Author:** ![jaydeepkr.pal](https://avatars.discourse-cdn.com/v4/letter/j/7feea3/32.png) [@jaydeepkr.pal](https://forum.katalon.com/u/jaydeepkr.pal)\ **Post date:** [April 23, 2020, 10:39am UTC](https://forum.katalon.com/t/manage-test-data/16695/15 "2020-04-23T10:39:57Z")
Hello Folks, I wand to some read and write operation for that i want to place my excel file in katalon project itself instead of placing in my local system but i not able find the exact place. where should i store my excel file can any one tell please ---
**Author:** ![Swapna2](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/swapna2/32/16103_2.png) [@Swapna2](https://forum.katalon.com/u/Swapna2)\ **Post date:** [June 10, 2020, 3:20pm UTC](https://forum.katalon.com/t/manage-test-data/16695/16 "2020-06-10T15:20:45Z")
Hi, I used the Data file to verify my table headers which i stored in a xlsx file using relative path ![image](https://europe1.discourse-cdn.com/katalon/original/2X/8/8a44b5fd202e76228c0ada934d740d255966eca5.png) and in my script i used the below to the value def Exceldata = TestDataFactory.findTestData(“Well List/Well Status Columns”) ``` def HeaderExcel = Exceldata.getValue(1, i) ``` when i run on KSE that all run fine, when i run the same script using KRE from Devops, am getting an error as File is unsupported ![image](https://europe1.discourse-cdn.com/katalon/original/2X/8/8cfdc83ccd584e9e39937d22a83c3b7aea37c726.png) I made sure the xlsx the script referring to is in project data file folder can someone help me ---
**Author:** ![bhargavia](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bhargavia/32/16103_2.png) [@bhargavia](https://forum.katalon.com/u/bhargavia)\ **Post date:** [June 12, 2020, 3:42pm UTC](https://forum.katalon.com/t/manage-test-data/16695/17 "2020-06-12T15:42:33Z")
Hi,By using data-driven I want to pick the date from my CSV file while picking am getting invalid formate how can I handle it could you please help me. ---
**Author:** ![Swapna2](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/swapna2/32/16103_2.png) [@Swapna2](https://forum.katalon.com/u/Swapna2)\ **Post date:** [June 12, 2020, 4:14pm UTC](https://forum.katalon.com/t/manage-test-data/16695/18 "2020-06-12T16:14:20Z")
Hi, try using SimpleDateFormat(“dd-MMM-yyyy”).format(CSV\_Date) ---
**Author:** ![bhargavia](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bhargavia/32/16103_2.png) [@bhargavia](https://forum.katalon.com/u/bhargavia)\ **Post date:** [June 12, 2020, 4:19pm UTC](https://forum.katalon.com/t/manage-test-data/16695/19 "2020-06-12T16:19:32Z")
could you please declare clearly,i need to implement in the WebUi ---
**Author:** ![Swapna2](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/swapna2/32/16103_2.png) [@Swapna2](https://forum.katalon.com/u/Swapna2)\ **Post date:** [June 12, 2020, 4:33pm UTC](https://forum.katalon.com/t/manage-test-data/16695/20 "2020-06-12T16:33:09Z")
can you update the code how you picking the date from CSV and verifying for Format [Next page](https://forum.katalon.com/t/manage-test-data/16695.md?page=2)