When I try to import data on a table with a timestamp, I get failed for all rows :-(

[skamensky]

Is there an existing issue for this?

• [X] I have searched the existing issues

Version of Corteza

2022.9.x

Current Behavior

Upon import I get the following error:

DB Error:

2022-12-04 18:33:10.706 UTC [44734] ERROR:  invalid input syntax for type timestamp: ""
2022-12-04 18:33:10.706 UTC [44734] STATEMENT:  INSERT INTO "ImportMerchant" ("ImportDate", "LeadSource", "BusinessName", "Phone", "AlternatePhone", "CreditScore", "FirstName", "LastName", "BusinessAddress", "MailingAddress", "Fax", "Zip", "MonthlyRevenue", "FundedDate", "EIN", "ApprovalAmount", "RequestingAmount", "DateBusinessStarted", "Industry", "Email", "AlternativeEmail", "Merchant", "Notes", "Error", "ImportJob_calc", "NumMergeFields_calc", "ImportSucceeded_calc", "id", "rel_module", "deleted_by", "rel_namespace", "revision", "meta", "owned_by", "created_at", "created_by", "updated_at", "updated_by", "deleted_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39)

Client side view:

Expected Behavior

No response

Steps To Reproduce

1. Create a physical table
2. Add a date field
3. Import data with empty data in the date field
4. Get error

Environment and versions

No response

Anything else?

If you don't specify the field in the import, the data gets imported successfully

[skamensky]

Anyone see this?

[Fajfa]

Didn't see until now, raising this issue. If its not yet fixed it should be in 2022.9.7

Also for future issue reports, the accurate version helps greatly (You can always check it by clicking the ? dropdown in the topbar)

[tjerman]

I'll be looking into import/report related issues in the current sprint (this and next week). Will update you when I have something here

[skamensky]

@Fajfa ,

I'm running 2023.3.0-dev.1

Still getting this error

[github-actions[bot]]

Stale issue message

[github-actions[bot]]

Stale issue message