Importing CSV logs me out of Joomla

[Lyquid]

Ok,

So, I really like the import feature in Fabrik, because I am wanting to use it to import price lists.

But in my testing using Joomla 1.5.8 if I upload a CVS file either from the back-end or the front-end I get logged out of Joomla admin/front-end account.

In the Joomla Admin I get to the next screen where it asks me what elements I want to create when importing the CSV. But when I hit Continue I am logged out.

[rob]

hi

Is this importing into an existing fabrik table, or creating a new table from a CSV file?
Do you have SEF url's turned on - and if so what settings do you have?

Cheers
Rob

[Lyquid]

Hello,

I may be incorrect with my understanding, but I believe I was trying to import a CSV file to a table that already existed but the table had no elements created.

After importing Fabrik was asking me which elements I wanted to create in the Table from the CSV.

I do have SEF url's turned on, as well as mod_rewrite and add suffix to url. Settings in my .htaccess are defaults that came with Joomla in regards to SEF.

[cheesegrits]

Where are you doing the import from? The "Import" button on the backend Tables tab, or the "Import CSV" link on the table template itself?

-- hugh

[Lyquid]

Import CSV I believe

[cheesegrits]

Try it from the Import button on the main Fabrik Tables page.

-- hugh

[Lyquid]

Importing directly from Components->Fabrik->Tables still logs me out of Joomla.

I tried it on a fresh 1.5.8 install with only Fabrik installed, using SVN code.

SEF is turned off on this site.

[cheesegrits]

I can't replicate this at all. I've imported various flavors of CSV file, all of them work fine.

Can you check that the url you are using to access to Tables page is the same as your Joomla 'live site'? In other words, if your live site is set to 'my.site', make sure you aren't accessing the Tables page as 'www.my.site'.

-- hugh

[Lyquid]

Yeah, the url is the same.

Hmm, perhaps it is my cvs file?

If you'd like I can send it to you, it is just a pricelist.

I will see if I can start from scratch on a test site and replicate it, then give you access to that site, if that would be helpful?

It's Turkey week here in the states so I wont get to that for a little while here.

[cheesegrits]

Sure, attach the CSV if you want. If it's confidential data, post it in the Fabrik Projects forum, so only you and us can see it.

And yes, a test site I can get at would be helpful.

And yeah, I'm going to be somewhat unavailable over Thanksgiving ... I'm a Brit, but been living in Huntsville, AL, for 16 years or so.

-- hugh

[Lyquid]

I went ahead and posted the csv file in the projects forum.

Thanks for taking a look.

[cheesegrits]

I can confirm that when I use that file, it logs me out.

Working on it.

-- hugh

[AniMo]

I had the same problem with a svn file i coudn't import without being logged out.
I opened it with notepad2, selected utf8 as encoding charset (after that some special characters needed to be rewritten) and saved the file;
And the import function was working again...

edit : importing logs me out when i have a name with special character on the first line of the csv file.
for exemple :
"id","expérience"
-> logs me out
"id","experience"
-> ok

[cheesegrits]

Can you post a test file for us to try with?

-- hugh

[AniMo]

Now i can't replicate anymore the "logout" effect :)
I updated my files from the svn today.

Importing still doesn't work on utf8 with special characters but it does with ANSI files...
here is the example i used to check what was working.

The file is utf8 with a special character on the first column name.