import arabic csv

[vaguemind]

Hello, I have a csv file which has two column , id & cityname and the cities in arabic ,, i created a list on fabrik with the same column and elements , i am trying to import the csv file but it return to empty on the column cityname ? what the reason ? can someone help please ?

 

[troester]

Is it working with Ascii citynames?
If yes, is your CSV file UTF8 encoded?

 

[vaguemind]

Is it working with Ascii citynames?
If yes, is your CSV file UTF8 encoded?

Ya working, and csv file is utf8 ya !


Sent from my Lenovo A6000 using Tapatalk

 

[troester]

And your database is UTF8, too?

 

[vaguemind]

It's default joomla db , if its not utf8 ,can i convert it to utf8? How?

Sent from my Lenovo A6000 using Tapatalk

 

[rob]

I think you would be able to check the table encoding and change it in something like phpmyadmin.

 

[vaguemind]

The table encoding itself I am sure its utf8 but for the all db I am not sure , does it affects ?

Sent from my Lenovo A6000 using Tapatalk

 

[troester]

It's working fine on my site, no matter if front-end language is set to German or Arabic.

 

[rob]

No its the table encoding that is what is important here

 

[vaguemind]

Thanks a lot for ur suggestions , the was the CSV very large , I split it to more files then imported successfully

Sent from my Lenovo A6000 using Tapatalk

 

[vaguemind]

Oh , now when i try to access the form which contain the dbjoin element to this cities list , it gives me this error : Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 29 bytes) ??

 

[troester]

the CSV very large

How many records do you have?
It seems your php memory limit is about 64MB, you can try to set it to 128.

But if you have an unconstrained dbjoin to a big list it's building a huge dropdown in the form.
You can try to set "render as" to autocomplete or add some Data-where

 

[vaguemind]

I have about 655500 records and I already made it as auto complete I will try to raise memory limit to 128

Sent from my Lenovo A6000 using Tapatalk

 

[rob]

were you still getting the out of memory error after having changed the element to an autocomplete?

 

[vaguemind]

I increased the memory limit to 128 and its rendered as auto complete already and worked well

Sent from my Lenovo A6000 using Tapatalk