array(4 items)
   caller => 'TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery' (60 chars)
   ERROR => 'Unknown column '_LOCALIZED_UID' in 'field list'' (47 chars)
   lastBuiltQuery => 'SELECT uid,pid,content_uid,title,description,fal_image,link,textposition,sty
      leclass,tstamp,crdate,cruser_id,deleted,hidden,starttime,endtime,t3ver_oid,t
      3ver_id,t3ver_wsid,t3ver_label,t3ver_state,t3ver_stage,t3ver_count,t3ver_tst
      amp,t3ver_move_id,sorting,t3_origuid,sys_language_uid,l10n_parent,l10n_diffs
      ource,_LOCALIZED_UID FROM tx_wsflexslider_domain_model_image WHERE pid=-1 AN
      D t3ver_oid=42 AND t3ver_wsid=0 AND tx_wsflexslider_domain_model_image.delet
      ed=0 LIMIT 1' (468 chars)
   debug_backtrace => '{closure}#34 // TYPO3\CMS\Frontend\Http\Application->run#33 // TYPO3\CMS\Cor
      e\Core\Bootstrap->handleRequest#78 // TYPO3\CMS\Frontend\Http\RequestHandler
      ->handleRequest#311 // TYPO3\CMS\Frontend\Page\PageGenerator::renderContent#
      216 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#210 /
      / TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#805 
      // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render#859 // TYP
      O3\CMS\Frontend\ContentObject\TemplateContentObject->render#943 // TYPO3\CMS
      \Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#130 // TYPO3\CM
      S\Frontend\ContentObject\ContentObjectRenderer->render#859 // TYPO3\CMS\Fron
      tend\ContentObject\ContentContentObject->render#943 // TYPO3\CMS\Frontend\Co
      ntentObject\ContentObjectRenderer->cObjGetSingle#97 // TYPO3\CMS\Frontend\Co
      ntentObject\ContentObjectRenderer->cObjGetSingle#841 // TYPO3\CMS\Frontend\C
      ontentObject\ContentObjectRenderer->render#859 // TYPO3\CMS\Frontend\Content
      Object\CaseContentObject->render#943 // TYPO3\CMS\Frontend\ContentObject\Con
      tentObjectRenderer->cObjGetSingle#44 // TYPO3\CMS\Frontend\ContentObject\Con
      tentObjectRenderer->cObjGetSingle#841 // TYPO3\CMS\Frontend\ContentObject\Co
      ntentObjectRenderer->render#859 // TYPO3\CMS\Frontend\ContentObject\FluidTem
      plateContentObject->render#943 // TYPO3\CMS\Frontend\ContentObject\FluidTemp
      lateContentObject->renderFluidView#102 // TYPO3\CMS\Fluid\View\AbstractTempl
      ateView->render#300 // FluidCache_Standalone_layout_HeaderContentFooter_2a81
      d5eab37923b17f062118145e31540222992a->render#189 // TYPO3\CMS\Fluid\ViewHelp
      ers\RenderViewHelper::renderStatic#63 // TYPO3\CMS\Fluid\View\AbstractTempla
      teView->renderSection#121 // FluidCache_Standalone_template_file_List_60beed
      5e52fafc03df4ca0aaf63d338ce48a889c->section_040f06fd774092478d450774f5ba30c5
      da78acc8#230 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initiali
      zeArgumentsAndRender#47 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelpe
      r->callRenderMethod#249 ...' (4717 chars)
Data Collection for ERP Systems

Workflow-based Data Collection for ERP Systems like SAP

Does collaborative data collection for ERP systems like SAP sound familiar to you?
There are many reasons why data is not promptly submitted to ERP system like SAP but instead gathered step by step before finally being submitted.

 

Some examples:

  • The data can only be collected gradually but has to be complete before being entered into ERP systems
  • Different stakeholders are involved in collaborative data collection
  • The data has to be in a certain quality and requires approval before being submitted to ERP systems
  • Parts of the data are automatically computed in Excel® forms

Many companies rely on Excel as a tool for data collection due to its availability and its powerful form and formula features. The data collection processes around Excel forms, however, often lack proper coordination. Excel files are often exchanged through e-mails or cloud storage. Such data collection processes lack transparency and can cause problems like lost of data, data conflicts and communication overhead.

Spreadsheet Router dramatically simplifies the data collection process. It lets you collect data through a fully configurable workflow that uses your time-tested Excel forms.
You define your individual data collection workflow, stakeholders and their tasks – no coding necessary. Spreadsheet Router coordinates the data collection by routing the spreadsheet through your predefined workflow. Users can continue working with the familiar Excel interface and well-established Excel forms while benefit from task management and other features of a workflow management system at the same time.
As Spreadsheet Router takes care of data management, you no longer have to bother with synchronisation issues.

Workflow-based data collection can not only speed up data collection processes. It also gives you better control of data collection processes through monitoring and targeted workflow changes.

Faster data entry through automation

SAP Script Recording and simple Excel Macros can be used to automate data entry into your SAP user interface directly from Excel. In addition, CSV files exported from Spreadsheet Router enables you to use Robotic Process Automation (RPA) tools like UiPath in order to automate data entry into any kind of ERP system through its user interface. Automated data entry through the user interface spares you from changing existing ERP systems. Data entry is done using the login data of a real user, not of an anonymous system user – a plus for software audits.

Data Collection for ERP Systems

You’d like to optimize your data collection and entry process for ERP systems or any other information system? Let us know or get a free live online introduction to Spreadsheet Router to lern how it can help you to optimize your Excel® workflows.