Backendless Support
 
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

Leave a Comment

Comments (17)

photo
1

Hello,

please send your JSON file to support@backendless.com

photo
1

Yeap I sent to support@backendless.com

Please check there is an error. Thanks

photo
photo
1

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

photo
1

from 4.x.

photo
1

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

photo
1

I converted this from csv by Python Pandas.

photo
1

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.

photo
1

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

photo
1

I sent my csv file to support@backendless.com

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

photo
photo
1

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

  1. 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)

photo
1

Ok, it works! Thanks for the comment.

photo
1

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.

photo
1

This is my Result class data table from code generation.

  1. import UIKit

    class Result: NSObject {

    var objectId : String?

    var ownerId : String?

    var updated : Date?

    var created : Date?

    }

photo
1

Hi Ken,

Please provide your application ID.

photo
1

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.

photo
1

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

photo
1

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

(I mean notification was too fast)

photo