ニューコム List of Products and Services

"dbSheet EX" is software designed to make existing business systems built with Excel/Access more user-friendly. We offer three versions: "Excel Compatible," "Access Compatible," and "Web Compatible." Please feel free to contact us if you have any inquiries. 【Product Lineup】 ■ Excel Compatible ■ Access Compatible ■ Web Compatible *For more details, please refer to the related links or feel free to contact us.

The Excel-compatible version of "dbSheet EX" is software that enables centralized management of Excel data that has been constructed by field personnel in a database. Complex Excel files using functions and macros, as well as vast amounts of Excel workbooks, can be managed collectively in the database. By developing the system based on the customer's Excel, and being able to utilize Excel's features and usability as they are, it allows for an implementation that minimizes the burden on the field. 【Product Composition】 ■ Server Version ■ Development Version ■ Execution Version *For more details, please refer to the related links or feel free to contact us.

The Access-compatible version of "dbSheet EX" has already been developed and is operational. By incorporating an API into the existing Access system, it is possible to realize a web system that allows for centralized management of data across multiple locations. Data will be migrated from ACCDB to the server's database. We provide support tools for migrating the table structure and data from ACCDB to the server's database. Additionally, the application components of the existing Access system (forms, queries, reports, modules, etc.) can be reused almost as they are. The tables within the Access files on client PCs will be used as temporary (work) tables when interacting with the dbSheet server version. 【Features】 ■ File format is ACCDB ■ Login authentication via the server ■ Permission management by group is possible ■ Centralized management of user operation logs ■ Concurrency control during data updates *For more details, please refer to the related links or feel free to contact us.

By using the Web API provided by "dbSheet EX," it becomes easy to utilize the database under our product's management, including exclusive control, from smartphones and tablets. Additionally, by using the Web Portal (which utilizes the Web API), you can create web projects that operate in browsers compatible with our product with no-code/low-code. Please feel free to contact us if you have any inquiries. 【Main processes possible with the Web API (partial)】 ■ Token issuance ■ Log off ■ Data retrieval ■ Data update ■ Pessimistic lock release *For more details, please refer to the related links or feel free to contact us.

This document includes the development flow of the dbSheet EX11 Access-compatible version and the API reference. It explains standalone development using Access, as well as definition editing (DB definitions and Access path definitions) and development/debugging for web integration, with accompanying images. Additionally, it introduces the API group provided by the Access version DLL, making it a useful resource. Please download it and take a look. 【Contents (partial)】 ■ Standalone development using Access ■ Resource registration to the server ■ Migration of Access tables to the server DB ■ Definition editing (DB definitions and Access path definitions) ■ Development/debugging for web integration *For more details, please download the PDF or feel free to contact us.

"dbSheet×MES" is a production execution system that can flexibly accommodate the different business rules and procedures of each factory. While leveraging your current Excel-based operations, it achieves "efficiency, visibility, and error reduction" through systemization. It has high customizability, allowing for both "integration" and "application" into existing operations. You can operate it according to your scale, from a small start to full-scale implementation. [Features] ■ The main screen is just like the familiar Excel ■ Database updates in multiple locations (real-time sharing) ■ Customization suited to the site is possible ■ Progress can be checked via a web portal (tablet compatible) *For more details, please download the PDF or feel free to contact us.

"dbSheet" realizes the reduction of management forms in the sales field and can flexibly respond to different items and procedures on-site. While making the most of your current Excel-based project management and numerical management, it achieves "integration with SFA" through systemization. As you manage daily sales, SFA is naturally updated, leading to departmental collaboration, knowledge sharing, and improved project accuracy. [Features] ■ The on-site management screen is just like the familiar Excel ■ Customization suitable for the field is possible ■ Screens that management, managers, and on-site staff want to see can be designed ■ Real-time updates are possible through mutual integration with SFA *For more details, please download the PDF or feel free to contact us.

"dbSheet EX11" is a DX tool that utilizes Excel. It allows for input and updates via smartphones and tablets, enabling real-time information sharing and automatic aggregation of categorized data. Additionally, it has a proven track record of integration with Salesforce and SAP, allowing for linkage with core systems and enabling budget management. 【Features】 ■ Data is centrally managed in a database (SQL or Oracle) ■ Excel templates are also centrally managed on the server ■ Cloud usage of the server is possible ■ Development is done with low-code ■ Input is possible via web browsers using APIs ■ Seamless integration with other systems is possible *For more details, please download the PDF or feel free to contact us.

"dbSheet" is a system that allows seamless integration of Excel data with core systems and cloud systems in a secure environment. While functions and macros can be used, it is possible to build a database integration mechanism using the task types provided in this product with no-code or low-code solutions. By effectively utilizing the ability to freely design layouts in Excel, it is effective in consolidating the demands of rapidly changing field operations. 【Features】 ■ Layouts can be freely designed in Excel ■ Full utilization of Excel functions and formulas ■ Full utilization of macros *For more details, please download the PDF or feel free to contact us.

This document is a collection of user case studies for "dbSheet." It includes numerous examples such as the construction of subsystems for production management package systems (molding and pressing), the development of a new PSI system with Excel I/F, and the implementation of complex sake process traceability functions. This book serves as a useful reference when considering implementation, so please feel free to download it and read it. 【Contents (partial)】 ■ Excel Case Studies - Manufacturing Industry - Service Industry - Wholesale Industry - Construction Industry *For more details, please download the PDF or feel free to contact us.