[Skip to main content](#vessel-content) # Howto check consumed serial - consume date ## - **[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")** - [![mkaker's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4781-mkaker "View mkaker's Profile") Topic Author - [ Offline](/forum/user/4781-mkaker) Less More - Posts: 29 - Thank you received: 0 - - 12 years 8 months ago [\#142567](#142567) by [mkaker](/forum/user/4781-mkaker "View mkaker's Profile") *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#142567 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* was created by *[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")* Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 8 months ago [\#142637](#142637) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#142637 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi there, I am sorry but I don't understand what you are looking for. What do you mean by serial? What is a web request to you? A SQL query? Please be a bit more specific and we'll try to help you ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")** - [![mkaker's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4781-mkaker "View mkaker's Profile") Topic Author - [ Offline](/forum/user/4781-mkaker) Less More - Posts: 29 - Thank you received: 0 - - 12 years 8 months ago - 12 years 8 months ago [\#142793](#142793) by [mkaker](/forum/user/4781-mkaker "View mkaker's Profile") Replied by *[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#142793 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi Eliot, serial means an serial number, witch is used before. I am looking for an feature like "consume serial" witch gives me more informations about an used serial, for example to check through our code that an serial is in use, the date of the first use and the name of the user... these informations are useful when the customer changes the computer on witch our software is running or the installation is damaged and the user reinstall our software packet during an started recurring period... Thanks Last edit: 12 years 8 months ago by [mkaker](/forum/user/4781-mkaker "View mkaker's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 8 months ago [\#142821](#142821) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#142821 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi, The way to access by WebService to the serials is the "check" url, like explain in the consume tutorial page. [ www.hikashop.com/support/documentation/1...onsume-features.html](http://www.hikashop.com/support/documentation/138-consume-features.html) The url is in this form: Code: index.php?option=com_hikaserial&ctrl=serial&task=check&hikaserial[serial]=YOUR_SERIAL_DATA&hikaserial[format]=xml When you call the "check", HikaSerial will use the view "serial | check_XXX" (where XXX is html, json or xml). You can override the views (in HikaShop > Display > Views) like any other HikaSerial views. By overriding a "check" view, you can display the information you want about the serial. So you can display the consumption date or any other information you want. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")** - [![mkaker's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4781-mkaker "View mkaker's Profile") Topic Author - [ Offline](/forum/user/4781-mkaker) Less More - Posts: 29 - Thank you received: 0 - - 12 years 8 months ago [\#143090](#143090) by [mkaker](/forum/user/4781-mkaker "View mkaker's Profile") Replied by *[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#143090 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi, how can i find the List of information variables about the possible informations like consumpion date? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 8 months ago [\#143096](#143096) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#143096 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi, You can display all information (columns) in the table "hikaserial_serial" and all information you will see in the HikaSerial backend (when editing/showing a serial). It requires some PHP knowledge and development skills but you can use the existing code as base for your modification. In your case, I think that the best will be to display the date of the last even in the serial history. You can access it though " $this->serial->history " (it is an array with all serial history). The last element can be access using Code: $last_history = end($this->serial->history); echo hikaserial::getDate($last_history->history_created); Don't hesitate to use a " var_dump($this->serial); " in order to see the all content of the serial and see what you can display in your overridden view. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")** - [![mkaker's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4781-mkaker "View mkaker's Profile") Topic Author - [ Offline](/forum/user/4781-mkaker) Less More - Posts: 29 - Thank you received: 0 - - 12 years 8 months ago [\#143548](#143548) by [mkaker](/forum/user/4781-mkaker "View mkaker's Profile") Replied by *[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#143548 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi Jerome, i try to play with "check" and i get back from "serial_assign_date" Values like this "1385204963". What date format is that? how can i parse it? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 8 months ago [\#143552](#143552) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#143552 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi, The value is stored in the timestamp format. Like I wrote in my previous post, you can use hikaserial::getDate() to format it. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")** - [![mkaker's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4781-mkaker "View mkaker's Profile") Topic Author - [ Offline](/forum/user/4781-mkaker) Less More - Posts: 29 - Thank you received: 0 - - 12 years 8 months ago [\#143731](#143731) by [mkaker](/forum/user/4781-mkaker "View mkaker's Profile") Replied by *[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#143731 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi Jerome, i don't use php. i need the exact date format to parse the value with DateTime.TryparseExact in net. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 8 months ago [\#143834](#143834) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#143834 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* Hi, Like I said, it is a timestamp format. I don't know what I can say more... Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")** - [![mkaker's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4781-mkaker "View mkaker's Profile") Topic Author - [ Offline](/forum/user/4781-mkaker) Less More - Posts: 29 - Thank you received: 0 - - 12 years 8 months ago [\#143955](#143955) by [mkaker](/forum/user/4781-mkaker "View mkaker's Profile") Replied by *[mkaker](/forum/user/4781-mkaker "View mkaker's Profile")* on topic *[Howto check consumed serial - consume date](/forum/14-hikaserial/865605-howto-check-consumed-serial-consume-date#143955 "Hi, i am looking for an way / howto to check and get back an date of an past consume action of an specific serial number via web request. How is that possible? Thanks")* after some reading... it is an UNIX timestamp format All a UNIX timestamp represents is the number of seconds since January 1st, 1970 12:00:00 AM. So we have to create a new System.DateTime structure, set it to 1/1/1970 12:00:00 AM, and use the AddSeconds() methods to tack on the timestamp. Code: Function ConvertTimestamp(ByVal timestamp as Double) As DateTime Return New DateTime(1970, 1, 1, 0, 0, 0).AddSeconds(timestamp) End Function thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODY1NjA1LWhvd3RvLWNoZWNrLWNvbnN1bWVkLXNlcmlhbC1jb25zdW1lLWRhdGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.124 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)