Comments
Sort by recent activity
Hi David,
Thanks for the post. It is not such a odd feature request.
If I understand correctly, to solve your requirement you want to be able to:
1) Define an expression to generate the data based on other columns in the row. Similar to how you define a computed column in SQL Server?
2) Have a set of rules governing how the data is created for each column on a row by row basis?
I have added your post into our system, and we will review it for our next release. If you could confirm my two points above that would really help us for planning the feature.
Thanks
Ben / comments
Hi David,
Thanks for the post. It is not such a odd feature request.
If I understand correctly, to solve your requirement you want to be able to:
1) Define an expression to generate the data based...
Hello,
Thanks for your post, I have added a note into our system to review for the next release.
Thankyou
Ben / comments
Hello,
Thanks for your post, I have added a note into our system to review for the next release.
Thankyou
Ben
Hi David,
At the moment, we control the order the data is generated in based on dependencies within the database.
For example, if there is a FK relationship, then we will generate that in the correct order. Similarly, if you use the SQL Statement generator or Manual FK Generator, this will be taken into account.
Out of interest, what is the scenario for altering the order of generation?
Thanks
Ben / comments
Hi David,
At the moment, we control the order the data is generated in based on dependencies within the database.
For example, if there is a FK relationship, then we will generate that in the corre...
Hi David,
I have been able to replicate this and I have added it into our bug tracking system. Thankyou for reporting this.
Ben / comments
Hi David,
I have been able to replicate this and I have added it into our bug tracking system. Thankyou for reporting this.
Ben
Hello,
Thank you very much for all of the feedback! It has been really useful.
As Lionel mentioned, 1.1 should be out sometime this week, as a result a number of the items you have mentioned has already been fixed. For the others, we will look at each issue again when we are planning our next release.
I just wanted to comment on the other issues.
4) On the table generation settings, you can define what should happen if the data is invalid - for example too large for the column. I recommend that you switch this to truncate data instead of skip row which will solve your problem without having to modify the regex.
6) Could you suggest any alternatives on how you would have liked to solve this scenario? Do you think a different type of generator is required for example?
12) You can configure this behaviour in the application options, under project setup however I'm not sure this is the best place for the setting.
13) I am unable to replicate this. Have you configure the generator with any SQL text or connection setting?
16) Could you please confirm which Set unique option you mean? Is is the "All key values unique" option?
Once again thankyou for the feedback.
Ben / comments
Hello,
Thank you very much for all of the feedback! It has been really useful.
As Lionel mentioned, 1.1 should be out sometime this week, as a result a number of the items you have mentioned has al...
Hello,
Sorry for the delay in getting back to you. Sadly, this is not currently supported, I have added a note to see if we can address this for later versions.
You might want to look at using SQL Statement to pull in the required data. However, you will have to run the generation twice, appending the data so we can use it as the source of the FK. Like I said, we do not currently support this, but you might have some luck with the SQL Statement generator.
Sorry I could be of more help. Hopefully we can address this at a later point.
Thank you for your feedback.
Ben / comments
Hello,
Sorry for the delay in getting back to you. Sadly, this is not currently supported, I have added a note to see if we can address this for later versions.
You might want to look at using SQL...
Hello,
Thank you for the detail post. We have had reports about the issue with self referencing tables and the data being the same.
However, if I understand your requirement correctly you want to have your data grouped. so you have multiple values the same.
One solution which I think will work for you is to modify the population method on the FK column. If you select Repeat key values between, you can specify the number of times the PK should appear in the FK column.
The data would then look something like this:
BreedId ParentBreedId Breed
1 1 Scent hounds
2 1 Guard dogs
3 1 Scent hounds
4 1 Cur dogs
I hope this makes sense and helps solve your problem, if it doesn't then please let me know.
Thanks
Ben / comments
Hello,
Thank you for the detail post. We have had reports about the issue with self referencing tables and the data being the same.
However, if I understand your requirement correctly you want to h...
Hello,
Thanks for the post, we are planning to incorporate this functionality into a later version which will allow you to specify the server, username, password and database name.
Are there any other properties you would like to configure on the command line or anything else we could do to support you in this area.
Thanks
Ben / comments
Hello,
Thanks for the post, we are planning to incorporate this functionality into a later version which will allow you to specify the server, username, password and database name.
Are there any ot...
Hello,
Thanks for the suggestion, it is much appreciated. A number of other users have also requested this feature and we are looking at the best way of solving this for future versions.
Once again thank you, if there are any other features would you like to see then please let us know.
Thank you
Ben / comments
Hello,
Thanks for the suggestion, it is much appreciated. A number of other users have also requested this feature and we are looking at the best way of solving this for future versions.
Once again...
Hi Aline,
In the mean time, that is a great solution to getting around this the problem.
Just so everyone is aware, the post generation script feature can be found on the project configuration dialog on the scripts tab.
Thanks
Ben / comments
Hi Aline,
In the mean time, that is a great solution to getting around this the problem.
Just so everyone is aware, the post generation script feature can be found on the project configuration dial...