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

0
Under review

API - Retrieve Drop SQL Script

Rishab Nayak 2 weeks ago updated by Rafał Strzaliński (Senior Engineer) 1 week ago 1

Is there any way for us to generate the Drop SQL Script using the API?

0
Answered

Does Vertabelo support purchase order/invoicing for yearly team subscription so payment can be handled via AP instead of credit card?

Matt Leisse 2 weeks ago updated by Łukasz Kubicki 2 weeks ago 1

I found a similar post from 7 years ago that says its not supported. I'm hoping things have changed more recently. 

Answer
Łukasz Kubicki 2 weeks ago

Hello Matt,

I'm happy to say that we support PO/invoicing for annual team plans. Please create a private ticket when you're ready, and we'll assist you to go through the process.

Kind regards,

Luke

0
Completed

The SQL script generated do not contain the table and column description.

Wavelet Account 7 years ago updated by David Kinmond 4 weeks ago 9
I have keyed in description for all tables and columns. When I generate the SQL script, the script does not contain description or comment. This is quite troublesome when I create the table in postgresql, I need to rekey-in all the description again.
0
Completed

XML export version 2.4 not supported by vertabelo_flask_sqlalchemy.py :-(

Andrea De Carolis 2 months ago updated by Rafał Strzaliński (Senior Engineer) 1 month ago 3

(AutoWan-mode) C:\Users\00301401\auto\vertabelo-flask-master>python vertabelo_flask_sqlalchemy.py -i AutoManager_2021-12-01_10_53.xml

Traceback (most recent call last):

File "C:\Users\00301401\auto\vertabelo-flask-master\vertabelo_flask_sqlalchemy.py", line 756, in

main(sys.argv[1:])

File "C:\Users\00301401\auto\vertabelo-flask-master\vertabelo_flask_sqlalchemy.py", line 753, in main

generate(inputfile,outputfile)

File "C:\Users\00301401\auto\vertabelo-flask-master\vertabelo_flask_sqlalchemy.py", line 723, in generate

g.process();

File "C:\Users\00301401\auto\vertabelo-flask-master\vertabelo_flask_sqlalchemy.py", line 701, in process

raise Exception("Not supported Vertabelo XML format version %s" % (version))

Exception: Not supported Vertabelo XML format version 2.4

0
Completed

How do you change the order of columns in the physical model ?

Claire Frankel 2 years ago updated by Lilly Liu 2 months ago 2

How do you change the order of columns in the physical model ?

claire.frankel@warbyparker.com

Answer
Adam Mościcki 2 years ago

Hello Claire,

Please:
1. Click on the dotted field placed before column name:

2. Then drag it:

3. And drop where you need the column:

Best regards,
Adam

0
Fixed

DDL Import Issue: unused tokens were found parsing columns and constraints for table

David Morrison 3 months ago updated by Grzegorz Małyska 2 months ago 7

First time loading DDL script to tool today - mostly it went well but there was one issue that might be a bug...

Error Message

The following unused tokens were found parsing columns and constraints for table: SCHEMA.TABLE.[ []

Scenario


This happened on 2 tables where
1. SQL key words were used as field names*, and

2. there were column names with spaces in them, and
3. all column names were enclosed in square brackets.


I loaded a dozen other tables as part of the same script absolutely fine!

Fix


All I did to fix it was change spaces to underscores in the column names with spaces - I didn't have to do anything for 1. or 3. 

The DDL itself is valid as it came out of the DB. 

0
Completed

Model properties vanishing

Adithya Nairy 2 months ago updated by Rafał Strzaliński (Senior Engineer) 2 months ago 2

Whenever i try to change the default data type from integer to varchar the model properties disappear

0
Planned

Better model migration for renaming

Kamil Bladoszewski 2 months ago updated by Artsiom Kashkou 2 months ago 1

In my project I had a table, let's call it table_1. I decided to rename it to table_2. Then I generated a model migration using Vertabelo and the resulting code dropped the table_1, and then created a new table_2. Fortunately, the table is currently empty, so that's not an issue. However, the next time I'm using the feature, I'd like Vertabelo to notice that I renamed the table, not deleted it.

0
Fixed

Model properties vanishing

Adithya Nairy 2 months ago updated by Grzegorz Małyska 2 months ago 4

Whenver change value from integer to another data type; model properties dissapear, very dissapointing bug can't use logical design feature.

0
Completed

The system does not allow me to add users to my account.

Gabriel Lobo-Blanco 2 months ago updated by Grzegorz Małyska 2 months ago 3