New Topic

Backendless Feedback Topic Question Data Service

KenChoi shared this question 8 months ago

Mark Piller

Admin

Sergey Kukurudzyak

Admin

Sergey Chupov

Agent

Oleg Vyalyh

Agent

Agent

Agent

Agent

Agent

Agent

Agent

Agent

Data Service 252 topics

Answered

import JSON file but data is strange

I am using Backendless 4.0, and try to import JSON file from local computer.

However, after I got msg from the server, the data table is strange.

I had 186 objects, but they show only 32 null objects.

Is there any issue of import Json file? Please check

The same question

Comments (17)

Sergey Kukurudzyak ● 8 months ago

Hello,

please send your JSON file to support@backendless.com

Reply URL

KenChoi ● 8 months ago

Yeap I sent to support@backendless.com

Please check there is an error. Thanks

URL

Sergey Kukurudzyak ● 8 months ago

Does this file was created from 3.x or 4.x backendless?

Reply URL

KenChoi ● 8 months ago

from 4.x.

URL

Sergey Kukurudzyak ● 8 months ago

But backendless creates only csv files, how do you get this file?

URL

KenChoi ● 8 months ago

I converted this from csv by Python Pandas.

URL

Sergey Kukurudzyak ● 8 months ago

We do not support such scenario. You can export to csv( change it) then import to another application, but only csv file. We support json files only for Parse export files.

URL

KenChoi ● 8 months ago

oh bcs console shows me error when I try as csv file. I just followed the document bcs it shows u support JSON or CSV either. And u should fix the documentation here.

https://backendless.com/docs/ios/doc.html#mgmt_import

URL

KenChoi ● 8 months ago

I sent my csv file to support@backendless.com

My csv is valid but I dunno why it is not working.

URL

Sergey Kukurudzyak ● 8 months ago

There is a number of issues with this file:

1. It starts from ',' but should be column name, I have added this num(INT) at the beginning

2. there are duplicate column names 'address' and 'name', so I have changed it to name2(STRING(36)) and address2(STRING(72))

so the first line should be

num(INT),created(DATETIME),affiliated(BOOLEAN),hits(INT),petSize(STRING(144)),images(TEXT),reviewAverage(DOUBLE),updated(DATETIME),advertising(BOOLEAN),objectId(STRING_ID),serviceCategory(STRING(72)),serviceablePet(STRING(500)),desc(STRING(500)),name(STRING(36)),isAdvertising(BOOLEAN),verified(BOOLEAN),note(STRING(144)),reviewCount(DOUBLE),website(STRING(144)),headerImageUrl(TEXT),priceInfo(STRING(288)),emailAddress(UNKNOWN),contact(STRING(36)),isAffiliated(BOOLEAN),operationTime(STRING(288)),subtitle(STRING(500)),ownerId(STRING(36)),isVerified(BOOLEAN),address(STRING(72)),location__GeoPoint__bcklsFK__ONE_TO_ONE,name2(STRING(36)),address2(STRING(72)),cafe_Urls(TEXT)

Reply URL

KenChoi ● 8 months ago

Ok, it works! Thanks for the comment.

URL

KenChoi ● 8 months ago

Hmm can u check my data table? Result table seems weird bcs it seems like everything was perfect but it show only partial data such as objectId, created, updated.

However, when I try to add a property in schema such as 'hits', they say it is already existing.

URL

KenChoi ● 8 months ago

This is my Result class data table from code generation.

import UIKit

class Result: NSObject {

var objectId : String?

var ownerId : String?

var updated : Date?

var created : Date?

}

Files: 스크린샷 2017...

URL

Sergey Chupov ● 7 months ago

Hi Ken,

Please provide your application ID.

URL

KenChoi ● 7 months ago

Now it looks fine.

However, there was quite big gap between the notification by mail and the time which the job has done. If u still need app ID, plz let me know.

URL

Sergey Chupov ● 7 months ago

Sometimes the notifications are delayed a bit, though it shouldn't be more than a few minutes.

URL

KenChoi ● 7 months ago

Yeap understood but it was quite weird at the first time haha

(I mean notification was too fast)

URL

import JSON file but data is strange

Comments (17)

Leave a Comment

Stay Connected