- Index
- » Support
- » Content Uploader
- » £ SIGNS NOT BEING SHOWN
£ SIGNS NOT BEING SHOWN
£ SIGNS NOT BEING SHOWN
Hi,
1/ using free version but going to upgrade but first 3 things if csv contans £ it does not load and stops the rest of the text.
example:
this cost £60 buy now
becomes
this cost
2/ Just making sure you can start and end articles from the csv file in pro?
3/ any development to upload from url with maybe cron?
thanks
- earthgate
-
-
- 7 Posts
Re: £ SIGNS NOT BEING SHOWN
Hello earthgate,
1.) That seems to be a bug in the free version. I have just tested in in the Pro versions (J1.5 and 1.7) and it works fine. I need to look into the free version and fix it.
2.) What do you mean by start and end articles? If you mean setting publish and unpublish dates, then yes, this can be set from the spreadsheet.
3.) This is currently not being worked on. We received several requests about this so there is a good chance that it will be implemented at some point but right now I can't make any promises.
Kind regards,
Pete
If you are satisfied with our products please write a review in the Joomla Extensions Directory!
- Pete
- Site admin
-
-
- 758 Posts
-
Re: £ SIGNS NOT BEING SHOWN
Hi,
Just brought pro version and it still stops on £ in csv so Ive had to change format to GBP also date format I have is in uk so months and days are mixed up in start and end dates.
Gaz
- earthgate
-
-
- 7 Posts
Re: £ SIGNS NOT BEING SHOWN
Hello Gaz,
Please use xls files instead of csv. This will solve the £ problem and also the date format issue. In csv files there is no way to tell which date format is used while this information is included in a xls file and the dates are set properly for either format.
Also, please update to the latest version released today since this will fix a problem with the timezone offset.
Kind regards,
Pete
If you are satisfied with our products please write a review in the Joomla Extensions Directory!
- Pete
- Site admin
-
-
- 758 Posts
-
Re: £ SIGNS NOT BEING SHOWN
Hi,
Thanks sorted out but now Start and end date not showing right.
Start date column is say F
End Date G
Put in to editor
{F}
{G}
comes out as:
START DATE
40954
END DATE
40968.5840162
Formatted cell to date format still no good but Publishing Start and End date are correct when F and G put in
Hope this makes sense 
- earthgate
-
-
- 7 Posts
Re: £ SIGNS NOT BEING SHOWN
Hi Gaz,
Excel stores dates internally as number of days since 1900 plus a fractional portion of a 24 hour day. In the date fields (created,publish, unpublish) we can expect to receive these values and convert them accordingly. In the content editor we can't tell if a value would have to be treated as date or plain value. So if you want to use the dates in the content editor you will have to save your spreadsheet in csv format so that Excel converts it's internal date values to a real date.
Kind regards,
Pete
If you are satisfied with our products please write a review in the Joomla Extensions Directory!
- Pete
- Site admin
-
-
- 758 Posts
-
Re: £ SIGNS NOT BEING SHOWN
Hi Gaz,
Excel stores dates internally as number of days since 1900 plus a fractional portion of a 24 hour day. In the date fields (created,publish, unpublish) we can expect to receive these values and convert them accordingly. In the content editor we can't tell if a value would have to be treated as date or plain value. So if you want to use the dates in the content editor you will have to save your spreadsheet in csv format so that Excel converts it's internal date values to a real date.
Kind regards,
Pete
Edit: Just figured I told you to use xls instead csv before. Ehm. Looks like we're having a catch-22 here. To be honest I don't have a perfect solution right now. What I would recommend is changing the date format in the xls file so dates and months are the other way around and also using GBP instead £. Then save the file as csv again and import it.
I'll have to think about how we can solve this issue best but it might take a bit until I have a new version ready to release. Please bear with me.
If you are satisfied with our products please write a review in the Joomla Extensions Directory!
- Pete
- Site admin
-
-
- 758 Posts
-
Re: £ SIGNS NOT BEING SHOWN
Hi,
Thanks for reply bit stuck in the middle
"What I would recommend is changing the date format in the xls file so dates and months are the other way around and also using GBP instead £. Then save the file as csv again and import it."
I figured out myself but thanks for info.
I'm not sure how the Update Articles works could I upload the xls file as one configuration with a column as ID then upload csv on another config just to import Dates into the page. If so I assume I put the same column ID into both configs so it up dates the articles??
Gaz
- earthgate
-
-
- 7 Posts
Re: £ SIGNS NOT BEING SHOWN
Hello Gaz,
Unfortunately updating articles won't help in this case. When updating articles you're basically replacing the complete content and not only parts of it.
Kind regards,
Pete
If you are satisfied with our products please write a review in the Joomla Extensions Directory!
- Pete
- Site admin
-
-
- 758 Posts
-
Re: £ SIGNS NOT BEING SHOWN
OK,
one other thing can I use 2 or more columns as title?
Thanks
- earthgate
-
-
- 7 Posts
Re: £ SIGNS NOT BEING SHOWN
The title can at the moment only pulled from one cell. You would have to join the cells in Excel, which is fairly easy. For example to join cell A and B with a space character in between put this formula in cell C:
=A1&" "&B1
Then use column C as title.
You will have to save the file in csv format to get rid of the formula.
Kind regards,
Pete
If you are satisfied with our products please write a review in the Joomla Extensions Directory!
- Pete
- Site admin
-
-
- 758 Posts
-
- Index
- » Support
- » Content Uploader
- » £ SIGNS NOT BEING SHOWN
