Your feedback is highly appreciated! Let's make Vertabelo even better.

  1. Forum: Vertabelo
0
Answered

Share button is not active

Ganbayar Gansukh 9 years ago • updated by Jack Polkowski 9 years ago • 2
I have an academic plan, and the share button is not active. Does academic plans not able to share the model?

I do believe this button was active at some point time ago
Answer
Jack Polkowski 9 years ago
Hi!
Inactive "share" button means that you are not the owner of the model and you can't invite new persons to share it.
If you'd like to check your role in the model, go to the "Model details" panel. For that particular model, your role is set as an editor.

I noticed that in your case the model had been shared with you by the owner who then closed his/her account. So at the moment the model doesn't have its owner.

If you would like to share it with other persons, first you must clone it. Once again, go to the "Model details" panel, then click the button "Clone model" on the right. Since you are the owner of the cloned model, you can share it with other persons.

I hope I helped you.

Best regards and enjoy Vertabelo!
0
Under review

Error in view builder using LEAD function

Kent Graziano 9 years ago • updated by Jack Polkowski 9 years ago • 3
When I try to create a view using this SQL I get a parsing error:
SELECT
dbms_obfuscation_toolkit.md5(upper(trim(HC.COUNTRY_ABBRV))
|| '^'
|| TO_CHAR(SC.SAT_Load_DTS, 'YYYY-MM-DD')) AS DIM2_COUNTRY_KEY,
HC.COUNTRY_ABBRV,
SC.COUNTRY_NAME,
SC.SAT_Load_DTS AS EFFECTIVE_DTS,
LEAD(SC.SAT_Load_DTS) OVER (PARTITION BY SC.HUB_COUNTRY_KEY ORDER BY
SC.SAT_Load_DTS) AS EXPIRE_DTS,
SC.SAT_Rec_SRC AS REC_SRC
FROM
HUB_COUNTRY HC,
SAT_COUNTRIES SC
WHERE
HC.HUB_COUNTRY_KEY = SC.HUB_COUNTRY_KEY
0
Answered

request for switching my account to the academic one

Wenyuan Gao 9 years ago • updated by Jack Polkowski 9 years ago • 1
Answer
Jack Polkowski 9 years ago
Hi! Your account has been switched to the academic one. After logging in, you'll be requested to complete the registration form.
Best regards and enjoy Vertabelo!
0
Answered

Canvas size is huge. How do I reduce it?.

Ronald Dantonio 9 years ago • updated by anonymous 9 years ago • 2
How do I reduce the size of the canvas. I have accidentally made it huge. Everything else is now microscopic.
Answer
anonymous 9 years ago
You're right, there are two kinds of zoom: Vertabelo zoom and a browser zoom. Vertabelo zoom affects only a diagram, while a browser zoom affects the whole page.
In Chrome you can edit the browser zoom in the menu or using mouse wheel together with Ctrl pressed.
0
Answered

How can I change my trial plan to the academic one?

taavi podzuks 9 years ago • updated 9 years ago • 3
How can i change my plan to an academic one? Im a student in the estonian information technology college. I think is a similar problem as in http://support.vertabelo.com/topic/818837-i-cannot-change-my-plan-to-academic-but-i-am-a-tafe-student/ thread.

0
Started

sqlite generate er diagram from sql

Martin Chiu 9 years ago • updated 9 years ago • 3
Hello Vertabelo,
I am using your student account so you may not find my bug report a high priority. I will tell you though I tried to generate tables and a lot of things were not marked properly or tables were not linked properly. Mainly, the many to many tables. I have posted my SQL below so you may recreate the problem. It is fairly easy to reproduce. Anyway, the specific bugs you'll see are things like the table "genre" not being linked to anything and it also created a NULL primary key and marked other things as NULL that it shouldn't. The data base used is SQLite 3.7.x Well I hope this helps!


SQL USED

CREATE TABLE IF NOT EXISTS movie(id INTEGER PRIMARY KEY, title VARCHAR(150) NOT NULL, language CHAR(20), tagline VARCHAR(500), release_date DATE);

CREATE TABLE IF NOT EXISTS country(id INTEGER PRIMARY KEY, name CHAR(75) NOT NULL);

CREATE TABLE IF NOT EXISTS genre(id INTEGER PRIMARY KEY, type CHAR(50) NOT NULL);

CREATE TABLE IF NOT EXISTS theater(id INTEGER PRIMARY KEY, in_business INTEGER, website_url VARCHAR(100), mantinee_endtime DATETIME, phone_number CHAR(20) );

CREATE TABLE IF NOT EXISTS showtime(id INTEGER PRIMARY KEY, expires DATE NOT NULL, showtime DATETIME NOT NULL, movie_id INTEGER, showingtype_id INTEGER, theater_id INTEGER, FOREIGN KEY(movie_id) REFERENCES movie(id), FOREIGN KEY(theater_id) REFERENCES theater(id), FOREIGN KEY(showingtype_id) REFERENCES showingtype(id) );

CREATE TABLE IF NOT EXISTS showingtype(id INTEGER PRIMARY KEY, type CHAR(40) NOT NULL);

CREATE TABLE IF NOT EXISTS price(id INTEGER PRIMARY KEY, enddate DATE NOT NULL,cost DOUBLE NOT NULL, mantinee INTEGER NOT NULL, showingtype_id INTEGER, theater_id INTEGER, FOREIGN KEY(theater_id) REFERENCES theater(id), FOREIGN KEY(showingtype_id) REFERENCES showingtype(id));

CREATE TABLE IF NOT EXISTS state(id INTEGER PRIMARY KEY, state CHAR(2));

CREATE TABLE IF NOT EXISTS zipcode(id INTEGER PRIMARY KEY, zipcode CHAR(5));

CREATE TABLE IF NOT EXISTS location(id INTEGER PRIMARY KEY, street VARCHAR(100), state_id INTEGER, zipcode_id INTEGER, country_id INTEGER, FOREIGN KEY(state_id) REFERENCES state(id), FOREIGN KEY(zipcode_id) REFERENCES zipcode(id), FOREIGN KEY(country_id) REFERENCES country(id));

CREATE TABLE IF NOT EXISTS reviewer(id INTEGER PRIMARY KEY, first_name CHAR(50), last_name CHAR(50));

CREATE TABLE IF NOT EXISTS review(review VARCHAR(255) NOT NULL, title VARCHAR(150) NOT NULL, rating INTEGER, last_updated TIMESTAMP, date_posted DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, movie_id INTEGER, reviewer_id INTEGER, PRIMARY KEY(movie_id, reviewer_id), FOREIGN KEY(reviewer_id) REFERENCES reviewer(id), FOREIGN KEY(movie_id) REFERENCES movie(id));

CREATE TABLE IF NOT EXISTS cast_crew(id INTEGER PRIMARY KEY, first_name CHAR(50), last_name CHAR(50), date_death DATETIME, date_birth DATETIME, job_title VARCHAR(100));




CREATE TABLE IF NOT EXISTS movie_country(movie_id INTEGER, country_id INTEGER, PRIMARY KEY(movie_id, country_id) FOREIGN KEY(movie_id) REFERENCES movie(id),
FOREIGN KEY(country_id) REFERENCES country(id));

CREATE TABLE IF NOT EXISTS movie_genre(movie_id INTEGER, genre_id INTEGER, PRIMARY KEY(movie_id, genre_id) FOREIGN KEY(movie_id) REFERENCES movie(id), FOREIGN KEY(genre_id) REFERENCES genre(id));

CREATE TABLE IF NOT EXISTS movie_theater(movie_id INTEGER, theater_id INTEGER, PRIMARY KEY(movie_id, theater_id) FOREIGN KEY(movie_id) REFERENCES movie(id), FOREIGN KEY(theater_id) REFERENCES theater(id));

CREATE TABLE IF NOT EXISTS movie_cast_crew(movie_id INTEGER, cast_crew_id INTEGER, PRIMARY KEY(movie_id, cast_crew_id), FOREIGN KEY(movie_id) REFERENCES movie(id), FOREIGN KEY(cast_crew_id) REFERENCES cast_crew(id));




0
Answered

How to reopen closed account?

Sruthi Guvvala 9 years ago • updated by Jack Polkowski 9 years ago • 1
I just closed my account. How can i reopen it
0
Completed

"Open diagram" and "new diagram" to open in the current browser tab not in a new one.

Станислав Милев 9 years ago • updated by Jack Polkowski 9 years ago • 1
If i want a new tab, i would click the action with the scroll or right (mouse) click and "open in new tab".
0
Not a bug

Seems to be some issue with multi select functionality

Shantanu Kher 9 years ago • updated by anonymous 9 years ago • 2
If I select more than one objects while pressing / key, it selects all those objects for further processing. However it does not display all of them as SELECTED. Only last selected object appears as SELECTED. There seems to be some issue with multiple selection. Please advise.
0
Answered

I cannot see my model

Cloud Mason 9 years ago • updated by anonymous 9 years ago • 2
The graphical display of my model seems to have disappeared. I can click on the the tables and see all the columns and properties, but I cannot get the graph to display.


Customer support service by UserEcho