Method for assisting content entry in XML scanning mode
The content entry method is assisted by XML scanning, and XML files are generated using Excel templates and conversion tools, which solves the problem of low pure manual entry efficiency in CMS system, and realizes efficient and flexible content entry, suitable for small companies and users with less content .
Patent Information
- Application Number
- CN202410960431.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-17
- Publication Date
- 2024-11-12
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
In existing CMS systems, the efficiency of placing content into the database by purely manual means is very low, especially not suitable for small companies and users with little content.
XML scanning is used to assist in content entry methods, and automatically process content data by setting up Excel templates, conversion tools and configuration libraries, generating correct XML files, improving library entry efficiency and reducing workload.
It realizes a low-cost and convenient content entry method, improves the efficiency of content storage in CMS system, avoids CODE conflicts, and supports a variety of image types and templates to meet different business needs.
Smart Images

Figure CN118939836A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and in particular to a method for assisting content entry by using XML scanning. Background Art
[0002] Content Management System (CMS) is one of the core systems of the IPTV (Internet Protocol Television, referred to as IPTV) business platform. It can centrally manage content, perform business processes such as injection, editing, review, distribution, and recycling, and complete the life cycle management of content. The content types supported by CMS include on-demand, live, time-shift, playback, columns, products, etc. It generally includes system management, on-demand management, channel management, program list management, column management, product management, content injection management, content distribution management, transcoding management, review management and other functions. Through a friendly operation interface, it makes content management more convenient and ensures the security of broadcast content.
[0003] There are two main types of content transmission in traditional CMS systems. One is that if the user is a large company and needs to transmit a lot of content, they will choose to use a dedicated line to transmit the content to our CMS system. This method of opening a dedicated line is relatively expensive and is not suitable for small companies and users with less content. The other is a small content provider, who generally provides little content and is not so stable. Considering the cost issue, they will not spend money to open a dedicated line, but will send the media file to the resident editor through the public network FTP, network disk or express hard disk of the management party, and then the resident editor will transfer the content to the intranet through the content pre-processing FTP, and finally use tools or pure manual to store the content in the CMS system. If the content is stored in the CMS system in a purely manual way, the efficiency is very low. Therefore, it is necessary to design a simple, convenient, cheap, and XML scanning method for small users to assist in content entry. Summary of the invention
[0004] The purpose of the present invention is to provide a method for assisting content entry using XML scanning to solve the technical problem that the existing method of entering content into the CMS system using purely manual methods is very inefficient. A low-cost content entry method is designed to improve the entry efficiency. In order to achieve the above purpose, the technical solution adopted by the present invention is as follows:
[0005] A method for assisting content entry using XML scanning, which places pictures and TS video files in a content preprocessing FTP, sets an Excel template, transmits the set Excel template to a content user, and the user copies batch content into the Excel template. A conversion tool is set to generate an XML file from the data in Excel, and the XML file is scanned, parsed, and stored in a CMS system, and Excel tables are filled in batches, thereby reducing workload and complexity.
[0006] Furthermore, the CODE of the conversion tool is shared in real time. When a content provider uses a certain CODE of a certain element last time, the used CODE is stored in the tool configuration library. Next time when a different client wants to generate XML, it will continue to use the used CODE to avoid CODE conflicts.
[0007] Furthermore, the conversion tool checks whether the file path and file name entered by the operator are valid, generates a real and valid content XML file, improves the efficiency of warehousing, logs in to the content preprocessing FTP according to the configuration information of the content provider in the tool configuration library, and then checks one by one whether the path or quantity of the posters, stills, extended content pictures (optional), single-piece media, and drama media entered by the operator is correct and valid, and then generates XML. The generated XML can be guaranteed to be correct.
[0008] Furthermore, the conversion tool includes several template types, integrating the templates of TV series SD, TV series HD, series HD, single-film SD and single-film HD, increasing the types of XML templates to better meet business development needs.
[0009] Furthermore, the conversion tool sets up a configuration library. During configuration, if a content provider is allowed to use it, it is only necessary to add a line of data in the conversion tool configuration library. If its use permission is cancelled, it is only necessary to delete a line of configuration information from the configuration library.
[0010] Furthermore, the conversion tool is provided with error prompts. If the user encounters any improper operation during use, a corresponding error prompt message will be displayed, and the user can correct his or her operation according to the error prompt.
[0011] Furthermore, the conversion tool has high flexibility, and high-definition content supports image expansion. In addition to the two fixed image types of posters and stills, each content can also add up to four images according to business needs. The image type can be any image type supported by the CMS system, including but not limited to posters, stills, thumbnails, icons, title images, advertising images, sketches, carousel images, and smart images. Users can choose to meet every image required for content operation.
[0012] Furthermore, the conversion tool will log in to the content preprocessing FTP of the CP according to the information of the CP in the tool configuration library module, and then obtain the TS file list of the series in combination with the directory where the subset TS file is located filled in by the user in the Excel table. After obtaining the list, the list will be further processed. On the one hand, the validity of each TS file is verified, such as whether the file size is 0; on the other hand, the subset list will be sorted according to specific rules, and automatically matched to the first episode (period), second episode (period), third episode (period) of multiple series... For users, for a series, they only need to specify the directory where the subset of the series is located in the Excel table, and the tool can automatically find the entity file of the subset and match it, greatly reducing the workload and improving the efficiency of content entry.
[0013] Furthermore, the conversion tool can generate multiple episodes XML and single episode XML. The specific process of generating multiple episodes XML is as follows:
[0014] Point the cursor to the second row of the Several Episodes table, and then follow these steps
[0015] Step 1: Read the row and save the elements of each column in this row as an array, determine whether the CP identifier is empty, if it is empty, prompt an error message, if it is not empty, query the CP configuration information in the tool configuration library, and then determine whether the corresponding CP exists. If not, prompt an error message. If it exists, take out all the configuration information of the corresponding CP in the tool configuration library, determine whether the reporter column is 1107, if not, determine whether the drama title ends with 4K or HD, if not, go to step 2, if yes, go to step 3, if yes, log in to the content pre-processing FTP according to the FTP information of the corresponding CP in the conversion tool configuration library, and check whether the filled poster path is valid, if not, prompt an error message, if yes, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there is an extended picture, if yes, check whether the filled extended picture path is valid, If it is invalid, an error message is prompted. If it is valid, or if not, obtain the TS file list under the corresponding drama directory on FTP and sort them. Determine whether the number of TS is equal to the number of episodes filled in. If not, an error message is prompted. If it is, determine whether the number of subset introductions filled in is equal to the number of episodes filled in. If not, an error message is prompted. If they are equal, use the high-definition series template to allocate the CODE of Series and Picture. Generate the parent set XML based on the filled in and fixed information. Allocate the CODE of Program and Movie. Generate the subset XML based on the filled in and fixed information. Determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Series, Picture, Program, and Movie in the tool configuration library and end the processing.
[0016] Step 2: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, obtain the TS file list under the corresponding drama directory on FTP, sort it, and determine whether the number of TS is equal to the filled number of episodes, if not equal, prompt an error message, if equal, use the standard definition drama template, allocate the CODE of Series and Picture, generate the parent set XML according to the filled and fixed information, allocate the CODE of Program and Movie, generate the subset XML according to the filled and fixed information, determine whether it is the last line, if not, continue to the next line and return to step 1, if yes, save the CODE of Series, Picture, Program and Movie in the tool configuration library and end the processing;
[0017] Step 3: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there are extended pictures, if yes, check whether the filled extended picture path is valid, if invalid, prompt an error message, if valid, or if not, obtain the TS file list under the corresponding drama directory on FTP, and sort it, and determine whether the number of TS is equal to the filled number of episodes, if not equal, prompt an error message, if equal, use the high-definition TV series template, deploy Series, Picture CODE, generate parent set XML according to the filled and fixed information, deploy Program, Movie CODE, generate subset XML according to the filled and fixed information, determine whether it is the last line, if not, continue to the next line, return to step 1, if yes, save Series, Picture, Program, Movie CODE in the tool configuration library, and end the processing.
[0018] Furthermore, the specific process of generating a single XML is as follows:
[0019] The cursor points to the second row of several single-table tables, and then follows the steps below
[0020] Step 1: Read the row and store the elements of each column in the row as an array, determine whether the CP identifier is empty, if it is empty, prompt an error message, if it is not empty, query the CP configuration information in the tool configuration library, and then determine whether there is a corresponding CP, if not, prompt an error message, if it exists, retrieve all the configuration information of the corresponding CP from the tool configuration library, determine whether the film title ends with 4K or HD, if not, go to step 2, if yes, go to step 3;
[0021] Step 2: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, check whether the filled TS path is valid, if not, prompt an error message, if valid, use the standard single film template, deploy the CODE of Picture, Program, and Movie, generate a single-piece XML according to the filled and processed information, and determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Picture, Program, and Movie in the tool configuration library and end the processing;
[0022] Step 3: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there are extended pictures, if yes, check whether the filled extended picture path is valid, if invalid, prompt an error message, if valid, or if not, check whether the filled TS path is valid, if invalid, prompt an error message, if valid, use the high-definition single-piece template, deploy the CODE of Picture, Program, and Movie, generate a single-piece XML according to the filled and processed information, and determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Picture, Program, and Movie in the tool configuration library and end the processing.
[0023] The conversion tool is highly flexible, and high-definition content supports image expansion. In addition to the two fixed image types of posters and stills, each content can also add up to four images according to business needs. The image type can be any image type supported by the CMS system, including but not limited to posters, stills, thumbnails, icons, title images, advertising images, sketches, carousel images, and smart images. Users can choose to meet every image required for content operation.
[0024] The conversion tool consists of six modules
[0025] 1. Logic control module
[0026] The logic control module is responsible for the logic control of the entire process. Since the tool involves relatively complex logic, a module is needed to control the logic and determine the direction of the process. If a condition is met at a certain link, the process will proceed in that direction and the function of that module will be called.
[0027] 2. Tool configuration library management module
[0028] The tool configuration library module includes two modules: CP information configuration management module and content element encoding rule configuration management module.
[0029] 2.1CP information configuration management module: The CP information configuration module is used to configure the basic information of the CP, such as the CP name, CP logo, CP number, CP pre-processing FTP account, password, etc. If you want to authorize a CP to use the tool, you only need to add a line of CP information in the CP information configuration module. Similarly, if you want to cancel a CP's permission to use the tool, just delete the line of data.
[0030] 2.2 Content element encoding rule configuration management module: used to specify the encoding rules of each content element, that is, the composition rules of CODE. In the current CMS system, whether it is each element of the content or other elements outside the content, 32-bit pure digital encoding rules are used. Each element is composed of 32 bits. Specifically, the first 8 bits represent the code of the content provider, the second 8 bits represent the code of the element type, the third 8 bits represent the content creation date (YYYY-MM-DD), and the fourth 8 bits are the serial number. The four elements contained in the content are Series, Program, Movie, and Picture. In order to be highly compatible with CMS, the encoding rules of the tool also need to be consistent with the encoding rules of the CMS system. Therefore, the functions of the content element encoding rule configuration module mainly have two points. One is to enable the content element encoding to be generated according to the configured rules, and the other is to support multiple people to convert different CPs or the same CP content XML at the same time, and the element encoding can still guarantee uniqueness.
[0031] 3. Input file reading module
[0032] The function of this module is to read the Excel templates submitted by the user, including templates for single episodes and templates for multiple episodes. The module reads the fixed number of columns in Excel according to the set parameters and obtains the data of each cell in a row. In order to ensure the validity of the data as much as possible, the module will do some checks on the data, such as whether the required fields have been filled in, whether the data type filled in meets the requirements, whether the format of the filled in data meets the requirements, etc.; at the same time, in order to avoid errors in the tool during operation, the filled in data needs to be processed, such as special symbols "&", "<", ">", etc. that will report errors in XML files, or spaces before and after the fields, tab symbols, etc., which need to be processed before XML conversion. The module will automatically identify the total number of rows in the input file and will automatically loop to read and process each row of data.
[0033] 4. Content entity file inspection and processing module
[0034] The content entity file processing module includes two modules: a content entity file verification module and a subset processing module.
[0035] 4.1 Content Entity File Verification Module
[0036] Content entity files include two types: image files and TS files. This module will log in to the content preprocessing FTP of the CP based on the information of the CP in the tool configuration library module, and then check whether it exists based on the image and TS file names and directories filled in by the user in the Excel table. The condition for existence is that the file can be found and the file size is not 0. After verifying the entity file, the validity of the entity is ensured. When CMS parses the content XML file, it will not report an error due to failure to find a valid content entity file, which greatly improves the efficiency of content warehousing and reduces system resource consumption. This point was optimized in a recent version. Before the optimization, CMS often reported an error due to invalid entity files when parsing XML files.
[0037] 4.2 Subset Processing Module
[0038] The function of this module is to obtain the entity files (TS files) of subsets of multiple episodes. This module will log in to the content preprocessing FTP of the CP according to the information of the CP in the tool configuration library module, and then obtain the TS file list of the episode in combination with the directory where the subset TS files are located filled in by the user in the Excel table. After obtaining the list, the list will be further processed. On the one hand, the validity of each TS file is verified, such as whether the file size is 0; on the other hand, the subset list will be sorted according to specific rules, and automatically matched to the first episode (period), the second episode (period), the third episode (period) of multiple episodes... For users, a series only needs to specify the directory where the subset of the series is located in the Excel table, and the tool can automatically find the entity files of the subset and match them, greatly reducing the workload and improving the efficiency of content entry.
[0039] 5. XML conversion and output module
[0040] The function of this module is to convert the content information after comprehensive processing into an XML file. Under this module, there are currently six templates: TV Series SD, TV Series HD, Series HD, Single Film SD, Single Film HD, and Subset. The template management is relatively flexible. On the one hand, the template types can be expanded according to business needs; on the other hand, the elements of each template can also be added or deleted according to business needs. The XML conversion module is driven by the logic control module and selects the corresponding template to convert the content information into an XML file. When operating a batch of content XML file conversion, if it is a single film, it is output to a directory with a naming format of "single film_YYYY:MM:DD:HH24:MM:SS". The content XML file is named after the single film, followed by the extension ".xml". If there are multiple episodes, the parent episodes will be uniformly output to a directory with the naming format of "parent episode__YYYY:MM:DD:HH24:MM:SS", and the content XML file will be named after the multiple episodes with the extension ".xml"; and the child episodes will be stored in a directory named after the multiple episodes, and the content XML file will be named after the multiple episodes with the extension ".xml".
[0041] 6. Error information management module
[0042] The function of this module is to manage all foreseeable errors during the operation of the tool, including those caused by the tool operating environment and those caused by incorrect user operations. For example, common errors caused by the tool operating environment include network failure, unavailable tool configuration library, abnormal content preprocessing FTP status, etc. Common incorrect user operations include incorrect CP identification, inconsistent number of subsets filled in with the actual number of TS files, non-existence of image files, etc. For these foreseeable errors, make a good language description in advance. On the one hand, it is necessary to briefly explain the cause of the error, and on the other hand, it is necessary to indicate how to solve it. Through friendly error information management, resident content editors and company editors can easily use this tool to assist in content storage after simple training, and for tool developers, it also reduces the support for tool use.
[0043] The present invention has the following beneficial effects due to the adoption of the above technical solution:
[0044] The CODE of the present invention adopts a real-time sharing mode to avoid CODE conflicts, comprehensively checks whether the file path and file name filled in by the operator are valid, thereby generating an XML file with real and valid content, improving the storage efficiency, and is relatively convenient to configure. If a content provider is allowed to use it, only one line of data needs to be added to the configuration library. If the use authority is revoked, only one line of configuration information needs to be deleted from the configuration library. It supports flexible addition of any type of operation pictures in the "CCTV International Program Pricing and Release Interface Specification". BRIEF DESCRIPTION OF THE DRAWINGS
[0045] Figure 1 It is a flow chart of multi-episode XML generation of the present invention;
[0046] Figure 2 It is a flow chart of the single-chip XML generation of the present invention;
[0047] Figure 3 It is a module block diagram of the conversion tool of the present invention. DETAILED DESCRIPTION
[0048] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below with reference to the accompanying drawings and preferred embodiments. However, it should be noted that many details listed in the specification are only for the purpose of enabling the reader to have a thorough understanding of one or more aspects of the present invention, and these aspects of the present invention can be implemented even without these specific details.
[0049] A method for assisting content entry using XML scanning, which places pictures and TS video files in a content preprocessing FTP, sets an Excel template, transmits the set Excel template to a content user, and the user copies batch content into the Excel template. A conversion tool is set to generate an XML file from the data in Excel, and the XML file is scanned, parsed, and stored in a CMS system, and Excel tables are filled in batches, thereby reducing workload and complexity.
[0050] In the embodiment of the present invention, the CODE of the conversion tool is shared in real time. When a content provider uses a CODE of an element last time, the CODE used is stored in the tool configuration library. The next time a different client wants to generate XML, it will continue to use the CODE that has been used to avoid CODE conflicts. If the sharing method is not used, the CODE of each element is directly stored in the client after use. Therefore, in order to avoid CODE conflicts, it is stipulated that within one day, the content XML of a certain content provider is only generated on a certain client. For example, today, colleague A has generated the content XML of Feisha Media on his office computer. Then, today, the content XML of the content provider can only be generated on his computer; if another colleague B also generates the content XML of Feisha Media on his office computer, then the CODE in the content XML of Feisha Media generated by classmate B may conflict with the CODE generated by classmate A. After this optimization, multiple different clients are supported to generate content XML at any time.
[0051] In the embodiment of the present invention, the conversion tool checks whether the file path and file name filled in by the operator are valid, generates a real and valid content XML file, improves the efficiency of warehousing, logs in to the content preprocessing FTP according to the configuration information of the content provider in the tool configuration library, and then checks one by one whether the paths or quantities of posters, stills, extended content pictures (optional), single-chip media, and drama media filled in by the operator are correct and valid, and then generates XML. The generated XML can be guaranteed to be correct. Comprehensively check whether the file path and file name filled in by the operator are valid, thereby generating a real and valid content XML file, and improving the efficiency of warehousing. According to the configuration information of the content provider in the tool configuration library, log in to the content preprocessing FTP, and then check one by one whether the paths or quantities of posters, stills, extended content pictures (optional), single-chip media, and drama media filled in by the operator are correct and valid, and then generate XML. The generated XML can be guaranteed to be correct. If no inspection is performed, what they fill in will be generated according to what they fill in, and the generated XML may be wrong, and when it is put into the CMS system for parsing, it may report errors in pictures or TS media.
[0052] The conversion tool in the embodiment of the present invention includes several template types, integrating the templates of TV series SD, TV series HD, series HD, single-chip SD and single-chip HD, increasing the types of XML templates and better adapting to business development needs.
[0053] In the embodiment of the present invention, the conversion tool is provided with a configuration library. During configuration, if a content provider is allowed to use the content, only one line of data needs to be added to the conversion tool configuration library. If the use right is cancelled, only one line of configuration information needs to be deleted from the configuration library.
[0054] In the embodiment of the present invention, the conversion tool is provided with an error prompt. If the user encounters an error due to improper operation during use, a corresponding error prompt message will be displayed, and the user can correct his / her operation according to the error prompt.
[0055] In the embodiment of the present invention, the conversion tool has high flexibility, and high-definition content supports image expansion. In addition to the two fixed image types of posters and stills, each content can also add up to four images according to business needs. The image type can be any image type supported by the CMS system, including but not limited to posters, stills, thumbnails, icons, title images, advertising images, sketches, carousel images, and smart images. Users can choose to meet every image required for content operation.
[0056] In the embodiment of the present invention, the conversion tool will log in to the content preprocessing FTP of the CP according to the information of the CP in the tool configuration library module, and then obtain the TS file list of the series in combination with the directory where the subset TS file is located filled in by the user in the Excel table. After obtaining the list, the list will be further processed. On the one hand, the validity of each TS file is checked, such as whether the file size is 0; on the other hand, the subset list will be sorted according to specific rules, and automatically matched to the first episode (period), the second episode (period), the third episode (period) of multiple series... For users, a series only needs to specify the directory where the subset of the series is located in the Excel table, and the tool can automatically find the entity file of the subset and match it, which greatly reduces the workload and improves the efficiency of content entry.
[0057] like Figure 1 As shown, the conversion tool can generate multiple episodes XML and single episode XML. The specific process of generating multiple episodes XML is as follows:
[0058] Point the cursor to the second row of the Several Episodes table, and then follow these steps
[0059] Step 1: Read the row and save the elements of each column in this row as an array, determine whether the CP identifier is empty, if it is empty, prompt an error message, if it is not empty, query the CP configuration information in the tool configuration library, and then determine whether the corresponding CP exists. If not, prompt an error message. If it exists, take out all the configuration information of the corresponding CP in the tool configuration library, determine whether the reporter column is 1107, if not, determine whether the drama title ends with 4K or HD, if not, go to step 2, if yes, go to step 3, if yes, log in to the content pre-processing FTP according to the FTP information of the corresponding CP in the conversion tool configuration library, and check whether the filled poster path is valid, if not, prompt an error message, if yes, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there is an extended picture, if yes, check whether the filled extended picture path is valid, If it is invalid, an error message is prompted. If it is valid, or if not, obtain the TS file list under the corresponding drama directory on FTP and sort them. Determine whether the number of TS is equal to the number of episodes filled in. If not, an error message is prompted. If it is, determine whether the number of subset introductions filled in is equal to the number of episodes filled in. If not, an error message is prompted. If they are equal, use the high-definition series template to allocate the CODE of Series and Picture. Generate the parent set XML based on the filled in and fixed information. Allocate the CODE of Program and Movie. Generate the subset XML based on the filled in and fixed information. Determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Series, Picture, Program, and Movie in the tool configuration library and end the processing.
[0060] Step 2: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, obtain the TS file list under the corresponding drama directory on FTP, sort it, and determine whether the number of TS is equal to the filled number of episodes, if not equal, prompt an error message, if equal, use the standard definition drama template, allocate the CODE of Series and Picture, generate the parent set XML according to the filled and fixed information, allocate the CODE of Program and Movie, generate the subset XML according to the filled and fixed information, determine whether it is the last line, if not, continue to the next line and return to step 1, if yes, save the CODE of Series, Picture, Program and Movie in the tool configuration library and end the processing;
[0061] Step 3: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there are extended pictures, if yes, check whether the filled extended picture path is valid, if invalid, prompt an error message, if valid, or if not, obtain the TS file list under the corresponding drama directory on FTP, and sort it, and determine whether the number of TS is equal to the filled number of episodes, if not equal, prompt an error message, if equal, use the high-definition TV series template, deploy Series, Picture CODE, generate parent set XML according to the filled and fixed information, deploy Program, Movie CODE, generate subset XML according to the filled and fixed information, determine whether it is the last line, if not, continue to the next line, return to step 1, if yes, save Series, Picture, Program, Movie CODE in the tool configuration library, and end the processing.
[0062] like Figure 2 As shown, the specific process of single-piece XML generation is:
[0063] The cursor points to the second row of several single-table tables, and then follows the steps below
[0064] Step 1: Read the row and store the elements of each column in the row as an array, determine whether the CP identifier is empty, if it is empty, prompt an error message, if it is not empty, query the CP configuration information in the tool configuration library, and then determine whether there is a corresponding CP, if not, prompt an error message, if it exists, only all the configuration information of the corresponding CP can be retrieved from the tool configuration library, and determine whether the film title ends with 4K or HD, if not, go to step 2, if yes, go to step 3;
[0065] Step 2: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, check whether the filled TS path is valid, if not, prompt an error message, if valid, use the standard single film template, deploy the CODE of Picture, Program, and Movie, generate a single-piece XML according to the filled and processed information, and determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Picture, Program, and Movie in the tool configuration library and end the processing;
[0066] Step 3: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there are extended pictures, if yes, check whether the filled extended picture path is valid, if invalid, prompt an error message, if valid, or if not, check whether the filled TS path is valid, if invalid, prompt an error message, if valid, use the high-definition single-piece template, deploy the CODE of Picture, Program, and Movie, generate a single-piece XML according to the filled and processed information, and determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Picture, Program, and Movie in the tool configuration library and end the processing.
[0067] The conversion tool consists of six modules, such as Figure 3 shown.
[0068] 1. Logic control module
[0069] The logic control module is responsible for the logic control of the entire process. Since the tool involves relatively complex logic, a module is needed to control the logic and determine the direction of the process. If a condition is met at a certain link, the process will proceed in that direction and the function of that module will be called.
[0070] 2. Tool configuration library management module
[0071] The tool configuration library module includes two modules: CP information configuration management module and content element encoding rule configuration management module.
[0072] 2.1CP information configuration management module: The CP information configuration module is used to configure the basic information of the CP, such as the CP name, CP logo, CP number, CP pre-processing FTP account, password, etc. If you want to authorize a CP to use the tool, you only need to add a line of CP information in the CP information configuration module. Similarly, if you want to cancel a CP's permission to use the tool, just delete the line of data.
[0073] 2.2 Content element encoding rule configuration management module: used to specify the encoding rules of each content element, that is, the composition rules of CODE. In the current CMS system, whether it is each element of the content or other elements outside the content, 32-bit pure digital encoding rules are used. Each element is composed of 32 bits. Specifically, the first 8 bits represent the code of the content provider, the second 8 bits represent the code of the element type, the third 8 bits represent the content creation date (YYYY-MM-DD), and the fourth 8 bits are the serial number. The four elements contained in the content are Series, Program, Movie, and Picture. In order to be highly compatible with CMS, the encoding rules of the tool also need to be consistent with the encoding rules of the CMS system. Therefore, the functions of the content element encoding rule configuration module mainly have two points. One is to enable the content element encoding to be generated according to the configured rules, and the other is to support multiple people to convert different CPs or the same CP content XML at the same time, and the element encoding can still guarantee uniqueness.
[0074] 3. Input file reading module
[0075] The function of this module is to read the Excel templates submitted by the user, including templates for single episodes and templates for multiple episodes. The module reads the fixed number of columns in Excel according to the set parameters and obtains the data of each cell in a row. In order to ensure the validity of the data as much as possible, the module will do some checks on the data, such as whether the required fields have been filled in, whether the data type filled in meets the requirements, whether the format of the filled in data meets the requirements, etc.; at the same time, in order to avoid errors in the tool during operation, the filled in data needs to be processed, such as special symbols "&", "<", ">", etc. that will report errors in XML files, or spaces before and after the fields, tab symbols, etc., which need to be processed before XML conversion. The module will automatically identify the total number of rows in the input file and will automatically loop to read and process each row of data.
[0076] 4. Content entity file inspection and processing module
[0077] The content entity file processing module includes two modules: a content entity file verification module and a subset processing module.
[0078] 4.1 Content Entity File Verification Module
[0079] Content entity files include two types: image files and TS files. This module will log in to the content preprocessing FTP of the CP based on the information of the CP in the tool configuration library module, and then check whether it exists based on the image and TS file names and directories filled in by the user in the Excel table. The condition for existence is that the file can be found and the file size is not 0. After verifying the entity file, the validity of the entity is ensured. When CMS parses the content XML file, it will not report an error due to failure to find a valid content entity file, which greatly improves the efficiency of content warehousing and reduces system resource consumption. This point was optimized in a recent version. Before the optimization, CMS often reported an error due to invalid entity files when parsing XML files.
[0080] 4.2 Subset Processing Module
[0081] The function of this module is to obtain the entity files (TS files) of subsets of multiple episodes. This module will log in to the content preprocessing FTP of the CP according to the information of the CP in the tool configuration library module, and then obtain the TS file list of the episode in combination with the directory where the subset TS files are located filled in by the user in the Excel table. After obtaining the list, the list will be further processed. On the one hand, the validity of each TS file is verified, such as whether the file size is 0; on the other hand, the subset list will be sorted according to specific rules, and automatically matched to the first episode (period), the second episode (period), the third episode (period) of multiple episodes... For users, a series only needs to specify the directory where the subset of the series is located in the Excel table, and the tool can automatically find the entity files of the subset and match them, greatly reducing the workload and improving the efficiency of content entry.
[0082] 5. XML conversion and output module
[0083] The function of this module is to convert the content information after comprehensive processing into an XML file. Under this module, there are currently six templates: TV Series SD, TV Series HD, Series HD, Single Film SD, Single Film HD, and Subset. The template management is relatively flexible. On the one hand, the template types can be expanded according to business needs; on the other hand, the elements of each template can also be added or deleted according to business needs. The XML conversion module is driven by the logic control module and selects the corresponding template to convert the content information into an XML file. When operating a batch of content XML file conversion, if it is a single film, it is output to a directory with a naming format of "single film_YYYY:MM:DD:HH24:MM:SS". The content XML file is named after the single film, followed by the extension ".xml". If there are multiple episodes, the parent episodes will be uniformly output to a directory with the naming format of "parent episode__YYYY:MM:DD:HH24:MM:SS", and the content XML file will be named after the multiple episodes with the extension ".xml"; and the child episodes will be stored in a directory named after the multiple episodes, and the content XML file will be named after the multiple episodes with the extension ".xml".
[0084] 6. Error information management module
[0085] The function of this module is to manage all foreseeable errors during the operation of the tool, including those caused by the tool operating environment and those caused by incorrect user operations. For example, common errors caused by the tool operating environment include network failure, unavailable tool configuration library, abnormal content preprocessing FTP status, etc. Common incorrect user operations include incorrect CP identification, inconsistent number of subsets filled in with the actual number of TS files, non-existence of image files, etc. For these foreseeable errors, make a good language description in advance. On the one hand, it is necessary to briefly explain the cause of the error, and on the other hand, it is necessary to indicate how to solve it. Through friendly error information management, resident content editors and company editors can easily use this tool to assist in content storage after simple training, and for tool developers, it also reduces the support for tool use.
[0086] The above is only a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.
Claims
1. A method for assisting content entry using XML scanning, characterized in that: Place the images and TS video files in the content preprocessing FTP, set up an Excel template, pass the set Excel template to the content user, the user copies the batch content into the Excel template, set up a conversion tool to generate an XML file from the Excel data, scan and parse the XML file into the CMS system, and fill in the Excel table in batches, reducing the workload and complexity.
2. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The CODE of the conversion tool is shared in real time. When a content provider uses a certain CODE of a certain element last time, the used CODE will be stored in the tool configuration library. Next time a different client wants to generate XML, it will continue to use the used CODE to avoid CODE conflicts.
3. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The conversion tool checks whether the file path and file name entered by the operator are valid, generates a real and valid content XML file, improves the efficiency of warehousing, logs in to the content preprocessing FTP according to the configuration information of the content provider in the tool configuration library, and then checks one by one whether the path or quantity of the posters, stills, extended content images, single-piece media, and drama media entered by the operator is correct and valid, and then generates XML. The generated XML can be guaranteed to be correct.
4. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The conversion tool includes several template types, integrating the templates for TV series SD, TV series HD, series HD, single-film SD and single-film HD, increasing the types of XML templates to better meet business development needs.
5. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The conversion tool sets up a configuration library. During configuration, if you allow a content provider to use it, you only need to add a line of data in the conversion tool configuration library. If you cancel its usage rights, you only need to delete its configuration information from the configuration library.
6. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The conversion tool is set with error prompts. If the user encounters any improper operation during use, there will be corresponding error prompts. The user can correct his or her operation based on the error prompts.
7. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The conversion tool includes a logic control module, a tool configuration library management module, an input file reading module, a content entity file inspection and processing module, an XML conversion and output module, and an error information management module. The logic control module is connected to the tool configuration library management module, the input file reading module, the content entity file inspection and processing module, the XML conversion and output module, and the error information management module respectively. The logic control module is used to perform logical control on the entire process. The tool configuration library management module includes two modules: a CP information configuration management module and a content element encoding rule configuration management module. The CP information configuration module is used to configure the basic information of the CP. If you want to authorize a CP to use the tool, you only need to add a line of CP information in the CP information configuration module. If you want to cancel a CP's permission to use the tool, just delete the line of data. Yes, the content element encoding rule configuration management module is used to specify the encoding rules of each content element. The input file reading module is used to read the Excel templates submitted by the user, including single-episode templates and multi-episode templates. According to the set parameters, the fixed number of columns in Excel is read to obtain the data of each cell in a row. The content entity file inspection and processing module includes a content entity file inspection module and a subset processing module. The content entity files in the content entity file inspection module include two types: picture files and TS files. The content entity file inspection module logs in to the content preprocessing FTP of the CP according to the information of the CP in the tool configuration library module, and then combines the picture and TS file names and the directories filled in by the user in the Excel table to check whether they exist. The condition for existence is that the file can be found and the file size is not 0. After checking the entity file, the validity of the entity is ensured. The function of the subset processing module is to obtain the entity files of the subset of multiple episodes. The subset processing module logs in to the content preprocessing FTP of the CP according to the information of the CP in the tool configuration library module, and then obtains the TS file list of the episode in combination with the directory where the subset TS file is located filled in by the user in the Excel table. The XML conversion and output module converts the comprehensively processed content information into an XML file. The error information management module is used to manage all foreseeable errors during the operation of the tool.
8. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The conversion tool logs into the content preprocessing FTP of the CP according to the information of the CP in the tool configuration library module, and then obtains the TS file list of the series based on the directory of the subset TS file filled in by the user in the Excel table. After obtaining the list, the list will be further processed. On the one hand, the validity of each TS file is checked to see if the file size is 0. On the other hand, the subset list is sorted according to specific rules.
9. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The conversion tool can generate multiple episodes XML and single episode XML. The specific process of generating multiple episodes XML is as follows: Point the cursor to the second row of the Several Episodes table, and then follow these steps Step 1: Read the row and save the elements of each column in this row as an array, determine whether the CP identifier is empty, if it is empty, prompt an error message, if it is not empty, query the CP configuration information in the tool configuration library, and then determine whether the corresponding CP exists. If not, prompt an error message. If it exists, take out all the configuration information of the corresponding CP in the tool configuration library, determine whether the reporter column is 1107, if not, determine whether the drama title ends with 4K or HD, if not, go to step 2, if yes, go to step 3, if yes, log in to the content pre-processing FTP according to the FTP information of the corresponding CP in the conversion tool configuration library, and check whether the filled poster path is valid, if not, prompt an error message, if yes, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there is an extended picture, if yes, check whether the filled extended picture path is valid, If it is invalid, an error message is prompted. If it is valid, or if not, obtain the TS file list under the corresponding drama directory on FTP and sort them. Determine whether the number of TS is equal to the number of episodes filled in. If not, an error message is prompted. If it is, determine whether the number of subset introductions filled in is equal to the number of episodes filled in. If not, an error message is prompted. If they are equal, use the high-definition series template to allocate the CODE of Series and Picture. Generate the parent set XML based on the filled in and fixed information. Allocate the CODE of Program and Movie. Generate the subset XML based on the filled in and fixed information. Determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Series, Picture, Program, and Movie in the tool configuration library and end the processing. Step 2: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, obtain the TS file list under the corresponding drama directory on FTP, sort it, and determine whether the number of TS is equal to the filled number of episodes, if not equal, prompt an error message, if equal, use the standard definition drama template, allocate the CODE of Series and Picture, generate the parent set XML according to the filled and fixed information, allocate the CODE of Program and Movie, generate the subset XML according to the filled and fixed information, determine whether it is the last line, if not, continue to the next line and return to step 1, if yes, save the CODE of Series, Picture, Program and Movie in the tool configuration library and end the processing; Step 3: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there are extended pictures, if yes, check whether the filled extended picture path is valid, if invalid, prompt an error message, if valid, or if not, obtain the TS file list under the corresponding drama directory on FTP, and sort it, and determine whether the number of TS is equal to the filled number of episodes, if not equal, prompt an error message, if equal, use the high-definition TV series template, deploy Series, Picture CODE, generate parent set XML according to the filled and fixed information, deploy Program, Movie CODE, generate subset XML according to the filled and fixed information, determine whether it is the last line, if not, continue to the next line, return to step 1, if yes, save Series, Picture, Program, Movie CODE in the tool configuration library, and end the processing.
10. The method for assisting content entry using XML scanning according to claim 1, characterized in that: The specific process of single-piece XML generation is: The cursor points to the second row of several single-table tables, and then follows the steps below Step 1: Read the row and store the elements of each column in the row as an array, determine whether the CP identifier is empty, if it is empty, prompt an error message, if it is not empty, query the CP configuration information in the tool configuration library, and then determine whether there is a corresponding CP, if not, prompt an error message, if it exists, retrieve all the configuration information of the corresponding CP from the tool configuration library, determine whether the film title ends with 4K or HD, if not, go to step 2, if yes, go to step 3; Step 2: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, check whether the filled TS path is valid, if not, prompt an error message, if valid, use the standard single film template, deploy the CODE of Picture, Program, and Movie, generate a single-piece XML according to the filled and processed information, and determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Picture, Program, and Movie in the tool configuration library and end the processing; Step 3: According to the FTP information of the corresponding CP in the tool configuration library, log in to the corresponding content preprocessing FTP, check whether the filled poster path is valid, if not, prompt an error message, if valid, check whether the filled stills path is valid, if invalid, prompt an error message, if valid, check whether there are extended pictures, if yes, check whether the filled extended picture path is valid, if invalid, prompt an error message, if valid, or if not, check whether the filled TS path is valid, if invalid, prompt an error message, if valid, use the high-definition single-piece template, deploy the CODE of Picture, Program, and Movie, generate a single-piece XML according to the filled and processed information, and determine whether it is the last line. If not, continue to the next line and return to step 1. If yes, save the CODE of Picture, Program, and Movie in the tool configuration library and end the processing.
Citation Information
Patent Citations
Multimedia information sharing method
CN101895536A
Resource management device and resource management method
CN102222112A
Binding method of security marking and data objects based on extensive markup language (XML)
CN103139296A
Method and device for converting Excel format testing case into XML (extensive markup language) format
CN104156342A
Excel data importing method and device, electronic equipment and storage medium
CN115080651A
