Automated Data Import
Controlled Import of XML/CSV
With the Alistar XML Importer, you can import structured data from XML/CSV files in a controlled manner into Exact Globe. This powerful application was developed to integrate seamlessly into business processes. Using scheduled tasks, you can precisely determine when imports are performed for each XML/CSV file.
How Does the XML Importer Work?
The XML Importer is based on configurable settings that our consultants tailor to your organization's needs.
XML/CSV files in a specified folder are processed according to this configuration. Any errors that occur during the import process are logged and can be reported via email if desired.
Maximize Your Import Process
See how the XML Importer can simplify and improve your data import process. Contact us today to discuss all the possibilities and discover how our solutions can support your business.
Who are our customers?
We work for the following clients, among others. Here is a selection of organizations that rely on our expertise.
XML / CSV
What is XML?
XML, or Extensible Markup Language, is a standardized protocol used to describe data.
This versatile language makes it possible to present and store information in a structured way. In addition to the public Internet, XML is also a valuable tool within organizations.
Why Use XML?
Data structuring: XML (Extensible Markup Language) allows data to be organized into elements and attributes, creating a hierarchical structure that is easy to understand and manage.
Platform independence: XML files are platform-independent. This allows them to be used on different operating systems and in different applications without compatibility issues.
Readability: The use of clear tags and structure makes it easy for both technical and non-technical users to interpret and understand the file's content.
Data Description: XML is not only suitable for storing data, but also for describing data structures. It can be used to include metadata and documentation about the data.
What is CSV?
CSV stands for “Comma-Separated Values” and is a simple and widely used file format for storing and exchanging structured data.
In a CSV file, data is stored in text format, with each row of data separated by a comma and each column identified by a specific value.
Why Use CSV?
Simple structure: The text-based format makes it possible to store data in a clear and structured way, without the complexity of other file formats.
Wide compatibility: One of the main advantages is that almost any spreadsheet program, database, or text editor can open and process CSV files. This makes it easy to exchange data between different applications and systems.
Accessibility: CSV files are human-readable, which means they can be opened and understood using a simple text editor. Both technical and non-technical users can review the file's contents.
Suitable for large datasets: CSV files can contain large amounts of data without compromising performance or file size. This makes them ideal for storing and sharing datasets with many records.
Key Benefits of the XML Importer
With the XML Importer, you can automate the processing of XML and CSV files into Exact Globe. This eliminates the need to manually enter data and ensures that the import process is controlled and consistent.
Key benefits include:
- Automatic processing of XML and CSV files via scheduled tasks.
- Flexible setup tailored to your specific import needs.
- Support for various data flows, such as financial entries, sales orders, accounts receivable, and accounts payable.
- Error logging in log files for optimal control and traceability.
- Option to automatically receive error messages via email.
- Automatic archiving of processed files.
- Less manual work and a lower risk of data entry errors.
- Seamless integration with Exact Globe and existing business processes.
Curious to find out what this solution can do for your organization?
With the right solution, you’ll work more efficiently, save time, and get more value out of your business software. Our consultants are happy to help you find the best approach.
Request a demonstration or contact us for personalized advice.
Ron Vijg
How does this benefit your organization?
By automating import processes, you’ll spend less time on repetitive administrative tasks. Data is processed more quickly in Exact Globe, ensuring that employees always have access to up-to-date information.
In addition, the XML Importer helps minimize errors caused by manual data entry. Thanks to logging, error messages, and archiving, you maintain control over the entire import process and can identify and correct discrepancies more quickly.
The result is more efficient administration, more reliable data, and less time wasted on checks and corrective actions. This allows employees to focus on tasks that truly add value to the organization, while data flows are processed and verified in the background.
Import from various sources
Both XML and CSV files are versatile and user-friendly file formats, suitable for a variety of applications, ranging from data exchange between software applications to the storage of structured data.
The XML Importer lets you import all those XML/CSV files from various sources into your Exact Globe-administration. This saves time, prevents errors, and ensures that you get more out of your back office.
Alistar
Frequently Asked Questions
Are you curious about how this solution can enhance your Exact environment? Check out the answers below to frequently asked questions about the integration, features, and capabilities within Exact.
Can the Alistar XML Importer automatically retrieve XML files?
Yes. The XML Importer can automatically download XML files via an HTTP request. To do this, download profiles are configured to specify the source locations.
Can the XML Importer import multiple XML files at the same time?
No. The XML Importer actually processes files in batches, one after another. The next file isn't started until the previous import is fully complete.
Does the XML Importer support a fixed import order?
Yes. You can specify the order in which XML files are imported. This is useful, for example, when accounts receivable must be imported before sales orders are processed.
Do you have to use a separate folder for each XML type?
No. The XML Importer can automatically recognize which XML topic is being provided based on the contents of the XML file.
Can the XML Importer import XML files into multiple Exact Globe installations?
Yes. With import profiles, the same solution can process XML files for multiple Exact Globe installations, even if they are running on different SQL Server instances.
Are imported XML files saved automatically?
Yes. XML files that have been successfully imported are automatically moved to an archive folder (HistoryDir), so they remain available for review and reference.
Can the XML Importer automatically delete old archive files?
Yes. You can set the number of days files should be kept in the archive. After that, they are automatically deleted.
Do you receive a notification if an XML import fails?
Yes. If import errors occur, the XML Importer can automatically send an error report via email to one or more designated recipients.
Can the XML Importer save invalid XML files separately?
Yes. XML files that are not processed successfully are automatically moved to a separate error folder (ErrorDir) so they can be easily reviewed.
Does the XML Importer work without the Exact Globe XML modules?
No. Within Exact Globe, the correct XML server modules must be available in order to actually import XML files.
Want to learn more about Exact solutions in practice? Follow Alistar: Exactly on LinkedIn.